Introduction about Database

Relational Data Model

Referential Integrity

Difference between MySQL and SQL

SQL and its advantages

Classification of SQL statements

MySQL Data Types

CREATING DATABASE IN MYSQL

Constraints

CREATE TABLE Command

Defining Foreign key through Create Table

ALTER Commands

Defining Foreign key through Alter Table

Foreign Key and Storage Engine

DROP TABLE Command

Truncate Table

Insert INTO Command

UPDATE Query in SQL

DELETE Query in SQL

SELECT Command

Eliminating Redundant Data

ORDER BY Clause in SQL Query

Aggregate functions in SQL Query

GROUP BY and HAVING Clause in SQL Queries

Operators used in SQL commands:

Viewing Structure of a Table

Performing Simple Calculations

Using Column Aliases

Condition Based on a Range in SQL Queries

Condition Based on a List in SQL Queries

Condition Based on Pattern Matches or Use of LIKE operator in SQL

How to Search Records having NULL value

SQL Joins

INDEXES IN DATABASE

How to Create index in SQL