| | 0. Introduction.mov | 6.87 MB |
| | 1. Understanding Client Server Architecture.mov | 20.66 MB |
| | 2. Introducing the Tools.mov | 18.82 MB |
| | 3. Selecting an Addition.mov | 15.54 MB |
| | 4. Creating Sample Databases.mov | 19.8 MB |
| | 1. Arranging the Workspace.mov | 4.9 MB |
| | 2. Registering Servers.mov | 5.74 MB |
| | 3. Explaining Items in the Object Explorer.mov | 12.2 MB |
| | 4. Explaining the Database Properties Dialog.mov | 13.4 MB |
| | 5. Explaining the Columns Properties Dialog.mov | 7.55 MB |
| | 6. Continuing with Object Explorer Items.mov | 4.41 MB |
| | 7. Using the Query Editor.mov | 12.96 MB |
| | 1. Understanding Normalization.mov | 6.38 MB |
| | 2. Discovering Patterns.mov | 22.15 MB |
| | 3. Avoiding Over Complexity.mov | 14.67 MB |
| | 4. Managing Optional Data.mov | 12.25 MB |
| | 5. Creating Physical Keys.mov | 12.96 MB |
| | 6. Using the Database Diagrammer Tool.mov | 12.47 MB |
| | 7. Final Comments.mov | 1.81 MB |
| | 1. Understanding Query Flow.wmv | 8.63 MB |
| | 10. Sorting Data.wmv | 3.97 MB |
| | 11. Topping Off the Query with Predicates.wmv | 5.92 MB |
| | 2. Filtering Data with the Where Clause.wmv | 10.85 MB |
| | 3. Columns, Expressions & Scalar Functions.wmv | 3.65 MB |
| | 4. Using Case Expressions.wmv | 8.33 MB |
| | 5. Working with Nulls & Coalesce.wmv | 6.05 MB |
| | 6. Selecting Environment Functions.wmv | 1.93 MB |
| | 7. Working with Dates & Times.wmv | 7.99 MB |
| | 8. Parsing Strings.wmv | 3.98 MB |
| | 9. Converting Data.wmv | 3.65 MB |
| | 1. Working with Inner Joins.mov | 17.2 MB |
| | 2. Using Left Outer Joins.mov | 7.38 MB |
| | 3. Multiplying Data with Cross Joins.mov | 6.11 MB |
| | 4. Referencing Self-Joins.mov | 9.9 MB |
| | 5. Working with Complex Joins.mov | 4.11 MB |
| | 6. Finding the Set Difference.mov | 4.81 MB |
| | 7. Stacking Data with Unions.mov | 11.39 MB |
| | 1. Using Subqueries as Expressions.mov | 13.57 MB |
| | 2. Including Subqueries as Lists.mov | 5.32 MB |
| | 3. Adding Subqueries as Derived Tables.mov | 4.54 MB |
| | 4. Working with Correlated Subqueries.mov | 9.77 MB |
| | 5. Solving for X with Relations Division.mov | 13.84 MB |
| | 1. Using the New Windowing Functions.mov | 14.06 MB |
| | 2. Using Aggregate Functions.mov | 8.7 MB |
| | 3. Grouping a Data Set.mov | 14.88 MB |
| | 4. Nesting Aggregations.mov | 7.11 MB |
| | 5. Filtering Groups & Adding Grand Totals.mov | 11.75 MB |
| | 6. Generating Cross Tab Tables (Pivot).mov | 19.87 MB |
| | 7. Calculating Cumulative Sums.mov | 12.31 MB |
| | 1. Creating a Full-Text Index.mov | 14.79 MB |
| | 2. Searching for Words.mov | 17.27 MB |
| | 3. Using a Fuzzy Search to Search for Phrases.mov | 4.18 MB |
| | 1. Creating Views.mov | 14.76 MB |
| | 2. Preventing Disappearing Rows.mov | 5.03 MB |
| | 3. Protecting from Schema Changes.mov | 3.96 MB |
| | 4. Nesting Views.mov | 4.88 MB |
| | 1. Linking to External Data Sources.mov | 12.83 MB |
| | 2. Executing Distributed Queries.wmv | 9.82 MB |
| | 3. Looking at Where the Work Takes Place.mov | 6.04 MB |
| | 4. Using Pass Through Queries.mov | 6.58 MB |
| | 5. Controlling Distributed Transactions.mov | 8.21 MB |
| | 0.Introduction.mov | 2.8 MB |
| | 1. Inserting Data.mov | 27.84 MB |
| | 2. Updating Data.mov | 15.45 MB |
| | 3. Deleting Data.mov | 11.01 MB |
| | 4. Using the Output Clause.mov | 8.87 MB |
| | 5. Final Comments & Credits.mov | 10.24 MB |
| | 0. Introduction.wmv | 2.73 MB |
| | 1. Introducing T-SQL.wmv | 5.06 MB |
| | 10. Working with a Cursor.wmv | 8.61 MB |
| | 11. Handling Errors.wmv | 10.52 MB |
| | 12. Explaining the Raise Error.wmv | 8.74 MB |
| | 13. Controlling Transactions.wmv | 5.46 MB |
| | 2. Working with Variables.wmv | 11.83 MB |
| | 3. Controlling Procedural Flow.wmv | 7.01 MB |
| | 4. Examining SQL Server with Code.wmv | 5.13 MB |
| | 5. Using Temp Tables.wmv | 12.45 MB |
| | 1. Introducing After Triggers.wmv | 4.89 MB |
| | 2. Using Instead of Trigger.wmv | 7.34 MB |
| | 3. Disabling Triggers.wmv | 2.64 MB |
| | 4. Using the Update ( ) Function.wmv | 2.16 MB |
| | 5. Selecting Transaction Data.wmv | 4.99 MB |
| | 6. Nesting & Recursion.wmv | 7.9 MB |
| | 7. Enforcing Complex RI.wmv | 6.14 MB |
| | 8. Auditing Data Changes.wmv | 17.31 MB |
| | 1. Creating Scalar Functions.wmv | 8.1 MB |
| | 2. Working with Inline Table-Valued Functions.wmv | 6.77 MB |
| | 3. Using Multi-Statement Table-Valued UDFs.wmv | 3.68 MB |
| | 4. Navigating a Hierarchy.wmv | 12.97 MB |
| | 5. Having Fun with Apply.wmv | 4.4 MB |
| | 6. Exploring Functions in Nordic.wmv | 8.27 MB |
| | 1. Introducing Indexes.wmv | 4.09 MB |
| | 2. Creating Indexes.wmv | 14.31 MB |
| | 3. Examinging Query Execution Plans, Pt. 1.wmv | 12.01 MB |
| | 4. Examinging Query Execution Plans, Pt. 2.wmv | 12.7 MB |
| | 0 Introduction.wmv | 1.43 MB |
| | 1. Introducing ACID.wmv | 1.98 MB |
| | 2. Understanding Transactional Faults.mov | 19.88 MB |
| | 3. Stepping through a Transaction.wmv | 3.14 MB |
| | 4. Exploring Locks.wmv | 4.6 MB |
| | 5. Working with Locks.mov | 10.93 MB |
| | 6. Viewing Deadlocks.mov | 13.85 MB |
| | 7. Using Snapshot Isolation.mov | 9.44 MB |
| | 1. Deconstructing the Database System.mov | 5.16 MB |
| | 2. Walking through Optimization Theory.mov | 17.5 MB |
| | 3. Optimization Theory Continued.mov | 16.18 MB |
| | 4. Final Comments & Credits.mov | 9.91 MB |
| | Lesson 01 - Selecting Data.sql | 9.53 KB |
| | Lesson 02 - Joins and Unions.sql | 4.82 KB |
| | Lesson 03 - Subqueries.sql | 9.93 KB |
| | Lesson 04 - Aggregating Data.sql | 16.33 KB |
| | Lesson 05 - FullText Search.sql | 3.69 KB |
| | Lesson 06 - Views.sql | 3.06 KB |
| | Lesson 07 - Distributed Queries.sql | 4.07 KB |
| | Lesson 08 - Modifying Data.sql | 8.36 KB |
| | LE7F94~1.sql | 4.25 KB |
| | Lesson 01 - T-SQL and Stored Procedures.sql | 12.39 KB |
| | Lesson 02 - Triggers.sql | 11.48 KB |
| | Lesson 03 - User-Defined Functions.sql | 6.16 KB |
| | Lesson 04 - Indexing.sql | 793 bytes |
| | Aesop.adp | 22 KB |
| | Aesop_Create.sql | 18.18 KB |
| | CHA1_Customers.mdb | 120 KB |
| | CHA1_Schedule.xls | 24 KB |
| | CHA_Convert.sql | 4.09 KB |
| | CHA_Create.sql | 7.29 KB |
| | Family_Create.sql | 9.93 KB |
| | Family_Queries.sql | 11.5 KB |
| | Family_UDF.sql | 907 bytes |
| | OBXKites_Create.sql | 29.22 KB |
| | OBXKites_Populate.sql | 18.85 KB |
| | hell.nfo | 2.82 KB |
Thank you so much for TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT-[www ozone-torrents org]link.Is there anyway to download just Project Files - SQL Server 2005 section?I mean Sample databases and lesson scripts.
It is kind of your notice to reply me back.
Regards