Overview

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. 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. The Microsoft 70-764 SQL Server 2016 Administration course is designed to equip students with all the skills and knowledge necessary for them to confidently pass the Microsoft Certification Exam 70-764. By mastering this program, learners will be fully capable of administering a complete Microsoft SQL 2016 server solution – from installation through maintenance tasks. In this online IT learning course you will learn the .NET open source developer platform. This platform provides a comprehensive and consistent programming model for building web applications that have visually stunning user experiences and seamless and secure communication. HTML 5, Javascript and CSS3 can integrate with this platform. Oracle Database 12c: SQL Fundamentals provides a multitude of advantages from the re-engineered Oracle Database for Cloud computing. The architecture ensures hardware and software efficiency, superior performance, manageability benefits that lead to quick and effortless cloud provisioning. This Learn HTML course is designed for beginner level individuals who are interested in learning how to build a page for a website. Our comprehensive training course dives into all areas of HTML writing & editing so that by the end, you will be an expert in coding with HTML!

Your Training Instructor

Chrys Thorsen

Education and Technology Expert

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.

  • 12 Traning Hours
  • 84 Videos
  • 16 Topics
  • 53 Practice Questions

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

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
[/fusion_text]