Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Online Course

Databases and SQL for Data Science

IBM via Coursera

Overview

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.

Syllabus

Week 1 - Introduction to Databases and Basic SQL
-In Week 1 you will be introduced to databases. You will create a database instance on the cloud. You will learn some of the basic SQL statements. You will also write and practice basic SQL hands-on on a live database.

Week 2 - Advanced SQL
-By the end of this module, you will be able to: (1) Utilize string patterns and ranges to search data and how to sort and group data in result sets. (2) Compose nested queries and execute select statements to access data from multiple tables .

Week 3 - Accessing Databases using Python
-After completing the lessons in this week, you will learn how to explain the basic concepts related to using Python to connect to databases and then create tables, load data, query data using SQL, and analyze data using Python

Week 4: Course Assignment
-As a hands-on Data Science assignment, you will be working with multiple real world datasets for the city of Chicago. You will be asked questions that will help you understand the data just like a data scientist would. You will be assessed both on the correctness of your SQL queries and results.



Taught by

Rav Ahuja and Hima Vasudevan

Tags

Related Courses

Reviews

2.0 rating, based on 1 reviews

Start your review of Databases and SQL for Data Science

  • Profile image for Kurp
    Kurp

    Kurp completed this course, spending 5 hours a week on it and found the course difficulty to be easy.

    One of the courses you're not sure what they try to achieve. If you know SQL a bit, you'll probably find nothing interesting here. If you don't know - I don't think it's a good place to start.

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free