O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Microsoft 70-461 Querying SQL Server 2012

Video Description

This course is intended for SQL Server database administrators, implementers, system engineers, and developers. This new SQL 2012 course is focused on anyone interested in the validation of your skills and knowledge with writing queries. This course provides the knowledge and understanding for some of these important job functions: Apply built-in scalar functions Apply ranking functions Combine datasets Creates and alters Design T-SQL stored procedures, views Implementing aggregate queries, error handling, sequence generation and data types Manage transactions Modify data by using INSERT, UPDATE, DELETE and MERGE statements Optimizing queries Query data using SELECT statements and Managing XML data OUTPUT clause to return data

Table of Contents

  1. Querying Microsoft SQL Server 2012
    1. Course Introduction Part1 00:01:26
    2. Course Introduction Part2 00:00:41
    3. Course Modules 00:01:54
  2. Module 1
    1. Introduction to SQL Server 2012 Part1 00:00:11
    2. Introduction to SQL Server 2012 Part2 00:00:23
    3. Introduction to SQL Server 2012 Part3 00:01:25
    4. SQL Instances Part1 00:05:05
    5. SQL Instances Part2 00:03:08
    6. SQL Instances Part3 00:01:53
    7. Editions and Licensing Part1 00:05:08
    8. Editions and Licensing Part2 00:01:02
    9. SQL Server Objects 00:01:21
    10. System Databases 00:04:11
    11. SQL Server Data Tools 00:02:24
    12. Object Explorer Part1 00:00:49
    13. Object Explorer Part2 00:01:54
    14. Object Scripting Part1 00:00:48
    15. Object Scripting Part2 00:02:58
    16. Template Explorer Part1 00:00:56
    17. Template Explorer Part2 00:01:51
    18. Query Tabs Part1 00:00:37
    19. Query Tabs Part2 00:03:28
    20. Projects and Solutions Part1 00:00:49
    21. Projects and Solutions Part2 00:03:10
    22. Customizing SSDT Part1 00:00:39
    23. Customizing SSDT Part2 00:05:17
    24. Debugging T-SQL Part1 00:00:57
    25. Debugging T-SQL Part2 00:02:20
    26. SQLCMD Part1 00:02:17
    27. SQLCMD Part2 00:05:36
    28. Module 1 Exam Scenarios 00:03:01
    29. Module 1 Review 00:01:14
  3. Module 2
    1. T-SQL Overview Part1 00:00:07
    2. T-SQL Overview Part2 00:01:16
    3. T-SQL Overview Part3 00:01:02
    4. T-SQL Elements Part1 00:00:18
    5. T-SQL Elements Part2 00:01:29
    6. Batch Separators Part1 00:01:12
    7. Batch Separators Part2 00:02:57
    8. Line Terminator Part1 00:00:31
    9. Line Terminator Part2 00:01:35
    10. Variables Part1 00:01:17
    11. Variables Part2 00:01:51
    12. Control Flow Part1 00:01:17
    13. Control Flow Part2 00:01:28
    14. Expressions Part1 00:00:56
    15. Expressions Part2 00:01:48
    16. Functions Part1 00:01:35
    17. Functions Part2 00:02:51
    18. Predicates and Operators Part1 00:01:38
    19. Predicates and Operators Part2 00:02:12
    20. Predicates and Operators Part3 00:00:57
    21. SELECT Part1 00:01:13
    22. SELECT Part2 00:01:42
    23. SELECT Part3 00:00:39
    24. Column Aliasing Part1 00:01:13
    25. Column Aliasing Part2 00:01:16
    26. SELECT Execution Part1 00:01:00
    27. SELECT Execution Part2 00:01:22
    28. Module 2 Exam Scenarios 00:02:54
    29. Module 2 Review 00:00:44
  4. Module 3
    1. SELECT Statements Part1 00:00:09
    2. SELECT Statements Part2 00:00:09
    3. Basic SELECT Statement Part1 00:01:05
    4. Basic SELECT Statement Part2 00:01:22
    5. Specifying Columns Part1 00:00:45
    6. Specifying Columns Part2 00:01:52
    7. Derived Columns Part1 00:00:47
    8. Derived Columns Part2 00:01:20
    9. Aliasing Columns Part1 00:01:41
    10. Aliasing Columns Part2 00:01:10
    11. Calculated Columns Part1 00:01:11
    12. Calculated Columns Part2 00:01:46
    13. Ordering Results Part1 00:00:08
    14. Ordering Results Part2 00:00:51
    15. Ordering Results Part3 00:01:18
    16. Ordering Results Part4 00:01:04
    17. Returning Distinct Results Part1 00:01:54
    18. Returning Distinct Results Part2 00:01:54
    19. Module 3 Exam Scenarios 00:02:44
    20. Module 3 Review 00:00:49
  5. Module 4
    1. Filtering Part1 00:00:14
    2. Filtering Part2 00:00:17
    3. WHERE Syntax Part1 00:01:26
    4. WHERE Syntax Part2 00:01:35
    5. BETWEEN 00:01:20
    6. WHERE Syntax IN 00:01:37
    7. Filtering NULL Values 00:02:49
    8. LIKE 00:01:54
    9. Data Type Comparison 00:03:35
    10. Filtering Data with WHERE Part1 00:03:14
    11. Filtering Data with WHERE Part2 00:04:35
    12. Filtering Data with WHERE Part3 00:04:47
    13. TOP Part1 00:00:14
    14. TOP Part2 00:02:37
    15. OFFSET-FETCH Part1 00:02:07
    16. OFFSET-FETCH Part2 00:03:26
    17. Module 4 Exam Scenarios 00:02:26
    18. Module 4 Review 00:00:53
  6. Module 5
    1. Join and Set Operators 00:00:10
    2. Using Joins Part1 00:00:11
    3. Using Joins Part2 00:01:21
    4. Categories of Joins 00:01:46
    5. INNER JOIN 00:04:24
    6. OUTER JOIN 00:03:40
    7. JOIN Demo 00:06:44
    8. Set Operators Part1 00:00:09
    9. Set Operators Part2 00:01:27
    10. Set Operators Part3 00:01:14
    11. Set Operators Part4 00:00:45
    12. Set Operators Demo 00:04:33
    13. Module 5 Exam Scenarios 00:02:40
    14. Module 5 Review 00:00:59
  7. Module 6
    1. Subqueries and Table Expressions 00:00:11
    2. Subqueries Part1 00:00:09
    3. Subqueries Part2 00:00:52
    4. Self Contained Subquery 00:01:16
    5. Correlated Subquery 00:00:44
    6. Subquery Demo 00:03:40
    7. EXISTS Part1 00:00:08
    8. EXISTS Part2 00:01:21
    9. EXISTS Part3 00:02:07
    10. Common Table Expressions Part1 00:00:15
    11. Common Table Expressions Part2 00:02:43
    12. Temporary Tables 00:02:28
    13. Table Variables 00:02:48
    14. Table Demo 00:05:42
    15. Module 6 Exam Scenarios 00:02:54
    16. Module 6 Review 00:01:23
  8. Module 7
    1. System Functions Part1 00:00:12
    2. System Functions Part2 00:02:01
    3. Scalar Functions 00:02:13
    4. ROWSET 00:01:12
    5. System Function Demo 00:03:22
    6. Aggregate Functions Part1 00:00:33
    7. Aggregate Functions Part2 00:02:28
    8. DISTINCT 00:03:24
    9. Aggregation Demo 00:04:57
    10. GROUP BY Part1 00:05:24
    11. GROUP BY Part2 00:07:34
    12. HAVING Part1 00:01:23
    13. HAVING Part2 00:02:27
    14. Conversion Functions Part1 00:00:13
    15. Conversion Functions Part2 00:02:51
    16. Conversion Functions Part3 00:02:45
    17. Conversion Functions Part4 00:06:11
    18. Module 7 Exam Scenarios 00:02:35
    19. Module 7 Review 00:02:05
  9. Module 8
    1. T-SQL Programming 00:00:16
    2. Logical Functions Part1 00:00:11
    3. Logical Functions Part2 00:01:00
    4. IIF, CHOOSE and CASE 00:03:19
    5. Logical Function Demo Part1 00:02:35
    6. Logical Function Demo Part2 00:02:49
    7. Using Views Part1 00:00:29
    8. Using Views Part2 00:04:02
    9. Stored Procedures 00:04:03
    10. Functions 00:03:44
    11. Triggers 00:02:27
    12. Views Demo Part1 00:04:35
    13. Views Demo Part2 00:06:56
    14. Views Demo Part3 00:04:47
    15. TRY CATCH Part1 00:00:09
    16. TRY CATCH Part2 00:02:24
    17. Module 8 Exam Scenarios 00:03:18
    18. Module 8 Review 00:01:28
  10. Module 9
    1. Transactions 00:00:11
    2. Introduction to Transactions Part1 00:00:09
    3. Introduction to Transactions Part2 00:03:35
    4. INSERT and UPDATE 00:02:30
    5. INSERT and UPDATE 00:02:46
    6. Transactions Demo Part1 00:04:52
    7. Transactions Demo Part2 00:03:53
    8. Transactions Demo Part3 00:03:35
    9. Managing Transactions Part1 00:00:14
    10. Managing Transactions Part2 00:03:42
    11. XACT_ABORT 00:02:19
    12. Managing Transactions Demo Part1 00:04:47
    13. Managing Transactions Demo Part2 00:04:22
    14. Module 9 Exam Scenarios 00:02:02
    15. Module 9 Review 00:00:33
  11. Module 10
    1. Query Performance 00:00:09
    2. Indexing Part1 00:00:09
    3. Indexing Part2 00:03:59
    4. Indexing Part3 00:02:37
    5. Index Strategies 00:03:25
    6. Indexes Demo Part1 00:04:07
    7. Indexes Demo Part2 00:04:20
    8. Execution Plans Part1 00:00:11
    9. Execution Plans Part2 00:03:50
    10. Statistics IO 00:01:12
    11. Execution Plans Demo Part1 00:03:54
    12. Execution Plans Demo Part2 00:03:46
    13. Module 10 Exam Scenarios 00:02:30
    14. Module 10 Review 00:01:24
    15. Program Review 00:02:15