6.6.Bonus Module: Advanced SQL for Data Engineer - sj50179/IBM-Data-Science-Professional-Certificate GitHub Wiki

Learning Objectives

• Create and query view
• Create stored procedures and invoke them from other code
• Describe the benefits and disadvantages of using stored procedures
• Describe the benefits that views provide
• Describe the significance of ACID transactions
• Explain how to use different types of JOIN operators
• Use joins to query data from multiple tables
• Use transactions in your SQL code

---