Self-paced

Microsoft 70-461: Querying SQL Server

In this Microsoft 70-461: Querying SQL Server course you will learn the technical skills required 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.

Start learning

$129

this course includes

12+ Hrs Training Hours

84 On-demand Videos

Closed Captions

16 Topics

53 Prep Questions

Certificate of Completion

 

COURSE CONTENT

01

Getting Started with SQL Server 2012

02

Working with T-SQL

03

Writing SELECT Queries

04

Working with SQL Data Types

05

Sorting and Filtering Data

06

Querying Data from Multiple Tables

07

Modifying Data

08

Working with SQL Server Built-in Functions

09

Programming in T-SQL

10

Implementing Stored Procedures

11

Working with Subqueries and Table Expressions

12

Working with Set Operators, Conditional Operators, and Window Functions

13

Working with PIVOT, UNPIVOT, and Grouping Sets

14

Managing Error Handling and Transactions

15

Querying SQL Server System

16

Optimizing Query Performance

Course Description for Microsoft 70-461: Querying SQL Server 2012

The Microsoft 70-461: Querying SQL Server 2012 course is designed to provide students with a comprehensive understanding of SQL Server 2012. This course covers essential concepts such as T-SQL, data types, and SQL server functions. It also delves into complex topics like querying data from multiple tables, implementing stored procedures, and managing error handling and transactions.

Students will gain practical experience through various modules focused on real-world applications. By the end of the course, learners will be proficient in writing SELECT queries, sorting and filtering data, and optimizing query performance, preparing them for the Microsoft 70-461 certification exam.

 

What You Will Learn in Microsoft 70-461: Querying SQL Server 2012

 

In this course, you will develop key skills necessary for effective SQL Server 2012 management. The following are the core learning outcomes:

 

  • Understand the fundamentals of T-SQL and how to create complex queries.
  • Work with various SQL data types and their applications.
  • Sort and filter data efficiently using SQL commands.
  • Query data from multiple tables and understand table relationships.
  • Implement stored procedures and use built-in SQL Server functions.
  • Manage error handling and transactions to ensure data integrity.
  • Optimize query performance to enhance database efficiency.
 

Exam Objectives for Microsoft 70-461 Certification

 

This course prepares you for the Microsoft 70-461 certification exam, which tests your ability to create database objects, work with data, modify data, and troubleshoot and optimize queries. The certifying body is Microsoft.

 

  • Creating Database Objects (20-25%)
  • Working with Data (25-30%)
  • Modifying Data (20-25%)
  • Troubleshooting and Optimizing (25-30%)
 

Who This Microsoft 70-461: Querying SQL Server 2012 Course is For

 

This course is ideal for IT professionals and database administrators looking to enhance their SQL Server skills. It is also suitable for:

 

  • Beginner and intermediate SQL Server users.
  • Developers looking to deepen their knowledge of SQL queries.
  • Data analysts and data scientists working with SQL Server.
  • Professionals preparing for the Microsoft 70-461 certification exam.
 

Possible Jobs You Can Get With This Knowledge

 

With the skills acquired in this course, you can pursue various career opportunities in the field of database management and analysis. Potential job titles include:

 

  • Database Administrator
  • SQL Developer
  • Data Analyst
  • Business Intelligence Developer
  • Data Scientist
  • IT Consultant
 

Average Industry Salaries for People with These Skills

 

Professionals with SQL Server skills are in high demand and can expect competitive salaries. Here are some average salary ranges:

 

  • Database Administrator: $75,000 – $115,000 per year
  • SQL Developer: $70,000 – $110,000 per year
  • Data Analyst: $60,000 – $100,000 per year
  • Business Intelligence Developer: $80,000 – $120,000 per year
  • Data Scientist: $95,000 – $140,000 per year

course CURRICULUM

Getting Started with SQL Server 2012

Course Introduction

Working with T-SQL

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

Writing SELECT Queries

Select Statement-Part 1
Select Statement-Part 2
Select Statement-Part 3
Select Statement-Part 4

Working with SQL Data Types

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

Sorting and Filtering Data

Sorting Results-Part 1
Sorting Results-Part 2
Sorting Results-Part 3
Sorting Results-Part 4
Sorting Results-Part 5
Sorting Results-Part 6

Querying Data from Multiple Tables

Tables Part 1
Tables Part 2
Tables Part 3
Tables Part 4
Tables Part 5
Tables Part 6

Modifying Data

Inserting Data-Part 1
Inserting Data-Part 2
Inserting Data-Part 3
Inserting Data-Part 4
Inserting Data-Part 5
Inserting Data-Part 6

Working with SQL Server Built-in Functions

Functions
Parse
Logical Functions
Group By

Programming in T-SQL

Programming-Part 1
Programming-Part 2
Programming-Part 3
Programming-Part 4
Programming-Part 5
Programming-Part 6

Implementing Stored Procedures

Storage Procedures-Part 1
Storage Procedures-Part 2
Dynamic SQL-Part 1
Dynamic SQL-Part 2

Working with Subqueries and Table Expressions

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

Working with Set Operators, Conditional Operators, and Window Functions

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

Working with PIVOT, UNPIVOT, and Grouping Sets

Pivot
Grouping Sets

Managing Error Handling and Transactions

Error Handling-Part 1
Error Handling-Part 2
Manage Transactions-Part 1
Manage Transactions-Part 2
Manage Transactions-Part 3

Querying SQL Server System

System Databases-Part 1
System Databases-Part 2
System Databases-Part 3
System Databases-Part 4

Optimizing Query Performance

Query Planning-Part 1
Query Planning-Part 2
Index-Part 1
Index-Part 2
Index-Part 3

Our Talents Work Here
ti.webp
unicard_ltd_logo.jpeg
onecall.png
ibm.png
Fourth_new-logo-e1678350336847.png

Our talentstories

We connect learners with peers and experts from around the world, facilitating networking and collaboration opportunities.

IBT Training's DevOps course provided a comprehensive and insightful learning experience with valuable hands-on exercises. While the internship placement was beneficial, additional guidance could enhance the overall transition. Overall, IBT Training lays a solid foundation for entering the DevOps field.

Olaniyan Olatunde Kubernetes Admin, Microsoft

Enrolling in this course proved career-defining, offering invaluable knowledge and a guaranteed internship. It set me on a path to success, delivering everything promised—free certification, ongoing learning, and the ability to pass my sec+ on the first try.

Solomon Awuku Cybersecurity Analyst, Tek Computers

Upon completing the class, I felt confident and prepared to embark on a career in cybersecurity. The skills and knowledge I acquired have already proven invaluable, as I find myself better equipped to tackle real-world challenges and contribute to the protection of digital assets.

Raymond A. CYBERSECURITY ANALYST BLUE CROSS

"IBT Learning is an outstanding tech school, with experienced teachers. Graduates gain hands-on experience with management tools such as Git, Maven, Nexus, SonarQube, Ansible, Docker for microservices, Kubernetes for container orchestration, and Terraform for Infras as Code"

Landric N DevOps Engineer, Transportation Insight