Home > Course Catalog > Choose By Delivery Format > Self-Paced On-Demand > Microsoft 70-461: Querying SQL Server 2012 On-Demand
$595 – $1,295
Course Duration: 12 hours 22 minutes
Choose the On-Demand Package that best fits your learning and certification needs:
Basic Package |
Standard Package |
Premium Package |
|
|
|
$595 | $795 |
$1295 |
Plan Type | Delivery Format | Days | Status | Price | Enroll |
---|---|---|---|---|---|
Basic | Self-Paced On-Demand | 365 | Yearly Subscription | $595 | |
Standard | Self-Paced On-Demand | 365 | Yearly Subscription | $795 | |
Premium | Self-Paced On-Demand | 365 | Yearly Subscription | $1,295 |
This course provides students with the technical skills required to be prepared for the 70-461 Querying SQL Server 2012 exam. Students will acquire the skills to write basic Transact-SQL queries for Microsoft SQL Server 2012, which is the foundation for all SQL Server-related disciplines; namely Database Administration, Database Development and Business Intelligence.
Lesson 1: Getting Started with SQL Server 2012
Lesson 2: Working with T-SQL
Lesson 3: Writing SELECT Queries
Lesson 4: Working with SQL Data Types
Lesson 5: Sorting and Filtering Data
Lesson 6: Querying Data from Multiple Tables
Lesson 7: Modifying Data
Lesson 8: Working with SQL Server Built-in Functions
Lesson 9: Programming in T-SQL
Lesson 10: Implementing Stored Procedures
Lesson 11: Working with Subqueries and Table Expressions
Lesson 12: Working with Set Operators, Conditional Operators, and Window Functions
Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets
Lesson 14: Managing Error Handling and Transactions
Lesson 15: Querying SQL Server System
Lesson 16: Optimizing Query Performance