SQL Tutorial | Learning SQL |SQL Overview

                     SQL - Overview:

What is SQL?

 Ans: SQL is structured Query Language which is a computer language for storing, manipulating and retrieving data stored in relational database.

SQL is the standard language for Relation Database System. All relational database management systems like MySQL, MS Access, Oracle, Sybase, Informix, postgres and SQL Server uses SQL as standard database language.

Also they are using different dialects, Such as:

    1.MS SQL Server using T-SQL,

   2. Oracle using PL/SQL,

    3.MS Access version of SQL is called JET SQL (native format )etc

 Ans2:

    1.SQL stands for Structured Query Language
    2.SQL lets you access and manipulate databases
    3.SQL is an ANSI (American National Standards Institute) standard

Why SQL?

    1.Allow users to access data in relational database management systems.

    2.Allow users to describe the data.

    3.Allow users to define the data in database and manipulate that data.

    4.Allow to embed within other languages using SQL modules, libraries & pre-compilers.

    5.Allow users to create and drop databases and tables.

    6.Allow users to create view, stored procedure, functions in a database.

    7.Allow users to set permissions on tables, procedures, and views

What Can SQL do?

    1.SQL can execute queries against a database
    2.SQL can retrieve data from a database
    3.SQL can insert records in a database
    4.SQL can update records in a database
    5.SQL can delete records from a database
    6.SQL can create new databases
    7.SQL can create new tables in a database
    8.SQL can create stored procedures in a database
    9.SQL can create views in a database
    10.SQL can set permissions on tables, procedures, and views

Posted in: learning SQL.,SQL Tutorial,SQL-Overview