ITM 143 - Structured Query Language and PL/ SQL

Institution:

Golden Gate University-San Francisco

Subject:

Description:

Provides a solid foundation in the syntax and the use of the Structured Query Language (SQL). This course builds upon the introduction to SQL provided in ITM 113. SQL is the standard language for most of the current relational database management systems. You will learn how to create applications using the programming language known as PL/SQL. The following topics will be covered: writing basic SQL select statements, restricting and sorting data, single row functions, displaying data from multiple tables, aggregating data using group functions, the syntax and use of the PL/SQL programming language, how to create functions, procedures, packages and triggers. This course makes extensive use of ORACLE. Prerequisite: ITM 113 or consent of the department.

Credits:

3.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Lecture

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.ggu.edu

Phone Number:

(415) 442-7800

Regional Accreditation:

Western Association of Schools and Colleges

Calendar System:

Trimester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.