Tuesday, January 22, 2013

SQL - Sorting, Retrieving, and Filtering Data

Print Friendly and PDF

Query Terms and Syntax Rules

query: a command that you use to retrieve data from one or more tables.

clause: a component  of an SQL statement.

keywords: reserved words.

statement: keywords and data in the SQL query.

FROM keyword: to indicate the table to retrieve data from.

SELECT keyword: gives you the ability to retrieve data from the table by telling the database which column(s) to display.

Monday, January 21, 2013

SQL - Data Base Basics of SQL

Print Friendly and PDF

SQL is a computer language used to retrieve and manipulate data from relational databases. Some of the functions of SQL:

  • Modify a database's structure
  • Change system security settings
  • Add user permissions to databases
  • Query a database 
  • Update a database

Important terms

  • client: a single-user computer that interfaces with a multiple-user server
  • client/server database system: system that divides time between a client and a database server
  • database: collection of related data stored as organized files
  • server: multiple-user computer that holds the actual database and provides shared database connection, interfacing, and processing services