The role of a data scientist is to turn raw data into actionable insights. Much of the world's raw data—from electronic medical records to customer transaction histories—lives in organized collections of tables called relational databases. To be an effective data scientist, you must know how to wrangle and extract data from these databases using a language called SQL . This course teaches syntax in SQL shared by many types of databases, such as PostgreSQL, MySQL, SQL Server, and Oracle. This course teaches you everything you need to know to begin working with databases today!

Master the basics of querying tables in relational databases such as MySQL, SQL Server, and PostgreSQL.

Learn the basics of syntax in SQL, how to extract and wrangle data, and use querying tables in relational databases like MySQL, SQL Server, and PostgreSQL.

Introduction to SQL

Begin your journey into Data Science! Even if you've never written a line of code in your life, you'll be able to follow this course and witness the power of Python to perform Data Science. You'll use data to solve the mystery of Bayes, the kidnapped Golden Retriever, and along the way you'll become familiar with basic Python syntax and popular Data Science modules like Matplotlib (for charts and graphs) and pandas (for tabular data).

Dive into data science using Python and learn how to effectively analyze and visualize your data. No coding experience or skills needed.

Dive into data science using Python and learn how to effectively analyze and visualize your data using Pandas and Matplotlib. No coding experience needed.

Introduction to Data Science in Python

In this introduction to R course, you'll master the basics of this widely used open source language&mdash;including vectors, factors, lists, and data frames. With the coding skills you'll gain in this course, you'll be ready to undertake your own data analysis in R. There are millions of R users worldwide, cementing it as a leading programming language in statistics and data science. More and more organizations are using R, so begin your coding journey in one of DataCamp's most popular courses today!

Master the basics of data analysis by manipulating common data structures such as vectors, matrices, and data frames.

DataCamp's Into to R training course teaches you how to use R programming for data science at your own pace with video tutorials & interactive challenges.

Introduction to R Online

Introduction to R

Learning Python is crucial for any aspiring data science practitioner. Learn to visualize real data with Matplotlib's functions and get acquainted with data structures such as the dictionary and the pandas DataFrame. After covering key concepts such as boolean logic, control flow, and loops in Python, you'll be ready to blend together everything you've learned to solve a case study using hacker statistics.

Level up your data science skills by creating visualizations using Matplotlib and manipulating DataFrames with pandas.

In this intermediate Python course, learn to visualize real data with Matplotlib's functions and get to know new data structures such as the pandas DataFrame.

Intermediate Python

Now that you've learned the basics of SQL in our <a href="https://learn.datacamp.com/courses/introduction-to-sql">Introduction to SQL</a> course, it's time to supercharge your queries using joins and relational set theory. In this course, you'll learn all about the power of joining tables while exploring interesting features of countries and their cities throughout the world. You will master inner and outer joins, as well as self joins, semi joins, anti joins and cross joins—fundamental tools in any PostgreSQL wizard's toolbox. Never fear set theory again after learning all about unions, intersections, and except clauses through easy-to-understand diagrams and examples. Lastly, you'll be introduced to the challenging topic of subqueries. You will be able to visually grasp these ideas by using Venn diagrams and other linking illustrations.

Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL.

Discover all the fundamental in PostgreSQL, like inner, outer self, semi, anti, and cross joins, as well as unions, intersections, and except clauses.

Joining Data in SQL

pandas is the world's most popular Python library, used for everything from data manipulation to data analysis. In this course, you'll learn how to manipulate DataFrames, as you extract, filter, and transform real-world datasets for analysis. Using pandas you’ll explore all the core data science concepts. Using real-world data, including Walmart sales figures and global temperature time series, you’ll learn how to import, clean, calculate statistics, and create visualizations—using pandas to add to the power of Python!

Use the world’s most popular Python data science package to manipulate data and calculate summary statistics.

Data Manipulation with pandas

