EdX

SQL Basics for Data Science with R (edX)

Offered by IBM,
SQL Basics for Data Science with R (edX)

Build a baseline understanding about relational database concepts and learn how to apply foundational knowledge of the SQL and R languages through a series of hands-on labs to practice building and running SQL queries.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

A majority of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language for communicating with and extracting data from databases. A working knowledge of databases and the SQL language is a must if you want to become a data scientist. The purpose of this course is to introduce relational database concepts and to help you learn and apply foundational knowledge of the SQL and R languages. It is also intended to get you started with performing SQL access in a data science environment.
The emphasis in this course is on hands-on and practical learning, which means you will work with real databases, real data science tools, and real-world datasets. You will also create a database instance in the cloud. Through a series of hands-on labs you will practice building and running SQL queries. And you will learn how to access databases from Jupyter notebooks using SQL and R.
No prior knowledge of databases, SQL, R, or programming is required.

This course is part of the Data Analytics and Visualization with Excel and R Professional Certificate and Applied Data Science with R Professional Certificate

What you'll learn

  • Create and access a database instance on cloud
  • Write basic SQL statements: CREATE, DROP, SELECT, INSERT, UPDATE, DELETE
  • Filter, sort, group results, use built-in functions, compose nested queries, access multiple tables
  • Access databases from Jupyter using R and SQL to query real-world datasets
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Data Science: R Basics (edX) EdX
HarvardX,Harvard University

Data Science: R Basics (edX)

Statistics & Data Analysis Data Science

Build a foundation in R and learn how to wrangle, analyze, and visualize data. This course will introduce you to the basics of R programming. You can better retain R when you learn it to solve a specific problem, so you’ll use a real-world dataset about crime in the United States. You will learn the R skills needed to answer essential questions about differences in crime across the different states.

Self Paced
Self-Paced
Probability Machine Learning Inference
Details
Advanced Statistical Inference and Modelling Using R (edX) EdX
University of Canterbury,UCx

Advanced Statistical Inference and Modelling Using R (edX)

Sci: Mathematics Statistics & Data Analysis

Extend your knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up. Advanced Statistical Inference and Modelling Using R is part two of the Statistical Analysis in R professional certificate. This course is directed at people who are already familiar with basic linear regression and fundamentals of statistical inference. It extends the knowledge of linear regression to the situations where the response variable is binary, a count, or categorical as well as to hierarchical experimental set-up.

Self Paced
Self-Paced
Modeling Data Analysis Linear Regression
Details
Data Analytics and Visualization Capstone Project (edX) EdX
IBM

Data Analytics and Visualization Capstone Project (edX)

Statistics & Data Analysis

Accelerate the knowledge you gain from previous courses in the IBM Data Analyst Professional Certificate program. Assume the role of an Associate Data Analyst and use various skills and techniques on real-world datasets to accomplish a task. This course provides students with the opportunity to assume the role of an Associate Data Analyst who has recently joined an organization. In this role, you will use Data Analytics skills and techniques on real-world datasets to complete a business task.

Self Paced
Self-Paced
Data Data Wrangling Data Visualization
Details
Fundamentals of TinyML (edX) EdX
HarvardX,Harvard University

Fundamentals of TinyML (edX)

Statistics & Data Analysis Data Science

Focusing on the basics of machine learning and embedded systems, such as smartphones, this course will introduce you to the “language” of TinyML. What do you know about TinyML? Tiny Machine Learning (TinyML) is one of the fastest-growing areas of Deep Learning and is rapidly becoming more accessible. This course provides a foundation for you to understand this emerging field.

Self Paced
Self-Paced
Machine Learning Embedded Systems Data Science
Details
Data Visualization and Building Dashboards with Excel and Cognos (edX) EdX
IBM

Data Visualization and Building Dashboards with Excel and Cognos (edX)

Statistics & Data Analysis

Build the fundamental knowledge necessary to use Excel and IBM Cognos Analytics to create data visualizations and to create dashboards containing those visualizations to help tell a lucid story about data. This course provides students with the basics required to create data visualizations and dashboards using both Microsoft Excel and IBM Cognos Analytics.

Self Paced
Self-Paced
Spreadsheets Excel Analytics
Details
Fundamentos TIC para profesionales de negocios: Programación (edX) EdX
Universitat Politècnica de València,UPValenciaX

Fundamentos TIC para profesionales de negocios: Programación (edX)

CS: Software Engineering

¿Tienes que trabajar con las Tecnologías de la Información y te faltan conocimientos? Conoce los fundamentos de la programación software. Este curso forma parte de una serie de 5 cursos de introducción al uso de sistemas de información en las empresas que te introducirá en el apasionante mundo de las TIC.

Self Paced
Self-Paced
HTML Javascript XML
Details
Data Science: Probability (edX) EdX
HarvardX,Harvard University

Data Science: Probability (edX)

Statistics & Data Analysis Data Science

Learn probability theory — essential for a data scientist — using a case study on the financial crisis of 2007–2008. In this course, you will learn valuable concepts in probability theory. The motivation for this course is the circumstances surrounding the financial crisis of 2007–2008. Part of what caused this financial crisis was that the risk of some securities sold by financial institutions was underestimated. To begin to understand this very complicated event, we need to understand the basics of probability.

Self Paced
Self-Paced
Probability Monte Carlo Method Data Science
Details
Data Science and Machine Learning Capstone Project (edX) EdX
IBM

Data Science and Machine Learning Capstone Project (edX)

Statistics & Data Analysis Data Science

Create a project that you can use to showcase your Data Science skills to prospective employers. Apply various data science and machine learning techniques to analyze and visualize a data set involving a real life business scenario and build a predictive model. Now that you've taken several courses on data science and machine learning, it’s time to put your learning to work on a data problem involving a real life scenario. Employers really care about how well you can apply your knowledge and skills to solve real world problems, and the work you do in this capstone project will make you stand out in the job market.

Self Paced
Self-Paced
Python Machine Learning Data Science
Details
Data Science Ethics (edX) EdX
University of Michigan,MichiganX

Data Science Ethics (edX)

CS: Software Engineering Engineering

Learn how to think through the ethics surrounding privacy, data sharing, and algorithmic decision-making. As patients, we care about the privacy of our medical record; but as patients, we also wish to benefit from the analysis of data in medical records. As citizens, we want a fair trial before being punished for a crime; but as citizens, we want to stop terrorists before they attack us. As decision-makers, we value the advice we get from data-driven algorithms; but as decision-makers, we also worry about unintended bias.

Self Paced
Self-Paced
Ethics Decision Making Privacy
Details
Analyzing Data with Excel (edX) EdX
IBM

Analyzing Data with Excel (edX)

Statistics & Data Analysis

Build the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis. The course covers the basic workings and key features of Excel to help students analyze their data. This course provides students with the fundamental knowledge required to use Excel spreadsheets to perform basic data analysis.The course consists of several videos, demos, examples, and hands-on labs to help you learn, and ends with a final assignment project which will help you put what you have learned into practice.

Self Paced
Self-Paced
Data Spreadsheets Excel
Details