Sql Introduction

Sql stands for - structured query language
                         Basically Sql is a programming language which manages data
                     
Developed by - E F codd

Why we need SQL ?

• If user want to do any type of manipulation like insert , delete , update , create on data in database he/she has to write the sql queries.
• Without sql queries we cannot interact with database engine.
• Sql query is standardised programming language by ANSI
• To implement function , operations on data sql query needed.
• To save you data of website or any kind of digital data you need database.
• So , if you are in database . All you need to know is sql queries and you can easily interact to you database

What happens when SQL runs ?

• when a sql query is executed two thing happens 

      1 . The first step is query compilation, which generates a query execution plan by the SQL 
            Server engine

       2 . The second step is execution of the query execution plan by the SQL Server storage engine.

  

 Examples of Database tools :

                                                   Oracle , sql , sqlLite , sql server  etc 

Next Blog we'll learn - Types of Sql commands