SQL is an essential skill for data scientists, and Microsoft SQL Server is one of the world's most popular database systems. In this course, you'll start with simple SELECT statements, and refine these queries with ORDER BY and WHERE clauses. You'll learn how to group and aggregate your results, and also how to work with strings.  You'll also cover the most common way to join tables, how to create tables, and inserting and updating data. You'll mainly work with the Chinook digital media database, representing sales of various artists and tracks. The music theme continues with the classic rock and Eurovision datasets, while we also look at trends in power outages in the US. Overall, you'll become proficient in the most common data manipulation tasks in SQL Server and build a solid foundation for the upcoming T-SQL courses here on DataCamp!

Become proficient at using SQL Server to perform common data manipulation tasks.

Learn how to use SQL Server to do common data manipulation tasks, like insert data, joining tables,  group and aggregate results, and work with strings.

Introduction to SQL Server

Intermediate R is the next stop on your journey in mastering the R programming language. In this R training, you will learn about conditional statements, loops, and functions to power your own R scripts. Next, make your R code more efficient and readable using the apply functions. Finally, the utilities chapter gets you up to speed with regular expressions in R, data structure manipulations, and times and dates. This course will allow you to take the next step in advancing your overall knowledge and capabilities while programming in R.

Continue your journey to becoming an R ninja by learning about conditional statements, loops, and vector functions.

Discover conditional statements, loops, and functions to power your own R scripts, and learn to make your R code more efficient using the apply functions.

Intermediate R

Visualizing data in plots and figures exposes the underlying patterns in the data and provides insights. Good visualizations also help you communicate your data to others, and are useful to data analysts and other consumers of the data. In this course, you will learn how to use Matplotlib, a powerful Python data visualization library. Matplotlib provides the building blocks to create rich visualizations of many different kinds of datasets. You will learn how to create visualizations for different kinds of data and how to customize, automate, and share these visualizations.

Learn how to create, customize, and share data visualizations using Matplotlib.

Introduction to Data Visualization with Matplotlib

Being able to combine and work with multiple datasets is an essential skill for any aspiring Data Scientist. pandas is a crucial cornerstone of the Python data science ecosystem, with Stack Overflow recording 5 million views for pandas questions. Learn to handle multiple DataFrames by combining, organizing, joining, and reshaping them using pandas. You'll work with datasets from the World Bank and the City Of Chicago. You will finish the course with a solid skillset for data-joining in pandas.

Learn to combine data from multiple tables by joining data together using pandas.

Learn to handle multiple DataFrames by combining, organizing, joining, and reshaping them using Pandas. You'll gain a solid skillset for data-joining.

Joining Data with pandas

This is an introduction to the programming language R, focused on a powerful set of tools known as the Tidyverse. You'll learn the intertwined processes of data manipulation and visualization using the tools dplyr and ggplot2. You'll learn to manipulate data by filtering, sorting, and summarizing a real dataset of historical country data in order to answer exploratory questions. You'll then learn to turn this processed data into informative line plots, bar plots, histograms, and more with the ggplot2 package. You’ll get a taste of the value of exploratory data analysis and the power of Tidyverse tools. This is a suitable introduction for those who have no previous experience in R and are interested in performing data analysis.

Get started on the path to exploring and visualizing your own data with the tidyverse, a powerful and popular collection of data science tools within R.

Discover the fundamentals of the Tidyverse, and learn all about renaming and reordering variables, while becoming familiar with binomial distribution.

Introduction to the Tidyverse

You’ve already used SQL to query data from databases. But did you know that there's a lot more you can do with databases? You can model different phenomena in your data, as well as the relationships between them. This gives your data structure and consistency, which results in better data quality. In this course, you'll experience this firsthand by working with a real-life dataset that was used to investigate questionable university affiliations. Column by column, table by table, you'll get to unlock and admire the full potential of databases. You'll learn how to create tables and specify their relationships, as well as how to enforce data integrity. You'll also discover other unique features of database systems, such as constraints.

Learn how to create one of the most efficient ways of storing data - relational databases! 

Learn how to create tables and specify their relationships in SQL, as well as how to enforce data integrity and other unique features of database systems.

Introduction to Relational Databases in SQL

