种子简介

种子名称： TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL
文件类型： 视频
文件数目： 123个文件
文件大小： 1.04 GB
收录时间： 2016-9-3 23:19
已经下载： 3次
资源热度： 89
最近下载： 2024-12-19 07:19

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:fe75dbc2ede8027f9a353aaf47a0916d8bbdced7&dn=TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

TOTAL.TRAINING.ONLINE.MICROSOFT.SQL.SERVER.DEVELOPMENT-HELL.torrent

Lesson 1 SQL SERVER OVERVIEW(32 min)/0. Introduction.mov6.87MB

Lesson 1 SQL SERVER OVERVIEW(32 min)/1. Understanding Client Server Architecture.mov20.66MB

Lesson 1 SQL SERVER OVERVIEW(32 min)/2. Introducing the Tools.mov18.82MB

Lesson 1 SQL SERVER OVERVIEW(32 min)/3. Selecting an Addition.mov15.54MB

Lesson 1 SQL SERVER OVERVIEW(32 min)/4. Creating Sample Databases.mov19.8MB

Lesson 10 DISTRIBUTED QUERIES (18 min)/0. Introduction.mov2.84MB

Lesson 10 DISTRIBUTED QUERIES (18 min)/1. Linking to External Data Sources.mov12.83MB

Lesson 10 DISTRIBUTED QUERIES (18 min)/2. Executing Distributed Queries.wmv9.82MB

Lesson 10 DISTRIBUTED QUERIES (18 min)/3. Looking at Where the Work Takes Place.mov6.04MB

Lesson 10 DISTRIBUTED QUERIES (18 min)/4. Using Pass Through Queries.mov6.58MB

Lesson 10 DISTRIBUTED QUERIES (18 min)/5. Controlling Distributed Transactions.mov8.21MB

Lesson 11 MODIFYING DATA (29 min)/0.Introduction.mov2.8MB

Lesson 11 MODIFYING DATA (29 min)/1. Inserting Data.mov27.84MB

Lesson 11 MODIFYING DATA (29 min)/2. Updating Data.mov15.45MB

Lesson 11 MODIFYING DATA (29 min)/3. Deleting Data.mov11.01MB

Lesson 11 MODIFYING DATA (29 min)/4. Using the Output Clause.mov8.87MB

Lesson 11 MODIFYING DATA (29 min)/5. Final Comments & Credits.mov10.24MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/0. Introduction.wmv2.73MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/1. Introducing T-SQL.wmv5.06MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/10. Working with a Cursor.wmv8.61MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/11. Handling Errors.wmv10.52MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/12. Explaining the Raise Error.wmv8.74MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/13. Controlling Transactions.wmv5.46MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/2. Working with Variables.wmv11.83MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/3. Controlling Procedural Flow.wmv7.01MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/4. Examining SQL Server with Code.wmv5.13MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/5. Using Temp Tables.wmv12.45MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/6. Developing Dynamic SQL.wmv9.81MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/7. Introducing Stored Procedures.wmv8.49MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/8. Passing Parameters.wmv5.76MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)/9. Returning Parameters.wmv9.94MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/0. Introduction.wmv1.96MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/1. Introducing After Triggers.wmv4.89MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/2. Using Instead of Trigger.wmv7.34MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/3. Disabling Triggers.wmv2.64MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/4. Using the Update ( ) Function.wmv2.16MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/5. Selecting Transaction Data.wmv4.99MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/6. Nesting & Recursion.wmv7.9MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/7. Enforcing Complex RI.wmv6.14MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/8. Auditing Data Changes.wmv17.31MB

Lesson 14 USER-DEFINED FUNCTIONS (27 min)/0. Introduction.wmv1.91MB

Lesson 14 USER-DEFINED FUNCTIONS (27 min)/1. Creating Scalar Functions.wmv8.1MB

Lesson 14 USER-DEFINED FUNCTIONS (27 min)/2. Working with Inline Table-Valued Functions.wmv6.77MB

Lesson 14 USER-DEFINED FUNCTIONS (27 min)/3. Using Multi-Statement Table-Valued UDFs.wmv3.68MB

Lesson 14 USER-DEFINED FUNCTIONS (27 min)/4. Navigating a Hierarchy.wmv12.97MB

Lesson 14 USER-DEFINED FUNCTIONS (27 min)/5. Having Fun with Apply.wmv4.4MB

Lesson 14 USER-DEFINED FUNCTIONS (27 min)/6. Exploring Functions in Nordic.wmv8.27MB

Lesson 15 INDEXING FOR PERFORMANCE (31 min)/0. Introduction.wmv2.25MB

Lesson 15 INDEXING FOR PERFORMANCE (31 min)/1. Introducing Indexes.wmv4.09MB

Lesson 15 INDEXING FOR PERFORMANCE (31 min)/2. Creating Indexes.wmv14.31MB

Lesson 15 INDEXING FOR PERFORMANCE (31 min)/3. Examinging Query Execution Plans, Pt. 1.wmv12.01MB

