Data Science Courses NYC

All Locations NYC Los Angeles Chicago Online Boston Nashville Houston Washington, D.C. San Diego San Francisco Seattle Atlanta Denver San Jose Charlotte New Jersey Brooklyn

Advanced Python: Best Practices and Design Patterns

Learning Tree International @ 1601 Broadway, New York, NY

Expand upon your fundamental Python programming skills to build reliable and stable applications. In this training course, you learn to implement Gang of Four (GoF) design patterns in order to solve commonly recurring, real-world software design programs, thereby avoiding pitfalls and greatly improving the effectiveness of your programming efforts. You Will Learn How To: Employ design patterns and best practices in Python applications Unit test,...

Introduction to SQL and Data Analytics

Practical Programming @ 185 Madison Ave, New York, NY

This workshop will teach you the core concepts of databases as well as how to write effective SQL queries you can use in your everyday work. We will spend a quarter of the workshop reviewing database theory and the majority of the time going through examples. Also, this workshop will teach you advanced concepts of databases as well as how to write effective SQL queries you can use in your everyday work. Going over the major topics a data scientist...

XZSQL Data Analytics: Intermediate Level

Extensive Business Solutions Corp. @ 845 3rd Ave, New York, NY

DURATION: 8 + 1 HOURS ONSITE TRAINING  (5 Sessions: 2 Hrs + 2Hrs + 2Hrs + 2Hrs + 1Hrs) Method: 1 on 1 Schedule is tentative; finalized after enrollment according to student/instructor availability. TOPICS COVERED Introduction to need for SQL and Design Aspects Why do we need SQL? What is wrong with excel? Different distribution packages available from Oracle, microsoft, ibm For example: if we create the information of people attending the...

Big Data Hadoop NYC Training: Beginner Class

Extensive Business Solutions Corp. @ 845 3rd Ave, New York, NY

Duration: 5 Hours Onsite (3 Sessions) Schedule: Flexible (call to confirm desired or available schedule) Method: 1 on 1 (onsite) Subscription: 1 months of online support after completion How Can This Big Data Hadoop Training Intro Help You? This Intro to Big Data Hadoop NYC class will introduce you to Big Data using Hadoop. A wide range of business and organizations use Big Data to uncover hidden patterns and unknown correlations to help them figure...

Programming for Non-Programmers - Intensive Workshop

General Assembly @ 902 Broadway, New York, NY

