Oracle PL/SQL is My Game: EXAM 1Z0-149

Become Oracle PL/SQL Developer / Covers ORACLE university track 100%. All the presentations & scripts are attached

Created by: Khaled Alkhudari
Sr Oracle Developer/ Sr system analyst

What Will I Learn?

• The full track of Oracle university Exam 1Z0-144 : Program with PL/SQL
• Oracle Database 12c Architecture
• Downloading and installing oracle database 12c in details
• Overview of PLSQL
• Declaring PLSQL Variables
• Writing executable statements
• Interacting with Oracle DB Server
• Writing Control structure
• Working with Composite Data Types
• Using explicit cursors
• Handling Exceptions
• Creating Procedures
• Creating Functions
• Creating Packages
• Working with Packages
• Using oracle-supplied Packages in Application Development
• Using dynamic SQL
• Design consideration for PLSQL Code
• Creating triggers
• Creating Compound, DDL, and Event Database Triggers
• Using the PLSQL Compiler
• Managing PLSQL Code
• Managing Dependencies

Requirements

• You should know Oracle SQL ( 11g or 12c)
• You should have strong knowledge in (SELECT statement, DML, DDL, DCL, creating views, indexes, and synonyms)
• Windows Operating system is preferred, but this is not mandatory if you have the knowledge of downloading Oracle database on other OS
• Downloading oracle database and this will be covered in details on Windows OS.
• No need for any previous experience in PL/SQL, this Course starts from zero in PL/SQL

Target audience

• Students who wants to be expert in PL/SQL programming
• Students who wants to be certified in PL/SQL
• Fresh and junior programmers who need to find better jobs by gaining oracle certification
• Students who already know Oracle SQL and they need to move to next level which is PL/SQL