#### PostgreSQL Summary Stats and Window Functions

Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!

458 results

Learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon!

4 hours
Data Manipulation
Fernando Gonzalez Prada
Course

Use Seaborn's sophisticated visualization tools to make beautiful, informative visualizations with ease.

4 hours
Data Visualization
Chris Moffitt
Course

Learn to combine data across multiple tables to answer more complex questions with dplyr.

4 hours
Data Manipulation
DataCamp Content Creator
Course

In this course, you will be introduced to unsupervised learning through techniques such as hierarchical and k-means clustering using the SciPy library.

4 hours
Machine Learning
Shaumik Daityari
Course

An introduction to data visualization with no coding involved.

2 hours
Data Visualization
Richie Cotton
Course

Learn to perform the two key tasks in statistical inference: parameter estimation and hypothesis testing.

4 hours
Probability & Statistics
Justin Bois
Course

Learn about data science and how can you use it to strengthen your organization.

2 hours
Management
Michael Chow
Course

Learn to retrieve and parse information from the internet using the Python library scrapy.

4 hours
Importing & Cleaning Data
Thomas Laetsch
Course

R Markdown is an easy-to-use formatting language for authoring dynamic reports from R code.

4 hours
Reporting
Amy Peterson
Course

Learn how to work with dates and times in Python.

4 hours
Programming
Max Shron
Course

Explore the Stanford Open Policing Project dataset and analyze the impact of gender on police behavior using pandas.

4 hours
Data Manipulation
Kevin Markham
Course

Consolidate and extend your knowledge of Python data types such as lists, dictionaries, and tuples, leveraging them to solve Data Science problems.

4 hours
Programming
Jason Myers
Course

Learn to use facets, coordinate systems and statistics in ggplot2 to create meaningful explanatory plots.

4 hours
Data Visualization
Rick Scavetta
Course

In this course you will learn the details of linear classifiers like logistic regression and SVM.

4 hours
Machine Learning
Mike Gelbart
Course

In this course you will learn the basics of machine learning for classification.

4 hours
Machine Learning
Brett Lantz
Course

Learn the fundamentals of neural networks and how to build deep learning models using TensorFlow.

4 hours
Machine Learning
Isaiah Hull
Course

Predict housing prices and ad click-through rate by implementing, analyzing, and interpreting regression analysis in R.

4 hours
Probability & Statistics
Richie Cotton
Course

Learn the basics of spreadsheets by working with rows, columns, addresses, and ranges.

2 hours
Programming
Vincent Vankrunkelsven
Course

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.

4 hours
Data Manipulation
Frank Sumanski
Course

Learn how to describe relationships between two numerical quantities and characterize these relationships graphically.

4 hours
Probability & Statistics
Ben Baumer
Course

Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.

4 hours
Data Manipulation
Brian Piccolo
Course

This course introduces Python for financial analysis.

4 hours
Applied Finance
Adina Howe
Course

In this course you'll learn the basics of working with time series data.

4 hours
Data Manipulation
Stefan Jansen
Course

Learn how to build a model to automatically classify items in a school budget.

4 hours
Case Studies
Peter Bull
Course

Learn to write SQL queries to calculate key metrics that businesses use to measure performance.

4 hours
Reporting
Michel Semaan
Course

Learn the key concepts of data modeling on Power BI.

4 hours
Data Manipulation
Maarten Van den Broeck
Course

Learn to design databases in SQL.

4 hours
Data Engineering
Lis Sulmont
Course

Expand your spreadsheets vocabulary by diving deeper into data types, including numeric data, logical data, and missing data.

4 hours
Programming
Richie Cotton
Course

In this course you'll learn the basics of analyzing time series data.

4 hours
Probability & Statistics
Rob Reider
Course

Take your Tableau skills up a notch with advanced analytics and visualizations.

8 hours
Data Visualization
Hadrien Lacroix
Course

Learn the fundamentals of data visualization using spreadsheets.

4 hours
Data Visualization
Raina Hawley
Course

Learn how to to implement and schedule data engineering workflows.

4 hours
Data Engineering
Mike Metzger
Course

In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server for data analysis.

4 hours
Programming
Ginger Grant
Course

In this course, you'll learn about the concepts of random variables, distributions, and conditioning.

4 hours
Probability & Statistics
David Robinson
Course

Learn how to use graphical and numerical techniques to begin uncovering the structure of your data.

4 hours
Probability & Statistics
Andrew Bray
Course

Learn to write faster R code, discover benchmarking and profiling, and unlock the secrets of parallel programming.

4 hours
Programming
Colin Gillespie
Course

Learn to create deep learning models with the PyTorch library.

4 hours
Machine Learning
Ismail Elezi
Course

The xts and zoo packages make the task of managing and manipulating ordered observations fast and mistake free.

