Description
Oracle PL/SQL Fundamentals vol. I & II is a Udemy-based course that introduces you to the PL/SQL database programming language. PL/SQL is an Oracle product programming language designed for SQL and its Oracle relational database. It has structures like conditionals, loops, variables, and exceptions, and it lets you define functions and data types. The course is structured in two separate parts and introduces you to the basic topics with advanced PL/SQL language commands.
In the first part of this course, you will learn the basics of PL/SQL and learn about syntax, structure and its functions when working with database applications. In the second part, you will learn about the basic shape and structure of storage units in a database, and learn how to build and maintain functions, packaged programs, and database triggers. The instructor will also teach you advanced programming techniques such as pointer variables and pointer markers and prepare you to take the Oracle OCP exam.
Courses taught in this course:
- Preparing the environment
- Introduction to Database Programming Units
- Build and maintain packages
- Use system-ready packages
- Manufacturing and maintenance of database triggers
- Run the System Event Trigger
- Working with Oracle Database Tools
- Knowledge of working with PL/SQL language functions
- Use nested blocks
- Use a simple cursor
Oracle PL/SQL Fundamentals Course Specifications vol. I and II:
- English
- Duration: 19 hours 59 minutes
- Number of lessons: 97
- Education level: intermediate
- Instructor: Intellezy Trainers
- File format: mp4
Course titles:
97 lectures 19:59:18
Oracle 11g PL/SQL Fundamentals I
51 lectures 09:50:45
Oracle 11g PL/SQL Fundamentals II
46 lectures 10:08:33
Course prerequisites:
- Knowledge of database and programming principles
Pictures
Sample movie
installation manual
After extraction, watch with your favorite player.
english subtitles
Quality: 720p
Download link
File password(s): free download software
size
7.8GB