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.
  • icon for small classesSmall classes
  • icon for small classesComputer provided
  • icon for small classesBook included
  • icon for small classesFree retake

Register for a Class 

$975 18 Hours In-person classroom training

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

Register at nobledesktop.com 

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