Generic Database Fundamentals: Relation Algebra, SQL, and Concurrency Concepts

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

Prerequisite
None

Expected Duration
214 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 Algebra

  • start the course
  • describe relational algebra, what is achieves in a database and the basic operations
  • describe the relational algebra union and intersection set operations
  • describe the relational algebra difference and Cartesian product set operations
  • describe the native relational algebra selection operation
  • describe the native relational algebra projection operation
  • describe the native relational algebra theta, equi, natural, semi join operations
  • describe the native relational algebra outer joins
  • describe the native relational algebra division operation
  • describe relational calculus for a relational database
  • identify what tuple relational calculus is
  • identify what domain relational calculus is

Introduction to SQL and Transactions

  • describe SQL and its advantages and disadvantages to a relational database
  • describe the different functions that can be performed using SQL in a relational database
  • identify the different DML statements and their uses
  • identify the different DDL and DCL statements and their uses
  • describe DBMS transactions and the ACID properties used to maintain data integrity
  • describe the ANSI/ISO model and the SQL statements used to process transactions

Concurrency, Locking and Security

  • identify the concurrency issues that can occur within a relational database
  • identify the concurrency issues that can occur within a relational database
  • recognize the fundamentals of locking in a relational database
  • describe advanced locking techniques in a relational database
  • recognize security concepts in a relational database
  • recognize how the role of a DBA can ensure security within a relational database

Practice: Relational Algebra, Transactions, and Locking

  • identify relational algebra concepts, how transactions are implemented, and concurrency and locking concepts

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.