Total Training SQL Server Development

by Nguyen Trung Hoa Sun 22 Aug 2010, 9:10 am

Total Training SQL Server Development

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!

Highlights

* Master the fundamentals of SQL Server technology.
* Learn how to write better queries to return the exact data required.
* Avoid slow iterative code by refactoring cursors into queries using user-defined functions and case expressions.
* Develop stored procedures using T-SQL.
* Understand how transactions affect performance, how to detect blocking transactions, and how to minimize the impact of locking and blocking.
* Create triggers to build custom audit trails and enforce database rules.

http://www.totaltraining.com/prod/microsoft/sqlserverdev.asp

PART 1: Introduction to SQL Server 2005

Lesson 1: SQL SERVER OVERVIEW (32 min)

Code:: http://rapidshare.com/files/54623473/TSQL05_P01_C01_L00.mov http://rapidshare.com/files/54623535/TSQL05_P01_C01_L01.mov http://rapidshare.com/files/54623524/TSQL05_P01_C01_L02.mov http://rapidshare.com/files/54623515/TSQL05_P01_C01_L03.mov http://rapidshare.com/files/54623571/TSQL05_P01_C01_L04.mov

Lesson 2: USING MANAGEMENT STUDIO (23 min)

Code:: http://rapidshare.com/files/54623455/TSQL05_P01_C02_L00.mov http://rapidshare.com/files/54623483/TSQL05_P01_C02_L01.mov http://rapidshare.com/files/54623474/TSQL05_P01_C02_L02.mov http://rapidshare.com/files/54623499/TSQL05_P01_C02_L03.mov http://rapidshare.com/files/54623574/TSQL05_P01_C02_L04.mov http://rapidshare.com/files/54623477/TSQL05_P01_C02_L05.mov http://rapidshare.com/files/54623472/TSQL05_P01_C02_L06.mov http://rapidshare.com/files/54623513/TSQL05_P01_C02_L07.mov

Lesson 3: DESIGNING RELATIONAL DATABASES (35 min)

Code:: http://rapidshare.com/files/54623461/TSQL05_P01_C03_L00.mov http://rapidshare.com/files/54623480/TSQL05_P01_C03_L01.mov http://rapidshare.com/files/54623592/TSQL05_P01_C03_L02.mov http://rapidshare.com/files/54623522/TSQL05_P01_C03_L03.mov http://rapidshare.com/files/54623523/TSQL05_P01_C03_L04.mov http://rapidshare.com/files/54623599/TSQL05_P01_C03_L05.mov http://rapidshare.com/files/54623516/TSQL05_P01_C03_L06.mov http://rapidshare.com/files/54623465/TSQL05_P01_C03_L07.mov

Part 2: Selecting Data

Lesson 1: WORKING WITH SINGLE TABLE QUERIES (42 min)

Code:: http://rapidshare.com/files/54623471/TSQL05_P02_C01_L00.mov http://rapidshare.com/files/54623544/TSQL05_P02_C01_L01.mov http://rapidshare.com/files/54623631/TSQL05_P02_C01_L02.mov http://rapidshare.com/files/54623507/TSQL05_P02_C01_L03.mov http://rapidshare.com/files/54623601/TSQL05_P02_C01_L04.mov http://rapidshare.com/files/54623538/TSQL05_P02_C01_L05.mov http://rapidshare.com/files/54623488/TSQL05_P02_C01_L06.mov http://rapidshare.com/files/54623540/TSQL05_P02_C01_L07.mov http://rapidshare.com/files/54623521/TSQL05_P02_C01_L08.mov http://rapidshare.com/files/54623520/TSQL05_P02_C01_L09.mov http://rapidshare.com/files/54623517/TSQL05_P02_C01_L10.mov http://rapidshare.com/files/54623547/TSQL05_P02_C01_L11.mov

Lesson 2: MERGING DATA WITH JOINS & UNIONS (25 min)

