| 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.8 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.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 | ||
| 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.9 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.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 | ||
| 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.7 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.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 | ||
| 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.5 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.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 | ||
| 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 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 | ||
| 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.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 | ||
| 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 | |||
| 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 B | ||
| Lesson 05 - Transactions, Locking and Blocking.sql | 4.25 KB | ||
| Sample Databases | |||
| Aesop | |||
| Aesop.adp | 22 KB | ||
| Aesop_Create.sql | 18.18 KB | ||
| CapeHatterasAdventures | |||
| CHA1_Customers.mdb | 120 KB | ||
| CHA1_Schedule.xls | 24 KB | ||
| CHA_Convert.sql | 4.09 KB | ||
| CHA_Create.sql | 7.29 KB | ||
| Family | |||
| Family_Create.sql | 9.93 KB | ||
| Family_Queries.sql | 11.5 KB | ||
| Family_UDF.sql | 907 B | ||
| OBXKites | |||
| OBXKites_Create.sql | 29.22 KB | ||
| OBXKites_Populate.sql | 18.85 KB | ||
| hell.nfo | 2.82 KB | ||
| ▲ 148 total files | |||
Title: Microsoft SQL Server Development
Category: Development & Programming
Presenter: Paul Nielsen
Paul Nielsen believes SQL is the romance language of data. As such he\'s a hands-on database developer, Microsoft SQL Server MVP, trainer, and author of many books including SQL Server 2005 Bible. As a data architect, he developed the concepts of Optimization Theory and Nordic - an O/R dbms for SQL Server, and writes the data architecture column for SQL Standard magazine. Paul supports the SQL community as the Director of Global Community Development with the PASS (Professional Association for SQL Server). You may have seen Paul speaking at a PASS Summit, SQL Open in Denmark, or SQL Teach in Montreal. His website is www.SQLServerBible.com.
Platform: Windows
Format: DVD-ROM & Online
Running Time: 8 Hrs, 2 DVD
Level: Beginner to Advanced
Project Files: Included
Solutions: Multi-User Education Government International More
Description: Total Training for Microsoft SQL Server Development takes you inside the latest, coolest, and most powerful database software platform, Microsoft\'s SQL Server 2005. The tutorials focus on key elements in a logical sequence. You can easily find what you need-including all the SQL Server 2005 basics, best practices, dozens of targeted examples, and sample code. If you design or develop SQL Server 2005 databases, this video series is what you need to succeed!
Highlights
* Master the fundamentals of SQL Server technology.
* Learn how to write better queries to return the exact data required.
* Avoid slow iterative code by refactoring cursors into queries using user-defined functions and case expressions.
* Develop stored procedures using T-SQL.
* Understand how transactions affect performance, how to detect blocking transactions, and how to minimize the impact of locking and blocking.
* Create triggers to build custom audit trails and enforce database rules.
Free Tutorial 1
Free Tutorial 2
Play Quick Time clip
Free Sample Training
View samples traing tutoorials from a large list of topics. We are confident that you\'re going to love our online training courses.
View Free Sample Tutorials
QuickTime Get the latest QuickTime Player
Download the free player
Windows Media Player Get the latest Windows Media Player
Download the free player
Product Family
ASP.NET AJAX
» More Details
ASP.NET 2.0
Building Web Applications (Set 1)
» More Details
ASP.NET 2.0
Building Web Applications (Set 2)
» More Details
Visual Studio 2005
Productivity with .NET Framework 2.0
» More Details
Visual Studio 2008
Essentials - Featuring Windows Forms
» More Details
» View All Microsoft Products
Bundles
Available Microsoft Bundles
Microsoft ASP.NET 2.0
Building Web Applications Bundle
» More Details
Microsoft Expression Studio Bundle
» More Details
Microsoft Expression Studio2: Essentials Bundle
» More Details
Microsoft Office 2007 Bundle
» More Details
» View All Bundles
DISC1:
PART 1: Introduction to SQL Server 2005
Chapter 1: SQL SERVER OVERVIEW (32 min)
1. Understanding Client Server Architecture
2. Introducing the Tools
3. Selecting an Edition
4. Creating Sample Databases
Chapter 2: USING MANAGEMENT STUDIO (23 min)
1. Arranging the Workspace
2. Registering Servers
3. Explaining Items in the Object Explorer
4. Explaining the Database Properties Dialog
5. Explaining the Columns Properties Dialog
6. Continuing with Object Explorer Items
7. Using the Query Editor
Chapter 3: DESIGNING RELATIONAL DATABASES (35 min)
1. Understanding Normalization
2. Discovering Patterns
3. Avoiding Over Complexity
4. Managing Optional Data
5. Creating Physical Keys
6. Using the Database Diagrammer Tool
7. Final Comments
Part 2: Selecting Data
Chapter 1: WORKING WITH SINGLE TABLE QUERIES (42 min)
1. Understanding Query Flow
2. Filtering Data with the Where Clause
3. Columns, Expressions & Scalar Functions
4. Using Case Expressions
5. Working with Nulls & Coalesce
6. Selecting Environment Functions
7. Working with Dates & Times
8. Parsing Strings
9. Converting Data
10. Sorting Data
11. Topping Off the Query with Predicates
Chapter 2: MERGING DATA WITH JOINS & UNIONS (25 min)
1. Working with Inner Joins
2. Using Left Outer Joins
3. Multiplying Data with Cross Joins
4. Referencing Self-Joins
5. Working with Complex Joins
6. Finding the Set Difference
7. Stacking Data with Unions
Chapter 3: WORKING WITH SUBQUERIES (19 min)
1. Using Subqueries as Expressions
2. Including Subqueries as Lists
3. Adding Subqueries as Derived Tables
4. Working with Correlated Subqueries
5. Solving for X with Relations Division
Chapter 4: AGGREGATING DATA (35 min)
1. Using the New Windowing Functions
2. Using Aggregate Functions
3. Grouping a Data Set
4. Nesting Aggregations
5. Filtering Groups & Adding Grand Totals
6. Generating Cross Tab Tables (Pivot)
7. Calculating Cumulative Sums
Chapter 5: USING FULL-TEXT SEARCH (14 min)
1. Creating a Full-Text Index
2. Searching for Words
3. Using a Fuzzy Search to Search for Phrases
Chapter 6: SELECTING DATA THROUGH VIEWS (11 min)
1. Creating Views
2. Preventing Disappearing Rows
3. Protecting from Schema Changes
4. Nesting Views
Chapter 7: DISTRIBUTED QUERIES (18 min)
1. Linking to External Data Sources
2. Executing Distributed Queries
3. Looking at Where the Work Takes Place
4. Using Pass Through Queries
5. Controlling Distributed Transactions
Chapter 8: MODIFYING DATA (29 min)
1. Inserting Data
2. Updating Data
3. Deleting Data
4. Using the Output Clause
5. Final Comments & Credits
PART 3: Developing Solutions
Chapter 1: T-SQL & STORED PROCEDURES (68 min)
1. Introducing T-SQL
2. Working with Variables
3. Controlling Procedural Flow
4. Examining SQL Server with Code
5. Using Temp Tables
6. Developing Dynamic SQL
7. Introducing Stored Procedures
8. Passing Parameters
9. Returning Parameters
10. Working with a Cursor
11. Handling Errors
12. Explaining the Raise Error
13. Controlling Transactions
Chapter 2: TRIGGERS & AUDIT TRAILS (31 min)
1. Introducing After Triggers
2. Using \"Instead of\" Trigger
3. Disabling Triggers
4. Using the Update ( ) Function
5. Selecting Transaction Data
6. Nesting & Recursion
7. Enforcing Complex RI
8. Auditing Data Changes
Chapter 3: USER-DEFINED FUNCTIONS (27 min)
1. Creating Scalar Functions
2. Working with Inline Table-Valued Functions
3. Using Multi-Statement Table-Valued UDFs
4. Navigating a Hierarchy
5. Having Fun with Apply
6. Exploring Functions in Nordic
Chapter 4: INDEXING FOR PERFORMANCE (32 min)
1. Introducing Indexes
2. Creating Indexes
3. Examinging Query Execution Plans, Pt. 1
4. Examinging Query Execution Plans, Pt. 2
Chapter 5: TRANSACTIONS, LOCKING & BLOCKING (33 min)
1. Introducing ACID
2. Understanding Transactional Faults
3. Stepping through a Transaction
4. Exploring Locks
5. Working with Locks
6. Viewing Deadlocks
7. Using Snapshot Isolation
Chapter 6: INTRODUCTION TO OPTIMIZATION THEORY (22 min)
1. Deconstructing the Database System
2. Walking through Optimization Theory
3. Optimization Theory Continued
4. Final Comments & Credits
DISC2:
PART 3: Developing Solutions
Chapter 1: T-SQL & STORED PROCEDURES (68 min)
1. Introducing T-SQL
2. Working with Variables
3. Controlling Procedural Flow
4. Examining SQL Server with Code
5. Using Temp Tables
6. Developing Dynamic SQL
7. Introducing Stored Procedures
8. Passing Parameters
9. Returning Parameters
10. Working with a Cursor
11. Handling Errors
12. Explaining the Raise Error
13. Controlling Transactions
Chapter 2: TRIGGERS & AUDIT TRAILS (31 min)
1. Introducing After Triggers
2. Using \"Instead of\" Trigger
3. Disabling Triggers
4. Using the Update ( ) Function
5. Selecting Transaction Data
6. Nesting & Recursion
7. Enforcing Complex RI
8. Auditing Data Changes
Chapter 3: USER-DEFINED FUNCTIONS (27 min)
1. Creating Scalar Functions
2. Working with Inline Table-Valued Functions
3. Using Multi-Statement Table-Valued UDFs
4. Navigating a Hierarchy
5. Having Fun with Apply
6. Exploring Functions in Nordic
Chapter 4: INDEXING FOR PERFORMANCE (32 min)
1. Introducing Indexes
2. Creating Indexes
3. Examinging Query Execution Plans, Pt. 1
4. Examinging Query Execution Plans, Pt. 2
Chapter 5: TRANSACTIONS, LOCKING & BLOCKING (33 min)
1. Introducing ACID
2. Understanding Transactional Faults
3. Stepping through a Transaction
4. Exploring Locks
5. Working with Locks
6. Viewing Deadlocks
7. Using Snapshot Isolation
Chapter 6: INTRODUCTION TO OPTIMIZATION THEORY (22 min)
1. Deconstructing the Database System
2. Walking through Optimization Theory
3. Optimization Theory Continued
4. Final Comments & Credits
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 1.35 GB | Anonymous | 13 years | 0 | 1 | |
|
Total Training - Microsoft Office 2010 Shared Features-iNKiSO-ed Posted by
Vandermond in Movies
> Other Movies
|
808.79 MB | Vandermond | 14 years | 0 | 1 |
| 1.32 GB | Vandermond | 14 years | 1 | 0 | |
|
Total Training For Microsoft ASP NET 2 0 [Set 2] DVD1 Posted by
bobby_juji10 in Movies
> Other Movies
|
2.25 GB | bobby_juji10 | 15 years | 0 | 1 |
| 2.17 GB | bobby_juji10 | 17 years | 0 | 1 |
All Comments