Microsoft 70-461: Querying SQL Server - ITU Online

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.

Included In This Course

Microsoft 70-461: Querying SQL Server
12 Hrs 22 Min
Videos
84 On-demand Videos
Closed Captions

Closed Captions

Course Topics
16  Topics
Question & Answers
53 Prep Questions
Certificate of Completion

Certificate of Completion

Note: Although this course is based on an older version, it remains to be a beneficial resource for educating and training.

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.

The Microsoft 70-461: Querying SQL Server course offered by ITU Online delivers comprehensive training to equip learners with the technical skills needed to write basic Transact-SQL queries for Microsoft SQL Server. This online course serves as the foundational stepping stone for all SQL Server-related disciplines including Database Administration, Database Development, and Business Intelligence. As part of this course, students will be fully prepared for the 70-461 Querying SQL Server exam, making it an ideal choice for those aiming to achieve a solid understanding of SQL Server and to validate their skills through certification​.

This training courses content is structured to cover key areas that are integral to the 70-461 exam. These areas include creating database objects (20-25% of the exam), working with data (25-30% of the exam), modifying data (20-25% of the exam), and troubleshooting and optimizing (25-30% of the exam). This coverage ensures that learners gain a well-rounded understanding of the subject matter, paving the way for success in the exam and in their future career pursuits​.

To facilitate effective learning, the course is led by Chrys Thorsen, an education and technology expert specializing in enterprise-level IT infrastructure consulting and certified training-of-trainers. With an instructor of such caliber, learners can be assured of receiving high-quality instruction that combines both theoretical understanding and practical application​​.

The Microsoft 70-461: Querying SQL Server course can be accessed as part of ITU Online’s All Access Monthly Subscription. This subscription gives you access to this course and over 2,500 hours of on-demand content, allowing for flexible and comprehensive learning. To ensure satisfaction, ITU Online offers a 7-day free trial with no obligation, and the subscription can be cancelled anytime. Embark on your learning journey today and gain the necessary skills to excel in your career with SQL Server​

Exam will cover the following areas

  • 20% – 25%: Create database objects
  • 25% – 30%: Working with data
  • 20% – 25%: Modify data
  • 25% – 30%: Troubleshoot and optimizing

To see more Microsoft related training, Visit the Microsoft Website.

Frequently Asked Questions About Microsoft 70-461: Querying SQL Server

What skills will I gain from the Microsoft 70-461: Querying SQL Server online course?

You’ll learn the technical skills needed to write basic Transact-SQL queries for Microsoft SQL Server. This knowledge forms the foundation for all SQL Server-related disciplines, including Database Administration, Database Development, and Business Intelligence.

Is this IT training course helpful for exam preparation?

Absolutely! This course is designed to prepare students for the 70-461 Querying SQL Server exam. It’ll give you the skills to write basic Transact-SQL queries for Microsoft SQL Server 2012, which is crucial for all SQL Server-related roles

What topics does the exam cover?

The 70-461 Querying SQL Server exam covers several areas. It includes creating database objects (20-25% of the exam), working with data (25-30%), modifying data (20-25%), and troubleshooting and optimizing (25-30%).

Who is the instructor for this online course?

The course is taught by Chrys Thorsen, an education and technology expert. Chrys specializes in enterprise-level IT infrastructure consulting and certified training-of-trainers. So, you’ll be learning from someone who really knows their stuff.

Can I get access to other courses as well?

Yes! With the All Access Monthly Subscription, you can access this course and over 2,500 hours of on-demand content. It’s a great way to expand your IT skills across multiple areas.

What if I decide the course isn’t for me after signing up?

No problem at all! You can start the All Access Monthly Subscription with a 7-day free trial, and there’s no obligation to continue. If you find the course isn’t what you’re looking for, you can cancel anytime.

Proudly Display
Your Achievement

Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
Example Certificate

Microsoft 70-461: Querying SQL Server 2012 Course Content

Lesson 1: Getting Started with SQL Server 2012

  •    Course Introduction

Lesson 2: 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

Lesson 3: Writing SELECT Queries

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

Lesson 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

Lesson 5: 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

Lesson 6: Querying Data from Multiple Tables

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

Lesson 7: 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

Lesson 8: Working with SQL Server Built-in Functions

  •    Functions
  •    Parse
  •    Logical Functions
  •    Group By

Lesson 9: Programming in T-SQL

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

Lesson 10: Implementing Stored Procedures

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

Lesson 11: 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

Lesson 12: 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

Lesson 13: Working with PIVOT, UNPIVOT, and Grouping Sets

  •    Pivot
  •    Grouping Sets

Lesson 14: 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

Lesson 15: Querying SQL Server System

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

Lesson 16: Optimizing Query Performance

  •    Query Planning-Part 1
  •    Query Planning-Part 2
  •    Index-Part 1
  •    Index-Part 2
  •    Index-Part 3
Add a review
Currently, we are not accepting new reviews
4.8
Based on 81 reviews
1-5 of 66 reviews
  1. SJ

    good

  2. AA
  3. K
  4. BO
  5. A

    Smooth delivery and easy access to LMS. Good to see that the LMS offers progress tracking. Would be great if badges were offered on completion of courses to share via Credly to future employers.

Your Training Instructor

Chrys Thorsen

Chrys Thorsen

Education and Technology Expert

Chrys Thorsen is an education and technology expert who specializes in enterprise-level IT infrastructure consulting and certified training-of-trainers. In her career, she has garnered over 50 IT Certifications including CISSP, CISA, CEHv12, PenTest+, CompTIA CNVP, Cisco CCSI/CCNP, Microsoft Cloud and on-premises technologies, VMware vSphere, and many more. She has also authored 40 published certification textbooks, and over 35 full-length IT certification video courses.

When not working in the United States, Chrys spends her time abroad capacity-building IT literacy in developing nations in Sub-Saharan Africa. Her client list has included: the US Federal Government, the Republic of Zambia Ministry of Health, Cavendish University Zambia, Accenture, JP Morgan Chase, the US Centers for Disease Control and Prevention, the Elizabeth Glaser Pediatric AIDS Foundation (EGPAF), Hughes Aircraft, Microsoft, and many more.

Chrys lives by, and is fond of repeating, her professional creed:

“The only true measure of success for any project or training is results on the ground. Everything else is just noise.” “I teach what I deploy; I deploy what I teach.”

Microsoft 70-461: Querying SQL Server

Subscribe To All-Access
Lock In $16.99 / Month Forever

Gain access to this training and all our other courses with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.99 $16.99 Monthly

OR

$49.00