Code:: http://rapidshare.com/files/54623484/TSQL05_P02_C02_L00.mov http://rapidshare.com/files/54623629/TSQL05_P02_C02_L01.mov http://rapidshare.com/files/54623532/TSQL05_P02_C02_L02.mov http://rapidshare.com/files/54623537/TSQL05_P02_C02_L03.mov http://rapidshare.com/files/54623573/TSQL05_P02_C02_L04.mov http://rapidshare.com/files/54623497/TSQL05_P02_C02_L05.mov http://rapidshare.com/files/54623500/TSQL05_P02_C02_L06.mov http://rapidshare.com/files/54623542/TSQL05_P02_C02_L07.mov

Lesson 3: WORKING WITH SUBQUERIES (19 min)

Code:: http://rapidshare.com/files/54623495/TSQL05_P02_C03_L00.mov http://rapidshare.com/files/54623591/TSQL05_P02_C03_L01.mov http://rapidshare.com/files/54623518/TSQL05_P02_C03_L02.mov http://rapidshare.com/files/54623510/TSQL05_P02_C03_L03.mov http://rapidshare.com/files/54623557/TSQL05_P02_C03_L04.mov http://rapidshare.com/files/54623596/TSQL05_P02_C03_L05.mov

Lesson 4: AGGREGATING DATA (35 min)

Code:: http://rapidshare.com/files/54623487/TSQL05_P02_C04_L00.mov http://rapidshare.com/files/54623575/TSQL05_P02_C04_L01.mov http://rapidshare.com/files/54623598/TSQL05_P02_C04_L02.mov http://rapidshare.com/files/54623585/TSQL05_P02_C04_L03.mov http://rapidshare.com/files/54623533/TSQL05_P02_C04_L04.mov http://rapidshare.com/files/54623615/TSQL05_P02_C04_L05.mov http://rapidshare.com/files/54623600/TSQL05_P02_C04_L06.mov http://rapidshare.com/files/54623577/TSQL05_P02_C04_L07.mov

Lesson 5: USING FULL-TEXT SEARCH (14 min)

Code:: http://rapidshare.com/files/54623514/TSQL05_P02_C05_L00.mov http://rapidshare.com/files/54623605/TSQL05_P02_C05_L01.mov http://rapidshare.com/files/54623656/TSQL05_P02_C05_L02.mov http://rapidshare.com/files/54623558/TSQL05_P02_C05_L03.mov

Lesson 6: SELECTING DATA THROUGH VIEWS (11 min)

Code:: http://rapidshare.com/files/54623511/TSQL05_P02_C06_L00.mov http://rapidshare.com/files/54623586/TSQL05_P02_C06_L01.mov http://rapidshare.com/files/54623528/TSQL05_P02_C06_L02.mov http://rapidshare.com/files/54623561/TSQL05_P02_C06_L03.mov http://rapidshare.com/files/54623551/TSQL05_P02_C06_L04.mov

Lesson 7: DISTRIBUTED QUERIES (18 min)

Code:: http://rapidshare.com/files/54623525/TSQL05_P02_C07_L00.mov http://rapidshare.com/files/54623621/TSQL05_P02_C07_L01.mov http://rapidshare.com/files/54623630/TSQL05_P02_C07_L02.mov http://rapidshare.com/files/54623597/TSQL05_P02_C07_L03.mov http://rapidshare.com/files/54623608/TSQL05_P02_C07_L04.mov http://rapidshare.com/files/54623582/TSQL05_P02_C07_L05.mov

Lesson 8: MODIFYING DATA (29 min)

Code:: http://rapidshare.com/files/54623563/TSQL05_P02_C08_L00.mov http://rapidshare.com/files/54623710/TSQL05_P02_C08_L01.mov http://rapidshare.com/files/54623644/TSQL05_P02_C08_L02.mov http://rapidshare.com/files/54623625/TSQL05_P02_C08_L03.mov http://rapidshare.com/files/54623594/TSQL05_P02_C08_L04.mov http://rapidshare.com/files/54623590/TSQL05_P02_C08_L05.mov

PART 3: Developing Solutions

Lesson 1: T-SQL & STORED PROCEDURES (68 min)

