Total Training for Microsoft SQL Server Development | 955BE305777DF1E486ECFDABA3F2706CB85865A4

Total Training for Microsoft SQL Server Development

Name	Total Training for Microsoft SQL Server Development	DOWNLOAD Copy Link
Total Size	1.1 GB
Total Files	148
Hash	955BE305777DF1E486ECFDABA3F2706CB85865A4

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