Microsoft SQL Server Development

Description

Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft's SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!

PART 1: Introduction to SQL Server 2005

Lesson 1: SQL SERVER OVERVIEW (32 min)
1. Understanding Client Server Architecture
2. Introducing the Tools
3. Selecting an Addition
4. Creating Sample Databases

Lesson 2: USING MANAGEMENT STUDIO (23 min)
1. Arranging the Workspace
2. Registering Servers
3. Explaining Items in the Object Explorer
4. Explaining the Database Properties Dialog
5. Explaining the Columns Properties Dialog
6. Continuing with Object Explorer Items
7. Using the Query Editor

Lesson 3: DESIGNING RELATIONAL DATABASES (35 min)
1. Understanding Normalization
2. Discovering Patterns
3. Avoiding Over Complexity
4. Managing Optional Data
5. Creating Physical Keys
6. Using the Database Diagrammer Tool
7. Final Comments


Part 2: Selecting Data

Lesson 1: WORKING WITH SINGLE TABLE QUERIES (42 min)
1. Understanding Query Flow
2. Filtering Data with the Where Clause
3. Columns, Expressions & Scalar Functions
4. Using Case Expressions
5. Working with Nulls & Coalesce
6. Selecting Environment Functions
7. Working with Dates & Times
8. Parsing Strings
9. Converting Data
10. Sorting Data
11. Topping Off the Query with Predicates

Lesson 2: MERGING DATA WITH JOINS & UNIONS (25 min)
1. Working with Inner Joins
2. Using Left Outer Joins
3. Multiplying Data with Cross Joins
4. Referencing Self-Joins
5. Working with Complex Joins
6. Finding the Set Difference
7. Stacking Data with Unions

Lesson 3: WORKING WITH SUBQUERIES (19 min)
1. Using Subqueries as Expressions
2. Including Subqueries as Lists
3. Adding Subqueries as Derived Tables
4. Working with Correlated Subqueries
5. Solving for X with Relations Division

Lesson 4: AGGREGATING DATA (35 min)
1. Using the New Windowing Functions
2. Using Aggregate Functions
3. Grouping a Data Set
4. Nesting Aggregations
5. Filtering Groups & Adding Grand Totals
6. Generating Cross Tab Tables (Pivot)
7. Calculating Cumulative Sums

Lesson 5: USING FULL-TEXT SEARCH (14 min)
1. Creating a Full-Text Index
2. Searching for Words
3. Using a Fuzzy Search to Search for Phrases

Lesson 6: SELECTING DATA THROUGH VIEWS (11 min)
1. Creating Views
2. Preventing Disappearing Rows
3. Protecting from Schema Changes
4. Nesting Views

Lesson 7: DISTRIBUTED QUERIES (18 min)
1. Linking to External Data Sources
2. Executing Distributed Queries
3. Looking at Where the Work Takes Place
4. Using Pass Through Queries
5. Controlling Distributed Transactions

Lesson 8: MODIFYING DATA (29 min)
1. Inserting Data
2. Updating Data
3. Deleting Data
4. Using the Output Clause
5. Final Comments & Credits

PART 3: Developing Solutions

Lesson 1: T-SQL & STORED PROCEDURES (68 min)
1. Introducing T-SQL
2. Working with Variables
3. Controlling Procedural Flow
4. Examining SQL Server with Code
5. Using Temp Tables
6. Developing Dynamic SQL
7. Introducing Stored Procedures
8. Passing Parameters
9. Returning Parameters
10. Working with a Cursor
11. Handling Errors
12. Explaining the Raise Error
13. Controlling Transactions

Lesson 2: TRIGGERS & AUDIT TRAILS (31 min)
1. Introducing After Triggers
2. Using "Instead of" Trigger
3. Disabling Triggers
4. Using the Update ( ) Function
5. Selecting Transaction Data
6. Nesting & Recursion
7. Enforcing Complex RI
8. Auditing Data Changes

Lesson 3: USER-DEFINED FUNCTIONS (27 min)
1. Creating Scalar Functions
2. Working with Inline Table-Valued Functions
3. Using Multi-Statement Table-Valued UDFs
4. Navigating a Hierarchy
5. Having Fun with Apply
6. Exploring Functions in Nordic

