# SQL Bootcamp Online Canonical URL: ## Overview Learn how to turn raw data into actionable insights by writing SQL queries. This course shows you how to view and navigate tables, columns, and rows, then write queries to pull the specific data you need. You'll discover how to filter and group data, shaping it into useful insights, and how to combine information from multiple tables using JOIN statements. You'll also get into advanced techniques such as aggregate functions, subqueries, and working with functions that take parameters. Throughout this hands-on course, you'll use PostgreSQL and the free DBeaver app to explore databases and run SQL queries. The skills you build with PostgreSQL carry over to other SQL platforms like Microsoft SQL Server and MySQL, with only minor differences in syntax. As businesses across every industry keep leaning on data, knowing SQL will help you answer important questions and make informed decisions. SQL is an essential skill for anyone in business, data analysis, data science, web development, or any field that involves working with data. ## What you'll learn - Explore information stored in a database (tables, columns, rows, and more) through the graphical interface of DBeaver, a popular free database app - Write SQL queries to retrieve data from tables in a database - Combine information from multiple tables with JOIN statements - Filter, group, and sort data to extract the specific info you need - Pick up advanced techniques like subqueries, string functions, and IF-ELSE logic with CASE - Discover how to use views and functions with parameters instead of querying tables directly ## Instructors ### Garfield Stinvil — 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. 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. ### Colin Jaffe — Instructor Colin Jaffe is a programmer, writer, and teacher with a passion for creative code, customizable computing environments, and simple puns. He loves teaching code, from the fundamentals of algorithmic thinking to the business logic and user flow of application building—he particularly enjoys teaching JavaScript, Python, API design, and front-end frameworks. Colin has taught code to a diverse group of students since learning to code himself, including young men of color at All-Star Code, elementary school kids at The Coding Space, and marginalized groups at Pursuit. Colin lives in Brooklyn with his wife, two kids, and many intricate board games. ### Brian McClain — Instructor Brian McClain is an experienced instructor, curriculum developer, and web developer. Brian served as Director for a coding bootcamp, where he is now a lead instructor and course developer for both JavaScript and Python. He teaches Web Development, JavaScript, Python for Data Science, Machine Learning, and AI. He taught Python Data Science and Machine Learning as an Adjunct Professor of Computer Science at Westchester County College. Brian is also an active industry professional in the field of generative AI app development. His website and iOS app, Artmink, provide appraisals of art and antiques from user-uploaded images. ## Pricing **Tuition:** $975