SQL Server: Introduction

Course Overview

This course is designed for web developers who need to learn to build database applications which can take advantage of the powerful server-side features that Microsoft SQL Server provides. This is a practical and comprehensive introduction to building flexible, efficient, dynamic applications using SQL Server.

This three day course will enable you to create database schemas with robust integrity using constraints, calculated columns, view and triggers and to write efficient, optimised queries. You will also choose the right compilation strategies for your server-side code, write robust transaction processing code with efficient error handling and build powerful client-side applications with ADO programming. If you would like to tailor the following course content to meet your exact requirements, please give us a call.

Course content

Introduction to SQL Server
· Understanding a RDBMS

Installing SQL Server
· The SQL security and authentication
· An introduction to:
- Service manager
- Enterprise manager
- The Query Analyser

Databases and tables
· Using the Enterprise Manager
· Creating a simple table
· Creating Primary Keys identities
· Learn about SQL Server data types
· Setting constraints

Data retrieval
· The SQL SELECT statement
· Using Query Designer
· Creating simple SQL SELECT queries
· Using special operators

Relationships
· Defining relational entities
· Creating relationships
· Queries vs views
· Creating views
The Query analyser
· Query Analyser and Query window
· Using Scripts
· Creating Scripts to:
- Create / Drop database
Create / Drop table
- INSERT, SELECT, UPDATE and DELETE data

Learning SQL
· Using Distinct, Unique
· Using MAX(), MIN(), COUNT() AND AVG()
· Using Group By clauses
· The DATE and STRING functions
· INNER SELECTS

Creating views
· What are views?
· The advantages of views
· Build your own views

Stored Procedures
· The advantages of stored procedures
· Creating stored procedures
· Stored procedures: a practical exercise

Administering SQL Server
· Backing up databases
· Restoring databases
· Developing a maintenance plan to suit your requirements

Questions and answers