Online Tutor

Database is a collection of related data and data is a collection of facts and figures that can be processed to produce information.

Mostly data represents recordable facts. Data aids in producing information, which is based on facts. For example, if we have data about marks obtained by all students, we can then conclude about toppers and average marks.

A database management system stores data in such a way that it becomes easier to retrieve, manipulate, and produce information.

Overview of DBMS

Components of DBMS

Database Architecture

Types of Database Model

ER Model: Basic Concepts

ER Model: Creating ER Diagram

The Extended ER Model

Codd's 12 rule of RDBMS

Basic Concepts of RDBMS

Relational Algebra

Relational Calculus

ER Model to Relational Model

Types of Database key

Introduction to Normalization

First Normal Form (1NF)

Second Normal Form (1NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

Fourth Normal Form (4NF)

Create query

Alter query

Truncate, Drop and Rename query

All DML command

All TCL Command

All DCL Command

WHERE clause

SELECT query

LIKE clause

ORDER BY clause

Group BY clause

Having clause

DISTINCT keyword

AND & OR operator

DIVISION operator

SQL Constraints

SQL function

SQL Join

SQL Alias

SQL SET operation

SQL Sequences

SQL Views