IBM: Databases and SQL for Data Science

INSTRUCTORS

Instructors: Rav Ahuja

Course Description

You will create new tables and be able to move data into them. You will learn common operators and how to combine the data. You will use case statements and concepts like data governance and profiling. You will discuss topics on data, and practice using real-world programming assignments. You will interpret the structure, meaning, and relationships in source data and use SQL as a professional to shape your data for targeted analysis purposes.

Topics include

Week 1 - Databases and SQL

• Explain SQL and Relational Databases
• Create a database instance on the Cloud
• Learn how to write SQL statements
• Practice SQL statements hands-on on a live database

Week 2 - Advanced SQL

• Explain how to use string patterns and ranges in SQL queries
• Demonstrate how to sort and order result sets
• Practice use of grouping data in result sets
• Employ Built-in functions in Queries
• Demonstrate how to write sub-queries and nested selects
• Build queries to access multiple tables

Week 3 - Accessing Databases using Python

• Describe concepts related to accessing Databases using Python
• Learn and Practice how to connect to a database from a Jupyter notebook
• Understand and demonstrate how to create tables and insert data from Python
• Write SQL queries and retrieve result sets from Python
• Practice how to perform simplified database access from Python using SQL magic
• Enumerate different type of JOIN operations
• Explain what is an INNER JOIN and practice hands-on
• Distinguish between different types of OUTER JOINs and apply your understanding

This course is part of the ‘IBM Data Science Professional Certificate’