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. ...
Long summary:
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 ...
Computer Science A.A. Degree & Certificate Programs, application range from database theory and
design using a database engine such as SQL
server or Oracle to programming in ADO ...,
Using the Oracle Forms Application Programming Interface (API), Using the Oracle. . Forms Application
Programming. Interface (API). An Oracle
Technical White Paper. EITDEWP56. January
2000 ...,
DATABASE MANAGEMENT: ORACLE DBA PROGRAMMING (C25150B) CERTIFICATE ..., Department Head Computer Programming. Dean
Computer Information Systems Division.
Curriculum By Semester. Hours Per Week.
DATABASE MANAGEMENT: ORACLE DBA ...,
