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

Django Application Development with SQL and Databases (edX) EdX
IBM

Django Application Development with SQL and Databases (edX)

Computer Science

This course introduces you to the basics of SQL, Django and Bootstrap. You will gain hands-on practical experience developing and deploying a full-stack Django web application on the cloud. This course introduces you to the basics of SQL, a simple and powerful programming language for querying and managing data, and the fundamentals of cloud databases. You will discover Object-Relational Mapping (ORM), and how to use Object-Oriented Programming (OOP) languages to work with databases.

Self Paced
Self-Paced
Databases SQL Bootstrap
Details
SQL for Everyone (edX) EdX
Southern New Hampshire University,SNHUx

SQL for Everyone (edX)

Statistics & Data Analysis CS: Programming

This course introduces relational database concepts and helps you learn and apply foundational knowledge of SQL. The emphasis in this course is on hands-on and practical learning. Structured Query Language (SQL) is a standardized programming language used to manage relational databases and perform various operations on their data. This is the first course of a two-part series to introduce relational database concepts and help you learn and apply foundational knowledge of SQL.

Self Paced
Self-Paced
Databases SQL Relational Databases
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
Introduction to SQL (edX) EdX
IBM

Introduction to SQL (edX)

Computer 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 Data Engineering, Data Analytics or Data Science. 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 manipulating data in databases.

Self Paced
Self-Paced
Databases SQL Programming Languages
Details
CS50's Introduction to Computer Science (edX) EdX
HarvardX,Harvard University

CS50's Introduction to Computer Science (edX)

CS: Programming Computer Science

An introduction to the intellectual enterprises of computer science and the art of programming. This is CS50, Harvard University's introduction to the intellectual enterprises of computer science and the art of programming for majors and non-majors alike, with or without prior programming experience. An entry-level course taught by David J. Malan, CS50 teaches students how to think algorithmically and solve problems efficiently.

Self Paced
Self-Paced
Programming Python C
Details
Structured Database Environments with SQL (edX) EdX
Southern New Hampshire University,SNHUx

Structured Database Environments with SQL (edX)

Statistics & Data Analysis

Discover Structured Query Language (SQL) programming basics in relation to database management and data manipulation. This course can provide you with an overview of topics like joins, database schemas, database design and importing data into a database. Develop the skills necessary to create structured database environments using a relational database management system (RDBMS), such as MySQL, that incorporates basic processing functionality and allows for data management, data manipulation and data analysis.

Self Paced
Self-Paced
SQL Data Analysis Database Management
Details
Introduction to SQL (edX) EdX
Davidson College,DavidsonX

Introduction to SQL (edX)

Statistics & Data Analysis

In this introduction to SQL Online Course you will gain strong understanding and utilize SQL to aggregate, manipulate, analyze, and visualize data in your field. SQL (Structured Query Language) is the most commonly used language to communicate with databases and extract data for application development, reporting and analytics. It is ubiquitous for industries across the world and a vital skill for aspiring data professions to have. This course will introduce you to the SQL language and give you the skills you need to query and analyze data from complex relational databases.

Self Paced
Self-Paced
SQL Relational Databases Structured Query Language
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