SQL Courses New York City
Hands-on SQL training classes in Manhattan, NYC
SQL has become the standard for relational database management, and the premier tool for storing and analyzing data. SQL is used to extract data from a large set of related tables, helping user make informed decisions based on data analytics. Career Centers offers the leading SQL courses, beginner to advanced, for the most effective SQL training experience in New York City.
Our SQL classes will cover: select queries, writing inner and outer joins, creating views, subqueries, user functions and stored procedures, importing and exporting. You'll get personalized attention in small class sizes and our comfortable Midtown Manhattan training facility. The classes are taught with proprietary training methods and step-by-step instruction to build comprehension.
Beginner to advanced SQL Courses
Starting with our beginner SQL course, you will use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database. In our intermediate SQL class, we will create advanced SQL queries, and manipulate and index tables. Our advanced SQL training will show how to write decision making code, using advanced functions for manipulating text.
Small Group SQL Classes & Corporate SQL Training
Our SQL classes are taught by a live instructor in NYC in small groups. We also offer private SQL training with the ability to customize the course content.
SQL Bootcamp NYC
If you are looking for comprehensive SQL training, our SQL bootcamp includes the beginner, intermediate and advanced SQL classes at a 15% discount. Buy the complete bootcamp package for only $915 ($160 discount).
Upcoming SQL Classes in New York City
Code | Course Name | Hours | Price | Location |
---|---|---|---|---|
SC | Beginner SQL | 8 | $325 | 185 Madison Ave, NYC |
SD | Intermediate SQL | 8 | $325 | 185 Madison Ave, NYC |
SE | Advanced SQL | 8 | $425 | 185 Madison Ave, NYC |
SQB | SQL Bootcamp | 24 | $915 | 185 Madison Ave, NYC |
SF | Database Cleansing | 8 | $425 | 185 Madison Ave, NYC |
ED | Create/Analyze Database in Excel | 8 | $675 | 185 Madison Ave, NYC |
RD | Relational Database Fundamentals | 8 | $425 | 185 Madison Ave, NYC |
- Simple Queries
- Conditional Criteria
- Organize Data
- Join Tables
- Aggregate Functions
- CASE WHEN THEN
- Format Numbers
- Text Functions
- Stored Procedures
- Create Temp Tables
- Identify Bad Practices
- Analyze Data Integrity
- Correct Poor Data Using Formulas
- Structure Tables For Import
- Analyze Data Integrity
- Identify the Components of a Database
- Organize Data in Tables
- Understand Relationships
- Link Multiple Tables to Extract Data
- Query a Database
- Understand a Basic SQL Statement
- Subqueries
- Insert, Update, Delete
- Create Tables
- Create Views
- Create Indexes
- Beginner SQL
- Intermediate SQL
- Advanced SQL
- Working with Databases
- Using AutoFilter
- Working with Advanced Filters
- Lookup Formulas
- Exporting and Importing Data
- Creating/Revising PivotTable
SQL Fundamentals & Content Overview
What is SQL?
SQL stands for Structured Query Language and is programming language used to manage data held in a relational database management system.
What is Microsoft SQL Server?
Microsoft’s database management application, comparable to many other database management tools made by many other software developers.
Relational Databases
Relational databases break up huge data sets into component elements called tables. Tables are designed to only hold elements pertaining to one specific topic.
For example, consider a scenario where customers are buying products. Storing the data in in a large single table would lead to redundant data (same customer with multiple order, same product sold multiple time, etc.). Instead, we break up the large table into its component parts (i.e. one table for customers, one table for products, one table for transactions, etc.). This reduces redundant data, facilitates data entry, allows for easy searching within the databases, and ability to summarize data. The tables contain certain fields that are common to other tables, thereby allowing them to be queried, or searched from, as if it were all in one table.
What can SQL be used for?
SQL is useful for database management, including storing databases, building databases, managing databases, analyzing databases, and communicating with other data management tools and reporting tools.
SQL Topics & Terms
- Query: Extracting data and analyzing it (like a search request from the database)
- Data normalization: Structuring tables to prevent duplication of data
- Data integrity: Preventing records from being scrambled or matching up with incorrect items
- Client server architecture: Server-side processing to facilitate rapid distribution of data
- Aggregations: Summarizations via common functions
- Set Theory: Branch of mathematics upon which SQL is based
- One to many relationships: Connecting tables so one record can access many records in another table
- Primary keys: Unique record identifier
- Foreign keys: Fields in tables that connect to primary keys in other tables and enforce data integrity rules
- Indexes: Sort orders & constraints that are placed on fields to enhance speed and prevent data duplication
- Efficiencies and Execution Plans: writing code in a manner to promote speed and accuracy
- Views: Programmatically stored queries made available to other users and to enable layered queries
- Stored Procedures: Queries that can create automation for repetitive tasks and complex processes
- Transactions: Creating undo levels for various processes
What You'll Learn in Our SQL Classes
Beginner SQL Class
Review the basics of coding to extract data from an existent database and basic theory behind database technology.
Intermediate SQL Class
Continue the extraction concepts into more complex scenarios. Introducing code that will also manage the structure of the database and concepts on security.
Advanced SQL Class
Build databases and the tables and other structures required for the management of databases: exporting, importing, editing and deleting data. Build automation to archive data and facilitate flow of data through the database.