Ementorhub

What you'll learn

Create and access a database instance on the cloud

Compose and execute basic SQL statements - SELECT, INSERT, UPDATE, DELETE, CREATE, DROP

Construct SQL statements to filter, sort, group results, use built-in functions, compose nested queries, access multiple tables

Analyze data from Jupyter using R and SQL by combining SQL and R skills to query real-world datasets

Skills you'll gain

Query Languages

Database Management

Data Analysis

Databases

R Programming

Data Modeling

Database Design

Data Manipulation

Data Access

SQL

Relational Databases

Exploratory Data Analysis

There are 6 modules in this course

The purpose of this course is to introduce relational database concepts and 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. As such, you will work with real databases, real data science tools, and real-world datasets. Through a series of hands-on labs, you will practice building and running SQL queries. You will also learn how to access databases from Jupyter notebooks using SQL and R. No prior knowledge of databases, SQL, R, or programming is required. Anyone can audit this course at no charge. If you choose to take this course and earn the Coursera course certificate, you can also earn an IBM digital badge upon successful completion of the course.

Introduction to Relational Databases and Tables

Intermediate SQL

Getting Started with Databases using R

Working with Database Objects using R

Course Project