Querying Microsoft SQL Server 2012
This instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. The main purpose of the course is to prepare students for the exam "70-461: Writing Queries Using Microsoft® SQL Server® 2012 Transact-SQL." This exam will be the underlying exam for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. As such, the primary target audience for this course is: Database Administrators, Database Developers and BI professionals.
After completing this course, you will be able to:
- Write SELECT queries
- Query multiple tables
- Use built-in functions
- Use subqueries
- Execute stored procedures
- Use set operators
- Implement error handling
- Implement 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
Course # WITAC 2513
Text: Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 (Microsoft Press Training Kit), ISBN #978-0-7356-6605-4.
Click here to register for this course.
For directions on how to register click here.
To request more info about any of our courses please contact us 215-968-8132 or firstname.lastname@example.org.