2020-2021 Undergraduate Catalog 
    
    Oct 03, 2024  
2020-2021 Undergraduate Catalog [ARCHIVED CATALOG]

ISBA 450 - Advanced SQL


Credit Hours: 3
Lecture Hours: 3
Lab Hours: 0

This course provides students with advanced SQL skills that allow them to write effective queries against single and multiple tables; manipulate data in tables; create database schema objects; create indices and constraints; alter existing schema objects; create and query external tables; and learn to use the advanced features of SQL in order to query and manipulate data within the database. Students also learn to control privileges at the object and system level and will be able to work with date-time functions available in the Oracle Database. In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus will be introduced as an optional development tool. This course is one of three Oracle certification training courses.
Prerequisite: ISBA 321