Database Management System

About Database Management System

✴ A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.✴

► A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible.✦

【Topics Covered in this App are Listed Below】

⇢ Overview

⇢ Architecture

⇢ Data Models

⇢ Data Schemas

⇢ Data Independence

⇢ ER Model - Basic Concepts

⇢ ER Diagram Representation

⇢ Generalization Aggregation

⇢ Codd's 12 Rules

⇢ Relation Data Model

⇢ Relational Algebra

⇢ ER Model to Relational Model

⇢ SQL Overview

⇢ Normalization

⇢ Joins

⇢ Storage System

⇢ File Structure

⇢ Indexing

⇢ Hashing

⇢ Transaction

⇢ Concurrency Control

⇢ Deadlock

⇢ Data Backup

⇢ Data Recovery

⇢ What is a Database Management System?

⇢ Who Interacts with a DBMS?

⇢ Components of a Database System

⇢ Basic Set Concepts

⇢ DBMS Database Models

⇢ Database Keys

⇢ What is First Normal Form (1NF)?

⇢ What is Second Normal Form?

⇢ Third Normal Form (3NF)

⇢ Boyce-Codd Normal Form (BCNF)

⇢ Fourth Normal Form (4NF)

⇢ create command

⇢ ALTER command

⇢ Truncate, Drop or Rename a Table

⇢ INSERT SQL command

⇢ UPDATE SQL command

⇢ DELETE SQL command

⇢ Commit, Rollback and Savepoint SQL commands

⇢ GRANT and REVOKE

⇢ SELECT SQL Query

⇢ WHERE SQL clause

⇢ SQL LIKE clause

⇢ ORDER BY Clause

⇢ Group By Clause

⇢ HAVING Clause

⇢ DISTINCT keyword

⇢ AND & OR operator

⇢ Division Operator in SQL

⇢ SQL Constraints

⇢ What are SQL Functions?

⇢ Scalar Functions

⇢ SQL Alias - AS Keyword

⇢ SET Operations in SQL

⇢ What is an SQL Sequence?

⇢ SQL VIEW