New Banner :) TEST UPDATE Learn more

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 reading
Premium

Course

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.

The importance of data organization and manipulation in data science and related fields cannot be overstated. Learn the power behind data manipulation for data sets stored in relational databases using SQL or structured query language.  

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

In this course, you will 
  • 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

The course is structured into 5 weeks, each focusing on a specific topic. 
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

No prior knowledge of databases, SQL, Python, or programming is required. Suitable for anyone who wants to gain key skills in Data Science/Analytics.

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

Tell Your Friends!

Saved this page to your clipboard!

Stay Ahead in AI – Subscribe to Our Newsletter

Get latest insights, courses, and trends in AI and cognitive computing by joining our newsletter. Be the first to know about new learning opportunities, expert articles, and exclusive content.

Have questions or need support? Chat with me 😊