Microsoft 70-461: Querying SQL Server 2012 Training Course

Current Status

Not Enrolled

Price

49.99

Get Started

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

Querying Microsoft SQL Server 2012
1. Course Introduction Part1
2. Course Introduction Part2
3. Course Modules
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
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
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
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
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
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
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
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
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
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