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

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
Fundamentos TIC para profesionales de negocios: Programación (edX) EdX
Universitat Politècnica de València,UPValenciaX

Fundamentos TIC para profesionales de negocios: Programación (edX)

CS: Software Engineering

¿Tienes que trabajar con las Tecnologías de la Información y te faltan conocimientos? Conoce los fundamentos de la programación software. Este curso forma parte de una serie de 5 cursos de introducción al uso de sistemas de información en las empresas que te introducirá en el apasionante mundo de las TIC.

Self Paced
Self-Paced
HTML Javascript XML
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
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