With SQL you can answer questions using a database, the ultimate system of record for most organizations. 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.

This course will teach you how to explore, modify, and export data from a database. 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 stored procedures.

Class Notes & Related Courses

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.
A Mac or PC with PostgreSQL will be provided for use during the class.
Register for this SQL Bootcamp at our coding school, Noble Desktop. For courses in SQL Server, see all our SQL classes and our SQL Server Bootcamp.

What You'll Learn

Explore and alter data using a graphical user interface
Write queries to search through tables programmatically
Understanding various data types and convert data between them
Combine information across tables with join statements
Advanced techniques like subqueries and stored procedures

Learn the Skills Guarantee™

Hands-on Training in small groups

Work on projects proven to boost retention

Workbook Included

Students get a custom workbook with step-by-step instructions.

Learn from industry experts with teaching experience

Experienced educators who are driven to help you succeed

Retake the course for free within one year

Refresh the course materials and gain additional practice

Setup Assistance Provided

Prior to the course, we will help you get set up properly with the software you need.

Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.

Full Course Syllabus

Download PDF Outline

Foundations

Basic Concepts

What is a relational database?
What is SQL?
What is Postgres?
Database tables
Rows and columns
Data types

Graphical User Interface

Query Window
Results Grid
Setting Options

Querying

Select Statements

Syntax of a SELECT statement
Selecting specific columns
Using a LIMIT clause
Distinct records
Using a WHERE clause
Field and Table Aliases

Filtering and Aggregating

Filtering with Text Criteria
Wildcard Filters
Filtering with Numeric Criteria
Using SUM, COUNT and AVG
Using MAX and MIN
Group-by Statements

Adding Data

Creating tables

Primary keys
Foreign keys
Data normalization
Create statement
Constraints

Inserting data

Insert statement
Nulls, empty strings and zeros
Update Statement
Setting Conflict Actions

Combining tables

Joins

Inner Joins
Full Outer Joins
Left/Right Joins

Views

Creating a view
Performance issues

Advanced Topics

Advanced querying

Subqueries
Querying JSON data

Stored Procedures

Creating a stored procedure
Transactions
Temp Tables

Functions

String Functions
Cast Function
Convert Function
Rounding Functions

Dealing with CSVs

Loading data from a CSV
Exporting a table to CSV

This Course is Available Live Online

You can attend this training live online at the scheduled time the course is offered (New York, Eastern Time) through screen-sharing software Zoom (free for you).
Our live online training is interactive and hands-on, just like our in-person classes. There are no extra fees and we'll work with you to ensure your setup is perfect.

Classes are activity-based and taught by a live instructor.

You can hear the instruction, ask questions, and share your screen—all in real-time.

Retake the course for free (in-person or live online) within one year.

See What Students Are Saying About Live Online

“Overall experience on Zoom was maybe even better than in IRL classroom because the instruction takes place right on your own screen, with less distraction. Great overall experience.”
“Given the fact that we had to do this entire class remotely due to Covid-19, I didn’t have very high expectations it would run so smoothly. However, I don’t think it could’ve gone any better. Not only do I feel very comfortable with the program now, but I’m actually excited to use it!”
“This was the first online class I’ve taken with ND and it was a great experience. Looking forward to the other classes I’ve signed up for!”

Frequently Asked Questions

Does this course require any prior knowledge or experience?

Students must be comfortable using a computer. No other prior knowledge is required.

Do I need to bring a computer?

No. We provide a computer with the necessary software for each attendee. Choose a Mac or a PC during the checkout process.

Are discounts available for this course?

No. This course is not eligible for any discounts.

We offer discounts for packages of classes, including our Excel Bootcamp, SQL Bootcamp, Data Analytics, and PowerPoint Bootcamp.

We also provide discounts for ten or more classes purchased together. Please reach out for more information on our voucher programs.

Does this course come with a book?

Yes. This course includes a complimentary book or manual at no additional cost.

What if I need to retake this course? May I retake it for free?

Yes. You may retake this course for free once within six months, provided that the class is running with an available seat. For more information, visit our policies page.

Can I take this course online (remote learning)?

You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).

How does attending “live online” work?

Students can attend this training remotely through screen sharing software (we use Zoom).
Participants can hear the instruction, ask questions, and even share their screen with the instructor.
For audio you can use your computer’s microphone/speakers or call a phone number that we’ll provide.
Classes are activity-based and taught by a live instructor, so we strongly encourage students who are local to the area to attend in person!

What if I don’t have the software on my computer?

Upon registration, please email contact@nyimtraining.com and we will help you get set up with the software or anything else needed for an optimal training experience.

Corporate & Onsite PostgreSQL Bootcamp Training

For over two decades, NYIM Training has created and delivered the highest-rated corporate training programs in New York. We have extensive experience developing curriculum for a variety of training sessions, both onsite and in our Midtown offices. Our program can be completely customized to suit your training needs.