Company Information

QRCode for Mobile Website
Visit our Mobile website.
Our Blog

Public Courses

Data Dog - Training your Data
Data Dog understands your Database issues.
Oracle

Microsoft

Java Training

Management

CNN Top Stories

Scouts' vote sends confused message

John Sutter says the organization's vote to allow gay and lesbian Scouts but not leaders is illogical and continues to teach discrimination to its young members.

Coburn: No, I don't oppose tornado aid

Sen. Tom Coburn says, despite what some reports say, he agrees with FEMA funding for tornado relief, but if it runs out, he will stick to his policy.

Will New Yorkers want a Mayor Weiner?

Errol Louis says even with ideas, the shamed congressman--and Park Ave. denizen--may have a tough time selling himself anew as a middle class champion to a city and its media

Don't blame Apple, blame the tax code

Will Marshall says Tim Cook was grilled about Apple's tax practices but the real culprit is a dysfunctional tax system.

MJ was called 'freak' before deal

A top AEG executive referred to Michael Jackson as "a freak" and another called him "creepy" just hours before their company signed the pop icon to a huge concert deal.

Boston suspect may have killed in 2011

Bombing suspect Tamerlan Tsarnaev took part in a triple homicide outside Boston, a U.S. law enforcement official said. The source said Chechen Ibragim Todashev also confessed his role before he died. FULL STORY

Rescued women send us a message

Three women who were rescued this month after allegedly being held captive in a Cleveland house for close to a decade "are happy and safe," and overwhelmed by the public's support, their attorneys said in a statement released Wednesday.

Face-eating victim starting over

Hospital staff discuss the recovery of Ronald Poppo after a man chewed off parts of his face on a Miami street last year.

'Hangover' and 19 other top buddy films

Stars on the Cannes red carpet


Tech Learning

Artopia: Sculpture

Pay a visit to this examination of sculpture in the realm of fine arts

Science of Baseball

The Exploratorium in San Francisco offers this extensive site that looks into many aspects of baseball.

You Can’t Spell the Word Prefix Without a Prefix

Recognizing and using word prefixes helps with reading comprehension and specificity in writing.

Video Tutorial: Kid Pix Deluxe 4 – Paintzone and Slideshow

In today's video, learn about the two parts of Kid Pix Deluxe 4—the Paintzone art-making tool and the Slideshow presentation tool.

Math Challenge

Challenge your younger students to use their problem-solving skills with these short problems.

Is It Safe to Live Near a Volcano?

The primary focus of this excellent interactive site is for users to decide how to plan for evacuation when a volcanic eruption is imminent.

New York Times Book Review: A Literary Map of Manhattan

What an interesting way to explore Manhattan and its place in American literary history.

Kids and Money

This site, divided into information for five different age groups, provides lessons and activities that teach important lessons about saving, spending, and ways to avoid debt.

Product Review: The Answer Pad

The Answer Pad is an enhanced student response system with an automatic grading tool for quizzes and assessments that supports BYOD

Microbe Clock

One of the daunting battles scientists are fighting now is preventing antibiotic resistance of certain bacteria that cause lethal diseases.


Information

On-Site Training - Have wheels will travel !!
On-site training course details, Click to view.
NPR World News

Can This Man Bring Silicon Valley To Yangon?

A Stanford MBA who used to work for Google returned to Myanmar to be an Internet entrepreneur. But it's tough to start an Internet company in a country where the power goes out every day.

Four Arrested After British Soldier Hacked To Death In London

The two men charged with killing a British soldier in south London on Wednesday were apparently on a government watch list, raising questions about why authorities were unable to prevent the attack.

One Of London Attack Suspects Had Troubled Past

Robert Siegel speaks with Sandra Laville, crime correspondent for The Guardian, about what's known about the suspect in the Woolwich attack in London on Wednesday.

Syrian Rebels Continue To Clash With Hezbollah-Backed Forces

Robert Siegel speaks with Anne Barnard, Beirut bureau chief for The New York Times, about clashes between Syrian rebels and government forces backed by Hezbollah fighters.

More Young Syrians Flee Home Lives To Face The Unknown

