Introduction to Modern Database Systems (saylor.org)

Introduction to Modern Database Systems (saylor.org)
Free Course
Categories
Effort
Certification
Languages
Have completed the CS202: Discrete Structures course.
Misc

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

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.

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

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.



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

Free Course
Have completed the CS202: Discrete Structures course.

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