SQL Concepts for Data Engineers
About this Course
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.Created by: IBM
Level: Intermediate
Related Online Courses
What do you know about TinyML? Tiny Machine Learning (TinyML) is one of the fastest-growing areas of Deep Learning and is rapidly becoming more accessible. This course provides a foundation for you... more
A majority of the world's data resides in databases. SQL (or Structured Query Language) is a powerful language for communicating with and extracting data from databases. A working knowledge of... more
This introductory Excel course will equip you with a strong foundational knowledge of Excel to organize, analyze and work with data. You will develop essential Excel skills, such as simple data... more
To become an expert data scientist you need practice and experience. By completing this capstone project you will get an opportunity to apply the knowledge and skills in R data analysis that you... more
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 thi... more
Powered by
