Sams.Teach.Yourself.Microsoft.SQL.Server.T-SQL.in.10.Minutes.Aug130261471955.042

Files (2): en_sql_server_2008_developer_x86_x64_ia64_dvd_x14-88839.iso (3.0 GB) • deliberate187.nfo (2.6 KB)

Comments (6): I recommend www.dreamspark.com for us students • Cheers mate. This was exactly what I needed. You've also done me a great service by pointing me at DreamSpark - I'm a student and I had *no* idea such a site existed. • Edit.com with Windows XP should do the trick. Just type "edit " at the command line or get an nfo viewer and it'll show it as it was intended to be shown. BTW the readme is the file that you want to read. • how do you open nfo files? • Thanks a lot! • Okay... I found out the system requirements on this... but it's long, so I'll go over the basics... for 32 bit you need a 1.0 GHz processor with at least 512 MB of RAM and Windows XP (any edition) SP2, Vista (any edition), Server 2008 (any edition). or Server 2003 (any edition) For 64 bit you need at least a 1.4GHz with 512 MB RAM and Windows XP x64, Vista 64-bit (any edition), Server 2003 or 2008 x64 (any edition). I believe it is also Itanium compatible. Recommended are at least a 2.0 GHz (32 bit or 64 bit) and at least 2.048 gig RAM.

