185 Madison Ave. at 34th St., Suite 1104, New York, NY 10016 • 212-684-5151

SQL Training Classes & Courses NYC

If you are interested in learning SQL, the Career Center offers SQL classes and courses for every skill level. SQL is a powerful and popular database program that is widely used for data analysis and manipulation. The Career Center provides hands-on Instructor-led training in small class sizes to provide an ideal training experience. When you arrive at The Career Center you are given a Course Manual, that is yours to keep, and then shown to your seat with a computer that is fully equipped with SQL. The instructor's computer is attached to an overhead projector so you can easily follow their instructions. The class is taught in a very hands-on way, with the instructor teaching a concept and then the class doing exercises to enforce it. The maximum class size is 10 so you don't have to worry about getting lost in the crowd! Choose one of 3 levels of SQL training, which are conveniently located in NYC area.

SQL Level 1
  • Simple Queries
  • Conditional Criteria
  • Organize Data
  • Join Tables
  • Aggregate Functions
SQL Level 1 course will help you to use - SQL: Structured Query Language as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database.

$325.00

SQL Level 3
  • CASE WHEN THEN
  • Format Numbers
  • Text Functions
  • Stored Procedures
  • Create Temp Tables
In this continuation you will learn techniques for writing decision making code, using advanced functions for manipulating text, using data conversion functions and formatting output to make data more comprehensible. You will also explore temporary tables, parameterized queries and creating Stored Procedures to automate work flow.

$425.00

Creating & Analyzing Database
  • Working with Databases
  • Using AutoFilter
  • Working with Advanced Filters
  • Lookup Formulas
  • Exporting and Importing Data
  • Creating/Revising PivotTable
This 1-day course provides students with the knowledge and skills, to use advanced Excel features, in creating and analyzing databases. Students will learn how to sort and manage data; filter and query data; and apply lookup and database functions. Students will learn to analyze and evaluate, the information, in databases, by creating pivot table and pivot charts.

$345.00

SQL Level 2
  • Subqueries
  • Insert, Update, Delete
  • Create Tables
  • Create Views
  • Create Indexes
SQL Level 2 you will create advanced SQL queries, and manipulate and index tables. Course Objective: You will work with advanced queries and manipulate tables. You will also view and index table data.

$325.00

Database Cleansing
  • Identify Bad Practices
  • Analyze Data Integrity
  • Correct Poor Data Using Formulas
  • Structure Tables For Import
  • Analyze Data Integrity
Students will explore various issues that cause databases to be unreliable and identify tools that can be used to correct the underlying problems.

$425.00

Relational Database Fundamentals
  • 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
This course is designed for students who not only need to learn the basics of the SQL language but to also understand how true databases function and understand the benefits of using these specialized tools. It is also recommended for students who need to learn MS Excel Power Pivots which is also based on relational concepts. It also provides the fundamental knowledge and techniques needed to advance to more complex data analysis scenarios.

$425.00

Code Course Name Hours Price
SC SQL: Level 1 8 $325
SD SQL: Level 2 8 $325
SE SQL: Level 3 8 $425
SF Database Cleansing 8 $425
ED Create/Analyze Database in Excel 8 $345
RD Relational Database Fundamentals 8 $425

Buy Any 3 Classes Get 10% Off
Info@CareerCenters.com
(212) 684-5151