Introduction to the course
  • Explaining the free version
Setup: Let's set up, so we can start coding!
  • Getting the Software: Downloading the mySQL relational database manager.
  • Using the Software: The 3 important parts of mySQL workbench for writing SQL
  • Let's code again! Is my name more suited to puppy dogs or humans?
  • Uploading the Data: The rich bank relational database unique to this course.
Handling Data: The foundation of all data analysis
  • Introducing the section
  • SELECT & FROM: Seeing, inspecting, and displaying data.
  • FILTERING: Introducing filtering using a fun analogy.
  • WHERE: Filtering data in SQL.
  • (Cont) WHERE: Filtering Data in SQL
  • AND & OR Logic: Introducing a tricky topic using a fun analogy.
  • AND & OR: Specifying your filter
  • End of the short version of the course
  • (Cont) AND & OR: Specifying your filter (Coming Soon)
  • AND & OR COMBINED: More realistic and powerful filters.
  • IN, LIKE, ANY, NOT, BETWEEN, and IS NULL (Coming Soon)
  • ORDER BY: Sorting your data (Coming Soon)
  • ARITHMETIC FUNCTIONS: Modifying your numeric columns. (Coming Soon)
  • STRING FUNCTIONS: Modifying your string columns. (Coming Soon)
  • DATE FUNCTIONS: Modifying your date columns. (Coming Soon)
  • CREATE TABLE: Creating new columns and datasets. (Coming Soon)
Full Introduction to the Course (COMING SOON)
  • Introduction to the course (Coming Soon)
  • Course Overview: Detailed view (Coming Soon)
  • Course overview (Coming Soon)
  • Teaching philosophy and lesson structure (Coming soon)
  • Why learn data analysis and why SQL (Coming soon)
(COMING SOON) Data Theory: What in the world is data?
  • Intro to Part 1 (And why I wish I heard this when I started learning SQL)
  • Why data and analysis are so powerful (Coming soon)
  • How data is stored and organised (Coming soon)
  • How analysts access, handle, and use data (Coming soon)
  • Practicing our understanding data theory on a variety of data sets.
(COMING SOON) Joining Data: Gathering data from different sources using JOINS
  • Intro to Part 4
  • JOINS: Using analogies to introduce the theory of joins
  • LEFT JOIN: Adding new columns to your existing dataset
  • INNER JOIN: Merging your datasets
  • UNION: Putting your datasets on top of one another!
(COMING SOON) Problem Solving: Practice with multiple start to finish problems
  • Intro to Part 5
  • CRYPTOCURRENCY: Advising consumer bank CEO on their response to crypto-trading.
  • Sharks attack! Driving shark safety policy for the Australian government.
  • "Po-po shut us down": Advising the NY Police on improving their public image.
  • Salary and Employee Growth at Goggle Inc.
  • Blockbuster video and the curious case of...
  • Road deaths: How to reduce fatal road crashes in Australia.
Bonus material
  • Saving yourself a bunch of effort using Subqueries
  • Saving your future self effort by formatting your code perfectly
  • Your next career steps