Acrobat X Files

Home > Programming > Oracle Programming

Oracle PLSQL Programming

Sort Desciption:

ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...

Content Inside:

Oracle PLSQL ProgrammingPage 1ORACLE PL/SQL PROGRAMMINGCourse Code 2PTC313Module AimsThe aims of the module are to:Support students to develop a good understanding PL/SQL.Introduce concepts of cursors and exception handling.Learning OutcomesBy the end of the module students are expected to: Manage data retrieval using explicit and implicit cursors while using exception handlers to trap probable errors. Understand and use PL/SQL to create stored procedures and functions that can be reused. Demonstrate a good understanding of using PL/SQL to write queries in order to design applications using packagesand other techniques.Course BenefitsPL/SQL is the procedural extension to SQL. Its use increases performance productivity portability and security.This course teaches how to utilise advanced techniques to design PL/SQL applications.Indicative SyllabusThe module will normally cover techniques for: Introduction to PL/SQL. Declaring PL/SQL Variables. Writing Executable Statements. Interacting with the Oracle server. Writing Control Structures. Working with Composite Data Types. Using Explicit Cursors. Handling Exceptions. Creating Stored Procedures and Functions.Who Should AttendThis course assumes a working knowledge and understanding of SQL.The course will be useful to those that wish to extend their SQL knowledge and learn how to integrate PL/SQL codewith Oracle databases.Having prior knowledge of programming languages would be useful but not necessary.Familiarity and exposure to using a PC and Windows is assumed. Teaching and LearningThis course will be delivered by an experienced tutor in a sophisticated environment.The classroom features powerful networked PCs electronic data projectors and interactive boards. Oracle 9i clientswill be used to connect to Oracle 9i Enterprise database server.As a University of Westminster student you will be granted access to Campus facilities including the library.Successful completion of the assessment at the end of this course will le ...

Source: www.wmin.ac.uk

 

Related Files

Oracle JDeveloper for Forms & PL/SQL Developers; A Guide to J2EE ...

Filed under: Programming and Oracle Programming
The most efficient way to learn J2EE programming techniques. Two Oracle experts ... Market. Developers currently using Oracle Forms and the PL/SQL language ...

Oracle/SQL Tutorial

Filed under: Programming and Oracle Programming
C.J. Date and Hugh Darwen: A Guide to the SQL Standard (4th Edition) AddisonWesley ... Oracle Data Dictionary. 23. 4. Application Programming. 4.1. PL/SQL ...

Oracle PLSQL Programming

Filed under: Programming and Oracle Programming
ORACLE PL/SQL PROGRAMMING. Course Code 2PTC313. Module Aims. The aims of the module are to:. Support students to develop a good understanding PL/SQL. ...