Administering MS SQL server 2012 Databases Certification Training

Administering Microsoft SQL Server 2012 Databases (Exam 70-462)

• Lesson 00 - Course Overview

  06:19Preview

  • 0.1 Course Overview

    00:47

  • 0.2 Table of Contents

    00:43

  • 0.3 Objectives

    00:26

  • 0.4 Course Overview

    00:46

  • 0.5 Course Overview (contd.)

    00:55

  • 0.6 Value of Administering SQL Server 2012 for Professionals

    00:47

  • 0.7 Value of Administering SQL Server 2012 for Organizations

    00:38

  • 0.8 Lessons Covered

    00:11

  • 0.9 Exam Pattern

    00:24

  • 0.10 Administering SQL Server 2012 Certification

    00:14

  • 0.11 Sources of Information

    00:14

  • 0.12 Conclusion

    00:14

• Lesson 01 - SQL Server Tools and Installation

  35:18Preview

  • 1.1 SQL Server Tools and Installation

    00:22

  • 1.2 Objectives

    00:38

  • 1.3 SQL Server 2012 Components and Their Uses

    00:09

  • 1.4 SQL Server 2012 Components

    02:33

  • 1.5 Database Engine

    00:50

  • 1.6 Integration Services

    00:54

  • 1.7 Reporting Services

    01:12

  • 1.8 Analysis Services

    00:38

  • 1.9 Planning SQL Server Installation

    00:21

  • 1.10 Installation Requirements

    02:45

  • 1.11 32-Bit vs. 64-Bit Architecture

    02:14

  • 1.12 Scaling

    01:04

  • 1.13 Planning Storage

    03:09

  • 1.14 SQL Server Instances

    01:45

  • 1.15 Installing SQL Server 2012

    00:15

  • 1.16 Steps to Install SQL Server 2012

    02:41

  • 1.17 Steps to Install SQL Server 2012 (contd.)

    01:28

  • 1.18 Security Considerations

    01:54

  • 1.19 Installing SQL Server 2012

    00:12

  • 1.20 Installing SQL Server 2012 Demo 01

    07:11

  • 1.21 Exploring the Installed Components

    00:06

  • 1.22 Exploring the Installed Components Demo2

    01:32

  • 1.23 Quiz

  • 1.24 Summary

    00:42

  • 1.25 Summary (contd.)

    00:42

  • 1.26 Conclusion

    00:01

• Lesson 02 - Managing the Database Server

  26:40Preview

  • 2.1 Managing the Database Server

    00:26

  • 2.2 Objectives

    00:24

  • 2.3 Server Properties and sp configure

    00:12

  • 2.4 Server Properties

    00:55

  • 2.5 Using sp configure

    01:04

  • 2.6 RECONFIGURE Command

    01:26

  • 2.7 Viewing Server Properties and Using sp configure

    00:12

  • 2.8 Viewing Server Properties and Using sp configure Demo 01

    02:15

  • 2.9 Advanced Options

    00:50

  • 2.10 Default Values of sp configure

    00:45

  • 2.11 Enabling Advanced Options, and Viewing and Modifying Them

    00:06

  • 2.12 Enabling Advanced Options, and Viewing and Modifying Them Demo 02

    01:40

  • 2.13 CPU and Memory Architectures

    00:10

  • 2.14 Constraints in Processor Switching

    02:07

  • 2.15 Affinity Masks in SQL Server

    01:12

  • 2.16 Calculating CPU Affinity

    00:58

  • 2.17 SQL Server 2012 Enhancements

    00:54

  • 2.18 Memory Properties

    01:29

  • 2.19 Working with CPU Affinity and Memory Configurations

    00:08

  • 2.20 Working with CPU Affinity and Memory Configurations Demo 03

    03:06

  • 2.21 Configuring Database Mail

    00:09

  • 2.22 Database Mail

    00:45

  • 2.23 Setting up Database Mail

    01:13

  • 2.24 Sending a Mail

    00:42

  • 2.25 Set up Database Mail

    00:05

  • 2.26 Set up Database Mail Demo 04

    02:36

  • 2.27 Quiz

  • 2.28 Summary

    00:42

  • 2.29 Conclusion

    00:09

