SQL for Non-Programmers

2h 44mBeginner2025-02-25

Authors

Christina Stathopoulos

Data Whisperer, Analytics Specialist, Public Speaker, and Educator

Course details

New technologies allow data to be shared, accessed, and analyzed more easily than ever before, even by non-data science professionals. Regardless of your industry, technical background, or current role, you can now leverage data to make better business decisions with the easy-to-use SQL Data Query Language. This course covers some of the most basic, fundamental SQL commands for non-programmers and non-data science professionals.

Join instructor Christina Stathopoulos as she demonstrates the skills required to independently and confidently access and analyze your data, utilizing key commands, functions, and joins such as SELECT, ORDER BY, WHERE, GROUP BY, HAVING, CASE, wildcards, UNION, and more. Along the way, test out your new skills in the exercise challenges at the end of each section.

Skills covered

SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware DevelopmentOne-Off

Concepts

0. Introduction

01 - Why SQL and why now
02 - What you should know
03 - Set up with SQLite and SQLiteStudio
04 - Explore the code challenge environment

1. Getting Started with Relational Databases, SQL, and DQL

05 - Relational databases
06 - Database structuring through normalization
07 - The power of SQL
08 - DQL for all

2. Basic Commands

09 - Getting started with SQL
10 - Retrieving data with SELECT
11 - Formatting your query
12 - Putting order to your data with ORDER BY
13 - Filtering your data with WHERE
14 - Filtering your data with multiple conditions
15 - Solution - Basic commands solved

3. Aggregate Functions

16 - Getting started with aggregate functions
17 - Making aggregate functions work for you
18 - Group data using GROUP BY
19 - Filter on groups of data with HAVING
20 - Solution - Aggregate functions solved
21 - Solution - Filtering on groups solved

4. Multiple Table Joins

22 - Combining tables with an Equijoin
23 - From Equijoins to inner joins
24 - Other types of SQL joins
25 - Solution - Equijoins solved
26 - Solution - Inner joins solved

5. Advanced Commands

27 - Categorize data with CASE
28 - Beyond basic CASE statements
29 - Creating Calculated Fields
30 - Matching data with wildcards
31 - Combining data with UNION
32 - Solution - Advanced commands solved

6. Conclusion

33 - Recommendations and next steps