(Click Category to List Courses)

1 - ACC- Accredited Courses


MCP 501 - Querying Microsoft SQL Server 2012

 

Course Description

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. Many of the exercises in this course are SQL Azure enabled. 

Course Objectives

  • Write SELECT Queries
  • Query Multiple Tables
  • Use Built-In Functions
  • Use Subqueries
  • Execute Stored Procedures
  • Use Set Operators
  • Implement Error Handling
  • Implementing Transactions
  • Use Table Expressions
  • Sort and Filter Data
  • Use Window Ranking, Offset and Aggregate Functions
  • Query SQL Server Metadata
  • Program with T-SQL
  • Improve Query Performance

Who Should Attend?

  • Database Administrators
  • Database Developers
  • Business Intelligence professionals
  • The course will very likely be well attended by SQL power users who aren't necessarily database-focused or plan on taking the exam; namely, report writers, business analysts and client application developers.

Course Schedule

Day 1

  • Module 1: Introduction to Microsoft SQL Server 2012
  • Module 2: Introduction to Transact-SQL Querying
  • Module 3: Writing SELECT Queries

Day 2

  • Module 4: Querying Multiple Tables
  • Module 5: Sorting and Filtering Data
  • Module 6: Working with SQL Server Denali Data Types

Day 3

  • Module 7: Using Built-In Functions
  • Module 8: Grouping and Aggregating Data
  • Module 9: Using Subqueries
  • Module 10: Using Table Expressions
  • Module 11: Use Set Operators

Day 4

  • Module 12: Using Window Ranking, Offset and Aggregate Functions
  • Module 13: Pivoting and Grouping Sets
  • Module 14: Querying SQL Server Metadata
  • Module 15: Executing Stored Procedures

Day 5

  • Module 16: Programming with T-SQL
  • Module 17: Implementing Error Handling
  • Module 18: Implementing Transactions
  • Module 19: Improving Query Performance