SQL Bootcamp
Learn PostgreSQL to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering the results. Extract actionable insights from data sets in this hands-on training.
Learn PostgreSQL to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering the results. Extract actionable insights from data sets in this hands-on training.
Turn the information in databases into useful insights by writing SQL queries. Once you understand the basics of viewing tables, columns, and rows, you’ll learn how to code queries to extract the specific information you want.
Learn how to filter the data, group it, and turn raw data into insights. Combine information from multiple tables using join statements. You’ll also learn more advanced techniques like aggregate functions, subqueries, and how to use functions with parameters.
In this hands-on course you’ll learn PostgreSQL and the free DBeaver app to explore the database and execute SQL queries you write. The concepts you’ll learn on PostgreSQL can be applied to other flavors of SQL (such as Microsoft SQL Server, MySQL, etc.) with minor syntax differences.
With SQL you can answer questions from information stored in a database (the ultimate system of storing data for most companies). As nearly every industry is becoming more data-driven, having this skill will give you a larger role in decision-making wherever you work.
SQL is vital to anyone in business or any job that involves working with data: business analysts, data analysts, data scientists, web developers, business people, and many others.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
SQL Bootcamp is rated 4.8 stars by 132 students
in the past 24 months
I'd absolutely recommend this course to SQL beginners. (A basic understanding of relational databases, even just baseline Excel skills, are a plus.) The class content and structure were excellent. The format repeated PowerPoint presentation - coding demo - hands-on exercise for each new topic, which meant students never spent too long focusing on a lecture and always had a chance to apply what we'd just been taught immediately, which made the content stick. The instructor, Dan, was extremely well-prepared and well-paced, and is an engaging speaker who made three days of 8-hours-each code instruction digestible and interesting. I also thought Dan did a great job of balancing online and in-person students — hybrid is harder than he made it look, and I felt I had more than enough of his attention as an online attendee.
Jody Freinkel
Great introduction to SQL, top notch professor, and great learning materials.
Jason McKenna
A strong dive in SQL. You'll walk out of this class with a good grasp of database handling. A great professional skill.
Anderson Wang
Instructors at Noble Desktop are devoted to their students!
Andrew Gordon
Genghis was AMAZING. He was so clear in his explanations, and especially helpful if you had a specific question. I am in an online bootcamp now and his instruction was fantastic and helped me tremendously. Great format to offer practice SQL exercises, and then review with the instructor.
Tracy D.
The teacher was able to answer any questions asked! This course is great for people just getting into SQL!
Christian Gauthier
This class was amazing and helped me understand the basics of SQL.
Simone Wilson
I was skeptical about whether to join these classes since I don't have any previous experience in any coding or programming languages. But the classes are appropriate for any beginner and make understanding and learning skills easy.
Anwesh Kumar Yeddula Sobitha
If you want to learn SQL and get plenty of hands-on practice with an instructor who provides the business context, this is course will meet your needs.
Damaris Lasa
This was a great start to learning PostgresSQL as my instructor provided us with all the materials to become proficient in the language.
Jake Block
Great class to take for SQL!
Shannyl Baez
This class was very informative. Everything was really easy to understand. The instructor did a great job simplifying everything and answering our questions. I'm already putting my new SQL skills into practice at work.
Mariely De La Cruz
As one of our smaller courses, tuition for this course is due in full before the start date. The best way to save on this course is to take it as part of a certificate program.
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.
We don’t currently offer discounts as we do our best to affordably prices our courses.
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
The teaching method at Noble Desktop is perfect and the classes provide you with infinite knowledge that makes you eager to take everything they offer. I love Noble!
—Ivonne Ackerman
Experienced educators who are driven to help you succeed
Refresh the materials for free within one year
Attend this course in-person in NYC or Live Online via Zoom. Engage with expert instructors, ask questions, and get feedback on your exercises and projects. Switch between live-online and in-person as needed, even after the course has started.
Unlike other providers, these are not mass open-enrollment classes. At Noble Desktop, you’ll learn in small groups (typically 8-15 students) and receive personalized attention.
Get face-to-face interaction with an instructor and other students when you learn at our NYC campus. Courses are hands-on with a computer and software provided.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
Our instructors are verterans of their field and experienced educators, driven to help you succeed.
School Director, Instructor, & Senior Course Developer
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
We offer a single free retake of the the class within a year.
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
Learn practical skills by working on real projects with instructor guidance and lectures to strengthen and improve your skill.
Combine data from multiple tables using the various types of joins: inner, outer (left, right, and full) and self
Group data and apply aggregate functions to perform common statistical calculations
Filter grouped data using HAVING
Use CAST() to change data types. Make a data type fit the needs of your query.
Work with dates and time: year, month, day, day of week, etc.
Learn to query and work with Views, like you do with tables
Use Subqueries to grab data from anywhere in a database and use the result in another query
Use String Functions to get specific parts of text
Learn how to use custom functions with parameters (which are reusable and flexible)
Write SQL queries to retrieve information from a database to gain insights into your data
Get to know a database by exploring tables, columns, and more using DBeaver’s user interface
Use DBeaver’s ER Diagrams to see the structure of a database and how tables are connected via Primary & Foreign Keys
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.
Noble’s typical class ranges from 8–12 students, but we allow up to 20 students to register for our course.
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, in order to work with a database, one must know SQL.
In this training you’ll learn Microsoft SQL Server, but the core concepts can be applied to other flavors of SQL (such as PostgreSQL, 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:
Whichever you end up learning, the concepts are transferrable to other SQL flavors with minor syntax differences. So if you’re not sure, choose the one based on whether you use Mac or Windows.
You are not required to complete any work outside of 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.
Students must be comfortable using a computer. No other prior knowledge is required.
This course does not qualify for payments plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
You may attend this training virtually (online) at the scheduled time the course is offered (New York, Eastern Time).
You have some options:
Select up to two courses and tap Compare selected courses to view a side-by-side comparison of SQL Bootcamp with your selected courses.
Learn to extract information from databases by writing SQL queries, joining tables, aggregating data, and filtering results so you can turn data into actionable insights.
Master the tools to become a Data Scientist: Python, SQL, automation, and machine learning. Learn Python programming fundamentals and analyze data with Pandas, NumPy, and Matplotlib, and query databases with SQL. Use machine learning to apply regressions and other statistical analysis to create predictive models.
Learn functions, formulas, Pivot Tables, Macros, and time-saving techniques in this hands-on Excel Bootcamp. You'll conquer all the keys skills to become proficient in Microsoft Excel.
Learn the skills you’ll need to become a Data Analyst or Business Analyst, including data analysis, visualization, statistical analysis, and how to work with relational databases. Build a portfolio of projects and prepare for a career.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
We’ve trained thousands of companies!
Let us create the perfect program for your team.
There will always be more things to learn than you have time for. So the question is: which skills do you invest in and which do you skip? Like with any investment, it’s about weighing the costs and the benefits. While this is often a difficult question to answer, for SQL the balance is unusually compelling. Being able to explore a database with SQL is a powerful, fundamental skill that you can pick up quickly.
SQL takes less time to master than other programming languages. With a few weeks of dedicated practice, it’s possible to be competent in SQL. To reach professional-level competence in other programming languages (such as Python or JavaScript) takes far longer. Even at the most selective coding bootcamps, students take three months to a year to develop those skills. Compared to other languages, SQL is much more of a quick win.
In part, this is because SQL has a narrow focus. SQL is focused on one task: controlling a database. Other programming languages are more general-purpose.
However, it’s also because SQL is declarative. In SQL code, you only describe the output that you want, not the procedure to create it. The database itself is doing a lot of the heavy lifting, automatically finding an efficient way to accomplish your task. To get results in other programming languages, you generally have to specify a step-by-step procedure yourself.
Data is growing in importance across every industry. As a consequence, the ability to use a database is more important today than ever before. Over half of the jobs on Indeed that contain the word “data” (e.g. data analyst, data scientist) mention SQL in the job description. This is three times more often than Python, R, or any other programming language. If you want to work with data, SQL is the single biggest requirement.
However, it’s not just an expected skill for data scientists. If you are a decision maker at your company or aspire to be one, people will increasingly expect you to ground your ideas in data. If you really want to “know your numbers,” being able to query a database is a critical skill. Modern companies rely on their database as the system of record—i.e. the final say on facts about the company’s operations. Databases are specifically designed to track thousands of complex data points, such as recording every transaction down to the level of product, customer, and time of day. If you just read reports, you are getting someone else’s summary of the facts as they stood when the report was written. Querying a database with SQL, you can directly see the facts as they stand right now.
Best practices in SQL are very stable over time, relative to other programming languages. The main principles for how databases are organized today—known as the “normal forms”—date back to papers written in the 1970s. The SQL language itself was standardized by 1986, and has not changed significantly since that time. Although new features are added to the standard every few years, the portion that most programmers will ever use has been the same for decades.
While it is true that there are numerous dialects of SQL, the differences between them are very minimal. Each dialect will have a slightly different way of expressing the same set of concepts. As an example, to request only five results in Postgres you would use LIMIT 5 while in Microsoft’s dialect of SQL you would use TOP 5. Unless you are a database administrator, most job postings do not even bother to differentiate between dialects of SQL.
By contrast, best practices in a language like Javascript are expected to be obsolete within 3-4 years. Programmers use the term "javascript fatigue" to refer to the exhaustion that comes with trying to stay on the cutting edge in this language. Although there are rewards for learning hot new technologies, you would do better by learning SQL if you are looking for an evergreen skill that can benefit you for the rest of your career.
If you want to take the leap and learn SQL, sign up for our SQL Bootcamp class. The class will cover everything from basic database terminology to advanced querying techniques so you are confident using SQL in your workplace or on your resume.
If you’re interested in diving deeper with data, this course is featured as part of the Data Science Certificate. The certificate includes an in-depth Python Bootcamp for data science so that you can grow your data skillset and do more advanced analysis.
The first installment is due one week before the first class. Subsequent installments are spread out evenly across the duration of the course.
Installments | |
---|---|
10% non-refundable deposit | |
$975.00 | Total You Pay |
See the Installment plan FAQ for more information.
School Director, Instructor, & Senior Course Developer
Dan Rodney has been a designer and web developer for over 20 years. He creates coursework for Noble Desktop and teaches classes. In his spare time Dan also writes scripts for InDesign (Make Book Jacket, Proper Fraction Pro, and more). Dan teaches just about anything web, video, or print related: HTML, CSS, JavaScript, Figma, Adobe XD, Sketch, After Effects, Premiere Pro, Photoshop, Illustrator, InDesign, and more. You can find Dan on Twitter, LinkedIn, Facebook, and at danrodney.com.