SQL

What Is SQL?

SQL is a slandered language for accessing and manipulating database.Its ANSI Standard. SQL is a Structured Query Language. You can access and manipulate database.



SQL Can Do:


  • SQL can Execute queries against a database.
  • SQL can retrieve data from database.
  • SQL can Insert records in database.
  • SQL can Update records in a database.
  • SQL can Delete records from a database.
  • SQL can Create new database.
  • SQL can Create new table in a database.
  • SQL can Create stored procedure in a database.
  • SQL can Create view in a database.


  • SQL can Set permissions on tables, procedures and views.


  • The topic will cover in this tutorial in Advance SQL:
    CREATE DB
    CREATE TABLE
    CREATE INDEX
    Key & CONSTRAINT
    AUTO INCREMENT
    SELECT
    INSERT
    UPDATE
    DELETE
    DROP
    USE DATABASE
    LIKE
    WILDCARD
    IN
    BETWEEN
    ALIAS
    JOIN
    UNION & UNION ALL
    INTERSECT
    TOP
    TRUNCATE
    ALTER
    VIEW
    SUBQUERY
    WHERE
    AND & OR
    NULL & NOT NULL
    GRANT & REVOKE
    TRANSACTION
    DISTINCT
    Functions
    AVG()
    COUNT()
    SUM()
    FIRST()
    LAST()
    MAX()
    MIN()
    GROUP BY()
    HAVING()
    ORDER BY()
    UCASE()
    LCASE()
    MID()
    LEN()

    NOW()


    Share this

    Related Posts

    Previous
    Next Post »

    :)
    :(
    hihi
    :-)
    :D
    =D
    :-d
    ;(
    ;-(
    @-)
    :P
    :o
    :>)
    (o)
    :p
    :-?
    (p)
    :-s
    (m)
    8-)
    :-t
    :-b
    b-(
    :-#
    =p~
    $-)
    (y)
    (f)
    x-)
    (k)
    (h)
    cheer

    Popular Posts