Intro to PL/SQL

Source: home.earthlink.net
Topic: Oracle Programming

Short Desciption:
Introduction to PL/SQL 2-day Workshop Give your IT staff the knowledge of using Oracles procedural language: PL/SQL. The focus of this course is to students with a working knowledge of SQL the ...

 

Content Inside:
Introduction to PL/SQL 2-day Workshop Give your IT staff the knowledge of using Oracles procedural language: PL/SQL. The focus of this course is to students with a working knowledge of SQL the ability to develop Oracle procedures, functions, and database triggers using PL/SQL. The attendees have the opportunity to construct various PL/SQL routines to solve simple and complex business questions.  Dan will cover how to code PL/SQL, access data in a variety of methods, error handling, and will touch on debugging PL/SQL. The optional 3rd day involves training the attendees in how to use TOAD **OR** Oracles free SQL Developer tool to assist with their day-to-day development needs. Attendees will be able to use TOAD or SQL Developer to do the lab exercises and learn how to use the Procedure Editor and debug their PL/SQL routines.  Students will also see how to enter their SQL using the TOAD or SQL Developer interface, easily create spreadsheets from data, display data, see various application relationships, and more. The course utilizes a variety of current tools.  Students will have the opportunity to learn more about SQL Developer, TOAD, as well as the Oracle tools like SQL*Plus. Workshop Prerequisites: A working knowledge of SQL is required. Topics covered: • Oracle Architecture • Introduction to PL/SQL o Syntax and language structure • PL/SQL Topics o Cursor management o Exception handling o Procedures/Functions/Triggers o Packages o Collections • Optional SQL Developer or TOAD Tips and Techniques for IT Lectures and topics are enhanced with live illustrations and hands-on exercises Attendees Receive: • Study guide with presentations and relevant white papers • Book: Oracle9i Development by Example • Diskette full of example SQL and SQL*Plus scripts • Opportunity to ask the tough Oracle questions • A hands-on opportunity to learn more about Oracle, SQL Developer, and TOAD †...

 

 

 

 

cache werptfnaz0wj www preseps com search tutoriali pl sql na srpskom html pl sql na srpskom, cache lldiojbtjbqj www preseps com search pl sql ivan bayross torrent html introduction to pl sql ivan torrent, cache 6foa6wtifgij http www preseps com search sql exercises with answers pdf html sql exercises with answers pdf, plsql course content pdf, introduction to pl sql developer pdf, pl sql developer manual pdf download, pl sql shell script tutorial, debug plsql, pl sql lab manual pdf, pl sql faq pdf download, toad pl sql examples, download learn oracle procedure, plsql procedure examples pdf, pl sql free routines, guide to learn pl sql pdf, pdf plsql examples, toad manual 10 1, plsql toad tutorial, toad pdf download, pl sql examples exercises pdf