The ability to produce meaningful and beautiful data visualizations is an essential part of your skill set as a data scientist. This course, the first R data visualization tutorial in the series, introduces you to the principles of good visualizations and the grammar of graphics plotting concepts implemented in the ggplot2 package. ggplot2 has become the go-to tool for flexible and professional plots in R. Here, we’ll examine the first three essential layers for making a plot - Data, Aesthetics and Geometries. By the end of the course you will be able to make complex exploratory plots.

Learn to produce meaningful and beautiful data visualizations with ggplot2 by understanding the grammar of graphics.

Introduction to Data Visualization with ggplot2

Say you've found a great dataset and would like to learn more about it. How can you start to answer the questions you have about the data? You can use dplyr to answer those questions—it can also help with basic transformations of your data. You'll also learn to aggregate your data and add, remove, or change the variables. Along the way, you'll explore a dataset containing information about counties in the United States. You'll finish the course by applying these tools to the babynames dataset to explore trends of baby names in the United States.

Learn to transform and manipulate your data using dplyr. 

Learn how to use dplyr to transform and aggregate data, then add, remove, or change variables. You'll then apply your skills to a real-world case study.

Data Manipulation with dplyr

The Unix command line has survived and thrived for almost 50 years because it lets people do complex things with just a few keystrokes. Sometimes called "the universal glue of programming," it helps users combine existing programs in new ways, automate repetitive tasks, and run programs on clusters and clouds that may be halfway around the world. This course will introduce its key elements and show you how to use them efficiently.

The Unix command line helps users combine existing programs in new ways, automate repetitive tasks, and run programs on clusters and clouds. 

Discover the Unix command line and how to use it to combine existing programs, automate repetitive tasks, and run programs on clusters and clouds in Shell.

Introduction to Shell

Importing data into R should be the easiest step in your analysis. Unfortunately, that is almost never the case. Data can come in many formats, ranging from .csv and text files, to statistical software files, to databases and HTML data. Knowing which approach to use is key to getting started with the actual analysis.
In this course, you’ll start by learning how to read .csv and text files in R. You will then cover the readr and data.table packages to easily and efficiently import flat file data. After that, you will learn how to read .xls files in R using readxl and gdata.

In this course, you will learn to read CSV, XLS, and text files in R using tools like readxl and data.table.

Learn to read .xls, .csv, and text files in R using readxl and gdata, before learning how to use readr and data.table packages to import flat file data.

Introduction to Importing Data in R

Often in data science, you'll encounter fascinating data that is spread across multiple tables. This course will teach you the skills you'll need to join multiple tables together to analyze them in combination. You'll practice your skills using a fun dataset about LEGOs from the Rebrickable website. The dataset contains information about the sets, parts, themes, and colors of LEGOs, but is spread across many tables. You'll work with the data throughout the course as you learn a total of six different joins! You'll learn four mutating joins: inner join, left join, right join, and full join, and two filtering joins: semi join and anti join. In the final chapter, you'll apply your new skills to Stack Overflow data, containing each of the almost 300,000 Stack Oveflow questions that are tagged with R, including information about their answers, the date they were asked, and their score. Get ready to take your dplyr skills to the next level!

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

Learn to combine data across multiple tables to answer complex questions with dplyr. You'll learn 6 different joins including inner, full, anti, and more.

Joining Data with dplyr

A good database design is crucial for a high-performance application. Just like you wouldn't start building a house without the benefit of a blueprint, you need to think about how your data will be stored beforehand. Taking the time to design a database saves time and frustration later on, and a well-designed database ensures ease of access and retrieval of information. While choosing a design, a lot of considerations have to be accounted for. In this course, you'll learn how to process, store, and organize data in an efficient way. You'll see how to structure data through normalization and present your data with views. Finally, you'll learn how to manage your database and all of this will be done on a variety of datasets from book sales, car rentals, to music reviews.

Learn to design databases using star and snoflake schemas, and OLTP and OLAP. You will gain essential skills for creating and managing databases in SQL.

Database Design

