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: https://www.microsoft.com/en-us/learning/exam-70-461.aspx

 

All our trainings are CERTIFICATION ORIETED & JOB ORIENTED. All the VERY BEST!

 

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