Testout SQL Server - 2005

e-Book & Magazine. March 29, 2011 by sputnik.

Testout SQL Server 2005
English | 2005 | 866 pages | PDF | 480 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
Fileserve


http://www.fileserve.com/file/Q5bRFxM/TSQL.part1.rar
http://www.fileserve.com/file/5HXZ9b7/TSQL.part2.rar
http://www.fileserve.com/file/7MQfZuZ/TSQL.part3.rar


Filesonic


http://www.filesonic.com/file/309491441/TSQL.part1.rar
http://www.filesonic.com/file/309498311/TSQL.part2.rar
http://www.filesonic.com/file/309504001/TSQL.part3.rar

Download File

Here you can download files online. Unlimited access to all sources file with one click direct download link!
Share
  • Featured link
  • [29-03-2011]

Comment