Download Total Training for Microsoft SQL Server Development Torrent

Torrent Contents Size: 1.04 GB

Total Training for Microsoft SQL Server Development

▼ show more 133 files

Lesson 1 SQL SERVER OVERVIEW(32 min)

0. Introduction.mov	MOV	6.87 MB
1. Understanding Client Server Architecture.mov	MOV	20.66 MB
2. Introducing the Tools.mov	MOV	18.82 MB
3. Selecting an Addition.mov	MOV	15.54 MB
4. Creating Sample Databases.mov	MOV	19.8 MB

Lesson 10 DISTRIBUTED QUERIES (18 min)

0. Introduction.mov	MOV	2.84 MB
1. Linking to External Data Sources.mov	MOV	12.83 MB
2. Executing Distributed Queries.wmv	WMV	9.82 MB
3. Looking at Where the Work Takes Place.mov	MOV	6.04 MB
4. Using Pass Through Queries.mov	MOV	6.58 MB
5. Controlling Distributed Transactions.mov	MOV	8.21 MB

Lesson 11 MODIFYING DATA (29 min)

0.Introduction.mov	MOV	2.8 MB
1. Inserting Data.mov	MOV	27.84 MB
2. Updating Data.mov	MOV	15.45 MB
3. Deleting Data.mov	MOV	11.01 MB
4. Using the Output Clause.mov	MOV	8.87 MB
5. Final Comments & Credits.mov	MOV	10.24 MB

Lesson 12 T-SQL & STORED PROCEDURES (68 min)

0. Introduction.wmv	WMV	2.73 MB
1. Introducing T-SQL.wmv	WMV	5.06 MB
10. Working with a Cursor.wmv	WMV	8.61 MB
11. Handling Errors.wmv	WMV	10.52 MB
12. Explaining the Raise Error.wmv	WMV	8.74 MB
13. Controlling Transactions.wmv	WMV	5.46 MB
2. Working with Variables.wmv	WMV	11.83 MB
3. Controlling Procedural Flow.wmv	WMV	7.01 MB
4. Examining SQL Server with Code.wmv	WMV	5.13 MB
5. Using Temp Tables.wmv	WMV	12.45 MB
6. Developing Dynamic SQL.wmv	WMV	9.81 MB
7. Introducing Stored Procedures.wmv	WMV	8.49 MB
8. Passing Parameters.wmv	WMV	5.76 MB
9. Returning Parameters.wmv	WMV	9.94 MB

Lesson 13 TRIGGERS & AUDIT TRAILS (31 min)

0. Introduction.wmv	WMV	1.96 MB
1. Introducing After Triggers.wmv	WMV	4.89 MB
2. Using Instead of Trigger.wmv	WMV	7.34 MB
3. Disabling Triggers.wmv	WMV	2.64 MB
4. Using the Update ( ) Function.wmv	WMV	2.16 MB
5. Selecting Transaction Data.wmv	WMV	4.99 MB
6. Nesting & Recursion.wmv	WMV	7.9 MB
7. Enforcing Complex RI.wmv	WMV	6.14 MB
8. Auditing Data Changes.wmv	WMV	17.31 MB

Lesson 14 USER-DEFINED FUNCTIONS (27 min)

0. Introduction.wmv	WMV	1.91 MB
1. Creating Scalar Functions.wmv	WMV	8.1 MB
2. Working with Inline Table-Valued Functions.wmv	WMV	6.77 MB
3. Using Multi-Statement Table-Valued UDFs.wmv	WMV	3.68 MB
4. Navigating a Hierarchy.wmv	WMV	12.97 MB
5. Having Fun with Apply.wmv	WMV	4.4 MB
6. Exploring Functions in Nordic.wmv	WMV	8.27 MB

Lesson 15 INDEXING FOR PERFORMANCE (31 min)

0. Introduction.wmv	WMV	2.25 MB
1. Introducing Indexes.wmv	WMV	4.09 MB
2. Creating Indexes.wmv	WMV	14.31 MB
3. Examinging Query Execution Plans, Pt. 1.wmv	WMV	12.01 MB
4. Examinging Query Execution Plans, Pt. 2.wmv	WMV	12.7 MB

Lesson 16 TRANSACTIONS, LOCKING & BLOCKING (33 min)

