Discover Classes. Earn 10% Rewards.

SQL Bootcamp

Master the art of turning raw data into actionable insights with SQL queries. This hands-on course will teach you how to filter, group, and join data, as well as use advanced techniques like subqueries and aggregate functions. Gain the skills to excel in any data-driven industry and make more informed decisions.

  • All levels
  • 18 and older
  • $975
  • Earn 10% Rewards
  • Price Lock
  • Interactive Online Classroom
Book at School

Express Checkout – $975


Proceed to Checkout

No Booking Fees. Lowest Price Guaranteed. Earn 10% Rewards.

Give as a Gift

Start Dates (7)

  • $975/person
19 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 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
20 left
Book
Show all 3 sessions
  • Sat, Sep 07 at 10:00am - 5:00pm
  • Sat, Sep 14 at 10:00am - 5:00pm
  • Sat, Sep 21 at 10:00am - 5:00pm
20 left
Book
Show all 3 sessions
  • Mon, Sep 30 at 10:00am - 5:00pm
  • Tue, Oct 01 at 10:00am - 5:00pm
  • Wed, Oct 02 at 10:00am - 5:00pm
20 left
Book
Show all 3 sessions
  • Mon, Nov 04 at 10:00am - 5:00pm
  • Tue, Nov 05 at 10:00am - 5:00pm
  • Wed, Nov 06 at 10:00am - 5:00pm
Showing 15 of 7

Class Description

Description

What you'll learn in this sql class:

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.

Learn more about SQL Bootcamp at Noble Desktop.

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Also available in-person in NYC

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

  • Students may cancel up to 14 days before the class/program start date and receive a refund, less the registration fee (10% of the undiscounted course price). 
  • Cancellations within 14 days are not permitted, but students may reschedule up to three business days before the class start date.
  • For cancellations and reschedules, please email us at [email protected]"

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Noble Desktop (376)

(4.6-star rating across 376 reviews)
  • SQL Bootcamp

    Reviewed by Kayla S. on 1/10/2024
  • SQL Bootcamp

    Anonymous review on 5/23/2016
See reviews for other classes at Noble Desktop
loading...
Hide Reviews

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

Noble Desktop

Noble Desktop is a renowned educational institution that specializes in providing comprehensive training in various creative and technology-related fields. Established in 1990 and headquartered in New York City, Noble Desktop has earned a stellar reputation for its high-quality courses and innovative...

Read more about Noble Desktop

CourseHorse Approved

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

Noble Desktop

Reviews of Noble Desktop at coursehorse.com

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.

  • Price Lock Guarantee

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • Earn 10% Reward Points

    Maximize your savings with every purchase. Unlock rewards on every transaction, ensuring you get the most value out of your experience!

  • No Added Fees

    Enjoy hassle-free transactions without worrying about additional charges. With us, what you see is what you pay - no surprises!

  • Curated Courses

    Discover a curated selection of courses handpicked by experts in the field. Dive into quality content that suits your learning needs and interests!

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...