SQL for Beginners

What is Data?

Types of Data

What is Database and its types

Relational Database

NoSQL DataBase

What is SQL?

Different Platfroms of SQL

What is MySQL?

Components of MySQL?

Data Definition Language (DDL)

Create Statement

Alter Statement

Rename Statement

Truncate Statement

Drop Statement

Data Manipulation Language (DML)

Insert Statement

Select Statement

Update Statement

Delete Statement

Data Control Language (DCL) Revoke Statement

Grant Statement

Revoke Statement

Transaction Control Language (TCL)

Commit Statement

Savepoint Statement

Rollback Statement

Types of Values

Null values

Maximum, Minimum and Average Values

Between Commands

Project Overview

MySQL: Installation and Set-up

Creating the Database and answering FAQs