Querying Microsoft SQL Server 2012 Boot Camp

Description

This 5-day instructor led 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. Many of the exercises in this course are SQL Azure enabled. The Beta version of this course (10774AB) utilizes pre-release software in the virtual machine for the labs. Microsoft SQL Server 2012 Release Candidate 0 (RC0) is used in this course. Many of the exercises in this course are SQL Azure enabled. This course helps people prepare for exam 70-461.


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


Microsoft Course 20461C

Prerequisites

Before attending this course, students must have:
• Working knowledge of relational databases.
• Basic knowledge of the Microsoft Windows operating system and its core functionality.
Before attending this course, students should have:
• Basic understanding of virtualization technology (Classroom labs utilize virtual machines)
Contact Us

THE ACADEMY

1.800.482.3172

FTL: 954.351.7040

MIA: 305.648.2000


Request More Information

 

Current Promotions!

 

  _____________________________________

 

 

 

 

Email Newsletter icon, E-mail Newsletter icon, Email List icon, E-mail List icon Sign up for our Email Newsletter!

          

 

Top
  • Follow us on
  • Facebook Academy Page
  • Twitter Academy Page