SQL - Sorting, Retrieving, and Filtering Data

http://connect.greenbeacon.com/Microsoft-SQL-Server.jpg

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.

SQL - Data Base Basics of SQL

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