The Oracle Database 19c SQL & PL/SQL Development course provides step-by-step instructions on how to perform a variety of SQL development tasks for activities based on real-life work scenarios. This course provides step-by-step instructions for SQL & 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 & PL/SQL.

This course introduces students to the fundamentals of SQL & PL/SQL using Oracle Database 19c database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL & PL/SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

The students also learn to use single row functions to customize output, use conversion functions and conditional expressions and use group functions to report aggregated data. Demonstrations and hands-on practice reinforce the fundamental concepts.

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.

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

Duration: N/A

Audience:

Developers
Database Administrators
Technical Consultant
Business Intelligence Developer
Application Developers

Prerequisites:
Familiarity with data processing concepts and techniques

Course Objectives:

Run data definition language (DDL) statements to create and manage schema objects
Identify the major structural components of the Oracle Database 19c
Retrieve row and column data from tables with the SELECT statement
Create reports of sorted and restricted data

Employ SQL & PL/SQL functions to generate and retrieve customized data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Create reports of aggregated data
Use the SET operators to create subsets of data
Run data manipulation statements (DML) to update data in the Oracle Database 19c
Create PL/SQL Stored Procedures and Functions
Create PL/SQL Triggers and Packages
Handle PL/SQL Exceptions

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 19c 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 19c

Oracle Database 19c Options       

Database Management Packs      

Oracle Database 19c Related Products

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
PL/SQL Overview
Benefits of PL/SQL Subprograms

PL/SQL Programming      

Overview of the Types of PL/SQL blocks
Creating and Executing a Simple Anonymous Block
Generating Output from a PL/SQL Block

Using Triggers
Creating DML Triggers

Creating Stored Procedures and Functions
Understanding Stored Procedures and Functions
Differentiate between anonymous blocks and subprograms
Create a Simple Procedure
Create a Simple Procedure with IN parameter
Create a Simple Function
Execute a Simple Procedure
Execute a Simple Function

Handling Exceptions
Understanding Exceptions
Handling Exceptions with PL/SQL
Trapping Predefined Oracle Server Errors
Trapping Non-Predefined Oracle Server Errors
Trapping User-Defined Exceptions

Creating PL/SQL Packages
Understanding Packages
Creating a Package

Computer Based Training - CBT's - are 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 publishers CBT do NOT have voice.

This publishers CBT are NOT based on Flash. They are based on the latest technology which uses the: See It, Do It, and Try It learning paradigm. A very powerful new way of learning. Generally, CBT's tend to be more expensive.

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 CBT format. These factors give CBT's a clear advantage over conventional, inconvenient and expensive Classroom and Hard-copy print training methods.

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

CBT Simulation modes: 

See It Mode: enables a user to learn by watching an animated demonstration of the steps for a task being performed in a simulated environment. All required activities, such as moving the mouse are completed automatically. 

Try It Mode: enables a user to learn interactively in a simulated environment.

Do It Mode: enables a user to learn interactively using live data.

The WebLearning unique Methodology

All WebLearning® CBT and Courseware 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 CBT’S are 45% better than with conventional training methods

·        Your learning curve with CBT is 25%-55% less than conventional methods

·        The cost of CBT training is over 65% less than Classroom training

·        CBT’S are self pacing, interactive and simulate the actual software being studied