Yelp Facebook LinkedIn YouTube Twitter Instagram

SQL Bootcamp

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

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.

  • 18 Hours
  • Small classes
  • Mac or PC provided
  • Free retake

Register for a class

$975 Discounts Policies

594 Broadway, NYC or Live Online

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
View full syllabus

SQL Bootcamp Class Syllabus

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

Learn Real-world Design & Coding Skills

“Noble Desktop is far and away the most efficient way of gaining computer graphics skills. They give real-world exercises to work on, teach best practices, and inspire many an ‘aha!’ moment. Highly recommended.”
Joanne Hu

Students learning graphic design & coding at Noble Desktop

29 Years of Experience

Since 1990 we have perfected the craft of teaching. If students get hung up on an issue, we tweak the class to make it better. We’re the longest running independent training center for code and design in NYC.

Students learning hands-on at Noble Desktop

Register for SQL Bootcamp

$975 Discounts Policies

594 Broadway, NYC or Live Online