21.Implementing Database Mirroring

20.Implementing AlwaysOn Availability Groups

19.Managing and Troubleshooting Security

18.Managing Users and Database Roles

17.Managing Logins and Server Roles

16.Importing and Exporting Data

15.Implementing and Maintaining Indexes

14.Restoring Databases

13.Implementing a Backup Strategy

12.Auditing SQL Server

11.Troubleshooting SQL Server

10.Identifying and Resolving Concurrency Issues

9.Implementing a Clustered Instance

8.Configuring and Managing Instances

7.Configuring and Managing Databases

6.Managing SQL Server Agent

5.Configuring SQL Server Components

4.Implementing a Migration Strategy

3.Installing SQL Server 2012

2.Planning a SQL Server 2012 Installation

1.Introduction to 70 462 Administering SQL Server 2012

20.Introduction to Reporting with SQL Server Reporting Services

19.Introduction to Transforming Data with SQL Server Integration ServicesSSIS

18.Introduction to Messaging with SQL Server Notification ServicesSSNS

17.Working with Managed Code

16.Working with XML Data

15.Creating and Using Userdefined Functions

14.Creating and Using Stored Procedures

13.Creating ang Using Views

12.Implementing Indexes

11.Designing and Creating Tables

10.Creating,Managing and Maintaining Databases

9.T SQL Language Primer

8.Automating Tasks With SQL Server Agent

7.Implementing Replication

6.Maintaining High Availability

5.Monitoring Activity and Performance

4.Implementing Disaster Recovery

3.Implementing Security

2 Installing and Configuring SQL Server 2005

1.Introduction to SQL Server 2005

69.Course Wrap Up - SQL Server 2008

68.Log Shipping - SQL Server 2008

67.Database Mirroring - SQL Server 2008

66.Failover Clustering - SQL Server 2008

65.High Availability Options - SQL Server 2008

64.Database Tuning Advisor pt 2 - SQL Server 2008

63.Database Tuning Advisor pt 1 - SQL Server 2008

62.Partition Planning - SQL Server 2008

61.Partitions - SQL Server 2008

60.Using Filegroups - SQL Server 2008

59.Event Forwarding - SQL Server 2008

58.Log File Viewer - SQL Server 2008

57.SQL Profiler pt 2 - SQL Server 2008

56.SQL Profiler pt 1 - SQL Server 2008

55.Dedicated Administrator Connection - SQL Server 2008

54.Restoring the Database - SQL Sever 2008

53.Managing the Transaction Log - SQL Server 2008

52.Backup Devices - SQL Server 2008

51.Backup Compression - SQL Server 2008

50.Database Backup pt 2 - SQL Server 2008

49.Database Backup pt 1 - SQL Server 2008

48.Maintaining the Database - SQL Server 2008

47.Database Mail pt 3 - SQL Server2008

46.Database Mail pt 2 - SQL Server 2008

45.Database Mail pt 1 - SQL Server 2008

44.Activity Monitor - SQL Server 2008

43.Server Configuration - SQL Server 2008

42.Registering Servers - SQL Server 2008

41.SQL Server Options - SQL Server 2008

40.Understanding Alerts - SQL Server 2008

39.Understanding Jobs - SQL Server 2008

38.Understanding Operators - SQL Server 2008

37.Creating a Maintenance Plan- SQL Server 2008

36.SQL Server Agent- SQL Server 2008

35.Hiding System Objects in SQL Server 2008

34.Installing Sample Databases pt 2 - SQL Server 2008

33.Installing Sample Databases pt 1-SQL Server 2008

32.Moving Data Files in SQL Server 2008

31.Creating a Schema in SQL Server 2008

30.Default Schema in SQL Server 2008

29.Schemas in SQL Server 2008

28.Sizing the Transaction Log in SQL Sever 2008

27.Database Options in SQL Server 2008

26.Autogrowth in SQL Server 2008

25.Creating a Database in SQL Server 2008

24.File Placement in SQL Server 2008

23.System Databases in SQL Server 2008

22.Transaction Log in SQL Server 2008

21.File Types in SQL Server 2008

20.SQL Server Management Studio

19.Changing Authentication Modes in SQL Server

18.SQL Server Authentication Modes

17.SQL Server Configuration Manager

16.Upgrading SQL Server 2008

15.Installing SQL Server 2008 pt3

14.Installing SQL Server 2008 pt 2

13.Installing SQL Server 2008 pt 1

12.Creating Service Accounts in SQL Server

11.Service Accounts in SQL Server 2008

10.Collation Choices in SQL Server

9.SQL Server Components

8.SQL Server Instances

7.Hardware Requirements for SQL Server DBA

6.SQL Server Editions

5.Microsoft SQL Certifications

4.Getting Hands On SQL Server 2008 Administration

3.SQL Server Basics

2.Course Overview in SQL Server 2008 Administration

1.Welcome To SQL Server 2008 Administration

22.Next Steps in SQL Server 2008

21.Preparing for Your MCITP 70 645 Certification Exam

20.SQL Server 2008 Integration Services

19.SQL Server 2008 PowerShell

18.SQL Server 2008 Performance Tuning

17.Monitoring SQL Server 2008

16.Resource Governor

15.SQL Server 2008 Replication

14.SQL Server 2008 Log Shipping

13.SQL Server 2008 Database Mirroring

12.SQL Server 2008 Failover Clustering

11.SQL Server 2008 High Availability

10.SQL Server 2008 Backup and Recovery

9.SQL Server 2008 Data Encryption

8.SQL Server 2008 Policy Based Management

7.SQL Server 2008 Security

6.Full Text Search in SQL Server 2008

5.Optimizing SQL Searches with Indexes