IBM - Databases and SQL for Data Science with Python
4.6 /5- Offered byCoursera
- Public/Government Institute
Databases and SQL for Data Science with Python at Coursera Overview
Duration | 37 hours |
Total fee | Free |
Mode of learning | Online |
Difficulty level | Beginner |
Official Website | Explore Free Course  |
Credential | Certificate |
- Overview
- Highlights
- Course Details
- Curriculum
- Faculty
- + 1 more item
Databases and SQL for Data Science with Python at Coursera Highlights
- Earn a certificate of completion from IBM
Databases and SQL for Data Science with Python at Coursera Course details
- Analyze data within a database using SQL and Python
- Create a relational database on Cloud and work with tables
- Compare and contrast DDL to DML
- Write SQL statements including SELECT, INSERT, UPDATE, and DELETE
- The purpose of this course is to introduce relational database concepts and help you learn and apply foundational knowledge of the SQL language
- It is also intended to get you started with performing SQL access in a data science environment
- You will work with real databases, real data science tools, and real-world datasets
- You will also learn how to access databases from Jupyter notebooks using SQL and Python
Databases and SQL for Data Science with Python at Coursera Curriculum
Getting Started with SQL
Welcome to SQL for Data Science
Introduction to Databases
SELECT Statement
COUNT, DISTINCT, LIMIT
INSERT Statement
UPDATE and DELETE Statements
Introduction to Relational Databases and Tables
Relational Database Concepts
How to create a Database instance on Cloud
Types of SQL statements (DDL vs. DML)
CREATE TABLE Statement
ALTER, DROP, and Truncate tables
Intermediate SQL
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
Accessing Databases using Python
How to Access Databases Using Python
Writing code using DB-API
Connecting to a database using ibm_db API
Creating tables, loading data and querying data
Analyzing data with Python
Course Assignment
Working with Real World Datasets
Getting Table and Column Details
Bonus Module: Advanced SQL for Data Engineering (Honors)
Views
Stored Procedures
ACID Transactions
Join Overview
Inner Join
Outer Joins
Databases and SQL for Data Science with Python at Coursera Faculty details
Other courses offered by Coursera
Student Forum
Anything you would want to ask experts?
Databases and SQL for Data Science with Python at Coursera News & Updates
