With the demand for database professionals on the rise, there is no better time to begin learning or growing your expertise in SQL. The language is one of the most efficient tools for sorting and accessing information living within databases, making it easy to sift through multiple tables and sets to find data buried deep within. Boosting SQL skills is an exceptional way to become more efficient in a current career or even transition into an entirely new line of work in data analysis. These 13 SQL classes in NYC are the best bet for taking that first step.
Top SQL Classes in NYC
- General Assembly
- Practical Programming
- NYC Career Centers
- Certstaffix Training
- NetCom Learning
Beginner Courses
About the School: What began as a co-working space in 2011 has quickly become one of the largest technical learning centers in the world. General Assembly features award-winning curriculum, industry-seasoned instructors and an interactive learning environment with a goal to connect job-seekers and talent-seekers.
Course Name: SQL Bootcamp: Learning the Language
Course Description: Designed to leave absolute beginners with a functional understanding of SQL, this course will leave students with an understanding of SQL vocabulary like tables, schema, functions and JOINS, the differences between SQL databases, the first steps to creating their own SQL queries and other skills that can be immediately applied to their work.
- Average Class Size: 20
- Number of Sessions: 1
- Cost: $349
Course Name: SQL Training for Beginners
Course Description: SQL Training for Beginners is a three hour class that takes students’ understandings of SQL beyond the buzzword. This hands-on workshop teaches students how to work with data stored in a relational database and aims to leave attendees with the ability to find data to answer business questions using basic SQL commands.
- Average Class Size: 20
- Number of Sessions: 1
- Cost: $99
Course Name: SQL Bootcamp Series
Course Description: An in-depth course taking beginners through several SQL concepts, the SQL Bootcamp Series first focuses on the basics. The class covers SQL vocabulary, differences in databases and creating basic queries before diving into advanced SQL commands and conditional operators, string, date and math functions and complex JOINs.
- Average Class Size: 20
- Number of Sessions: 2
- Cost: $479
About the School: Featuring a highly skilled team of instructors knowledgeable in both programming and data analysis, Practical Programming prides itself on delivering thorough instruction to students looking to break into the tech field. The school primarily serves students in New York, with pop-up tech events also hosted nationwide.
Course Name: Introduction to SQL and Data Analysis
Course Description: A highly interactive and engaging option for learning SQL fundamentals, Practical Programming’s Introduction to SQL and Data Analysis focuses on writing effective SQL queries that can be used in daily work and understanding the core concepts of databases. The class begins with basic examples and moves up to complex queries, giving attendees the ability to write problem-solving SQL and produce reports.
- Average Class Size: 15
- Number of Sessions: 1
- Cost: $399
About the School: Borough of Manhattan Community College falls under the CUNY umbrella, with a large selection of industry-focused courses available for adults looking to continue their development. BMCC's goal is to place students on a path to fulfilling careers, not just good jobs.
Course Name: Introduction to SQL for Data Analytics
Course Description: Designed to jumpstart a career working with SQL and databases, BMCC’s Introduction to SQL for Data Analytics class teaches attendees how to query a rational database for information and analysis. The goal is for students to be able to show employers that they have a fundamental understanding of relational databases, including the Microsoft SQL server.
- Average Class Size: 20
- Number of Sessions: 5
- Cost: $714
About the School: NYC Career Centers have been providing professionals with results-oriented business courses that advance careers for over 30 years. Courses are available for all levels of expertise in areas including data analytics, programming, financial modeling, design, Microsoft Excel and Microsoft Office.
Course Name: Beginner SQL
Course Description: The Beginner SQL course at NYC Career Centers teaches students how to use SQL as a tool to implement logic, define instructions and compose SQL queries to pull information from databases. The course includes a step-by-step training manual customized by a top SQL instructor and students can expect to be able to execute simple queries, use search conditions, utilize various functions, organize obtained data and combine multiple tables.
- Average Class Size: 8
- Number of Sessions: 1-2
- Cost: $325
About the School: Certstaffix Training works directly with businesses and schools to embed valuable, career-advancing information into the hands of individuals looking to take a step forward. Courses are taught virtually by expert instructors and include headsets to promote communication and interaction between classmates.
Course Name: SQL Querying: Basic
Course Description: Taught using the Microsoft SQL server, the class teaches students how to compose beginner-level SQL queries to retrieve desired information from a database. The course explores database concepts and students will learn to write simple SELECT queries, use built-in functions and expressions, join tables and build subqueries and unions, all taught remotely.
- Average Class Size: 3
- Number of Sessions: 2
- Cost: $990
About the School: Baruch College’s CAPS program brings career development opportunities to New Yorkers from a variety of industries. A lengthy list of IT and data analysis courses are available to choose from, along with classes in accounting, management, finance, HR, project management, marketing, sales and more.
Course Name: Databases and SQL Queries with Oracle
Course Description: In this course, students learn how to utilize Oracle’s database software, the industry-leading method of working with SQL. Database diagramming, design and creation, entity relationship modeling, data warehousing, reporting and many more concepts are covered, introducing students to mainstay concepts in data management.
- Average Class Size: 10
- Number of Sessions: 8
- Cost: $675
Intermediate Courses
Course name: Intermediate SQL Bootcamp
Course description: General Assembly’s Intermediate SQL Bootcamp is designed to let analysts broaden their SQL skills and be able to pull and manipulate data from multiple sources quickly and cohesively. The class covers a variety of topics including JOIN and UNION with aliasing, primary and foreign keys, aggregation and functions, complex JOINs with multiple tables, NULL values, GROUP BY, HAVING, CASE and SUBSELECT.
- Average Class Size: 20
- Number of Sessions: 1
- Cost: $200
Course Name: Intermediate SQL
Course Description: NYC Career Center’s Intermediate SQL course features a small class size and a hands-on approach. Students will learn how to code subqueries to generate query output, create and manipulate views, create logic statements and use date functions, text parsing, concatenation and formatting functions by the end of the course.
- Average Class Size: 7
- Number of Sessions: 2
- Cost: $325
Advanced Courses
About the School: NetCom Learning seeks to empower the modern workforce by bridging the gap between tech and business skills. For individuals or teams looking to take a step forward, NetCom Learning offers courses in data & AI, security, networking, working within the cloud, design, people and more.
Course Name: Administering a SQL Database Infrastructure
Course Description: Intended for students who currently administer and maintain SQL databases, Administering a SQL Database Infrastructure gives students the knowledge to confidently administer SQL’s infrastructure. Attendees will learn how to authenticate users, assign roles, protect and encrypt data, backup and restore SQL server databases, configure security, troubleshoot a SQL and more. Developing applications that deliver content from SQL server databases will also be covered.
- Average Class Size: 6
- Number of Sessions: 5
- Cost: $2,995
Course Name: Advanced SQL
Course Description: Advanced SQL at NYC Career Centers builds upon the concepts covered in its Beginner and Intermediate SQL courses, featuring an interactive workspace with a small class size. Topics covered include creating databases and tables, importing and coding techniques to insert, update and delete data, exporting data to other applications, creating constraints, indexes and referential integrity, creating database diagrams, using stored procedures and triggers and protecting live data with temporary tables.
- Average Class Size: 7
- Number of Sessions: 1
- Cost: $425
Course Name: SQL Querying: Advanced
Course Description: Picking up on where the Basic level course leaves off, Certstaffix Training’s SQL Querying: Advanced course teaches attendees how to compose advanced SQL queries to retrieve information from a database. Building on derived tables, joining multiple tables, exploring advanced WHERE clauses and writing advanced SQL is all covered and classes are held remotely with free retakes for six months.
- Average Class Size: 3
- Number of Sessions: 1
- Cost: $495
