Learning Network: AppDev Microsoft SQL Server 2005 with Andy Baron and Don Kiely (20 CD-ROMs)

AppDev Microsoft SQL Server 2005 with Andy Baron and Don Kiely (20 CD-ROMs)
20 CD | Bin | Language: English | 800x600 401Kbps | MP3 192Kbps| 11.16 Gb
Genre: Fighting | Martial Arts

The course contains over 90 hours of video training. 20 CD-ROMs
Course Content
CD 1 A Tour of SQL Server 2005
SQL Server 2005 Editions, Components, and Tools
Using SQL Server Management Studio (SSMS)
Working with Tables and Queries
New Transact-SQL Features
Business Intelligence Services

CD 2 Installing SQL Server 2005
Preparing for Installation
Upgrading an Earlier Version
Installation Steps
Configuring the Server

CD 3 Designing and Creating a Database
Relational Database Design Principles
Implementing the Design

CD 4 Data Selection Queries
Understanding Transact-SQL
The SELECT Statement
The WHERE Clause
Using ORDER BY to Sort Data
The GROUP BY Clause
Joining Tables

CD 5 Modifying Data
Modifying Data
Inserting Data
Updating Data
Deleting Data
Understanding Transaction Isolation

CD 6 Working with SQL Server Management Studio
Getting Started with SSMS
Exploring the Object Explorer
Working with the Query Editor
Using SQL Server Books Online

CD 7 Transact-SQL Programming
Overview of Transact-SQL
Using Built-In Functions
Controlling Flow
Ranking Results

CD 8 Transactions and Error Handling
Transaction Concepts
Applications and Transactions
Creating Explicit Transactions
Using TRY / CATCH Error Handling

CD 9 Creating Views
What Is a View?
Creating Views
Updating Data Using a View
Using Computed Columns
Indexed Views
Partitioned Views

CD 10 Creating Stored Procedures and Triggers
Creating Stored Procedures
Creating Triggers

CD 11 Creating User-Defined Functions
User-Defined Function Overview
Scalar Functions
Inline Table-Valued Functions
Multi-Statement Table-Valued Functions
Using Functions, Views, and Stored Procedures

CD 12 Using. NET Code in SQL Server 2005
Writing SQLCLR Code
SQLCLR Code Modules
Managing Code Modules
SQLCLR Security
T-SQL vs. . NET Code

CD 13 Advanced Query Techniques
Full-Text Search
Generating XML with FOR XML
Using APPLY
Creating Recursive Queries
Creating Pivot Queries
Executing Dynamic SQL

CD 14 Understanding and Implementing Security
Security Overview
Authentication
Authorization
Permissions
Data Encryption
Security Epilog

CD 1915 Analyzing and Tuning Performance
Evaluating Performance
Monitoring with SQL Server Profiler
Tuning Queries
Indexes and Partitions
Using the Database Engine Tuning Advisor
Understanding SQL Server Performance Problems

CD 16 Automating Administrative Tasks
SQL Server Agent
Maintenance Plans
SQL Management Objects (SMO)

CD 17 Programming Replication
Overview of SQL Server Replication
Replication Programming Interfaces
Configuring Replication
Synchronizing Data

CD 18 Using Integration Services
Importing and Exporting Data
Integration Services Tools
Building a Package
Troubleshooting a Package

CD 1919 Analysis Services
Understanding Analysis Services
Creating a Unified Dimensional Model
Data Mining

CD 20 Introduction to Reporting Services
Understanding Reporting Services
Configuring Reporting Services
Building a Simple Report
Creating, Publishing, and Viewing Reports
Using and Managing Published Reports
Download

http://i1189.photobucket.com/albums/z431/reevn/photo/preaccos.png

Learning Network

Monday, May 2, 2011

AppDev Microsoft SQL Server 2005 with Andy Baron and Don Kiely (20 CD-ROMs)

About Me

Followers

Books Collection

Blog Archive