SQL Basic- Why SQL?



        Why SQL?           

   Structured Query Language (SQL)   

  • Allows users to access data in relational database management systems.
  • Allows users to define the data in database and manipulate that data.
  • Allows users to create and drop databases and tables.
  • Allows users to create view, stored procedure, functions in a database.
  • Allows users to set permissions on tables, procedures, and views.
  • SQL perform CRUD function:
                  CREATE → New database.

                                      → New tables in database.

                                      → Record in database.    

                  READ         → Retrieve data from database.

                  UPDATE → Update records in a database.

                  DELETE → Delete records from a database.