Microsoft 70-461: Querying SQL Server 2012 Training Course

Current Status
Not Enrolled
Price
£11.99
Get Started
or

Table of Contents

This course is best suited for participants who have a desire to learn but more importantly for SQL database administrators, system engineers and developers who intend to clear the Querying Microsoft SQL Server 2012 exam. It is required that you pass the 70-461 Exam in order to earn your MCSA: SQL Server certification from Microsoft.

Key Features

  • 1-year e-learning access

Overview

The Microsoft 70-461 exam is for those working as SQL Server Database administrators, System engineers, and experienced developers. This exam tests their skills and knowledge of writing queries. Here we bring you the best-in-class course that prepares you for taking up the Microsoft 70-461 exam.

Outline

  1. Querying Microsoft SQL Server 2012
    1. Course Introduction Part1
    2. Course Introduction Part2
    3. Course Modules
  2. Module 1
    1. Introduction to SQL Server 2012 Part1
    2. Introduction to SQL Server 2012 Part2
    3. Introduction to SQL Server 2012 Part3
    4. SQL Instances Part1
    5. SQL Instances Part2
    6. SQL Instances Part3
    7. Editions and Licensing Part1
    8. Editions and Licensing Part2
    9. SQL Server Objects
    10. System Databases
    11. SQL Server Data Tools
    12. Object Explorer Part1
    13. Object Explorer Part2
    14. Object Scripting Part1
    15. Object Scripting Part2
    16. Template Explorer Part1
    17. Template Explorer Part2
    18. Query Tabs Part1
    19. Query Tabs Part2
    20. Projects and Solutions Part1
    21. Projects and Solutions Part2
    22. Customizing SSDT Part1
    23. Customizing SSDT Part2
    24. Debugging T-SQL Part1
    25. Debugging T-SQL Part2
    26. SQLCMD Part1
    27. SQLCMD Part2
    28. Exam Scenarios
    29. Module Review
  3. Module 2
    1. T-SQL Overview Part1
    2. T-SQL Overview Part2
    3. T-SQL Overview Part3
    4. T-SQL Elements Part1
    5. T-SQL Elements Part2
    6. Batch Separators Part1
    7. Batch Separators Part2
    8. Line Terminator Part1
    9. Line Terminator Part2
    10. Variables Part1
    11. Variables Part2
    12. Control Flow Part1
    13. Control Flow Part2
    14. Expressions Part1
    15. Expressions Part2
    16. Functions Part1
    17. Functions Part2
    18. Predicates and Operators Part1
    19. Predicates and Operators Part2
    20. Predicates and Operators Part3
    21. SELECT Part1
    22. SELECT Part2
    23. SELECT Part3
    24. Column Aliasing Part1
    25. Column Aliasing Part2
    26. SELECT Execution Part1
    27. SELECT Execution Part2
    28. Exam Scenarios
    29. Module Review
  4. Module 3
    1. SELECT Statements Part1
    2. SELECT Statements Part2
    3. Basic SELECT Statement Part1
    4. Basic SELECT Statement Part2
    5. Specifying Columns Part1
    6. Specifying Columns Part2
    7. Derived Columns Part1
    8. Derived Columns Part2
    9. Aliasing Columns Part1
    10. Aliasing Columns Part2
    11. Calculated Columns Part1
    12. Calculated Columns Part2
    13. Ordering Results Part1
    14. Ordering Results Part2
    15. Ordering Results Part3
    16. Ordering Results Part4
    17. Returning Distinct Results Part1
    18. Returning Distinct Results Part2
    19. Exam Scenarios
    20. Module Review
  5. Module 4
    1. Filtering Part1
    2. Filtering Part2
    3. WHERE Syntax Part1
    4. WHERE Syntax Part2
    5. BETWEEN
    6. WHERE Syntax IN
    7. Filtering NULL Values
    8. LIKE
    9. Data Type Comparison
    10. Filtering Data with WHERE Part1
    11. Filtering Data with WHERE Part2
    12. Filtering Data with WHERE Part3
    13. TOP Part1
    14. TOP Part2
    15. OFFSET-FETCH Part1
    16. OFFSET-FETCH Part2
    17. Exam Scenarios
    18. Module Review
  6. Module 5
    1. Join and Set Operators
    2. Using Joins Part1
    3. Using Joins Part2
    4. Categories of Joins
    5. INNER JOIN
    6. OUTER JOIN
    7. JOIN Demo
    8. Set Operators Part1
    9. Set Operators Part2
    10. Set Operators Part3
    11. Set Operators Part4
    12. Set Operators Demo
    13. Exam Scenarios
    14. Module Review
  7. Module 6
    1. Subqueries and Table Expressions
    2. Subqueries Part1
    3. Subqueries Part2
    4. Self Contained Subquery
    5. Correlated Subquery
    6. Subquery Demo
    7. EXISTS Part1
    8. EXISTS Part2
    9. EXISTS Part3
    10. Common Table Expressions Part2
    11. Common Table Expressions Part1
    12. Temporary Tables
    13. Table Variables
    14. Table Demo
    15. Exam Scenarios
    16. Module Review
  8. Module 7
    1. System Functions Part1
    2. System Functions Part2
    3. Scalar Functions
    4. ROWSET
    5. System Function Demo
    6. Aggregate Functions Part1
    7. Aggregate Functions Part2
    8. DISTINCT
    9. Aggregation Demo
    10. GROUP BY Part1
    11. GROUP BY Part2
    12. HAVING Part1
    13. HAVING Part2
    14. Conversion Functions Part1
    15. Conversion Functions Part2
    16. Conversion Functions Part3
    17. Conversion Functions Part4
    18. Exam Scenarios
    19. Module Review
  9. Module 8
    1. T-SQL Programming
    2. Logical Functions Part1
    3. Logical Functions Part2
    4. IIF, CHOOSE and CASE
    5. Logical Function Demo Part1
    6. Logical Function Demo Part2
    7. Using Views Part1
    8. Using Views Part2
    9. Stored Procedures
    10. Functions
    11. Triggers
    12. Views Demo Part1
    13. Views Demo Part2
    14. Views Demo Part3
    15. TRY CATCH Part1
    16. TRY CATCH Part2
    17. Exam Scenarios
    18. Module Review
  10. Module 9
    1. Transactions
    2. Introduction to Transactions Part1
    3. Introduction to Transactions Part2
    4. INSERT and UPDATE
    5. DELETE and TRUNCATE
    6. Transactions Demo Part1
    7. Transactions Demo Part2
    8. Transactions Demo Part3
    9. Managing Transactions Part1
    10. Managing Transactions Part2
    11. XACT_ABORT
    12. Managing Transactions Demo Part1
    13. Managing Transactions Demo Part2
    14. Exam Scenarios
    15. Module Review
  11. Module 10
    1. Query Performance
    2. Indexing Part1
    3. Indexing Part2
    4. Indexing Part3
    5. Index Strategies
    6. Indexes Demo Part1
    7. Indexes Demo Part2
    8. Execution Plans part1
    9. Execution Plans Part2
    10. Statistics IO
    11. Execution Plans Demo part1
    12. Execution Plans Demo part2
    13. Exam Scenarios
    14. Module Review
    15. Program Review

stay informed!

Subscribe to receive exclusive content and notifications

small_c_popup.png

Share this course

[geturl]
Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Keep in touch

Fill in your details and we’ll get back to you in no time.