Microsoft SQL Server 2012 - Bespoke

• An understanding of basic database concepts

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

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