TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL

TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL

This download might also be available on Usenet. Click here to download the UseNeT client.

Torrent:

TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL

Poster:

Description:

Microsoft SQL Server Development

Company: Total Training Online

Type: Video Tutorial

Language: English

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!

Note: THIS IS THE ONLINE VERSION OF THE COURSE >> NOT THE DVD VERSION ***

Website: Microsoft® SQL Server Development

Rating:

Currently 5.00/5
1
2
3
4
5

Rating: 5.0/5 (3 votes cast)

Category:

Software/PC ISO

Size:

1.04 GB

Show/Hide Files:

File Name	Size
hell.nfo	2.82 KB
Lesson 1 SQL SERVER OVERVIEW(32 min)/0. Introduction.mov	6.87 MB
Lesson 1 SQL SERVER OVERVIEW(32 min)/1. Understanding Client Server Architecture.mov	20.66 MB
Lesson 1 SQL SERVER OVERVIEW(32 min)/2. Introducing the Tools.mov	18.82 MB
Lesson 1 SQL SERVER OVERVIEW(32 min)/3. Selecting an Addition.mov	15.54 MB
Lesson 1 SQL SERVER OVERVIEW(32 min)/4. Creating Sample Databases.mov	19.80 MB
Lesson 10 DISTRIBUTED QUERIES (18 min)/0. Introduction.mov	2.84 MB
Lesson 10 DISTRIBUTED QUERIES (18 min)/1. Linking to External Data Sources.mov	12.83 MB
Lesson 10 DISTRIBUTED QUERIES (18 min)/2. Executing Distributed Queries.wmv	9.82 MB
Lesson 10 DISTRIBUTED QUERIES (18 min)/3. Looking at Where the Work Takes Place.mov	6.04 MB
Lesson 10 DISTRIBUTED QUERIES (18 min)/4. Using Pass Through Queries.mov	6.58 MB
Lesson 10 DISTRIBUTED QUERIES (18 min)/5. Controlling Distributed Transactions.mov	8.21 MB
Lesson 11 MODIFYING DATA (29 min)/0.Introduction.mov	2.80 MB
Lesson 11 MODIFYING DATA (29 min)/1. Inserting Data.mov	27.84 MB
Lesson 11 MODIFYING DATA (29 min)/2. Updating Data.mov	15.45 MB
Lesson 11 MODIFYING DATA (29 min)/3. Deleting Data.mov	11.01 MB
Lesson 11 MODIFYING DATA (29 min)/4. Using the Output Clause.mov	8.87 MB
Lesson 11 MODIFYING DATA (29 min)/5. Final Comments & Credits.mov	10.24 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/0. Introduction.wmv	2.73 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/1. Introducing T-SQL.wmv	5.06 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/10. Working with a Cursor.wmv	8.61 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/11. Handling Errors.wmv	10.52 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/12. Explaining the Raise Error.wmv	8.74 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/13. Controlling Transactions.wmv	5.46 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/2. Working with Variables.wmv	11.83 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/3. Controlling Procedural Flow.wmv	7.01 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/4. Examining SQL Server with Code.wmv	5.13 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/5. Using Temp Tables.wmv	12.45 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/6. Developing Dynamic SQL.wmv	9.81 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/7. Introducing Stored Procedures.wmv	8.49 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/8. Passing Parameters.wmv	5.76 MB
Lesson 12 T-SQL & STORED PROCEDURES (68 min)/9. Returning Parameters.wmv	9.94 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/0. Introduction.wmv	1.96 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/1. Introducing After Triggers.wmv	4.89 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/2. Using Instead of Trigger.wmv	7.34 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/3. Disabling Triggers.wmv	2.64 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/4. Using the Update ( ) Function.wmv	2.16 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/5. Selecting Transaction Data.wmv	4.99 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/6. Nesting & Recursion.wmv	7.90 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/7. Enforcing Complex RI.wmv	6.14 MB
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/8. Auditing Data Changes.wmv	17.31 MB
Lesson 14 USER-DEFINED FUNCTIONS (27 min)/0. Introduction.wmv	1.91 MB
Lesson 14 USER-DEFINED FUNCTIONS (27 min)/1. Creating Scalar Functions.wmv	8.10 MB
Lesson 14 USER-DEFINED FUNCTIONS (27 min)/2. Working with Inline Table-Valued Functions.wmv	6.77 MB
Lesson 14 USER-DEFINED FUNCTIONS (27 min)/3. Using Multi-Statement Table-Valued UDFs.wmv	3.68 MB
Lesson 14 USER-DEFINED FUNCTIONS (27 min)/4. Navigating a Hierarchy.wmv	12.97 MB
Lesson 14 USER-DEFINED FUNCTIONS (27 min)/5. Having Fun with Apply.wmv	4.40 MB
Lesson 14 USER-DEFINED FUNCTIONS (27 min)/6. Exploring Functions in Nordic.wmv	8.27 MB
Lesson 15 INDEXING FOR PERFORMANCE (31 min)/0. Introduction.wmv	2.25 MB
Lesson 15 INDEXING FOR PERFORMANCE (31 min)/1. Introducing Indexes.wmv	4.09 MB
Lesson 15 INDEXING FOR PERFORMANCE (31 min)/2. Creating Indexes.wmv	14.31 MB
Lesson 15 INDEXING FOR PERFORMANCE (31 min)/3. Examinging Query Execution Plans, Pt. 1.wmv	12.01 MB
Lesson 15 INDEXING FOR PERFORMANCE (31 min)/4. Examinging Query Execution Plans, Pt. 2.wmv	12.70 MB
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/0 Introduction.wmv	1.43 MB
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/1. Introducing ACID.wmv	1.98 MB
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/2. Understanding Transactional Faults.mov	19.88 MB
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/3. Stepping through a Transaction.wmv	3.14 MB
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/4. Exploring Locks.wmv	4.60 MB
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/5. Working with Locks.mov	10.93 MB
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/6. Viewing Deadlocks.mov	13.85 MB
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/7. Using Snapshot Isolation.mov	9.44 MB
Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/0. Introduction.wmv	1.07 MB
Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/1. Deconstructing the Database System.mov	5.16 MB
Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/2. Walking through Optimization Theory.mov	17.50 MB
Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/3. Optimization Theory Continued.mov	16.18 MB
Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/4. Final Comments & Credits.mov	9.91 MB
Lesson 2 USING MANAGEMENT STUDIO(23 min)/0. Introduction.mov	1.85 MB
Lesson 2 USING MANAGEMENT STUDIO(23 min)/1. Arranging the Workspace.mov	4.90 MB
Lesson 2 USING MANAGEMENT STUDIO(23 min)/2. Registering Servers.mov	5.74 MB
Lesson 2 USING MANAGEMENT STUDIO(23 min)/3. Explaining Items in the Object Explorer.mov	12.20 MB
Lesson 2 USING MANAGEMENT STUDIO(23 min)/4. Explaining the Database Properties Dialog.mov	13.40 MB
Lesson 2 USING MANAGEMENT STUDIO(23 min)/5. Explaining the Columns Properties Dialog.mov	7.55 MB
Lesson 2 USING MANAGEMENT STUDIO(23 min)/6. Continuing with Object Explorer Items.mov	4.41 MB
Lesson 2 USING MANAGEMENT STUDIO(23 min)/7. Using the Query Editor.mov	12.96 MB
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/0. Introduction.mov	2.26 MB
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/1. Understanding Normalization.mov	6.38 MB
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/2. Discovering Patterns.mov	22.15 MB
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/3. Avoiding Over Complexity.mov	14.67 MB
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/4. Managing Optional Data.mov	12.25 MB
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/5. Creating Physical Keys.mov	12.96 MB
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/6. Using the Database Diagrammer Tool.mov	12.47 MB
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/7. Final Comments.mov	1.81 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/1. Understanding Query Flow.wmv	8.63 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/10. Sorting Data.wmv	3.97 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/11. Topping Off the Query with Predicates.wmv	5.92 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/2. Filtering Data with the Where Clause.wmv	10.85 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/3. Columns, Expressions & Scalar Functions.wmv	3.65 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/4. Using Case Expressions.wmv	8.33 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/5. Working with Nulls & Coalesce.wmv	6.05 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/6. Selecting Environment Functions.wmv	1.93 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/7. Working with Dates & Times.wmv	7.99 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/8. Parsing Strings.wmv	3.98 MB
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/9. Converting Data.wmv	3.65 MB
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/0. Introduction.mov	2.00 MB
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/1. Working with Inner Joins.mov	17.20 MB
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/2. Using Left Outer Joins.mov	7.38 MB
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/3. Multiplying Data with Cross Joins.mov	6.11 MB
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/4. Referencing Self-Joins.mov	9.90 MB
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/5. Working with Complex Joins.mov	4.11 MB
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/6. Finding the Set Difference.mov	4.81 MB
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/7. Stacking Data with Unions.mov	11.39 MB
Lesson 6 WORKING WITH SUBQUERIES (19 min)/0. Introduction.mov	2.62 MB
Lesson 6 WORKING WITH SUBQUERIES (19 min)/1. Using Subqueries as Expressions.mov	13.57 MB
Lesson 6 WORKING WITH SUBQUERIES (19 min)/2. Including Subqueries as Lists.mov	5.32 MB
Lesson 6 WORKING WITH SUBQUERIES (19 min)/3. Adding Subqueries as Derived Tables.mov	4.54 MB
Lesson 6 WORKING WITH SUBQUERIES (19 min)/4. Working with Correlated Subqueries.mov	9.77 MB
Lesson 6 WORKING WITH SUBQUERIES (19 min)/5. Solving for X with Relations Division.mov	13.84 MB
Lesson 7 AGGREGATING DATA (35 min)/0. Introduction.mov	1.62 MB
Lesson 7 AGGREGATING DATA (35 min)/1. Using the New Windowing Functions.mov	14.06 MB
Lesson 7 AGGREGATING DATA (35 min)/2. Using Aggregate Functions.mov	8.70 MB
Lesson 7 AGGREGATING DATA (35 min)/3. Grouping a Data Set.mov	14.88 MB
Lesson 7 AGGREGATING DATA (35 min)/4. Nesting Aggregations.mov	7.11 MB
Lesson 7 AGGREGATING DATA (35 min)/5. Filtering Groups & Adding Grand Totals.mov	11.75 MB
Lesson 7 AGGREGATING DATA (35 min)/6. Generating Cross Tab Tables (Pivot).mov	19.87 MB
Lesson 7 AGGREGATING DATA (35 min)/7. Calculating Cumulative Sums.mov	12.31 MB
Lesson 8 USING FULL-TEXT SEARCH (14 min)/0. Introduction.mov	1.59 MB
Lesson 8 USING FULL-TEXT SEARCH (14 min)/1. Creating a Full-Text Index.mov	14.79 MB
Lesson 8 USING FULL-TEXT SEARCH (14 min)/2. Searching for Words.mov	17.27 MB
Lesson 8 USING FULL-TEXT SEARCH (14 min)/3. Using a Fuzzy Search to Search for Phrases.mov	4.18 MB
Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/0. Introduction.mov	1.69 MB
Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/1. Creating Views.mov	14.76 MB
Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/2. Preventing Disappearing Rows.mov	5.03 MB
Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/3. Protecting from Schema Changes.mov	3.96 MB
Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/4. Nesting Views.mov	4.88 MB
Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 01 - Selecting Data.sql	9.53 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 02 - Joins and Unions.sql	4.82 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 03 - Subqueries.sql	9.93 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 04 - Aggregating Data.sql	16.33 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 05 - FullText Search.sql	3.69 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 06 - Views.sql	3.06 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 07 - Distributed Queries.sql	4.07 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 08 - Modifying Data.sql	8.36 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 01 - T-SQL and Stored Procedures.sql	12.39 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 02 - Triggers.sql	11.48 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 03 - User-Defined Functions.sql	6.16 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 04 - Indexing.sql	0.77 KB
Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 05 - Transactions, Locking and Blocking.sql	4.25 KB
Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop.adp	22.00 KB
Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop_Create.sql	18.18 KB
Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Customers.mdb	120.00 KB
Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Schedule.xls	24.00 KB
Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Convert.sql	4.09 KB
Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Create.sql	7.29 KB
Project Files - SQL Server 2005/Sample Databases/Family/Family_Create.sql	9.93 KB
Project Files - SQL Server 2005/Sample Databases/Family/Family_Queries.sql	11.50 KB
Project Files - SQL Server 2005/Sample Databases/Family/Family_UDF.sql	0.89 KB
Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Create.sql	29.22 KB
Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Populate.sql	18.85 KB

148 files

Added:

03/12/2007 07:12:30

NFO:

If you have access to unreleased training cds, bookware or something useful please contact us. _____. ._________.____ ___.__ / __/__ _____._________. ._______\__. / / / / / / .__/_______. ._______\_. / _ _/) ( ._//_______. \________.:nYx:.___.(____/___/.|______|/____/____).__.:Scripts:.________// nYx GreyLine FTPd Scripts

TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL.nfo

Hits:

926

Peers:

Seeders : 5 , Leechers : 2 = 7

Keywords:

TOTAL, TRAINING, ONLINE, MICROSOFT, SQL, SERVER, DEVELOPMENT, HELL , TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL , TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT HELL

No comments...

Back