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-464 Developing Microsoft SQL Server 2012 Databases

Video Description

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around Developing Microsoft SQL Server 2012 Databases. This course is designed for Database developers who build and implement databases across the organization, while ensuring high levels of data availability. They perform tasks including creating database files, create data types, tables, plan create and optimize indexes, implement data integrity, implement views, stored procedures and functions, manage transactions and locks.

Table of Contents

  1. Developing Microsoft SQL Server 2012 Databases
    1. Course Introduction 00:00:30
    2. Course Modules 00:00:48
  2. Module 1
    1. Introduction to SQL Server 2012 Part1 00:00:09
    2. Introduction to SQL Server 2012 Part2 00:00:37
    3. SQL Instances 00:04:06
    4. SQL Editions 00:05:31
    5. SQL Server Tools 00:00:19
    6. SQL Server Management Studio 00:06:10
    7. SQL Data Tools 00:00:37
    8. SQL Command 00:01:17
    9. Utilizing SQL Server Tools Part1 00:05:41
    10. Utilizing SQL Server Tools Part2 00:06:12
    11. Exam Scenarios Part1 00:00:49
    12. Exam Scenarios Part2 00:01:54
    13. Module 1 Review 00:00:52
  3. Module 2
    1. Introduction to Data Types and Tables Part1 00:00:15
    2. Introduction to Data Types and Tables Part2 00:02:04
    3. Introduction to Data Types and Tables Part3 00:01:41
    4. Collations 00:01:23
    5. Unicode Characters 00:00:46
    6. Null Values 00:00:52
    7. Converting Data Types 00:02:28
    8. Introduction to Tables Part1 00:00:14
    9. Introduction to Tables Part2 00:03:23
    10. Normalization 00:02:22
    11. Temporary Tables 00:01:50
    12. Working with Tables 00:01:41
    13. Schemas 00:02:00
    14. Primary and Foreign Keys Part1 00:00:07
    15. Primary and Foreign Keys Part2 00:05:37
    16. UNIQUE Constraint/Index 00:00:42
    17. In Depth Look Part1 00:03:55
    18. In Depth Look Part2 00:05:54
    19. In Depth Look Part3 00:06:04
    20. In Depth Look Part4 00:05:52
    21. Exam Scenarios Part1 00:00:37
    22. Exam Scenarios Part2 00:01:14
    23. Module 2 Review 00:00:40
  4. Module 3
    1. SQL Server Indexing Part1 00:00:10
    2. SQL Server Indexing Part2 00:00:45
    3. Introduction to Indexing 00:03:08
    4. Clustered Indexes 00:05:33
    5. Non Clustered Indexes Part1 00:02:15
    6. Non Clustered Indexes Part2 00:01:50
    7. Non Clustered Indexes Part3 00:03:02
    8. Non Clustered Indexes Part4 00:01:43
    9. Maintaining Indexes Part1 00:00:07
    10. Maintaining Indexes Part2 00:01:51
    11. Index Fragmentation 00:04:22
    12. Index Tuning 00:00:51
    13. Creating and Altering Indexes Part1 00:06:02
    14. Creating and Altering Indexes Part2 00:03:56
    15. Creating and Altering Indexes Part3 00:03:57
    16. Exam Scenarios Part1 00:00:33
    17. Exam Scenarios Part2 00:01:24
    18. Module 3 Review 00:00:32
  5. Module 4
    1. Query Performance Part1 00:00:14
    2. Query Performance Part2 00:02:05
    3. Execution Plans 00:03:08
    4. Reading Execution Plans 00:01:17
    5. Execution Plan Operators 00:01:22
    6. Plan Reuse 00:02:06
    7. Query Performance Part1 00:04:28
    8. Query Performance Part2 00:04:25
    9. Query Performance Part3 00:06:02
    10. Exam Scenarios 00:01:25
    11. Module 4 Review 00:01:01
  6. Module 5
    1. Common Language Runtime (CLR) Integration Part1 00:00:12
    2. Common Language Runtime (CLR) Integration Part2 00:02:52
    3. Assemblies 00:01:42
    4. Permissions 00:01:27
    5. CLR Objects 00:04:56
    6. Integrating the CLR within SQL Server 00:04:17
    7. Exam Scenarios Part1 00:01:17
    8. Exam Scenarios Part2 00:01:19
    9. Module 5 Review 00:00:47
  7. Module 6
    1. Transact-SQL (T-SQL) Error Handling Part1 00:00:13
    2. Transact-SQL (T-SQL) Error Handling Part2 00:02:18
    3. Error Severity 00:03:20
    4. TRY CATCH Error Handling 00:01:25
    5. TRY PARSE and TRY CONVERT 00:00:46
    6. @@ ERROR 00:00:44
    7. Alerts 00:01:05
    8. Error Handling in T-SQL Part1 00:04:02
    9. Error Handling in T-SQL Part2 00:05:05
    10. Exam Scenarios Part1 00:00:38
    11. Exam Scenarios Part2 00:01:24
    12. Module 6 Review 00:00:48
  8. Module 7
    1. Views and Functions Part1 00:00:10
    2. Views and Functions Part2 00:01:01
    3. Types of Views 00:01:35
    4. Working with Views Part1 00:04:37
    5. Working with Views Part2 00:03:03
    6. Introduction to Functions Part1 00:00:11
    7. Introduction to Functions Part2 00:01:20
    8. Working with Functions 00:01:50
    9. Working with Views and Functions Part1 00:04:41
    10. Working with Views and Functions Part2 00:03:47
    11. Working with Views and Functions Part3 00:03:06
    12. Exam Scenarios Part1 00:01:47
    13. Exam Scenarios Part2 00:01:18
    14. Module 7 Review 00:00:36
  9. Module 8
    1. Stored Procedures and Triggers Part1 00:00:12
    2. Stored Procedures and Triggers Part2 00:02:27
    3. Working with Stored Procedures 00:01:27
    4. Introduction to Triggers Part1 00:00:07
    5. Introduction to Triggers Part2 00:02:48
    6. Working with Triggers 00:02:35
    7. Stored Procedures and Triggers Demo Part1 00:05:02
    8. Stored Procedures and Triggers Demo Part2 00:03:26
    9. Stored Procedures and Triggers Demo Part3 00:03:32
    10. Exam Scenarios Part1 00:01:08
    11. Exam Scenarios Part2 00:01:46
    12. Module 8 Review 00:01:40
  10. Module 9
    1. Working with XML Part1 00:00:09
    2. Working with XML Part2 00:00:32
    3. XML Concepts Part1 00:02:00
    4. XML Concepts Part2 00:01:21
    5. Schemas and Schema Collections Part1 00:03:56
    6. Schemas and Schema Collections Part2 00:01:12
    7. FOR XML Clause Part1 00:00:06
    8. FOR XML Clause Part2 00:03:11
    9. FLOWR Queries 00:01:32
    10. Working with XML in SQL Server Part1 00:05:17
    11. Working with XML in SQL Server Part2 00:03:57
    12. Exam Scenarios Part1 00:01:04
    13. Exam Scenarios Part2 00:01:13
    14. Module 9 Review 00:00:40
  11. Module 10
    1. Transactions Part1 00:00:10
    2. Transactions Part2 00:01:45
    3. Implicit Transactions 00:00:36
    4. Explicit Transactions 00:02:22
    5. Locking Part1 00:04:03
    6. Locking Part2 00:01:36
    7. Working with Transactions and Locking within SQL Part1 00:03:38
    8. Working with Transactions and Locking within SQL Part2 00:02:40
    9. Exam Scenarios Part1 00:00:34
    10. Exam Scenarios Part2 00:01:26
    11. Module 10 Review 00:01:07
    12. Course Review 00:01:16