Course Description
A course in the use of the Oracle database management system to create, query, and update database tables. The course covers both the syntax and the logic of the major features of the Oracle SQL language. The course includes a brief introduction to the programming aspects of PL/SQL.
Student Learning Outcomes
Upon completion of this course, a student will be able to:
- Describe the basic concepts of databases, tables, relationships, and normalization.
- Analyze business requirements, designing and implementing queries that satisfy those requirements and using all of the major components of the SQL language for accessing data, including inner and outer joins, aggregate queries and subqueries, and a variety of the intrinsic functions supplied by Oracle.
- Manipulate an Oracle database using client software to create and modify database objects such as tables, constraints, relationships, and views following a database design and design and implement simple user-defined functions with PL/SQL.
- Create queries that will manipulate data in the database using Data Manipulation Language statements
Textbook
Jason Price; Oracle Database 12c SQL; Osborne Press/McGraw - Hill;
ISBN: 978-0-07-179935-5 (list price $ 60.00 , available for about $3 5 online) .
