Back to Catalog

SQL Fundamentals with Python

Premium
Intermediatecourse

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.

Language

  • English

Topic

  • Database

Industries

  • Information Technology

Skills You Will Learn

  • Python, SQL, Databases, Cloud Databases, Relational Databases

Offered By

  • IBMSkillsNetwork

Estimated Effort

  • 20 Hours

Platform

  • SkillsNetwork

Last Update

  • October 16, 2024
About this course
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.

Instructors

Rav Ahuja

Global Program Director, IBM Skills Network

Rav Ahuja is a Global Program Director at IBM. He leads growth strategy, curriculum creation, and partner programs for the IBM Skills Network. Rav co-founded Cognitive Class, an IBM led initiative to democratize skills for in demand technologies. He is based out of the IBM Canada Lab in Toronto and specializes in instructional solutions for AI, Data, Software Engineering and Cloud. Rav presents at events worldwide and has authored numerous papers, articles, books and courses on subjects in managing and analyzing data. Rav holds B. Eng. from McGill University and MBA from University of Western Ontario.

Read more

Contributors

Abhishek Gagneja

Freelance Subject Matter Expert

I am a lifelong learner with more than a decade of teaching experience at university level. I am an AI enthusiast and love learning new things.

Read more