Introduction to Microsoft SQL Server

This course provides a two-day high level overview of Microsoft's SQL Server.

It is aimed at web developers who need to interact with SQL Server using ASP. The course provides an overview of the operation of SQL Server, basic database administration, and the explanation of common database concepts and tasks. It is not intended as a full introduction to SQL Server Database Administration, but gives all the information necessary for ASP Developers to use and administer SQL Server for data-driven web sites.

Delegates should be developers intending to use ASP. Either SQL Server 7 or 2000 can be used.

Relational Database Systems

• Normalizing a Database
• Overview of the SQL language
• Overview of Transact-SQL

Introduction to Microsoft SQL Server

• Components of SQL Server
• SQL Server database structure
• The SQL Server architecture
• The requirements for installing SQL Server

SQL Server management tasks

• Designing and implementing databases
• Database design issues
• Creating databases
• Maintaining databases

Creating and managing tables

• Creating tables
• Maintaining tables

Data integrity

• Understanding data integrity
• Implementing constraints

Indexes

• Designing indexing
• Implementing indexes

Joining tables

• Querying multiple tables
• Table joins

Queries

• Designing queries
• Changing data through queries
• Using functions
• Aggregate functions

Designing views

• Creating and managing views

Creating stored procedures

• Designing stored procedures
• Creating stored procedures
• Using parameters in stored procedures

Creating triggers

• Designing triggers
• Creating and managing triggers

Understanding transactions and locks

• Working with transactions
• Working with locks

Designing and configuring SQL Server security

• The security features of SQL Server
• Login IDs

Importing and exporting data

• Introduction to data transfer
• Bulk data transfers

Backing up & Restoring SQL Server databases

• Planning backups
• Performing a backup
• Restoring SQL Server databases
• Methods to restore databases
• Restoring databases and transaction logs
• Recovering system databases

Database Replication

• Introduction to replication

Data Source Names

• The role of DSN's in Web Applications
• Setting up a DSN
• DSN-less connections

This course includes full course notes and course materials. This outline can be tailored to specific client requirements