0 Introduction.wmv	WMV	1.43 MB
1. Introducing ACID.wmv	WMV	1.98 MB
2. Understanding Transactional Faults.mov	MOV	19.88 MB
3. Stepping through a Transaction.wmv	WMV	3.14 MB
4. Exploring Locks.wmv	WMV	4.6 MB
5. Working with Locks.mov	MOV	10.93 MB
6. Viewing Deadlocks.mov	MOV	13.85 MB
7. Using Snapshot Isolation.mov	MOV	9.44 MB

Lesson 17 INTRODUCTION TO OPTIMIZATION THEORY (21 min)

0. Introduction.wmv	WMV	1.07 MB
1. Deconstructing the Database System.mov	MOV	5.16 MB
2. Walking through Optimization Theory.mov	MOV	17.5 MB
3. Optimization Theory Continued.mov	MOV	16.18 MB
4. Final Comments & Credits.mov	MOV	9.91 MB

Lesson 2 USING MANAGEMENT STUDIO(23 min)

0. Introduction.mov	MOV	1.85 MB
1. Arranging the Workspace.mov	MOV	4.9 MB
2. Registering Servers.mov	MOV	5.74 MB
3. Explaining Items in the Object Explorer.mov	MOV	12.2 MB
4. Explaining the Database Properties Dialog.mov	MOV	13.4 MB
5. Explaining the Columns Properties Dialog.mov	MOV	7.55 MB
6. Continuing with Object Explorer Items.mov	MOV	4.41 MB
7. Using the Query Editor.mov	MOV	12.96 MB

Lesson 3 DESIGNING RELATIONAL DATABASES(35 min)

0. Introduction.mov	MOV	2.26 MB
1. Understanding Normalization.mov	MOV	6.38 MB
2. Discovering Patterns.mov	MOV	22.15 MB
3. Avoiding Over Complexity.mov	MOV	14.67 MB
4. Managing Optional Data.mov	MOV	12.25 MB
5. Creating Physical Keys.mov	MOV	12.96 MB
6. Using the Database Diagrammer Tool.mov	MOV	12.47 MB
7. Final Comments.mov	MOV	1.81 MB

Lesson 4 WORKING WITH SINGLE TABLE QUERIES(42 min)

1. Understanding Query Flow.wmv	WMV	8.63 MB
10. Sorting Data.wmv	WMV	3.97 MB
11. Topping Off the Query with Predicates.wmv	WMV	5.92 MB
2. Filtering Data with the Where Clause.wmv	WMV	10.85 MB
3. Columns, Expressions & Scalar Functions.wmv	WMV	3.65 MB
4. Using Case Expressions.wmv	WMV	8.33 MB
5. Working with Nulls & Coalesce.wmv	WMV	6.05 MB
6. Selecting Environment Functions.wmv	WMV	1.93 MB
7. Working with Dates & Times.wmv	WMV	7.99 MB
8. Parsing Strings.wmv	WMV	3.98 MB
9. Converting Data.wmv	WMV	3.65 MB

Lesson 5 MERGING DATA WITH JOINS & UNIONS(25 min)

0. Introduction.mov	MOV	2 MB
1. Working with Inner Joins.mov	MOV	17.2 MB
2. Using Left Outer Joins.mov	MOV	7.38 MB
3. Multiplying Data with Cross Joins.mov	MOV	6.11 MB
4. Referencing Self-Joins.mov	MOV	9.9 MB
5. Working with Complex Joins.mov	MOV	4.11 MB
6. Finding the Set Difference.mov	MOV	4.81 MB
7. Stacking Data with Unions.mov	MOV	11.39 MB

Lesson 6 WORKING WITH SUBQUERIES (19 min)

0. Introduction.mov	MOV	2.62 MB
1. Using Subqueries as Expressions.mov	MOV	13.57 MB
2. Including Subqueries as Lists.mov	MOV	5.32 MB
3. Adding Subqueries as Derived Tables.mov	MOV	4.54 MB
4. Working with Correlated Subqueries.mov	MOV	9.77 MB
5. Solving for X with Relations Division.mov	MOV	13.84 MB

Lesson 7 AGGREGATING DATA (35 min)

0. Introduction.mov	MOV	1.62 MB
1. Using the New Windowing Functions.mov	MOV	14.06 MB
2. Using Aggregate Functions.mov	MOV	8.7 MB
3. Grouping a Data Set.mov	MOV	14.88 MB
4. Nesting Aggregations.mov	MOV	7.11 MB
5. Filtering Groups & Adding Grand Totals.mov	MOV	11.75 MB
6. Generating Cross Tab Tables (Pivot).mov	MOV	19.87 MB
7. Calculating Cumulative Sums.mov	MOV	12.31 MB

