Discover Classes. Earn 10% Rewards.

SQL Private Training

Unlock the power of databases with personalized SQL training. Master the art of querying, filtering, and aggregating data using PostgreSQL, gaining essential skills applicable across various database platforms. Transform

  • All levels
  • 13 and older
  • $399
  • Earn 10% Rewards
  • Price Lock
  • 185 Madison Ave, New York, NY & Virtually Online
  • 3 hours

Book This Course

Fill out this form and the course provider will contact you with more information about this course.

  • $399
  • 3 hours

By submitting this form, I consent to CourseHorse providing the information in this form with the course provider which may contact me via email, phone or text.

Class Description

Description

What you'll learn in this sql class:

Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results. You'll learn PostgreSQL in this class, but the concepts apply equally to other databases such as SQL Server and MySQL.

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 at a Glance:

  • 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
  • Advanced techniques like Subqueries, String Functions, and IF‑Else logic with CASE
  • How to use Views and Functions with parameters instead of directly querying tables

Syllabus

Foundations of SQL & Databases

  • SQL Fundamental Concepts
  • Exploring Databases & Writing SQL Statements (using the free DBeaver app)

Writing SQL Queries

  • Writing SELECT Statements
  • Filtering Results

Using Joins to Combine Data from Multiple Tables

  • Understanding Table Relationships
  • Inner Joins
  • Outer Joins & Finding NULLs

Manipulating, Aggregating, & Filtering Data

  • Using CAST to Change Data Types
  • Aggregate Functions
  • Working with Dates & Time

Grouping Data & Filtering Grouped Data

  • Grouping Data with Aggregate Functions
  • Filtering Grouped Data with HAVING

Advanced Query Techniques

  • Subqueries
  • Aggregate Window Functions
  • Conditionals with CASE
  • String Functions
  • Self Join

Views & User-Defined Functions

  • Views
  • Materialized Views
  • User-Defined 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]"

Reviews of Classes at Noble Desktop (373)

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

Noble Desktop

Noble Desktop

All classes at this location

We are located in New York City on 34th street and Madison Avenue, a few blocks from Penn Station, Port Authority and Times Square. You may also attend this class live online (virtual training) via Zoom. We will reach out with additional information, including the Zoom info and class files.

Also available virtually online

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