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

 

 

 

 

free download pl sql pdf, free download introduction to pl sql ebook, pl sql beginners pdf, pl sql for beginners pdf download, tough oracle sql tutorial, hands on pl sql tutorial free, toad ebook for beginners, introduction to oracle pl sql ebook free download, oracle9i sql with an introduction to pl sql download ebook, pl sql tutorials for beginners, complex plsql questions, pl sql tutorial for beginners exercises, oracle 9i pl sql free exercises download, free toad pdf for pl sql procedure, pl sql beginners tutorial download pdf, pl sql beginners tutorial, free pl sql tutorial for beginners, beginners guide to pl sql with exercises, pdf for cursor in pl sql, tutorial pl sql