Back to Catalog

Advanced SQL for Data Engineers

Premium
IntermediateCourse

Learn key SQL concepts like views, stored procedures, transactions, and JOINs to help you work more efficiently with databases.

Language

  • English

Topic

  • Data Analysis

Skills You Will Learn

  • SQL, Views, ACID, JOIN, Querying Databases, Data Engineering

Offered By

  • IBMSkillsNetwork

Estimated Effort

  • 6 Hours

Platform

  • SkillsNetwork

Last Update

  • October 3, 2025
About this Course
This course expands on your existing SQL skills, focusing on essential techniques crucial for Data Engineers. 

You'll learn how to create and use database views to simplify complex queries and control access to underlying tables, enhancing both security and performance. Discover the advantages of stored procedures, and learn how to write and execute them effectively to automate tasks, reduce network traffic, and improve execution speed. 
  
You will understand the importance of ACID transactions for maintaining data integrity. You'll learn how to implement transactions in your code to ensure reliable and consistent database operations. You’ll also master different types of JOIN operations to accurately retrieve related data from multiple tables, enabling efficient data analysis and reporting. 
  
By the end of this course, you'll have a deeper understanding of advanced SQL concepts that are essential for optimizing database management and enhancing your data engineering capabilities.

What you will learn:

  • Design and Implement Database Views   
  • Develop and Run Stored Procedures   
  • Manage ACID-Compliant Transactions 
  • Perform Multi-Table Queries with JOIN Operators

Course Syllabus

Welcome 
  • Introduction to Advanced SQL for Data Engineering 
  • General Information 
  • Syllabus 
  • Grading Scheme 
Module 1 - Advanced SQL for Data Engineers 
  • Video: Views (3:44) 
  • Video: Stored Procedures (3:43) 
  • Hands-on Lab: Stored Procedures 
  • Video: ACID Transactions (3:47) 
  • Hands-on Lab: Committing and Rolling Back a Transaction 
  • [Optional] Hands-on Labs Using IBM Db2 
  • Summary:  Views, Stored Procedures, and Transactions 
  • Practice Quiz:  Views, Stored Procedures, and Transactions 
  • SQL Cheat Sheet: Views, Stored Procedures and Transactions 
Module 2 - JOIN Statements 
  • Video: Join Overview (4:06) 
  • Video: Inner Join (2:43) 
  • Hands-on Lab: Joins 
  • Summary: JOIN Statements 
  • Practice Quiz: Join Statements 
  • SQL Cheat Sheet: JOIN Statements 
Module 3 - Quiz and Assignment for Advanced SQL 
  • Graded Quiz: Views, Stored Procedures and Transactions  
  • Graded Quiz: JOIN Statements 
  • Hands-on Lab: Final Project: Advanced SQL Techniques 
  • Final Exam: Advanced SQL for Data Engineers  
Course Rating 
  • Course Rating and Feedback  
Badge 
  • Claim your Badge

General Information

  • This course is self-paced. 
This platform works best with current versions of Chrome, Edge, Firefox, Internet Explorer, or Safari. 

Recommended Skills Prior to Taking this Course

Basic computer skills. 

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