The best SQL classes, bootcamps, and certifications near me

This comprehensive bootcamp starts with the basics of SQL and databases and takes you through the powerful advanced skills that will make you an essential part of any data team. You’ll start by using SQL to explore information stored in a database using the graphical interface of dBeaver, a popular free database app. You’ll learn to write SQL queries, combine data from multiple tables, and manipulate data to extract the information you need. You’ll gain experience with advanced functions like subqueries, string functions, and if-else logic with case, and you’ll learn to work with views and functions. 

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, or MySQL, with minor syntax differences. There will be a mix of lectures to explain the concepts, coding demonstrations that show you how to write SQL, and time for you to write SQL queries based on challenge questions.

This is an ideal course for leaders who want to make better data-driven decisions or analysts who want to advance their skills beyond Excel and Tableau. Developers who need to work with databases will also find this course valuable.

The free SQL Server Management Studio app (SSMS) is a Microsoft database app that provides a graphical interface for SQL. It allows you to explore information stored in a database and write SQL queries to retrieve the data, combine information from multiple tables, and extract the information you need. You’ll also explore advanced techniques like subqueries, string functions, and if-else logic with case. You’ll be able to use views and functions as a simpler alternative to directly querying tables. In this training, you’ll learn Microsoft SQL Server, but the core concepts can be applied to other forms of SQL, such as PostgreSQL, Microsoft Access, or MySQL, with minor syntax differences. You don’t need any prior experience with programming to take this course.

You’ll master SQL and so much more in this comprehensive data science certificate program. This is a great way to start your career as a data scientist or Python engineer, some of today’s best-ranking jobs. The course starts with a 30-hour intensive study of Python for data science. You’ll learn to handle different types of data, control the flow of your programs, and use object-oriented programming to simplify your code. You’ll also learn to use the powerful Python library, which includes Numpy, Pandas, Matplotlib, and Scikit-learn.

Armed with these powerful skills, you’ll take a deep dive into SQL, where you’ll learn to use the free graphical interface of DBeaver to explore the information stored in the database. Master retrieving the data you need, combining information from different tables, and extracting the specific answers you need. You’ll gain experience with advanced SQL techniques as well. Then, you’ll return to Python for an in-depth study of automation, data visualization, and machine learning. This certificate is for you if you’re looking to break into senior data science roles or you’re an analyst who wants to add Python and SQL to your toolkit. This is also ideal for developers who want to learn data science and Python. You’ll complete real-world projects to add to your portfolio, and you’ll get valuable help with your job search and resume, along with one-on-one mentoring with an experienced Data Scientist.

This introductory bootcamp covers the tools and programming languages essential to data analysts, including Excel, SQL, and Tableau. Plus, you’ll get hands-on experience working on real-world projects. The program consists of eight six-hour segments which cover the essential skills you’ll need to progress. Once you’ve mastered the fundamentals of Excel, such as using functions, formatting, visual charts, and workbook management, you’ll explore more advanced topics, like Pivot Tables, advanced functions, and special formatting. 

Then, you’ll dive into SQL using the graphical interface of SQL Server Management Studio, Microsoft’s free database app. You’ll use SQL’s plain English language to explore and manipulate the information in your database and glean valuable data-informed answers. Tableau is a data visualization tool that creates interactive dashboards like charts and graphs. You’ll learn to structure your data to present visualizations in Tableau and create dashboards and stories. Industries increasingly rely on data to drive decisions, and the skills you learn in this bootcamp will position you to aid in decision-making at any organization.

This program is designed to help students develop the skills needed to succeed in a data-driven profession. Throughout the bootcamp, there’s a dive deep into the tools and technologies that Data Analysts rely on, including Excel techniques and advanced data querying with SQL. The curriculum starts with learning how to handle large datasets and using Excel to build, manipulate, and visualize data. As it progresses, you’ll explore SQL in detail, grasping how to clean and analyze data using tools like SQL Server and PostgreSQL. In addition to SQL and Excel, the program includes an in-depth look at Tableau to create interactive dashboards. The bootcamp prepares students for certification exams in Tableau and Amazon Web Services (AWS), a credential that will set you apart in the job market.

This bootcamp is an intensive 12-week program designed to help participants master the analytical skills required to start a career in the field of data science. The program begins with a strong foundation in Python, where students learn how to manipulate data using libraries like Pandas, NumPy, and Matplotlib. They will also dive into SQL and write complex queries to extract and organize data across databases. As the course progresses, lessons cover the fundamentals of machine learning, including supervised and unsupervised learning models. Students will also work through case studies and build projects across industries like finance, public policy, and ecommerce to apply these techniques in real-world scenarios.

If you’re ready to launch a new career as a Data Analyst or Business Analyst, this comprehensive 156-hour program is a great place to start. You’ll learn to manipulate and analyze data, extract the information you need, interpret the results in a meaningful way, and visualize data so others can understand it. This comprehensive certificate program covers Excel, Python, SQL, and Tableau, all essential tools for data scientists. You’ll learn the fundamentals of data analytics and statistics and how they are used in businesses, and you’ll explore the hot new fields of automation and machine learning. 

Data analytics is about using data to solve problems, such as reducing risk, improving operations, or detecting fraud. In this course, you’ll work on real-world projects that prepare you for a professional career in fields like healthcare, finance, retail, gaming, and more. Plus, you’ll receive eight one-on-one mentoring sessions with a data analytics expert where you can ensure you’re on track with your learning goals, get help with challenging topics, review your portfolio, polish your resume and LinkedIn profile, and get advice for your job search. You can retake any part of this course, or even the entire program, at any time for up to a year.

SQL queries allow you to retrieve and manipulate data from databases so you can glean answers to important business questions. They make it possible to perform tasks like updating or retrieving data on a database. Learning SQL opens up career opportunities because it’s used by the most common relational database management systems, including Oracle, Sybase, Microsoft SQL Server, Access, and Ingres. In this introductory course, you’ll gain hands-on skills in executing simple queries and performing conditional searches. In addition, you’ll learn to work with functions, organize data, retrieve data from multiple tables, and export your query results.

If you just need to know how to get information from a database, this class gets right to the essentials. It will give you a great start on using SQL to inform your business decisions and perform basic analysis. This class uses Transact-SQL to query a relationship database. You’ll explore the basic concepts of how a relational database is structured and learn how data is retrieved. Then, you’ll gain an understanding of naming conventions and basic syntax, and you’ll use built-in functions for various operations. This course will take your data analytics skills beyond the basic spreadsheet.

ONLC Training Centers offers an Oracle Database: SQL Fundamentals course that covers the fundamentals of SQL, including basic syntax to intermediate query optimization. This program has over 33 hours of instruction over five sessions, typically held on consecutive days over the course of one week. Many of the skills in this course can be adapted to other database platforms, such as Microsoft SQL Server and IBM DB2, as well as MySQL and PostgreSQL. The curriculum intertwines data modeling theory, relational database theory, and graphical depictions of theoretical concepts into the lessons, making this comprehensive course geared towards all Oracle professionals, both business and systems professionals. This school offers this course, and several others in the series that are featured are included in the Oracle Database Certified SQL Expert certification exam.