70-461: Querying Microsoft SQL Server 2012

About this Course

This 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. This course helps people prepare for exam 70-461.
All the labs for this course can be performed using the provided virtual machines.  However, if you have a Microsoft Windows  Azure account you may be able to connect to your Windows Azure server and database.  Many of the labs in this course are enabled for you to perform the lab while connected to your own Windows Azure database in the cloud. To acquire a trial Windows Azure account click here.
Audience Profile

This course is intended for Database Administrators, Database Developers, and 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.
At Course Completion

After completing this course, students 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
Test your skills

The Cert kit has it all: In-depth e-learning content, exam quizzes, practice test, tips and information on the exam,and even online coaching from certified professionals that know how to pass the exam. This comprehensive product saves time and money by enabling you to access all your learning tools…with one login!

  • Customized e-Learning – focused on the specific certification video
videovideo
  • Exam Quizzes – an easy way to test your knowledge
video
  • Online Mentor – chat or mail with a technical specialist with the same certification
video
  • MeasureUp Exam Simulation – so you can test your readiness for the exam
video
  • Tips & Tricks – portal of notes, tips, articles, links to communities, etc
video