- +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.
$39.00
Buy This Course
$39.00
You can get access to this training and over 2,500 hours of on-demand content with our All Access Monthly Subscription. Start today for 7 free days with no obligation. You can cancel anytime.
7 Free Days / $0.00 due today / $39.00 monthlyÂ
12 Training Hours
84 Videos
16 Topics
53 Practice Questions
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.
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, click here.
Your Training Instructor
Chrys 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 35 IT Certifications including Cisco CCSI/CCNP, CISSP, CISA, MCSE/MCITP, and many more. She has also authored 40 published certification textbooks and is currently working on the new CompTIA PenTest+ courseware.
Course Outline
Microsoft 70-461: Querying SQL Server 2012 Course Outline
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
Microsoft 70-461: Querying SQL Server
$39.00
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.
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
Become a Certified Kubernetes Application Developer (CKAD). Enroll now and learn how to build, deploy, and manage Kubernetes applications.
If you’re looking to ace the Certified Kubernetes Application Developer (CKAD) exam, this is the video IT course for you! Through its comprehensive instruction materials, and lectures, it will teach you all that there is to know about Kubernetes – an open-source system designed by Google but now maintained by The Cloud Native Computing Foundation and pass the certification program.Â
$10.00
Take your SQL Server skills to the next level with ITU Online’s Microsoft 70-466 course on implementing data models and reports. Enroll now!
In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.
$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
Learn Java programming language with our online course and gain skills to build robust applications. Join now and get certified!
You should Learn Java as it is a must-have technology for a range of applications and websites, including business solutions, data centers, game consoles, utilities, desktop computers (as well as laptops and smartphones). That’s why this online training course explores the whole spectrum of Java Programming from beginner to advanced. With it you can confidently tackle any challenge that comes your way!