SQL for Data Science with R
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.
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- المدة 28 ساعات hours
- الطبع بواسطة IBM
-
Offered by
عن
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.الوحدات
Basic SQL
-
5
Videos
-
2
Readings
-
3
ExternalTool
-
2
Plugin
-
2
Assignment
2
Assignment
- Practice Quiz: Getting Started with SQL
- Graded Quiz: Getting Started with SQL
3
External Tool
- Hands-on Lab: Simple SELECT Statements
- Hands-on Lab: COUNT, DISTINCT, LIMIT
- Hands-on Lab: INSERT, UPDATE, and DELETE
5
Videos
- Welcome to SQL for Data Science
- SELECT Statement
- COUNT, DISTINCT, LIMIT
- INSERT Statement
- UPDATE and DELETE Statements
2
Readings
- Course Overview
- Module Summary: Getting Started with SQL
Introduction to Relational Databases and Tables
-
5
Videos
-
1
Readings
-
2
ExternalTool
-
2
Plugin
-
2
Assignment
2
Assignment
- Practice Quiz: Introduction to Relational Databases and Tables
- Graded Quiz: Introduction to Relational Databases and Tables
2
External Tool
- Hands-on Lab: CREATE, ALTER, TRUNCATE, DROP into Tables in MySQL using phpMyAdmin
- Hands-on Lab: Create and Load Tables using SQL Scripts
5
Videos
- Introduction to Databases
- Relational Database Concepts
- Types of SQL statements (DDL vs. DML)
- CREATE TABLE Statement
- ALTER, DROP, and Truncate tables
1
Readings
- Module Summary: Introduction to Relational Databases and Tables
[Optional] Using IBM Db2
-
1
Videos
-
2
Readings
-
1
ExternalTool
1
External Tool
- Obtain IBM Cloud Feature Code and Activate Trial Account
1
Videos
- How to create a Database instance on Cloud
2
Readings
- About this Optional Lesson
- [Optional] Hands-on Lab Using IBM Db2
Refining your Results
-
3
Videos
-
1
Readings
-
1
ExternalTool
-
1
Plugin
-
2
Assignment
2
Assignment
- Practice Quiz: Refining Your Results
- Graded Quiz: Refining Your Results
1
External Tool
- Hands-on Lab: String Patterns, Sorting and Grouping
3
Videos
- Using String Patterns and Ranges
- Sorting Result Sets
- Grouping Result Sets
1
Readings
- Summary: Refining Your Results
Functions, Multiple Tables, and Sub-queries
-
4
Videos
-
1
Readings
-
3
ExternalTool
-
4
Plugin
-
2
Assignment
2
Assignment
- Practice Quiz: Functions, Multiple Tables, and Sub-queries
- Graded Quiz: Functions, Multiple Tables, and Sub-Queries
3
External Tool
- Hands-on Lab: Built-in functions
- Hands-on Lab: Sub-queries and Nested SELECTs
- Hands-on Lab: Working with Multiple Tables
4
Videos
- Built-in Database Functions
- Date and Time Built-in Functions
- Sub-Queries and Nested Selects
- Working with Multiple Tables
1
Readings
- Summary: Functions, Multiple Tables, and Sub-queries
[Optional] Using IBM Db2
-
2
Readings
2
Readings
- About this Optional Lesson
- [Optional] Hands-on Lab Using IBM Db2
R and Relational Databases
-
5
Videos
-
1
Readings
-
1
ExternalTool
-
1
Plugin
-
2
Assignment
2
Assignment
- Practice Quiz: R and Relational Databases
- Graded Quiz: R and Relational Databases
1
External Tool
- Hands-on Lab: Review using Jupyter and R Dataframes
5
Videos
- Why use R with Relational Databases
- R Persistence Options
- Terminology Comparison
- Mapping Data between R and RDBMS
- Database Design Considerations
1
Readings
- Summary & Highlights: R and Relational Databases
Connecting to Databases from R
-
5
Videos
-
1
Readings
-
2
ExternalTool
-
3
Plugin
-
2
Assignment
2
Assignment
- Practice Quiz: Connecting to Databases from R
- Graded Quiz: Connecting to Databases from R
2
External Tool
- Hands-on Lab: Accessing Your Database using RJDBC
- Hands-on Lab: Accessing Your Database with RSQLite
5
Videos
- Connectivity Options
- Connecting with RJDBC
- Connectivity using ODBC
- RODBC in Detail
- Metadata Discovery
1
Readings
- Summary & Highlights : Connecting to Databases from R
[Optional] Using IBM Db2
-
1
Readings
-
2
ExternalTool
-
1
Plugin
2
External Tool
- [Optional] Hands-on Lab: Accessing Your Database using RJDBC with DB2
- [Optional] Hands-on Lab: Accessing your Database using RODBC with DB2
1
Readings
- About this Optional Lesson
Creating Database Objects and Querying Data from R
-
6
Videos
-
1
Readings
-
1
ExternalTool
-
2
Plugin
-
2
Assignment
2
Assignment
- Practice Quiz: Working with Database Objects using R
- Graded Quiz: Working with Database Objects using R
1
External Tool
- Hands-on Lab: Creating and Querying Database Objects from R using RSQLite with SQLite
6
Videos
- Working with Data
- Database Design and Data Preparation
- Creating Physical Database Objects
- Loading the Data
- Querying Data (SQL SELECT)
- Analyzing the Data
1
Readings
- Summary and Highlights: Working with Database Objects using R
[Optional] Using IBM Db2
-
1
Readings
-
1
ExternalTool
1
External Tool
- [Optional] Hands-on Lab: Creating and Querying Database Objects from R using RODBC with DB2
1
Readings
- About this Optional Lesson
Assignment Preparation
-
2
ExternalTool
2
External Tool
- Hands-on Lab: Practice Querying Real World Datasets using RSQLite with SQLite
- [Optional] Hands-on Lab: Practice Querying Real World Datasets using RODBC with DB2
Final Project
-
1
PeerReview
-
2
ExternalTool
-
1
Plugin
2
External Tool
- Jupyter Notebook with Problems for Peer Reviewed Assignment using RSQLite with SQLite
- [Optional] Jupyter Notebook with Problems for Peer Reviewed Assignment using RODBC with DB2
1
Peer Review
- Peer Review: Submit your Work and Review your Peers
Final Exam
-
1
Assignment
1
Assignment
- Final Exam
Course Wrap-up
-
1
Readings
1
Readings
- Congratulations & Next Steps
Auto Summary
"SQL for Data Science with R" is an engaging course designed to introduce you to relational database concepts, SQL, and R, with a focus on hands-on, practical learning. Ideal for aspiring data scientists, this foundational course requires no prior knowledge and allows you to work with real databases and data science tools. Taught by an expert instructor on Coursera, it spans 1680 minutes and offers both Starter and Professional subscription options. Earn a Coursera certificate and an IBM digital badge upon completion. Perfect for beginners aiming to excel in data science.
Rav Ahuja