EdX

Relational Database Basics (edX)

Offered by IBM,
Relational Database Basics (edX)

This course teaches you the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS). This course is an introduction to the world of relational databases. You will explore the fundamental concepts of relational databases and Relational Database Management Systems (RDBMS), learn about relational database design, and understand how to transform source data into tables with clearly defined relationships.

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

From there, you will learn how to apply relational database design principles to your own data, and create databases, tables, and load data yourself. You’ll get an introduction to Structured Query Language (SQL) and use it to add the keys and constraints necessary in a relational database.
This course includes hands-on, practical exercises to help you demonstrate your learning. You will work with several industry standard relational databases, including IBM Db2, MySQL, and PostgreSQL. Based on what you’ve learned through the course, you’ll complete a final project in which you’ll design, create, and populate a database instance containing multiple tables.
No prior knowledge of databases or programming is required.
This course is part of the following programs:

What you'll learn
The objective of this course is to provide you with a solid understanding of relational databases and Relational Database Management Systems (RDBMS).
After completing this course, you will be able to:

  • Describe a relational database and explain relational database concepts.
  • Design the schema of a relational database.
  • Create database objects such as tables, keys, constraints, and views.
  • Load tables with data from .CSV files.
  • Demonstrate working knowledge of MySQL, PostgreSQL and IBM Db2.

Syllabus

Module 1 – Relational Database Concepts

  • Review of data fundamentals
  • Information and Data Models
  • Types of Relationships
  • Mapping Entities to Tables
  • Data Types
  • Relational Model ConceptsRelational Database Architectures and Usage Scenarios
  • Introduction to Relational Database Products
  • Db2
  • MySQL
  • PostgreSQL

Module 2 – Using Relational Databases

  • Creating Tables
  • Loading Data
  • Exporting Data
  • Primary Keys and Foreign Keys
  • Overview of Indexes
  • Normalization
  • Relational Model Constraints

Module 3 – MySQL and PostgreSQL

  • Getting started with MySQL - architecture, design focus
  • Creating Databases and Tables in MySQL
  • Loading Data in MySQL
  • Using Keys and Constraints in MySQL
  • Getting started with PostgreSQL
  • Creating Databases and loading data into PostgreSQL
  • Views

Module 4 – Database Design Project

  • Approach to Database Design
  • Final Project
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
Building ETL and Data Pipelines with Bash, Airflow and Kafka (edX) EdX
IBM

Building ETL and Data Pipelines with Bash, Airflow and Kafka (edX)

Engineering Computer Science

This course provides you with practical skills to build and manage data pipelines and Extract, Transform, Load (ETL) processes using shell scripts, Airflow and Kafka. Well-designed and automated data pipelines and ETL processes are the foundation of a successful Business Intelligence platform. Defining your data workflows, pipelines and processes early in the platform design ensures the right raw data is collected, transformed and loaded into desired storage layers and available for processing and analysis as and when required.

Self Paced
Self-Paced
ETL Kafka Bash
Details
Python for Data Engineering Project (edX) EdX
IBM

Python for Data Engineering Project (edX)

Statistics & Data Analysis

An opportunity to apply your foundational Python skills via a project, using various techniques to collect and work with data. Journey into the realm of becoming a Data Engineer and apply your basic Python knowledge of working with data. You will exercise various techniques in Python to extract data in multiple file formats from different sources, transform it into specific datatypes, and then prepare it for loading it into a database.

Self Paced
Self-Paced
Python APIs Jupyter Notebooks
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