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
• 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

More

About this Course

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.

More

Length: 5 Days
Published: May 25, 2012
Language(s): English; Slovenian
Audience(s): IT Professionals
Level: 200
Technology: Microsoft SQL Server 2012
Type: Course
Delivery Method: Instructor-led (classroom)

Price: 1190 EUR + VAT
for NLT members FREE