Testout SQL Server 2005
English | 866 pages | PDF | 483 MB

Contains videos, demonstrations, fact sheets and exams

1.0 SQL Server

1.1 SQL Server Overview

1.1.1 Course Introduction
1.1.2 SQL Server 2005 Overview
1.1.3 SQL Server Editions
1.1.4 Server Edition Facts

1.2 Managment Tools

1.2.1 SQL Management Tools
1.2.2 Using Management Tools
1.2.3 SQL Tool Facts

1.3 Database Concepts

1.3.1 SQL Server Overview
1.3.2 Relational Database Concepts
1.3.3 SQL Databases
1.3.4 Database Objects
1.3.5 Data Types
1.3.6 Data Type Facts

1.4 Transact-SQL Overview

1.4.1 Query Facts
1.4.2 SQL Server Objects
1.4.3 Identifier Facts
1.4.4 Batch Facts

2.0 Installation (11 questions)

2.1 SQL Server Installation

2.1.1 SQL Server Installation
2.1.2 Installing SQL Server
2.1.3 Installation Requirements
2.1.4 Installation Facts

2.2 Upgrade and Coexistence

2.2.1 Using Named Instances
2.2.2 Instance Facts
2.2.3 Running the Upgrade Advisor
2.2.4 Upgrade Facts
2.2.5 ExamSim Questions Section 2.2

2.3 Post Installation

2.3.1 Configuring Server Properties
2.3.2 Configure Server Properties
2.3.3 Using the Surface Scan Area Utility
2.3.4 Configuring Services and Protocols
2.3.5 Services Facts
2.3.6 Net-Library Facts
2.3.7 SQL Server Configuration
2.3.8 Troubleshooting Installation
2.3.9 ExamSim Questions Section 2.3

3.0 Databases (9 questions)

3.1 Database Files

3.1.1 Database and Log Files
3.1.2 Managing Databases
3.1.3 Data File Facts
3.1.4 Create Database Facts
3.1.5 Create Database Files
3.1.6 Database Properties
3.1.7 Modify Database Properties
3.1.8 Create a Filegroup
3.1.9 ExamSim Questions Section 3.1

3.2 Recovery Model

3.2.1 Recovery Models
3.2.2 Setting the Recovery Model
3.2.3 Recovery Model Facts
3.2.4 Reset the Recovery Model
3.2.5 ExamSim Questions Section 3.2

3.3 Database Mail

3.3.1 Configuring Database Mail
3.3.2 Database Mail Facts
3.3.3 Configure Database Mail
3.3.4 ExamSim Questions Section 3.3

4.0 Database Objects (34 questions)

4.1 Tables

4.1.1 Tables
4.1.2 Table Facts

4.2 Constraints

4.2.1 Constraints
4.2.2 Using DEFAULT
4.2.3 Using CHECK
4.2.4 Using PRIMARY KEY
4.2.5 Using UNIQUE
4.2.6 Using FOREIGN KEY
4.2.7 Constraint Facts
4.2.8 Constraint Management Facts
4.2.9 ExamSim Questions Section 4.2

4.3 Indexes

4.3.1 Indexes
4.3.2 Creating Indexes
4.3.3 Index Facts
4.3.4 Index Management Facts
4.3.5 ExamSim Questions Section 4.3

4.4 Triggers

4.4.1 Triggers
4.4.2 Implementing DML Triggers
4.4.3 Implementing INSTEAD OF Triggers
4.4.4 DML Trigger Facts
4.4.5 DDL Triggers
4.4.6 Using DDL Triggers
4.4.7 DDL Trigger Facts
4.4.8 Nesting and Recursion
4.4.9 Nested and Recursive Triggers
4.4.10 ExamSim Questions Section 4.4

4.5 Views

4.5.1 Views
4.5.2 Creating Updatable Views
4.5.3 View Facts
4.5.4 ExamSim Questions Section 4.5

4.6 Stored Procedures

4.6.1 Stored Procedures
4.6.2 Defining a Stored Procedure
4.6.3 Stored Procedure Facts
4.6.4 Working with Managed Code
4.6.5 Managed Code Facts
4.6.6 ExamSim Questions Section 4.6

4.7 Functions

4.7.1 Function Facts
4.7.2 Using Functions
4.7.3 User-defined Functions
4.7.4 Implementing User-defined Functions
4.7.5 User-defined Function Facts
4.7.6 Identifying Deterministic Functions
4.7.7 Deterministic Function Facts
4.7.8 ExamSim Questions Section 4.7

Download

http://www.filesonic.com/file/325143791/T3st0utSQL.part1.rar
http://www.filesonic.com/file/325143801/T3st0utSQL.part2.rar