Microsoft SQL Server 2008 Development VTC Tutorials
English | 90 mins | 800x600 | 25fps | MP3 - 131kbs | 241MB
Genre: Video training

Microsoft SQL Server 2008 relational database management server is the heart of a comprehensive data platform that provides access and managment of the business critcal data that powers business. In this course, Microsoft Certified Trainer Mark Long introduces you to the basics of SQL Server 2008 Database Development. Work files are included.

Introduction
Welcome (01:58)
Course Overview (04:48)
SQL Server Basics (06:36)
Getting Hands On (04:04)
Microsoft SQL Certifications (05:24)
SQL Server Editions (05:48)
SQL Server Developer (03:39)
Getting Set Up
Hardware Requirements (03:48)
SQL Server Instances (04:27)
SQL Server Components (04:11)
Service Accounts (05:24)
Installing SQL Server 2008 pt. 1 (05:37)
Installing SQL Server 2008 pt. 2 (03:56)
Installing SQL Server 2008 pt. 3 (04:06)
SQL Authentication Modes (04:49)
Installing Sample Databases pt. 1 (05:46)
Installing Sample Databases pt. 2 (03:35)
Database Design
Database Types (05:56)
Normalization (06:25)
Normalization Benefits (05:15)
Database Diagrams (05:43)
Systematic Database Design (06:14)
Designing Database Objects (05:21)
Tables & Views
Table Basics (04:40)
Creating a Table pt. 1 (03:41)
Creating a Table pt. 2 (06:53)
Creating a Table pt. 3 (05:06)
Data Types (05:11)
Unicode Basics (05:27)
New Data Types In 2008 (04:16)
Character Types (05:46)
Exact Numerics (05:28)
Approximate Numeric Types (02:50)
Date & Time (05:08)
Null or Not Null (05:15)
Primary Key (04:32)
Foreign Key (04:35)
Candidate Key (03:22)
Retrieving Data
The Select Statement (05:16)
Column Aliases (03:00)
Joining Tables pt. 1 (04:47)
Joining Tables pt. 2 (03:50)
Scalar Functions (04:29)
UDF (06:00)
Modifying Data
Inserting Data (05:36)
Updating Data (02:44)
Deleting Data (02:26)
Output Clause (05:17)
Merge Clause (02:38)
Managing Transactions
Understanding Transactions (05:33)
Explicit Transactions (04:00)
Transaction Isolation Levels (06:20)
Programming Objects
Understanding Views (05:25)
Indexed Views (04:46)
Understanding Stored Procs (05:53)
Creating Stored Procs (05:04)
Using Parameters (05:51)
Temporary Tables (05:41)
Common Table Expressions (05:34)
Table Variables (05:32)
Temp Common or Table (05:52)
Dynamic SQL (04:53)
Indexes
Understanding Indexes (05:38)
Indexing Guidelines (04:56)
Clustered or Non-Clustered (04:57)
Creating Indexes (05:16)
Monitoring Indexes (06:19)
Course Wrap-Up
Course Wrap-Up (05:11)
Credits
About The Author (02:42)

Download
http://www.filesonic.com/file/2704574774/VTC.Microsoft.SQL.Server.2008.Development-iNKiSO.rar

Mirror For Japan, EU, UAE, China, Au, Ru, SA, Brazil and Sing...
http://downloadine.net/dl/29A60669G0/VTC.Microsoft.SQL.Server.2008.Development-iNKiSO.rar