This module discusses queries, cursors and views and SQL Server Database Implementation.
MS SQL Server 2008: Queries, Cursors and Views is the second course in the SQL Server 2008 Database Implementation Certification Series.
This series is designed to:
Provide the technical skills required to implement a database solution on Microsofts SQL Server 2008
Help you prepare for the Microsofts 70-029 Exam, Designing and Implementing Databases with Microsoft SQL Server 2008
After completing the course, you will be able to:
SELECT statements that retrieve and modify data
Write queries that retrieve and modify data using joins and sub-queries
Write queries that summarize data
Create views of data
Navigate through your table with cursors
As you probably know, you can interact with SQL Server in two ways:
by issuing Transact-SQL commands, and
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.