Oracle Database 11g:Introduction to SQL
This course is part of the following part-time on campus and/or online program(s):
Students study the concepts of relational databases and the essential Structured Query Language (SQL) skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects. They also learn to control privileges at the object and system level. Topics covered include creating indexes and constraints and altering existing schema objects, how to create and query external tables, how to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also experience some of the date-time functions available in 11g Oracle Database and how to use the regular expression support in SQL.
Applicants must have post secondary education or equivalent work experience and fundamental skills to navigate comfortably through a computing environment. Students will be expected to use command line interface in this program.
All sections for this course are in progress.