Microsoft SQL Server Certification Exam

Microsoft SQL Server T-SQL Certification Training & Guidance

About this course

This 3.5 Weeks instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.


Microsoft SQL Server T-SQL Certification : Course Details

Chapter 1: Introduction to Microsoft SQL Server 2014


Chapter 2: Introduction to T-SQL Querying


Chapter 3: Writing SELECT Queries


Chapter: Querying Multiple Tables


Chapter: Sorting and Filtering Data


Chapter 6: Working with SQL Server 2014 Data Types


Chapter 7: Using DML to Modify Data


Chapter 8: Using Built-In Functions


Chapter 9: Grouping and Aggregating Data


Chapter 10: Using Subqueries


Chapter 11: Using Table Expressions


Chapter 12: Using Set Operators


Chapter 13: Using Window Ranking, Offset, and Aggregate Functions


Chapter 14: Pivoting and Grouping Sets


Chapter 15: Querying data with Stored Procedures


Chapter 16: Programming with T-SQL


Chapter 17: Implementing Error Handling


Chapter 18: Implementing Transactions


Chapter 19: Appendix 1: Improving Query Performance


Chapter 20: Appendix 2: Querying SQL Server Metadata


For course details and registration, please visit: SQL Server & T-SQL Training Course

Microsoft Certification Exam - for SQL Server 2014. SQL School Training Institute provides In-DEPTH Certification Training & Guidance for Microsoft 70-461 Exam. 100% Guaranteed Results.

Source of Information for Certifications: Source:




Follow us on Facebook         Get Technology Updates on LinkedIn         Track Technical Events on Google+