Course Code: sqlserver2012
Duration: 21 hours
Prerequisites:
  • An understanding of basic database concepts
Overview:

In this instructor-led, live training, participants will learn how to write basic Transact-SQL queries for Microsoft SQL Server 2012.

By the end of this training, participants will be able to:

  • Query a database
  • Use MS SQL Server's built-in functions
  • Execute stored procedures
  • Implement transactions
  • Program with T-SQL
  • Improve query performance

Audience

  • Database Administrators
  • Database Developers
  • Business Intelligence professionals

Format of the course
Part lecture, part discussion, exercises and heavy hands-on practice

Course Outline:

Module 1: Introduction to Microsoft SQL Server 2012

Module 2: Getting Started with SQL Azure

Module 3: Introduction to T-SQL Querying

Module 4: Writing SELECT Queries

Module 5: Querying Multiple Tables

Module 6: Sorting and Filtering Data

Module 7: Working with SQL Server 2012 Data Types

Module 8: Using Built-In Functions

Module 9: Grouping and Aggregating Data

Module 10: Using Subqueries