Training

Information Technology

Oracle Database Developer

Start: TBA       Type: Evening / Weekend Classes       Duration (hr): 65

 

COURSE DESCRIPTION:
Course covers the fundamentals of database design. Students will review the concepts, principles, and purposes of databases. They will learn the processes often employed when developing a relational database. The student will also be introduced to Object Oriented Analysis approach to database design, and will determine how those methodologies fit in to Oracle Database development.
 
COURSE OBJECTIVES: Guide students to learn how to
  • Create and maintain database objects.
  • Store, retrieve, and manipulate data.
  • Create PL/SQL Blocks of application code
  • Prepare for Oracle’s exam, Introduction to Oracle SQL & PL/SQL
 
HANDS-ON TRAINING: The expert instructors guide students through practical hands-on exercises that reinforce their Oracle database developer skills. Exercises included;
  • Create, Update, Inserting Oracle DB tables
  • Use Oracle Data Dictionary
  • Created temporary tables, views and public synonyms
  • Manipulate with Oracle Data by using SQL DDL, DML statements
  • Create, format SQL reports
  • Create stored procedures, packages & triggers.
 
THE FOLLOWING TOPICS WILL BE COVERED:

Introduction to Data Base Management
Client Server Concepts
What is SQL
VIEWS, Set Operators
SQL Features
Oracle DATA DICTIONARY
Development Tools
Introduction to PL/SQL
Collections
Function, Procedure, Package
Dynamic SQL and PL/SQL Features
Introductory of Objects
Collection Methods
Oracle Standard Packages

 

(*) Contact us about current Discounts and Promotions 

Related Courses