Module 1: Module 1-1: Installing and Configuring SQL Server 2005

This module introduces views and summarizes the advantages that they provide. It describes how to create views by using Microsoft SQL Server Management Studio and Transact-SQL, the options available, and how to find information about views. The module then addresses restrictions on modifying data through views and how views can improve database performance.

Lessons

• SQL Server 2005 Architecture
• Preparing to Install SQL Server 2005
• Installing SQL Server 2005
• Installing and Configuring Administrative Tools
• SQL Server 2005 Conformation Tools

Lab: Lab 1-1 Installing SQL Server 2005

After completing this module, students will be able to:

Module 2: Module 1-2: Creating Databases and Database Files

This module describes how data is stored in SQL Server 2005. It provides information on how to create filegroups, databases, and schemas. It also covers the aspects of creating database snapshots and managing them.

Lessons

• Planning Data Storage for SQL Server 2005
• Creating Databases and File Storage
• Understanding Name Resolution and Creating Schemas
• Creating Database Snapshots
• Managing Databases

Lab: Lab 1-2 Creating Databases and Database Files

After completing this module, students will be able to:

Module 3: Module 2-1: Creating Data Types and Tables

It is important to know the characteristics of the various data types so that you can assign the appropriate data values for any column in an SQL Server database table. SQL Server provides a number of data types that are associated with the categories of data types used by common programming languages. This module describes the characteristics of the various SQL Server data types.

Lessons

• What Are Data Types?
• Creating Data Types
• Creating Tables
• Creating Partitioned Tables

Lab: Lab 2-1 Creating Data Types and Tables

After completing this module, students will be able to:

Module 4: Module 2-2: Querying SQL Server 2005 Databases

This module provides the knowledge and skills to perform basic Transact SQL queries in Microsoft SQL Server 2005. It also provides an overview of T-SQL and shows how to retrieve, group, summarize, and modify data. It provides an overview of querying multiple tables by using different types of joins, and gives you the foundation to query XML data by using XQuery.

Lessons

• What is T-SQL?
• Retrieving Data
• Grouping and Summarizing Data
• Modifying Data
• Working with XML Data

Lab: Lab 2-2 Querying SQL Databases

After completing this module, students will be able to:

Module 5: Module 3-1: Managing Security in SQL Server 2005

Security is a primary consideration when designing and managing a database environment. In this module, you will learn about the Microsoft SQL Server security model in SQL Server 2005, which is considerably enhanced and extended from previous versions of SQL Server.

Lessons

• SQL Server 2005 Security Overview
• Managing SQL Server 2005 Security
• Monitoring SQL Server 2005
• Automating SQL Server 2005 Administration

Lab: Lab 3-1 Managing SQL Security

After completing this module, students will be able to:

Module 6: Module 3-2: Disaster Recovery

Frequently, the data in a database substantiates an organization