20761A: Querying Data with Transact-SQL 2016 Training & Certification Course

The 20761A Querying Data with Transact-SQL 2016 Training & Certification course introduces students to the fundamentals and practices of the Transact-SQL language in detail. Transact-SQL is nowadays used by all Server-related disciplines namely, Database Administration, Database Development and Business Intelligence. The candidates will learn in this course the correct methods of selecting, sorting, and filtering data from different tables, among many other things.

Some of the major learnings of the candidates at the completion of this training and certification course can be listed as follows:

• Ability to describe the key capabilities and components of SQL Server
• Complete understanding of T-SQL, sets, and predicate logic
• Ability to write a single table and multi-table SELECT statement
• Ability to write DML statements
• Ability to write subqueries
• Knowledge of implementing views and table-valued functions
• Knowledge of creating and implementing stored procedures
• Know-how of adding programming constructs such as variables, conditions, and loops to T-SQL code