Microsoft 70-461: Querying SQL Server
$99.00
A self-paced course on writing T-SQL queries in Microsoft SQL Server 2012, based on Microsoft exam 70-461. Includes 12 hours 22 minutes of training over 84 videos for developers, DBAs and analysts.
- Login details sent straight after payment
- Self-paced. Study on any device
- StemBoss Certificate of Completion
- 14-day refund promise
Secure checkout. Pay by card, Apple Pay or Google Pay.
Microsoft 70-461: Querying SQL Server is a self-paced course that teaches you to write T-SQL queries against Microsoft SQL Server 2012. It follows the Microsoft 70-461 exam and suits database staff, developers and analysts at beginner to intermediate level. You get 12 hours 22 minutes of training across 84 videos, plus 53 test questions.
What you will learn
- Write T-SQL queries and add constraints to tables
- Build SELECT statements and work with SQL data types
- Sort and filter results
- Query data from several tables with joins
- Insert, update and delete data
- Use built-in, logical and aggregate functions with GROUP BY
- Write T-SQL programs, dynamic SQL and stored procedures
- Use subqueries, table expressions, set operators and window functions
- Pivot data and use grouping sets
- Handle errors, manage transactions and read query plans and indexes
Course outline
- Getting Started with SQL Server 2012: course introduction
- Working with T-SQL: creating queries and constraints
- Writing SELECT Queries: the SELECT statement
- Working with SQL Data Types: choosing and using data types
- Sorting and Filtering Data: ordering and limiting results
- Querying Data from Multiple Tables: joining tables
- Modifying Data: inserting and changing data
- Working with SQL Server Built-in Functions: functions, PARSE, logical functions and GROUP BY
- Programming in T-SQL: variables, logic and batches
- Implementing Stored Procedures: stored procedures and dynamic SQL
- Working with Subqueries and Table Expressions: nested queries
- Set Operators, Conditional Operators, and Window Functions: plus user-defined and analytic functions
- Working with PIVOT, UNPIVOT, and Grouping Sets: reshaping data
- Managing Error Handling and Transactions: safe, reliable changes
- Querying SQL Server System: system databases
- Optimizing Query Performance: query plans and indexes
The course follows a natural path for learning SQL. You start with simple queries and data types, then sort, filter, join and change data. Middle lessons cover functions, T-SQL programming and stored procedures. Later lessons move into subqueries, window functions, pivoting, error handling and transactions, and finish with query plans and indexes for faster queries.
Who this course is for
- Database administrators who write and tune queries
- Developers who need stronger SQL skills
- Data analysts and data scientists who pull data from SQL Server
- Beginner and intermediate SQL Server users
Before you start
No formal prerequisites are listed. It helps to know what a table, row and column are. The course starts with the basics, so keen beginners can follow it.
The course is made up of 84 video lessons with a total running time of 12 hours 22 minutes. You can watch at your own pace, pause and replay any lesson, and come back to a topic whenever you need it. When you finish, use the 53 test questions to check what you have learned and spot any areas to review.
About the 70-461 exam
Microsoft exam 70-461, Querying Microsoft SQL Server 2012/2014, tested your ability to write and tune T-SQL queries, change data and use programming objects such as stored procedures. Microsoft retired it on 31 January 2021 along with the other MCSA, MCSD and MCSE exams. The T-SQL skills it covers are still used every day in SQL Server and Azure SQL.
Jobs this course supports
- Database administrator
- SQL developer
- Data analyst
- Business intelligence developer
- Data scientist
- IT consultant
| Skill level | Intermediate |
|---|---|
| Duration | 12 Hours 22 Minutes |
| Videos | 84 Course Videos |
| Questions | 53 Test Questions |
| Certification | Microsoft 70-461: Querying Microsoft SQL Server 2012/2014 (retired) |
| Exam code | 70-461 |
| Certification body | Microsoft |
| Best for | Database administrators, SQL developers, data analysts, BI developers |
| Topics covered | T-SQL queries, SELECT statements, data types, joins, functions, stored procedures, subqueries, window functions, error handling and transactions, query performance |
| Format | Online video lessons, self-paced |
| Language | English |
| Closed captions | Yes |
| Certificate | StemBoss Certificate of Completion |
What is inside this course
16 modules and 84 lessons. Here is the full outline.
Module 11 lessons
- Course Introduction
Module 210 lessons
- Creating Queries-Part 1
- Creating Queries-Part 2
- Creating Queries-Part 3
- Creating Queries-Part 4
- Creating Queries-Part 5
- Constraints-Part 1
- Constraints-Part 2
- Constraints-Part 3
- Constraints-Part 4
- Constraints-Part 5
Module 34 lessons
- Select Statement-Part 1
- Select Statement-Part 2
- Select Statement-Part 3
- Select Statement-Part 4
Module 410 lessons
- Data Types-Part 1
- Data Types-Part 2
- Data Types-Part 3
- Data Types-Part 4
- Data Types-Part 5
- Data Types-Part 6
- Data Types-Part 7
- Data Types-Part 8
- Data Types-Part 9
- Data Types-Part 10
Module 56 lessons
- Sorting Results-Part 1
- Sorting Results-Part 2
- Sorting Results-Part 3
- Sorting Results-Part 4
- Sorting Results-Part 5
- Sorting Results-Part 6
Module 66 lessons
- Tables Part 1
- Tables Part 2
- Tables Part 3
- Tables Part 4
- Tables Part 5
- Tables Part 6
Module 76 lessons
- Inserting Data-Part 1
- Inserting Data-Part 2
- Inserting Data-Part 3
- Inserting Data-Part 4
- Inserting Data-Part 5
- Inserting Data-Part 6
Module 84 lessons
- Functions
- Parse
- Logical Functions
- Group By
Module 96 lessons
- Programming-Part 1
- Programming-Part 2
- Programming-Part 3
- Programming-Part 4
- Programming-Part 5
- Programming-Part 6
Module 104 lessons
- Storage Procedures-Part 1
- Storage Procedures-Part 2
- Dynamic SQL-Part 1
- Dynamic SQL-Part 2
Module 114 lessons
- Sub-Queries And Table Expressions-Part 1
- Sub-Queries And Table Expressions-Part 2
- Sub-Queries And Table Expressions-Part 3
- Sub-Queries And Table Expressions-Part 4
Module 127 lessons
- Set Operators-Part 1
- Set Operators-Part 2
- Window Functions-Part 1
- Window Functions-Part 2
- User Defined Functions-Part 1
- User Defined Functions-Part 2
- Advanced Analytical Functions
Module 132 lessons
- Pivot
- Grouping Sets
Module 145 lessons
- Error Handling-Part 1
- Error Handling-Part 2
- Manage Transactions-Part 1
- Manage Transactions-Part 2
- Manage Transactions-Part 3
Module 154 lessons
- System Databases-Part 1
- System Databases-Part 2
- System Databases-Part 3
- System Databases-Part 4
Module 165 lessons
- Query Planning-Part 1
- Query Planning-Part 2
- Index-Part 1
- Index-Part 2
- Index-Part 3
Your learning path
Where Microsoft 70-461: Querying SQL Server fits. Build your skills one step at a time.
Frequently asked questions
Can I still take Microsoft exam 70-461?
No. Microsoft retired 70-461 on 31 January 2021. The course is still a strong way to learn T-SQL.
Are the skills useful with newer versions of SQL Server?
Yes. Core T-SQL, such as SELECT, joins, functions, stored procedures and transactions, works the same way in later versions.
Is this course right for beginners?
Yes, if you are keen. It suits beginner and intermediate users and starts with how to create simple queries.
Does it cover performance tuning?
Yes. The last module covers query plans and indexes so you can make slow queries faster.
What should I take next?
Microsoft 70-462 covers SQL Server administration, and Microsoft 70-463 covers building a data warehouse.
Do I get a certificate?
Yes. You get a StemBoss Certificate of Completion when you finish the course.
Can I get a refund?
Yes, within 14 days if you have completed less than 20% of the course. See our refund policy for details. Read the refund policy.
