آموزش کامل sql 2000 در 14 سی دی به صورت حرفه ای

میتونید اونو از rapidshare دانولد کنید - اگه کسی هم امکان دانلود نداره به من پیغام بده تا سی دی هارو بهش بدم.

developer_reza@yahoo.com



سرفصل های اونم از قرار زیره:



MODULE 1



SQL Server Tour

SQL Server Editions

Graphical Tools

Exploring the Enterprise Manager

Working with SQL Server Books Online



Installing SQL Server

Multiple Instances

Installing an Instance of SQL Server

Configuring the Server



Designing and Creating a Database

Relational Database Design Principles



MODULE 2



Designing and Creating a Database (continued)

Implementing the Design



Basic Querying

Introduction to the Query Analyzer

Retrieving Data



MODULE 3



Basic Querying (continued)

Joining Tables



Action Queries

Modifying Data

Inserting Data

Updating Data

Deleting Data



MODULE 4



Using the Query Analyzer

Query Analyzer Features

The File Menu Items

The Edit Menu

Query Menu Items

Tools Menu Items

Window Menu Items

Help Menu Items



Programming With Transact-SQL

Overview of Transact-SQL

Using Built-In Functions



MODULE 5



Programming With Transact-SQL (continued)

Control of Flow

Error Handling



Transaction Processing

Transactions

Working with Locks

Monitoring Processes and Locks

Transaction Isolation

Blocking and Deadlocks



Creating Views

What is a View?



MODULE 6



Creating Views (continued)

Creating Views

Updating Views



Backups and Maintenance

Creating a Backup Strategy

Implementing Backups

Restoring from a Backup

The Database Maintenance Plan Wizard



Stored Procedures and Triggers

Building Stored Procedures



MODULE 7



Stored Procedures and Triggers (continued)

Building Stored Procedures (continued)

Building Triggers

Using INSTEAD OF Triggers



User-Defined Functions

User-Defined Functions in SQL Server 2000

Scalar Functions

Inline Table-Valued Functions

Multi-Statement Table-Valued Functions

Functions, Views, and Stored Procedures



MODULE 8



Advanced Queries and Linked Servers

Dynamic SQL

Transact-SQL Cursors

Handling Large Data Sets

Distributed Queries



Security

Security Overview

Authentication

Understanding Roles

Assigning Permissions



MODULE 9



Security (continued)

Application Roles



Monitoring, Tuning, and Configuration

Evaluating Performance

Monitoring with SQL Server Profiler

Tuning Queries

Working with Indexes

Indexed Views

Using the Index Tuning Wizard

Data Caching

The System Monitor



MODULE 10



Using System Objects

Exploring System Objects

DBCC



Automating Administration with SQL Agent

Configuring SQL Server Agent

Operators

Jobs

Alerts

Create an Alert



Data Transformation Services (DTS)

Introduction

The DTS Import/Export Wizard



MODULE 11



Data Transformation Services (DTS) (continued)

DTS Packages

Controlling DTS Workflow



Replication

Introduction to Replication

Implementing Replication



Publish SQL Server Data to the Web

Publishing Data to the Web

The Web Assistant Wizard

The SQL Server Web Stored Procedures

Scheduling Web Jobs



XML Features, Part I

XML Fundamentals



MODULE 12



XML Features, Part I (continued)

Generating XML from SQL Queries with FOR XML

Using FOR XML Explicit

Setting Up IIS for SQL Server

Accessing SQL Server Using a URL



XML Features, Part II

Creating XML Views with Annotated Schemas

Using Xpath to Retrieve SQL Server Data Directly

Using OpenXML to Work with XML Documents in Transact-SQL



MODULE 13



XML Features, Part II (continued)

Using Updategrams



Full Text Search

What is Full-Text Search?

Configuring Full-Text Search

Writing Full-Text Queries

Using Full-Text Search with Documents Stored in SQL Server



MODULE 14



Analysis Services

Understanding Analysis Services

Building a Simple Cube

Browsing Data from a Cube

Exploring MDX

Data Mining



English Query

Overview of English Query

Before You Start – Preparing Your Database

Creating and English Query Application

Deploying an English Query Application



   

اگه لینك rapidshare رو بزاری ممنون میشم

میتونی CD ها رو به صورت امانت به من قرض بدی ؟

salam age momkenee filhari toye site repaidshear gharar bedidi mamnon misham.. montazerre link fil ha hastam