Introduction to Microsoft SQL Server

Length: 5 Days
Prerequisites:  Prior knowledge of SQL, Basic Knowledge, Relational Database Theory


Overview

Learn the basics of Microsoft SQL Server and the SQL Server Language. Our instructors are hands-on Programmers,
Database Designers, and Database Administrators who will share their experiences while teaching the course material.

Key Benefits:  When you complete this course you will have learned: Client Server concepts, know the features
of Microsoft SQL Server. You will also be able to understand and implement SQL Server Database objects.

Outline


Chapter 1. Introduction to SQL Server

• SQL Server Distributive Management Framework
• Roles & Responsibilities of the Implementers

Chapter 2. Rules & Defaults

• Data Integrity
• Rules
• Defaults
• Rules & Defaults & User Defined Types

Chapter 3.  Database Design

• Tables
• Columns
• Domains
• Keys
• Referential Integrity
• Database Normalization

Chapter 4.  Views

• Creating and Dropping Views
• Uses

Chapter 5. System Databases

• Definition & Roles of System Database, master, model tempdb

Chapter 6. Constraints

• Check Constraints
• Key Constraints

 Chapter 7.  System Tables

• Definition of System Tables
• SQL Server Storage allocation (devices)

Chapter 8.  System Stored Procedures

• Details on Key Stored Procedures

Chapter 9.  Triggers & Stored Procedures

• Types of Stored Procedures
• Executing a Stored Procedure
• Dropping a Stored Procedure
• Showplan of a Procedure
• Creating a Trigger
• Dropping a Trigger
• Trigger vs Stored Procedures
• Triggers vs Constraints vs Rules and Defaults

Chapter 10. Databases

• Creating
• Altering & Dropping Databases
• Database System Catalog Tables

Chapter 11.  Batches & Scripts

• Limitations
• Use

Chapter 12.  Datatypes

• System Datatypes
• Creating User Defined Datatypes
• Removing User Defined Datatypes
• Nulls, not Nulls

Chapter 13.  Transaction Management

• Transaction Management Statements
• Transactions in Stored Procedures
• Distributive Transactions

Chapter 14.   Tables

• Creating Tables
• Table Placement
• Dropping Tables

Chapter 15.  Programming Constructs

• Cursors
• Case Statement
• Control-of=flow Statements
• Execute Statement

Chapter 16.  Retrieving Data

• The SELECT statement
• Limiting Columns
• Limiting Rows
• Sorting Data
• Using SELECT with VIEWS
• Aggregate Functions; GROUP B, HAVING, CUBE & ROLLUP
• --& COMPUTE, COMPUTE BY UNIONS Subqueries

Chapter 17.  Distributive Data

• Two-Phase Commit
• Open Data Services Library
• Function & Purpose
• Benefits
• Bulk Copy
• Replication
• What is Replication?
• Publishers
• Distributors
• Subscribers
• Replication Scenarios
• SQL Server Web Assistant

Chapter 18. Modifying Data

• INSERT
• DELETE
• SELECT INTO
• UPDATE

Chapter 19. SQL Server Extensibility

• SQL Server Extensions
• SQL Server Manager
• Extended Stored Procedures
• MAPI
• Using OLE
• Client-Side and Server-side APIs
• ODBC & DB-LIB

Chapter 20.  Indexes

• Types and Characteristics of Indexes
• Index Options
• Indexes & Performance

Back to Course Listing