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

 

 

hands on pl sql, sql pdfs, sql tutorial pdf download, introduction to oracle 9i pl sql free download book, introduction to oracle 9ipl sql tutorial in pdf, free download oracle 9i pl sql pdf version, oracle student guide, oracle 10g workshop pdf download, introduction to oracle 9i sql student guide, plsql exercises, plsql tutorials download pdf, pl sql pdfs free, getting started with oracle pl sql pdfs, free pl sql pdf downoad, manual oracle en toad pdf, free pl sql pdf book, intro working with oracle 10g pdf download, toshiba satellite a100 pl, introduction to oracle 9i sql student guide pdf download, free downloadbale error handling books for oracle developer