eBay

ADVANCE YOUR CAREER. TRANSFORM YOUR LIFE WITH IN-DEMAND SKILLS FOR AN ON.DEMAND WORLD. EARN MINIMUM £50K WITH YOUR ORACLE SKILLS.

EXCELLENT INTERACTIVE SELF-TEACH COMPUTER BASED TRAINING COURSE . IDEAL FOR THOSE DESIGNING AND DEVELOPING DATABASE, DATA WAREHOUSE, OLAP, ANALYTICS, BI AND REPORTING APPLICATIONS IN ANY ORACLE DATABASE DEPLOYMENT ENVIRONMENT.

PERFECT SELF-STUDY TRAINING COMPANION FOR ANALYSTS AND MODELLERS, BI/OLAP DEVELOPERS, SAP BW CONSULTANTS, PEOPLESOFT, ORACLE EBS, JD EDWARDS, ORACLE COMMUNICATIONS, ORACLE RETAIL APPS., SIEBEL ANALYSTS AND PROJECT MANAGERS.

ALSO FITS IN WELL FOR THOSE WHO WORK WITH OR WISH TO CROSS/UPSKILL FROM SQL SERVER, IBM DB2 OR SYBASE TO AN ORACLE ENVIRONMENT.

ORACLE DATABASE 12 and 19c: SQL & PL/SQL CERTIFIED ASSOCIATE SELF-STUDY CBT

How This Course Is Organised

The Oracle Database 19c SQL & PL/SQL Essentials Certified Associate 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.

Duration: N/A

Audience
Developers
Semantic Layer Modellers
Database Administrators
Technical Consultant
Business Intelligence Developer
Application Developers

Prerequisites:
Familiarity with data processing concepts and techniques

Certification
This course will assist in preparation for the Oracle Database Administration and Application DevelopmentI OCA - 1Z0-071 and 1Z0-149 Certification exams.

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
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 119c
Employ SQL & PL/SQL functions to generate and retrieve customized data
Create PL/SQL Triggers
Create PL/SQL Stored Procedures and Functions
Create PL/SQL Packages

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 Development Tools
Oracle SQL Developer
Navigate SQL Developer
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

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

What is a CBT?

CBT's are 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 CBT Titles do NOT have voice..

Generally, CBT's tend to be more expensive. Our CBT Titles 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. All CBT and Training Guide Learning formats are delivered with FULL LICENCE KEY.

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.

NOTE: WebLearning Publishing CBT and Training Guide products are now delivered with FULL LICENCE KEY.

FACT:

· Material retention with CBT's are 45% better than with conventional training method
· Your learning curve with CBT is 25%-55% less than conventional method
· The cost of CBT training is 75% less than Classroom training
· CBT’S are self pacing and Interactive
· CBT’S simulate the actual software being studied so there is no need to have the actual software installed

The WebLearning unique Methodology

All WebLearning® 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: A NEW, very effective and proven way of learning.

NOTE: WebLearning Publishing Courseware products are no longer available in Hard-copy format. They are now delivered in eBook Format with FULL LICENCE KEY.