Book Information:
Book: Oracle 11g
Author: Joan Casteel
ISBN: 978-1-4390-4128-4
Other References: various online resources
SQL and Oracle 11g
Topics Covered in this course:
- Relational databases
- Creating and Read Entity Relational Diagrams
- Tables and other database objects
- Constraints on tables
- Manipulating Data from Database Tables
- Joining tables
- Single Row and Group functions
- Creating Users and understand privileges they may receive
Measurable Outcomes:
- Define a relational database
- Describe the importance of System Modeling
- Interpret Data Models
- Create Tables and Data Structures
- Retrieve and Display information
- Manipulate information
- Control User Access to Data and Database
- Perform computations with data
- Display data from multiple tables