• Lesson 03 - Managing Databases

  34:10Preview

  • 3.1 Managing Databases

    00:20

  • 3.2 Objectives

    00:30

  • 3.3 Understanding Databases

    00:10

  • 3.4 Database Structure

    01:48

  • 3.5 Types of Databases

    00:52

  • 3.6 Contained Databases

    02:22

  • 3.7 Creating User and Contained Databases

    00:09

  • 3.8 Creating User and Contained Databases Demo 01

    02:36

  • 3.9 System Databases

    00:10

  • 3.10 System Database

    01:24

  • 3.11 Master Database

    00:49

  • 3.12 Model Database

    01:01

  • 3.13 TempDB Database

    01:08

  • 3.14 MSDB Database

    00:59

  • 3.15 Database Options

    00:10

  • 3.16 Auto Close

    01:43

  • 3.17 Auto Shrink

    01:06

  • 3.18 File Space

    01:01

  • 3.19 Moving between Filegroups

    01:19

  • 3.20 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database

    00:07

  • 3.21 Looking at Auto Close and Auto Shrink, and Checking Disk Space of a Database Demo 02

    02:44

  • 3.22 Moving between File Groups

    00:07

  • 3.23 Moving between File Groups Demo 03

    05:02

  • 3.24 Recovery Models

    00:10

  • 3.25 Recovery Models

    00:46

  • 3.26 Simple

    01:47

  • 3.27 Full

    01:13

  • 3.28 Bulk Logged

    01:07

  • 3.29 Changing Recovery Model

    00:05

  • 3.30 Changing Recovery Model Demo 04

    00:24

  • 3.31 Quiz

  • 3.32 Summary

    00:53

  • 3.33 Conclusion

    00:08

• Lesson 04 - SQL Server Security

  35:40Preview

  • 4.1 SQL Server Security

    00:20

  • 4.2 Objectives

    00:23

  • 4.3 Security Model and Types of Accounts in SQL Server

    00:08

  • 4.4 Security Layers

    01:15

  • 4.5 Windows Accounts

    01:44

  • 4.6 SQL Server Accounts

    02:26

  • 4.7 Login Accounts

    01:07

  • 4.8 Using Accounts in SQL Server

    00:14

  • 4.9 Using Accounts in SQL Server Demo 01

    04:55

  • 4.10 Server Roles

    00:07

  • 4.11 Rights

    00:51

  • 4.12 Server Roles

    01:29

  • 4.13 Fixed Server Roles

    03:02

  • 4.14 Custom Server Roles

    01:30

  • 4.15 Managing Server Roles

    00:12

  • 4.16 Managing Server Roles Demo 02

    02:24

  • 4.17 Managing Permissions

    00:12

  • 4.18 GRANT

    01:01

  • 4.19 WITH GRANT

    01:06

  • 4.20 DENY

    00:54

  • 4.21 Using GRANT and DENY

    00:11

  • 4.22 Using GRANT and DENY Demo 03

    03:08

  • 4.23 Database Roles and Permissions

    00:15

  • 4.24 Database Roles

    00:23

  • 4.25 Fixed Database Roles

    01:42

  • 4.26 Custom Database Roles

    00:25

  • 4.27 Using Database Roles

    00:06

  • 4.28 Using Database Roles Demo 04

    03:19

  • 4.29 Quiz

  • 4.30 Summary

    00:42

  • 4.31 Conclusion

    00:09

