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

Included In This Course

Total Hours
12 Training Hours
Microsoft 70-461: Querying SQL Server
84 On-demand Videos
Closed Caption

Closed Captions

Course Topics
16  Topics
Prep Questions
53 Prep Questions
Microsoft 70-461: Querying SQL Server

Certificate of Completion

Course Description

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

Course Outline

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 80 reviews
1-5 of 80 reviews
  1. AA
  2. K
  3. BO
  4. 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.

  5. A

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
 

$49.00

OR

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

Gain access to this training and all our other courses, offering over 2,500 hours of content, with our cost-effective monthly subscription. No obligations. Cancel anytime.

$49.00 $14.99 Monthly

Microsoft 70-461: Querying SQL Server

Microsoft 70-461: Querying SQL Server
Microsoft 70-461: Querying SQL Server
Additional Options to Access This Training
This training is also part of our extensive training library containing over 225 courses, 12,000+ videos and over 19,000 practice test questions.

Monthly All-Access Subscription
7 Days Free - $39.00 / month

A great option at an affordable monthly price.

Annual All-Access Subscription
$229 / year

A discounted price when paying for your All Access library on an annual basis.

Lifetime All-Access Library
$379 One time payment

Exceptional Value. Pay once, never have to buy IT training again.

Related Courses

$49.00

Get certified in Microsoft 70-463: Implementing a Data Warehouse with SQL Server with ITU Online. Get expert-led training and start your career today!

In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Add To Cart

$49.00

Gain expertise in designing BI solutions with SQL Server with our Microsoft 70-467 training course. Become an expert in BI solutions design today!

In this online training course you will learn how to plan and design a business intelligence (BI) infrastructure by designing a reporting solution, designing BI data models and designing an ETL solution. This course will teach business intelligence (BI) architects the overall design of a BI infrastructure and how it relates to other data systems in use.

Add To Cart

$49.00

Get certified as a Microsoft MCSA: SQL Server Solutions Associate with our comprehensive training program. Implement SQL Server solutions with ease.

Showcase your indispensable abilities and ingenious insights in creating and managing the upcoming generation of mission-critical environments with our Microsoft MCSA: SQL Server Solutions Associate online course.

Add To Cart