Learn the fundamentals of front-end and back-end programming, plus try your hand at writing some code of your own. Are you a creative or entrepreneur that wishes you could speak tech with your web development team? Maybe you wish you could code a bit yourself? Programming for Non-Programmers is workshop series designed to help non-programmers communicate more efficiently with developers. Because leading a development team (without being a developer...

Tableau for SQL & Excel Users

Borough of Manhattan Community College @ 25 Broadway, 8th Floor, New York, NY

Over the next 10 years the Department of Labor has projected a job increase for individuals who possess the right skills to store and query large data sets. This course is will leverage best practices to understand Data, create robust spreadsheet models using excel, a general survey of SQL to input, extract and manipulate data stored in a database, and enhance data models and insights with Tableau visualizations. Excel is a standard across many industries...

SQL Server 2014 Reporting Services

Hands On Technology Transfer, Inc. @ (Exact location to be announced), New York, NY

All HOTT courses are available face-to-face, remote-live, on-demand or on-site at your facility.  This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic...

Advanced Programming with Python for Database

New York City College of Technology @ 25 Chapel St, Brooklyn, NY

This course is a follow up to the Intro To Programming With Python course. In this course you will explore concepts of persistent storage. CRUD (Create, Read, Update, Delete) operations are essential to creating applications. Using Python and MySQL you will learn how to create and manage databases and automate data processing. Topics Advanced File Input and Output Apache Web Server Application Flowchart MySQL Databases and Tables CRUD Operations...

Intermediate SQL Bootcamp

General Assembly @ 10 E 21st St, New York, NY

Due to the current health concerns, all GA short-form events, workshops & bootcamps will temporarily be held online - including this one. Registered students will be notified 24 hours in advance of this program with information on how to log in to the Zoom Meeting Room and other tools you’ll need for the session. Registration for this class will close 2 hours prior to the session start in order to allow all students ample opportunity...

Database Cleansing in SQL - Excel

NYC Career Centers @ 185 Madison Ave, New York, NY

Analyzing Data with Excel

LaGuardia Community College @ 3110 Thomson Ave, Long Island City, NY

Analyze and summarize large sets of data without complex formulas using Microsoft Excel. Discover how to use simple tools and commands to organize data into a layout that is easy to understand. ND Prerequisite: Microsoft Excel for Windows or equivalent experience.

A Practical Introduction to SQL

General Assembly @ 902 Broadway, New York, NY

This workshop will take absolute beginners through the basics of SQL to an ability to write queries with confidence. SQL provides powerful but reasonably simple tools and concepts for analysis and processing of data. We’ll cover the use of queries to combine data from a variety of tables, as well as for analysis and workflow tasks. Takeaways Session I: Basics of database setup and single table queries Basics of setting up a database, loading...

Advanced SQL

Practical Programming @ 185 Madison Ave, New York, NY

This hands-on workshop will build on your SQL knowledge and give you the valuable skills and confidence needed to take your data exploration and analysis ability to the next level.  Students will begin by working on building fluency with complex queries and move on to a variety of data engineering techniques including manipulating data, creating and modifying tables, and creating views and indexes. The session will be highly interactive. We...

Apache Spark Training NYC - PySpark

Extensive Business Solutions Corp. @ 845 3rd Ave, New York, NY

9 Hours Total: 3 Hours of onsite training 3 Hours of live, online training 6 30-minute tech support sessions for personal projects Learn about becoming a big data engineer. Learn about Apache Spark, PySpark, and big data! Our classes and courses are held in our office in Midtown Manhattan. Learn Apache Spark NYC! Learn Apache Spark using Python (PySpark) with this big data training in NYC. Learn how big data and what you need to know to become...

FileMaker Pro

NYIM Training @ 185 Madison Ave, New York, NY

Implementing a Data Warehouse with Microsoft SQL

Corporate Training Group @ 330 West 38th St, New York, NY

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. Note: This course is designed for customers who are interested in learning SQL Server 2012 or SQL Server 2014. It covers...

SQL Data Analytics: Intermediate Level

Extensive Business Solutions Corp. @ 845 3rd Ave, New York, NY

DURATION: 8 + 1 HOURS ONSITE TRAINING  (5 Sessions: 2 Hrs + 2Hrs + 2Hrs + 2Hrs + 1Hrs) Method: 1 on 1 Schedule is tentative; finalized after enrollment according to student/instructor availability. TOPICS COVERED Introduction to need for SQL and Design Aspects Why do we need SQL? What is wrong with excel? Different distribution packages available from Oracle, microsoft, ibm For example: if we create the information of people attending the...

Introduction to Data Visualization

General Assembly @ 902 Broadway, New York, NY

The Data Visualization workshop provides an overview of how data visualization can be used to improve business insights and decision-making around large sets of data. It also covers the various types of visualizations that can be used to most effectively tell your business story. In the digital age, the ability to explore the visual representation of massive data and detect meaningful patterns and trends is becoming increasingly critical for businesses....

SQL Querying - Level 1 Fundamentals of Querying

New Horizons Computer Learning @ 462 Seventh Ave, New York, NY

In this course, students will compose SQL queries to retrieve desired information from a database. ​Who Should Attend Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Prerequisite(s) or equivalent knowledge Access 2003 - Level 1 Relational Database Design A Practical Approach Outline Lesson 1: Executing a Simple Query Connect...