Saylor Academy

Introduction to Modern Database Systems (saylor.org)

Offered by Saylor.org,
Introduction to Modern Database Systems (saylor.org)

This course will provide students with a general overview of databases, introducing you to database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases.

This course will provide students with a general overview of databases, introducing you to database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases.

Upon successful completion of this course, the student will be able to:

Compare and contrast the database approach and the file system approach.
Explain what a database management system is as well as the various components.
Identify the various people involved in database management systems.
Explain the historical background of database management systems.
Compare the various database models.
Describe the functions of a database management system.
Explain the three-schema database architecture.
Describe what tables, indexes, and views are as well as discuss the differences among them.
Explain the entity-relationship model.
Develop an entity-relationship model based on user requirements.
Describe the relational database model.
Explain the process of normalization.
Convert an entity-relationship diagram to a set of normalized relations.
Explain referential integrity.
Identify how relational algebra is used to construct queries.
Describe and use data definition commands.
Describe and use data manipulation commands.
Explain how to join tables together for queries.

Go to Class
MOOC List is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Related Courses

The Nature of Data and Relational Database Design (Coursera) Coursera
University of California, Irvine

The Nature of Data and Relational Database Design (Coursera)

CS: Information & Technology

This course provides a comprehensive overview of data, various data types, design of databases for storage of data, and creation and manipulation of data in databases using SQL. By the end of this course, students will be able to describe what business intelligence is and how it’s different from business analytics and data science, conduct a basic descriptive statistical analysis and articulate the findings, and differentiate between types of statistics. They will also be able to define normalization and ETL, create an ERD that shows progression from conceptual to logical to physical design, define DDL, DML, DCL, and TCL, and write SQL scripts to create a database and associated tables.

Jul 27th 2026
4 Weeks
Databases SQL Descriptive Statistics
Details
Web Application Technologies and Django (Coursera) Coursera
University of Michigan

Web Application Technologies and Django (Coursera)

Computer Science

In this course, you'll explore the basic structure of a web application, and how a web browser interacts with a web server. You'll be introduced to the Hypertext Transfer Protocol (HTTP) request/response cycle, including GET/POST/Redirect. You'll also gain an introductory understanding of Hypertext Markup Language (HTML), as well as the overall structure of a Django application.

Jul 27th 2026
5-12 Weeks
HTML SQL HTTP
Details
Foundations of marketing analytics (Coursera) Coursera
ESSEC Business School

Foundations of marketing analytics (Coursera)

Marketing & Communication Business

Who is this course for? This course is designed for students, business analysts, and data scientists who want to apply statistical knowledge and techniques to business contexts. For example, it may be suited to experienced statisticians, analysts, engineers who want to move more into a business role, in particular in marketing. You will find this course exciting and rewarding if you already have a background in statistics, can use R or another programming language and are familiar with databases and data analysis techniques such as regression, classification, and clustering. However, it contains a number of recitals and R Studio tutorials which will consolidate your competences, enable you to play more freely with data and explore new features and statistical functions in R.

Jul 27th 2026
5-12 Weeks
Databases Big Data Data Analysis
Details
Database Management Essentials (Coursera) Coursera
University of Colorado System

Database Management Essentials (Coursera)

CS: Software Engineering

Database Management Essentials provides the foundation you need for a career in database development, data warehousing, or business intelligence, as well as for the entire Data Warehousing for Business Intelligence specialization. In this course, you will create relational databases, write SQL statements to extract information to satisfy business reporting requests, create entity relationship diagrams (ERDs) to design databases, and analyze table designs for excessive redundancy.

Jul 27th 2026
5-12 Weeks
SQL MySQL Business Intelligence
Details
Importing Data in the Tidyverse (Coursera) Coursera
Johns Hopkins University

Importing Data in the Tidyverse (Coursera)

Statistics & Data Analysis Data Science

Getting data into your statistical analysis system can be one of the most challenging parts of any data science project. Data must be imported and harmonized into a coherent format before any insights can be obtained. You will learn how to get data into R from commonly used formats and harmonizing different kinds of datasets from different sources. If you work in an organization where different departments collect data using different systems and different storage formats, then this course will provide essential tools for bringing those datasets together and making sense of the wealth of information in your organization.

Jul 27th 2026
4 Weeks
Databases XML JSON
Details
Using Databases with Python (Coursera) Coursera
University of Michigan

Using Databases with Python (Coursera)

CS: Software Engineering

This course will introduce students to the basics of the Structured Query Language (SQL) as well as basic database design for storing data as part of a multi-step data gathering, analysis, and processing effort. The course will use SQLite3 as its database. We will also build web crawlers and multi-step data gathering and visualization processes. We will use the D3.js library to do basic data visualization.

Jul 27th 2026
5-12 Weeks
Programming Python Databases
Details
Serverless Data Processing with Dataflow: Develop Pipelines (Coursera) Coursera
Google Cloud

Serverless Data Processing with Dataflow: Develop Pipelines (Coursera)

Statistics & Data Analysis Data Science

In this second installment of the Dataflow course series, we are going to be diving deeper on developing pipelines using the Beam SDK. We start with a review of Apache Beam concepts. Next, we discuss processing streaming data using windows, watermarks and triggers. We then cover options for sources and sinks in your pipelines, schemas to express your structured data, and how to do stateful transformations using State and Timer APIs.

Jul 27th 2026
3 Weeks
SQL Schema Data Processing
Details