Introduction to SQL

Front

What is SQL?

Back

Structured Query Language.

Standard Language for managing databases

Supports CRUD operations

Efficient Data Querying & Manipulation

Front

BEFORE SQL

Back

Manual Files

Slow Retrieval

Inconsistent Storage

Front

After SQL

Back

Structured Data

Fast Querying

Data Integrity

Front

How SQL Works

Back

1.Write SQL Query

2. 2.Send to Server

3. 3.Execute Query

4. 4.Return Results

Front

Basic Operations in SQL

Back

SELECT

UPDATE

INSERT

DELETE

CREATE

ALTER

DROP

Front

Applications of SQL

Back

1.Data Analytics

2.BAckend Development

3.Business Intelligence

4. 4.E-commerce

5. 5.Finance

6. 6.Healthcare

Front

Natural JOIN

Back

SELECT *

FROM EMPLOYEE

NATURAL JOIN DEPARTMENT;

Front

EQUI JOIN

Back

SELECT E.emp_id, E.name, E.dept_id AS emp_dept_id, D.dept_id AS dept_dept_id, D.dept_name

FROM EMPLOYEE E JOIN DEPARTMENT D

ON E.dept_id = D.dept_id;

Front

LEFT OUTER JOIN

Back

EMPLOYEE ⟕ DEPARTMENT

SELECT *

FROM EMPLOYEE E

LEFT JOIN DEPARTMENT D ON E.dept_id = D.dept_id;

Front

FULL OUTER JOIN

Back

•SELECT E.emp_id, E.name, E.dept_id, D.dept_name

FROM EMPLOYEE E

FULL OUTER JOIN DEPARTMENT D

ON E.dept_id = D.dept_id;