How This Course Is Organised

The Oracle Database 18c Development Essentials course provides step-by-step instructions on how to perform a variety of administrative and development tasks for activities based on real-life work scenarios. The WebLearning hands-on series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical real world situations, not only is knowledge gained through valuable hands-on experience, but also the solutions presented may then be used as the foundation for production implementation, dramatically reducing time to deployment.

 

Students get introduced to the Oracle Database 18c Enterprise Edition Options, Architecture and Relational Database Modelling Concepts..  

 

This course provides step-by-step instructions for SQL and PL/SQL Database Application Development tasks using Oracle SQL Developer Tool. Students learn to build an Oracle Database and then develop database related applications using SQL and PL/SQL.

 

Certification 

This course will assist in preparation for the Oracle Database Administration and Application DevelopmentI OCP Certification exams.

 

Duration           

N/A

 

Audience 

Functional Implementer

Semantic Layer Modellers

Database Administrators

Technical Consultant

Business Intelligence Developer

Application Developers

Prerequisites:

Completed the WebLearning Oracle SQL Essentials Course

Working experience with Oracle Database Applications

Course Topics:

Overview

Business Scenario  

The Evolution of Oracle       

Milestones

Introduction to Databases and the Relational Model

Key Oracle DBMS Concepts         

Data Modeling and Database Design      

Stages of System Development    

Basic Types of Data Relationships           

The Role of Ordinality and Normalisation  

Relational Database Components

Oracle Database 18c Development Tools

Oracle SQL Developer        

Navigate SQL Developer-voip       

Exploring Database Objects          

SQL*Plus and SQL Workshop       

Connecting to the  SQL*Plus Interface      

Introduction to Oracle Database 18c

Oracle Database 18c Options

Database Management Packs      

Oracle Database 18c Related Products

Oracle Autonomous Database Cloud Services

Oracle Database 18c Architecture

Oracle Memory Structures  

Oracle Background Processes      

Oracle Disk Utilisation Structures  

Application and Networking Architecture  

Starting and Stopping the Oracle Instance           

Starting the Oracle Instance and Opening the Database

Shutting Down the Oracle Database         

Changing Database Availability and Restricting Login

Creating an Oracle Database

Parameter Files       

Creating the Oracle Data Dictionary

Introduction to SQL

Understanding SQL Processing    

Understanding the Optimizer          

Embedded SQL       

Data Definition Language

Creating a Database Connection  

Creating Tables       

Modifying Tables      

Managing Constraints         

Deleting Tables        

Exploring Constraint Information    

Data Manipulation Language

Creating Queries     

Selecting Columns in a Table         

Selecting Individual Columns in a Table    

Using Column Aliases         

Selecting Rows        

Joining Tables          

Joining Tables with an ON Clause 

Applying Conditions to a Join         

Joining A Table To Itself      

Creating Outer Joins           

Displaying Data From Multiple Tables      

Using Functions

Using Character Functions 

Using Numeric Functions    

Using Date Functions          

Formatting Dates     

Using the NVL Function      

Group Functions

Using Group Functions        

Using Group BY Function    

Excluding Group Data With Having

Data Manipulation Language (DML) Statements

Inserting Data           

Updating Single Row of Data         

Updating Multiple Rows of Data     

Using the FOR UPDATE Clause   

Deleting Data

Data Control Language

Commit and Rolling Back Transactions    

Database Security Model   

Creating a Database User Account          

Unlocking a Database User Account        

Granting System Privileges

Granting System Privileges to User           

Granting Object Privileges  

Granting And Revoking Object Privileges 

Granting And Revoking Object Privileges to User           

Using Synonyms For Database Transparency     

Introduction to PL/SQL Programming 

PL/SQL Blocks        

Creating an Anonymous Block       

Using Triggers          

Creating a DML Trigger      

Using Procedures and Functions   

Creating a Procedure          

Creating a Function 

Handling Exceptions

Creating  Exceptions           

PL/SQL packages   

Creating a Package

     

NOTE: THIS COURSE IS ALSO AVAILABLE IN SELF-STUDY CBT, TRAINING GUIDES OR DISTANCE LEARNING FORMATS. FEEL FREE TO ASK IF YOU PREFER DISTANCE, CBT OR TRAINING GUIDES E-BOOK LEARNING FORMATS. PRICES DIFFER.

 

 

What is eLearning?
eLearning is like CBT (Computer Based Training) training but eLearning is conducted over the internet with tutor support and is usually interactive with Software Simulations (behaves like you're using the real thing on the PC, therefore you don't even need the real software installed on your machine) and sometimes BUT NOT ALWAYS with voice. This Publisher's eLearning Titles do NOT have voice.

Today's competitive business environment and frequent software updates by software vendors demands rapid skill acquisition. WebLearning Publishing helps you keep up-to-date by delivering quality Interactive Self-Study in eLearning format. 

These factors give eLearning a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

eLearning not only offers the advantage in terms of convenience and lower cost, but it also facilitates improved subject-matter comprehension.

 

The WebLearning unique Methodology

All WebLearning®  CBT,  eLearning and Training Guide courses are based on the latest materials available at the time of publishing and are regularly updated every 3 months with FREE UPGRADES to the LATEST EDITION: ANEW, very effective and proven way of learning. 

FACT:

• Material retention with eLearning are 45% better than with conventional training methods
• Your learning curve with eLearning is 25%-55% less than conventional methods
• The cost of eLearning training is over 65% less than Classroom training
• eLearning are self-pacing, interactive and simulate the actual software being studied