Lifetime
An ITU Online Training exclusive. The only Buy Once, Never Pay for IT training again program available. Plus, get all new and updated content for life.
- +1 855.488.5327
- customerservice@ituonline.com
- Mon - Fri: 9:00am - 5:00pm ET
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
12 Hrs 22 Min
84 On-demand Videos
Closed Captions
16 Topics
53 Prep Questions
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 DisplayYour Achievement
Upon completion of your training, you’ll receive a personalized certificate of completion to help validate to others your new skills.
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
ITU OnlineYour Training Instructor
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.”
Subscribe To All-Access
Lock In $14.99 / Month Forever
Start this course for free with our 10-day trial of the all-access subscription providing access to over 2,600 hours of training.
$49.00 $14.99 Monthly
OR
$49.00
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
Learn how to develop scalable and secure web applications with Microsoft ASP .NET MVC in our comprehensive online course.
In this Microsoft ASP .NET MVC online training course you will learn a powerful, patterns-based way to build dynamic websites that gives you full control over markup for enjoyable, agile development. You will learn ASP.NET MVC and its many features that enable fast, TDD-friendly development for creating sophisticated applications that use the latest web standards.
$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.
$49.00
Master JavaScript Fundamentals and build powerful web applications with our comprehensive online training. Start now!
If you’re ready to dive into Java Programming, this JavaScript Fundamentals online training course is for you! You’ll start with the basics and work your way up to advanced levels. Not only will you get a comprehensive introduction to object-oriented programming, but also learn many other core Java features in detail. Don’t miss out on this opportunity – sign up now and make strides in mastering Java today!
