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

Introduction to Data Engineering (Coursera) Coursera
IBM

Introduction to Data Engineering (Coursera)

CS: Information & Technology

This course introduces you to the core concepts, processes, and tools you need to know in order to get a foundational knowledge of data engineering. You will gain an understanding of the modern data ecosystem and the role Data Engineers, Data Scientists, and Data Analysts play in this ecosystem. The Data Engineering Ecosystem includes several different components. It includes disparate data types, formats, and sources of data.

Oct 12th 2026
4 Weeks
Databases NoSQL SQL
Details
Web Application Development: Basic Concepts (Coursera) Coursera
University of New Mexico

Web Application Development: Basic Concepts (Coursera)

CS: Software Engineering CS: Information & Technology

This is the first course in a Coursera Specialization track involving Web Application Architectures. This course will give you the basic background, terminology and fundamental concepts that you need to understand in order to build modern full stack web applications. A full stack web developer is familiar with each "layer" of the software technologies involved in a web application, including data modeling and database technologies, the web server environment and middleware components, network protocols, the user interface and basic visual design and user interaction concepts.

Oct 12th 2026
5-12 Weeks
Web Databases Data Modeling
Details
Accounting Data Analytics with Python (Coursera) Coursera
University of Illinois at Urbana-Champaign

Accounting Data Analytics with Python (Coursera)

Statistics & Data Analysis Data Science

This course focuses on developing Python skills for assembling business data. It will cover some of the same material from Introduction to Accounting Data Analytics and Visualization, but in a more general purpose programming environment (Jupyter Notebook for Python), rather than in Excel and the Visual Basic Editor. These concepts are taught within the context of one or more accounting data domains (e.g., financial statement data from EDGAR, stock data, loan data, point-of-sale data).

Oct 12th 2026
5-12 Weeks
Python SQL Linear Regression
Details
Exploiting and Securing Vulnerabilities in Java Applications (Coursera) Coursera
University of California, Davis

Exploiting and Securing Vulnerabilities in Java Applications (Coursera)

Security & Networking

In this course, we will wear many hats. With our Attacker Hats on, we will exploit Injection issues that allow us to steal data, exploit Cross Site Scripting issues to compromise a users browser, break authentication to gain access to data and functionality reserved for the ‘Admins’, and even exploit vulnerable components to run our code on a remote server and access some secrets.

Oct 12th 2026
4 Weeks
Programming Java Security
Details
Build a Data Warehouse Using BigQuery (Coursera) Coursera
Starweaver

Build a Data Warehouse Using BigQuery (Coursera)

Statistics & Data Analysis Data Science

Unlock the power of Google BigQuery as you embark on a journey to become proficient in data warehouse building and advanced querying. In this comprehensive course, you'll learn to harness the capabilities of BigQuery, from setting up and accessing the platform to creating data warehouses using both the user interface and Python. Through hands-on lessons and practical applications, you'll develop the fundamental skills needed to manage, query, and optimize your data in this powerful cloud-based platform.

Oct 26th 2026
1 Week
SQL Data Warehousing Data Warehouse
Details
Python Scripting: Files, Inheritance, and Databases (Coursera) Coursera
LearnQuest

Python Scripting: Files, Inheritance, and Databases (Coursera)

Computer Science

This course is the third course in a series that aims to prepare you for a role working as a programmer. In this course, you will be introduced to the three main concepts in programming: Files, Inheritance and external libaries. Labs will allow the students to apply the material in the lectures in simple computer programs designed to re-enforce the material in the lesson.

Oct 12th 2026
4 Weeks
Python Databases Inheritance
Details
Database Design and Basic SQL in PostgreSQL (Coursera) Coursera
University of Michigan

Database Design and Basic SQL in PostgreSQL (Coursera)

CS: Software Engineering

In this course you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL.

Oct 12th 2026
Self-Paced
Databases SQL CRUD
Details
Managing Big Data with MySQL (Coursera) Coursera
Duke University

Managing Big Data with MySQL (Coursera)

Statistics & Data Analysis Data Science

This course is an introduction to how to use relational databases in business analysis. You will learn how relational databases work, and how to use entity-relationship diagrams to display the structure of the data held within them. This knowledge will help you understand how data needs to be collected in business contexts, and help you identify features you want to consider if you are involved in implementing new data collection efforts.

Oct 12th 2026
5-12 Weeks
Databases SQL Big Data
Details
Introduction to Structured Query Language (SQL) (Coursera) Coursera
University of Michigan

Introduction to Structured Query Language (SQL) (Coursera)

CS: Software Engineering CS: Programming

In this course, you'll walk through installation steps for installing a text editor, installing MAMP or XAMPP (or equivalent) and creating a MySql Database. You'll learn about single table queries and the basic syntax of the SQL language, as well as database design with multiple tables, foreign keys, and the JOIN operation. Lastly, you'll learn to model many-to-many relationships like those needed to represent users, roles, and courses.

Oct 12th 2026
4 Weeks
SQL PHP MySQL
Details