Files (148): Lesson 11 MODIFYING DATA (29 min)/1. Inserting Data.mov (27.8 MB) • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/2. Discovering Patterns.mov (22.1 MB) • Lesson 1 SQL SERVER OVERVIEW(32 min)/1. Understanding Client Server Architecture.mov (20.7 MB) • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/2. Understanding Transactional Faults.mov (19.9 MB) • Lesson 7 AGGREGATING DATA (35 min)/6. Generating Cross Tab Tables (Pivot).mov (19.9 MB) • Lesson 1 SQL SERVER OVERVIEW(32 min)/4. Creating Sample Databases.mov (19.8 MB) • Lesson 1 SQL SERVER OVERVIEW(32 min)/2. Introducing the Tools.mov (18.8 MB) • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/2. Walking through Optimization Theory.mov (17.5 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/8. Auditing Data Changes.wmv (17.3 MB) • Lesson 8 USING FULL-TEXT SEARCH (14 min)/2. Searching for Words.mov (17.3 MB) • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/1. Working with Inner Joins.mov (17.2 MB) • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/3. Optimization Theory Continued.mov (16.2 MB) • Lesson 1 SQL SERVER OVERVIEW(32 min)/3. Selecting an Addition.mov (15.5 MB) • Lesson 11 MODIFYING DATA (29 min)/2. Updating Data.mov (15.4 MB) • Lesson 7 AGGREGATING DATA (35 min)/3. Grouping a Data Set.mov (14.9 MB) • Lesson 8 USING FULL-TEXT SEARCH (14 min)/1. Creating a Full-Text Index.mov (14.8 MB) • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/1. Creating Views.mov (14.8 MB) • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/3. Avoiding Over Complexity.mov (14.7 MB) • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/2. Creating Indexes.wmv (14.3 MB) • Lesson 7 AGGREGATING DATA (35 min)/1. Using the New Windowing Functions.mov (14.1 MB) • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/6. Viewing Deadlocks.mov (13.9 MB) • Lesson 6 WORKING WITH SUBQUERIES (19 min)/5. Solving for X with Relations Division.mov (13.8 MB) • Lesson 6 WORKING WITH SUBQUERIES (19 min)/1. Using Subqueries as Expressions.mov (13.6 MB) • Lesson 2 USING MANAGEMENT STUDIO(23 min)/4. Explaining the Database Properties Dialog.mov (13.4 MB) • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/4. Navigating a Hierarchy.wmv (13.0 MB) • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/5. Creating Physical Keys.mov (13.0 MB) • Lesson 2 USING MANAGEMENT STUDIO(23 min)/7. Using the Query Editor.mov (13.0 MB) • Lesson 10 DISTRIBUTED QUERIES (18 min)/1. Linking to External Data Sources.mov (12.8 MB) • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/4. Examinging Query Execution Plans, Pt. 2.wmv (12.7 MB) • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/6. Using the Database Diagrammer Tool.mov (12.5 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/5. Using Temp Tables.wmv (12.4 MB) • Lesson 7 AGGREGATING DATA (35 min)/7. Calculating Cumulative Sums.mov (12.3 MB) • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/4. Managing Optional Data.mov (12.2 MB) • Lesson 2 USING MANAGEMENT STUDIO(23 min)/3. Explaining Items in the Object Explorer.mov (12.2 MB) • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/3. Examinging Query Execution Plans, Pt. 1.wmv (12.0 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/2. Working with Variables.wmv (11.8 MB) • Lesson 7 AGGREGATING DATA (35 min)/5. Filtering Groups & Adding Grand Totals.mov (11.7 MB) • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/7. Stacking Data with Unions.mov (11.4 MB) • Lesson 11 MODIFYING DATA (29 min)/3. Deleting Data.mov (11.0 MB) • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/5. Working with Locks.mov (10.9 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/2. Filtering Data with the Where Clause.wmv (10.8 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/11. Handling Errors.wmv (10.5 MB) • Lesson 11 MODIFYING DATA (29 min)/5. Final Comments & Credits.mov (10.2 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/9. Returning Parameters.wmv (9.9 MB) • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/4. Final Comments & Credits.mov (9.9 MB) • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/4. Referencing Self-Joins.mov (9.9 MB) • Lesson 10 DISTRIBUTED QUERIES (18 min)/2. Executing Distributed Queries.wmv (9.8 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/6. Developing Dynamic SQL.wmv (9.8 MB) • Lesson 6 WORKING WITH SUBQUERIES (19 min)/4. Working with Correlated Subqueries.mov (9.8 MB) • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/7. Using Snapshot Isolation.mov (9.4 MB) • Lesson 11 MODIFYING DATA (29 min)/4. Using the Output Clause.mov (8.9 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/12. Explaining the Raise Error.wmv (8.7 MB) • Lesson 7 AGGREGATING DATA (35 min)/2. Using Aggregate Functions.mov (8.7 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/1. Understanding Query Flow.wmv (8.6 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/10. Working with a Cursor.wmv (8.6 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/7. Introducing Stored Procedures.wmv (8.5 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/4. Using Case Expressions.wmv (8.3 MB) • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/6. Exploring Functions in Nordic.wmv (8.3 MB) • Lesson 10 DISTRIBUTED QUERIES (18 min)/5. Controlling Distributed Transactions.mov (8.2 MB) • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/1. Creating Scalar Functions.wmv (8.1 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/7. Working with Dates & Times.wmv (8.0 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/6. Nesting & Recursion.wmv (7.9 MB) • Lesson 2 USING MANAGEMENT STUDIO(23 min)/5. Explaining the Columns Properties Dialog.mov (7.5 MB) • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/2. Using Left Outer Joins.mov (7.4 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/2. Using Instead of Trigger.wmv (7.3 MB) • Lesson 7 AGGREGATING DATA (35 min)/4. Nesting Aggregations.mov (7.1 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/3. Controlling Procedural Flow.wmv (7.0 MB) • Lesson 1 SQL SERVER OVERVIEW(32 min)/0. Introduction.mov (6.9 MB) • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/2. Working with Inline Table-Valued Functions.wmv (6.8 MB) • Lesson 10 DISTRIBUTED QUERIES (18 min)/4. Using Pass Through Queries.mov (6.6 MB) • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/1. Understanding Normalization.mov (6.4 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/7. Enforcing Complex RI.wmv (6.1 MB) • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/3. Multiplying Data with Cross Joins.mov (6.1 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/5. Working with Nulls & Coalesce.wmv (6.0 MB) • Lesson 10 DISTRIBUTED QUERIES (18 min)/3. Looking at Where the Work Takes Place.mov (6.0 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/11. Topping Off the Query with Predicates.wmv (5.9 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/8. Passing Parameters.wmv (5.8 MB) • Lesson 2 USING MANAGEMENT STUDIO(23 min)/2. Registering Servers.mov (5.7 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/13. Controlling Transactions.wmv (5.5 MB) • Lesson 6 WORKING WITH SUBQUERIES (19 min)/2. Including Subqueries as Lists.mov (5.3 MB) • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/1. Deconstructing the Database System.mov (5.2 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/4. Examining SQL Server with Code.wmv (5.1 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/1. Introducing T-SQL.wmv (5.1 MB) • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/2. Preventing Disappearing Rows.mov (5.0 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/5. Selecting Transaction Data.wmv (5.0 MB) • Lesson 2 USING MANAGEMENT STUDIO(23 min)/1. Arranging the Workspace.mov (4.9 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/1. Introducing After Triggers.wmv (4.9 MB) • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/4. Nesting Views.mov (4.9 MB) • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/6. Finding the Set Difference.mov (4.8 MB) • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/4. Exploring Locks.wmv (4.6 MB) • Lesson 6 WORKING WITH SUBQUERIES (19 min)/3. Adding Subqueries as Derived Tables.mov (4.5 MB) • Lesson 2 USING MANAGEMENT STUDIO(23 min)/6. Continuing with Object Explorer Items.mov (4.4 MB) • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/5. Having Fun with Apply.wmv (4.4 MB) • Lesson 8 USING FULL-TEXT SEARCH (14 min)/3. Using a Fuzzy Search to Search for Phrases.mov (4.2 MB) • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/5. Working with Complex Joins.mov (4.1 MB) • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/1. Introducing Indexes.wmv (4.1 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/8. Parsing Strings.wmv (4.0 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/10. Sorting Data.wmv (4.0 MB) • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/3. Protecting from Schema Changes.mov (4.0 MB) • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/3. Using Multi-Statement Table-Valued UDFs.wmv (3.7 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/3. Columns, Expressions & Scalar Functions.wmv (3.7 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/9. Converting Data.wmv (3.6 MB) • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/3. Stepping through a Transaction.wmv (3.1 MB) • Lesson 10 DISTRIBUTED QUERIES (18 min)/0. Introduction.mov (2.8 MB) • Lesson 11 MODIFYING DATA (29 min)/0.Introduction.mov (2.8 MB) • Lesson 12 T-SQL & STORED PROCEDURES (68 min)/0. Introduction.wmv (2.7 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/3. Disabling Triggers.wmv (2.6 MB) • Lesson 6 WORKING WITH SUBQUERIES (19 min)/0. Introduction.mov (2.6 MB) • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/0. Introduction.mov (2.3 MB) • Lesson 15 INDEXING FOR PERFORMANCE (31 min)/0. Introduction.wmv (2.2 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/4. Using the Update ( ) Function.wmv (2.2 MB) • Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)/0. Introduction.mov (2.0 MB) • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/1. Introducing ACID.wmv (2.0 MB) • Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)/0. Introduction.wmv (2.0 MB) • Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)/6. Selecting Environment Functions.wmv (1.9 MB) • Lesson 14 USER-DEFINED FUNCTIONS (27 min)/0. Introduction.wmv (1.9 MB) • Lesson 2 USING MANAGEMENT STUDIO(23 min)/0. Introduction.mov (1.8 MB) • Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)/7. Final Comments.mov (1.8 MB) • Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)/0. Introduction.mov (1.7 MB) • Lesson 7 AGGREGATING DATA (35 min)/0. Introduction.mov (1.6 MB) • Lesson 8 USING FULL-TEXT SEARCH (14 min)/0. Introduction.mov (1.6 MB) • Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)/0 Introduction.wmv (1.4 MB) • Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)/0. Introduction.wmv (1.1 MB) • Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Customers.mdb (120.0 KB) • Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Create.sql (29.2 KB) • Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA1_Schedule.xls (24.0 KB) • Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop.adp (22.0 KB) • Project Files - SQL Server 2005/Sample Databases/OBXKites/OBXKites_Populate.sql (18.8 KB) • Project Files - SQL Server 2005/Sample Databases/Aesop/Aesop_Create.sql (18.2 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 04 - Aggregating Data.sql (16.3 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 01 - T-SQL and Stored Procedures.sql (12.4 KB) • Project Files - SQL Server 2005/Sample Databases/Family/Family_Queries.sql (11.5 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 02 - Triggers.sql (11.5 KB) • Project Files - SQL Server 2005/Sample Databases/Family/Family_Create.sql (9.9 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 03 - Subqueries.sql (9.9 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 01 - Selecting Data.sql (9.5 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 08 - Modifying Data.sql (8.4 KB) • Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Create.sql (7.3 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 03 - User-Defined Functions.sql (6.2 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 02 - Joins and Unions.sql (4.8 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/LE7F94~1.SQL (4.3 KB) • Project Files - SQL Server 2005/Sample Databases/CapeHatterasAdventures/CHA_Convert.sql (4.1 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 07 - Distributed Queries.sql (4.1 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 05 - FullText Search.sql (3.7 KB) • Project Files - SQL Server 2005/Lesson Scripts/Part 2 - Selecting Data/Lesson 06 - Views.sql (3.1 KB) • Project Files - SQL Server 2005/Sample Databases/Family/Family_UDF.sql (907 bytes) • Project Files - SQL Server 2005/Lesson Scripts/Part 3 - Developing Solutions/Lesson 04 - Indexing.sql (793 bytes)

Comments (1): No seeders. Stops at 55.9%. CHEAT !!!

Files (45): i-cbtn70448.r00 (14.3 MB) • i-cbtn70448.r01 (14.3 MB) • i-cbtn70448.r02 (14.3 MB) • i-cbtn70448.r03 (14.3 MB) • i-cbtn70448.r04 (14.3 MB) • i-cbtn70448.r05 (14.3 MB) • i-cbtn70448.r06 (14.3 MB) • i-cbtn70448.r07 (14.3 MB) • i-cbtn70448.r08 (14.3 MB) • i-cbtn70448.r09 (14.3 MB) • i-cbtn70448.r10 (14.3 MB) • i-cbtn70448.r11 (14.3 MB) • i-cbtn70448.r12 (14.3 MB) • i-cbtn70448.r13 (14.3 MB) • i-cbtn70448.r14 (14.3 MB) • i-cbtn70448.r15 (14.3 MB) • i-cbtn70448.r16 (14.3 MB) • i-cbtn70448.r17 (14.3 MB) • i-cbtn70448.r18 (14.3 MB) • i-cbtn70448.r19 (14.3 MB) • i-cbtn70448.r20 (14.3 MB) • i-cbtn70448.r21 (14.3 MB) • i-cbtn70448.r22 (14.3 MB) • i-cbtn70448.r23 (14.3 MB) • i-cbtn70448.r24 (14.3 MB) • i-cbtn70448.r25 (14.3 MB) • i-cbtn70448.r26 (14.3 MB) • i-cbtn70448.r27 (14.3 MB) • i-cbtn70448.r28 (14.3 MB) • i-cbtn70448.r29 (14.3 MB) • i-cbtn70448.r30 (14.3 MB) • i-cbtn70448.r31 (14.3 MB) • i-cbtn70448.r32 (14.3 MB) • i-cbtn70448.r33 (14.3 MB) • i-cbtn70448.r34 (14.3 MB) • i-cbtn70448.r35 (14.3 MB) • i-cbtn70448.r36 (14.3 MB) • i-cbtn70448.r37 (14.3 MB) • i-cbtn70448.r38 (14.3 MB) • i-cbtn70448.r39 (14.3 MB) • i-cbtn70448.r40 (14.3 MB) • i-cbtn70448.rar (14.3 MB) • i-cbtn70448.r41 (1.4 MB) • i-cbtn70448.nfo (7.9 KB) • i-cbtn70448.sfv (1.1 KB)

Files (33): kip-cbt70-433.r00 (14.3 MB) • kip-cbt70-433.r01 (14.3 MB) • kip-cbt70-433.r02 (14.3 MB) • kip-cbt70-433.r03 (14.3 MB) • kip-cbt70-433.r04 (14.3 MB) • kip-cbt70-433.r05 (14.3 MB) • kip-cbt70-433.r06 (14.3 MB) • kip-cbt70-433.r07 (14.3 MB) • kip-cbt70-433.r08 (14.3 MB) • kip-cbt70-433.r09 (14.3 MB) • kip-cbt70-433.r10 (14.3 MB) • kip-cbt70-433.r11 (14.3 MB) • kip-cbt70-433.r12 (14.3 MB) • kip-cbt70-433.r13 (14.3 MB) • kip-cbt70-433.r14 (14.3 MB) • kip-cbt70-433.r15 (14.3 MB) • kip-cbt70-433.r16 (14.3 MB) • kip-cbt70-433.r17 (14.3 MB) • kip-cbt70-433.r18 (14.3 MB) • kip-cbt70-433.r19 (14.3 MB) • kip-cbt70-433.r20 (14.3 MB) • kip-cbt70-433.r21 (14.3 MB) • kip-cbt70-433.r22 (14.3 MB) • kip-cbt70-433.r23 (14.3 MB) • kip-cbt70-433.r24 (14.3 MB) • kip-cbt70-433.r25 (14.3 MB) • kip-cbt70-433.r26 (14.3 MB) • kip-cbt70-433.r27 (14.3 MB) • kip-cbt70-433.r28 (14.3 MB) • kip-cbt70-433.rar (14.3 MB) • kip-cbt70-433.r29 (11.1 MB) • kip-cbt70-433.sfv (868 bytes)