SQL for Data Science with R by Coursera
This course is part of multiple programs.
Course Highlights
- 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 learn!
Curriculum
14 Topics
Welcome to SQL for Data Science
SELECT Statement
COUNT DISTINCT LIMIT
INSERT Statement
UPDATE and DELETE Statements
Course Overview
Module Summary: Getting Started with SQL
Practice Quiz: Getting Started with SQL
Graded Quiz: Getting Started with SQL
Hands-on Lab: Simple SELECT Statements
Hands-on Lab: COUNT DISTINCT LIMIT
Hands-on Lab: INSERT UPDATE and DELETE
SELECT statement examples
SQL Cheat Sheet: Basics - SELECT INSERT UPDATE DELETE COUNT DISTINCT LIMIT
16 Topics
Introduction to Databases
Relational Database Concepts
Types of SQL statements (DDL vs. DML)
CREATE TABLE Statement
ALTER DROP and Truncate tables
How to create a Database instance on Cloud
Module Summary: Introduction to Relational Databases and Tables
About this Optional Lesson
[Optional] Hands-on Lab Using IBM Db2
Practice Quiz: Introduction to Relational Databases and Tables
Graded Quiz: Introduction to Relational Databases and Tables
Hands-on Lab: CREATE ALTER TRUNCATE DROP into Tables in MySQL using phpMyAdmin
Hands-on Lab: Create and Load Tables using SQL Scripts
Obtain IBM Cloud Feature Code and Activate Trial Account
Examples to CREATE and DROP tables
SQL Cheat Sheet: CREATE TABLE ALTER DROP TRUNCATE
24 Topics
Using String Patterns and Ranges
Sorting Result Sets
Grouping Result Sets
Built-in Database Functions
Date and Time Built-in Functions
Sub-Queries and Nested Selects
Working with Multiple Tables
Summary: Refining Your Results
Summary: Functions Multiple Tables and Sub-queries
About this Optional Lesson
[Optional] Hands-on Lab Using IBM Db2
Practice Quiz: Refining Your Results
Practice Quiz: Functions Multiple Tables and Sub-queries
Graded Quiz: Refining Your Results
Graded Quiz: Functions Multiple Tables and Sub-Queries
Hands-on Lab: String Patterns Sorting and Grouping
Hands-on Lab: Built-in functions
Hands-on Lab: Sub-queries and Nested SELECTs
Hands-on Lab: Working with Multiple Tables
Reading: Examples for String Patterns Sorting and Grouping
Reading: Examples for Built-in Functions
Reading: Examples for Sub Queries and Nested Queries
Reading: Examples for Multiple Tables
SQL Cheat Sheet: Intermediate - LIKE ORDER BY GROUP BY
27 Topics
Why use R with Relational Databases
R Persistence Options
Terminology Comparison
Mapping Data between R and RDBMS
Database Design Considerations
Connectivity Options
Connecting with RJDBC
Connectivity using ODBC
RODBC in Detail
Metadata Discovery
Summary & Highlights: R and Relational Databases
Summary & Highlights : Connecting to Databases from R
About this Optional Lesson
Practice Quiz: R and Relational Databases
Practice Quiz: Connecting to Databases from R
Graded Quiz: R and Relational Databases
Graded Quiz: Connecting to Databases from R
Hands-on Lab: Review using Jupyter and R Dataframes
Hands-on Lab: Accessing Your Database using RJDBC
Hands-on Lab: Accessing Your Database with RSQLite
[Optional] Hands-on Lab: Accessing Your Database using RJDBC with DB2
[Optional] Hands-on Lab: Accessing your Database using RODBC with DB2
Cheat Sheet - R basics
Reading: Example for Connecting with RJDBC using SQLite
Reading: A Comprehensive Review of RSQLite
CheatSheet - Connecting to Databases using R
[Optional] Hands-on Lab: Create Db2 Service Credentials
14 Topics
Working with Data
Database Design and Data Preparation
Creating Physical Database Objects
Loading the Data
Querying Data (SQL SELECT)
Analyzing the Data
Summary and Highlights: Working with Database Objects using R
About this Optional Lesson
Practice Quiz: Working with Database Objects using R
Graded Quiz: Working with Database Objects using R
Hands-on Lab: Creating and Querying Database Objects from R using RSQLite with SQLite
[Optional] Hands-on Lab: Creating and Querying Database Objects from R using RODBC with DB2
Reading: Example for Creating and querying databases with SQLite using R
CheatSheet- Creating Database Objects & Querying Data from R
8 Topics
Congratulations & Next Steps
Final Exam
Peer Review: Submit your Work and Review your Peers
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
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
Final Peer-Graded Assignment Overview
SQL for Data Science with R
Related SQL Courses
Thank You!
Your review has been submitted successfully.