4 hours
Data Manipulation
DataCamp Content Creator
Course

Learn to reduce dimensionality in Python.

4 hours
Machine Learning
Jeroen Boeye
Course

Learn to process, transform, and manipulate images at your will.

4 hours
Machine Learning
Rebeca Gonzalez
Course

Grow your statistical skills and learn how to collect, analyze, and draw accurate conclusions from data using Python.

4 hours
Probability & Statistics
Maggie Matsui
Course

In this course, you'll learn the basics of relational databases and how to interact with them.

4 hours
Data Manipulation
Jason Myers
Course

Take your R skills up a notch by learning to write efficient, reusable functions.

4 hours
Programming
Richie Cotton
Course

This course provides a comprehensive introduction to working with base graphics in R.

4 hours
Data Visualization
Ronald Pearson
Course

Learn about string manipulation and become a master at using regular expressions.

4 hours
Data Manipulation
Maria Eugenia Inzaugarat
Course

Learn the fundamentals of gradient boosting and build state-of-the-art machine learning models using XGBoost to solve classification and regression problems.

4 hours
Machine Learning
Sergey Fogelson
Course

Learn to perform linear and logistic regression with multiple explanatory variables.

4 hours
Probability & Statistics
Richie Cotton
Course

Use data manipulation and visualization skills to explore the historical voting of the United Nations General Assembly.

4 hours
Case Studies
David Robinson
Course

Learn the fundamentals of working with big data with PySpark.

4 hours
Programming
Upendra Kumar Devisetty
Course

Bash scripting allows you to build analytics pipelines in the cloud and work with data stored across multiple files.

4 hours
Programming
Alex Scriven
Course

Use pandas and Bayesian statistics to see if left-handed people actually die earlier than righties.

45 minutes
Data Manipulation, Data Visualization...
Madeleine Bonsma-Fisher
Project
guided

Create and explore interactive maps using Leaflet to determine where to open the next Chipotle.

45 minutes
Data Manipulation, Data Visualization...
Rich Majerus
Project
guided

Flex your data manipulation muscles on breath alcohol test data from Ames, Iowa, USA.

45 minutes
Data Manipulation, Data Visualization...
Samantha Tyner
Project
guided

Build a machine learning classifier that knows whether President Trump or Prime Minister Trudeau is tweeting!

60 minutes
Data Manipulation, Data Visualization...
Katharine Jarmul
Project
guided

How can we find a good strategy for reducing traffic-related deaths?

60 minutes
Data Manipulation, Data Visualization...
Joel Ã–stblom
Project
guided

How can we find a good strategy for reducing traffic-related deaths?

60 minutes
Data Manipulation, Data Visualization...
Joel Ã–stblom
Project
guided

Get ready for Halloween by digging into a FiveThirtyEight dataset with all your favorite candy!

60 minutes
Data Visualization, Probability & Statistics...
Nick Solomon
Project
guided

Rock or rap? Apply machine learning methods in Python to classify songs into genres.

60 minutes
Data Manipulation, Data Visualization...
Lina Tran
Project
guided

Examine the relationship between heart rate and heart disease using multiple logistic regression.

60 minutes
Data Manipulation, Data Visualization...
Amy Yang
Project
guided

Explore a dataset from Kaggle containing a century's worth of Nobel Laureates. Who won? Who got snubbed?

60 minutes
Data Manipulation, Data Visualization...
Rasmus BÃ¥Ã¥th
Project
guided

Examine the network of connections among local health departments in the United States.

60 minutes
Data Manipulation, Data Visualization...
Jenine Harris
Project
guided

Analyze the relative popularity of programming languages over time based on Stack Overflow data.

60 minutes
Data Manipulation, Data Visualization...
David Robinson
Project
guided

Build a model that can automatically detect honey bees and bumble bees in images.

60 minutes
Data Manipulation, Data Visualization...
Peter Bull
Project
guided

If you have never done a DataCamp project, this is the place to start!

30 minutes
Data Visualization, Case Studies
Rasmus BÃ¥Ã¥th
Project
guided

Automatically generate keywords for a search engine marketing campaign using Python.

60 minutes
Data Manipulation
Elias Dabbas
Project
guided

Use web scraping and NLP to find the most frequent words in one of two pieces of classic literature: Herman Melville's novel, Moby Dick, or Peter Pan by J. M. Barrie.

45 minutes
Importing & Cleaning Data, Case Studies
Hugo Bowne-Anderson
Project
guided

Load, transform, and understand images of honey bees and bumble bees in Python.

60 minutes
Data Manipulation, Data Visualization...
Peter Bull
Project
guided

If you've never done a DataCamp project, this is the place to start!

30 minutes
Data Visualization, Case Studies
Rasmus BÃ¥Ã¥th
Project
guided

Explore a dataset from Kaggle containing a century's worth of Nobel Laureates. Who won? Who got snubbed?

