• Length:
    1 Weeks
  • Effort:
    4–5 hours per week
  • Price:

    FREE
    Add a Verified Certificate for $99 USD

  • Institution
  • Subject:
  • Level:
    Intermediate
  • Language:
    English
  • Video Transcript:
    English
  • Course Type:
    Self-paced on your time

Associated Programs:

About this course

Skip About this course

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

Skip 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

Module 1 – Additional SQL

  • Using Views

  • Stored Procedures

  • Transactions

  • JOINs

Meet your instructors

Rav Ahuja
AI and Data Science Program Director
IBM

Pursue a Verified Certificate to highlight the knowledge and skills you gain
$99 USD

View a PDF of a sample edX certificate
  • Official and Verified

    Receive an instructor-signed certificate with the institution's logo to verify your achievement and increase your job prospects

  • Easily Shareable

    Add the certificate to your CV or resume, or post it directly on LinkedIn

  • Proven Motivator

    Give yourself an additional incentive to complete the course

  • Support our Mission

    edX, a non-profit, relies on verified certificates to help fund free education for everyone globally