A majority of data is stored in databases and knowing the necessary tools needed to analyze and clean data directly in databases is indispensable. This course focuses on T-SQL, the version of SQL used in Microsoft SQL Server, needed for data analysis. You will learn several concepts in this course such as dealing with missing data, working with dates, and calculating summary statistics using advanced queries. After completing this course, you will have the skills needed to analyze data and provide insights quickly and easily.

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

Learn concepts for working in  T-SQL, such as dealing with missing data, working with dates, and calculating summary statistics using advanced queries.

Intermediate SQL Server

This ggplot2 course builds on your knowledge from the introductory course to produce meaningful explanatory plots. Statistics will be calculated on the fly and you’ll see how Coordinates and Facets aid in communication. You’ll also explore details of data visualization best practices with ggplot2 to help make sure you have a sound understanding of what works and why. By the end of the course, you’ll have all the tools needed to make a custom plotting function to explore a large data set, combining statistics and excellent visuals.

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

Intermediate Data Visualization with ggplot2

It's commonly said that data scientists spend 80% of their time cleaning and manipulating data and only 20% of their time analyzing it. The time spent cleaning is vital since analyzing dirty data can lead you to draw inaccurate conclusions.
 
In this course, you'll learn how to clean dirty data. Using R, you'll learn how to identify values that don't look right and fix dirty data by converting data types, filling in missing values, and using fuzzy string matching. As you learn, you’ll brush up on your skills by working with real-world datasets, including bike-share trips, customer asset portfolios, and restaurant reviews—developing the skills you need to go from raw data to awesome insights as quickly and accurately as possible!

Develop the skills you need to go from raw data to awesome insights as quickly and accurately as possible.

Cleaning Data in R

Ultimately, data analysis is about understanding relationships among variables. Exploring data with multiple variables requires new, more complex tools, but enables a richer set of comparisons. In this course, you will learn how to describe relationships between two numerical quantities. You will characterize these relationships graphically, in the form of summary statistics, and through simple linear regression models.

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

Learn how to describe relationships between two numerical quantities and characterize these relationships graphically through simple linear regression models.

Correlation and Regression in R

This beginner-level introduction to machine learning covers four of the most common classification algorithms. You will come away with a basic understanding of how each algorithm approaches a learning task, as well as learn the R functions needed to apply these tools to your own work.

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

Supervised Learning in R: Classification

When your dataset is represented as a table or a database, it's difficult to observe much about it beyond its size and the types of variables it contains. In this course, you'll learn how to use graphical and numerical techniques to begin uncovering the structure of your data. Which variables suggest interesting relationships? Which observations are unusual? By the end of the course, you'll be able to answer these questions and more, while generating graphics that are both insightful and beautiful.

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

Learn how to use graphical and numerical techniques for exploratory data analysis while generating insightful and beautiful graphics in R.

Exploratory Data Analysis in R

Being able to write your own functions makes your analyses more readable, with fewer errors, and more reusable from project to project. Function writing will increase your productivity more than any other skill!  In this course you'll learn the basics of function writing, focusing on the arguments going into the function and the return values. You'll be writing useful data science functions, and using real-world data on Wyoming tourism, stock price/earnings ratios, and grain yields.

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

Learn how to write efficient, reusable functions in R by understanding the basics of function writing, focusing on the arguments and the return values.

Introduction to Writing Functions in R

SQL Server has a robust set of tools to prepare, aggregate, and query time series data. This course will show you how to build and work with dates, parse dates from strings (and deal with invalid strings), and format dates for reporting. From there, you will see how SQL Server's built-in aggregation operators and window functions can solve important business problems like calculating running totals, finding moving averages, and displaying month-over-month differences using realistic sample data sets. You will also see how taking a different perspective on your data can solve difficult problems.

Explore ways to work with date and time data in SQL Server for time series analysis

Time Series Analysis in SQL Server

The beauty of R is that it is built for performing data analysis. The downside is that sometimes R can be slow, thereby obstructing our analysis. For this reason, it is essential to become familiar with the main techniques for speeding up your analysis, so you can reduce computational time and get insights as quickly as possible.

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

Writing Efficient R Code

