Scribd Logo
Upload

Welcome to Scribd!

  • 45 views

    Introduction To SQL

    Uploaded by

    Mohammed Ali
    SQL is a standard language for accessing and manipulating databases. It allows users to query data, as well as insert, update, and delete records from databases. SQL became a standard in 1986 by ANSI and 1987 by ISO. Although different versions of SQL exist, they all support major commands like SELECT, UPDATE, DELETE, INSERT, and WHERE. To build a website that displays data from a database requires an RDBMS database program, a server-side scripting language, SQL to retrieve data, and HTML/CSS to style the page.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Introduction To SQL

    Uploaded by

    Mohammed Ali
    45 views2 pages
    SQL is a standard language for accessing and manipulating databases. It allows users to query data, as well as insert, update, and delete records from databases. SQL became a standard in 1986 by ANSI and 1987 by ISO. Although different versions of SQL exist, they all support major commands like SELECT, UPDATE, DELETE, INSERT, and WHERE. To build a website that displays data from a database requires an RDBMS database program, a server-side scripting language, SQL to retrieve data, and HTML/CSS to style the page.

    Original Description:

    Start learning SQL

    Original Title

    Introduction to SQL

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    SQL is a standard language for accessing and manipulating databases. It allows users to query data, as well as insert, update, and delete records from databases. SQL became a standard in 1986 by ANSI and 1987 by ISO. Although different versions of SQL exist, they all support major commands like SELECT, UPDATE, DELETE, INSERT, and WHERE. To build a website that displays data from a database requires an RDBMS database program, a server-side scripting language, SQL to retrieve data, and HTML/CSS to style the page.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    45 views2 pages

    Introduction To SQL

    Uploaded by

    Mohammed Ali
    SQL is a standard language for accessing and manipulating databases. It allows users to query data, as well as insert, update, and delete records from databases. SQL became a standard in 1986 by ANSI and 1987 by ISO. Although different versions of SQL exist, they all support major commands like SELECT, UPDATE, DELETE, INSERT, and WHERE. To build a website that displays data from a database requires an RDBMS database program, a server-side scripting language, SQL to retrieve data, and HTML/CSS to style the page.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 2

    Introduction to SQL

    What is SQL?
    • SQL stands for Structured Query Language
    • SQL lets you access and manipulate databases
    • SQL became a standard of the American National Standards Institute
    (ANSI) in 1986, and of the International Organization for Standardization
    (ISO) in 1987

    What Can SQL do?


    • SQL can execute queries against a database
    • SQL can retrieve data from a database
    • SQL can insert records in a database
    • SQL can update records in a database
    • SQL can delete records from a database
    • SQL can create new databases
    • SQL can create new tables in a database
    • SQL can create stored procedures in a database
    • SQL can create views in a database
    • SQL can set permissions on tables, procedures, and views

    SQL is a Standard - BUT....


    Although SQL is an ANSI/ISO standard, there are different versions of the SQL
    language.

    However, to be compliant with the ANSI standard, they all support at least the
    major commands (such as SELECT, UPDATE, DELETE, INSERT, WHERE) in a similar
    manner.
    Using SQL in Your Web Site
    To build a web site that shows data from a database, you will need:

    • An RDBMS database program (i.e., MS Access, SQL Server, MySQL)


    • To use a server-side scripting language, like PHP or ASP
    • To use SQL to get the data you want
    • To use HTML / CSS to style the page

    RDBMS
    RDBMS stands for Relational Database Management System.

    RDBMS is the basis for SQL, and for all modern database systems such as MS
    SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access.

    The data in RDBMS is stored in database objects called tables. A table is a


    collection of related data entries and it consists of columns and rows.

    You might also like