Lesson 15 INDEXING FOR PERFORMANCE (31 min)/4. Examinging Query Execution Plans, Pt. 2.wmv12.7MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/0 Introduction.wmv1.43MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/1. Introducing ACID.wmv1.98MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/2. Understanding Transactional Faults.mov19.88MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/3. Stepping through a Transaction.wmv3.14MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/4. Exploring Locks.wmv4.6MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/5. Working with Locks.mov10.93MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/6. Viewing Deadlocks.mov13.85MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/7. Using Snapshot Isolation.mov9.44MB

Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/0. Introduction.wmv1.07MB

Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/1. Deconstructing the Database System.mov5.16MB

Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/2. Walking through Optimization Theory.mov17.5MB

Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/3. Optimization Theory Continued.mov16.18MB

Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/4. Final Comments & Credits.mov9.91MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)/0. Introduction.mov1.85MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)/1. Arranging the Workspace.mov4.9MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)/2. Registering Servers.mov5.74MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)/3. Explaining Items in the Object Explorer.mov12.2MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)/4. Explaining the Database Properties Dialog.mov13.4MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)/5. Explaining the Columns Properties Dialog.mov7.55MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)/6. Continuing with Object Explorer Items.mov4.41MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)/7. Using the Query Editor.mov12.96MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/0. Introduction.mov2.26MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/1. Understanding Normalization.mov6.38MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/2. Discovering Patterns.mov22.15MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/3. Avoiding Over Complexity.mov14.67MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/4. Managing Optional Data.mov12.25MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/5. Creating Physical Keys.mov12.96MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/6. Using the Database Diagrammer Tool.mov12.47MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/7. Final Comments.mov1.81MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/1. Understanding Query Flow.wmv8.63MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/10. Sorting Data.wmv3.97MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/11. Topping Off the Query with Predicates.wmv5.92MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/2. Filtering Data with the Where Clause.wmv10.85MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/3. Columns, Expressions & Scalar Functions.wmv3.65MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/4. Using Case Expressions.wmv8.33MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/5. Working with Nulls & Coalesce.wmv6.05MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/6. Selecting Environment Functions.wmv1.93MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/7. Working with Dates & Times.wmv7.99MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/8. Parsing Strings.wmv3.98MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/9. Converting Data.wmv3.65MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/0. Introduction.mov2MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/1. Working with Inner Joins.mov17.2MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/2. Using Left Outer Joins.mov7.38MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/3. Multiplying Data with Cross Joins.mov6.11MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/4. Referencing Self-Joins.mov9.9MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/5. Working with Complex Joins.mov4.11MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/6. Finding the Set Difference.mov4.81MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/7. Stacking Data with Unions.mov11.39MB

Lesson 6 WORKING WITH SUBQUERIES (19 min)/0. Introduction.mov2.62MB

Lesson 6 WORKING WITH SUBQUERIES (19 min)/1. Using Subqueries as Expressions.mov13.57MB

Lesson 6 WORKING WITH SUBQUERIES (19 min)/2. Including Subqueries as Lists.mov5.32MB

Lesson 6 WORKING WITH SUBQUERIES (19 min)/3. Adding Subqueries as Derived Tables.mov4.54MB

Lesson 6 WORKING WITH SUBQUERIES (19 min)/4. Working with Correlated Subqueries.mov9.77MB

Lesson 6 WORKING WITH SUBQUERIES (19 min)/5. Solving for X with Relations Division.mov13.84MB

Lesson 7 AGGREGATING DATA (35 min)/0. Introduction.mov1.62MB

Lesson 7 AGGREGATING DATA (35 min)/1. Using the New Windowing Functions.mov14.06MB

Lesson 7 AGGREGATING DATA (35 min)/2. Using Aggregate Functions.mov8.7MB

Lesson 7 AGGREGATING DATA (35 min)/3. Grouping a Data Set.mov14.88MB

Lesson 7 AGGREGATING DATA (35 min)/4. Nesting Aggregations.mov7.11MB

Lesson 7 AGGREGATING DATA (35 min)/5. Filtering Groups & Adding Grand Totals.mov11.75MB

Lesson 7 AGGREGATING DATA (35 min)/6. Generating Cross Tab Tables (Pivot).mov19.87MB

Lesson 7 AGGREGATING DATA (35 min)/7. Calculating Cumulative Sums.mov12.31MB

Lesson 8 USING FULL-TEXT SEARCH (14 min)/0. Introduction.mov1.59MB

Lesson 8 USING FULL-TEXT SEARCH (14 min)/1. Creating a Full-Text Index.mov14.79MB

Lesson 8 USING FULL-TEXT SEARCH (14 min)/2. Searching for Words.mov17.27MB

Lesson 8 USING FULL-TEXT SEARCH (14 min)/3. Using a Fuzzy Search to Search for Phrases.mov4.18MB

Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/0. Introduction.mov1.69MB

Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/1. Creating Views.mov14.76MB

Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/2. Preventing Disappearing Rows.mov5.03MB

Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/3. Protecting from Schema Changes.mov3.96MB

Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/4. Nesting Views.mov4.88MB