4.3
stars
69 ratings

Rav Ahuja

7,976 already enrolled

Offered By

IBM Skills Network

About this Course

38,058 recent views

Much of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language which is used for communicating with and extracting data from databases. A working knowledge of databases and SQL is a must if you want to become a data scientist.
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. You will create a database instance in the cloud. 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.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Beginner Level

No prior knowledge of databases, SQL, R, or programming is required.

Approx. 28 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

What you will 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 will gain

Data Science
Select (Sql)
Relational Databases (RDBMS)
R Programming
Data Analysis

Flexible deadlines

Reset deadlines in accordance to your schedule.

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Beginner Level

No prior knowledge of databases, SQL, R, or programming is required.

Approx. 28 hours to complete

English

Could your company benefit from training employees on in-demand skills?

Try Coursera for Business

Instructor

Instructor rating

4.15/5 (29 Ratings)

Rav Ahuja

Global Program Director

IBM Skills Network

1,471,699 Learners

35 Courses

Offered by

IBM Skills Network

IBM is the global leader in business transformation through an open hybrid cloud platform and AI, serving clients in more than 170 countries around the world. Today 47 of the Fortune 50 Companies rely on the IBM Cloud to run their business, and IBM Watson enterprise AI is hard at work in more than 30,000 engagements. IBM is also one of the world’s most vital corporate research organizations, with 28 consecutive years of patent leadership. Above all, guided by principles for trust and transparency and support for a more inclusive society, IBM is committed to being a responsible technology innovator and a force for good in the world.

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

Syllabus - What you will learn from this course

Week

Week 1

2 hours to complete

Getting Started with SQL

Structured Query Language, or SQL, provides a standard language for selecting and manipulating data in a relational database. Understanding SQL is a foundational skill that you must have when applying data science principles in R because SQL is the key to helping you unlock insights about the information stored deep inside relational databases. In this module, you will learn some basic SQL statements and practice them hands-on on a live database.

2 hours to complete

5 videos (Total 17 min), 1 reading, 5 quizzes

Week

Week 2

5 hours to complete

Introduction to Relational Databases and Tables

5 hours to complete

6 videos (Total 27 min), 1 reading, 5 quizzes

Week

Week 3

7 hours to complete

Intermediate SQL

7 hours to complete

7 videos (Total 32 min), 2 readings, 8 quizzes

7 videos

Using String Patterns and Ranges4m

Sorting Result Sets2m

Grouping Result Sets3m

Built-in Database Functions6m

Date and Time Built-in Functions2m

Sub-Queries and Nested Selects4m

Working with Multiple Tables6m

2 readings

Summary & Highlights5m

4 practice exercises

Practice Quiz10m

Graded Quiz: Refining Your Results15m

Practice Quiz10m

Graded Quiz: Functions, Sub-Queries, Multiple Tables15m

Week

Week 4

5 hours to complete

Getting Started with Databases using R

In this module, you will learn the benefits of using R to connect to relational databases and how to persist R database objects in files. You’ll also learn some of the similarities between R data frames and relational databases, including how data types compare and when you must convert from one type to another to improve the effectiveness of your data analysis. Finally, you’ll learn different methods for connecting to a database from R.

5 hours to complete

10 videos (Total 27 min), 2 readings, 9 quizzes

10 videos

Why use R with Relational Databases 2m

R Persistence Options1m

Terminology Comparison1m

Mapping Data between R and RDBMS2m

Database Design Considerations2m

Connectivity Options2m

Connecting with RJDBC 2m

Connectivity using ODBC2m

RODBC in Detail 4m

Metadata Discovery 3m

2 readings

Summary & Highlights 10m

4 practice exercises

Practice Quiz10m

Graded Quiz: R and Relational Databases10m

Practice Quiz10m

Graded Quiz: Connecting to Databases from R15m

Reviews

4.3

17 reviews

5 stars
60.86%
4 stars
20.28%
3 stars
10.14%
2 stars
2.89%
1 star
5.79%

TOP REVIEWS FROM SQL FOR DATA SCIENCE WITH R

by ANApr 11, 2022

Very useful course for those who wants to learn SQL.

by OMMay 31, 2022

I really like the course. Only I think that need to improve the final project, inlcude a little more information in each problem.

by HDMar 4, 2022

This skills in this course are easy to learn, the simplicity of the materials is what I like the most about IBM courses.

by SSOct 28, 2022

Well designed course with exposure to ODBC and JDBC...

View all reviews

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. You can try a Free Trial instead, or apply for Financial Aid.
The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Certificate?
When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.

Build employee skills, drive business results

Discover Coursera for Business

SQL for Data Science with R

About this Course

What you will learn

Skills you will gain