lynda.com - SQL Essential Training 2014
- 01. Introduction01_05-Installing the test environment on a PC.mp453.05 MB
- 01. Introduction01_04-Installing the test environment on a Mac.mp431.02 MB
- 03. Fundamentals03_12-Filtering data with WHERE, LIKE, and IN.mp424.41 MB
- 02. SQL Quick Start02_02-Using the basic SELECT statement.mp416.94 MB
- 12. A Simple CRUD Application12_02-The SELECT functions.mp416.17 MB
- 12. A Simple CRUD Application12_01-Touring the CRUD application.mp415.69 MB
- 09. Transactions09_02-Using transactions.mp412.55 MB
- 03. Fundamentals03_13-Removing duplicates with SELECT DISTINCT.mp411.43 MB
- 03. Fundamentals03_14-Sorting with ORDER BY.mp411.25 MB
- 10. Triggers10_02-Preventing automatic updates with a trigger.mp48.83 MB
- 10. Triggers10_01-Updating a table with a trigger.mp48.76 MB
- 08. Aggregates08_01-How aggregates work.mp48.66 MB
- 04. Relationships04_03-Using multiple related tables.mp48.65 MB
- 01. Introduction01_01-Welcome.mp48.61 MB
- 04. Relationships04_02-Accessing related tables with JOIN.mp48.59 MB
- 05. Strings05_04-Removing spaces with TRIM.mp48.38 MB
- 11. Subselects and Views11_02-Searching within a result set.mp48.12 MB
- 01. Introduction01_03-Course overview.mp47.76 MB
- 10. Triggers10_03-Automating timestamps with a trigger.mp47.74 MB
- 12. A Simple CRUD Application12_03-The INSERT, UPDATE, and DELETE functions.mp47.72 MB
- 11. Subselects and Views11_03-Creating a view.mp47.69 MB
- 01. Introduction01_06-What is SQL.mp47.49 MB
- 11. Subselects and Views11_04-Creating a joined view.mp47.39 MB
- 11. Subselects and Views11_01-Creating a simple subselect.mp46.81 MB
- 03. Fundamentals03_08-Understanding NULL.mp46.63 MB
- 02. SQL Quick Start02_06-Inserting data.mp46.58 MB
- 08. Aggregates08_02-Using aggregate functions.mp46.49 MB
- 02. SQL Quick Start02_03-Selecting rows.mp46.33 MB
- 03. Fundamentals03_15-Conditional expressions with CASE.mp46.27 MB
- 03. Fundamentals03_02-SQL syntax overview.mp45.84 MB
- 03. Fundamentals03_09-Controlling column behaviors with constraints.mp45.78 MB
- 08. Aggregates08_03-Aggregating DISTINCT values.mp45.67 MB
- 03. Fundamentals03_06-Inserting rows into a table.mp45.55 MB
- 02. SQL Quick Start02_04-Selecting columns.mp45.03 MB
- 05. Strings05_03-Selecting part of a string.mp44.49 MB
- 03. Fundamentals03_11-Creating an ID column.mp44.28 MB
- 03. Fundamentals03_10-Changing a schema with ALTER.mp44.14 MB
- 02. SQL Quick Start02_07-Updating data.mp44.06 MB
- 05. Strings05_05-Making strings uppercase and lowercase.mp43.99 MB
- 07. Dates07_02-Date- and time-related functions.mp43.95 MB
- 06. Numbers06_02-Finding the type of a value.mp43.71 MB
- 03. Fundamentals03_04-Creating tables.mp43.63 MB
- 03. Fundamentals03_05-Deleting a table with DROP TABLE.mp43.49 MB
- 06. Numbers06_03-Integer division and remainders.mp43.42 MB
- 03. Fundamentals03_07-Deleting rows from a table.mp43.24 MB
- 06. Numbers06_01-About numeric types.mp43.12 MB
- 04. Relationships04_01-Understanding joins.mp43.11 MB
- 02. SQL Quick Start02_08-Deleting data.mp43.07 MB
- 01. Introduction01_02-Using the exercise files.mp42.95 MB
- 05. Strings05_02-Finding the length of a string.mp42.66 MB