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.
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.
Get notified about the next cohort
Hosted by
Walter Shields
Best-Selling Author | Data Analyst SME | LinkedIn Learning Instructor
Course overview
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.
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.
You'll learn what the basic structure of a database is, how they work and how to navigate them without confusion.
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.
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.
You'll learn how to interpret verbal and written requests so you can transform them into effective SQL query solutions.
Vivien Peters
Kevin Jones
Alex German
Jerome Paterson
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 :)
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:
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:
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:
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:
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:
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:
07
USING FUNCTIONS
In this module you will learn how to simplify your calculations by using 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:
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.
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.
Limited Seating
Register Today! Cohort classes fill up quick, register now so you secure your seat for this Cohort!
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!
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
Sign up to be the first to know about course updates.