Microsoft SQL Server Querying with Transact-SQL

This two-day course teaches you how to use the Transact-SQL language to query a Microsoft SQL Server database. In addition, this course assists you in preparing for the MCSE & MCDA Exams.

* Exploring Transact-SQL
* Using the SELECT Statement
* Formatting the Results Set
* Changing Data Through Queries
* Summarizing Data
* Joining Tables
* Querying Multiple Tables
* Implementing Advanced Table Joins
* Implementing Subqueries
* Working with Full-text Indexes
* Implementing the Microsoft Search Service
* Querying Full-text Indexes
* Programming Transact-SQL
* Creating and Managing Views
* Implementing Stored Procedures, Triggers, and User-defined Functions
* Appendix A: The Movies Database Structure
* Table Design

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to:

Identify the features of Transact-SQL and use the Transact-SQL utilities to query a SQL server.
Retrieve data by using the SELECT statement.
Modify data by using the INSERT, UPDATE, and DELETE statements.
Summarize data by using the TOP, GROUP BY, COMPUTE, and COMPUTE BY clauses.
Query multiple tables through the use of joins.
Design subqueries.
Work with full-text indexes.
Describe the types of programming objects in Transact-SQL

Class targeted to:

Those needing to query databases.

Prerequisites:

Windows knowledge and some database knowledge helpful.