SQL Concepts for Data Engineers

عن

Please Note: Learners who successfully complete this IBM course can earn a skill badge " a detailed, verifiable and digital credential that profiles the knowledge and skills you've acquired in this course. Enroll to learn more, complete the course and claim your badge!

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.

What you will learn

• Create and use views
• Create and execute stored procedures
• Work with ACID transactions
• Query multiple tables using JOIN operators

Skills you learn

• Data Science
• Nested Queries
• Stored Procedure
• SQL (Programming Language)

Syllabus

Module 1 – Additional SQL

• Using Views

• Stored Procedures

• Transactions

• JOINs

Auto Summary

Enhance your data engineering skills with "SQL Concepts for Data Engineers" on edX. This 15-hour IT & Computer Science course, taught by expert instructors, delves into advanced SQL topics like views, stored procedures, transactions, and joins. Available with Starter and Professional subscription options, it's ideal for those seeking to deepen their SQL knowledge.