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

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

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

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

So you've learned how to aggregate and join data from tables in your database—now what? How do you manipulate, transform, and make the most sense of your data? This intermediate-level course will teach you several key functions necessary to wrangle, filter, and categorize information in a relational database, expand your SQL toolkit, and answer complex questions. You will learn the robust use of CASE statements, subqueries, and window functions—all while discovering some interesting facts about soccer using the European Soccer Database.

Master the complex SQL queries necessary to answer a wide variety of data science questions and prepare robust data sets for analysis in PostgreSQL.

Intermediate SQL

Have you ever wondered how data professionals use SQL to solve real-world business problems, like generating rankings, calculating moving averages and running totals, deduplicating data, or performing time intelligence? If you already know how to select, filter, order, join and group data with SQL, this course is your next step. By the end, you will be writing queries like a pro! You will learn how to create queries for analytics and data engineering with window functions, the SQL secret weapon! Using flights data, you will discover how simple it is to use window functions, and how flexible and efficient they are.

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

PostgreSQL Summary Stats and Window Functions

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

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

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

Become a master at building complex reports!  In this course, you will apply all the SQL concepts and functions you have learned in previous courses to build out your very own dashboard.  By navigating through an Olympics database, you will become an expert data explorer and learn how to understand novel database quickly and effectively.  Since data is never perfect, you will gain valuable strategies to deal with real-world issues commonly found with SQL, including how to remove data duplication and how to turn messy data into clean, organized reports.  Lastly, you’ll conquer complex calculations using window functions and layered calculations, all within the same report.  This is a perfect class for anyone who will be commonly pulling data from databases and is a great complement for those who use R or Python for data science.

Learn how to build your very own dashboard by applying all the SQL concepts and functions you have learned in previous courses.

Reporting in SQL

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

This course provides a comprehensive introduction on how to plot data with R’s default graphics system, base graphics.After an introduction to base graphics, we look at a number of R plotting examples, from simple graphs such as scatterplots to plotting correlation matrices. The course finishes with exercises in plot customization. This includes using R plot colors effectively and creating and saving complex plots in R.Base Graphics Background R supports four different graphics systems: base graphics, grid graphics, lattice graphics, and ggplot2. Base graphics is the default graphics system in R, the easiest of the four systems to learn to use, and provides a wide variety of useful tools, especially for exploratory graphics where we wish to learn what is in an unfamiliar dataset.

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

Data Visualization in R

Interactive graphics allow you to manipulate plotted data to gain further insight. As an example, an interactive graphic would allow you to zoom in on a subset of your data without the need to create a new plot. In this course, you will learn how to create and customize interactive graphics in plotly using the R programming language. Along the way, you will review data visualization best practices and be introduced to new plot types such as scatterplot matrices and binned scatterplots.

Learn to create interactive graphics entirely in R with plotly.

Learn how to create and style interactive graphs in R using Plotly. You'll discover univariate and bivarate distributions and how to convert ggplot2 graphs.

Interactive Data Visualization with plotly in R

You have access to a database. Now what do you do? Building on your existing skills joining tables,  using basic functions, grouping data, and using subqueries, the next step in your SQL journey is  learning how to explore a database and the data in it.  Using data from Stack Overflow, Fortune 500 companies, and 311 help requests  from Evanston, IL, you'll get familiar with numeric, character, and date/time data types. You'll use  functions to aggregate, summarize, and analyze data without leaving  the database. Errors and inconsistencies in the data won't stop you!  You'll learn common problems to look for  and strategies to clean up messy data. By the end of this course, you'll be ready to start exploring your  own PostgreSQL databases and analyzing the data in them.

Learn how to explore what's available in a database: the tables, relationships between them, and data stored in them.

Learn what's available in a database in SQL, including the tables, relationships, and data stored in them so you can explore your own PostgreSQL databases.

Exploratory Data Analysis in SQL

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

This course will provide you an understanding of how to use built-in PostgreSQL functions in your SQL queries to manipulate different types of data including strings, character, numeric and date/time. We'll travel back to a time where Blockbuster video stores were on every corner and if you wanted to
watch a movie, you actually had to leave your house to rent a DVD! You'll also get an introduction into the robust full-text search capabilities which provides a powerful tool for indexing and matching keywords in a PostgreSQL document. And finally, you'll learn how to extend these features by using PostgreSQL extensions.

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

Learn how to use built-in PostgreSQL functions in your SQL queries to manipulate different types of data like strings, character, numeric and date/time.

Functions for Manipulating Data in PostgreSQL

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

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

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

Being able to leverage transactions and find and handle errors is critical to building resilient SQL scripts and working with databases. Transactions provide the protection needed to ensure that your data is consistent and operations work on the desired data in concurrent environments. Improper error handling can cause many serious and unexpected issues. Without the proper use of transactions and error handling, it's possible to make decisions based on incorrect data leading to false outcomes. In this course, we'll cover proper ways to use transactions and handle errors with a record of what went wrong. Additionally, we discuss how concurrently plays into the use of transactions and data outcomes. We'll practice these concepts on the FFEIC bank health data and with a patient data table.

Ensure data consistency by learning how to use transactions and handle errors in concurrent environments.

Data Science Courses

Data Science Tracks

Our Learning Experience

@squall89333

Workspace Publications (0)

Completed Tracks (0)

Completed courses (10)

Completed Projects (0)