SQL Concepts for Data Engineers
Data Engineering Fundamentals,
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'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
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 1 weeks |
| Effort | 1 weeks, 4–5 hours per week |
| Starts | On Demand (Start anytime) |
| Cost | $99 |
| From | IBM via edX |
| Instructor | Rav Ahuja |
| Download Videos | On all desktop and mobile devices |
| Language | English |
| Subjects | Data Science |
| Tags | Data Analysis & Statistics |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Knowledge Technician $50k
Check, Please! Host $61k
Professional-Data Analysis - SQL $63k
Knowledge Strategist $73k
Many different sales & marketing positions $80k
Project Manager/ Different Appointment $101k
Knowledge Broker $102k
SQL Programmer - Data Analyst $105k
SQL Data Architect $108k
SQL Data Analyst 2 $123k
SQL Server DBA / Data Analyst $135k
SQL Developer / Data Modeler $144k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 1 weeks |
| Effort | 1 weeks, 4–5 hours per week |
| Starts | On Demand (Start anytime) |
| Cost | $99 |
| From | IBM via edX |
| Instructor | Rav Ahuja |
| Download Videos | On all desktop and mobile devices |
| Language | English |
| Subjects | Data Science |
| Tags | Data Analysis & Statistics |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
