Learn SQL fundamentals including data types and queries
Dec 15–Jan 3
Mondays & Wednesdays, 6–9pm
Choose another date
NYC or Live Online
We are open! Classes are running in-person (socially distanced) and live online. Secure your seat today
Upwards of 90% of time on data wrangling is spent cleaning and manipulating data. 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.
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.
Matt’s material was thorough and he took the time to make sure everyone was fully grasping the material
Awesome class! The instructor is very patient and helping you debug all kinds of problems and answering all kinds of questions.
These weren’t the days. It had gotten rescheduled a couple of times. I’ve taken only one session and I loved it. I instructor was very knowledgeable and he was good at teaching. I’m looking forward to the next two classes.
The class was very hands on and useful in real life scenarios. Gave the basic tool to implement SQL on your personal computer and the basics to use it in a work scenario. Tommy was great at keeping the class engaged and also made the class fun.
Terrific course with really useful information! Alex's explanations were clear and well-organized. Good mix of instruction and practice. I hope Alex designs a Part II to this course!
I had zero experience with SQL and Alex did an exceptional job at making sure I was understanding every single step!
I thought this was an excellent introduction to SQL. Alex's explanation of the concepts and the examples he used were easy to follow and made sense. It was two short classes, but I feel like I came away with a solid understanding of how SQL works. I recommend the class and Alex as a teacher.
The instructor did a good job of being attentive to the needs of the class and didn't move at too fast a pace. He knew the material well and was able to break down some of the more difficult concepts.
Alex was absolutely amazing. He did a great job explaining the concepts and having us do exercises along the way to get our "hands dirty". Would highly recommend this class to anyone who wants to get familiar with SQL and databases.
Helpful class for basics. Instructor knew the material and explained it clearly
Very easy to follow, focusing on practical application of SQL.
Instructor (Alex) was great, he was well prepared for both sessions. He covered all the fundamental concepts, provided good samples to exercise, followed up after the class, took his time to address all the questions during the class.
In the limited amount of time we had, our trainer Alex did an amazing job covering all the bases of basic SQL. He was very good at pointing out red herrings, common mistakes, use cases and examples. I would recommend this class to anyone who wants to understand what SQL is and how it is used. Amazing value for the price.
Alex was an enthusiastic and knowledgeable instructor. He made time to go through examples thoroughly and connect with students in the class. I learned a lot and would definitely recommend his course.
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!
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
I didn't expect to learn much in a 4 session Python course, but Art's teaching style was very fitting for me. As the Chinese proverb states: Tell me, I'll forget. Show me, I'll remember. Involve me, I'll understand.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
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.
Discounts are applied at checkout (no promo code required) and will be verified after you place your order. Discounts are subject to change. Read our discount policies for more details.
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.
Out 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 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.
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.
Students are not required to complete any work outside of class. However, we provide students with bonus materials if they would like extra practice.
Students will learn how to explore, 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.
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).
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 Python and boost your career with data science. You’ll learn the world’s most popular programming language through real-world dataset analysis. Manipulate data, learn how to make predictions, and gain the foundational skills you need to use Python on the job or start your data science career.
Learn to code in this beginner hands-on Python programming course. This course is designed to give you a comprehensive understanding of Python programming fundamentals and get you coding on your own. You'll learn how to professionally structure your programs and solve real-world challenges using Object-Oriented Programming. You'll also work on your own coding projects for your portfolio, and learn the common questions asked in a Python job interview.
Purchase group class vouchers at a discount for our regularly-scheduled group classes in NYC, or create a custom training program at your offices.
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 as competent in SQL as a professional software developer. You won’t be at the level of a database administrator or other SQL expert, but you’ll be able to write SQL as well as the average programmer.
In part, this is because SQL targets a narrow domain. SQL is focused on one task -- controlling a database -- while 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 most 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 ‘70s. 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.
If you want to take the leap and learn SQL, sign up for our 18-hour SQL Bootcamp class. The class will cover everything from basic database terminology to advanced querying techniques so that 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.