Introduction to Database Management Systems
Database Models
Relational Database Model
Functional Dependency
Data Integrity
Relational Database Management System (RDBMS)
Data Mining
Data Warehousing
Writing Basic SQL Queries
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Control Language (DCL)
SQL Middleware Basics
SQL API
Open SQL Gateway
Restricting and Sorting Data
Subqueries
Manipulating Data
Creating and Managing Tables
Creating Views
Controlling User Access
Set Operators
Date and Time Functions
Entity Relationship (ER) Diagram
Data Flow Diagram (DFD)
Keys
Primary Key
Foreign Key
Candidate Key
Alternate Key
Normalization
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce–Codd Normal Form (BCNF)
Fourth Normal Form (4NF)
Functional Dependencies
Basic Concepts of Major RDBMS Products
Microsoft SQL Server
Oracle
MariaDB
Concept of Time-Series Databases
Fundamentals of Database Servers
Functions
Stored Procedures
Triggers
Rules
Transactions
Concurrent Execution of User Programs
Concurrency Control Techniques
Types of Failures
Recovery Techniques
Query Processing
Query Optimization Techniques
Hash-Based Indexing
Tree-Based Indexing
Distributed Database Systems
Object-Oriented Database Systems
Concepts of SQL and NoSQL Databases