Lesson 4: INDEXING FOR PERFORMANCE (31 min)
1. Introducing Indexes
2. Creating Indexes
3. Examinging Query Execution Plans, Pt. 1
4. Examinging Query Execution Plans, Pt. 2

Lesson 5: TRANSACTIONS, LOCKING & BLOCKING (33 min)
1. Introducing ACID
2. Understanding Transactional Faults
3. Stepping through a Transaction
4. Exploring Locks
5. Working with Locks
6. Viewing Deadlocks
7. Using Snapshot Isolation

Lesson 6: INTRODUCTION TO OPTIMIZATION THEORY (21 min)
1. Deconstructing the Database System
2. Walking through Optimization Theory
3. Optimization Theory Continued
4. Final Comments & Credits

Part1
http://rapidshare.com/files/56345531/TSQL05_P01_C01_L00.wmv
http://rapidshare.com/files/56345603/TSQL05_P01_C01_L01.wmv
http://rapidshare.com/files/56346080/TSQL05_P01_C01_L02.wmv
http://rapidshare.com/files/56346112/TSQL05_P01_C01_L03.wmv
http://rapidshare.com/files/56346160/TSQL05_P01_C01_L04.wmv

http://rapidshare.com/files/56344418/TSQL05_P01_C02_L00.wmv
http://rapidshare.com/files/56344615/TSQL05_P01_C02_L01.wmv
http://rapidshare.com/files/56345282/TSQL05_P01_C02_L02.wmv
http://rapidshare.com/files/56345757/TSQL05_P01_C02_L03.wmv
http://rapidshare.com/files/56345695/TSQL05_P01_C02_L04.wmv
http://rapidshare.com/files/56345307/TSQL05_P01_C02_L05.wmv
http://rapidshare.com/files/56345350/TSQL05_P01_C02_L06.wmv
http://rapidshare.com/files/56345797/TSQL05_P01_C02_L07.wmv

http://rapidshare.com/files/56344297/TSQL05_P01_C03_L00.wmv
http://rapidshare.com/files/56344645/TSQL05_P01_C03_L01.wmv
http://rapidshare.com/files/56346094/TSQL05_P01_C03_L02.wmv
http://rapidshare.com/files/56345708/TSQL05_P01_C03_L03.wmv
http://rapidshare.com/files/56345299/TSQL05_P01_C03_L04.wmv
http://rapidshare.com/files/56345116/TSQL05_P01_C03_L05.wmv
http://rapidshare.com/files/56345871/TSQL05_P01_C03_L06.wmv
http://rapidshare.com/files/56344226/TSQL05_P01_C03_L07.wmv

Part2
http://rapidshare.com/files/56347494/TSQL05_P02_C01_L00.wmv
http://rapidshare.com/files/56350511/TSQL05_P02_C01_L01.wmv
http://rapidshare.com/files/56350997/TSQL05_P02_C01_L02.wmv
http://rapidshare.com/files/56348537/TSQL05_P02_C01_L03.wmv
http://rapidshare.com/files/56350392/TSQL05_P02_C01_L04.wmv
http://rapidshare.com/files/56349477/TSQL05_P02_C01_L05.wmv
http://rapidshare.com/files/56347748/TSQL05_P02_C01_L06.wmv
http://rapidshare.com/files/56350510/TSQL05_P02_C01_L07.wmv
http://rapidshare.com/files/56349263/TSQL05_P02_C01_L08.wmv
http://rapidshare.com/files/56349448/TSQL05_P02_C01_L09.wmv
http://rapidshare.com/files/56348668/TSQL05_P02_C01_L10.wmv
http://rapidshare.com/files/56349540/TSQL05_P02_C01_L11.wmv

http://rapidshare.com/files/56347205/TSQL05_P02_C02_L00.wmv
http://rapidshare.com/files/56351012/TSQL05_P02_C02_L01.wmv
http://rapidshare.com/files/56349147/TSQL05_P02_C02_L02.wmv
http://rapidshare.com/files/56348591/TSQL05_P02_C02_L03.wmv
http://rapidshare.com/files/56350381/TSQL05_P02_C02_L04.wmv
http://rapidshare.com/files/56348847/TSQL05_P02_C02_L05.wmv
http://rapidshare.com/files/56347745/TSQL05_P02_C02_L06.wmv
http://rapidshare.com/files/56350474/TSQL05_P02_C02_L07.wmv

