| Lynda.com Tutorial (SQL)/01. Introduction/01 01. Introduction.mov |
20.4 MB |
| Lynda.com Tutorial (SQL)/01. Introduction/01 02. What is SQL.mov |
1.4 MB |
| Lynda.com Tutorial (SQL)/01. Introduction/01 03. Understanding the terminology.mov |
3.6 MB |
| Lynda.com Tutorial (SQL)/01. Introduction/01 04. About the examples.mov |
2.7 MB |
| Lynda.com Tutorial (SQL)/01. Introduction/01 05. Setting up the test environment on a PC.mov |
15.8 MB |
| Lynda.com Tutorial (SQL)/01. Introduction/01 06. Setting up the example data on a PC.mov |
5.5 MB |
| Lynda.com Tutorial (SQL)/01. Introduction/01 07. Setting up the test environment on a Mac.mov |
16.3 MB |
| Lynda.com Tutorial (SQL)/01. Introduction/01 08. Setting up the example data on a Mac.mov |
4.1 MB |
| Lynda.com Tutorial (SQL)/02. SQL Quick Start/02 01. Quick-start introduction.mov |
478 KB |
| Lynda.com Tutorial (SQL)/02. SQL Quick Start/02 02. Using the basic SELECT statement.mov |
1.5 MB |
| Lynda.com Tutorial (SQL)/02. SQL Quick Start/02 03. Selecting columns.mov |
4.8 MB |
| Lynda.com Tutorial (SQL)/02. SQL Quick Start/02 04. Selecting rows.mov |
2.4 MB |
| Lynda.com Tutorial (SQL)/02. SQL Quick Start/02 05. Counting things.mov |
2.8 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 01. Organization Databases and tables.mov |
1.7 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 02. SQL syntax overview.mov |
1.7 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 03. Formatting SQL.mov |
3 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 04. Creating a database and tables.mov |
3.8 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 05. Inserting data.mov |
1.8 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 06. Reading tables with JOIN.mov |
4.3 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 07. Filtering data with WHERE LIKE and IN.mov |
5.8 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 08. Removing duplicates with DISTINCT.mov |
1.5 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 09. Sorting with ORDER BY.mov |
3.7 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 10. Updating data.mov |
1.4 MB |
| Lynda.com Tutorial (SQL)/03. SQL Essentials/03 11. Deleting data.mov |
1.7 MB |
| Lynda.com Tutorial (SQL)/04. IDs and Indexes/04 01. Creating relationships between tables.mov |
860 KB |
| Lynda.com Tutorial (SQL)/04. IDs and Indexes/04 02. Accessing related tables with JOIN.mov |
3 MB |
| Lynda.com Tutorial (SQL)/04. IDs and Indexes/04 03. About indexes.mov |
1 MB |
| Lynda.com Tutorial (SQL)/05. Strings/05 01. About the string functions.mov |
2.2 MB |
| Lynda.com Tutorial (SQL)/05. Strings/05 02. Finding the length of a string.mov |
1 MB |
| Lynda.com Tutorial (SQL)/05. Strings/05 03. Finding part of a string.mov |
1.3 MB |
| Lynda.com Tutorial (SQL)/05. Strings/05 04. Removing spaces with TRIM.mov |
1.6 MB |
| Lynda.com Tutorial (SQL)/05. Strings/05 05. Making strings UPPERCASE and lowercase.mov |
783 KB |
| Lynda.com Tutorial (SQL)/06. Numbers/06 01. When to use numeric functions.mov |
1.2 MB |
| Lynda.com Tutorial (SQL)/06. Numbers/06 02. Finding the absolute value.mov |
1.2 MB |
| Lynda.com Tutorial (SQL)/06. Numbers/06 03. Rounding numbers.mov |
1.7 MB |
| Lynda.com Tutorial (SQL)/06. Numbers/06 04. Integer division and remainders.mov |
3.8 MB |
| Lynda.com Tutorial (SQL)/07. Dates/07 01. Dates and times.mov |
1.2 MB |
| Lynda.com Tutorial (SQL)/07. Dates/07 02. Date and time-related functions.mov |
1.8 MB |
| Lynda.com Tutorial (SQL)/08. Aggregates/08 01. How aggregates work.mov |
3 MB |
| Lynda.com Tutorial (SQL)/08. Aggregates/08 02. Removing duplicates with DISTINCT.mov |
784 KB |
| Lynda.com Tutorial (SQL)/08. Aggregates/08 03. Using aggregate functions.mov |
2.2 MB |
| Lynda.com Tutorial (SQL)/09. The CRUD Application/09 01. About the CRUD application.mov |
7.5 MB |
| Lynda.com Tutorial (SQL)/09. The CRUD Application/09 02. The SELECT functions.mov |
6.8 MB |
| Lynda.com Tutorial (SQL)/09. The CRUD Application/09 03. The INSERT functions.mov |
3.5 MB |
| Lynda.com Tutorial (SQL)/09. The CRUD Application/09 04. The UPDATE functions.mov |
3.6 MB |
| Lynda.com Tutorial (SQL)/09. The CRUD Application/09 05. The DELETE functions.mov |
3.8 MB |
| Lynda.com Tutorial (SQL)/10. Conclusion/10 01. Goodbye.mov |
437 KB |
| Lynda.com Tutorial (SQL)/Exercise Files/Ex_Files_SQL_EssT.7z |
86 KB |
| Lynda.com Tutorial (SQL)/Exercise Files/Ex_Files_SQL_EssT.sitx |
73 KB |
Magnet link
