Hero image

SQL Zero to Hero Accelerator

2 Weeks

·

Cohort-based Course

Data analytics shouldn’t be so complicated. Future-proof your career and learn to analyze data with SQL. Based on my Best-selling SQL book.

Hosted by

Walter Shields

Best-Selling Author | Data Analyst SME | LinkedIn Learning Instructor

Course overview

Go From Data Newbie to SQL Master in 2 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
Be the first to know about upcoming cohorts

SQL Zero to Hero Accelerator

Meet your instructor

Walter Shields

Walter Shields

Walter Shields is the author of the #1 best selling and highest rated book on SQL & Data Analytics: SQL Quickstart Guide.


Partnering with Manning Publishing, LinkedIn Learning and Microsoft Learn, he develops books & courses on Data Analytics. More importantly, he's helped thousands of students, departments and managers, confidently master the skill of SQL and Data Analytics.


Outside of work he is married to the amazing Elke and they have two great kids: Julien and Maxi.


And thinking of getting a dog soon.


His passions are music (Soca and Reggae to be exact) and meditation.


He is also in Miami now and a Soccer Fan, so message him if you’re in town and want to grab an Inter Miami CF game :)

A pattern of wavy dots
Be the first to know about upcoming cohorts

SQL Zero to Hero Accelerator

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

CAPSTONE PROJECT

A fun gamified group project where you use what you've learned in the course to solve a crime with your data analytics skills.

Course schedule

4-6 hours each week for 2 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.

  • September 20, 22, 27, 29

    Limited Seating

    Register Today! Cohort classes fill up quick, register now so you secure your seat for this Cohort!

  • Gamified Group Project

    Solve The Crime!

    You will be using your new found SQL knowledge to assist authorities in solving a crime. You will paired up in Groups of two to design SQL solutions to crack the case!

Based on my Best-Selling Book on SQL

Based on my Best-Selling Book on SQL
A pattern of wavy dots
Be the first to know about upcoming cohorts

SQL Zero to Hero Accelerator

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
Be the first to know about upcoming cohorts

SQL Zero to Hero Accelerator

Stay in the loop

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