Databases and SQL for Data Science with Python

Instructor: Rav Ahuja , Hima Vasudevan

Beginner Level • Approx. 18 hours • Flexible Schedule

What You'll Learn

  • ✓Analyze data within a database using SQL and Python.
  • ✓Create a relational database and work with multiple tables using DDL commands.
  • ✓Construct basic to intermediate level SQL queries using DML commands.
  • ✓Compose more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins.

Skills You'll Gain

SQL
Relational Databases
Data analysis
Query Languages
Jupyter
Database Design
Data Manipulation
Databases
Pandas (Python Package)
Transaction Processing
Database Management
Stored Procedure

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate

There are 6 modules in this course

In this module, you will be introduced to databases. You will learn how to use basic SQL statements like SELECT, INSERT, UPDATE and DELETE. You will also get an understanding of how to refine your query results with the WHERE clause as well as using COUNT, LIMIT and DISTINCT.

In this module, you’ll learn more about relational database concepts and their importance. This module helps you to understand the process of creating a table in your database on MySQL using the graphical interface and SQL scripts. Further, you will also learn how to alter the entries or delete the entries for any table in the database, or even delete the table itself.

This module helps you learn how to use string patterns and ranges to search data and how to sort and group data in result sets. You will also practice composing nested queries and execute select statements to access data from multiple tables.

In this module you will learn the basic concepts of using Python to connect to databases. In a Jupyter Notebook, you will create tables, load data, query data using SQL magic and SQLite python library. You will also learn how to analyze data using Python.

In this module, 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 as you would in the real world. You will be assessed on the correctness of your SQL queries and results.

This module covers some advanced SQL techniques that will be useful for Data Engineers. In this module, you will learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins. If you are following the Data Engineering track, you must complete this module. Completion of this module is not required for those completing the Data Science or Data Analyst tracks.