Sql Server Course

by Vibrant Technologies & Computers

Module

Title

Contents

Module 1:

INTRODUCTION TO SQL SERVER

Major Features
Limits
Editions
Installing SQL Server

Module 2:

Building a Database

Introducing SQL Server Management Studio
Databases
Tables
Indexes
Relations
Using T-SQL to build and alter objects

Module 3:

T-SQL Basics

What is SQL?
Reading syntax diagrams
Identifiers
Data types
Operators
Functions

Module 4:

SELECT Queries

The SELECT clause
The FROM clause
The WHERE clause
Using Joins
ORDER BY
GROUP BY and HAVING

Module 5:

DESIGNING AND IMPLEMENTING VIEWS

Introduction to Views
Creating and Managing Views
Performance Considerations for Views

Module 6:

PLANNING FOR SQL SERVER INDEXING

Core Indexing Concepts
Data Types and Indexes
Single Column and Composite Indexes

Module 7:

DESIGNING AND IMPLEMENTING STORED PROCEDURES

Introduction to Stored Procedures
Working With Stored Procedures
Implementing Parameterized Stored Procedures
Controlling Execution Context

Module 8:

MERGING DATA AND PASSING TABLES

Using the MERGE Statement
Implementing Table Types
Using Table Types as Parameters

Module 9:

CREATING HIGHLY CONCURRENT SQL SERVER APPLICATIONS

Introduction to Transactions
Introduction to Locks
Management of Locking
Transaction Isolation Levels

Module 10:

HANDLING ERRORS IN T-SQL CODE

Designing T-SQL Error Handling
Implementing T-SQL Error Handling
Implementing Structured Exception Handling

Module 11:

DESIGNING AND IMPLEMENTING USER-DEFINED FUNCTIONS

Designing and Implementing Scalar Functions
Designing and Implementing Table-valued Functions
Implementation Considerations for Functions
Alternatives To Functions

Module 12:

ENSURING DATA INTEGRITY THROUGH CONSTRAINTS

Enforcing Data Integrity
Implementing Domain Integrity
Implementing Entity and Referential Integrity

Module 13:

SQL CLR Integration

Introduction to SQL CLR Integration
Importing and Configuring Assemblies
Implementing SQL CLR Integration

Module 14:

STORING XML DATA IN SQL SERVER

Introduction to XML and XML Schemas
Storing XML Data and Schemas in SQL Server
Implementing the XML Data Type

Module 15:

QUERYING XML DATA IN SQL SERVER

Using the T-SQL FOR XML Statement
Getting Started with XQuery Shredding XML

Module 16:

WORKING WITH SQL SERVER SPATIAL DATA

Introduction to Spatial Data Working with SQL Server Spatial
Data Types Using Spatial Data in Applications

Module 17:

Triggers

INSERT triggers
DELETE triggers
UPDATE triggers
INSTEAD OF triggers
Recursive triggers
DDL triggers