CPTR 522701
Structured Query Language (SQL)

COURSE DESCRIPTION:

Structured Query Language (SQL) is a standard language that allows users to query data from databases, update information within databases, create and delete tables, rows and columns, and control access to data. It is included in products other than databases, and many familiar programming languages are designed to work with embedded SQL. Many of these products support SQL with proprietary extensions, but all such products support a common subset of SQL. This course focuses on that common subset of SQL used by over 100 databases, languages and software applications.

COURSE OBJECTIVES:

• Use queries to extract information
• Create new tables, alter tables, and eliminate tables
• Insert data, update data, and delete data from tables
• Discuss data access security
• Create views to limit access to columns and rows in tables

PREREQUISITES:

A working knowledge of computers, and basic database concepts.

CEU:

1.4 CEU