• Lesson 05 - Advanced Security in SQL Server

  42:52Preview

  • 5.1 Advanced Security in SQL Server

    00:19

  • 5.2 Objectives

    00:22

  • 5.3 Working with Digital Certificates

    00:12

  • 5.4 Digital Certificates

    02:18

  • 5.5 Private and Public Keys

    02:28

  • 5.6 Keys in SQL Server

    01:08

  • 5.7 Certificate Based Logins

    00:37

  • 5.8 Certificate Based Logins (contd.)

    00:38

  • 5.9 Creating Certificate Based Logins

    00:08

  • 5.10 Creating Certificate Based Logins Demo 01

    04:14

  • 5.11 Auditing and Policies

    00:07

  • 5.12 SQL Server Auditing

    01:33

  • 5.13 Audit Specifications

    01:14

  • 5.14 Audit Reports

    01:02

  • 5.15 Creating and Viewing Audits

    00:14

  • 5.16 Creating and Viewing Audits Demo 2

    05:35

  • 5.17 Policy Based Management

    00:15

  • 5.18 Policy

    00:55

  • 5.19 Advantages of Policy

    01:03

  • 5.20 Components of Policy

    00:58

  • 5.21 Setting up Policy Based Management

    00:08

  • 5.22 Setting up Policy Based Management Demo 3

    05:24

  • 5.23 Encryption and Compression

    00:13

  • 5.24 Encryption in SQL Server

    00:26

  • 5.25 Transparent Data Encryption

    01:30

  • 5.26 Column Level Encryption

    01:09

  • 5.27 Compression

    00:49

  • 5.28 Using TDE and Compression

    00:09

  • 5.29 Using TDE and Compression Demo 4

    06:58

  • 5.30 Quiz

  • 5.31 Summary

    00:36

  • 5.32 Conclusion

    00:10

• Lesson 06 - Working with Indexes and Files

  39:43Preview

  • 6.1 Working with Indexes and Files

    00:21

  • 6.2 Objectives

    00:20

  • 6.3 Understanding Indexes

    00:15

  • 6.4 Indexes

    03:14

  • 6.5 Index Types

    01:48

  • 6.6 Other Index Types

    01:04

  • 6.7 Adding an Index to a Table

    00:06

  • 6.8 Adding an Index to a Table Demo 01

    01:47

  • 6.9 Introduction to Full Text Indexing

    00:12

  • 6.10 Need for Full Text Indexing

    01:28

  • 6.11 Full Text Indexing

    02:58

  • 6.12 Full Text Search

    04:17

  • 6.13 Setting up FTI and Querying Using FTS

    00:08

  • 6.14 Setting up FTI and Querying Using FTS Demo 02

    04:18

  • 6.15 New Index Types in SQL Server 2012

    00:11

  • 6.16 Column Store Index

    02:01

  • 6.17 FILESTREAM

    00:56

  • 6.18 FILETABLE

    00:59

  • 6.19 Using a Column Store Index

    00:05

  • 6.20 Using a Column Store Index Demo 03

    01:44

  • 6.21 Setting up New iFilters for FTI

    00:08

  • 6.22 Setting up New iFilters for FTI Demo 04

    02:20

  • 6.23 Setting up a New FILETABLE

    00:08

  • 6.24 Setting up a New FILETABLE Demo 05

    07:52

  • 6.25 Quiz

  • 6.26 Summary

    00:52

  • 6.27 Conclusion

    00:11

• Lesson 07 - Maintaining Reliability of SQL Server Installations

  25:53Preview

  • 7.1 Maintaining Reliability of SQL Server Installations

    00:25

  • 7.2 Objectives

    00:20

  • 7.3 Detaching and Attaching Databases

    00:09

  • 7.4 Detaching a Database

    01:53

  • 7.5 Attaching a Database

    00:46

  • 7.6 Detach and Attach a Database

    00:06

  • 7.7 Detach and Attach a Database Demo 01

    01:29

  • 7.8 Database Backup and Restoration

    00:13

  • 7.9 Backups

    02:31

  • 7.10 Backup Strategies

    01:20

  • 7.11 Restore

    00:41

  • 7.12 Scheduling Backups

    00:45

  • 7.13 Backup, Restore, and Scheduling of Backup

    00:09

  • 7.14 Backup, Restore, and Scheduling of Backup Demo 02

    02:26

  • 7.15 High Availability

    00:10

  • 7.16 What Is High Availability

    00:54

  • 7.17 Clustering

    02:07

  • 7.18 Replication

    02:15

  • 7.19 Mirroring

    00:40

  • 7.20 AlwaysOn

    00:48

  • 7.21 Set up an SQL Server Cluster

    00:05

  • 7.22 Set up an SQL Server Cluster Demo 03

    04:49

  • 7.23 Quiz

  • 7.24 Summary

    00:42

  • 7.25 Conclusion

    00:10

