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 †...

 

 

toad tutorial procedure editor, pl sql lab exercise, intriduction to sqlpdf, turtorial on sql using toad, pdfs on sql and pl sql, toad tutorial, course pdf plsql, discoverer online tutorials, oracle 9i plsql pdf, introduction to oraclesql and pl sql student guide, notebooks for prepration of oracle certified programmer in pdf form, toad hand on turtorial sql, pdfplsql cursors, pl sql tutorials, download pl sql tutorial, oracle discoverer student guide pdf download, introduction to oracle 9i plsql pdf, tutorial on toad for sql, plsql pdf download, free download code pl sql