SQL Zero to Hero
3 WEEKS · COHORT-BASED COURSE
Walter Shields’ SQL course unlocks big data’s potential. Learn to navigate databases, retrieve data efficiently, and command query syntax!
Walter Shields
Best-Selling Author | MIT Data Scientist | LinkedIn Learning Instructor
COURSE OVERVIEW
Earn Your SQL Certificate in 3 Weeks
Become one of the most in-demand professionals and analyze big data with ease! Stand out, stay competitive, and ultimately, future-proof your career by learning SQL.
Who is this course for
01
Business Analyst, Marketers, Software Engineers, Journalist who need to analyze data specific to their domain and discover insights.
02
Decision makers who have to deal with an overwhelming amount of data and need a quick way to understand it.
03
Beginners with little or no prior experience who need a clear, simple and actionable way to learn and master SQL.
Key outcomes
- Understand Database Structure You'll learn what the basic structure of a database is, how they work and how to navigate them without confusion.
- Query Any Database You'll learn how to use SQL, how to understand its code and how to best use it to retrieve and understand data from any SQL database.
- Know What's Important You'll learn the most important SQL queries that you should know to analyze data, how and when to use them for the most accurate results.
- Analyze Data Effectively You'll learn how to interpret verbal and written requests so you can transform them into effective SQL query solutions.
$1,497 USD
UPCOMING COHORTS
-
SQL Zero To Hero – Cohort 5
$1,497.00 Nov 2—22, 2023 Last day to enroll: Nov 2Enroll -
SQL Zero To Hero – Cohort 6
$1,497.00 Jan 10—26, 2024 Last day to enroll: Jan 10Enroll -
Cohort 8
$1,497.00 Mar 5—22, 2024 Last day to enroll: Mar 4Enroll
CAN'T JOIN THIS TIME?
Be the first to know about the next cohort
See what people are saying
On a scale from 1 to 10 in regard to my SQL knowledge, prior to this I was a 1. After this course and going through the exercises (which only took a week of dedication) I would say I am a 8. There is still more to learn, but this course is one heck of a solid start!
Vivien Peters
Marketing Analyst
I have “used” SQL at my job for many years now, but have never really understood it. I have always relied on other people to write my queries. This course puts it in layman’s terms. For example why the heck do they always use *. Hello, because it stands for all fields.Who knew. I strongly suggest you purchase this course, It is worth every penny.
Kevin Victor
Business Analyst
I’m just Amazed. One of the biggest hurdles to learning programming languages is getting over the technical jargon. It’s a real challenge but, Walter Shields has made SQL concepts and query writing so accessible in this course. I can literally write SQL queries I can communicate with the best experts.
Alexis Charles
Sales Manager
I’ve done a fair amount of programming in Java, storing and retrieving data through jdbc and various database vendors. After taking this course, the database, and SQL in particular, have now become far more interesting. Walter describes the importance of data in a free and unpretentious language. Explanations are not tedious – but fun!
Jamie Perez
Application Developer
Find WSDA Learners In
Best companies
Meet your instructor
Walter Shields
He is a passionate advocate for knowledge sharing and inclusion in the world of data, and the founder of the Walter Shields Data Academy – an educational platform that empowers learners with best practices in data analytics and data science.
As the bestselling author of the number one book on data analytics, ‘SQL Quickstart Guide’, Walter’s insights are sought after by learners around the globe. He is also a LinkedIn Learning course creator of top-rated data analytics courses and a professional in data science and machine learning from the prestigious Massachusetts Institute of Technology (MIT).
Over 100,000+ learners have already benefited from Walter’s guidance and expertise, as he helps them transform their data skills and achieve their goals. Join the Walter Shields Data Academy today and discover the power of data analytics and data science for yourself!
Join an upcoming cohort
SQL Zero to Hero
COST
$1,497 USD
UPCOMING
SQL Zero To Hero - Cohort 5
DATES
Nov 2—22, 2023
PAYMENT DEADLINE
Nov 2, 2023
COST
$1,497 USD
UPCOMING
SQL Zero To Hero - Cohort 6
DATES
Jan 10—26, 2024
PAYMENT DEADLINE
Jan 10, 2024
Course syllabus
01
UNDERSTANDING DATABASE STRUCTURE
In this module you will be introduced to the concept of a relational database, the SELECT statement and showcase the types of data you will encounter in a database:
- Understanding the language databases use
- How a relational database functions
- Data types
- Relational database management systems (RDBMSs)
- SQLite
02
SQL TOOLS AND STRATEGIES
In this module you will become familiar with the resources intended to be used in conjunction with this course, as well as the many exercises and self-assessment questions that will help you test your SQL knowledge:
- Setting up our SQL environment
- The sTunes database
- DB Browser for SQLite
- Self-assessments
- SQL learning strategies
03
EXPLORING A DATABASE IN SQLITE
In this module, we will familiarize ourselves with the interface of our chosen SQL browser for SQLite: DB Browser:
- Launching the SQL software
- Opening a database file
- The Database Structure tab
- The Browse Data tab
- The Execute SQL tab
04
GETTING STARTED WITH QUERIES
In this module you will cover the basics of writing a good query and formatting the results. By the end of this module you will be able to select individual fields from a specific database and display those fields in alphabetical order:
- Query notation techniques
- SQL query basics
- Using an alias
- Sorting results alphabetically
- Limiting query results
05
TURNING DATA INTO INFORMATION
Learn how SQL provides some tools that not only allow you to narrow down your result set that is, the results of your query to very specific data, but also to order and filter your data by user-specified conditions:
- Operators in SQL
- The WHERE clause
- Searching for text using wildcard values
- The DATE()
06
WORKING WITH MULTIPLE TABLES
In this module you will learn to access data from multiple tables simultaneously. You become comfortable obtaining data from two or more tables with a single query by using powerful tools called joins:
- Introducing joins
- Joins and relational database structure
- Joins and aliases
- Inner join, left outer join, and right outer
07
USING FUNCTIONS
In this module you will learn how to simplify your calculations by using functions:
- Adding calculations to your queries
- Types of functions in SQL
- String functions
- Date functions
- Aggregate functions
08
SUBQUERIES
In this chapter you’ll learn about Subqueries and how to use them as an alternate method of simultaneously accessing data from more than one table:
- Subqueries and aggregate functions
- SELECT statement subqueries
- WHERE clause subqueries
- Subqueries without aggregate functions
- Returning multiple values
09
VIEWS
Transform queries into reusable views, modify and remove views, create views from joins, and learn data manipulation techniques for inserting, updating, and deleting data.
- Turning Previous Queries into Views
- Why We Use Views
- How to Modify a View
- Creating a View from Joins
- Removing a View Using the DROP Statement
10
DATA MANIPULATION LANGUAGE (DML)
- Data Analysis Versus Database Management
- Inserting Data into a Database
- Updating Data and the SET Keyword
- Deleting Data
11
CAPSTONE PROJECT: Customer Returns Prediction (AI) in E-commerce using SQL
Combine SQL with AI/ML techniques to predict customer returns in e-commerce. Retrieve and prepare data, leverage advanced algorithms for accurate predictions, and drive data-driven decision-making for business growth.
Course schedule
4-6 hours each week for 3 weeks
Tuesdays & Thursdays
Day or Evening Classes
Live sessions will be a healthy mix of SQL concept explanations, interactive demos, and peer to peer projects to keep you active and connected with your fellow data analyst.
elect a Cohort
Limited Seating
Register Today! Cohort classes fill up quick, register now so you secure your seat for this Cohort!
Use SQL to build a regression model predicting customer returns in e-commerce.
Capstone Project!
Use SQL to build a regression model predicting customer returns in e-commerce. Retrieve data, clean/prep, perform analysis. Gain practical experience in SQL-based data analysis for e-commerce return prediction.
Based on my Best-Selling Book on SQL
Join an upcoming cohort
SQL Zero to Hero
COST
$1,497 USD
UPCOMING
SQL Zero To Hero - Cohort 5
DATES
Nov 2—22, 2023
PAYMENT DEADLINE
Nov 2, 2023
COST
$1,497 USD
UPCOMING
SQL Zero To Hero - Cohort 6
DATES
Jan 10—26, 2024
PAYMENT DEADLINE
Jan 10, 2024
Learning is better with cohorts
Engage Actively, not passive watch
This course expands upon live workshops and practical projects.
Interactive and hands-on approach
Collaborate with fellow learners in breakout rooms and project groups.
Study alongside a peer group
Connect with a community of individuals who share your passion for learning.
Where to Start With Data?
Do You Want To Improve Your Data Skills, But Don’t Know Where To Start?
In this FREE pdf, I will walk you through:
- The 3 core data skills to learn
- Recommended courses to take
- Links to my Linkedin Learning course
Get this free resource
Free resource
Frequently Asked Questions
It’s great if you can make the live sessions as you’ll be able to ask questions live and get “in-the-moment feedback”. And, of course, there’s a special magic that happens in live sessions.
But we all have lives outside the course so we record every session to watch later and you’ll be able to get feedback by posting your work in the community.
Yes! this course is designed for busy professionals with full-time work commitments. Depending on your location, classes meet twice per week in the evenings.
You’ll be expected to spend time working on homework and projects outside of class each week, but the workload is designed to be manageable with a full-time job.
Yes! Upon passing this course, you will receive a signed certificate of completion.
We stand behind this course 100% If it’s just not working for you, contact us before the course ends and we’ll give you a full refund.
However: because there are limited spaces available, please think carefully about joining and taking up a valuable space if you have any second thoughts or doubts about your availability or commitment to the course
Walter will teach all the live sessions which will be interactive and have plenty of time for questions and feedback.
Walter will also be active in the community providing feedback on the work you share.
You’ll get lifetime access to all the course material and recordings of the live session.
You have one Capstone Project where, you’ll select a data set for exploration and apply all of the techniques covered throughout the course to solve a gamified crime with SQL.
1 on 1 Video Call:
Schedule a meeting with Walter
Email Walter: walter@waltershields.com
Join an upcoming cohort
SQL Zero to Hero
COST
$1,497 USD
UPCOMING
SQL Zero To Hero - Cohort 5
DATES
Nov 2—22, 2023
PAYMENT DEADLINE
Nov 2, 2023
COST
$1,497 USD
UPCOMING
SQL Zero To Hero - Cohort 6
DATES
Jan 10—26, 2024
PAYMENT DEADLINE
Jan 10, 2024