Course description
SQL Concepts for Data Engineers
This course builds on your existing SQL knowledge to learn about additional techniques that are key to Data Engineers.
You will learn how to create and use views to simplify and control access to underlying tables. You will learn about the advantages provided by stored procedures and how to write and run them. You will discover the importance of ACID transactions to maintain the integrity of your data and how to use them in your code. Finally, you will learn how to use different types of joins to accurately retrieve related data from multiple tables.
PRE-REQUISITE: This course is intended as a follow on to SQL for Data Science course from IBM. Please ensure that you have either completed that course prior to starting this one, or have foundational/intermediate knowledge of SQL and are familiar with creating tables, performing select statements, filtering, sorting and grouping data, and working with nested queries and multiple tables.
Upcoming start dates
Who should attend?
Prerequisites
None
Training content
Module 1 – Additional SQL
- Using Views
- Stored Procedures
- Transactions
- JOINs
Course delivery details
This course is offered through IBM, a partner institute of EdX.
4–5 hours per week
Costs
- Verified Track -$99
- Audit Track - Free
Certification / Credits
What you'll learn
In this course you will learn about:
- Creating and using views
- Creating and executing stored procedures
- Working with ACID transactions
- Using different types of JOIN operators
Contact this provider
edX
edX For Business helps leading companies upskill their labor forces by making the world’s greatest educational resources available to learners across a wide variety of in-demand fields. edX For Business delivers high-quality corporate eLearning to train and engage your employees...