Scribd
Upload
15 views7 pages

Introduction to SQL and MySQL Basics

Uploaded by

devansh.amrujkar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
15 views7 pages

Introduction to SQL and MySQL Basics

Uploaded by

devansh.amrujkar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INTRODUCTION TO

SQL
SQL
ӿStructured Query Language.
ӿ SQL is a non procedural language that is used to create, manipulate
and process the databases(relations).

ӿ SQL consists of set of commands to interact with nearly all RDBMs.

ӿ A standard relational database language.


Categories of SQL Commands

DDL DML
Data Definition Language Data Manipulation Language

DCL TCL
Data Control Language Transaction Control Language
DDL-Data Definition Language

✓Allows us to perform tasks related to the structure of a


table.
✓DDL commands affect the database or table.
✓SQL includes following DDL Commands:
→CREATE
→ALTER
→DROP
DML-Data Manipulation Language

• Enable us to access or manipulate data from the


table.
• SQL includes following DML Commands:-
꙳ INSERT
꙳ UPDATE
꙳ DELETE
꙳ SELECT
What is MySQL?

It is an Open-source Relational Database Management


System.
Features
✓Speed
✓Ease of Use
✓Cost
✓Query Language Support
✓Portability
✓Data Types
✓Security
✓Scalability and Limits

You might also like