Cluster analysis is a powerful toolkit in the data science workbench. It is used to find groups of observations (clusters) that share similar characteristics. These similarities can inform all kinds of business decisions; for example, in marketing, it is used to identify distinct groups of customers for which advertisements can be tailored. In this course, you will learn about two commonly used clustering methods - hierarchical clustering and k-means clustering. You won't just learn how to use these methods, you'll build a strong intuition for how they work and how to interpret their results. You'll develop this intuition by exploring three different datasets&#58; soccer player positions, wholesale customer spending data, and longitudinal occupational wage data.

Develop a strong intuition for how hierarchical and k-means clustering work and learn how to apply them to extract insights from your data. 

Cluster Analysis in R

In this course, you will take a deeper dive into the wide range of data formats out there. More specifically, you'll learn how to import data from relational databases and how to import and work with data coming from the web. Finally, you'll get hands-on experience with importing data from statistical software packages such as SAS, STATA, and SPSS.

Parse data in any format. Whether it's flat files, statistical software, databases, or data right from the web.

Learn how you can use R to parse data in any format, whether that data is from flat files, statistical software, databases, or data right from the web.

Intermediate Importing Data in R

Once you've started learning tools for data manipulation and visualization like dplyr and ggplot2, this course gives you a chance to use them in action on a real dataset. You'll explore the historical voting of the United Nations General Assembly, including analyzing differences in voting between countries, across time, and among international issues. In the process you'll gain more practice with the dplyr and ggplot2 packages, learn about the broom package for tidying model output, and experience the kind of start-to-finish exploratory analysis common in data science.

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

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

Case Study: Exploratory Data Analysis in R

In this finance-oriented introduction to R, you will learn essential data structures such as lists and data frames and have the chance to apply that knowledge to real-world financial examples. By the end of the course, you will be comfortable with the basics of manipulating your data to perform financial analysis in R.

Learn essential data structures such as lists and data frames and apply that knowledge directly to financial examples.

Learn the essential data structures, including lists and data frames and have the chance to apply that knowledge directly to financial examples using R.

Intro to R for Finance

Introduction to R for Finance

Many times in machine learning, the goal is to find patterns in data without trying to make predictions. This is called unsupervised learning. One common use case of unsupervised learning is grouping consumers based on demographics and purchasing history to deploy targeted marketing campaigns. Another example is wanting to describe the unmeasured factors that most influence crime differences between cities. This course provides a basic introduction to clustering and dimensionality reduction in R from a machine learning perspective, so that you can get from data to insights as quickly as possible.


This course provides an intro to clustering and dimensionality reduction in R from a machine learning perspective.

This course provides a basic introduction to clustering and dimensionality reduction in R from a machine learning perspective to get insights quickly.

Unsupervised Learning in R

In this course, you will learn how to make use of the most important functions for manipulating data provided by SQL Server.  You can use these functions for processing and transforming data to get the results you want.

Learn the most important functions for manipulating, processing, and transforming data in SQL Server.

Learn how to use the most important functions for manipulating data in SQL Server to manipulate, process, and transform data to get the results you want.

Functions for Manipulating Data in SQL Server

Take your SQL Server programming to the next level. First, we demystify how to manipulate datetime data by performing temporal exploratory data analysis with the Washington DC BikeShare transactional dataset. Then, you’ll master how to create, update, and execute user-defined functions and stored procedures. You will learn the proper context for each modular programming tool and best practices. In the final chapter, you will apply all of your new skills to solve a real-world business case identifying the New York City yellow taxi utilization for each borough, and which pickup locations should be scheduled for each driver shift.

Master SQL Server programming by learning to create, update, and execute functions and stored procedures.

Writing Functions and Stored Procedures in SQL Server

A mission critical assignment is depending on your SQL coding skills. You’ve been given some code to fix.  It is giving the results you need but it’s running too slow, and it’s poorly formatted making it hard to read.  The deadline is tomorrow.  You’ll need to reformat the code and try different methods to improve performance.  The pressure is on!!!  In this course we’ll be using SQL on real world datasets, from sports and geoscience, to look at good coding practices and different ways how we can can improve the performance of queries to achieve the same outcome.

