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 Information

Course # WITAC 2513
Hours 54
Tuition $895
Text: Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 (Microsoft Press Training Kit), ISBN #978-0-7356-6605-4.

Registration

Click here to register for this course.

For directions on how to register click here.

More Information

To request more info about any of our courses please contact us 215-968-8132 or itacademy@bucks.edu.