Structured Query Language
(SQL)
Description
The purpose of this course is to introduce students to the basic
use of the query language SQL used to access information from relational
databases.
Upon completion of this course, students will:
Enter simple SQL data retrieval queries
Create tables and change table characteristics
Retrieve data using simple and complex functions
Manipulate data in tables
Use base security mechanisms for controlling access to data by
users
Control the display of data to the screen
Enter complex queries using multiple clauses for the retrieval
of data
Audience
Database users
Pre-requisites
None
Topics
SQL concepts
SQL syntax
SELECT statement
WHERE, IN, BETWEEN, and LINE
Functions
AVG, SUM, MIN, MAX, and COUNT
Arithmetic operations
ORDER BY, DISTINCT
Subqueries
GROUP BY and HAVING
Relational joins
INSERT, UPDATE, DELETE
CREATE, ALTER, and DROP TABLE
GRANT and REVOKE
|