Lesson 8 USING FULL-TEXT SEARCH (14 min)

0. Introduction.mov	MOV	1.59 MB
1. Creating a Full-Text Index.mov	MOV	14.79 MB
2. Searching for Words.mov	MOV	17.27 MB
3. Using a Fuzzy Search to Search for Phrases.mov	MOV	4.18 MB

Lesson 9 SELECTING DATA THROUGH VIEWS (11 min)

0. Introduction.mov	MOV	1.69 MB
1. Creating Views.mov	MOV	14.76 MB
2. Preventing Disappearing Rows.mov	MOV	5.03 MB
3. Protecting from Schema Changes.mov	MOV	3.96 MB
4. Nesting Views.mov	MOV	4.88 MB

Project Files - SQL Server 2005

Lesson Scripts

Part 2 - Selecting Data

Lesson 01 - Selecting Data.sql	SQL	9.53 KB
Lesson 02 - Joins and Unions.sql	SQL	4.82 KB
Lesson 03 - Subqueries.sql	SQL	9.93 KB
Lesson 04 - Aggregating Data.sql	SQL	16.33 KB
Lesson 05 - FullText Search.sql	SQL	3.69 KB
Lesson 06 - Views.sql	SQL	3.06 KB
Lesson 07 - Distributed Queries.sql	SQL	4.07 KB
Lesson 08 - Modifying Data.sql	SQL	8.36 KB

Part 3 - Developing Solutions

Lesson 01 - T-SQL and Stored Procedures.sql	SQL	12.39 KB
Lesson 02 - Triggers.sql	SQL	11.48 KB
Lesson 03 - User-Defined Functions.sql	SQL	6.16 KB
Lesson 04 - Indexing.sql	SQL	793 B
Lesson 05 - Transactions, Locking and Blocking.sql	SQL	4.25 KB

Sample Databases

Aesop

	Aesop.adp	ADP	22 KB
	Aesop_Create.sql	SQL	18.18 KB

CapeHatterasAdventures

CHA1_Customers.mdb	MDB	120 KB
CHA1_Schedule.xls	XLS	24 KB
CHA_Convert.sql	SQL	4.09 KB
CHA_Create.sql	SQL	7.29 KB

Family

Family_Create.sql	SQL	9.93 KB
Family_Queries.sql	SQL	11.5 KB
Family_UDF.sql	SQL	907 B

OBXKites

	OBXKites_Create.sql	SQL	29.22 KB
	OBXKites_Populate.sql	SQL	18.85 KB

hell.nfo

NFO

2.82 KB

Description

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Total training Excel 2010 - Advance Posted by Anonymous in Movies - Other Movies Posted in Movies - Other Movies 0 1.35 GB 13 years ago Anonymous	Size 1.35 GB	Files 99	Age 13 years ago	Seeds 0	Leechs 1	Source
Total Training - Microsoft Office 2010 Shared Features-iNKiSO-ed Posted by Vandermond in Movies - Other Movies Posted in Movies - Other Movies 0 808.79 MB 14 years ago Vandermond	Size 808.79 MB	Files 113	Age 14 years ago	Seeds 0	Leechs 1	Source
Total Training - Microsoft Word 2010-iNKiSO-edited Posted by Vandermond in Movies - Other Movies Posted in Movies - Other Movies 1 1.32 GB 14 years ago Vandermond	Size 1.32 GB	Files 93	Age 14 years ago	Seeds 1	Leechs 0	Source
Total Training For Microsoft ASP NET 2 0 [Set 2] DVD1 Posted by bobby_juji10 in Movies - Other Movies Posted in Movies - Other Movies 0 2.25 GB 15 years ago bobby_juji10	Size 2.25 GB	Files 1	Age 15 years ago	Seeds 0	Leechs 1	Source
Total Training ASP NET 2 0 (DVD-1) Posted by bobby_juji10 in Movies - Other Movies Posted in Movies - Other Movies 0 2.17 GB 16 years ago bobby_juji10	Size 2.17 GB	Files 1	Age 16 years ago	Seeds 0	Leechs 1	Source

Total Training for Microsoft SQL Server Development

Torrent Contents Size: 1.04 GB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce