-
Advanced Locking Techniques
After watching this video; you will be able to describe advanced locking techniques in a relational database.
-
Architectures; Models; and Normalization
After watching this video; you will be able to identify the different database architectures; models; and perform normalization on a database.
-
Benefits of Normalization
After watching this video; you will be able to identify the benefits of a well normalized database for users.
-
Concurrency Problems (Part 1)
After watching this video; you will be able to identify the concurrency issues that can occur within a relational database.
-
Concurrency Problems (Part 2)
After watching this video; you will be able to identify the concurrency issues that can occur within a relational database.
-
Database Modeling
After watching this video; you will be able to describe entity-relationship modelling for an RDBMS.
-
DBA and the Role of Views in Security
After watching this video; you will be able to recognize how the role of a DBA can ensure security within a relational database.
-
DBMS Transactions and ACID Properties
After watching this video; you will be able to describe DBMS transactions and the ACID properties used to maintain data integrity.
-
DDL and DCL Statements
After watching this video; you will be able to identify the different DDL and DCL statements and their uses.
-
Describing Concepts for Managing Data
After watching this video; you will be able to identify relational algebra concepts; how transactions are implemented; and concurrency and locking concepts.
-
DML Statements
After watching this video; you will be able to identify the different DML statements and their uses.
-
Domain Relational Calculus
After watching this video; you will be able to identify what domain relational calculus is.
-
Dr. Codd's 13 Rules for a Relational Database
After watching this video; you will be able to identify the 13 rules published by Dr. Codd to help determine whether a database is relational.
-
Features of RDBMSs
After watching this video; you will be able to describe the features and components of an RDBMS.
-
Flat-File; Hierarchical; and XML Database Models
After watching this video; you will be able to describe the features and characteristics of flat-file; hierarchical; and XML database models.
-
Functions Performed Using SQL
After watching this video; you will be able to describe the different functions that can be performed using SQL in a relational database.
-
Fundamentals of Locking
After watching this video; you will be able to recognize the fundamentals of locking in a relational database.
-
Indexes; Triggers; and Stored Procedures
After watching this video; you will be able to describe indexes; triggers; and stored procedures and how they help to access and manage data.
-
Introduction to a DBMS
After watching this video; you will be able to describe a DBMS; its components; and advantages for users.
-
Introduction to Relational Algebra
After watching this video; you will be able to describe relational algebra; what it achieves in a database; and the basic operations.
-
Introduction to Relational Calculus
After watching this video; you will be able to describe relational calculus for a relational database .
-
Levels of a DBS Architecture
After watching this video; you will be able to describe the three levels of a DBS architecture.
-
Network and Relational Database Models
After watching this video; you will be able to describe the network and relational database models.
-
Normalization (Part 1)
After watching this video; you will be able to describe the 1NF and 2NF in normalization for a database.
-
Normalization (Part 2)
After watching this video; you will be able to describe 3NF and BCNF in normalization for a database.
-
Normalization (Part 3)
After watching this video; you will be able to describe 4NF and 5NF in normalization for a database.
-
Object-Oriented and Object-Relational DB Models
After watching this video; you will be able to describe the object-oriented and object-relational database models.
-
Relational Algebra Difference and Product
After watching this video; you will be able to describe the relational algebra difference and Cartesian product set operations.
-
Relational Algebra Division
After watching this video; you will be able to describe the native relational algebra division operation.
-
Relational Algebra Joins
After watching this video; you will be able to describe the native relational algebra theta; equi; natural; semi join operations.
-
Relational Algebra Outer Joins
After watching this video; you will be able to describe the native relational algebra outer joins.
-
Relational Algebra Projection
After watching this video; you will be able to describe the native relational algebra projection operation.
-
Relational Algebra Selection
After watching this video; you will be able to describe the native relational algebra selection operation.
-
Relational Algebra Union and Intersection
After watching this video; you will be able to describe the relational algebra union and intersection set operations .
-
Requirements of a Good Database
After watching this video; you will be able to identify the requirements that make up a good database.
-
SQL Security Concepts
After watching this video; you will be able to recognize security concepts in a relational database.
-
The ANSI/ISO Model SQL Transaction Statements
After watching this video; you will be able to describe the ANSI/ISO model and the SQL statements used to process transactions.
-
The Centralized DBMS Architecture
After watching this video; you will be able to identify the characteristics of a centralized DBMS architectures.
-
The Client/Server DBMS Architecture
After watching this video; you will be able to identify the characteristics of a client/server DBMS architecture.
-
The Distributed and Parallel DBMS Architecture
After watching this video; you will be able to identify the characteristics of a distributed and parallel DBMS architecture.
-
The N-Tier DBMS Architecture
After watching this video; you will be able to identify the characteristics of an n-tier DBMS architecture.
-
Tuple Relational Calculus
After watching this video; you will be able to identify what tuple relational calculus is.
-
Types of Constraints
After watching this video; you will be able to describe the types of constraints that can be used for data integrity.
-
Types of Database Users
After watching this video; you will be able to identify different types of database users.
-
Types of Keys in a Table
After watching this video; you will be able to describe the different types of keys that can be implemented on a column in a table.
-
Understanding Tables
After watching this video; you will be able to identify the characteristics of a table in the conceptual level of the database architecture.
-
Introduction to SQL
After watching this video; you will be able to describe SQL and its advantages and disadvantages to a relational database.
-
Introduction to Databases
After watching this video; you will be able to create ASP.Net application; open; modify and run application on OS X and Linux platforms.
-
Generic Database Fundamentals: Architecture and Normalization Concepts
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. 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.
- start the course
- describe a database
- describe a DBMS, its components, and advantages for users
- identify different types of database users
- identify the requirements that make up a good database
- identify the characteristics of a centralized DBMS architectures
- identify the characteristics of a client/server DBMS architecture
- identify the characteristics of an n-tier DBMS architecture
- identify the characteristics of a distributed and parallel DBMS architecture
- describe the features and characteristics of flat-file, hierarchical, and XML database models
- describe the network and relational database models
- describe the object-oriented and object-relational database models
- identify the 13 rules published by Dr. Codd to help determine whether a database is relational
- describe the features and components of a RDBMS
- describe entity-relationship modeling for a RDBMS
- describe the three levels of a DBS architecture
- identify the characteristics of a table in the conceptual level of the database architecture
- describe the types of constraints that can be used for data integrity
- describe the different types of keys that can be implemented on a column in a table
- describe indexes, triggers, and stored procedures and how they help to access and manage data
- describe the 1NF and 2NF in normalization for a database
- describe 3NF and BCNF in normalization for a database
- describe 4NF and 5NF in normalization for a database
- identify the benefits of a well normalized database for users
- identify the different database architectures, models, and perform normalization on a database
-
Generic Database Fundamentals: Relation Algebra, SQL, and Concurrency Concepts
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.
- 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
- 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
- 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
- identify relational algebra concepts, how transactions are implemented, and concurrency and locking concepts