Hero image

SQL Zero to Hero Accelerator

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!

Hosted by

Walter Shields

Best-Selling Author | MIT Data Scientist | LinkedIn Learning Instructor

Course overview

Go From Data Newbie to SQL Master 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.

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

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 Jones

Kevin Jones

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 after the first day. I feel like I can communicate with the best experts.
Alex German

Alex German

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!
Jerome Paterson

Jerome Paterson

Application Developer
A pattern of wavy dots
Join an upcoming cohort

SQL Zero to Hero Accelerator

SQL Zero to Hero Accelerator - Cohort 4

$760 USD

Dates

June 13 - 30, 2023

Payment Deadline

June 13, 2023

Meet your instructor

Walter Shields

Walter Shields

Walter Shields is a renowned data expert with over 25 years of experience managing data systems for start-ups, Fortune 500 companies, and organizations in industries ranging from law and healthcare to retail and beyond.


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 40,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!

A pattern of wavy dots
Join an upcoming cohort

SQL Zero to Hero Accelerator

SQL Zero to Hero Accelerator - Cohort 4

$760 USD

Dates

June 13 - 30, 2023

Payment Deadline

June 13, 2023

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

    6:00pm - 8:00pm EST

    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.

  • June 13, 15, 20, 22, 27, 29

    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

Based on my Best-Selling Book on SQL
A pattern of wavy dots
Join an upcoming cohort

SQL Zero to Hero Accelerator

SQL Zero to Hero Accelerator - Cohort 4

$760 USD

Dates

June 13 - 30, 2023

Payment Deadline

June 13, 2023

Learning is better with cohorts

Learning is better with cohorts

Active learning, not passive watching

This course builds on live workshops and hands-on projects

Interactive and project-based

You’ll be interacting with other learners through breakout rooms and project teams

Learn with a cohort of peers

Join a community of like-minded people who want to learn and grow alongside you

Frequently Asked Questions

What happens if I can’t make a live session?
Can I work full-time while enrolled in this course?
Will I earn a certificate?
What’s the refund policy?
How much access to Walter will I get?
How long do I have access to the course materials for?
What projects will I work on during the course?
What if I have more questions?
A pattern of wavy dots
Join an upcoming cohort

SQL Zero to Hero Accelerator

SQL Zero to Hero Accelerator - Cohort 4

$760 USD

Dates

June 13 - 30, 2023

Payment Deadline

June 13, 2023

Stay in the loop

Sign up to be the first to know about course updates.

$760 USD

3 Weeks