Other

TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT org

  • Download 5x Faster
  • Download torrent
  • Direct Download
  • Rate this torrent +  |  -
TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT org

Anonymous and Free Direct Download 300GB+


Torrent info

Name:TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT org

Total Size: 1.04 GB

Magnet: Magnet Link

Seeds: 0

Leechers: 0

Stream: Watch Online @ Movie4u

Last Updated: 2016-12-18 12:14:07 (Update Now)

Torrent added: 2008-08-12 15:48:37



VPN For Torrents

Torrent Files List


hell.nfo (Size: 1.04 GB) (Files: 148)

 hell.nfo

2.82 KB

 Lesson 1 SQL SERVER OVERVIEW(32 min)

  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.80 MB

 Lesson 10 DISTRIBUTED QUERIES (18 min)

  0. Introduction.mov

2.84 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

 Lesson 11 MODIFYING DATA (29 min)

  0.Introduction.mov

2.80 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

 Lesson 12 T-SQL & STORED PROCEDURES (68 min)

  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

  6. Developing Dynamic SQL.wmv

9.81 MB

  7. Introducing Stored Procedures.wmv

8.49 MB

  8. Passing Parameters.wmv

5.76 MB

  9. Returning Parameters.wmv

9.94 MB

 Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)

  0. Introduction.wmv

1.96 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.90 MB

  7. Enforcing Complex RI.wmv

6.14 MB

  8. Auditing Data Changes.wmv

17.31 MB

 Lesson 14 USER-DEFINED FUNCTIONS (27 min)

  0. Introduction.wmv

1.91 MB

  1. Creating Scalar Functions.wmv

8.10 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.40 MB

  6. Exploring Functions in Nordic.wmv

8.27 MB

 Lesson 15 INDEXING FOR PERFORMANCE (31 min)

  0. Introduction.wmv

2.25 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.70 MB

 Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)

  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.60 MB

  5. Working with Locks.mov

10.93 MB

  6. Viewing Deadlocks.mov

13.85 MB

  7. Using Snapshot Isolation.mov

9.44 MB

 Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)

  0. Introduction.wmv

1.07 MB

  1. Deconstructing the Database System.mov

5.16 MB

  2. Walking through Optimization Theory.mov

17.50 MB

  3. Optimization Theory Continued.mov

16.18 MB

  4. Final Comments & Credits.mov

9.91 MB

 Lesson 2 USING MANAGEMENT STUDIO(23 min)

  0. Introduction.mov

1.85 MB

  1. Arranging the Workspace.mov

4.90 MB

  2. Registering Servers.mov

5.74 MB

  3. Explaining Items in the Object Explorer.mov

12.20 MB

  4. Explaining the Database Properties Dialog.mov

13.40 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

 Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)

  0. Introduction.mov

2.26 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

 Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)

  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

 Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)

  0. Introduction.mov

2.00 MB

  1. Working with Inner Joins.mov

17.20 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.90 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

 Lesson 6 WORKING WITH SUBQUERIES (19 min)

  0. Introduction.mov

2.62 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

 Lesson 7 AGGREGATING DATA (35 min)

  0. Introduction.mov

1.62 MB

  1. Using the New Windowing Functions.mov

14.06 MB

  2. Using Aggregate Functions.mov

8.70 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

 Lesson 8 USING FULL-TEXT SEARCH (14 min)

  0. Introduction.mov

1.59 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

 Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)

  0. Introduction.mov

1.69 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

 Project Files - SQL Server 2005

  Lesson Scripts

   Part 2 - Selecting Data

    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

   Part 3 - Developing Solutions

    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

0.77 KB

  Sample Databases

   Aesop

    Aesop.adp

22.00 KB

    Aesop_Create.sql

18.18 KB

   CapeHatterasAdventures

    CHA1_Customers.mdb

120.00 KB

    CHA1_Schedule.xls

24.00 KB

    CHA_Convert.sql

4.09 KB

    CHA_Create.sql

7.29 KB

   Family

    Family_Create.sql

9.93 KB

    Family_Queries.sql

11.50 KB

    Family_UDF.sql

0.89 KB

   OBXKites

    OBXKites_Create.sql

29.22 KB

    OBXKites_Populate.sql

18.85 KB
 

tracker

leech seeds
 

Torrent description

No description for : TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT org

related torrents

Torrent name

health leech seeds Size
 


comments (0)

Main Menu