Querying Microsoft SQL Server 2012

DESTINATÁRIOS
This course is intended for Database Administrators, Database Developers, and Business Intelligence professionals.

PRÉ-REQUISITOS
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)

PROGRAMA

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
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying SQL Server Metadata
Module 16: Executing Stored Procedures
Module 17: Programming with T-SQL
Module 18: Implementing Error Handling
Module 19: Implementing Transactions
Module 20: Improving Query Performance