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

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

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

Introduction to R (edX 1.1)

Introduction to R (edX 1.2)

Lab exercises on Create and Name Vectors.

Introduction to R (edX 2.1)

Introduction to R (edX 2.2)

Introduction to R (edX 2.3)

Lab exercises on Create and Name Matrices.

Introduction to R (edX 3.1)

Introduction to R (edX 3.2)

Introduction to R (edX 3.3)

Introduction to R (edX 4.1)

Introduction to R (edX 5.1)

Lab exercises on Subset and Extend Lists.

Introduction to R (edX 5.2)

Introduction to R (edX 6.1)

Introduction to R (edX 7.1)

Introduction to R (edX 7.2)

Introduction to R (edX 7.3)

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

Python is a general-purpose programming language that is becoming ever more popular for data science. Companies worldwide are using Python to harvest insights from their data and gain a competitive edge. Unlike other Python tutorials, this course focuses on Python specifically for data science. In our Introduction to Python course, you’ll learn about powerful ways to store and manipulate data, and helpful data science tools to begin conducting your own analyses. Start DataCamp’s online Python curriculum now.

Master the basics of data analysis in Python. Expand your skillset by learning scientific computing with NumPy.

Discover how to use Python for data science, learning about the ways to store and manipulate data in the environment to begin conducting your own analyses.

Introduction to Python

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

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

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

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

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

Businesses track data on everything, from operations to marketing to HR. Leveraging this data enables businesses to better understand themselves and their customers, leading to higher profits and better performance. In this course, you’ll learn about the key metrics that businesses use to measure performance. You'll write SQL queries to calculate these metrics and produce report-ready results. Throughout the course, you'll study data from a fictional food delivery startup, modeled on data from real companies.

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

Analyzing Business Data in SQL

Tableau is a widely used business intelligence (BI) and analytics software trusted by companies like Amazon, Experian, and Unilever to explore, visualize, and securely share data in the form of Workbooks and Dashboards. With its user-friendly drag-and-drop functionality it can be used by everyone to quickly clean, analyze, and visualize your team’s data.

You’ll learn how to navigate Tableau’s interface and connect and present data using easy-to-understand visualizations. By the end of this training, you’ll have the skills you need to confidently explore Tableau and build impactful data dashboards. Let’s dive in.

Get started with Tableau, a widely used business intelligence (BI) and analytics software to explore, visualize, and securely share data.

Learn to navigate Tableau’s interface, connect and present data, and build easy-to-understand visualizations to build impactful dashboards for business.

Introduction to Tableau

Gain a 360° overview of exploring and using Power BI to build impactful reports. In this course, you’ll go from zero to hero as you discover how to use this popular business intelligence platform through hands-on exercises. Before diving into creating visualizations using Power BI's drag-and-drop functionality, you’ll first learn how to confidently load and transform data using Power Query and the importance of data models. You’ll also learn to drill down into reports and make your reports fully interactive. You've got the power!

Gain a 360° overview of how to explore and use Power BI to build impactful reports.

Learn how to use the Power BI platform to load and transform data, create visualzations, run DAX formulas, and create reports through hands-on exercises.

Introduction to Power BI

There’s a lot more to Microsoft Excel than SUM and COUNT. Companies and institutions around the world use Excel’s powerful functions to efficiently transform mountains of raw data into clear insights, and now you can too.

 

In this course, you’ll develop employable analyst skills as you learn how to use time-saving keyboard shortcuts, convert and clean data types including text, times and dates, and build impressive logic functions and conditional aggregations. Through hands-on practice, you’ll learn over 35 new Excel functions, including CONCATENATE, VLOOKUP, and AVERAGEIF(S), and work with real-world Kickstarter data as you use your new-found Excel skills to analyze what makes a successful project.

Discover time-saving shortcuts in Excel to help you convert and clean your data. You will learn 35+ new Excel functions including CONCAT, VLOOKUP, and more.

Data Science Courses

Data Science Tracks

Our Learning Experience

@DavidBayani

Workspace Publications (0)

Completed Tracks (0)

Completed courses (19)

Completed Projects (0)