We provide course about Oracle Database: Develop PL/SQL Program Units in english. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers.
Learn to:
• Create, and execute stored procedures and functions
• Design and use PL/SQL packages
• Create overloaded package subprograms for more flexibility
• Utilize Oracle-Supplied Packages in Application Development
• Create triggers to solve business challenges
• Build and execute SQL statements dynamically
Course objectives:
• Use conditional PL/SQL compilation and obfuscate (hide) code
• Create triggers to solve business challenges
• Manage dependencies between PL/SQL subprograms
• Design PL/SQL code for predefined data types, local subprograms, additional pragmas and standardized constants and exceptions.
• Use the compiler warnings infrastructure
• Create, use, and debug stored procedures and functions
• Design and use PL/SQL packages to group and contain related constructs
• Create overloaded package subprograms for more flexibility
• Use the Oracle supplied PL/SQL packages to generate screen output, file output, and mail output
• Write dynamic SQL for more coding flexibility
Benefits to you:
• Students are introduced to the utilization of some of the Oracle-supplied packages. Additionally students learn to use Dynamic SQL, understand design considerations when coding using PL/SQL, understand and influence the PL/SQL compiler, and manage dependencies. In this course, students learn and use Oracle SQL Developer as the main environment tool to develop these program units. SQL*Plus is introduced as optional tools. Demonstrations and hands-on practice reinforce the fundamental concepts.
Target audience:
Databaseadministrator, teknisk konsulent og PL/SQL-utvikler
Prerequisites:
• Familiarity with data processing concepts and technique
• Familiarity with programming languages
• Oracle Database 12c: Introduction for Experienced SQL Users
Suggested prerequisites:
• Familiarity with data processing concepts and techniques
• Familiarity with programming languages
Language:
• English course material, english speaking instructor
Course material:
Digital course documentation and hands-on exercises