Part Number: SQLSERV05S12
Instructor: Alison Balter, Bruce Jones, Alan Sugano
Running Time: Approx. 10 Hours
Includes: 12 CD's

SQL Server 2005 Phase I
1.0 Introduction to SQL Server
1.1 Basic Relational Database Design
1.2 SQL Server Basics
1.3 Getting to Know the SQL Server Management Studio
1.4 Creating SQL Server Databases

SQL Server 2005 Phase II
1.0 SQL Server Tables
1.1 Introduction to Basic Relational Database Design
1.2 Primary Key Constraints
1.3 Identity Columns
1.4 Computed Columns
1.5 User-Defined Data Type
1.6 Using Indexes
2.0 Working with Relationships
2.1 SQL Server Basics
2.2 Viewing Foreign Key Relationships
2.3 Tables and Columns
2.4 Relationship Name and Description
2.5 Establishing Referential Integrity
2.6 Deleting and Updating Rules
3.0 Getting to Know the SELECT Statement
3.1 Introduction to T-SQL
3.2 SELECT Statement
3.3 The FROM Clause
3.4 The WHERE Clause
3.5 The ORDER BY Clause
3.6 The DISTINCT Keyword
3.7 The FOR XML Clause
3.8 The TOP Clause
4.0 Building SQL Statements Based on Multiple Tables
4.1 Exploring Join Types
4.2 How the GROUP BY Clause Works
4.3 Using Aggregate Functions
4.4 The HAVING Clause
4.5 The UNION Queries
4.6 Working With Subqueries

SQL Server 2005 Phase III
1.0 Modifying Data with Action Queries
1.1 The Five Types of Action Queries
2.0 Getting to Know the T-SQL Functions
2.1 The T-SQL Language
2.2 String Functions
2.3 Date and Time Functions
2.4 Working with NULLS
3.0 Working with SQL Server Views
3.1 Working with Views
3.2 Creating Views Using SQL Server Management Studio
3.3 Using T-SQL to Create a View
4.0 More About Views
4.1 Creating Views Based on Data from Multiple Tables
4.2 Working with Subquery of a View
4.3 Working with Outer Joins
4.4 The Top Syntax
4.5 Sorting Results of a View
4.6 User-Defined Functions
4.7 Security Benefit of a View
4.8 Updateability of View Results
4.9 Modifying a View
4.10 Renaming a View
4.11 Deleting a SQL Server View
4.12 Indexed Views
4.13 How to Design Your Indexes Efficiently

SQL Server 2005 Phase IV
1.0 Using T-SQL to Design SQL Stored Procedures
1.1 Intro to Creating Stored Procedures in SQL Server
1.2 Using Declare
1.3 Using Constructs
2.0 Import Stored Procedure Techniques
2.1 The SET NOCOUNT ON Statement
2.2 The @@ Functions
2.3 Input and Output Parameters
2.4 Using Stored Procedures to Insert, Update, and Delete Data
2.5 Handling Errors in Stored Procedures
2.6 Using Transaction Statements
3.0 Stored Procedure Special Topics
3.1 Creating and Using a Temporary Table
3.2 Stored Procedures and Security
3.3 User-Defined Functions
3.4 Using Triggers

SQL Server 2005 Phase V
1.0 The Basics of ADO.NET

SQL Server 2005 Phase VI
1.0 Using VB.NET to Design SQL Stored Procedures
1.1 Stored Procedure Written in VB.NET
1.2 Variables in Stored Procedures
1.3 Determining the Logic Flow Within a Stored Procedure
1.4 Input and Output Parameters
1.5 Insert, Update, and Delte Data
2.0 VB.NET Special Topics
2.1 Using Temporary Tables
2.2 Error Handling in a VB.NET Stored PRocedure
2.3 Using Transactions
1.0 Using C# to Work With Stored Procedures
1.1 Using C# to Desing SQL Server Stored Procedures
1.2 C# Special Topics
1.3 Debugging Stored Procedures

SQL Server 2005 Phase VII
1.0 Using C# to Work With Stored Procedures
1.1 Using C# to Desing SQL Server Stored Procedures
1.2 C# Special Topics
1.3 Debugging Stored Procedures

SQL Server 2005 Phase VIII
1.0 SQL Server Authentication
1.1 SQL Server Security
1.2 SQL Server Authentication
1.3 Creating SQL Server Logins
1.4 Roles and Permissions
1.5 Understanding Ownership
2.0 SQL Server Permissions Validation
2.1 Types of Permissions
2.2 Using Rights for a Table
2.3 Permissions for a View
2.4 Column-Level Permissions
3.0 The Basics of Configuring & Maintaining SQL
3.1 SQL Server Hardware
3.2 Configuring SQL
3.3 Database Maintenance
4.0 Performance Monitoring
4.1 Executing a Query
4.2 Analyzing a Query
4.3 Using the Execution Plan and Client Statistics Tabs
4.4 Using Options to Queries Process

SPECIAL TOPICS Database Mirroring - Led by Alan Sugano
1.0 Database Mirroring
1.1 SQL Server Witness
1.2 Database Mirroring Steps
1.3 Database Mirror Wizard and Failover Test

SPECIAL TOPICS Hardware Sizing - Led by Alan Sugano
1.0 SQL 2005 Hardware Sizing
1.1 Hardware Sizing

SPECIAL TOPICS High Visibility - Led by Alan Sugano
1.0 SQL 2005 High Visibility
1.1 SQL Server 2005 High Availability
1.2 Log Shipping
1.3 Database Mirroring and Clustering
1.4 SAN Types, Active/Passive and Active/Active Clustering
1.5 Online Restore and Indexing
1.6 Fast Recovery, Snapshot and Mirroring

SPECIAL TOPICS Database Mirroring - Led by Alan Sugano
1.0 Neverfail Server Mirroring
1.1 Neverfail Modules, Ordering and Installation Summary
1.2 Neverfail Scope and Obtaining Neverfail License Keys
1.3 Neverfail Prerquisites and Anti-Virus Software
1.4 Neverfail Installation on the Primary Server
1.5 Neverfail Installation on the Secondary Server
1.6 Switchover and Switchback