ITS 33475 ORACLE SQL

Introduction to Oracle relational database concepts; Use of SQL for storing, retrieving, and manipulating data in relational database; Access data from more than one table using joins; Aggregate data using group functions, writing sub-queries, and create and populate Oracle database tables; Define, maintain, and modify other database objects; Use SQL's Data Manipulation Language and transaction controls; Control both user and object level security in an Oracle database; Use basic PL/SQL. Prerequisite: ITS 30163 Database Management, ITS 33470 Networking, or consent of instructor