Course Content

  • 0%

    • Introduction
    • 1. Concepts and Characteristics of DBMS
    • 1. History and Evolution of Database
    • 1. Database System Architecture

    Data Modelling
    • 1. Relational Database Model
    • 1. Entity Relationship Model
    • 1. Types of Attributes and their Symbols
    • 1. Connectivity of Relationships
    • 1. Degree of a Relationship
    • 1. Designing an ER Model
    • 1. Conversion from ER Model to Relational Model
    • 1. Conversion from ER Model to Relational Model_Composite Attributes
    • 1. Conversion from ER Model to Relational Model - Derived and Multi-valued Attributes
    • 1. Many to Many Relationship
    • 1. Many to One Relationships
    • 1. One to Many Relationships
    • 1. One to One Relationships
    • 1. Strong and Weak Entity Sets
    • 1. Strong and Weak Entity Sets_2
    • 1. Cardinality of a Relationship
    • 1. Total and Partial Participation
    • 1. Cardinality and Participation
    • 1. Examples
    • 1. Codd's Rules

    Database Design
    • 1. Data Independence
    • 1. Keys in DBMS
    • 1. Functional Dependence
    • 1. Inference Rules
    • 1. Closure of Functional Dependencies
    • 1. Minimal Cover
    • 1. Fully Functional Dependency
    • 1. Transitive Dependency
    • 1. Multi Valued Dependency
    • 1. Normalization Process
    • 1. Computer Center Case Study
    • 1. First Normal Form_1
    • 1. Anomalies of the First Normal Form
    • 1. First Normal Form_2
    • 1. Second Normal Form
    • 1. 1Third Normal Form
    • 1. 1Boyce Codd Normal Form
    • 1. 1Fourth Normal Form
    • 1. 1Fifth Normal Form

    Relational Algebra
    • 1. Relational Query Languages
    • 1. Basics of Relational Algebra
    • 1. Select Operation
    • 1. Projection Operation
    • 1. Rename Operation
    • 1. Union Operation
    • 1. Intersection Operation
    • 1. Set Difference Operation
    • 1. Cartesian Product Operation
    • 1. Joins
    • 1. Relational Algebra Queries_1
    • 1. Relational Algebra Queries_2

    Oracle Introduction
    • 1. Introduction
    • 1. DESCRIBE Command
    • 1. SQL Statement Basics

    Oracle Retrieving Data
    • 1. Select Statements
    • 1. Column Aliases
    • 1. Quote Operator
    • 1. DISTINCT and UNIQUE Operator
    • 1. Concatenation Operator
    • 1. Arithmetic Expressions

    Oracle Receiving
    • 1. WHERE Clause
    • 1. Comparison Operators
    • 1. BETWEEN ... AND Operator
    • 1. IN Operator
    • 1. LIKE Operator
    • 1. IS NULL Operator
    • 1. Logical Operators
    • 1. Rules of Precedence

    Oracle Sorting Data
    • 1. ORDER BY Clause
    • 1. ASC and DESC Operators
    • 1. NULLS FIRST and NULLS LAST
    • 1. ROWID and ROWNUM

    Oracle Single-Row Functions
    • 1. Single Row Functions
    • 1. Case Conversion Functions
    • 1. Character Manipulation Functions
    • 1. Numeric Functions
    • 1. Nested Functions
    • 1. Date Values and Formats
    • 1. Date Format Models
    • 1. Date Functions and Arithmetic Operators
    • 1. Date Manipulation Functions
    • 1. Number Format Models

    Oracle Conversion Functions
    • 1. Oracle Conversion Functions
    • 1. Implicit Conversion Examples
    • 1. TO_CHAR Function
    • 1. NVL, NVL2, NULLIF and COALESCE Functions

    Oracle Group Functions
    • 1. Group Functions
    • 1. AVG Function
    • 1. COUNT Function
    • 1. MAX Function
    • 1. MIN Function
    • 1. SUM Function
    • 1. LISTAGG Function
    • 1. Overview of Group Functions

    Oracle Grouping Data
    • 1. GROUP BY Clause - 1
    • 1. GROUP BY Clause - 2
    • 1. HAVING Clause
    • 1. Nested Group Functions

    Oracle Joins
    • 1. Join
    • 1. Creating a Join
    • 1. Natural Join
    • 1. Join with USING Clause
    • 1. Handling Ambiguous Column Names
    • 1. INNER Join
    • 1. Multiple Join Operations
    • 1. Restricting Joins
    • 1. SELF Join
    • 1. Non-Equijoins
    • 1. OUTER Joins
    • 1. CROSS Join
    • 1. Join Types

    Oracle Subqueries
    • 1. Subqueries
    • 1. Single Row Subqueries
    • 1. Multiple Row Subqueries
    • 1. Multiple Column Subqueries

    Oracle Set Operators
    • 1. SET Operators
    • 1. UNION and UNION ALL Operators
    • 1. INTERSECT Operator
    • 1. MINUS Operator
    • 1. Matching Unmatched Queries
    • 1. ORDER BY with SET Operators
    • 1. Combining Multiple Queries with SET Operators

    Oracle DDL Commands
    • 1. Data Definition Language
    • 1. Database Object Naming Rules
    • 1. CREATE TABLE Statement
    • 1. ALTER TABLE Statement
    • 1. DROP TABLE Command
    • 1. TRUNCATE TABLE Statement
    • 1. RENAME TABLE Statement

    Oracle DML Commands
    • 1. Data Manipulation Language
    • 1. INSERT Statement
    • 1. INSERT INTO SELECT Statement
    • 1. UPDATE Statement
    • 1. DELETE Statement

    Oracle Constraints
    • 1. Constraints
    • 1. NOT NULL Constraint
    • 1. UNIQUE Constraint
    • 1. Primary Key Constraint
    • 1. Foreign Key Constraint
    • 1. Check Constraint

    Oracle PLSQL
    • 1. Introduction
    • 1. Procedure
    • 1. Trigger
    • 1. Functions

    Storage and Querying
    • 1. Disk Management
    • 1. Pages and Blocks
    • 1. Time to Access a Page
    • 1. Heap Files
    • 1. Index and Index Structure
    • 1. Sorted Files
    • 1. Storage Structure
    • 1. Clustered Index
    • 1. Unclustered Index
    • 1. Problem on Cost of Range Search
    • 1. Sparse Versus Dense Index
    • 1. Two Level Index
    • 1. Multi Level Index
    • 1. Query Processing
    • 1. Query Optimization

    Transaction Management
    • 1. Transactions
    • 1. Concurrent Execution of Transactions
    • 1. Inconsistency Problem
    • 1. States of a Transaction
    • 1. ACID Properties
    • 1. Schedules
    • 1. Lost Update Problem
    • 1. Dirty Read Problem
    • 1. Unrepeatable Read Problem
    • 1. Phantom Read Problem
    • 1. Recoverable and Non-Recoverable Schedule
    • 1. Cascadeless and Cascading Schedules
    • 1. Recoverable and Cascadeless Schedules
    • 1. Example Problem
    • 1. Strict Schedule
    • 1. Recoverable, Cascadeless and Strict Schedules
    • 1. Important Point
    • 1. Equivalence of Schedules
    • 1. Conflicting Actions
    • 1. Conflict Equivalence and Equivalence of Schedules
    • 1. Conflict Serializability of a Schedule
    • 1. Test for Conflict Serializability
    • 1. Number of Conflict Serializable Schedules
    • 1. Example Problems
    • 1. View Equivalence and View Serializability
    • 1. Problems on View Serializability
    • 1. Additional Problems on View Serializability
    • 1. Shared and Exclusive Locking Protocol
    • 1. Two Phase Locking
    • 1. Strict and Rigorous Phase Locking Protocols
    • 1. Recovery Techniques

    NoSQL Databases and Big Data Storage Systems
    • 1. Introduction to NoSQL Databases
    • 1. Types of NoSQL Databases
    • 1. BASE Properties
    • 1. CAP Theorem
    • 1. Big Data

    Data Warehousing
    • 1. Introduction
    • 1. Components of Data Warehouse
    • 1. Data Warehouse Architecture
    • 1. Online Analytical Processing
    • 1. Online Transaction Processing
    • 1. OLAP Versus OLTP