45 minutes
Data Manipulation, Data Visualization...
Rasmus BÃ¥Ã¥th
Project
guided

Use MLB's Statcast data to compare New York Yankees sluggers Aaron Judge and Giancarlo Stanton.

45 minutes
Data Manipulation, Data Visualization...
David Venturi
Project
guided

Flex your data manipulation muscles on breath alcohol test data from Ames, Iowa, USA.

45 minutes
Data Manipulation, Data Visualization...
Samantha Tyner
Project
guided

Reanalyse the data behind one of the most important discoveries of modern medicine: handwashing.

60 minutes
Data Manipulation, Data Visualization...
Rasmus BÃ¥Ã¥th
Project
guided

Analyze an A/B test from the popular mobile puzzle game, Cookie Cats.

45 minutes
Case Studies
Rasmus BÃ¥Ã¥th
Project
guided

Analyze athletics data to find new ways to scout and assess jumpers and throwers.

45 minutes
Case Studies
George Perry
Project
guided

Compare life expectancy across countries and genders with ggplot2.

45 minutes
Data Manipulation, Data Visualization...
Antonio SÃ¡nchez ChinchÃ³n
Project
guided

Find the true Scala experts by exploring its development history in Git and GitHub.

45 minutes
Data Manipulation, Data Visualization...
Anita Sarma
Project
guided

Use Natural Language Processing on NIPS papers to uncover the trendiest topics in machine learning research.

45 minutes
Data Manipulation, Data Visualization...
Lars Hulstaert
Project
guided

Check what passwords fail to conform to the National Institute of Standards and Technology password guidelines.

45 minutes
Case Studies
Rasmus BÃ¥Ã¥th
Project
guided

Analyze data from the hit mobile game, Candy Crush Saga.

45 minutes
Data Manipulation, Data Visualization...
Rasmus BÃ¥Ã¥th
Project
guided

Recreate John Snow's famous map of the 1854 cholera outbreak in London.

60 minutes
Data Manipulation, Data Visualization...
Radovan Kavicky
Project
guided

Use data management and exploratory data analysis skills to help analyze the UK Dairy Industry.

60 minutes
Case Studies
DataCamp Content Creator
Project
unguided

Apply the foundational Python skills you learned in Introduction to Python and Intermediate Python by manipulating and visualizing movie and TV data.

45 minutes
Data Manipulation, Data Visualization...
Justin Saddlemyer
Project
guided

Use coding best practices and functions to improve a script!

45 minutes
Programming
Lis Sulmont
Project
guided

Use DataFrames to read and merge employee data from different sources.

45 minutes
Data Manipulation, Importing & Cleaning Data
Hadrien Lacroix
Project
guided

Apply your data importing and cleaning skills from the Importing and Cleaning Data with R skill track to uncover insights about the Airbnb market in New York City.

45 minutes
Importing & Cleaning Data
Maggie Matsui
Project
guided

Load, clean, and visualize scraped Google Play Store data to gain insights into the Android app market.

45 minutes
Data Manipulation, Data Visualization...
Lavanya Gupta
Project
guided

Reanalyse the data behind one of the most important discoveries of modern medicine: handwashing.

45 minutes
Data Manipulation
Maggie Matsui
Project
guided

Analyze the relative popularity of programming languages over time based on Stack Overflow data.

60 minutes
Data Manipulation, Data Visualization...
Sara Billen
Project
guided

Manipulate and plot time series data from Google Trends to analyze changes in search interest over time.

45 minutes
Data Manipulation, Data Visualization...
Lis Sulmont
Project
guided

Apply the foundational Python skills you learned in Introduction to Python and Intermediate Python by manipulating and visualizing movie and TV data.

45 minutes
Data Manipulation, Data Visualization...
Justin Saddlemyer
Project
unguided

Use SQL data manipulation and joins to discover the oldest businesses around the world.

45 minutes
Data Manipulation
Richie Cotton
Project
guided

Find out about the evolution of the Linux operating system by exploring its version control system.

45 minutes
Importing & Cleaning Data, Case Studies
Markus Harrer
Project
guided

In this project, you will use importing and text manipulation skills to find out the main protagonists in Peter Pan!

45 minutes
Importing & Cleaning Data, Case Studies
Hadrien Lacroix
Project
guided

Write functions to forecast time series of food prices in Rwanda.

45 minutes
Data Manipulation, Data Visualization...
Richie Cotton
Project
guided

Check what passwords fail to conform to the National Institute of Standards and Technology password guidelines.

45 minutes
Data Manipulation, Importing & Cleaning Data
Lis Sulmont
Project
guided

Use a variety of data manipulation techniques to explore different aspects of Lego's history!

45 minutes
Data Manipulation, Data Visualization...
Ramnath Vaidyanathan
Project
guided