PostgreSQL Bootcamp

SQL Bootcamps in NYC

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.

Register For a Class

This course is offered at our design school, Noble Desktop. View upcoming dates and register for this course directly on Noble Desktop’s website.

Register at nobledesktop.com pop-out-line
tag-solid $975 clock-solid 18 Hours map-marker-solid 185 Madison Ave, 3rd Floor, NYC
  • video-gallery-solid

    Video Training and Workbook Included

    Students get a workbook and lifetime access to self-paced training videos, a $95 value.

  • display-solid

    Computer Provided

    Modern computer classroom with your choice of Mac or PC to work on.

  • users-solid

    Small In-Person Classes

    Get personalized attention in small groups with an expert instructor in the classroom.

  • redo-line

    Free Retake

    Refresh the course materials within six months for free as long as there's space in the class.

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

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

    Object Explorer
  • 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
help-solid

Frequently Asked Questions

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