Total Training - Microsoft SQL Server Development

1. 76.Final Comments & Credits.mp426.94MB
2. 124.Final Comments & Credits.mp426.52MB
3. 72.Inserting Data.mp423.73MB
4. 5.Creating Sample Databases.mp422.26MB
5. 99.Auditing Data Changes.mp421.75MB
6. 1.INTRODUCTION.mp420MB
7. 16.Discovering Patterns.mp419.56MB
8. 3.Introducing the Tools.mp419.23MB
9. 110.Examinging Query Execution Plans Pt. 0.mp418.94MB
10. 4.Selecting an Edition.mp416.69MB
11. 109.Creating Indexes.mp416.28MB
12. 54.Generating Cross Tab Tables (Pivot).mp416.12MB
13. 58.Searching for Words.mp415.76MB
14. 35.Working with Inner Joins.mp415.18MB
15. 114.Understanding Transactional Faults.mp414.36MB
16. 82.Using Temp Tables.mp414.06MB
17. 111.Examinging Query Execution Plans Pt. 1.mp413.53MB
18. 20.Using the Database Diagrammer Tool.mp413.39MB
19. 47.Solving for X with Relations Division.mp413.37MB
20. 79.Working with Variables.mp413.35MB
21. 73.Updating Data.mp413.12MB
22. 122.Walking through Optimization Theory.mp413.07MB
23. 24.Filtering Data with the Where Clause.mp412.95MB
24. 123.Optimization Theory Continued.mp412.44MB
25. 118.Viewing Deadlocks.mp412.42MB
26. 49.Using the New Windowing Functions.mp412.24MB
27. 106.Exploring Functions in Nordic.mp412.11MB
28. 51.Grouping a Data Set.mp412MB
29. 67.Executing Distributed Queries.mp411.74MB
30. 83.Developing Dynamic SQL.mp411.7MB
31. 88.Handling Errors.mp411.48MB
32. 66.Linking to External Data Sources.mp411.44MB
33. 55.Calculating Cumulative Sums.mp411.24MB
34. 53.Filtering Groups & Adding Grand Totals.mp411.2MB
35. 13.Using the Query Editor.mp411.18MB
36. 23.Understanding Query Flow.mp410.97MB
37. 101.Creating Scalar Functions.mp410.94MB
38. 43.Using Subqueries as Expressions.mp410.91MB
39. 86.Returning Parameters.mp410.91MB
40. 119.Using Snapshot Isolation.mp410.77MB
41. 117.Working with Locks.mp410.38MB
42. 57.Creating a Full-Text Index.mp49.9MB
43. 104.Navigating a Hierarchy.mp49.79MB
44. 10.Explaining the Database Properties Dialog.mp49.79MB
45. 38.Referencing Self-Joins.mp49.76MB
46. 2.Understanding Client Server Architecture.mp49.69MB
47. 89.Explaining the Raise Error.mp49.45MB
48. 87.Working with a Cursor.mp49.26MB
49. 84.Introducing Stored Procedures.mp48.95MB
50. 77.INTRODUCTION.mp48.87MB
51. 9.Explaining Items in the Object Explorer.mp48.83MB
52. 29.Working with Dates & Times.mp48.69MB
53. 97.Nesting & Recursion.mp48.68MB
54. 26.Using Case Expressions.mp48.48MB
55. 41.Stacking Data with Unions.mp48.37MB
56. 102.Working with Inline Table-Valued Functions.mp48.29MB
57. 17.Avoiding Over Complexity.mp48.29MB
58. 22.INTRODUCTION.mp48.14MB
59. 80.Controlling Procedural Flow.mp47.99MB
60. 61.Creating Views.mp47.88MB
61. 46.Working with Correlated Subqueries.mp47.75MB
62. 116.Exploring Locks.mp47.74MB
63. 93.Using .mp47.72MB
64. 50.Using Aggregate Functions.mp47.66MB
65. 107.INTRODUCTION.mp47.58MB
66. 74.Deleting Data.mp47.34MB
67. 65.INTRODUCTION.mp47.18MB
68. 69.Using Pass Through Queries.mp46.95MB
69. 11.Explaining the Columns Properties Dialog.mp46.75MB
70. 19.Creating Physical Keys.mp46.67MB
71. 91.INTRODUCTION.mp46.65MB
72. 42.INTRODUCTION.mp46.6MB
73. 98.Enforcing Complex RI.mp46.59MB
74. 100.INTRODUCTION.mp46.48MB
75. 75.Using the Output Clause.mp46.47MB
76. 70.Controlling Distributed Transactions.mp46.43MB
77. 27.Working with Nulls & Coalesce.mp46.43MB
78. 33.Topping Off the Query with Predicates.mp46.38MB
79. 18.Managing Optional Data.mp46.28MB
80. 81.Examining SQL Server with Code.mp45.9MB
81. 71.INTRODUCTION.mp45.89MB
82. 96.Selecting Transaction Data.mp45.84MB
83. 108.Introducing Indexes.mp45.83MB
84. 85.Passing Parameters.mp45.8MB
85. 68.Looking at Where the Work Takes Place.mp45.74MB
86. 105.Having Fun with Apply.mp45.7MB
87. 92.Introducing After Triggers.mp45.69MB
88. 14.INTRODUCTION.mp45.58MB
89. 52.Nesting Aggregations.mp45.5MB
90. 78.Introducing T-SQL.mp45.45MB
91. 36.Using Left Outer Joins.mp45.42MB
92. 90.Controlling Transactions.mp45.29MB
93. 103.Using Multi-Statement Table-Valued UDFs.mp45.07MB
94. 8.Registering Servers.mp44.89MB
95. 112.INTRODUCTION.mp44.87MB
96. 32.Sorting Data.mp44.74MB
97. 115.Stepping through a Transaction.mp44.69MB
98. 34.INTRODUCTION.mp44.62MB
99. 6.INTRODUCTION.mp44.61MB
100. 15.Understanding Normalization.mp44.6MB
101. 7.Arranging the Workspace.mp44.48MB
102. 45.Adding Subqueries as Derived Tables.mp44.29MB
103. 21.Final Comments.mp44.23MB
104. 37.Multiplying Data with Cross Joins.mp44.08MB
105. 30.Parsing Strings.mp43.97MB
106. 62.Preventing Disappearing Rows.mp43.94MB
107. 113.Introducing ACID.mp43.87MB
108. 44.Including Subqueries as Lists.mp43.83MB
109. 121.Deconstructing the Database System.mp43.8MB
110. 40.Finding the Set Difference.mp43.74MB
111. 59.Using a Fuzzy Search to Search for Phrases.mp43.71MB
112. 60.INTRODUCTION.mp43.71MB
113. 31.Converting Data.mp43.69MB
114. 120.INTRODUCTION.mp43.59MB
115. 56.INTRODUCTION.mp43.5MB
116. 12.Continuing with Object Explorer Items.mp43.49MB
117. 25.Columns Expressions & Scalar Functions.mp43.49MB
118. 48.INTRODUCTION.mp43.49MB
119. 39.Working with Complex Joins.mp43.47MB
120. 63.Protecting from Schema Changes.mp42.88MB
121. 94.Disabling Triggers.mp42.73MB
122. 95.Using the Update ( ) Function.mp42.37MB
123. 28.Selecting Environment Functions.mp42.05MB
124. 64.Nesting Views.mp41.83MB