Discover Classes. Earn 10% Rewards.

SQL Bootcamp Online (Self-Paced)

Learn how to extract, filter, and manipulate data efficiently using SQL with a focus on PostgreSQL fundamentals. This course covers database querying, table joins, and advanced techniques for handling large datasets.

  • All levels
  • All ages
  • Earn 10% Rewards
  • Price Lock

    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!

  • Self-paced, start anytime

Express Checkout – $975


Proceed to Checkout

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

Give as a Gift

Book a Private Group Event

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

Or see all Data Analytics Group Events

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

Class Description

Description

Learn how to turn raw data into actionable insights by writing SQL queries. This course shows you how to view and navigate tables, columns, and rows, then write queries to pull the specific data you need. You'll discover how to filter and group data, shaping it into useful insights, and how to combine information from multiple tables using JOIN statements. You'll also get into advanced techniques such as aggregate functions, subqueries, and working with functions that take parameters.

Throughout this hands-on course, you'll use PostgreSQL and the free DBeaver app to explore databases and run SQL queries. The skills you build with PostgreSQL carry over to other SQL platforms like Microsoft SQL Server and MySQL, with only minor differences in syntax. As businesses across every industry keep leaning on data, knowing SQL will help you answer important questions and make informed decisions. SQL is an essential skill for anyone in business, data analysis, data science, web development, or any field that involves working with data.

What You Will Learn

  • Explore information stored in a database (tables, columns, rows, and more) through 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, group, and sort data to extract the specific info you need
  • Pick up advanced techniques like subqueries, string functions, and IF-ELSE logic with CASE
  • Discover how to use views and functions with parameters instead of querying tables directly

This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.

Similar Classes

Virtual Design & Construction Institute

VDCI offers career-focused software training in 2D drafting (CAD), Building Information Modeling (BIM), and Virtual Design & Construction (VDC). We are committed to providing our students with the best training, tools, and resources to prepare them for a career in the design and construction industry. Our courses are approved by Autodesk, Adobe, Trimble, and the American Institute of Architects (AIA) for eLearning.

View school profile
Virtual Design & Construction Institute
Vetted by CourseHorse

A verified Online educator.

Loading...