Other
TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT org
-
-
- Rate this torrent + | -
Download Anonymously! Get Protected Today And Get your 70% discount
Torrent info
Torrent Files List
hell.nfo (Size: 1.04 GB) (Files: 148)
hell.nfo
Lesson 1 SQL SERVER OVERVIEW(32 min)
0. Introduction.mov
1. Understanding Client Server Architecture.mov
2. Introducing the Tools.mov
3. Selecting an Addition.mov
4. Creating Sample Databases.mov
Lesson 10 DISTRIBUTED QUERIES (18 min)
0. Introduction.mov
1. Linking to External Data Sources.mov
2. Executing Distributed Queries.wmv
3. Looking at Where the Work Takes Place.mov
4. Using Pass Through Queries.mov
5. Controlling Distributed Transactions.mov
Lesson 11 MODIFYING DATA (29 min)
0.Introduction.mov
1. Inserting Data.mov
2. Updating Data.mov
3. Deleting Data.mov
4. Using the Output Clause.mov
5. Final Comments & Credits.mov
Lesson 12 T-SQL & STORED PROCEDURES (68 min)
0. Introduction.wmv
1. Introducing T-SQL.wmv
10. Working with a Cursor.wmv
11. Handling Errors.wmv
12. Explaining the Raise Error.wmv
13. Controlling Transactions.wmv
2. Working with Variables.wmv
3. Controlling Procedural Flow.wmv
4. Examining SQL Server with Code.wmv
5. Using Temp Tables.wmv
6. Developing Dynamic SQL.wmv
7. Introducing Stored Procedures.wmv
8. Passing Parameters.wmv
9. Returning Parameters.wmv
Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)
0. Introduction.wmv
1. Introducing After Triggers.wmv
2. Using Instead of Trigger.wmv
3. Disabling Triggers.wmv
4. Using the Update ( ) Function.wmv
5. Selecting Transaction Data.wmv
6. Nesting & Recursion.wmv
7. Enforcing Complex RI.wmv
8. Auditing Data Changes.wmv
Lesson 14 USER-DEFINED FUNCTIONS (27 min)
0. Introduction.wmv
1. Creating Scalar Functions.wmv
2. Working with Inline Table-Valued Functions.wmv
3. Using Multi-Statement Table-Valued UDFs.wmv
4. Navigating a Hierarchy.wmv
5. Having Fun with Apply.wmv
6. Exploring Functions in Nordic.wmv
Lesson 15 INDEXING FOR PERFORMANCE (31 min)
0. Introduction.wmv
1. Introducing Indexes.wmv
2. Creating Indexes.wmv
3. Examinging Query Execution Plans, Pt. 1.wmv
4. Examinging Query Execution Plans, Pt. 2.wmv
Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)
0 Introduction.wmv
1. Introducing ACID.wmv
2. Understanding Transactional Faults.mov
3. Stepping through a Transaction.wmv
4. Exploring Locks.wmv
5. Working with Locks.mov
6. Viewing Deadlocks.mov
7. Using Snapshot Isolation.mov
Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)
0. Introduction.wmv
1. Deconstructing the Database System.mov
2. Walking through Optimization Theory.mov
3. Optimization Theory Continued.mov
4. Final Comments & Credits.mov
Lesson 2 USING MANAGEMENT STUDIO(23 min)
0. Introduction.mov
1. Arranging the Workspace.mov
2. Registering Servers.mov
3. Explaining Items in the Object Explorer.mov
4. Explaining the Database Properties Dialog.mov
5. Explaining the Columns Properties Dialog.mov
6. Continuing with Object Explorer Items.mov
7. Using the Query Editor.mov
Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)
0. Introduction.mov
1. Understanding Normalization.mov
2. Discovering Patterns.mov
3. Avoiding Over Complexity.mov
4. Managing Optional Data.mov
5. Creating Physical Keys.mov
6. Using the Database Diagrammer Tool.mov
7. Final Comments.mov
Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)
1. Understanding Query Flow.wmv
10. Sorting Data.wmv
11. Topping Off the Query with Predicates.wmv
2. Filtering Data with the Where Clause.wmv
3. Columns, Expressions & Scalar Functions.wmv
4. Using Case Expressions.wmv
5. Working with Nulls & Coalesce.wmv
6. Selecting Environment Functions.wmv
7. Working with Dates & Times.wmv
8. Parsing Strings.wmv
9. Converting Data.wmv
Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)
0. Introduction.mov
1. Working with Inner Joins.mov
2. Using Left Outer Joins.mov
3. Multiplying Data with Cross Joins.mov
4. Referencing Self-Joins.mov
5. Working with Complex Joins.mov
6. Finding the Set Difference.mov
7. Stacking Data with Unions.mov
Lesson 6 WORKING WITH SUBQUERIES (19 min)
0. Introduction.mov
1. Using Subqueries as Expressions.mov
2. Including Subqueries as Lists.mov
3. Adding Subqueries as Derived Tables.mov
4. Working with Correlated Subqueries.mov
5. Solving for X with Relations Division.mov
Lesson 7 AGGREGATING DATA (35 min)
0. Introduction.mov
1. Using the New Windowing Functions.mov
2. Using Aggregate Functions.mov
3. Grouping a Data Set.mov
4. Nesting Aggregations.mov
5. Filtering Groups & Adding Grand Totals.mov
6. Generating Cross Tab Tables (Pivot).mov
7. Calculating Cumulative Sums.mov
Lesson 8 USING FULL-TEXT SEARCH (14 min)
0. Introduction.mov
1. Creating a Full-Text Index.mov
2. Searching for Words.mov
3. Using a Fuzzy Search to Search for Phrases.mov
Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)
0. Introduction.mov
1. Creating Views.mov
2. Preventing Disappearing Rows.mov
3. Protecting from Schema Changes.mov
4. Nesting Views.mov
Project Files - SQL Server 2005
Lesson Scripts
Part 2 - Selecting Data
Lesson 01 - Selecting Data.sql
Lesson 02 - Joins and Unions.sql
Lesson 03 - Subqueries.sql
Lesson 04 - Aggregating Data.sql
Lesson 05 - FullText Search.sql
Lesson 06 - Views.sql
Lesson 07 - Distributed Queries.sql
Lesson 08 - Modifying Data.sql
Part 3 - Developing Solutions
LE7F94~1.SQL
Lesson 01 - T-SQL and Stored Procedures.sql
Lesson 02 - Triggers.sql
Lesson 03 - User-Defined Functions.sql
Lesson 04 - Indexing.sql
Sample Databases
Aesop
Aesop.adp
Aesop_Create.sql
CapeHatterasAdventures
CHA1_Customers.mdb
CHA1_Schedule.xls
CHA_Convert.sql
CHA_Create.sql
Family
Family_Create.sql
Family_Queries.sql
Family_UDF.sql
OBXKites
OBXKites_Create.sql
OBXKites_Populate.sql
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT org Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
