A simple & concise mySQL course (applicable to any SQL), perfect for data analysis, data science, business intelligence.
Free tutorial
4.1
Created by Max SQL
English
What you’ll learn
- The most important SQL to get you job ready fast.
- To apply SQL to solve real-world business problems.
- Excellent skills in handling, joining, and summarizing data.
- How a realistic relational database works (using never seen before data).
- To set up an analysis and solve problems from start to finish using SQL.
- And how to decide which animals to see when you visit Australia 😉
Requirements
- No coding experience required.
- No data experience required.
- No ‘math brain’ required.
- Requirements: Eagerness to learn, sense of humour, and a career to build!
- The lessons are targeted to ‘everyday people’ with a can-do attitude and a healthy aversion to reading textbooks.
Description
Note on the Short Version of the Course
I have launched the course as a free, shortened version. It is an excellent introduction to the basics of handling data. Two points I want you to know:
1. The course so far is an in-depth view on a small & important part of SQL, rather than a light-touch overview of everything.
2. Technically, the full paid version is on the way. But I am finding it very difficult to find the time to complete the lessons (between other projects and work).
Therefore for those who need a comprehensive course now, I’d suggest signing up to a couple of courses now including this one while it’s free. That way you can learn now but also enjoy all the additional lessons for free when they arrive.
Note on the Communicating
Udemy prevents instructors of Free courses from answering any questions from students. Therefore for now I cannot provide any feedback or respond to comments.
Summary
Forget the dry, old, textbook approach to learning code. Forget endlessly drilling syntax.
This course puts SQL in context and gets you solving real-world business problems from Day 1.
You’ll play the role of a data analyst at Australia’s largest fictional consumer bank, with a uniquely rich relational database at your fingertips. This context brings SQL to life and makes it easier for you to understand deeply and quickly.
With this new approach, you’ll be surprised to see that SQL is fun and simple to learn. My course guarantee is that you’ll go from zero to functional SQL coder within the weekend.
Best features in a nutshell
- In plain English, with business context and fun analogies to explain the otherwise dry syntax.
- Unique database, using a fictional bank relational database with incredibly rich transaction data to keep the course interesting and relevant.
- Focuses deep on the absolute basics, to get you the strong foundations required for a data career.
- Doesn’t cost money! If you sign up now while it’s free, you have lifetime free access, even as the course grows and becomes paid.
Read on for more detail
My story and building the course
My SQL learning experience was not ideal. When I started work I hadn’t the slightest idea what data was, let alone the power it brings to those who wield it skillfully. I took probably a year longer than necessary to master the SQL for data analytics. Even though I was practicing everyday on the job, I was slow to understand new concepts and struggled to remember new syntax.
Now as a full-time data analytics and insights manager, I have the hindsight to know it should have been much easier.
The main ingredients missing for me were:
- Structure
- What is important, what isn’t, and why.
- Context
- Analogies, interesting examples, and plain English explanations. Bringing it to life!
So I’ve taken what was lacking in my learning experience and build a course around it. Specifically, here’s why my course stands out:
- Structured
- We learn what you need for on the job data analysis using SQL, no more less.
- The topics are covered in an order that makes sense and helps you build on past learning.
- You understand why each lesson is important, where it sits in the grand scheme of SQL.
- In context
- SQL shouldn’t have to be dry or boring, so I have used realistic business problems and analogies.
- You’ll be playing the role of a data analyst at the largest fictional company in Australia, the Royal Bank of Australia, solving problems to drive sales, improve marketing reach, and manage customers.
- Knowing why you’re learning the syntax, you’ll learn faster.
- Hands on/practical
- You’ll practice writing SQL in every single lesson.
We are going to have fun too, investigating cryptocurrency trading among customers, and even learning about Australian animals!
Why learn SQL?
Most successful companies today are data-driven.
- They record every bit of information about their business (e.g. customers, sales).
- They store that information (called data) in complex databases.
- And they draw insights from the data to improve their business.
That’s where SQL comes in.
The only way to gather data and transform it into valuable business insights is to combine SQL and a smart analyst like you.
It’s with SQL that companies know answers all sorts of where do my customers prefer to shop? Who was incorrectly charged fees? Why are sales going down?)
And as you may have noticed in the Promo, SQL is a great skill to build your career
Data careers, in data analysis (business analysis), data science, & data visualisation (business intelligence).
- SQL is needed to actually find and handle data in most organisations.
- The data handling and management skills learned via SQL are fundamental to understanding data in general, and are useful even if you don’t use the SQL language (rare).
- Access to data can make you powerful in organisations. It’s hard to argue with an analyst armed with well-prepped data and a solid numbers-based argument.
Marketing, product management, and tech sales:
- SQL (and the accompanying data skills) are a great way to stand out in marketing and product.
- Marketers and product managers propose changes to improve the business.
- Nowadays, any proposed change needs a strong case to support it.
- Data is the foundation of any strong business case.
- Therefore marketers and product managers with data skills can put together stronger cases, get more initiatives approved, and grow their career faster.
Why start with mySQL? mySQL is:
- Very common, used by major companies and organisations across the world, such as Uber, Netflix, Spotify, and JPMorgan.
- Free and easy to set up.
- Similar to other forms of SQL like Microsoft SQL Server, PostGre SQL, Oracle SQL, Teradata SQL.
Who this course is for:
- You want to stand out in interviews for your dream job in data analysis, business intelligence, or data science.
- You’re a student wanting a taste of what real-world data analysis is like.
- You’re a product manager, marketing manager, or commercial manager, short on time but need to level-up in data skills to stand out in your career.
- You’re a budding data scientist: SQL is critical for feature engineering, which is a large part of any data science role. Plus, SQL is a much faster and easier route to data than Python.
- You’re already a data analyst using a different language but have moved to a company that uses SQL.
Show less
Course content
8 sections • 48 lectures • 1h 57m total lengthCollapse all sections
Introduction to the course1 lecture • 1min
- Explaining the free version01:04
Setup: Let’s set up, so we can start coding!4 lectures • 45min
- Getting the Software: Downloading the mySQL relational database manager.07:47
- Using the Software: The 3 important parts of mySQL workbench for writing SQL14:57
- Let’s code again! Is my name more suited to puppy dogs or humans?11:32
- Uploading the Data: The rich bank relational database unique to this course.10:14
Handling Data: The foundation of all data analysis17 lectures • 1hr 10min
- Introducing the section00:57
- SELECT & FROM: Seeing, inspecting, and displaying data.12:01
- FILTERING: Introducing filtering using a fun analogy.10:29
- WHERE: Filtering data in SQL.10:01
- (Cont) WHERE: Filtering Data in SQL11:24
- AND & OR Logic: Introducing a tricky topic using a fun analogy.14:14
- AND & OR: Specifying your filter09:11
- End of the short version of the course01:18
- (Cont) AND & OR: Specifying your filter (Coming Soon)00:04
- AND & OR COMBINED: More realistic and powerful filters.00:04
- IN, LIKE, ANY, NOT, BETWEEN, and IS NULL (Coming Soon)00:04
- ORDER BY: Sorting your data (Coming Soon)00:04
- ARITHMETIC FUNCTIONS: Modifying your numeric columns. (Coming Soon)00:04
- STRING FUNCTIONS: Modifying your string columns. (Coming Soon)00:04
- DATE FUNCTIONS: Modifying your date columns. (Coming Soon)00:04
- CREATE TABLE: Creating new columns and datasets. (Coming Soon)00:04
- CRYPTOCURRENCY CHALLENGE: Part 100:04
Full Introduction to the Course (COMING SOON)5 lectures • 1min
- Introduction to the course (Coming Soon)00:04
- Course Overview: Detailed view (Coming Soon)00:04
- Course overview (Coming Soon)00:04
- Teaching philosophy and lesson structure (Coming soon)00:04
- Why learn data analysis and why SQL (Coming soon)00:04
(COMING SOON) Data Theory: What in the world is data?5 lectures • 1min
- Intro to Part 1 (And why I wish I heard this when I started learning SQL)00:04
- Why data and analysis are so powerful (Coming soon)00:04
- How data is stored and organised (Coming soon)00:04
- How analysts access, handle, and use data (Coming soon)00:04
- Practicing our understanding data theory on a variety of data sets.00:04
(COMING SOON) Joining Data: Gathering data from different sources using JOINS6 lectures • 1min
- Intro to Part 400:04
- JOINS: Using analogies to introduce the theory of joins00:04
- LEFT JOIN: Adding new columns to your existing dataset00:04
- INNER JOIN: Merging your datasets00:04
- UNION: Putting your datasets on top of one another!00:04
- CRYPTOCURRENCY CHALLENGE Part 300:04
(COMING SOON) Problem Solving: Practice with multiple start to finish problems7 lectures • 1min
- Intro to Part 500:04
- CRYPTOCURRENCY: Advising consumer bank CEO on their response to crypto-trading.00:04
- Sharks attack! Driving shark safety policy for the Australian government.00:04
- “Po-po shut us down”: Advising the NY Police on improving their public image.00:04
- Salary and Employee Growth at Goggle Inc.00:04
- Blockbuster video and the curious case of…00:04
- Road deaths: How to reduce fatal road crashes in Australia.00:04
Bonus material3 lectures • 1min
- Saving yourself a bunch of effort using Subqueries00:04
- Saving your future self effort by formatting your code perfectly00:04
- Your next career steps00:04
