Section 1 : Introduction
|
|
Lecture 1 | Don't let your reporting system hold you back | 00:00:24 Duration |
|
|
Lecture 2 | Who this course is for | |
|
|
Lecture 3 | What is SQL | 00:04:12 Duration |
Section 2 : Prepare to Code in SQL
|
|
Lecture 1 | Get familiar with phpMyAdmin | 00:03:45 Duration |
|
|
Lecture 2 | Understand the demo database |
Section 3 : Use SQL to Report Data
|
|
Lecture 1 | Retrieve data with SELECT | 00:05:31 Duration |
|
|
Lecture 2 | Filter results with WHERE clause | 00:05:04 Duration |
|
|
Lecture 3 | Use LIKE, IN, and wildcards with WHERE | 00:05:39 Duration |
|
|
Lecture 4 | Sort SQL results with ORDER BY | |
|
|
Lecture 5 | Use string functions on your data | 00:06:41 Duration |
|
|
Lecture 6 | More advanced string functions | 00:08:35 Duration |
|
|
Lecture 7 | Change report headings with alias | 00:02:28 Duration |
|
|
Lecture 8 | Use date functions with WHERE |
Section 4 : Group Your SQL Results
|
|
Lecture 1 | Use GROUP BY with count | 00:05:46 Duration |
|
|
Lecture 2 | Filter grouped results with HAVING | |
|
|
Lecture 3 | De-duplicate with SELECT DISTINCT | 00:06:30 Duration |
|
|
Lecture 4 | Merge rows with GROUP BY | 00:02:24 Duration |
Section 5 : Merge Data from Multiple Tables
|
|
Lecture 1 | Make your queries faster | 00:01:47 Duration |
|
|
Lecture 2 | Understand SQL indexes and keys | 00:07:16 Duration |
|
|
Lecture 3 | Visualize your database | 00:07:59 Duration |
|
|
Lecture 4 | Merge data across tables with JOIN | 00:05:02 Duration |
|
|
Lecture 5 | Understand SQL JOINS | 00:04:16 Duration |
|
|
Lecture 6 | Combine rows with SQL UNION | |
|
|
Lecture 7 | Merge data across tables with IN | 00:02:11 Duration |
|
|
Lecture 8 | Select from a selection with subqueries | 00:02:56 Duration |
Section 6 : More Advanced SQL
|
|
Lecture 1 | Save your queries using a VIEW | 00:08:28 Duration |
|
|
Lecture 2 | Use variables | 00:05:17 Duration |
|
|
Lecture 3 | Use functions | 00:08:04 Duration |
|
|
Lecture 4 | Use procedures | 00:04:58 Duration |
