Oracle Database Fundamentals to Everyone

Please note, the topics mentioned here are only the major subtopics within the course

• Overview of RDBMS
  • Overview of key DBMS concepts
  • The relational Database Model
  • Working of a typical RDBMS
• Design of Oracle RDBMS
  • Structure of Oracle RDBMS
  • A step-by-step approach to Data modeling
  • ER Models and Normalisation
• Introduction to SQL and PL/SQL
  • SQL Fundamentals
  • Access DB objects through SQL (DDL)
  • Database views and customisation
  • PL/SQL - Procedures and functions
• Oracle Architecture Concepts
  • Oracle Database Organisation
  • More about Oracle Instances
  • Maintenance of Oracle Schemas
• Oracle DB objects and Indexes
  • Creation/modification of Database Tables
  • Maintenance of Database Indexes
  • More about DDL, DML, and DCL constructs
• Advanced SQL*Plus
  • SQL Generation from SQL constructs
  • Spooling of output as OS files
  • Copying of Database tables
  • Analysis of DB object locking
• Step into Oracle Database Administration
  • Understanding Oracle DBA tasks
  • About Administering Oracle-based Business Applications
  • About fail-safe Oracle Instances

 

ENROL                             Request Info                             IT Courses Page