In this course, students will learn to write queries that are both efficient and easy to read and understand.

Discover how you can reformat code and try different methods to improve the performance of queries in SQL. Then apply your skills to real-world datasets.

Improving Query Performance in SQL Server

Dates and times are abundant in data and essential for answering questions that  start with when, how long, or how often.  However, they can be tricky, as they come in a variety of formats and can behave in unintuitive ways. This course teaches you the essentials of parsing, manipulating, and computing with  dates and times in R. By the end, you'll have mastered the lubridate package, a member of the tidyverse, specifically designed to handle dates and times.  You'll also have applied your new skills to explore how often R versions are released,  when the weather is good in Auckland (the birthplace of R), and how long monarchs ruled in Britain.

Learn the essentials of parsing, manipulating and computing with dates and times in R.

Dates and Times in R

Working with Dates and Times in R

The data.table package provides a high-performance version of base R's data.frame with syntax and feature enhancements for ease of use, convenience and programming speed. This course shows you how to create, subset, and manipulate data.tables. You'll also learn about the database-inspired features of data.tables, including built-in groupwise operations. The course concludes with fast methods of importing and exporting tabular text data such as CSV files. Upon completion of the course, you will be able to use data.table in R for a more efficient manipulation and analysis process. Throughout the course you'll explore the San Francisco Bay Area bike share trip dataset from 2014.

Master core concepts about data manipulation such as filtering, selecting and calculating groupwise statistics using data.table. 

Data Manipulation with data.table in R

From a machine learning perspective, regression is the task of predicting numerical outcomes from various inputs. In this course, you'll learn about different regression models, how to train these models in R, how to evaluate the models you train and use them to make predictions.

In this course you will learn how to predict future events using linear regression, generalized additive models, random forests, and xgboost.

Supervised Learning in R: Regression

As a data scientist, you will often find yourself working with non-numerical data, such as job titles, survey responses, or demographic information. R has a special way of representing them, called factors, and this course will help you master working with them using the tidyverse package forcats. We’ll also work with other tidyverse packages, including ggplot2, dplyr, stringr, and tidyr and use real world datasets, such as the fivethirtyeight flight dataset and Kaggle’s State of Data Science and ML Survey. Following this course, you’ll be able to identify and manipulate factor variables, quickly and efficiently visualize your data, and effectively communicate your results. Get ready to categorize!

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.

Categorical Data in the Tidyverse

Time series are all around us, from server logs to high frequency financial data. Managing and manipulating ordered observations is central to all time series analysis. The xts and zoo packages provide a set of powerful tools to make this task fast and mistake free. In this course, you will learn everything from the basics of xts to advanced tips and tricks for working with time series data in R.

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

You will learn everything from the basics of working with the xts and zoo packages to advanced tips and tricks for working with time series data in R. 

Manipulating Time Series Data with xts and zoo in R

Many phenomena in our day-to-day lives, such as the movement of stock prices, are measured in intervals over a period of time. Time series analysis methods are extremely useful for analyzing these special data types. In this course, you will be introduced to some core time series analysis concepts and techniques.

Learn the core techniques necessary to extract meaningful insights from time series data.

Learn the core techniques necessary to extract meaningful insights from time series data, including WN and RW models, correlation analysis, and more. 

Time Series Analysis in R

It is critical to know how to handle errors and manage transactions when programming SQL scripts. Unhandled errors can be very harmful and can cause unexpected situations, such as inconsistent data in your database, or even worse, errors can lead you to make wrong business decisions.
In this course, you will learn how to handle errors and discover how to manage transactions in case of an error. Additionally, you will study what happens when two or more people interact at the same time with the same data. You will practice all these concepts using two datasets, one of them based on bank accounts and the other one on an electric bike store.

Learn to write scripts that will catch and handle errors and control for multiple operations happening at once.

Transactions and Error-Handling in SQL Server

Transactions and Error Handling in SQL Server