http://rapidshare.com/files/56347117/TSQL05_P02_C03_L00.wmv
http://rapidshare.com/files/56350193/TSQL05_P02_C03_L01.wmv
http://rapidshare.com/files/56348132/TSQL05_P02_C03_L02.wmv
http://rapidshare.com/files/56347704/TSQL05_P02_C03_L03.wmv
http://rapidshare.com/files/56349284/TSQL05_P02_C03_L04.wmv
http://rapidshare.com/files/56350272/TSQL05_P02_C03_L05.wmv

http://rapidshare.com/files/56346792/TSQL05_P02_C04_L00.wmv
http://rapidshare.com/files/56350866/TSQL05_P02_C04_L01.wmv
http://rapidshare.com/files/56349244/TSQL05_P02_C04_L02.wmv
http://rapidshare.com/files/56350855/TSQL05_P02_C04_L03.wmv
http://rapidshare.com/files/56349609/TSQL05_P02_C04_L04.wmv
http://rapidshare.com/files/56350914/TSQL05_P02_C04_L05.wmv
http://rapidshare.com/files/56351212/TSQL05_P02_C04_L06.wmv
http://rapidshare.com/files/56350646/TSQL05_P02_C04_L07.wmv

http://rapidshare.com/files/56347512/TSQL05_P02_C05_L00.wmv
http://rapidshare.com/files/56351020/TSQL05_P02_C05_L01.wmv
http://rapidshare.com/files/56351174/TSQL05_P02_C05_L02.wmv
http://rapidshare.com/files/56348435/TSQL05_P02_C05_L03.wmv

http://rapidshare.com/files/56347686/TSQL05_P02_C06_L00.wmv
http://rapidshare.com/files/56350880/TSQL05_P02_C06_L01.wmv
http://rapidshare.com/files/56349267/TSQL05_P02_C06_L02.wmv
http://rapidshare.com/files/56348695/TSQL05_P02_C06_L03.wmv
http://rapidshare.com/files/56349269/TSQL05_P02_C06_L04.wmv

http://rapidshare.com/files/56348452/TSQL05_P02_C07_L00.wmv
http://rapidshare.com/files/56350807/TSQL05_P02_C07_L01.wmv
http://rapidshare.com/files/56350833/TSQL05_P02_C07_L02.wmv
http://rapidshare.com/files/56349805/TSQL05_P02_C07_L03.wmv
http://rapidshare.com/files/56350286/TSQL05_P02_C07_L04.wmv
http://rapidshare.com/files/56350044/TSQL05_P02_C07_L05.wmv

http://rapidshare.com/files/56348605/TSQL05_P02_C08_L00.wmv
http://rapidshare.com/files/56351312/TSQL05_P02_C08_L01.wmv
http://rapidshare.com/files/56351007/TSQL05_P02_C08_L02.wmv
http://rapidshare.com/files/56350426/TSQL05_P02_C08_L03.wmv
http://rapidshare.com/files/56350132/TSQL05_P02_C08_L04.wmv
http://rapidshare.com/files/56350987/TSQL05_P02_C08_L05.wmv


Part3

http://rapidshare.com/files/56352619/TSQL05_P03_C01_L00.wmv
http://rapidshare.com/files/56354359/TSQL05_P03_C01_L02.wmv
http://rapidshare.com/files/56354110/TSQL05_P03_C01_L03.wmv
http://rapidshare.com/files/56353319/TSQL05_P03_C01_L04.wmv
http://rapidshare.com/files/56354555/TSQL05_P03_C01_L05.wmv
http://rapidshare.com/files/56354232/TSQL05_P03_C01_L06.wmv
http://rapidshare.com/files/56354106/TSQL05_P03_C01_L07.wmv
http://rapidshare.com/files/56354127/TSQL05_P03_C01_L08.wmv
http://rapidshare.com/files/56354582/TSQL05_P03_C01_L09.wmv
http://rapidshare.com/files/56354132/TSQL05_P03_C01_L10.wmv
http://rapidshare.com/files/56354583/TSQL05_P03_C01_L11.wmv
http://rapidshare.com/files/56354124/TSQL05_P03_C01_L12.wmv
http://rapidshare.com/files/56354077/TSQL05_P03_C01_L13.wmv

