Training Microsoft

Training goals

code: MS-10774

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

All the labs for this course can be performed using the provided virtual machines. However, if you have a Microsoft Windows Azure account and the classroom virtual machines connect to the internet you may be able to connect to your Windows Azure server and database from the classroom. Many of the labs in this course are enabled for you to perform the lab while connected to your own Windows Azure database in the cloud.

Conspect Show list

  1. Module 1: Introduction to Microsoft SQL Server 2012
    • Introducing Microsoft SQL Server 2012
    • Getting Started with SQL Server Management Studio
  2. Module 2: Getting Started with SQL Azure
    • Overview of SQL Azure
    • Working with SQL Azure
  3. Module 3: Introduction to T-SQL Querying
    • Introducing T-SQL
    • Understanding Sets
    • Understanding Predicate Logic
    • Understanding the Logical Order of Operations in SELECT statements
  4. Module 4: Writing SELECT Queries
    • Writing Simple SELECT Statements
    • Eliminating Duplicates with DISTINCT
    • Using Column and Table Aliases
    • Writing Simple CASE Expressions
  5. Module 5: Querying Multiple Tables
    • Understanding Joins
    • Querying with Inner Joins
    • Querying with Outer Joins
    • Querying with Cross Joins and Self Joins
  6. Module 6: Sorting and Filtering Data
    • Sorting Data
    • Filtering Data with a WHERE Clause
    • Filtering with the TOP and OFFSET-FETCH Options
    • Working with Unknown and Missing Values
  7. Module 7: Working with SQL Server 2012 Data Types
    • Introducing SQL Server 2012 Data Types
    • Working with Character Data
    • Working with Date and Time Data
  8. Module 8: Using Built-In Functions
    • Writing Queries with Built-In Functions
    • Using Conversion Functions
    • Using Logical Functions
    • Using Functions to Work with NULL
  9. Module 9: Grouping and Aggregating Data
    • Using Aggregate Functions
    • Using the GROUP BY Clause
    • Filtering Groups with HAVING
  10. Module 10: Using Subqueries
    • Writing Self-Contained Subqueries
    • Writing Correlated Subqueries
    • Using the EXISTS Predicate with Subqueries
  11. Module 11: Using Table Expressions
    • Using Derived Tables
    • Using Common Table Expressions
    • Using Views
    • Using Inline Table-Valued Functions
  12. Module 12: Using Set Operators
    • Writing Queries with the UNION Operator
    • Using EXCEPT and INTERSECT
    • Using APPLY
  13. Module 13: Using Window Ranking, Offset and Aggregate Functions
    • Creating Windows with OVER
    • Exploring Window Functions
  14. Module 14: Pivoting and Grouping Sets
    • Writing Queries with PIVOT and UNPIVOT
    • Working with Grouping Sets
  15. Module 15: Querying SQL Server Metadata
    • Querying System Catalog Views and Functions
    • Executing System Stored Procedures
    • Querying Dynamic Management Objects
  16. Module 16: Executing Stored Procedures
    • Querying Data with Stored Procedures
    • Passing Parameters to Stored Procedures
    • Creating Simple Stored Procedures
    • Working with Dynamic SQL
  17. Module 17: Programming with T-SQL
    • T-SQL Programming Elements
    • Controlling Program Flow
  18. Module 18: Implementing Error Handling
    • Using TRY / CATCH Blocks
    • Working with Error Information
  19. Module 19: Implementing Transactions
    • Transactions and the Database Engine
    • Controlling Transactions
  20. Module 20: Improving Query Performance
    • Factors in Query Performance
    • Displaying Query Performance Data
Download conspect training as PDF

Additional information


Before attending this course, students must have:

  • Working knowledge of relational databases.
  • Basic knowledge of the Microsoft Windows operating system and its core functionality.

Before attending this course, students should have:

  • Basic understanding of virtualization technology (Classroom labs utilize virtual machines)
Difficulty level
Duration 5 days

The participants will obtain Microsoft certificates.


Microsoft Certified Trainer.

Training thematically related


Contact form

Please fill form below to obtain more info about this training.

* Fields marked with (*) are required !!!

Information on data processing by Compendium - Centrum Edukacyjne Spółka z o.o.

950 EUR


Discount codes

Discount code may refer to (training, producer, deadline). If you have a discount code, enter it in the appropriate field.
(green means entering the correct code | red means the code is incorrect)



Traditional training

Sessions organised at Compendium CE are usually held in our locations in Kraków and Warsaw, but also in venues designated by the client. The group participating in training meets at a specific place and specific time with a coach and actively participates in laboratory sessions.



Electronic materials

Electronic Materials: These are electronic training materials that are available to you based on your specific application: Skillpipe, eVantage, etc., or as PDF documents.

Ctab materials

Ctab materials: the price includes ctab tablet and electronic training materials or traditional training materials and supplies provided electronically according to manufacturer's specifications (in PDF or EPUB form). The materials provided are adapted for display on ctab tablets. For more information, check out the ctab website.



No deadlines for this training.

Suggest your own appointment