Halloween Sale: Flat 70% + Addl. 25% Off + 30 Days Extra Lab on all Courses | Use Coupon HS25 in Checkout | Offer Expires In

  Enroll Now

Introduction to SQL

What is SQL

  • SQL is a very simple, intuitive and self-explanatory data reading and modification language like typical English sentence formations.

  • SQL stands for Structured Query Language and is a standard term for such purposes

  • SQL lets you access and manipulate databases (read and modify)

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

With SQL, one can

  • Read data from a database (SELECT)

  • Insert new data or rows in a database (INSERT)

  • Update/modify existing rows in a database (UPDATE)

  • Delete rows from a database (DELETE)

  • Create new databases

  • Create new tables in database

  • Create view, procedures and other types of objects in a database

  • Change the structure of tables/indexes/other objects (ALTER)

  • Set permissions on tables/procedures/views and other objects

Syntax of a basic SELECT SQL statement:

SELECT field1, field2,...fieldN
[FROM table_name1, table_name2...]
[WHERE Clause]

SQL statements are run against a database and few or all columns are selected from a table stored in database files.

We will study more about database and database management systems in this series.


No hints are availble for this assesment

Answer is not availble for this assesment

Loading comments...