SQL Tutorial for Beginners - SQL Interview Preparation - DAY 1

SQL - Tutorial - DAY 1 

Our SQL tutorial will teach you how to learn SQL in 30 Days. 

DAY 1 - SQL 

What is SQL?

SQL - Structured Query Language

It's a standard language for storing, manipulating, and retrieving data in databases and you access and manipulate databases. 

SQL became a type of the American National Standards Institute (ANSI) in 1986 and of the International Organization for Standardization (ISO) in 1987

What Can SQL do?

• SQL can execute database against queries 
• SQL can retrieve data from a database
• SQL can insert records into a database
• SQL can update records during a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables during a database
• SQL can create stored procedures during a database
• SQL can create views during a database
• SQL can give permissions to tables, views, and procedures.

What is Data? 

Data is a raw fact that describes the attributes of an entity /object.

Example: Human Being (Data)

What is Data Base?

It is a place where data will be stored in a systematic and organized manner.

Basic Operations performed on the database are:

• Create/Insert
• Read/Retrieve
• Update/Modify
• Delete/Drop

It is generally known as “CRUD” Operations.

What is Database Management System (DBMS)?

It is software used to maintain and manage the database.

The main factors of DBMS are:

• Security 
• Authorization
• We use Query language to communicate

Types of DBMS Software?

There are four types of DBMS Software,

1. NDBMS(Network)
2. HDBMS(Hierarchical)
3. OODBMS(Object-Oriented)
4. RDBMS(Relational)