http://rapidshare.com/files/56353102/TSQL05_P03_C02_L00.wmv
http://rapidshare.com/files/56352910/TSQL05_P03_C02_L01.wmv
http://rapidshare.com/files/56353952/TSQL05_P03_C02_L02.wmv
http://rapidshare.com/files/56352842/TSQL05_P03_C02_L03.wmv
http://rapidshare.com/files/56352233/TSQL05_P03_C02_L04.wmv
http://rapidshare.com/files/56352925/TSQL05_P03_C02_L05.wmv
http://rapidshare.com/files/56354045/TSQL05_P03_C02_L06.wmv
http://rapidshare.com/files/56353245/TSQL05_P03_C02_L07.wmv

http://rapidshare.com/files/56352185/TSQL05_P03_C03_L00.wmv
http://rapidshare.com/files/56353647/TSQL05_P03_C03_L01.wmv
http://rapidshare.com/files/56353444/TSQL05_P03_C03_L02.wmv
http://rapidshare.com/files/56352616/TSQL05_P03_C03_L03.wmv
http://rapidshare.com/files/56354781/TSQL05_P03_C03_L04.wmv
http://rapidshare.com/files/56352812/TSQL05_P03_C03_L05.wmv
http://rapidshare.com/files/56353743/TSQL05_P03_C03_L06.wmv

http://rapidshare.com/files/56352734/TSQL05_P03_C04_L01.wmv
http://rapidshare.com/files/56354622/TSQL05_P03_C04_L02.wmv
http://rapidshare.com/files/56354426/TSQL05_P03_C04_L03.wmv
http://rapidshare.com/files/56354457/TSQL05_P03_C04_L04.wmv


http://rapidshare.com/files/56352838/TSQL05_P03_C05_L01.wmv
http://rapidshare.com/files/56353179/TSQL05_P03_C05_L03.wmv

http://rapidshare.com/files/56352619/TSQL05_P03_C01_L01.wmv
http://rapidshare.com/files/56352838/TSQL05_P03_C05_L01.wmv
http://rapidshare.com/files/56353179/TSQL05_P03_C05_L03.wmv
MISSING PARTS ??
PLEASE COMPLETE.
Thanks in advance,

I am sorry Guys, I am not able to get the files

TSQL05_P03_C01_L01.wmv
TSQL05_P03_C05_L01.wmv
TSQL05_P03_C05_L03.wmv

but all these files are independent .wmv files
so the rest will still work!!!

Disclaimer:
Contents of this page are indexed from this page for search purpose only. All actions are under your responsability. Email us to report illegal contents or external links and we'll remove them immediately.

Please check the description for download links if any or do a search to find alternative books.

Can't Download?
Please search mirrors if you can't find download links for "Microsoft SQL Server Development" in "Description" and someone else may update the links. Check the comments when back to find any updates.

Search Mirrors
Maybe some mirror pages will be helpful, search this book at top of this page or click here to find more info.

1. Ebooks list page : 1286
2. A First Look at SQL Server 2005 for Developers (Microsoft .NET Development Series)
3. Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
4. A Developer's Guide to SQL Server 2005 (Microsoft .NET Development Series) by Bob Beauchemin
5. M.O.C. 2734B Updating Your Database Development Skills to Microsoft SQL Server 2005-LiB
6. Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
7. Expert Cube Development with Microsoft SQL Server 2008 Analysis Services
8. A Developer%27s Guide to SQL Server 2005 (Microsoft .Net Development)
9. A Developer%27s Guide to SQL Server 2005 (Microsoft .NET Development Series)
10. [share_ebook] Microsoft 70-448 Exam - TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
11. [share_ebook] Microsoft 70-448 Exam - TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance
12. Microsoft SQL Server High Availability (Microsoft Windows Server)
13. MCSE Self-Paced Training Kit (Exam 70-297): Designing a Microsoft Windows Server
14. SharePoint Resources: 7 Development Projects for Microsoft Sharepoint Server 2007
15. Microsoft SQL Server 2000 High Availability
16. Migrating from Microsoft Windows NT Server 4.0 to Windows Server 2003