Introducing
SQL Simplified
A step-by-step program to help you learn SQL from scratch, so you feel confident and prepared to use it at work.
Before I tell you all about this program, let's make sure you're a good fit.
If you are:
- Looking to become a data analyst and want to learn the most important skill for that role.
- A database developer who knows the basics but wants to learn more intermediate-level features of SQL.
- A software developer that works with a database for an application and wants to improve their skills.
You're in the right place!
SQL Simplified will give you the step-by-step process and guidance to become proficient and confident with SQL.
By the end of this program,
you will…
-
Have a Solid Understanding of the Basic SQL Commands
You'll know what the basic and most common SQL commands are, what they mean, and how to write statements that use them. -
Know Many Ways to Filter Your Results
You'll be confident in using the WHERE clause in many ways to filter your results, getting the data you need. -
Understand How to Work with Multiple Tables and How to Use Joins
Databases work best with multiple tables, and you'll understand how to create mutiple tables, relate them to each other, and use joins to view data from multiple tables: a must-have skill when working with SQL. -
Have Confidence When Using Functions
You'll learn what functions are and how to use them on your data to view the data in the way you want. -
Learn a Range of More Advanced Concepts
After learning the basics, you'll also learn a range of intermediate concepts that are used in the "real world": subqueries, constraints, window functions, and more.
"Ben has simplified sub-queries for me, regex, and many other topics. I feel slow when reading a lot of explanations off the internet, but his explanations are so clear, they make these topics easy to understand."
Nancy T, Database Star Academy member
"I just finished the SQL Simplified course and it was really great and helpful."
Pascal D, course student
Enroll in SQL Simplified Today
- 5 high-quality video modules (48 lessons)
- 40 SQL Practice Questions
- Ultimate SQL How-To Guide
- SQL Scripts
- Complete Course PDF
- SQL Best Practices Guide
- Time Saver Guide
- Weekly Action Plan
- Course Quiz
- Discord community
- SQL Projects (Limited Time Offer)
Your explanations are so clear and concise that you don’t need to go on and on and on as I have heard others do.
- Donna M
The brevity of lessons are more manageable and the progression is well designed.
- Merri H
I have learnt a lot by following your site which cannot be described in words. Examples given after each topic are very useful. The videos are simple, informative and easy to understand.
- Korlahalli S
What’s Inside SQL Simplified
Module 1
Create Your First Database Table
In the first module, we'll start with the basics. You'll learn what a database and SQL is, a little about the different tools available, set up your database environment, and create your very first table.
Module Highlights:
- A summary of the four main vendors taught in this course (Oracle, SQL Server, MySQL, and Postgres), with advice on which one to choose if you're new.
- Instructions on how to download and setup the database software and SQL editors, so you can follow along with this course.
- Write your very first SQL statement to create a table: and then add data to it, and view this data.
Module 2
View the Data You Want
Once you've created your table and added some data, you'll want to see what's inside.
In this module, you'll learn how to filter your results to only show the rows that you want to see.
Module Highlights:
- An introduction of the WHERE clause and what it is for
- How to show unique rows in your results, so you don't see duplicate records.
- How to show your results in a specific order
- How to filter your results on a range of values, or partial text values, to give you the flexibility based on your requirements
Module 3
Work with Multiple Tables
Databases work well with many tables, so you'll need to know how to write SQL that looks at multiple tables as well.
In this module, you'll create multiple tables, link them together, and write SELECT queries to view data from them.
Module Highlights:
- How and why to create multiple tables and relate them together: the core concept of a database
- An explanation of primary keys and foreign keys and how to use them, to improve the quality of your data
- How to understand and use joins in an easy and effective way to combine multiple tables in a single query
Module 4
Analyse Your Data
There are a range of SQL features for manipulating your data and results as you need.
In this module, you'll learn about functions and grouping and how they can help your queries.
Module Highlights:
- Learn what functions are, why use them, and see many examples of functions in SQL queries.
- The power and simplicity of aggregate functions
- How, and why, to group your data in your query results.
- How to use conditional logic in SQL (like an IF statement)
Module 5
Take Your SQL to the Next Level
You've learned the basics. Now it's time to learn some more features that are helpful in the "real world" and can really improve your queries.
Module Highlights:
- How to use Common Table Expressions (CTEs), so you can improve the readability and performance of your query.
- A feature to simplify your queries and add security.
- How to use window functions to get the results you need in a single query
- How to run a query inside another query, and why you would want to do this.
When you enroll during this special, limited time period,
you’ll get:
SQL Simplified
($1,000 Value)
-
5 Modules
A step-by-step roadmap to follow to learn SQL from the basics up to intermediate-level functionality in several different databases.
-
Installation and Setup Walkthroughs
You'll be able to watch videos on how to install and set up each of the databases (Oracle, SQL Server, MySQL, Postgres) and tools (SQL Developer Extension for VS Code, SQL Server Management Studio, MySQL Workbench, and DBeaver) in this course -
Comments for Questions and Answers
You'll have access to the built-in comments where you can ask questions to me and other members, and provide answers on other posts.
Plus These Bonuses to Help You Save Time and Improve Your SQL
Bonus 1
SQL Practice Questions
A PDF guide + SQL scripts with 40 practice questions for SQL, with a range of beginner and intermediate questions.
($47 Value)
What You’ll Get:
- 40 practice questions to help improve your skills
- SQL scripts for the four database vendors to help you set up the sample database
- Answers included so you can check your own answers to see if you are correct.
Bonus 2
Ultimate SQL How-To Guide
An explanation of the features in SQL that are actually helpful to you as a developer or data analyst, and how to use them
($47 Value)
What You’ll Get:
- A list of 20 common tasks you may need to do in SQL and the SQL to do it.
- How to find and delete duplicate rows, compare two tables, generate running totals, and more
Bonus 3
SQL Scripts
A collection of SQL files used in the course and as extra support to help you save time.
All SQL scripts work for Oracle, SQL Server, MySQL, and Postgres.
(A $47 Value)
What You’ll Get:
- SQL scripts in a GitHub repository so you can access them easily and don't have to type them from a video.
- Scripts available for Oracle, SQL Server, MySQL, and Postgres, so you can use them regardless of which vendor you're using.
Bonus 4
Complete Course PDF
A PDF file with the complete course included, so you can read it offline and use as a reference.
(A $97 Value)
What You’ll Get:
- A single PDF with all lessons included, so you can refer to it in the future
- PDF includes screenshots and SQL so you know what scripts and screens are being referenced
Bonus 5
Time Saver Guide
A PDF file to help you assess what you spend time on each week and find 30 minutes (or more) to spend on learning and development, to help you complete this course (or any other).
(A $47 Value)
What You’ll Get:
- A PDF with a short process to help understand your week and find blocks of time
- A list of 9 possible options for finding time during your week, that you can choose and apply to your circumstances
Bonus 6
SQL Best Practice Guide
A collection of SQL best practices and style guide for writing effective SQL.
(A $47 Value)
What You’ll Get:
- A PDF with a range of tips for writing SQL and working with databases.
- A range of style guide recommendations of how to write and style your SQL queries.
Bonus 7
Weekly Action Plan
A checklist of actionable items, broken up into small blocks, so you know what to do in each week to complete this course - even if you only have 30 minutes per week.
(A $47 Value)
What You’ll Get:
- A PDF with the course material and actions broken up into 30-minute weekly blocks.
- This will help you reduce overwhelm and take your time with completing the course, with time for practising your skills
Limited-Time Bonus
3 x SQL Projects
A collection of SQL projects to help you practice the SQL skills you learn in this course.
(A $97 Value)
What You’ll Get:
- 3 separate SQL projects in different domains
- Links to CSV files for each project to import into your chosen vendor's database
- A PDF with a series of questions for each project, where you aim to write an SQL statement to find the answer to each question.
Here’s what you’re getting when you enroll today:
SQL Simplified - $1,000 Value
- SQL Practice Questions - $47 Value
- Ultimate SQL How-To Guide - $47 Value
- SQL Scripts - $47 Value
- Complete Course PDF - $97 Value
- Time Saver Guide - $47 Value
- SQL Best Practices - $47 Value
- Weekly Action Plan - $47 Value
- Lifetime access to the course
- Course Quiz to test your knowledge
- Discord community
- 3 x SQL Projects (Limited Time Bonus)
Total Value: $1,238
But when you enroll today, you’ll get access to everything for just:
30-Day Money Back Guarantee
I'm very confident that this course can help you improve your knowledge and SQL skills
If you enrol in this course, and are not satisfied, let me know within 30 days of enrolling and I'll provide a refund for you.
Frequently Asked Questions
Why should I learn SQL?
Which SQL vendors/databases is this for?
I don't know which database vendor I should choose
What software is used in this course?
I don’t have the time to learn
Do I get access to all of the lessons at once?
What if I have questions during the course?
I have unreliable internet so it’s hard for me to watch the videos
Do you offer refunds?
Can you remind me of everything I’m getting when I sign up today?
Enroll in SQL Simplified Today
- 5 high-quality video modules (48 lessons)
- 40 SQL Practice Questions
- Ultimate SQL How-To Guide
- SQL Scripts
- Complete Course PDF
- SQL Best Practices Guide
- Time Saver Guide
- Weekly Action Plan
- Course Quiz
- Discord community
- SQL Projects (Limited Time Offer)
Still thinking about it?
You should give SQL Simplified a 30-day risk-free shot if you're motivated by any of the following:
- You know nothing about SQL and databases, but want to learn how to write SQL.
- You know a little bit about SQL but want to learn more.
- You're taking another course but are confused and unsatisfied with what you're learning.
- You're thinking about changing job roles into a more data-focused role and want to learn the skills to do this.
- Ready to take the actions needed to improve your SQL skills.
I can’t wait for you to join SQL Simplified
I created this course because SQL is the most important skill in the software world (in my opinion), and I believe many people can improve their careers by learning SQL.
So much of the material out there is hard to follow, moves too quickly, and goes into more detail than you need to know.
As someone who is currently working with data, or wants to work with data, SQL is a fundamental skill to learn. It's been around for 40+ years, and is unlikely to go anywhere.
Knowing how to read and write SQL will serve you for years to come.
All it takes is a small investment in your education, and practicing the skills and techniques highlighted in the course.
You're in the right place, and this is the course for you.
There's no risk to joining, with my 30-day money back guarantee.
I hope to see you inside.
Ben Brumm
Enroll in SQL Simplified Today
- 5 high-quality video modules (48 lessons)
- 40 SQL Practice Questions
- Ultimate SQL How-To Guide
- SQL Scripts
- Complete Course PDF
- SQL Best Practices Guide
- Time Saver Guide
- Weekly Action Plan
- Course Quiz
- Discord community
- SQL Projects (Limited Time Offer)
