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-465: Designing Database Solutions for Microsoft SQL Server 2012

Video Description

This course is specifically for participants to measure their knowledge and skills on making the appropriate job role decisions around designing database solutions for Microsoft SQL Server 2012. This course is designed for Database professionals who design and build database solutions. These Database professionals are responsible for the creation of plans and designs for Database structure, storage, objects, and servers, as well as creating the plan for the environment in which the database solution runs.

Table of Contents

  1. Designing Database Solutions for Microsoft SQL Server 2012
    1. Course Introduction 00:01:03
    2. Course Modules 00:00:40
  2. Module 1: Introduction to SQL Server 2012
    1. Introduction to SQL Server 2012 Part1 00:00:08
    2. Introduction to SQL Server 2012 Part2 00:00:54
    3. SQL Server Instances 00:05:51
    4. SQL Server Editions and Licensing 00:03:18
    5. SQL Server Objects 00:01:19
    6. System Databases 00:03:26
    7. SQL Server Management Studio 00:01:26
    8. SSMS Components Part1 00:04:58
    9. SSMS Components Part2 00:02:14
    10. SQL Server Data Tools 00:01:00
    11. SQLCMD 00:03:28
    12. Working with SSMS Part1 00:04:19
    13. Working with SSMS Part2 00:01:45
    14. Working with SQLCMD 00:03:36
    15. Exam Scenarios 1 00:03:57
    16. Module 1 Review 00:01:09
  3. Module 2: Introduction to Databases
    1. Introduction to Databases Part1 00:00:09
    2. Introduction to Databases Part2 00:02:39
    3. Database Files Part1 00:01:33
    4. Database Files Part2 00:01:52
    5. Temp db 00:01:45
    6. Working with Databases 00:03:49
    7. Introduction to Filegroups and Files Part1 00:00:05
    8. Introduction to Filegroups and Files Part2 00:02:44
    9. Introduction to Log Files 00:02:17
    10. Transactions 00:02:25
    11. Moving Databases 00:01:32
    12. Detaching and Attaching Databases 00:01:55
    13. Backing Up and Restoring Databases 00:01:24
    14. Copy Database Wizard 00:01:16
    15. Database Catalog View 00:02:23
    16. Creating and Configuring Databases Part1 00:05:51
    17. Creating and Configuring Databases Part2 00:04:57
    18. Exam Scenarios 2 00:02:25
    19. Module 2 Review 00:01:22
  4. Module 3: Introduction to Data Types and Tables
    1. Introduction to Data Types and Tables Part1 00:00:08
    2. Introduction to Data Types and Tables Part2 00:00:13
    3. Supported Data Types 00:06:49
    4. Collations and Unicode Characters Part1 00:01:33
    5. Collations and Unicode Characters Part2 00:01:00
    6. Introduction to NULLS 00:00:57
    7. Converting Data Types 00:01:58
    8. Introduction to Tables Part1 00:00:11
    9. Introduction to Tables Part2 00:03:31
    10. Normalization 00:03:21
    11. Temporary Tables 00:02:09
    12. Working with Tables 00:01:50
    13. Schemas 00:02:08
    14. Primary and Foreign Keys Part1 00:01:12
    15. Primary and Foreign Keys Part2 00:02:19
    16. Primary and Foreign Keys Part3 00:01:01
    17. UNIQUE Constraint/Index 00:01:07
    18. Data Types in SQL Server Demonstration Part1 00:05:37
    19. Data Types in SQL Server Demonstration Part2 00:02:17
    20. Working with Tables Demonstration Part1 00:05:12
    21. Working with Tables Demonstration Part2 00:02:58
    22. Exam Scenarios 3 Part1 00:01:12
    23. Exam Scenarios 3 Part2 00:01:11
    24. Module 3 Review 00:01:33
  5. Module 4: SQL Server Indexing
    1. SQL Server Indexing Part1 00:00:07
    2. SQL Server Indexing Part2 00:01:11
    3. Introduction to Indexing 00:01:48
    4. Heaps 00:01:02
    5. Clustered Indexes 00:04:38
    6. Non-Clustered Indexes Part1 00:02:11
    7. Non-Clustered Indexes Part2 00:02:43
    8. Non-Clustered Indexes Part3 00:02:08
    9. Maintaining Indexes Part1 00:00:06
    10. Maintaining Indexes Part2 00:02:56
    11. Index Fragmentation 00:02:56
    12. SQL Server Profiler 00:01:23
    13. Index Tuning 00:00:44
    14. Working with Indexes Demonstration Part1 00:04:41
    15. Working with Indexes Demonstration Part2 00:02:08
    16. Working with Indexes Demonstration Part3 00:03:16
    17. SQL Server Tuning Advisor Demonstration Part1 00:04:59
    18. SQL Server Tuning Advisor Demonstration Part2 00:01:09
    19. Exam Scenarios 4 00:02:00
    20. Module 4 Review 00:01:06
  6. Module 5: Performance Considerations
    1. Performance Considerations Part1 00:00:09
    2. Performance Considerations Part2 00:00:45
    3. Partitioning Function 00:00:54
    4. Partition Scheme 00:00:17
    5. Partitioned Table or Index 00:01:47
    6. Introduction to Transaction 00:01:18
    7. Implicit and Explicit Transactions 00:02:53
    8. Locking 00:03:46
    9. Working with Partition Tables, Transaction and Locks Part1 00:05:20
    10. Working with Partition Tables, Transaction and Locks Part2 00:02:27
    11. Working with Partition Tables, Transaction and Locks Part3 00:03:49
    12. Exam Scenarios 5 00:02:18
    13. Module 5 Review 00:00:37
  7. Module 6: Backup and Restore
    1. Backup and Restore Part1 00:00:09
    2. Backup and Restore Part2 00:00:27
    3. Database Data and Log Files Part1 00:01:11
    4. Database Data and Log Files Part12 00:00:41
    5. Recovery Model 00:02:23
    6. Database Backups Types Part1 00:01:02
    7. Database Backups Types Part2 00:01:00
    8. Database Backups Types Part3 00:01:27
    9. Database Backups Types Part4 00:00:52
    10. Database Backups Types Part5 00:01:06
    11. Backup Compression and Mirrored Media Sets 00:00:58
    12. Verifying Backups 00:00:47
    13. Restoration Process 00:00:49
    14. Restoring Backup Types Part1 00:01:28
    15. Restoring Backup Types Part2 00:00:44
    16. Restoring Backup Types Part3 00:00:20
    17. Restoring to a Point in Time 00:01:11
    18. WITH STANDBY 00:00:54
    19. Restoring a Database 00:00:41
    20. Restoring System Databases 00:01:45
    21. Restoring the Master Database 00:00:21
    22. Backing Up and Restoring SQL Server Part1 00:05:00
    23. Backing Up and Restoring SQL Server Part2 00:02:59
    24. Backing Up and Restoring SQL Server Part3 00:03:00
    25. Backing Up and Restoring SQL Server Part4 00:02:47
    26. Exam Scenarios 6 00:03:27
    27. Module 6 Review 00:00:59
  8. Module 7: Views and Functions
    1. Module 7: Views and Functions Part1 00:00:09
    2. Module 7: Views and Functions Part2 00:00:09
    3. Module 7: Views and Functions Part3 00:00:43
    4. Types Of Views 00:01:21
    5. Creating and Altering Views 00:03:50
    6. Updatable and Indexed Views 00:03:43
    7. Partitioned Views 00:01:13
    8. Introduction to Functions 00:00:30
    9. Function Types 00:01:01
    10. Scalar and Table Valued Functions 00:02:29
    11. Working with Views and Functions Part1 00:06:07
    12. Working with Views and Functions Part2 00:03:52
    13. Working with Views and Functions Part3 00:03:10
    14. Exam Scenarios 7 00:03:21
    15. Module 7 Review 00:01:21
  9. Module 8: Stored Procedures and Triggers
    1. Stored Procedures and Triggers Part1 00:00:09
    2. Stored Procedures and Triggers Part2 00:00:15
    3. Stored Procedures and Triggers Part3 00:00:42
    4. Types of Stored Procedures 00:01:11
    5. Parameters 00:01:02
    6. Stored Procedure Compilation 00:02:36
    7. Execution Context Part1 00:01:31
    8. Execution Context Part2 00:00:39
    9. Introduction to Triggers Part1 00:00:07
    10. Introduction to Triggers Part2 00:01:12
    11. Types of Triggers 00:02:10
    12. Nested and Recursive Triggers 00:00:51
    13. Trigger Firing Order 00:00:44
    14. Working with Stored Procedures and Triggers Part1 00:05:27
    15. Working with Stored Procedures and Triggers Part2 00:05:52
    16. Exam Scenarios 8 00:02:38
    17. Module 8 Review 00:01:04
  10. Module 9: SQL Server Security
    1. SQL Server Security Part1 00:00:07
    2. SQL Server Security Part2 00:01:42
    3. SQL Authentication 00:01:00
    4. SQL Logins 00:01:02
    5. Accessing a Database 00:01:28
    6. Authorization Across Servers 00:01:47
    7. Server Roles 00:02:25
    8. Database Roles 00:01:11
    9. Application Roles 00:00:38
    10. Authorizing Access Part1 00:03:13
    11. Authorizing Access Part2 00:03:13
    12. Configuring Access Using Schemas 00:01:22
    13. Working with SQL Security Part1 00:03:53
    14. Working with SQL Security Part2 00:03:45
    15. Exam Scenarios 9 00:02:35
    16. Module 9 Review 00:01:03
  11. Module 10: Installing and Upgrading SQL
    1. Installing and Upgrading SQL Part1 00:00:10
    2. Installing and Upgrading SQL Part2 00:00:51
    3. Server Resources Part1 00:02:20
    4. Server Resources Part2 00:01:38
    5. 32 vs. 64 Bit 00:00:50
    6. SQL Requirements 00:02:48
    7. Software Requirements 00:00:58
    8. Collations 00:00:34
    9. Service Accounts 00:00:35
    10. Installing SQL Server 00:00:51
    11. Troubleshooting Installation 00:00:49
    12. Upgrading SQL Server Part1 00:00:06
    13. Upgrading SQL Server Part2 00:02:07
    14. Unattended Installations 00:00:38
    15. Exam Scenarios 10 00:02:29
    16. Module 13 Review 00:00:43
    17. Course Review 00:00:45