Oracle Fundamentals
Duration: 3 Days Instructor-Led
Practical introduction to fundamental Oracle concepts. Students learn how to create a data model, and how to implement it as a database.
Target Audience
Database administrators, programmers and system administrators who want an introduction to Oracle and its use, and an introduction to SQL.
Prerequisites
Computing background, preferably with some database or programming experience.
Course Outline
- Database Concepts
- Data Normalization
- Data Modelling and Design
- Introduction to SQL
- PL/SQL
- Database Objects
- Oracle Architecture
Practical Skills Gained
- Create a basic data model
- Implement model as functioning Oracle database
- Write SQL queries
- Create and modify tables
- Manage user privileges
- Understand Oracle architecture


