# SQL Bootcamp Canonical URL: ## Overview ### Why SQL? Most of the time spent working with data goes into cleaning and manipulating it. With SQL you can easily address these challenges with English-like queries to a database. The gap between the supply and demand of people skilled in SQL is huge. 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. ### What You'll Learn 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 won't just learn the syntax, but also the crucial skill of translating plain English questions into SQL. 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 using timestamp functions. This course will use Postgres, an advanced open-source database management system. Concepts from this course will apply equally to other database systems such as MySQL and SQL Server, with the minor syntax differences noted during class. ## What you'll learn - Explore and alter data using a graphical user interface - Write queries to search through tables programmatically - Understand different data types and converting between them - Combine information across tables with join statements - Advanced techniques like subqueries and timestamp functions ## Curriculum ### Foundations of SQL & Databases #### SQL Fundamental Concepts - What is SQL & why is it used? - Flavors of SQL: Postgres vs SQL Server, etc. - Database Tables, Rows, & Columns - Using ER (Entity Relationship) Diagrams to visualize what’s in a database #### Exploring Databases & Writing SQL Statements (using the free DBeaver app) - Connecting to a Database - Database Navigator - SQL Query Editor - Using Code Hints - Viewing the Results of your SQL query - Setting Preferences ### Writing SQL Queries #### Writing SELECT Statements - Syntax of a SELECT statement - Selecting all columns or specific columns from a table - Limiting the number of results using LIMIT - Ordering the results using ORDER BY - Returning only DISTINCT records (eliminating duplicates) #### Filtering Results - Data Types (Strings vs Numbers) - Comparison Operators: equal to, greater or less than, not equal to, etc. - Filtering results using WHERE, AND, OR, IN, and NOT - Pattern Matching: Wildcard Filters - Case Sensitivity ### Using Joins to Combine Data from Multiple Tables #### Understanding Table Relationships - What are Primary vs Foreign Keys - Database Relations: One-to-One, One-to-Many, & Many-to-Many #### Inner Joins - The difference between Inner & Outer Joins - Inner Joins - Column & Table Aliases #### Outer Joins & Finding NULLs - Left Join - Right Join - Full Join - Find NULL values ### Manipulating, Aggregating, & Filtering Data #### Using CAST to Change Data Types - Why and how to use CAST to make a data type fit your query’s needs #### Aggregate Functions - Using Aggregate Functions to perform common statistical calculations - Using SUM, COUNT, AVG, MAX & MIN #### Working with Dates & Time - Date Functions: Getting the desired part of a date/time (Year, Month, Day, etc.) - Formatting dates, including the day of the week (Sunday, Monday, etc.) - Calculating the difference between 2 dates ### Grouping Data & Filtering Grouped Data #### Grouping Data with Aggregate Functions - Using GROUP BY to organize results into categories - Applying Aggregate Functions to groups #### Filtering Grouped Data with HAVING - Using HAVING to filter the results of a GROUP BY - HAVING vs WHERE ### Advanced Query Techniques #### Subqueries - Subqueries: Queries within queries - Single-Value vs Multi-Value vs Table-Value Subqueries #### Aggregate Window Functions - Using OVER and PARTITION BY to apply Aggregate Functions #### Conditionals with CASE - Adding If-Else Logic with CASE - Simple CASE vs Searched CASE #### String Functions - Manipulating text using string functions - Using SUBSTRING, SPLIT\_PART, UPPER, etc. #### Self Join - How a Self Join is different from other types of joins - Using a Self Join ### Views & User-Defined Functions #### Views - What are Views? - The Advantages & Disadvantages of using Views - How to Use & Query a View #### Materialized Views - The difference between regular Views and Materialized Views #### User-Defined Functions - Using Scalar-Value (Single-Value) Functions - Using Table-Value Functions ## Schedule - Oct 26, 2026 – Oct 28, 2026 — NYC - Oct 27, 2026 – Nov 12, 2026 — NYC - Nov 15, 2026 – Dec 6, 2026 — NYC - Nov 23, 2026 – Nov 25, 2026 — NYC - Dec 14, 2026 – Dec 16, 2026 — NYC - Jan 19, 2027 – Jan 21, 2027 — NYC - Feb 17, 2027 – Feb 19, 2027 — NYC - Feb 23, 2027 – Mar 11, 2027 — NYC - Mar 7, 2027 – Mar 21, 2027 — NYC - Mar 15, 2027 – Mar 17, 2027 — NYC - May 17, 2027 – May 19, 2027 — NYC - Jun 22, 2027 – Jul 8, 2027 — NYC - Jul 11, 2027 – Jul 25, 2027 — NYC - Jul 19, 2027 – Jul 21, 2027 — NYC - Sep 7, 2027 – Sep 9, 2027 — NYC ## FAQ ### Who is the target audience for this course? Leaders interested in making better data-driven decisions and “knowing the numbers” Analysts looking to deepen their skillset beyond Excel and Tableau Developers who want to be more comfortable working with databases ### How is this class structured? This course is an 18-hour bootcamp that teaches the student the ins and outs of SQL. Students will learn to explore data using a GUI, write search queries, combine information, and much more. ### How many students are in a given class? Our typical class ranges from 8-12 students, but we allow up to 20 students to register for our course. ### Why should I learn SQL? Data has become central to almost every job on the market and it is becoming an increasingly necessary skill to know how to handle and control data. As data grows larger, databases are now the only mode of storage that can handle the quantity. There is a gap across industries between the supply and demand of those who can manage databases. In order to work with a database, one must know SQL. ### What type of SQL is being used? This class uses PostgreSQL but concepts from this course will apply equally to other databases such as MySQL and SQL Server, with the minor syntax differences noted during class. ### Is there mandatory work outside of the classroom? Students are not required to complete any work outside of class. However, we provide students with bonus materials if they would like extra practice. ### What tangible skills do students leave with after the class? Students will learn how to explore and alter data within a database as well as use join statements and perform various techniques such as subqueries and stored procedures. They learn how to translate business questions posed by their non-technical colleagues into SQL queries. ### Is this course open to beginners? Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required. ### Do you offer payment plans or student financing for this course? This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify. ### Can I take this course online (remote learning)? No upcoming live online dates are currently available. Please contact us about future availability. ### What happens if I need to miss a session? You have some options: You can watch a recording of the session. We will provide any course materials. Contact us to confirm whether remote attendance is available for your session. You can use your free retake to make up any missed class time. ### What’s included with my tuition? A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed Additional personalized 1-on-1 bonus training with an industry expert to reinforce concepts Top-notch curricula that have been tried and tested over many cohorts and are consistently improved for an optimal learning experience A 1-year free retake policy which allows students to retake any part of the course or program for free to refresh the materials and gain additional practice 30-day access to class recordings to review material at your own pace A certificate of completion to verify your accomplishment ### Are there any additional fees or expenses? There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us. However, if you plan to take the course live online , you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost. ### Do you offer any discounts for this course? Take this course as part of a certificate program and save: Data Science Certificate Price: $3,995 | Hours: 114 Hours ## Pricing **Tuition:** $975