TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT HELL | FE75DBC2EDE8027F9A353AAF47A0916D8BBDCED7

TOTAL TRAINING ONLINE MICROSOFT SQL SERVER DEVELOPMENT HELL

Name	TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL	DOWNLOAD Copy Link
Total Size	1.1 GB
Total Files	148
Hash	FE75DBC2EDE8027F9A353AAF47A0916D8BBDCED7

/
hell.nfo	2.9 KB
/Lesson 1 SQL SERVER OVERVIEW(32 min)/
0. Introduction.mov	7.2 MB
1. Understanding Client Server Architecture.mov	21.7 MB
2. Introducing the Tools.mov	19.7 MB
3. Selecting an Addition.mov	16.3 MB
4. Creating Sample Databases.mov	20.8 MB
/Lesson 10 DISTRIBUTED QUERIES (18 min)/
0. Introduction.mov	3.0 MB
1. Linking to External Data Sources.mov	13.5 MB
2. Executing Distributed Queries.wmv	10.3 MB
3. Looking at Where the Work Takes Place.mov	6.3 MB
4. Using Pass Through Queries.mov	6.9 MB
5. Controlling Distributed Transactions.mov	8.6 MB
/Lesson 11 MODIFYING DATA (29 min)/
0.Introduction.mov	2.9 MB
1. Inserting Data.mov	29.2 MB
2. Updating Data.mov	16.2 MB
3. Deleting Data.mov	11.5 MB
4. Using the Output Clause.mov	9.3 MB
5. Final Comments & Credits.mov	10.7 MB
/Lesson 12 T-SQL & STORED PROCEDURES (68 min)/
0. Introduction.wmv	2.9 MB
1. Introducing T-SQL.wmv	5.3 MB
10. Working with a Cursor.wmv	9.0 MB
11. Handling Errors.wmv	11.0 MB
12. Explaining the Raise Error.wmv	9.2 MB
13. Controlling Transactions.wmv	5.7 MB
2. Working with Variables.wmv	12.4 MB
3. Controlling Procedural Flow.wmv	7.4 MB
4. Examining SQL Server with Code.wmv	5.4 MB
5. Using Temp Tables.wmv	13.1 MB
6. Developing Dynamic SQL.wmv	10.3 MB
7. Introducing Stored Procedures.wmv	8.9 MB
8. Passing Parameters.wmv	6.0 MB
9. Returning Parameters.wmv	10.4 MB
/Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/
0. Introduction.wmv	2.1 MB
1. Introducing After Triggers.wmv	5.1 MB
2. Using Instead of Trigger.wmv	7.7 MB
3. Disabling Triggers.wmv	2.8 MB
4. Using the Update ( ) Function.wmv	2.3 MB
5. Selecting Transaction Data.wmv	5.2 MB
6. Nesting & Recursion.wmv	8.3 MB
7. Enforcing Complex RI.wmv	6.4 MB
8. Auditing Data Changes.wmv	18.1 MB
/Lesson 14 USER-DEFINED FUNCTIONS (27 min)/
0. Introduction.wmv	2.0 MB
1. Creating Scalar Functions.wmv	8.5 MB
2. Working with Inline Table-Valued Functions.wmv	7.1 MB
3. Using Multi-Statement Table-Valued UDFs.wmv	3.9 MB
4. Navigating a Hierarchy.wmv	13.6 MB
5. Having Fun with Apply.wmv	4.6 MB
6. Exploring Functions in Nordic.wmv	8.7 MB
/Lesson 15 INDEXING FOR PERFORMANCE (31 min)/
0. Introduction.wmv	2.4 MB
1. Introducing Indexes.wmv	4.3 MB
2. Creating Indexes.wmv	15.0 MB
3. Examinging Query Execution Plans, Pt. 1.wmv	12.6 MB
4. Examinging Query Execution Plans, Pt. 2.wmv	13.3 MB
/Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/
0 Introduction.wmv	1.5 MB
1. Introducing ACID.wmv	2.1 MB
2. Understanding Transactional Faults.mov	20.8 MB
3. Stepping through a Transaction.wmv	3.3 MB
4. Exploring Locks.wmv	4.8 MB
5. Working with Locks.mov	11.5 MB
6. Viewing Deadlocks.mov	14.5 MB
7. Using Snapshot Isolation.mov	9.9 MB
/Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/
0. Introduction.wmv	1.1 MB
1. Deconstructing the Database System.mov	5.4 MB
2. Walking through Optimization Theory.mov	18.3 MB
3. Optimization Theory Continued.mov	17.0 MB
4. Final Comments & Credits.mov	10.4 MB
/Lesson 2 USING MANAGEMENT STUDIO(23 min)/
0. Introduction.mov	1.9 MB
1. Arranging the Workspace.mov	5.1 MB
2. Registering Servers.mov	6.0 MB
3. Explaining Items in the Object Explorer.mov	12.8 MB
4. Explaining the Database Properties Dialog.mov	14.1 MB
5. Explaining the Columns Properties Dialog.mov	7.9 MB
6. Continuing with Object Explorer Items.mov	4.6 MB
7. Using the Query Editor.mov	13.6 MB
/Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/
0. Introduction.mov	2.4 MB
1. Understanding Normalization.mov	6.7 MB
2. Discovering Patterns.mov	23.2 MB
3. Avoiding Over Complexity.mov	15.4 MB
4. Managing Optional Data.mov	12.8 MB
5. Creating Physical Keys.mov	13.6 MB
6. Using the Database Diagrammer Tool.mov	13.1 MB
7. Final Comments.mov	1.9 MB
/Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/
1. Understanding Query Flow.wmv	9.0 MB
10. Sorting Data.wmv	4.2 MB
11. Topping Off the Query with Predicates.wmv	6.2 MB
2. Filtering Data with the Where Clause.wmv	11.4 MB
3. Columns, Expressions & Scalar Functions.wmv	3.8 MB
4. Using Case Expressions.wmv	8.7 MB
5. Working with Nulls & Coalesce.wmv	6.3 MB
6. Selecting Environment Functions.wmv	2.0 MB
7. Working with Dates & Times.wmv	8.4 MB
8. Parsing Strings.wmv	4.2 MB
9. Converting Data.wmv	3.8 MB
/Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/
0. Introduction.mov	2.1 MB
1. Working with Inner Joins.mov	18.0 MB
2. Using Left Outer Joins.mov	7.7 MB
3. Multiplying Data with Cross Joins.mov	6.4 MB
4. Referencing Self-Joins.mov	10.4 MB
5. Working with Complex Joins.mov	4.3 MB
6. Finding the Set Difference.mov	5.0 MB
7. Stacking Data with Unions.mov	11.9 MB
/Lesson 6 WORKING WITH SUBQUERIES (19 min)/
0. Introduction.mov	2.7 MB
1. Using Subqueries as Expressions.mov	14.2 MB
2. Including Subqueries as Lists.mov	5.6 MB
3. Adding Subqueries as Derived Tables.mov	4.8 MB
4. Working with Correlated Subqueries.mov	10.2 MB
5. Solving for X with Relations Division.mov	14.5 MB
/Lesson 7 AGGREGATING DATA (35 min)/
0. Introduction.mov	1.7 MB
1. Using the New Windowing Functions.mov	14.7 MB
2. Using Aggregate Functions.mov	9.1 MB
3. Grouping a Data Set.mov	15.6 MB
4. Nesting Aggregations.mov	7.5 MB
5. Filtering Groups & Adding Grand Totals.mov	12.3 MB
6. Generating Cross Tab Tables (Pivot).mov	20.8 MB
7. Calculating Cumulative Sums.mov	12.9 MB
/Lesson 8 USING FULL-TEXT SEARCH (14 min)/
0. Introduction.mov	1.7 MB
1. Creating a Full-Text Index.mov	15.5 MB
2. Searching for Words.mov	18.1 MB
3. Using a Fuzzy Search to Search for Phrases.mov	4.4 MB
/Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/
0. Introduction.mov	1.8 MB
1. Creating Views.mov	15.5 MB
2. Preventing Disappearing Rows.mov	5.3 MB
3. Protecting from Schema Changes.mov	4.2 MB
4. Nesting Views.mov	5.1 MB
/.../Part 2 - Selecting Data/
Lesson 01 - Selecting Data.sql	9.8 KB
Lesson 02 - Joins and Unions.sql	4.9 KB
Lesson 03 - Subqueries.sql	10.2 KB
Lesson 04 - Aggregating Data.sql	16.7 KB
Lesson 05 - FullText Search.sql	3.8 KB
Lesson 06 - Views.sql	3.1 KB
Lesson 07 - Distributed Queries.sql	4.2 KB
Lesson 08 - Modifying Data.sql	8.6 KB
/.../Part 3 - Developing Solutions/
Lesson 01 - T-SQL and Stored Procedures.sql	12.7 KB
Lesson 02 - Triggers.sql	11.8 KB
Lesson 03 - User-Defined Functions.sql	6.3 KB
Lesson 04 - Indexing.sql	0.8 KB
Lesson 05 - Transactions, Locking and Blocking.sql	4.4 KB
/Sample Databases/Aesop/
Aesop.adp	22.5 KB
Aesop_Create.sql	18.6 KB
/Sample Databases/CapeHatterasAdventures/
CHA1_Customers.mdb	122.9 KB
CHA1_Schedule.xls	24.6 KB
CHA_Convert.sql	4.2 KB
CHA_Create.sql	7.5 KB
/Sample Databases/Family/
Family_Create.sql	10.2 KB
Family_Queries.sql	11.8 KB
Family_UDF.sql	0.9 KB
/Sample Databases/OBXKites/
OBXKites_Create.sql	29.9 KB
OBXKites_Populate.sql	19.3 KB
Total files 148