# SQL Course Online (Self-Paced) Canonical URL: ## Overview Turn the information in databases into useful insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you’ll learn how to code queries to extract the specific information you want. Learn how to filter the data, group it, and turn raw data into insights. Combine information from multiple tables using join statements. You’ll also learn more advanced techniques like aggregate functions, subqueries, and how to use functions with parameters. In this hands-on course, you’ll learn PostgreSQL and the free DBeaver app to explore the database and execute SQL queries you write. The concepts you’ll learn on PostgreSQL can be applied to other flavors of SQL (such as Microsoft SQL Server, MySQL, etc.) with minor syntax differences. #### Why Learn SQL? With SQL, you can answer questions from information stored in a database (the ultimate system of storing data for most companies). As nearly every industry is becoming more data-driven, having this skill will give you a larger role in decision-making wherever you work. SQL is vital to anyone in business or any job that involves working with data: business analysts, data analysts, data scientists, web developers, business people, and many others. ## What you'll learn - Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver (a popular free database app) - Write SQL queries to retrieve data from tables in a database - Combine information from multiple tables with JOIN statements - Filter data, group it, and sort it to extract the specific info you need - Learn advanced techniques like subqueries, string functions, and IF‑ELSE logic with CASE - Learn how to use views and functions with parameters instead of directly querying tables ## Curriculum ### Foundations of SQL & Databases #### SQL Fundamental Concepts - What is SQL & why is it used? - Flavors of SQL: Postgres vs SQL Server, etc. - Database Tables, Rows, & Columns - Using ER (Entity Relationship) Diagrams to visual what’s in a database #### Exploring Databases & Writing SQL Statements (using the free DBeaver app) - Connecting to a Database - Database Navigator - SQL Query Editor - Using Code Hints - Viewing the Results of your SQL query - Setting Preferences ### Writing SQL Queries #### Writing SELECT Statements - Syntax of a SELECT statement - Selecting all columns or specific columns from a table - Limiting the number of results using LIMIT - Ordering the results using ORDER BY - Returning only DISTINCT records (eliminating duplicates) #### Filtering Results - Data Types (Strings vs Numbers) - Comparison Operators: equal to, greater or less than, not equal to, etc. - Filtering results using WHERE, AND, OR, IN, and NOT - Pattern Matching: Wildcard Filters - Case Sensitivity ### Using Joins to Combine Data from Multiple Tables #### Understanding Table Relationships - What are Primary vs Primary Keys - Database Relations: One-to-One, One-to-Many, & Many-to-Many #### Inner Joins - The difference between Inner & Outer Joins - Inner Joins - Column & Table Aliases #### Outer Joins & Finding NULLs - Left Join - Right Join - Full Join - Find NULL values ### Manipulating, Aggregating, & Filtering Data #### Using CAST to Change Data Types - Why and how to use CAST to make a data type fit your query’s needs #### Aggregate Functions - Using Aggregate Functions to perform common statistical calculations - Using SUM, COUNT, AVG, MAX & MIN #### Working with Dates & Time - Date Functions: Getting the desired part of a date/time (Year, Month, Day, etc.) - Formatting dates, including the day of the week (Sunday, Monday, etc.) - Calculating the difference between 2 dates ### Grouping Data & Filtering Grouped Data #### Grouping Data with Aggregate Functions - Using GROUP BY to organize results into categories - Applying Aggregate Functions to groups #### Filtering Grouped Data with HAVING - Using HAVING to filter the results of a GROUP BY - HAVING vs WHERE ### Advanced Query Techniques #### Subqueries - Subqueries: Queries within queries - Single-Value vs Multi-Value vs Table-Value Subqueries #### Aggregate Window Functions - Using OVER and PARTITION BY to apply Aggregate Functions #### Conditionals with CASE - Adding If-Else Logic with CASE - Simple CASE vs Searched CASE #### String Functions - Manipulating text using string functions - Using SUBSTRING, SPLIT\_PART, UPPER, etc. #### Self Join - How a Self Join is different from other types of joins - Using a Self Join ### Views & User-Defined Functions #### Views - What are Views? - The Advantages & Disadvantages of using Views - How to Use & Query a View #### Materialized Views - The difference between regular Views and Materialized Views #### User-Defined Functions - Using Scalar-Value (Single-Value) Functions - Using Table-Value Functions ## Instructors ### Dan Rodney — School Director, Instructor, & Senior Course Developer Dan Rodney has been a designer and web developer for over 20 years, creating coursework and leading innovative training initiatives at Noble Desktop. He teaches courses covering Figma, HTML & CSS, Adobe Photoshop, InDesign, Illustrator, and Power BI. Dan has also been at the forefront of integrating AI into design and business workflows, spearheading Noble Desktop’s latest AI course offerings. In addition to teaching and curriculum development, he writes custom scripts for InDesign (Make Book Jacket, Proper Fraction Pro, and more) and works with automation and AI-driven tools in his free time. You can find Dan on X (Twitter), LinkedIn, Facebook, and at danrodney.com. Learn more about [Dan Rodney's](/dan-rodney) background and expertise. ### Garfield Stinvil — Senior Instructor Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently. Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills. ## Pricing **Tuition:** $975