Database Systems and Relational Databases

People who want to get a thorough understanding of the fundamentals of databases.

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
120 minutes

Description
A database is used by organizations to store their data, and allow their employees to access, update, and manage it. Organizations use a Database Management System, also known as a DBMS to control, store, organization and retrieve that data for the users through end-user applications. There are multiple types of database, such as flat-file, network, and hierarchical. The most widely used database is the relational database, which is based on a mathematical theory. A relational database stores data in relations, which are tables, that store data in rows or tuples and columns or attributes. The relational database is based on the relational model and consists of a relational schema which contains the database objects. This course discusses what database and DBMSs are, the different database models and the database architectures. It also discusses what relational databases are, its components, and how relational databases were identified by Dr. Edgar Codd, including the 12 rules that were identified that a database should adhere to be considered relational.

Objective

Database System and the Architecture

  • recognize the differences between a database and a DBMS
  • recognize the different types of database users
  • identify the requirements of a good database
  • match the database architecture with its correct description
  • match the database model with its correct description
  • recognize the features of databases and DBMS
  • describe database models and database architectures
  • Relational Databases

  • describe the features and recognize the types of relational databases
  • recognize how to model the database
  • describe how to outline a relationship database schema
  • describe the concept of referential integrity
  • recognize how to normalize the relations
  • describe relational database concepts
  • recognize the constructs in a relationship database schema
  • normalize database tables
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.