This course is one of three courses required to pass the MCSA: SQL Server exam.
... READ MORE
Try searching for another option from our course list.
Or call us at (623) 570-4309 to request a class near you!
This course is one of three courses required to pass the MCSA: SQL Server exam.
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-relateddisciplines; namely, Database Administration, Database Development and Business Intelligence. This coursehelps people prepare for exam 70-461.
All the labs for this course can be performed using the provided virtual machines. However, if you have aMicrosoft Windows Azure account and the classroom virtual machines connect to the internet you may beable to connect to your Windows Azure server and database from the classroom. Many of the labs in thiscourse are enabled for you to perform the lab while connected to your own Windows Azure database in thecloud. Your instructor should be able to provide a current list of Windows Azure enabled labs.
After completing this course, students will be able to:
Before attending this course, students must have:
Before attending this course, students should have:
Module 1: Introduction to Microsoft SQL Server 2012
Module 2: Getting Started with SQL Azure
Module 3: Introduction to T-SQL Querying
Module 4: Writing SELECT Queries
Module 5: Querying Multiple Tables
Module 6: Sorting and Filtering Data
Module 7: Working with SQL Server 2012 Data Types
Module 8: Using Built-In Functions
Module 9: Grouping and Aggregating Data
Module 10: Using Subqueries
Module 11: Using Table Expressions
Module 12: Using Set Operators
Module 13: Using Window Ranking, Offset and Aggregate Functions
Module 14: Pivoting and Grouping Sets
Module 15: Querying SQL Server Metadata
Module 16: Executing Stored Procedures
Module 17: Programming with T-SQL
Module 18: Implementing Error Handling
Module 19: Implementing Transactions
Module 20: Improving Query Performance
Demonstrate your essential skills and breakthrough insights in developing and maintaining the next wave of mission-critical environments.
Earning an MCSA: SQL Server 2012 certification will qualify you for a position as a database developer or database analyst.
Step | Exam title | Optional training | Required exam |
---|---|---|---|
1 | 10774 | 461 | |
2 | 10775 | 462 | |
3 | Implementing a Data Warehouse with Microsoft SQL Server 2012 | 10777 | 463 |
Training and Certification Courses and Bootcamps in VMware | Microsoft Technical | Microsoft Developer | Microsoft Sharepoint | Security | Cisco | Citrix