EdX

SQL Concepts for Data Engineers (edX)

Offered by IBM,
SQL Concepts for Data Engineers (edX)

In this short course you will learn additional SQL concepts such as views, stored procedures, transactions and joins. This course builds on your existing SQL knowledge to learn about additional techniques that are key to Data Engineers.

Class Deals by MOOC List - Click here and see EdX's Active Discounts, Deals, and Promo Codes.

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.
This course is part of the following programs:

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

Syllabus

Module 1 – Additional SQL

  • Using Views
  • Stored Procedures
  • Transactions
  • JOINs
Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

Advanced Database Queries (edX) EdX
New York University,NYUx

Advanced Database Queries (edX)

Computer Science

Learn the fundamentals of interacting with relational database management systems, including issuing advanced queries that return complicated results sets. This course is a continuation of the basic concepts, organization, and implementation models taught in the Introduction to Databases course, with an emphasis on the relational model. Among the topics covered are the development of advanced queries that utilize aggregation, subqueries and built-in functions.

Self Paced
Self-Paced
Databases SQL Queries
Details
Data Warehousing and BI Analytics (edX) EdX
IBM

Data Warehousing and BI Analytics (edX)

Engineering

This course introduces you to designing, implementing and populating a data warehouse and analyzing its data using SQL & Business Intelligence (BI) tools. Today’s businesses are investing significantly in capabilities to harness the massive amounts of data that fuel Business Intelligence (BI). Working knowledge of Data Warehouses and BI Analytics tools are a crucial skill for Data Engineers, Data Warehousing Specialists and BI Analysts, making who are amongst, the most valued resources for organizations.

Self Paced
Self-Paced
SQL Analytics Business Intelligence
Details
Python Basics for Data Science (edX) EdX
IBM

Python Basics for Data Science (edX)

Statistics & Data Analysis CS: Programming

This Python course provides a beginner-friendly introduction to Python for Data Science. Practice through lab exercises, and you'll be ready to create your first Python scripts on your own! Kickstart your learning of Python for data science, as well as programming in general with this introduction to Python course. This beginner-friendly Python course will quickly take you from zero to programming in Python in a matter of hours and give you a taste of how to start working with data in Python.

Self Paced
Self-Paced
Python Data Science Python Programming
Details
SQL for Data Science (edX) EdX
IBM

SQL for Data Science (edX)

Statistics & Data Analysis Data Science

Learn how to use and apply the powerful language of SQL to better communicate and extract data from databases - a must for anyone working in the data science field. Much of the world's data lives in databases. SQL (or Structured Query Language) is a powerful programming language that is used for communicating with and extracting various data types from databases.

Self Paced
Self-Paced
Python Databases SQL
Details
Introduction to Database Queries (edX) EdX
New York University,NYUx

Introduction to Database Queries (edX)

Computer Science

Learn the fundamentals of interacting with relational database management systems, including issuing queries that return results sets and modify data. This course is an introduction to the basic concepts, organization, and implementation models of databases, with an emphasis on the relational model.

Self Paced
Self-Paced
Databases SQL Queries
Details