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
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
SQL Zero to Hero Accelerator - Cohort 4
$760 USD
Dates
June 13 - 30, 2023
Payment Deadline
June 13, 2023
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!
SQL Zero to Hero Accelerator - Cohort 4
$760 USD
Dates
June 13 - 30, 2023
Payment Deadline
June 13, 2023
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
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.
10
DATA MANIPULATION LANGUAGE (DML)
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.
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!
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.
SQL Zero to Hero Accelerator - Cohort 4
$760 USD
Dates
June 13 - 30, 2023
Payment Deadline
June 13, 2023
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
SQL Zero to Hero Accelerator - Cohort 4
$760 USD
Dates
June 13 - 30, 2023
Payment Deadline
June 13, 2023
Sign up to be the first to know about course updates.