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

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
Intermediate PostgreSQL (edX) EdX
University of Michigan,MichiganX

Intermediate PostgreSQL (edX)

Computer Science

This second course in PostgreSQL for Everybody explores a wide range of SQL techniques to aggregate and transact data in PostgreSQL.This course also explores handling, reading, and parsing data with PostgreSQL and working with text in databases with regular expressions. This course covers a wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database.

Self Paced
Self-Paced
SQL CRUD PostgreSQL
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
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
Hacking PostgreSQL: Data Access Methods (edX) EdX
Ural Federal University,UrFUx

Hacking PostgreSQL: Data Access Methods (edX)

CS: Software Engineering Statistics & Data Analysis

Learn the science, engineering practices and hacking techniques of data access – core aspects of information processing in a database. This course is about data storage and data processing technologies with examples from PostgreSQL. It is geared toward database core developers, operation systems developers, system architects, and all those who want to understand databases in more detail.

No sessions available
13-24 Weeks
Algorithms Hacking Data Access
Details