{"product_id":"oracle®-pl-sql-training","title":"Oracle® PL\/SQL Training","description":"\u003cdiv\u003e\n\u003cp\u003eThis \u003cstrong\u003eOracle® PL\/SQL training\u003c\/strong\u003e course will teach you to increase the productivity, performance, scalability, portability, and security of your Oracle database. With this training, you will learn how to execute PL\/SQL programs in Oracle, build stored procedures, design, and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.\u003c\/p\u003e\r\n\u003cp\u003e\u003c\/p\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch3\u003eOracle® PL\/SQL Training Benefits\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eIn this Oracle PL\/SQL Programming training, you will learn how to:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDevelop efficient PL\/SQL programs to access Oracle databases. \u003c\/li\u003e\n\u003cli\u003eCreate stored procedures and functions for reuse and maintenance. \u003c\/li\u003e\n\u003cli\u003eDesign modular applications using packages. \u003c\/li\u003e\n\u003cli\u003eManage data retrieval for front-end applications. \u003c\/li\u003e\n\u003cli\u003eInvoke native dynamic SQL to develop high-level abstract code. \u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/li\u003e\n\u003cli\u003e\n\u003cp\u003e\u003cstrong\u003eOracle PL\/SQL Programming Training Course Prerequisites\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eStudents taking this course should have basic knowledge of SQL as taught in Learning Tree course 925, Introduction to SQL Course.\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\u003ch3\u003eOracle PL\/SQL Course Outline\u003c\/h3\u003e\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 1: Introduction and Overview\u003c\/h4\u003e\n\u003cp\u003ePL\/SQL fundamentals\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDeclaring and anchoring variables to database definitions\u003c\/li\u003e\n\u003cli\u003eFlow control constructs\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eOracle 11\u003ci\u003eg\u003c\/i\u003e and 12\u003ci\u003ec\u003c\/i\u003e PL\/SQL features\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePL\/Scope in Oracle 11\u003ci\u003eg\u003c\/i\u003e\n\u003c\/li\u003e\n\u003cli\u003eReturning implicit cursor results from stored procedures in Oracle 12\u003ci\u003ec\u003c\/i\u003e\n\u003c\/li\u003e\n\u003cli\u003eDeclaring local functions within SELECT statements in Oracle 12\u003ci\u003ec\u003c\/i\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 2: Data Manipulation Techniques\u003c\/h4\u003e\n\u003cp\u003eMaintaining data with DML statements\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying the RETURNING INTO clause\u003c\/li\u003e\n\u003cli\u003eSolving the fetch-across-commit problem\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eManaging data retrieval with cursors\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eImplications of explicit and implicit cursors\u003c\/li\u003e\n\u003cli\u003eSimplifying cursor processing with cursor FOR LOOPs\u003c\/li\u003e\n\u003cli\u003eEmbedding cursor expressions in SELECT statements\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCursor variables\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eStrong vs. weak cursor variables\u003c\/li\u003e\n\u003cli\u003ePassing cursor variables to other programs\u003c\/li\u003e\n\u003cli\u003eDefining REF CURSORS in packages\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 3: Developing Well-Structured and Error-Free Code\u003c\/h4\u003e\n\u003cp\u003eError handling using EXCEPTIONs\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePropagation and scope\u003c\/li\u003e\n\u003cli\u003e\"Retrying\" problem transactions with EXCEPTION processing\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDebugging PL\/SQL blocks\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSimplifying testing and debugging with conditional compilation\u003c\/li\u003e\n\u003cli\u003eInterpreting compiler messages\u003c\/li\u003e\n\u003cli\u003eApplying structured testing techniques\u003c\/li\u003e\n\u003cli\u003eBuilding and applying a test bed\u003c\/li\u003e\n\u003cli\u003eLeveraging the debugging facilities in SQL Developer\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 4: Achieving Maximum Reusability\u003c\/h4\u003e\n\u003cp\u003eWriting stored procedures and functions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCalling and invoking server-side logic\u003c\/li\u003e\n\u003cli\u003ePassing input and output parameters\u003c\/li\u003e\n\u003cli\u003eImplementing an autonomous transaction\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eCoding user-written functions\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eCalling PL\/SQL functions from SQL\u003c\/li\u003e\n\u003cli\u003eBuilding table-valued functions\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eDeveloping safe triggers\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eEmploying :OLD and :NEW variables\u003c\/li\u003e\n\u003cli\u003eAvoiding unreliable trigger constructs\u003c\/li\u003e\n\u003cli\u003eExploiting schema and database triggers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 5: Exploiting Complex Datatypes\u003c\/h4\u003e\n\u003cp\u003eCollection types\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003ePL\/SQL tables, nested tables, VARRAYs\u003c\/li\u003e\n\u003cli\u003eStepping through dense and nonconsecutive collections\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eBulk binding for high performance\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eMoving data into and out of PL\/SQL blocks\u003c\/li\u003e\n\u003cli\u003eBULK COLLECT INTO and FORALL\u003c\/li\u003e\n\u003cli\u003eBULK cursor attributes\u003c\/li\u003e\n\u003cli\u003eBULK EXCEPTION handling\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 6: Invoking Native Dynamic SQL\u003c\/h4\u003e\n\u003cp\u003eFinessing the compiler\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eThe EXECUTE IMMEDIATE statement\u003c\/li\u003e\n\u003cli\u003eThe RETURNING INTO clause\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003eTypes of dynamic SQL\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eBuilding SQL statements during runtime\u003c\/li\u003e\n\u003cli\u003eAutogenerating standard code\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e\u003cdiv\u003e\n\u003ch4\u003eModule 7: Package Tips and Techniques\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003ePackage structure: SPEC and BODY\u003c\/li\u003e\n\u003cli\u003eEliminating dependency problems\u003c\/li\u003e\n\u003cli\u003eOverloading for polymorphic effects\u003c\/li\u003e\n\u003cli\u003eEvaluating application frameworks\u003c\/li\u003e\n\u003cli\u003eDeclaring and using persistent global variables\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003c\/div\u003e","brand":"Learning Tree","offers":[{"title":"269B35US \/ 2026-09-14T09:00:00 \/ Herndon, VA","offer_id":47591598096603,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"268C75US \/ 2026-08-10T09:00:00 \/ Herndon, VA","offer_id":48216578031835,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"26BA82US \/ 2026-11-30T09:00:00 \/ Herndon, VA","offer_id":48216578064603,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"272A55US \/ 2027-02-01T09:00:00 \/ Herndon, VA","offer_id":48216578097371,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true},{"title":"274A64US \/ 2027-04-05T09:00:00 \/ Herndon, VA","offer_id":48556121293019,"sku":"US-493-IL","price":2680.0,"currency_code":"USD","in_stock":true}],"url":"https:\/\/learningtreeinternational-dirinfosec-hhs.myshopify.com\/products\/oracle%c2%ae-pl-sql-training","provider":"Learning Tree International","version":"1.0","type":"link"}