SQL Server 2005 is an integrated database management and analysis solution that allows you to create, deploy, and manage secure, scalable, and reliable enterprise applications. It also maximizes IT productivity because it reduces the intricacies involved in developing and supporting database applications. In addition, you can share data across multiple applications, platforms, and devices which makes connections to internal and external systems easier.

Outline

Introduction to SQL Server

• Overview of SQL Server
• Components of SQL Server
• Overview of SQL Server Architecture

Designing a SQL Server Database

• Introduction to Database Design
• Planning a SQL Server Database
• Identifying System Requirements
• Developing a Logical Data Model

Implementing SQL Server Databases and Tables

• Creating and Maintaining a SQL Server Database
• Identifying Data Types
• Creating and Managing Tables

Accessing and Modifying Data

• Accessing Data in a SQL Server Database
• Using Advanced Queries to Access Data
• Modifying Data in a SQL Server Database

Accessing and Modifying Data

• Importing and Exporting Data
• Using Distributed Queries to Access External Data

Retrieving and Modifying Data

• Referring to a SQL Server object
• Transact-SQL
• System functions
• Collation precedence
• Using the SELECT statement
• Clauses for the SELECT statement
• Subqueries
• Using the DELETE statement
• Using the UPDATE statement
• Using the INSERT statement
• Bulk copy operations
• Data Transformation Services

Implementing Stored Procedures

• Intro to Stored Procedures
• Creating, Modifying, and Deleting Stored Procedures
• Programming Stored Procedures

Implementing Triggers

• Intro to Triggers
• Creating and Managing Triggers
• Programming Triggers

Implementating View

• Intro to Views
• Creating, Modifying Views
• Accessing Data with Views

SQL Server Administration and Security

• Overview of SQL Server Security
• Designing a SQL Server Security Plan
• Database Security Implementation and Administration