Offered By: IBMSkillsNetwork
SQL Fundamentals with Python
Learn the power behind data manipulation for data sets stored in relational databases using SQL or structured query language – a fundamental skill for anyone in the data sciences.
Continue readingCourse
Database
At a Glance
Learn the power behind data manipulation for data sets stored in relational databases using SQL or structured query language – a fundamental skill for anyone in the data sciences.
Anyone working in data science requires SQL skills. This fundamental skill allows you to find and extract the data you need in your analyses. This course introduces you to relational database concepts and how to query these databases using SQL so you can obtain the data you need. The course also teaches you how to use SQL in a data science environment.
The many labs and projects in this course emphasize a hands-on approach so you finish the course with practical, applicable skills. After taking this course you can showcase your new SQL skills with the tangible assets from these labs and project to showcase potential employers.
Learning Objectives
- Execute basic SQL queries using SELECT, INSERT, UPDATE, and DELETE
- Use string patterns and ranges to query and filter data
- Sort and group data in result sets
- Query multiple tables and compose nested SELECT statements and sub-queries
- Analyze data in a database using Python and Jupyter Notebooks
- You do not need prior knowledge of relational databases, SQL, Python, or programming for success in this course.
Course Syllabus
Week 1: Getting Started with SQL
This week will let you learn the basics of SQL and databases. You will also learn how to query tables in a database.
Week 2: Introduction to Relational Databases and Tables
This week is all about relational databases, creating tables, and modifying their contents.
Week 3: Intermediate SQL
In this module, you will learn more about different types of SQL queries, functions, string patterns, grouping, and sorting.
Week 4: Accessing Databases with Python
This week, you will learn the nuances of accessing databases using Python libraries and SQL magic in Jupyter Notebooks.
Week 5: Course Assignment
This week is designed to give you an understanding of how to deal with real-world datasets and complete an assignment which tests your skills acquired throughout the course.
Recommended Skills Prior to Taking this Course
Estimated Effort
20 Hours
Level
Intermediate
Industries
Information Technology
Skills You Will Learn
Cloud Databases, Databases, Python, Relational Databases, SQL
Language
English
Course Code
DB0201EN