• Lesson 08 - Optimizing Servers

  20:02Preview

  • 8.1 Optimizing Servers

    00:20

  • 8.2 Objectives

    00:18

  • 8.3 Benchmarking Server Performance

    00:09

  • 8.4 System Benchmarks

    01:01

  • 8.5 Resource Governor

    00:56

  • 8.6 PerfMon

    01:01

  • 8.7 Using Resource Governor and PerfMon

    00:09

  • 8.8 Using Resource Governor and PerfMon Demo 01

    04:16

  • 8.9 DMVs and SQL Profiler

    00:09

  • 8.10 Dynamic Management View (DMV)

    01:11

  • 8.11 SQL Profiler

    01:17

  • 8.12 Using DMVs

    00:07

  • 8.13 Using DMVs Demo 02

    02:58

  • 8.14 Using SQL Profiler

    00:07

  • 8.15 Using SQL Profiler Demo 03

    00:07

  • 8.16 Optimizing Indexes

    00:10

  • 8.17 Index Statistics

    00:57

  • 8.18 Fragmentation of Indexes

    01:09

  • 8.19 View Index Statistics

    00:05

  • 8.20 View Index Statistics Demo 04

    02:19

  • 8.21 View and Rebuild Index to Reduce Fragmentation

    00:05

  • 8.22 View and Rebuild Index to Reduce Fragmentation Demo 05

    00:27

  • 8.23 Quiz

  • 8.24 Summary

    00:35

  • 8.25 Conclusion

    00:09

• Lesson 09 - Troubleshooting Errors in SQL Server

  21:02Preview

  • 9.1 Troubleshooting Errors in SQL Server

    00:22

  • 9.2 Objectives

    00:20

  • 9.3 SQL Server Errors and Handling Issues

    00:07

  • 9.4 SQL Server Errors

    00:50

  • 9.5 Database Console Commands

    00:53

  • 9.6 DBCC Error Handling

    00:57

  • 9.7 Using DBCC

    00:11

  • 9.8 Using DBCC Demo 01

    01:57

  • 9.9 Traces

    00:07

  • 9.10 Trace Flags

    02:01

  • 9.11 Using Trace Flags

    00:05

  • 9.12 Using Trace Flags Demo 02

    02:03

  • 9.13 Extended Events

    00:08

  • 9.14 What Are Extended Events

    00:25

  • 9.15 Use XEvents

    00:06

  • 9.16 Use XEvents Demo 03

    02:46

  • 9.17 Database Recovery

    00:07

  • 9.18 Database Failure

    01:12

  • 9.19 Recovering a Database without a Backup

    00:08

  • 9.20 Recovering a Database without a Backup Demo 04

    05:33

  • 9.21 Quiz

  • 9.22 Summary

    00:34

  • 9.23 Conclusion

    00:10

• Lesson 10 - Advanced Server Management

  36:44Preview

  • 10.1 Advanced Server Management

    00:20

  • 10.2 Objectives

    00:19

  • 10.3 Virtualization and SQL Server

    00:07

  • 10.4 What Is Virtualization

    02:15

  • 10.5 SQL Server and Virtualization

    01:20

  • 10.6 Running SQL Server in a Virtual Environment

    00:09

  • 10.7 Running SQL Server in a Virtual Environment Demo 01

    01:40

  • 10.8 Updating SQL Server

    00:07

  • 10.9 Updates Management

    02:12

  • 10.10 Patch Deployment

    02:06

  • 10.11 Updating SQL Server 2012

    00:06

  • 10.12 Updating SQL Server 2012 Demo 02

    06:07

  • 10.13 Data Tier Applications

    00:12

  • 10.14 Client Application Connections

    01:58

  • 10.15 Data Tier Applications

    01:58

  • 10.16 Deployment Process

    02:09

  • 10.17 Deploy Structure to Different Databases Using DTA

    00:08

  • 10.18 Deploy Structure to Different Databases Using DTA Demo 03

    04:51

  • 10.19 Sync Changes Made to Main Database Using DTA

    00:08

  • 10.20 Sync Changes Made to Main Database Using DTA Demo 04

    03:33

  • 10.21 Export Data and Structure to a New Server Using DTA

    00:10

  • 10.22 Export Data and Structure to a New Server Using DTA Demo 05

    03:52

  • 10.23 Quiz

  • 10.24 Summary

    00:51

  • 10.25 Conclusion

    00:06