Explore

Databases and SQL for Data Science with Python

Approx. 18 hours to complete

Save Course

Go to Course

Course Summary

Learn how to use SQL for data science in this comprehensive course. From querying and manipulating data to joining tables and analyzing data trends, this course covers all the essential SQL skills for data analysis.

Key Learning Points

Understand the principles of SQL and how to use it for data science
Learn how to query and manipulate data using SQL
Master the art of joining tables and analyzing data trends

Learning Outcomes

Ability to use SQL for data analysis and manipulation
Understanding of how to join tables and analyze data trends
Proficiency in data visualization techniques

Prerequisites or good to have knowledge before taking this course

Basic knowledge of programming concepts
Familiarity with databases and data structures

Course Difficulty Level

Intermediate

Course Format

Online
Self-paced
Video lectures
Hands-on exercises

Similar Courses

Python for Data Science
Data Visualization with Tableau
Big Data Essentials: Hadoop and Spark

Related Education Paths

Notable People in This Field

Statistician
Data Scientist

Related Books

Description

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 language. 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 Python. No prior knowledge of databases, SQL, Python, 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. LIMITED TIME OFFER: Subscription is only $39 USD per month for access to graded materials and a certificate.

Knowledge

Create and access a database instance on cloud
Write basic SQL statements: CREATE, DROP, SELECT, INSERT, UPDATE, DELETE
Filter, sort, group results, use built-in functions, access multiple tables
Access databases from Jupyter using Python and work with real world datasets

Outline

Getting Started with SQL
Welcome to SQL for Data Science
Introduction to Databases
SELECT Statement
COUNT, DISTINCT, LIMIT
INSERT Statement
UPDATE and DELETE Statements
Summary & Highlights
Practice Quiz
Graded Quiz: Basic SQL

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
Summary & Highlights
Practice Quiz
Graded Quiz: Relational DB Concepts and 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
Summary & Highlights
Summary & Highlights
Practice Quiz
Graded Quiz: Refining Your Results
Practice Quiz
Graded Quiz: Functions, Sub-Queries, 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
Summary & Highlights
Practice Quiz
Graded Quiz: Database access from Python

Course Assignment
Working with Real World Datasets
Getting Table and Column Details
Congratulations & Next Steps
Final Exam

Bonus Module: Advanced SQL for Data Engineering (Honors)
Views
Stored Procedures
ACID Transactions
Join Overview
Inner Join
Outer Joins
About this Honors module
Summary & Highlights
Summary & Highlights
Practice Quiz
Practice Quiz
Graded Quiz: Views, Stored Procedures and Transactions
Graded Quiz: JOIN operations

Summary of User Reviews

The SQL for Data Science course on Coursera has received positive reviews from many users. The course is highly recommended for beginners who want to learn SQL for data analysis. One key aspect that users appreciated was the instructor's clear and concise teaching style.

Pros from User Reviews

The course is well-structured and easy to follow.
The instructor provides clear explanations and examples.
The course covers a wide range of topics related to SQL for data science.
The assignments and quizzes are helpful for reinforcing the concepts learned in the course.

Cons from User Reviews

Some users found the course to be too basic and not challenging enough.
The course can be repetitive at times, covering similar concepts in multiple modules.
The course does not provide much hands-on practice with real datasets.
The course does not cover advanced SQL topics, such as stored procedures or triggers.
The discussion forums can be disorganized and difficult to navigate.

Recommended for you

Programming for Data Science with Python

The Programming for Data Science with Python Nanodegree program offers you the opportunity to learn the most important programming languages used by data scientists today....

Save Course

SQL Masterclass: SQL for Data Analytics

SQL course covering basic to advanced SQL topics for SQL Database ( PostgreSQL ). Elucidates SQL Database for beginners 6 Reasons why you should choose this SQL course...

Save Course