Oracle PL/SQL is My Game: EXAM 1Z0-149
What you'll 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
Course content
- Preview05:31
- 04:32Course Setup Notes / 4 Options
- 07:34Option 2- creating the HR Schema
- 04:27Option 3- Part 1 : Oracle Database 12c Architecture
- 03:42Option 3- Part 2 : Downloading Oracle DB 12c
- 09:16Option 3- Part 3 : Installing Oracle DB 12c
- 10:39Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer
- 04:30Option 3- Part 5: Unlock HR Account Part 1
- 11:49Option 3- Part 6 : Unlock HR Account Part 2
- 03:33Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c
- 10:21Option 4- Installing Oracle 11g express Edition + Unlock HR
- 00:20About Oracle 18c express edition
- 04:34HR Schema in this Course
- 07:05Navigate HR schema
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
Description
This is one of the most amazing Udemy courses in Oracle PLSQL.
The course covers the oracle university track 100% for :
Exam Number: 1Z0-149 : Program with PL/SQL
I designed in this course in a very professional structure that includes huge amount of exercises and examples.
Be sure that you will become expert in PLSQL programming after finishing this course, and you will be ready 100% to pass the Oracle Exam.
You will find all the presentations and all the SQL scripts attached in every chapter, so no need to waste your time repeating any example I did.
Simply this course is the best….
Who this course is for:
- 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
Featured review
![Sarah Funtanilla](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
Instructor
- 4.5 Instructor Rating
- 8,176 Reviews
- 30,592 Students
- 7 Courses
My name is Khaled Al Khudari, I graduated in 2003 in computer science.
I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat and many others )
I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others )
I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft and desire to learn .
I believe in success through hard work & dedication.
My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’.