Auditing your SQL Server database and keeping data integrity can be a challenging task for DBAs and database developers. SQL Server triggers are special types of stored procedures designed to help you achieve consistency and integrity of your database. This course will teach you how to work with triggers and use them in real-life examples. Specifically, you will learn about the use cases and limitations of triggers and get practice designing and implementing them. You will also learn to optimize triggers to fit your specific needs.

Learn how to design and implement triggers in SQL Server using real-world examples.

Building and Optimizing Triggers in SQL Server

If you enjoyed the Introduction to R for Finance course, then you will love Intermediate R for Finance. Here, you will first learn the basics about how dates work in R, an important skill for the rest of the course. Your next step will be to explore the world of if statements, loops, and functions. These are powerful ideas that are essential to any financial data scientist's toolkit. Finally, we will spend some time working with the family of apply functions as a vectorized alternative to loops. And of course, all examples will be finance related! Enjoy!

Learn about how dates work in R, and explore the world of if statements, loops, and functions using financial examples.

Learn about how dates work in R, and explore the world of if statements, loops, and functions. You'll practice this knowledge using financial examples.

Intermediate R for Finance

In the real world, data sets typically come split across many tables while most data analysis functions in R are designed to work with single tables of data. In this course, you'll learn how to effectively combine data sets into single tables using data.table. You'll learn how to add columns from one table to another table,
how to filter a table based on observations in another table, and how to identify records across multiple tables matching complex criteria. Along the way, you'll learn how to troubleshoot failed join operations and best practices for working with complex data sets. After completing this course you'll be well on your way to be a data.table master!


This course will show you how to combine and merge datasets with data.table.

Learn how to combine and merge datasets, add columns from one table to another, filter based on observations in another table, and more with data.table

Joining data with data.table in R

Joining Data with data.table in R

Forecasting involves making predictions about the future. It is required in many situations: deciding whether to build another power generation plant in the next ten years requires forecasts of future demand; scheduling staff in a call centre next week requires forecasts of call volumes; stocking an inventory requires forecasts of stock requirements. Forecasts can be required several years in advance (for the case of capital investments), or only a few minutes beforehand (for telecommunication routing). Whatever the circumstances or time horizons involved, forecasting is an important aid to effective and efficient planning. This course provides an introduction to time series forecasting using R.

Learn how to make predictions about the future using time series forecasting in R.

Make predictions about the future using time series forecasting in R. You will learn how to plot data, observe patterns, benchmark, forecast, and more.

Forecasting in R

Character strings can turn up in all stages of a data science project. You might have to clean messy string input before analysis, extract data that is embedded in text or automatically turn numeric results into a sentence to include in a report. Perhaps the strings themselves are the data of interest, and you need to detect and match patterns within them. This course will help you master these tasks by teaching you how to pull strings apart, put them back together and use stringr to detect, extract, match and split strings using regular expressions, a powerful way to express patterns.

Learn how to pull character strings apart, put them back together and use the stringr package.

In this course you will learn how to pull character strings apart, put them back together and use the stringr package.

String Manipulation with stringr in R

Object-oriented programming (OOP) lets you specify relationships between functions and the objects that they can act on, helping you manage complexity in your code. This is an intermediate level course, providing an introduction to OOP, using the S3 and R6 systems. S3 is a great day-to-day R programming tool that simplifies some of the functions that you write. R6 is especially useful for industry-specific analyses, working with web APIs, and building GUIs.

Manage the complexity in your code using object-oriented programming with the S3 and R6 systems.

Object-Oriented Programming with S3 and R6 in R

In this course, you will become an expert in fitting ARIMA models to time series data using R.  First, you will explore the nature of time series data using the tools in the R stats package.  Next, you learn how to fit various ARMA models to simulated data (where you will know the correct model) using the R package astsa.  Once you have mastered the basics, you will learn how to fit integrated ARMA models, or ARIMA models to various real data sets. You will learn how to check the validity of an ARIMA model and you will learn how to forecast time series data.  Finally, you will learn how to fit ARIMA models to seasonal data, including forecasting using the astsa package.

