# SQL Bootcamp Canonical URL: ## Overview Turn the information in databases into valuable insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you'll learn how to write queries to extract the specific information you need. In this hands-on course, you'll learn PostgreSQL and the free DBeaver app to explore databases and execute SQL queries. The concepts you'll learn apply to other versions of SQL (such as Microsoft SQL Server and MySQL) with minor syntax differences. Learn how to filter and group data, combine information from multiple tables using JOIN statements, and apply advanced techniques like aggregate functions and subqueries. ## What you'll learn - Explore information stored in a database (tables, columns, rows, etc.) using the graphical interface of DBeaver, a popular free database app. - Write SQL queries to retrieve data from tables in the database - Combine information from multiple tables using JOIN statements - Filter data, group it, and sort it to extract the specific information you need - Master advanced techniques, including subqueries, string functions, and IF‑Else logic with CASE - Learn how to use views and functions with parameters instead of directly querying tables ## 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 ## Instructors ### Dan Rodney — School Director, Instructor, & Senior Course Developer Dan Rodney has been a designer and web developer for over 20 years, creating coursework and leading innovative training initiatives at Noble Desktop. He teaches courses covering Figma, HTML & CSS, Adobe Photoshop, InDesign, Illustrator, and Power BI. Dan has also been at the forefront of integrating AI into design and business workflows, spearheading Noble Desktop’s latest AI course offerings. In addition to teaching and curriculum development, he writes custom scripts for InDesign (Make Book Jacket, Proper Fraction Pro, and more) and works with automation and AI-driven tools in his free time. You can find Dan on X (Twitter), LinkedIn, Facebook, and at danrodney.com. Learn more about [Dan Rodney's](/dan-rodney) background and expertise. ### Garfield Stinvil — Senior Instructor Garfield is an experienced software trainer with over 16 years of real-world professional experience. He started as a data analyst with a Wall Street real estate investment company & continued working in the professional development department at New York Road Runners Organization before working at Noble. He enjoys bringing humor to whatever he teaches and loves conveying ideas in novel ways that help others learn more efficiently. Since starting his professional training career in 2016, he has worked with several corporate clients including Adobe, HBO, Amazon, Yelp, Mitsubishi, WeWork, Michael Kors, Christian Dior, and Hermès. Outside of work, his hobbies include rescuing & archiving at-risk artistic online media using his database management skills. ## 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? In this hands-on course you’ll learn the ins and outs of SQL. You will learn to explore data using a graphical interface of DBeaver, write SQL queries, combine information from multiple tables, and much more. There will be a combination of lectures explaining the concepts, coding demonstrations showing you how to write SQL, and time for you to write SQL queries based on challenge questions we provide. ### How many students are in a given class? Noble’s 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 is becoming larger, databases are now the only mode of storage that can handle the quantity. However, to work with a database, one must know SQL. ### What flavor of SQL will I learn in this class? In this training you’ll learn PostgreSQL, but the core concepts can be applied to other flavors of SQL (such as Microsoft SQL Server, Microsoft Access, MySQL, etc.) with minor syntax differences. Which version of SQL should you learn? You should learn the version of SQL used by the company you’ll be working with, but if you don’t know that here’s a guide to help: SQL Server runs on Windows and Linux. SQL Server Management Studio, the client used in our SQL Server classes, requires Windows. PostgreSQL works on both Mac and Windows. It is widely used in data science, data analytics, and by companies like Apple, Instagram, Uber, Netflix, etc. Whichever you end up learning, the concepts are transferrable to other SQL flavors with minor syntax differences. If you’re not sure, choose based on your goals and the tools used in your workplace. ### Is there mandatory work outside of the classroom? You are not required to complete any work outside of class. ### What tangible skills will I leave with after the class? You will learn how to explore and query data in a database, use join statements, filter data using various techniques such as subqueries, aggregate functions, and much more . ### 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)? Yes. This course is available online. See the course description and enrollment options for the training format and schedule. How do live-online sessions work? For live-online sessions, you attend at the scheduled class times (New York, Eastern Time). Attend remotely through Zoom with a live instructor. Hear the instruction, ask questions, and share your screen with the instructor. Use your computer’s microphone and speakers, or call the phone number we provide. You will need your own computer and any required software. See the course requirements for details. If you need assistance, contact us at hello@nobledesktop.com . ### 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. 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: Full-Stack Web Development Certificate Price: $7,995 | Hours: 420 Hours JavaScript Development Certificate Price: $5,995 | Hours: 336 Hours Software Engineering Certificate Price: $10,995 | Hours: 510 Hours Data Analytics Certificate Price: $4,995 | Hours: 156 Hours Data Science & AI Certificate Price: $3,995 | Hours: 114 Hours FinTech Bootcamp Price: $4,995 | Hours: 114 Hours Business Analyst Certificate Price: $2,995 | Hours: 63 Hours “MBA” Business Certificate Price: $3,495 | Hours: 96 Hours SQL Certification Program Price: $1,699 | Hours: 24 Hours Data Analytics & AI Certificate Price: $6,995 | Hours: 210 Hours Data Analytics Certification Price: $2,995 | Hours: 66 Hours ## Pricing **Tuition:** $975