reed.co.uk Courses

Header

Oracle 9i Course Bundle Training


EduCBA

Summary

Price
Save 90%
£10 inc VAT (was £99)
Offer ends 31 December 2019
Study method
Online, self-paced
Duration
41 Hours
Access to content
Lifetime access
Qualification
No formal qualification
Additional info
  • Certificate of completion available and is included in the price

Add to basket or enquire

Overview

Oracle 9i Course Bundle

  • 41+ Hours OF HD VIDEOS
  • Verifiable CERTIFICATION
  • Practical SKILLS DEVELOPMENT
  • Accelerate YOUR CAREER
  • Lifetime Access 24*7 Unlimited Access
  • Access through any device
  • Technical support
  • Mobile App Access

In this course on Oracle SQL Training, you will learn about Producing Readable Output with iSQL*Plus, Manipulating Data, Creating and Managing Tables, Including Constraints etc. The course starts from scratch and hence a beginner can also take and enjoy this course.

Description

Oracle 9i Course Bundle

In this course on Oracle SQL Training, you will learn about Producing Readable Output with iSQL*Plus, Manipulating Data, Creating and Managing Tables, Including Constraints etc. The course starts from scratch and hence a beginner can also take and enjoy this course.

About the Oracle 9i Course Bundle:

In this Training Bundle you will learn about 3 Major Concepts:

  • Oracle SQL Training
  • Oracle PLSQL Training
  • Oracle Database Administration 1

In this Oracle 9i Course Bundle we will learn:

  • RDBMS Concepts & ER Model And Normalization
  • Transact SQL Statements
  • Creating & Managing Database
  • Accessing Data From Database
  • Creating Tables & Using Data types
  • Introduction to Data Integrity
  • Introduction to Indexes
  • Types of Indexes
  • Maintaining Indexes
  • Implementing Views

In this Oracle 9i Course Bundle Training we will learn:

  • Create triggers to solve business challenges.
  • Use some of the Oracle supplied PL/SQL packages to generate screen output and file output.
  • Create anonymous PL/SQL blocks of code.
  • Declare PL/SQL Variables
  • Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
  • Create and use stored procedures and functions Design and use PL/SQL packages to group and contain related constructs
  • Create overloaded package subprograms for more flexibility Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
  • Write dynamic SQL for more coding flexibility Describe the features and syntax of PL/SQL Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Oracle Built-in Data Types
  • ROWID Format,Structure of a Row
  • Truncating , Dropping Table
  • Bitmap Indexes
  • Changing Storage Parameters for Indexes

Who is this course for?

  • Application Developers
  • Database Administrators
  • Developer
  • Forms Developer
  • Portal Developer
  • System Analysts

Requirements

  • Knowledge of SQL will be helpful (Although the course starts from Scratch)
  • Passion to learn Oracle 9i Bundle

Questions and answers

Currently there are no Q&As for this course.Be the first to ask a question.

Rating and reviews

There haven't been any reviews for this course yet.

Leave a review

Modals