| | | 01 01 Introduction.mp4 | 10.04 MB |
| | | 02 01 Creating a Table.mp4 | 12.81 MB |
| | | 02 02 Primary Keys - Integer.mp4 | 9.91 MB |
| | | 02 03 Primary Keys - GUID.mp4 | 6.29 MB |
| | | 02 04 Primary Keys - Auto-incrementing.mp4 | 11.01 MB |
| | | 02 05 Tangent - Choosing a Primary Key.mp4 | 15.35 MB |
| | | 02 06 Composite Keys.mp4 | 11.2 MB |
| | | 02 07 Defining Columns.mp4 | 8.4 MB |
| | | 02 08 Basic Column Constraints.mp4 | 20.66 MB |
| | | 02 09 Column Defaults.mp4 | 6.16 MB |
| | | 02 10 Naming Conventions.mp4 | 9.76 MB |
| | | 03 01 Inserting Data.mp4 | 11.88 MB |
| | | 03 02 Bulk Inserts.mp4 | 8.06 MB |
| | | 03 03 Updates.mp4 | 6.22 MB |
| | | 03 04 Updates with Criteria.mp4 | 4.1 MB |
| | | 03 05 Bulk Updates.mp4 | 4.34 MB |
| | | 03 06 Delete.mp4 | 3.24 MB |
| | | 03 07 Bulk Deletes.mp4 | 5.54 MB |
| | | 04 01 Installing Chinook.mp4 | 4.58 MB |
| | | 04 02 Simple Select.mp4 | 5.31 MB |
| | | 04 03 Select Columns.mp4 | 7.29 MB |
| | | 04 04 Aliasing Columns.mp4 | 5.49 MB |
| | | 04 05 Column Expressions.mp4 | 4.26 MB |
| | | 04 06 Tangent - Naming Things.mp4 | 7.08 MB |
| | | 05 01 Inner Joins.mp4 | 15.23 MB |
| | | 05 02 Subqueries.mp4 | 9.12 MB |
| | | 05 03 Left and Right Joins.mp4 | 8.73 MB |
| | | 05 04 Full Joins.mp4 | 2.81 MB |
| | | 06 01 Ordering Results.mp4 | 5.81 MB |
| | | 06 02 Limiting Results.mp4 | 3.18 MB |
| | | 06 03 Sequential Ordering.mp4 | 7.48 MB |
| | | 06 04 Filtering by Sets.mp4 | 5.88 MB |
| | | 06 05 Offsetting Results.mp4 | 7.08 MB |
| | | 07 01 Basic Aggregates.mp4 | 7.93 MB |
| | | 07 02 Grouping Results.mp4 | 6.09 MB |
| | | 07 03 A Simple Sales Query.mp4 | 7.54 MB |
| | | 07 04 Tangent - Checking Your Numbers.mp4 | 10.05 MB |
| | | 07 05 Constraining Aggregate Results.mp4 | 9.66 MB |
| | | 08 01 Adding Data to a Many to Many.mp4 | 4.75 MB |
| | | 08 02 Querying a Many to Many.mp4 | 8.25 MB |
| | | 08 03 Many to Many Table Constraints.mp4 | 22.83 MB |
| | | 08 04 Querying a Self-referencing Table Using a Join.mp4 | 12.5 MB |
| | | 08 05 Querying a Self-referencing Table with a Subquery.mp4 | 9.12 MB |
| | | 09 01 Querying Strings with a Partial Match.mp4 | 18.97 MB |
| | | 09 02 Partial String Results with Substring.mp4 | 9.16 MB |
| | | 09 03 Editing String Results with Replace.mp4 | 5.59 MB |
| | | 09 04 Fixing Bad Data with Trim.mp4 | 8.45 MB |
| | | 09 05 Fixing Bad Data with Rtrim Len and Datalength.mp4 | 10.36 MB |
| | | 09 06 Slicing Dates with Datepart.mp4 | 6.29 MB |
| | | 09 07 Doing Date Math with Datediff.mp4 | 9.3 MB |
| | | 09 08 Summary and Goodbye.mp4 | 4 MB |