In this training course you will learn to implement and manage a Microsoft SQL Server 2008 database. You will also learn the query language Transact-SQL. The training course is part of the Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, implementation and maintenance.

Among the topics covered are installing SQL Server 2008, creating and managing database instances, security, database management, performance monitoring, backups and restoring, Transact-SQL and much more.

Installing on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance

  • Introduction
  • Installing Part 1
  • Installing Part 2
  • Installing Part 2 Demo 1
  • Installing Part 2 Demo 2

Getting familiar with SQL on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance

  • Getting Familiar With SQL Part 1
  • Getting Familiar With SQL Part 1 Demo
  • Getting Familiar With SQL Part 2
  • Getting Familiar With SQL Part 2 Demo
  • Getting Familiar With SQL Part 3
  • Getting Familiar With SQL Part 3 Demo

Types of Data on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance

  • Data Types
  • Data Types Demo

Databases on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance

  • Databases Part 1
  • Databases Part 1 Demo
  • Databases Part 2
  • Databases Part 2 Demo
  • Databases Part 3

Looking at Tables on Microsoft 70-432: SQL Server 2008, Implementation and Maintenance

  • Tables
  • Tables Demo

Module 6: Looking at Views

  • Views Part 1
  • Views Part 1 Demo
  • Views Part 2
  • Views Part 2 Demo
  • Views Part 3

Module 7: About Constraints

  • Constraints Part 1
  • Constraints Part 1 Demo
  • Constraints Part 2

Module 8: Looking at Stored Procedures

  • Stored Procedures Part 1
  • Stored Procedures Part 1 Demo
  • Stored Procedures Part 2

Module 9: Functions

  • Functions
  • Functions Demo

Modules 10: About Service Broker

  • Service Broker Part 1
  • Service Broker Part 2

Modules 11: Integrity

  • Data Integrity Part 1
  • Data Integrity Part 2

Modules 12: Permissions in SQL

  • Permissions Part 1
  • Permissions Part 1 Demo
  • Permissions Part 2

Modules 13: Accounts

  • Logins Roles And Credentials
  • Logins Roles And Credentials Demo

Modules 14: Security

  • Additional Security Tools
  • Additional Security Tools Demo

Modules 15: Backups/Restores

  • Backing Up And Restoring Databases Part 1
  • Backing Up And Restoring Databases Part 2
  • Backing Up And Restoring Databases Demo

Modules 16: Endpoints

  • Endpoints

Modules 17: Servers working together

  • Linking Servers

Modules 18: Triggers in SQL

  • Triggers

Modules 19: Replication between servers

  • Replication Part 1
  • Replication Part 2

Modules 20: Indexes

  • Performing Indexing And Full Text Searching

Modules 21: Transactions in SQL

  • Transaction And Locks

Modules 22: Data moves

  • Moving Data

Modules 23: Data specialties in SQL

  • Handling Specialty Data

Modules 24: Fault Tolerance

  • High-Availability Methods Part 1
  • High-Availability Methods Part 2

Modules 25: SQL Management

  • Maintaining And Automating SQL Server

Modules 26: SQL Management Monitoring

  • Monitoring And Optimizing SQL Server
  • Monitoring And Optimizing SQL Server Demo

Modules 27: SQL Management tools

  • SQL Server Management Tools

Module 28: Troubleshooting

  • Troubleshooting Techniques
  • Troubleshooting Techniques Demo

Module 29: Course Review

  • Course Review Part 1
  • Course Review Part 2
  • Course Review Part 3
  • Course Review Part 4
  • Course Review Part 5

Module 30: Common Questions

  • Common Student Questions Part 1
  • Common Student Questions Part 2

Module 31: Real World Scenarios

  • Real World Scenarios Part 1
  • Real World Scenarios Part 2