Become an expert in fitting ARIMA (autoregressive integrated moving average) models to time series data using R.

In this course, you will become an expert in fitting ARIMA models to time series data using R, from fitting to simulated data and seasonal data to using astsa.

ARIMA Models in R

A golden rule in investing is to always test the portfolio strategy on historical data, and, once you are trading the strategy, to constantly monitor its performance. In this course, you will learn this by critically analyzing portfolio returns using the package PerformanceAnalytics. The course also shows how to estimate the portfolio weights that optimally balance risk and return. This is a data-driven course that combines portfolio theory with the practice in R, illustrated on real-life examples of equity portfolios and asset allocation problems. If you'd like to continue exploring the data after you've finished this course, the data used in the first three chapters can be obtained using the tseries-package. The code to get them can be found <a href='http://s3.amazonaws.com/assets.datacamp.com/course/portfolio-analysis/data_portfolio_analysis.R' target='_blank'>here</a>. The data used in chapter 4 can be downloaded <a href='http://s3.amazonaws.com/assets.datacamp.com/course/portfolio-analysis/prices.rds' target='_blank'>here</a>.

Apply your finance and R skills to backtest, analyze, and optimize financial portfolios.

Apply your R skills to backtest, analyze, and optimize financial portfolios. The course also shows how to estimate the weights that optimize risk and return.

Introduction to Portfolio Analysis in R

If you've ever done anything with financial or economic time series, you know the data come in various shapes, sizes, and periodicities. Getting the data into R can be stressful and time-consuming, especially when you need to merge data from several different sources into one data set. This course will cover importing data from local files as well as from internet sources.

Learn how to access financial data from local files as well as from internet sources.

Learn how to import and manage different financial or economic time series data into R from different sources, including local files and the internet.

Importing and Managing Financial Data in R

Most of the useful data in the world, from economic data to news content to geographic information, lives somewhere on the internet - and this course will teach you how to access it.

You'll explore how to work with APIs (computer-readable interfaces to websites), access data from Wikipedia and other sources, and build your own simple API client. For those occasions where APIs are not available, you'll find out how to use R to scrape information out of web pages. In the process you'll learn how to get data out of even the most stubborn website, and how to turn it into a format ready for further analysis. The packages you'll use and learn your way around are rvest, httr, xml2 and jsonlite, along with particular API client packages like WikipediR and pageviews.

Learn how to efficiently import data from the web into R.

Discover how to work with APIs, build your own API client, and access data from Wikipedia and other sources by using R to scrape information from web pages.

Working with Web Data in R

This hands-on-course with real-life credit data will teach you how to model credit risk by using logistic regression and decision trees in R.Modeling credit risk for both personal and company loans is of major importance for banks. The probability that a debtor will default is a key component in getting to a measure for credit risk. While other models will be introduced in this course as well, you will learn about two model types that are often used in the credit scoring context; logistic regression and decision trees. You will learn how to use them in this particular context, and how these models are evaluated by banks.

Apply statistical modeling in a real-life setting using logistic regression and decision trees to model credit risk.

Learn to create models to evaluate financial credit risk like a professional

Credit Risk Modeling in R

This course builds on the fundamental concepts from Introduction to Portfolio Analysis in R and explores advanced concepts in the portfolio optimization process. It is critical for an analyst or portfolio manager to understand all aspects of the portfolio optimization problem to make informed decisions. In this course, you will learn a quantitative approach to apply the principles of modern portfolio theory to specify a portfolio, define constraints and objectives, solve the problem, and analyze the results. This course will use the R package PortfolioAnalytics to solve portfolio optimization problems with complex constraints and objectives that mirror real world problems.

Advance you R finance skills to backtest, analyze, and optimize financial portfolios.

Learn to apply the principles of modern portfolio theory to specify a portfolio, define constraints and objectives, solve the problem, and analyze results.

Data Science Courses

Data Science Tracks

Our Learning Experience

@dbchl51198818

Workspace Publications (0)

Completed Tracks(5)

Completed courses (64)

Completed projects (3)