Discover Classes. Earn Rewards.

SQL Bootcamp

Master the fundamentals of SQL and gain the skills to easily clean, manipulate, and analyze data with English-like queries. Take your role in decision-making to the next level in any industry as you become proficient in this in-demand skill. Join us for this comprehensive course that covers everything from basic querying techniques to advanced concepts like subqueries and timestamp functions.

  • Beginner
  • 18 and older
  • $975
  • Live Online Webinar, New York, NY & Virtually Online

Start Dates (7)

  • $975
  • Live Online Webinar @ Live Online Webinar, New York, NY 10001
20 seats left
Book
Show all 3 sessions
  • Tue, Apr 30 at 10:00am - 5:00pm
  • Wed, May 01 at 10:00am - 5:00pm
  • Thu, May 02 at 10:00am - 5:00pm
20 seats left
Book
Show all 3 sessions
  • Mon, Jun 10 at 10:00am - 5:00pm
  • Tue, Jun 11 at 10:00am - 5:00pm
  • Wed, Jun 12 at 10:00am - 5:00pm
20 seats left
Book
Show all 3 sessions
  • Wed, Jul 10 at 10:00am - 5:00pm
  • Thu, Jul 11 at 10:00am - 5:00pm
  • Fri, Jul 12 at 10:00am - 5:00pm
20 seats left
Book
Show all 6 sessions
  • Thu, Jul 25 at 6:00pm - 9:00pm
  • Tue, Jul 30 at 6:00pm - 9:00pm
  • Thu, Aug 01 at 6:00pm - 9:00pm
  • Tue, Aug 06 at 6:00pm - 9:00pm
  • Thu, Aug 08 at 6:00pm - 9:00pm
  • Tue, Aug 13 at 6:00pm - 9:00pm
20 seats left
Book
Show all 3 sessions
  • Mon, Aug 12 at 10:00am - 5:00pm
  • Tue, Aug 13 at 10:00am - 5:00pm
  • Wed, Aug 14 at 10:00am - 5:00pm
Showing 15 of 7

Class Description

Description

What you'll learn in this data science course:

Learn SQL fundamentals including data types and queries.

Why SQL?

Upwards of 90% of time on data wrangling is spent cleaning and manipulating data. With SQL you can easily address these challenges with English-like queries to a database. The gap between the supply and demand of people skilled in SQL is huge. As nearly every industry is moving toward being more data-driven, having this skill will give you a larger role in decision-making wherever you work.

You’ll be introduced to foundational concepts like tables, data types, and queries. Once you understand the basics of viewing tables, you’ll be introduced to more advanced querying techniques like filtering and aggregating. You will be able to drill down into specific cases or step back and see larger patterns. You’ll also learn how to combine information from different tables using join statements and views. The final day of the course will cover advanced techniques like creating subqueries and using timestamp functions.

This course will use Postgres, an advanced open-source database. Concepts from this course will apply equally to other databases such as MySQL and SQL Server, with the minor syntax differences noted during class.

What You’ll Learn:

  • Explore and alter data using a graphical user interface
  • Write queries to search through tables programmatically
  • Understand different data types and converting between them
  • Combine information across tables with join statements
  • Advanced techniques like subqueries and timestamp functions

Learn more about SQL Bootcamp at Practical Programming.

Syllabus

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

Refund Policy

To reschedule or cancel, email us at [email protected]

All courses include a non-refundable registration fee (10% of the undiscounted course price).

  • Students may cancel up to 11 business days before the class/program start date and receive a refund, less the registration fee.
  • Cancellations within 11 business days are not permitted; however, students may reschedule up to 4 business days before the class start date.

Note: Any refunds must be requested within 180 days from the original payment date; courses rescheduled within 11 business days of the start date are not eligible for refunds.

Reviews of Classes at Practical Programming (378)

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Practical Programming

Practical Programming classes and workshops for everyone who wants to learn how to code from scratch or practice Python. You will learn how to start using Python, problem solving with algorithms and make dynamic web applications.

No coding experience needed, anyone who would like to learn how to code...

Read more about Practical Programming

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified NYC educator.

Practical Programming

Practical Programming

All classes at this location

Live Online Webinar

Also available virtually online

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...