Popular Posts

  • JSP Scripting Elements
    JSP scripting elements let you insert Java code into the servlet that will be generated from the current JSP page. There are three forms: ...
  • SQL ALIASES
    SQL aliases can be used with database tables and with database table columns, depending on task you are performing. SQL column aliases are u...
  • The JSP page Directive
    The page directive lets you define one or more of the following case-sensitive attributes: * import="package.class" or import=...
  • SQL Replication
    SQL Replication term describes a group of technologies allowing information distribution and mirroring between different databases. SQL repl...
  • JSP ARCHITECTURE
    JSP pages are high level extension of servlet and it enable the developers to embed java code in html pages. JSP files are finally compiled ...
  • SQL Server 2005 Express
    SQL Server Express is a free, easy to use, redistributable version of SQL Server 2005 designed for building simple data-driven applications....
  • SQL SELECT INTO
    The SQL SELECT INTO statement is used to select data from a SQL database table and to insert it to a different table at the same time. The g...
  • SQL AND & OR
    The SQL AND clause is used when you want to specify more than one condition in your SQL WHERE clause, and at the same time you want all con...
  • SQL Server – MS SQL Server
    MS SQL Server or simply SQL Server is RDBMS developed by Microsoft Corp. SQL Server uses a dialect of SQL called Transact-SQL (T-SQL). The S...
  • SQL ORDER BY
    The SQL ORDER BY clause comes in handy when you want to sort your SQL result sets by some column(s). For example if you want to select all t...

Saturday, February 28, 2009

SQL Tutorial

SQL Tutorial Table of Contents

SQL Tutorial
Learn what SQL (Structured Query Language) is, and where and how it is used.

SQL Table
SQL Database Tables are the foundation of every RDBMS (Relational Database Management System). Learn more about SQL tables here.

SQL SELECT
Learn how to use the SELECT SQL statement to retrieve data from a SQL database table.

SQL SELECT INTO
Learn how to use the SQL SELECT INTO statement to copy data between database tables.

SQL DISTINCT
Learn how to use the SQL DISTINCT clause together with the SQL SELECT keyword, to return a dataset with unique entries for certain database table column.

SQL WHERE
The SQL WHERE command is used to specify selection criteria, thus restricting the result of a SQL query.

SQL LIKE
The SQL LIKE clause is used along with the SQL WHERE clause and specifies criteria based on a string pattern.

SQL INSERT INTO
Learn how to use the SQL INSERT INTO clause to insert data into a SQL database table.

SQL UPDATE
Learn how to use the SQL UPDATE statement to update data in a SQL database table.

SQL DELETE
Learn how to use the SQL DELETE statement to delete data from a SQL database table.

SQL ORDER BY
Learn how to use the SQL ORDER BY statement to sort the data retrieved in your SQL query.

SQL OR & AND
Learn how to use the SQL OR & AND keywords together with the SQL WHERE clause to add several conditions to your SQL statement.

SQL IN
The SQL IN clause allows you to specify discrete values in your SQL WHERE search criteria.

SQL BETWEEN
The SQL BETWEEN & AND keywords define a range of data between 2 values.

SQL Aliases
SQL aliases can be used with database tables and/or with database table columns, depending on task you are performing.

SQL COUNT
The SQL COUNT aggregate function is used to count the number of rows in a database table.

SQL MAX
The SQL MAX aggregate function allows us to select the highest (maximum) value for a certain column.

SQL MIN
The SQL MIN aggregate function allows us to select the lowest (minimum) value for a certain column.

SQL AVG
The SQL AVG aggregate function selects the average value for a certain table column.

SQL SUM
The SQL SUM aggregate function allows selecting the total for a numeric column.

SQL GROUP BY
The SQL GROUP BY statement is used along with the SQL aggregate functions like SUM to provide means of grouping the result dataset by certain database table column(s).

SQL HAVING
The SQL HAVING clause is used to restrict conditionally the output of a SQL statement, by a SQL aggregate function used in your SELECT list of columns.

SQL JOIN
The SQL JOIN clause is used whenever we have to select data from 2 or more tables.
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)