Course Introduction
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.
COURSE CONTENT
Getting Started with SQL Server 2012
Working with T-SQL
Writing SELECT Queries
Working with SQL Data Types
Sorting and Filtering Data
Querying Data from Multiple Tables
Modifying Data
Working with SQL Server Built-in Functions
Programming in T-SQL
Implementing Stored Procedures
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
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.
In this course, you will develop key skills necessary for effective SQL Server 2012 management. The following are the core learning outcomes:
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.
This course is ideal for IT professionals and database administrators looking to enhance their SQL Server skills. It is also suitable for:
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:
Professionals with SQL Server skills are in high demand and can expect competitive salaries. Here are some average salary ranges:
Course Introduction
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
Select Statement-Part 1
Select Statement-Part 2
Select Statement-Part 3
Select Statement-Part 4
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 Results-Part 1
Sorting Results-Part 2
Sorting Results-Part 3
Sorting Results-Part 4
Sorting Results-Part 5
Sorting Results-Part 6
Tables Part 1
Tables Part 2
Tables Part 3
Tables Part 4
Tables Part 5
Tables Part 6
Inserting Data-Part 1
Inserting Data-Part 2
Inserting Data-Part 3
Inserting Data-Part 4
Inserting Data-Part 5
Inserting Data-Part 6
Functions
Parse
Logical Functions
Group By
Programming-Part 1
Programming-Part 2
Programming-Part 3
Programming-Part 4
Programming-Part 5
Programming-Part 6
Storage Procedures-Part 1
Storage Procedures-Part 2
Dynamic SQL-Part 1
Dynamic SQL-Part 2
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
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
Pivot
Grouping Sets
Error Handling-Part 1
Error Handling-Part 2
Manage Transactions-Part 1
Manage Transactions-Part 2
Manage Transactions-Part 3
System Databases-Part 1
System Databases-Part 2
System Databases-Part 3
System Databases-Part 4
Query Planning-Part 1
Query Planning-Part 2
Index-Part 1
Index-Part 2
Index-Part 3
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, MicrosoftEnrolling 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 ComputersUpon 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