Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Complete SQL Bootcamp for Data Science, Analytics, Marketing
Introduction and Outline
Introduction and Outline (7:12)
Special Offer! Get the VIP version of this course (1:14)
Survey of SQL databases and Installation of SQLite
Overview of SQL databases (2:43)
Installing SQLite on Mac, Linux, and Windows (1:07)
What is a relational database? Basic commands
What’s a relational database? (1:08)
How to load the data used in this class (2:22)
Basic commands (1:07)
Querying a table (2:25)
Creating a table (1:28)
Modifying a table’s structure (2:29)
Indexes and speed comparison
Speeding things up with indexes (3:07)
Index Example in the Console (2:36)
Modifying a table's data
Insert / Update / Delete (2:47)
What is CRUD? (1:29)
Joining tables
Joining or Merging tables together (2:18)
Joins in the console (1:21)
Aggregating, grouping, and sorting. Real marketing queries.
Count, Distinct, Sum, Min, Max, Avg (1:18)
Group by, Sort, Limit (2:02)
Funnels, YOY revenue, and Sales by Location (4:33)
Advanced: SQL on Spark
Spark SQL (4:36)
Create your own Spark cluster on Amazon EC2 (1:37)
Further Knowledge, Practice and Exercises
How to load the extra dataset (tab-separated tables) (6:19)
The "IN" Keyword (2:38)
The "BETWEEN" Keyword (1:41)
Interview Question-Style Exercises (5:50)
Appendix
BONUS: Where to get discount coupons and FREE deep learning material (5:31)
How to load the extra dataset (tab-separated tables)
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock