Lesson 1

This module discusses queries, cursors and views and SQL Server Database Implementation. MS SQL Server 2016: Queries, Cursors and Views is the second course in the SQL Server 2016 Database Implementation Certification Series. This series is designed to:

1. Provide the technical skills required to implement a database solution on Microsoft’s SQL Server 2016
2. Help you prepare for the Microsoft’s 70-029 Exam, Designing and Implementing Databases with Microsoft SQL Server 2016

After completing the course, you will be able to:

1. Write INSERT, DELETE, UPDATE, and SELECT statements that retrieve and modify data
2. Write queries that retrieve and modify data using joins and sub-queries
3. Write queries that summarize data
4. Create views of data
5. Navigate through your table with cursors

As you probably know, you can interact with SQL Server in two ways:

1. by issuing Transact-SQL commands, and
2. by interacting with its GUI, or Graphical User Interface.

This course uses SlideShows and Mouseovers to explain the code syntax used in Transact-SQL commands, and simulations for practicing different elements of the SQL Server GUI.

Queries, Cursors and Views is the second of three courses in the
SQL Server 2016 Database Implementation Certification Series
In the next lesson, the prerequisites for the course will be discussed.