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

  • December 6, 2024
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.