Lynda - SQL Essential Training
File List
| File | Size |
|---|---|
| 2.1. Installation/07.Installing on a Mac - Part II.mp4 | 30.13 MB |
| 1.Introduction/01.Welcome.mp4 | 5.96 MB |
| 1.Introduction/02.Exercise files.mp4 | 5.99 MB |
| 1.Introduction/03.Course overview.en.srt | 2.56 KB |
| 1.Introduction/03.Course overview.mp4 | 3.37 MB |
| 2.1. Installation/04.Installing on Windows - Part I.en.srt | 13.89 KB |
| 2.1. Installation/04.Installing on Windows - Part I.mp4 | 19.85 MB |
| 2.1. Installation/05.Installing on Windows - Part II.en.srt | 16.91 KB |
| 2.1. Installation/05.Installing on Windows - Part II.mp4 | 26.39 MB |
| 2.1. Installation/06.Installing on a Mac - Part I.en.srt | 12.63 KB |
| 2.1. Installation/06.Installing on a Mac - Part I.mp4 | 16.1 MB |
| 2.1. Installation/07.Installing on a Mac - Part II.en.srt | 20.55 KB |
| 1.Introduction/01.Welcome.en.srt | 1.86 KB |
| 3.2. SQL Overview/08.About the overview.en.srt | 6.05 KB |
| 3.2. SQL Overview/08.About the overview.mp4 | 6.6 MB |
| 3.2. SQL Overview/09.Database organization.en.srt | 4.59 KB |
| 3.2. SQL Overview/09.Database organization.mp4 | 5.9 MB |
| 3.2. SQL Overview/10.The SELECT statement.en.srt | 9.7 KB |
| 3.2. SQL Overview/10.The SELECT statement.mp4 | 12.42 MB |
| 3.2. SQL Overview/11.Selecting rows.en.srt | 2.76 KB |
| 3.2. SQL Overview/11.Selecting rows.mp4 | 4.09 MB |
| 3.2. SQL Overview/12.Selecting columns.mp4 | 2.94 MB |
| 3.2. SQL Overview/13.Counting rows.en.srt | 3.67 KB |
| 3.2. SQL Overview/13.Counting rows.mp4 | 4.64 MB |
| 3.2. SQL Overview/14.Inserting data.mp4 | 5.72 MB |
| 3.2. SQL Overview/15.Updating data.mp4 | 4.45 MB |
| 3.2. SQL Overview/16.Deleting data.en.srt | 2.63 KB |
| 3.2. SQL Overview/16.Deleting data.mp4 | 2.79 MB |
| 4.3. Fundamental Concepts/17.Creating a table.en.srt | 6.7 KB |
| 4.3. Fundamental Concepts/17.Creating a table.mp4 | 5.75 MB |
| 4.3. Fundamental Concepts/18.Deleting a table.en.srt | 3.96 KB |
| 4.3. Fundamental Concepts/18.Deleting a table.mp4 | 3.64 MB |
| 4.3. Fundamental Concepts/19.Inserting rows.en.srt | 4.93 KB |
| 4.3. Fundamental Concepts/19.Inserting rows.mp4 | 5.54 MB |
| 4.3. Fundamental Concepts/20.Deleting rows.en.srt | 2.67 KB |
| 4.3. Fundamental Concepts/20.Deleting rows.mp4 | 3.16 MB |
| 4.3. Fundamental Concepts/21.The NULL value.mp4 | 8.51 MB |
| 4.3. Fundamental Concepts/22.Constraining columns.en.srt | 5.31 KB |
| 4.3. Fundamental Concepts/22.Constraining columns.mp4 | 5.42 MB |
| 4.3. Fundamental Concepts/23.Changing a schema.en.srt | 3.03 KB |
| 4.3. Fundamental Concepts/23.Changing a schema.mp4 | 3.24 MB |
| 4.3. Fundamental Concepts/24.ID columns.en.srt | 4 KB |
| 4.3. Fundamental Concepts/24.ID columns.mp4 | 3.68 MB |
| 4.3. Fundamental Concepts/25.Filtering data.mp4 | 11.43 MB |
| 4.3. Fundamental Concepts/26.Removing duplicates.en.srt | 3.61 KB |
| 4.3. Fundamental Concepts/26.Removing duplicates.mp4 | 4.91 MB |
| 4.3. Fundamental Concepts/27.Ordering output.mp4 | 6.25 MB |
| 4.3. Fundamental Concepts/28.Conditional expressions.en.srt | 4.47 KB |
| 4.3. Fundamental Concepts/28.Conditional expressions.mp4 | 4.34 MB |
| 5.4. Relationships/29.Understanding JOIN.mp4 | 4.61 MB |
| 5.4. Relationships/30.Accessing related tables.mp4 | 8.09 MB |
| 5.4. Relationships/31.Relating multiple tables.en.srt | 5.54 KB |
| 5.4. Relationships/31.Relating multiple tables.mp4 | 7.98 MB |
| 6.5. Strings/32.About SQL strings.en.srt | 2.58 KB |
| 6.5. Strings/32.About SQL strings.mp4 | 3.19 MB |
| 6.5. Strings/33.Finding the length of a string.mp4 | 4.3 MB |
| 6.5. Strings/34.Selecting part of a string.en.srt | 3.29 KB |
| 6.5. Strings/34.Selecting part of a string.mp4 | 3.21 MB |
| 6.5. Strings/35.Removing spaces.mp4 | 6.24 MB |
| 6.5. Strings/36.Folding case.en.srt | 2.72 KB |
| 6.5. Strings/36.Folding case.mp4 | 3.8 MB |
| 7.6. Numbers/37.Numeric types.en.srt | 6.36 KB |
| 7.6. Numbers/37.Numeric types.mp4 | 6.52 MB |
| 7.6. Numbers/38.What type is that value.en.srt | 3.4 KB |
| 7.6. Numbers/38.What type is that value.mp4 | 3.3 MB |
| 7.6. Numbers/39.Integer division.en.srt | 2.81 KB |
| 7.6. Numbers/39.Integer division.mp4 | 2.87 MB |
| 7.6. Numbers/40.Rounding numbers.en.srt | 1.5 KB |
| 7.6. Numbers/40.Rounding numbers.mp4 | 1.58 MB |
| 8.7. Dates and Times/41.Dates and times.en.srt | 3.19 KB |
| 8.7. Dates and Times/41.Dates and times.mp4 | 3.81 MB |
| 8.7. Dates and Times/42.Date- and time-related functions.en.srt | 3.42 KB |
| 8.7. Dates and Times/42.Date- and time-related functions.mp4 | 3.94 MB |
| 9.8. Aggregates/43.What are aggregates.en.srt | 6.46 KB |
| 9.8. Aggregates/43.What are aggregates.mp4 | 8.31 MB |
| 9.8. Aggregates/44.Using aggregate functions.en.srt | 2.62 KB |
| 9.8. Aggregates/44.Using aggregate functions.mp4 | 3.91 MB |
| 9.8. Aggregates/45.Aggregating DISTINCT values.en.srt | 3.03 KB |
| 9.8. Aggregates/45.Aggregating DISTINCT values.mp4 | 3.85 MB |
| 10.9. Transactions/46.What are transactions.en.srt | 3.51 KB |
| 10.9. Transactions/46.What are transactions.mp4 | 4.34 MB |
| 10.9. Transactions/47.Data integrity.en.srt | 5.35 KB |
| 10.9. Transactions/47.Data integrity.mp4 | 5.66 MB |
| 10.9. Transactions/48.Performance.en.srt | 5.84 KB |
| 10.9. Transactions/48.Performance.mp4 | 5.91 MB |
| 11.10. Triggers/49.Automating data with triggers.en.srt | 5 KB |
| 11.10. Triggers/49.Automating data with triggers.mp4 | 6.45 MB |
| 11.10. Triggers/50.Preventing updates.en.srt | 4.11 KB |
| 11.10. Triggers/50.Preventing updates.mp4 | 4.91 MB |
| 11.10. Triggers/51.Example - Timestamps.en.srt | 3.73 KB |
| 11.10. Triggers/51.Example - Timestamps.mp4 | 5.34 MB |
| 12.11. Views and Subselects/52.Creating a subselect.en.srt | 5.91 KB |
| 12.11. Views and Subselects/52.Creating a subselect.mp4 | 6.33 MB |
| 12.11. Views and Subselects/53.Searching within a result set.en.srt | 4.5 KB |
| 12.11. Views and Subselects/53.Searching within a result set.mp4 | 5.93 MB |
| 12.11. Views and Subselects/54.Creating a view.mp4 | 7.73 MB |
| 12.11. Views and Subselects/55.Creating a joined view.en.srt | 3.52 KB |
| 12.11. Views and Subselects/55.Creating a joined view.mp4 | 5.81 MB |
| 13.12. Defined Functions/56.Overview.en.srt | 1.7 KB |
| 13.12. Defined Functions/56.Overview.mp4 | 2.49 MB |
Trackers
No trackers found.