(Click Category to List Courses)
50 - ACC- Accredited Courses
MCP 501 - Querying Microsoft SQL Server 2012
Please contact us for fees
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 Details/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