Over the past few months, the security situation in the Syrian capital Damascus has been deteriorating. For many Damascenes, the city they always called home is no longer a livable place. They can't make a living anymore, and everyday is a risk that tempts fate. In an exodus from Damascus, many young professionals are abandoning their lives at home to flee abroad and face the unknown.

A Look Ahead To The Flash Point In The South China Sea

Beijing continues to pressure its neighbors over strings of disputed areas in the South China Sea that reportedly hold massive deposits of oil and gas. The ongoing disputes raise serious questions about China's goals in the region and how the United States should address escalating tensions.

Pitbull Gets 'Epic': 'You Constantly Have To Defend Your Success'

Armando Christian Perez — better known as Pitbull or Mr. Worldwide — has sold five million albums and had No. 1 hits in more than 15 countries. He tells NPR's Michel Martin about using music as an escape and playing a well-dressed toad in the animated film Epic.

Reports: Obama To Limit Drones, Urge Action On Guantanamo

The president is set to deliver Thursday what's being billed as a major address on national security. Officials are telling news outlets that he'll be addressing two controversial topics: The use of drones to kill suspected terrorists; and the closing of the Guantanamo Bay detention center.

As Myanmar Reforms, Indonesia Offers Some Lessons

Recent sectarian strife in Myanmar threatens the country's nascent democratic reforms. Not so long ago, Indonesia faced similar challenges. Now, it's a thriving democracy.

'On Top Of The World' At 80: Japanese Climber Summits Everest

A Japanese mountaineer has become the oldest person to conquer Mount Everest, as Yuichiro Miura, 80, reached the peak Thursday morning. The feat marks Miura's third time atop Mount Everest. As in 2008, Miura's accomplishment is in danger of being surpassed by rival climber Min Bahadur Sherchan, 81.


Oracle Web Site

Valid HTML5

Level A conformance icon, W3C-WAI Web Content Accessibility Guidelines 1.0

Valid CSS!

Get Adobe Reader



 
Contents

A complete guide to PLSQL in a 10g Database, please refer to the index for this course for full details. The following aspects are included:

The Processing Block in PLSQL
Using Explicit Cursors in PLSQL
Loop Processing in PLSQL
Programmer Defined Procedures
Instead Of Triggers
Using UTL_FILE for I/O
Index By Tables in PLSQL




Exercises

There are practical and comprehensive exercises scheduled throughout the course to ensure delegates leave with a sound theoretical and practical knowledge.

The exercises include:

Inserting Records using a Loop
Selecting Records using Explicit Cursors
Writing Audit Trails to the Operating System
Using PLSQL to create Database Objects
Using Triggers to validate records


Duration

Five Days

Oracle PLSQL 10g training course details.

Oracle PLSQL 10g
Training Course

Synopsis

PLSQL language is Oracle's versatile procedural extension to SQL, which capitalises on SQL's functionality and can increase database efficiency, effectiveness, scalability, portability and security.


Course Preview

The following options give examples of Course content ...

Index of Training Course Index of Training Course (html) Example pages of Delegate Manual Sample exercise


Pre-Requisite Course(s)

Essential SQL

Suggested Further Course(s)

Forms 10g
Reports 10g



This intensive training course has a dynamic face to face, tutor led learning framework and is delivered by an experienced Oracle professional. In-depth course notes are provided in a presentation file for the delegate to use, and this becomes a valuable reference guide following the course.

On completion all delegates receive a certificate.



On Site or Off Site ?

On Site

All that we require is a private room with tables and chairs, that is large enough to comfortably hold your delegates and a tutor. We will provide each delegate with an individual laptop and all other equipment that is required.

Off Site

If you prefer instead of delivering on site we can deliver the course off site at Seer House, Swansea or we will be happy to arrange a neutral venue that is convenient for you (please be aware this will incur additional costs).



Weekday or Weekend ?

This course has the provision to be delivered over the weekend.
Ideal for your company, if you are working on projects with tight timescales or need to train employees with incredibly busy working weeks.



Standard or Customised ?

If you feel that this is not entirely suitable for your company requirements we offer the service of creating bespoke training packages. We can either customise this training to your exact company requirements or work with you to build a completely new one (please be aware this will incur additional costs).



Contact Details

Please contact us on
+44 (0) 800 157 7519 or email at training@seercomputing.com