- Course Syllabus Lesson 1: Getting Started with SQL Server 2012 Lesson
- Working with T-SQL Lesson
- Writing SELECT Queries Lesson
- Working with SQL Data Types Lesson
- Sorting and Filtering Data Lesson
- Querying Data from Multiple Tables
- Modifying Data
- Working with SQL Server Built-in Functions
- Programming in T-SQL Lesson
- Implementing Stored Procedures Lesson
- Working with Subqueries and Table Expressions
- Working with Set Operators, Conditional Operators, and Window Functions
- Working with PIVOT, UNPIVOT, and Grouping Sets
- Managing Error Handling and Transactions
- Querying SQL Server System
- Optimizing Query Performance
Overview
Introducing Microsoft 70-461: Querying SQL Server, the comprehensive certification program designed to equip individuals with the skills and knowledge to query and retrieve data from SQL Server databases effectively. If you’re interested in becoming a proficient SQL developer or looking to enhance your database querying and manipulation skills, this training program is essential for your career growth.
Microsoft 70-461 focuses on querying SQL Server databases’ core concepts and tasks. With this certification, you’ll gain expertise in writing SQL queries, retrieving and manipulating data, creating and modifying database objects, and implementing stored procedures and functions. You’ll also learn about optimizing query performance, implementing error handling, and working with XML and JSON data.
