Joining Data in SQL
Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL.
Follow short videos led by expert instructors and then practice what you’ve learned with interactive exercises in your browser.
Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL.
Use the world’s most popular Python data science package to manipulate data and calculate summary statistics.
Learn to combine data from multiple tables by joining data together using pandas.
Learn how to use NumPy arrays in Python to perform mathematical operations and wrangle data with the best of them!
Learn how to analyze data in Excel.
Enhance your Power BI knowledge, by learning the fundamentals of Data Analysis Expressions (DAX) such as calculated columns, tables, and measures.
Learn how to explore what's available in a database: the tables, relationships between them, and data stored in them.
Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!
Learn to transform and manipulate your data using dplyr.
Harness the power of relational databases by learning how they are structured and writing simple SQL commands to start analyzing data.
Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.
Learn to combine data across multiple tables to answer more complex questions with dplyr.
In this interactive Power BI course, you’ll learn how to use Power Query Editor to transform and shape your data to be ready for analysis.
Explore the Stanford Open Policing Project dataset and analyze the impact of gender on police behavior using pandas.
Learn the key concepts of data modeling on Power BI.
Explore the world of Pivot Tables within Google Sheets, and learn how to quickly organize thousands of data points with just a few clicks of the mouse.
In this course you'll learn the basics of working with time series data.
You’ll learn how to (un)pivot, transpose, append and join tables. Gain power with custom columns, M language, and the Advanced Editor.
Data Analysis Expressions (DAX) allow you to take your Power BI skills to the next level by writing custom functions.
Learn about string manipulation and become a master at using regular expressions.
Master data modeling in Power BI.
Explore ways to work with date and time data in SQL Server for time series analysis
Discover a wide range of DAX calculations and learn how to use them in in Microsoft Power BI.
In this course, you'll learn the basics of relational databases and how to interact with them.
Learn powerful command-line skills to download, process, and transform data, including machine learning pipeline.
Learn how to identify, analyze, remove and impute missing data in Python.
Reshape DataFrames from a wide to long format, stack and unstack rows and columns, and wrangle multi-index DataFrames.
Enhance your reports with trend analysis techniques such as time series, decomposition trees, and key influencers.
Discover the different ways you can enhance your Power BI data importing skills.
Learn the most important functions for manipulating, processing, and transforming data in SQL Server.
The xts and zoo packages make the task of managing and manipulating ordered observations fast and mistake free.
Learn to write scripts that will catch and handle errors and control for multiple operations happening at once.
Analyze text data in R using the tidy framework.
Learn to manipulate and analyze flexibly structured data with MongoDB.
In this course, you'll learn how to collect Twitter data and analyze Twitter text, networks, and geographical origin.
Transform almost any dataset into a tidy format to make analysis easier.
Learn to work with data using tools from the tidyverse, and master the important skills of taming and tidying your data.
Master core concepts about data manipulation such as filtering, selecting and calculating groupwise statistics using data.table.
Learn how to use conditional formatting with your data through built-in options and by creating custom formulas.
Learn how to manipulate data and create machine learning feature sets in Spark using SQL in Python.
Accompanied at every step with hands-on practice queries, this course teaches you everything you need to know to analyze data using your own SQL code today!
Learn how to import and manipulate data with Oracle SQL.
Learn the fundamentals of exploring, manipulating, and measuring biomedical image data.
Learn the gritty details that data scientists are spending 70-80% of their time on; data wrangling and feature engineering.
This course will show you how to integrate spatial data into your Python Data Science workflow.
Level up your SQL knowledge and learn to join tables together, apply relational set theory, and work with subqueries.
This course will show you how to combine and merge datasets with data.table.
Learn how to manipulate and visualize categorical data using pandas and seaborn.
Learn to load, transform, and transcribe human speech from raw audio files in Python.
Get ready to categorize! In this course, you will work with non-numerical data, such as job titles or survey responses, using the Tidyverse landscape.
Extract and visualize Twitter data, perform sentiment and network analysis, and map the geolocation of your tweets.
Learn how to perform advanced dplyr transformations and incorporate dplyr and ggplot2 code in functions.
Explore association rules in market basket analysis with R by analyzing retail data and creating movie recommendations.
Manipulate text data, analyze it and more by mastering regular expressions and string distances in R.
Diagnose, visualize and treat missing data with a range of imputation techniques with tips to improve your results.
Learn how to import, clean and manipulate IoT data in Python to make it ready for machine learning.
Learn how to effectively and efficiently join datasets in tabular format using the Python Pandas library.
Ensure data consistency by learning how to use transactions and handle errors in concurrent environments.
Master time series data using data.table in R.