When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Oracle PL/SQL Fundamentals & Database Design--3course bundle
The ultimate Oracle/database course bundle with over 20 hours and 100 videos!

Related Courses
- Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Managing PL/SQL Code (⭐ 0 | Reviews 0)
- Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Design Considerations for PL/SQL Code (⭐ 0 | Reviews 0)
- Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Writing SQL in PL/SQL (⭐ 0 | Reviews 0)
This Course Includes
udemy
4.7 (449 reviews )
21h 34m
english
Online - Self Paced
professional certificate
Udemy
About Oracle PL/SQL Fundamentals & Database Design--3course bundle
Over 20 hours and 100 videos are included in this bundle. Save 20% by purchasing 3 Oracle/Database courses. This bundle includes:
Oracle PL/SQL Fundamentals vol. I
Oracle PL/SQL Fundamentals vol. II
Database Design Instruction In this Oracle 11g PL/SQL vol I & II courses, you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II 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). The Database Design Instruction course familiarizes the student with techniques necessary to properly create and normalize a relational database. This single course can help prevent the new database developer from creating mistakes that add hours and days to a development project. Information in this course is a must for anyone responsible for building and maintaining a database.
What You Will Learn?
- Over 100 lectures and 20 hours of content .
- Understand different types of databases .
- Relate tables with IDs .
- Understand normalization .
- Introducing Database Program Units .
- Creating and Maintaining Packages .
- Work with DECLARE, BEGIN & EXCEPTION clause .
- Understand and use nested blocks .
- Use explicit cursors.