SQL Training NYC Classes
Interested in learning SQL? The Career Center offers SQL classes 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.
- Simple Queries
- Conditional Criteria
- Organize Data
- Join Tables
- Aggregate Functions
Use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database.
- CASE WHEN THEN
- Format Numbers
- Text Functions
- Stored Procedures
- Create Temp Tables
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.
Creating & Analyzing Database
- Working with Databases
- Using AutoFilter
- Working with Advanced Filters
- Lookup Formulas
- Exporting and Importing Data
- Creating/Revising PivotTable
Provides students with the knowledge and skills, to use advanced Excel features, in creating and analyzing databases. Learn how to sort and manage data; filter and query data; and apply lookup and database functions. Learn to analyze and evaluate the information in the databases by creating pivot table and pivot charts.
- Insert, Update, Delete
- Create Tables
- Create Views
- Create Indexes
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.
- Identify Bad Practices
- Analyze Data Integrity
- Correct Poor Data Using Formulas
- Structure Tables For Import
- Analyze Data Integrity
Explore various issues that cause databases to be unreliable and identify tools that can be used to correct the underlying problems.
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
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.