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

Designing Database Solutions for Microsoft SQL Server 2012 (70-465)

Video Description

Microsoft's Designing Database Solutions for Microsoft SQL Server 2012 70-465 certification exam is intended for database professionals who design and build database solutions in the organization. They are responsible for the creation of plans and designs for database structure, storage, objects, and servers. They create the plan for the environment in which the database solution runs. The exam is part of Microsoft's MCSE: Data Platform certification track. In this VTC course, author Mark Long walks you through the technologies, terms, and functionalities you need to know to prepare for the 70-465 exam. To begin learning today, simply click on the movie links.

Table of Contents

  1. Welcome
    1. Introduction 00:01:24
    2. Course Overview 00:03:41
    3. Understanding SQL 00:05:03
    4. Understanding TSQL 00:05:33
    5. SQL Server History 00:05:30
    6. SQL Server Certifications 00:05:49
    7. The 70-465 Exam 00:05:53
  2. SQL Server 2012 Essentials
    1. SQL Server 2012 Editions 00:05:21
    2. Hardware Requirements 00:03:34
    3. Software Requirements 00:02:50
  3. Installing SQL Server 2012
    1. Getting a Copy of SQL Server 2012 00:05:03
    2. Understanding Instances 00:05:48
    3. Installing SQL Server 2012 pt. 1 00:06:22
    4. Installing SQL Server 2012 pt. 2 00:06:07
    5. SQL Books Online Goes Online 00:04:17
    6. Downloading Books Online 00:04:00
    7. SSMS Tour 00:06:33
  4. Designing Database Structure
    1. Determining Business Requirements 00:06:00
    2. Database Types 00:05:28
    3. The Relational Model 00:05:46
    4. Normalization Basics 00:05:10
    5. Basic Architectural Decisions 00:04:52
    6. Understanding File Groups 00:03:38
    7. Understanding Partitioning 00:04:24
    8. Authentication Modes 00:03:32
    9. Windows Authentication 00:03:18
    10. SQL Server Authentication 00:05:03
    11. The SA Account 00:02:46
  5. Database Object Design
    1. Logical Database Design 00:04:29
    2. Physical Design Implications 00:04:08
    3. Understanding Collation 00:04:29
    4. Linked Servers 00:05:15
    5. Understanding NULLs 00:05:35
    6. ANSI NULLs 00:05:56
    7. Handling Database Growth 00:06:07
    8. Linked Servers or Openrowset 00:04:59
    9. CPU Affinity 00:03:54
    10. Memory Allocation 00:03:07
    11. Managing SQL Server Memory 00:05:28
  6. Designing Tables
    1. Table Basics 00:04:55
    2. Temp Tables 00:04:24
    3. Table Variables 00:05:03
    4. Common Table Expressions 00:05:34
    5. Transaction Basics 00:05:19
    6. Explicit & Implicit Transactions 00:05:27
    7. Transaction Impact on Performance 00:03:51
    8. Planning with Concurrency in Mind 00:06:15
    9. Locking Basics 00:04:42
    10. Lock Types & Escalation 00:05:23
    11. Schema Basics 00:05:05
    12. Creating Schemas 00:04:24
  7. Indexing
    1. Understanding Indexes 00:03:06
    2. Understanding Data Distribution 00:05:53
    3. Clustered Indexes 00:03:28
    4. Non-Clustered Indexes 00:03:00
    5. Indexing Best Practices 00:03:39
    6. Reorganizing & Rebuilding Indexes 00:04:13
    7. Which Should I Use? 00:02:22
    8. Understanding Index Fragmentation 00:03:43
    9. Understanding Index Internals pt. 1 00:05:43
    10. Understanding Index Internals pt. 2 00:03:57
    11. Understanding Fillfactor 00:05:15
  8. Programming Objects
    1. Stored Procedure Basics 00:05:15
    2. Advantages of Stored Procedures 00:04:37
    3. Stored Procedure Best Practices 00:03:46
    4. Understanding Views 00:04:43
    5. Understanding Indexed Views 00:04:12
  9. Database Server Maintenance
    1. SQL Server Agent 00:04:49
    2. Understanding Jobs 00:03:27
    3. Understanding Alerts 00:03:23
    4. Understanding Operators 00:03:08
    5. Understanding Schedules 00:03:39
    6. Creating a Job 00:04:31
    7. Database Maintenance Plans 00:03:57
    8. Creating a Maintenance Plan 00:06:01
    9. Maintenance Plan Design Surface 00:06:37
    10. Multiserver Administration 00:04:35
    11. Ensuring Good Database Health 00:06:19
    12. DMVs 00:04:57
    13. SQL Server 2012 DMVs 00:04:32
    14. Getting to Know Your DMVs 00:05:47
  10. Monitoring Performance
    1. Performance Monitoring Basics 00:05:17
    2. Performance Monitor 00:04:00
    3. Counters To Watch 00:05:52
    4. Monitoring Locks 00:06:02
    5. SQL Server Profiler pt. 1 00:03:22
    6. SQL Server Profiler pt. 2 00:06:00
  11. Designing Backup & Recovery
    1. Backup & Recovery Planning 00:05:56
    2. Transaction Log Basics 00:04:44
    3. Understanding Recovery Models 00:04:48
    4. Setting the Recovery Model 00:02:23
    5. Understanding Database Snapshots 00:04:50
    6. Using Database Snapshots 00:04:24
    7. High Availability Options 00:05:24
  12. Conclusion
    1. Course Wrap Up 00:03:58
  13. Credits
    1. About the Author 00:02:38