Management of Relational Database Data

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

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
120 minutes

Description
Database Management Systems, DBMSs, are used to control, maintain, and use a relational database where the data is stored. A relational database consists of the data records, files, and database objects. An important part of each organization is allowing users to gain access to the data for them to view and manipulated if required. In order for users to do this query languages are used which enable users to write queries and send them to the database to retrieve the appropriate data and return it to them. Queries can also be written to manipulate the data by updating, deleting or inserting it to the database. The Structured Query Language, known as SQL or SEQUEL, is the main query language used by most DBMSs, this is based on relational algebra and relational calculus which was developed by Dr. Edgar Codd for his theory for the relational database. This course discusses the relational algebra operations and relational calculus for a relational database, how to use SQL to manage data in a relational database, and how transactions and concurrency control are used to ensure data integrity and data consistency. It also discusses how security is implemented in a relational database to keep the data secure.

Objective

Relational Database Querying and Manipulation

  • match each relational algebra operation with its correct description
  • recognize what the different SQL statements do
  • recognize the different relational algebra operations
  • recognize how to use SQL statements for queries and manipulation
  • Transaction Control and Security

  • recognize characteristics of transaction processing and concurrency control
  • recognize how a transaction works in a DBMS and describe the ANSI/ISO transaction model
  • recognize concurrency problems
  • recognize the fundamentals of locking
  • describe advanced locking techniques
  • recognize security concepts in a relational database
  • describe transaction processing and concurrency control
  • describe concurrency control with locking
  • describe security concepts in a relational database
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.