Code:: http://rapidshare.com/files/54623892/TSQL05_P03_C01_L00.mov http://rapidshare.com/files/54623950/TSQL05_P03_C01_L01.mov http://rapidshare.com/files/54624011/TSQL05_P03_C01_L02.mov http://rapidshare.com/files/54623942/TSQL05_P03_C01_L03.mov http://rapidshare.com/files/54623911/TSQL05_P03_C01_L04.mov http://rapidshare.com/files/54623967/TSQL05_P03_C01_L05.mov http://rapidshare.com/files/54623989/TSQL05_P03_C01_L06.mov http://rapidshare.com/files/54623971/TSQL05_P03_C01_L07.mov http://rapidshare.com/files/54623946/TSQL05_P03_C01_L08.mov http://rapidshare.com/files/54623955/TSQL05_P03_C01_L09.mov http://rapidshare.com/files/54623954/TSQL05_P03_C01_L10.mov http://rapidshare.com/files/54624010/TSQL05_P03_C01_L11.mov http://rapidshare.com/files/54623966/TSQL05_P03_C01_L12.mov http://rapidshare.com/files/54623919/TSQL05_P03_C01_L13.mov

Lesson 2: TRIGGERS & AUDIT TRAILS (31 min)

Code:: http://rapidshare.com/files/54623899/TSQL05_P03_C02_L00.mov http://rapidshare.com/files/54623937/TSQL05_P03_C02_L01.mov http://rapidshare.com/files/54623934/TSQL05_P03_C02_L02.mov http://rapidshare.com/files/54623906/TSQL05_P03_C02_L03.mov http://rapidshare.com/files/54623910/TSQL05_P03_C02_L04.mov http://rapidshare.com/files/54623965/TSQL05_P03_C02_L05.mov http://rapidshare.com/files/54623994/TSQL05_P03_C02_L06.mov http://rapidshare.com/files/54623970/TSQL05_P03_C02_L07.mov http://rapidshare.com/files/54624052/TSQL05_P03_C02_L08.mov

Lesson 3: USER-DEFINED FUNCTIONS (27 min)

Code:: http://rapidshare.com/files/54623921/TSQL05_P03_C03_L00.mov http://rapidshare.com/files/54623982/TSQL05_P03_C03_L01.mov http://rapidshare.com/files/54623953/TSQL05_P03_C03_L02.mov http://rapidshare.com/files/54623941/TSQL05_P03_C03_L03.mov http://rapidshare.com/files/54623991/TSQL05_P03_C03_L04.mov http://rapidshare.com/files/54623948/TSQL05_P03_C03_L05.mov http://rapidshare.com/files/54623958/TSQL05_P03_C03_L06.mov

Lesson 4: INDEXING FOR PERFORMANCE (31 min)

Code:: http://rapidshare.com/files/54623917/TSQL05_P03_C04_L00.mov http://rapidshare.com/files/54623964/TSQL05_P03_C04_L01.mov http://rapidshare.com/files/54623983/TSQL05_P03_C04_L02.mov http://rapidshare.com/files/54624066/TSQL05_P03_C04_L03.mov http://rapidshare.com/files/54624029/TSQL05_P03_C04_L04.mov

Lesson 5: TRANSACTIONS, LOCKING & BLOCKING (33 min)

Code:: http://rapidshare.com/files/54623935/TSQL05_P03_C05_L00.mov http://rapidshare.com/files/54623952/TSQL05_P03_C05_L01.mov http://rapidshare.com/files/54624025/TSQL05_P03_C05_L02.mov http://rapidshare.com/files/54623961/TSQL05_P03_C05_L03.mov http://rapidshare.com/files/54623976/TSQL05_P03_C05_L04.mov http://rapidshare.com/files/54623975/TSQL05_P03_C05_L05.mov http://rapidshare.com/files/54623978/TSQL05_P03_C05_L06.mov http://rapidshare.com/files/54623996/TSQL05_P03_C05_L07.mov

Lesson 6: INTRODUCTION TO OPTIMIZATION THEORY (21 min)

Code:: http://rapidshare.com/files/54623928/TSQL05_P03_C06_L00.mov http://rapidshare.com/files/54623940/TSQL05_P03_C06_L01.mov http://rapidshare.com/files/54624039/TSQL05_P03_C06_L02.mov http://rapidshare.com/files/54623986/TSQL05_P03_C06_L03.mov http://rapidshare.com/files/54623997/TSQL05_P03_C06_L04.mov