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. 

Explore, modify, and export data from databases in MySQL. 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.

Dive further into Tableau tools and customization of your visualizations. You will learn to create a variety of maps to represent your geographic data and build actions to control your visualizations within your sheets and dashboards.

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 VBA, Excel's programming language, in project-based training. This VBA course concentrates on the automation of repetitious Excel tasks and reports.

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.

Get started with Python programming: data types, conditional statements, loops, functions, and object-oriented programming. Learn how Python is used for web development, data science, and more. 

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.