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.

In this class you'll learn how to code HTML and CSS, the coding languages used to create webpages. We focus on best practices for structuring the content of your webpages with HTML and then styling the content with CSS.
Once you have the basics under your belt, you'll move on to real-world page layout. You'll learn text and link styles, centered page layout, background images, CSS-based navigation, forms, uploading files via FTP, and much more. We will provide you with the content and prepared images for use in these projects but this training will give you hands-on practice coding websites from scratch all the way through uploading them to make them live.

This SQL Bootcamp package includes our Beginner, Intermediate, and Advanced SQL classes at a 15% discount. In this bootcamp, you will use SQL as a tool to implement logic, define instructions and compose queries. You will create advanced queries and manipulate and index tables, and learn techniques for writing decision-making code using advanced functions.

Learn to automate daily work in Excel using VBA (Visual Basic for Applications), the programming language of Excel. In our instructor-led VBA courses in NYC, we'll review how to develop a macro, use loops and conditions, and create VBA scripts.
The VBA classes are taught by a live instructor with hands-on exercises based on real-world applications of VBA.

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.

Learn to create basic shapes and custom shapes with the pen tool, customize objects, and create graphics containing customized paths and text. In our advanced Illustrator class, we will review drawing complex illustrations, enhancing artwork using painting tools, and customizing colors and swatches.

Beginners, start with our Beginner Excel Course, where you'll review calculations, charts, formulas, and tables. In our Intermediate Excel Class, we'll dive into multi-input functions, Pivot Tables, and Sort & Filter. For advanced training, our Advanced Excel Class will show you how to automate workbook functionality, use advanced lookup functions, and forecast data using What-If Analysis. Microsoft Excel VBA & Macros will show you how to automate your daily work.
Excel Bootcamp
Sign up today for three levels of Excel at a 15% discount with our Microsoft Excel Bootcamp package: Basic, intermediate, advanced. Check out with "by request" for $535, a 15% discount, and then email us to schedule your dates. You can choose any combination of dates that work with your schedule, and if you're not sure yet, no problem. You'll have two years to complete the courses.

Use SQL as a tool to implement logic, define instructions, and compose SQL queries to retrieve information from the database.

NYC Career Centers