IBM - Institute of Business Management - Databases and SQL for Data Science with Python

Offered byCoursera

Databases and SQL for Data Science with Python
at
Coursera
Overview

Gain the ability to handle large datasets, optimize queries, and perform data analysis tasks crucial for data-driven decision-making

Duration	3 months
Start from	Start Now
Mode of learning	Online
Difficulty level	Beginner
Official Website	Go to Website
Credential	Certificate

Databases and SQL for Data Science with Python
at
Coursera
Highlights

Earn a certificate after completion of the course
Financial aid facility available
Assignment for better practice

Databases and SQL for Data Science with Python
at
Coursera
Course details

Who should do this course?

Aspiring Data Scientists

Data Analysts

Software Developers

Business Analysts

What are the course deliverables?

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

More about this course

This course provides a comprehensive introduction to databases and SQL, focusing on their application in data science

It is designed to equip students with the skills needed to interact with databases, perform complex queries, and integrate database operations with Python programming for efficient data analysis

Participants will learn to manage and manipulate data effectively, enabling them to derive meaningful insights and make data-driven decisions

Databases and SQL for Data Science with Python
at
Coursera
Curriculum

Getting Started with SQL

learn how to use basic SQL statements like SELECT, INSERT, UPDATE and DELETE

Introduction to Relational Databases and Tables

Understand the process of creating a table in your database on MySQL using the graphical interface and SQL scripts

Intermediate SQL

Learn how to use string patterns and ranges to search data and how to sort and group data in result sets

Accessing Databases using Python

Learn the basic concepts of using Python to connect to databases

Course Assignment

You will be working with multiple real-world datasets for the city of Chicago

Bonus Module: Advanced SQL for Data Engineer (Honors)

Learn how to build more powerful queries with advanced SQL techniques like views, transactions, stored procedures, and joins

Databases and SQL for Data Science with Python
at
Coursera
Faculty details

Rav Ahuja

Rav Ahuja is a Global Program Director at IBM. Rav leads growth strategy, curriculum creation, and partner programs for the IBM Skills Network. He is the architect for the IBM Data Science Professional Certificate and instructor for the Databases & SQL for Data Science course on Coursera. Rav co-founded Cognitive Class, an IBM led initiative to democratize skills for in demand technologies

Hima Vasudevan

Hima Vasudevan is a Data Scientist in the Digital Business Group at IBM. She is part of the Cognitive Class team and focuses on creating skills offerings and deliver learning curriculum for the Data Science and Data Engineering professions. Hima joined IBM in 2016 as an Analytics Data Scientist Intern and worked on a data mining project to predict power outages related to storms using IBM SPSS Modeler