Hi, 
SQL Fundamentals with Python
Course
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.
Flexible Schedule
Intermediate Level
Mentor Support
Estimated Time
20 hours
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.
This course comprises five purposely designed modules that take you on a carefully defined learning journey.
It is a self-paced course, which means it is not run to a fixed schedule with regard to completing modules. It is anticipated that you will complete the course in 20 hours. However, as long as the course is completed by the end of your enrollment, you can work at your own pace. And dont worry, youre not alone! You will be encouraged to stay connected with your learning community through the course discussion space.
The materials for each module are accessible from the start of the course and will remain available for the duration of your enrollment. Methods of learning and assessment will include discussion space, videos, reading material, quizzes, hands-on labs, quizzes and final assignment.
Once you have successfully completed the course, you will earn your IBM Certificate.
You will be able to:
- 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.
- Beginners in programming
- Aspiring data analysts & data scientists
- No prior knowledge of databases, SQL, Python, or programming is required.
- Suitable for anyone who wants to gain key skills in data science/analytics.
Course Outline
Video: Welcome to SQL for Data Science (3:21)
General Information
Learning Objectives and Syllabus
Grading Scheme
Module Introduction & Learning Objectives (1m)
Video: Introduction to SQL, Database, and DBMS (3:41)
Video: SELECT Statement (3:38)
Reading: SELECT Statement Examples
Hands-on Lab: Simple SELECT Statements
Video: COUNT, DISTINCT, LIMIT (2:28)
Hands-on Lab: COUNT, DISTINCT, LIMIT
Video: INSERT Statement (2:39)
Video: UPDATE and DELETE Statements (3:14)
Hands-on Lab: INSERT, UPDATE, and DELETE
Summary: Basic SQL
Practice Quiz: Basic SQL
SQL Cheat Sheet: Basics - SELECT, INSERT, UPDATE, DELETE, COUNT, DISTINCT, LIMIT
Graded Quiz: Basic SQL (5 Questions)
Module Introduction & Learning Objectives (1m)
Video: Relational Database Concepts (5:32)
Video: Types of SQL Statements (DDL vs. DML) (2:25)
Video: CREATE TABLE Statement (3:59)
Video: ALTER, DROP, and TRUNCATE Tables (4:15)
Reading: Examples to ALTER and TRUNCATE Tables using MySQL
Reading: Examples to CREATE and DROP Tables
Hands-on Lab : CREATE, ALTER, TRUNCATE, DROP
Reading: SQL Scripts - Uses and Applications
Hands-on Lab: Create and Load Tables Using SQL Scripts
Summary: Relational Database Concepts and Tables
Practice Quiz: Introduction to Relational Databases and Tables
SQL Cheat Sheet: CREATE TABLE, ALTER, DROP, TRUNCATE
Graded Quiz: Relational DB Concepts and Tables (5 Questions)
Video: [Optional] How to create a Database Instance on Cloud (5:51)
[Optional] Obtain IBM Cloud Feature Code and Activate Trial Account
Reading: [Optional] Hands-on Lab Using IBM Db2
Module Introduction & Learning Objectives (1m)
Video: Using String Patterns and Ranges (4:25)
Video: Sorting Result Sets (2:46)
Hands-on Lab: String Patterns, Sorting and Grouping
Reading: [Optional] Hands-on Labs Using IBM Db2
Summary: Refining Your Results
Practice Quiz: Refining Your Results
SQL Cheat Sheet: Intermediate - LIKE, ORDER BY, GROUP BY
Graded Quiz: Refining Your Results (5 Questions)
Graded Quiz
Video: Built-in Database Functions (6:11), Incomplete7 min7 minutes
Video: Date and Time Built-in Functions (3:07)
Hands-on Lab: Built-in Functions
Video: Sub-Queries and Nested Selects (4:44)
Hands-on Lab: Sub-Queries and Nested Selects
Video: Working with Multiple Tables (6:24), Incomplete7 min7 minutes
Hands-on Lab: Working with Multiple Tables
Summary: Functions, Multiple Tables, and Sub-queries
Practice Quiz: Functions, Multiple Tables, and Sub-queries
SQL Cheat Sheet: FUNCTIONS and Implicit JOIN
Graded Quiz: Functions, Multiple Tables, and Sub-queries (5 Questions)
Module Introduction & Learning Objectives (1m)
Video: How to Access Databases Using Python (6:00), Incomplete7 min7 minutes
Video: Writing Code Using DB-API (5:35)
Hands-on Lab: Creating Tables, Inserting and Querying Data
Video: Accessing Databases with SQL Magic (6:03), Incomplete7 min7 minutes
Hands-on Tutorial: Accessing Databases with SQL Magic
Video: Analyzing Data with Python (9:38), Incomplete10 min10 minutes
Hands-on Lab: Analyzing a Real-World Data Set
Summary: Accessing Databases Using Python
Practice Quiz: Accessing Databases Using Python
SQL Cheat Sheet: Accessing Databases Using Python
Graded Quiz: Accessing Databases Using Python (5 Questions)
Reading: [Optional] Hands-on Labs Using IBM Db2
Video: [Optional] Connecting to a Database Using ibm_db API (2:10)
Hands-on Lab: [Optional] Db2 Lab: Connecting to a Database Instance
Video: [Optional] Creating Tables, Loading Data and Querying Data (3:54)
Hands-on Lab: [Optional] Db2 Lab: Creating Tables, inserting and querying Data
Hand-on Lab: [Optional] Db2 Lab: Tutorial, Accessing Databases with SQL Magic
Hands-on Lab: [Optional] Db2 Lab: Analyzing a Real-World Data Set
Module Introduction & Learning Objectives
Video: Working with Real World Data Sets (5:52)
Video: Getting Table and Column Details (2:24)
Hands-on Lab: Working with a Real-World Data Set Summary and Highlights
Reading: [Optional] Hands-on Labs Using IBM Db2
Hands-on Lab: [Optional] Practice Querying Real World Data Sets
Final Lab: Assignment Based on SQLite
Final Assignment Based on Final Lab (10 Questions)
Final Exam (10 Questions)
Reading: Congratulations & Next Steps
Why Learn with SkillUp Online?
We believe every learner is an individual and every course is an opportunity to build job-ready skills. Through our human-centered approach to learning, we will empower you to fulfil your professional and personal goals and enjoy career success.
Reskilling into tech? We’ll support you.
Upskilling for promotion? We’ll help you.
Cross-skilling for your career? We’ll guide you.
Personalized Mentoring & Support
1-on-1 mentoring, live classes, webinars, weekly feedback, peer discussion, and much more.
Practical Experience
Hands-on labs and projects tackling real-world challenges. Great for your resumé and LinkedIn profile.
Best-in-Class Course Content
Designed by the industry for the industry so you can build job-ready skills.
Job-Ready Skills Focus
Competency building and global certifications employers are actively looking for.
FAQs
You will learn to execute SQL queries to extract, manipulate, and analyze data stored in relational databases. The course covers SELECT, INSERT, UPDATE, DELETE queries, string patterns, sorting, grouping, and querying multiple tables. Youll also use Python and Jupyter Notebooks to integrate SQL with data analysis workflows.
No prior experience is required. This course is designed for beginners who want to gain practical skills in SQL with Python for data analysis.
Youll learn the fundamentals of relational databases, including creating and modifying tables, understanding relationships, and querying structured data effectively.
Yes, the course provides hands-on practice with all these essential SQL commands to manipulate and manage database records.
Absolutely. The course covers joining tables, composing nested SELECT statements, and creating sub-queries to handle complex data retrieval tasks.
You will use Python and Jupyter Notebooks to connect to databases, execute queries, and analyze data, bridging SQL with practical Python-based data analysis workflows.
Yes, the course is highly hands-on, with labs and a final assignment designed to give you real-world experience in SQL and Python data analysis.
Youll work with real-world datasets stored in relational databases, helping you practice querying, cleaning, and analyzing data effectively.
Yes, the course emphasizes practical skills in filtering, sorting, and grouping data to make your analysis accurate and meaningful.
The course is structured over 5 weeks, with each week focusing on specific topics from SQL basics to Python integration and a final hands-on assignment.
Yes, it is ideal for anyone aiming for a career in data analytics, data science, or business intelligence who wants to learn SQL with Python.
Yes, the practical projects and labs provide you with tangible skills and portfolio assets you can showcase to employers.
Yes, you will learn to filter and query data using string patterns, ranges, and other techniques to refine your data analysis.
Yes, upon successful completion, you will receive an industry-recognized IBM Certificate that validates your skills in SQL with Python.
This course combines SQL fundamentals with Python integration, hands-on labs, real-world datasets, and a final project, making it highly practical and career-oriented compared to other beginner SQL courses.
Yes. After completing these SQL and Python certifications online, you can pursue recognized certifications to validate your skills. For Python, consider PCEP or PCAP from the Python Institute, or Microsofts Python Development Professional Certificate. For SQL, popular options include the Microsoft SQL Server Professional Certificate, Azure Database Administrator (DP-300), or Oracle Database SQL Certified Associate. Choose based on your career goalanalytics, development, or database administration.
Type of certificate
IBM Certificate
About this course
05 Modules
05 Skills
Includes
Discussion space
20 Hands-on labs
05 Practice quizzes
05 Graded quizzes
01 Final exam
01 Final project
Create
Tables
Built-in Functions
Inserting and Querying Data
Exercises to explore
Getting Started with SQL
Relational Databases and Tables
IBM Db2
Accessing Databases with SQL Magic
Analyzing data
This course has been created by
Newsletters & Updates
Subscribe to get the latest tech career trends, guidance, and tips in your inbox.