Oracle PL/SQL Fundamentals vol. I & II

Partner: Udemy
Affiliate Name:
Area:
Description: Oracle PL/SQL Fundamentals Pt. I Description of Course: The primary objective of this Oracle 11g training part I course is to provide an introduction to the PL/SQL database programming language covering syntax, structure, and features of the language within the context of database applications and programming. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).Learning Objectives: Preparing Your EnvironmentWorking with Oracle Database ToolsLanguage FeaturesThe DECLARE ClauseThe BEGIN ClauseThe EXCEPTION ClauseExplicit CursorsNested BlocksDeclared SubprogramsOracle PL/SQL Fundamentals Pt. II Description of Course: In this part 2 of Oracle PL/SQL fundamentals, students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).Learning Objectives: Preparing Your EnvironmentDatabase Program UnitsWorking with Stored Procedures and FunctionsMaintaining Stored Procedures and FunctionsCreating and Maintaining PackagesAdvanced Cursor TechniquesUsing System Supplied PackagesCreating Database TriggersTrigger MaintenanceWorking with System Event TriggersAs you proceed through the course, don’t forget you can ask questions and engage with us.  When watching a video, click the Browse Q&A at the bottom of the screen an
Category: Office Productivity > Oracle > PL/SQL
Partner ID:
Price: 149.99
Commission:
Source: Impact
Go to Course