This course covers the fundamentals of relational databases, Microsoft SQL Server, and the SQL database language. Begin writing SQL code, including SELECT statements. Learn to sort, filter, and format data and produce reports based on your queries.
Master views, subqueries, logic statements, and data conversions in this course. Combine advanced SQL functions with fundamentals like inner and outer joins to proof your work.
Gain the skills to begin a career in database management. Master advanced SQL processes and controls, and create stored procedures and temporary tables.
Explore, modify, and export data from databases in PostgreSQL. Learn foundation concepts like tables, data types, and queries, and advanced techniques like join statements, subqueries, and stored procedures.
In this course, you will be introduced to the field of data visualization and the various tools Tableau Public offers. Through concepts and exercises, you will learn to identify datasets to connect to, explore, analyze, filter and structure your data to create your desired visualizations.
Learn all the basics to use Excel as your primary data processing tool. Create charts and tables, get started with formulas and functions, and format and print your output.
Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow.
Become an Excel guru in this hands-on advanced training. You'll make functions more flexible, take Pivot Tables to the next level, automate tasks with macros, and learn advanced analytical tools.
Learn the fundamentals of Python and object-oriented programming in this 5-day intensive course. You'll gain a solid understanding of Python, with a strong emphasis on using libraries and frameworks for data science.
Take a step beyond normal programming, into using algorithms that can independently learn patterns and make decisions. Machine learning skills are in high demand, as these algorithms now run the majority of trading on Wall Street and the product recommendations at big companies like Amazon, Spotify, and Netflix.
Learn Python to extract data from websites. Along the way, you’ll learn how to write loops so that your web scraping code can process a large number of pages.
Learn to create a data file and enter data, conduct preliminary analyses, use graphs to describe and explore the data, manipulate the data, check the reliability of a scale, apply correlations, conduct significance tests, and perform regression analysis.
This course introduces how to present, analyze and interpret data using the statistical analysis software package SPSS. In virtually every field of work, being confident and competent in analyzing data and drawing conclusions is extremely helpful. You'll learn to develop those skills using SPSS.
This is an intermediate level course designed to introduce students to advance techniques used in data analysis and database management. Focus is placed on the use of scripts, the appropriate use of parametric and nonparametric tests, regression analysis and Decision Trees. The incorporation of these techniques will provide the tools necessary to perform sophisticated analysis and management of data.
The aim of this course is to provide an introduction to R, the environment for statistical computing and graphics. Statistical analysis will be performed through the graphic user interface called RCommander. The focus of the course will be on getting familiar with the R environment, to use R for manipulation and exploration of data, and to perform simple statistical analyses.
SQL Level 1 is a great course to introduce you to writing SQL queries. Starting with the basics, by the end you will understand complex queries with inner or outer joins. Peter was our instructor and his customized course material is very well laid out with practical examples. You work on a local sample database, so you can type notes and test your queries to better understand the output you get.
For over two decades, NYIM has delivered the highest-caliber corporate training programs in NYC. Our programs feature custom curriculum, comprehensive support materials and videos, pre-class assessments, and top instructors. With the most running Data Analytics group classes scheduled in Manhattan, your employees have abundant scheduling choices.
Call us for a free consultation and we’ll create a custom curriculum catered to your learning objectives and industry-specific requirements.
Learning does not end when the instructor goes home. Trainees receive handouts, detailed exercise files, and access to our premium training videos to help support and reinforce what they’ve learned throughout the training.
Study under industry experts with engaging teaching styles. All our courses are taught hands-on with practical exercises.
Train your team on your schedule — we’ll work around you. For voucher progams, our courses are scheduled frequently on weekdays, weeknights, and weekend so your employees can choose the time that works best.
We’ll discuss your training needs free of charge. Let us help you develop a customized corporate training program to achieve your company goals.