Oracle PL/SQL Fundamentals vol. I & II
Learn PL/SQL: a complete introduction to database programming. Master this powerful language for Oracle database development. Get started today!
Course Content
Oracle PL/SQL Fundamentals vol. I & II is an all-levels Udemy course taught by Intellezy Trainers. It runs 19h 59m, is taught in English, and includes a certificate of completion. Learners rate it 4.4 out of 5 from 5,628 reviews, with 26,992 students enrolled. It is a paid course, last updated January 2022.
Master Oracle PL/SQL Fundamentals: Part I & II
This comprehensive Oracle 11g training course provides a solid foundation in the PL/SQL database programming language. Ideal for aspiring database developers and those preparing for Oracle certification exams (OCP), this two-part series covers essential PL/SQL syntax, structure, and features within the context of real-world database applications.
Part I: PL/SQL Fundamentals
- Preparing Your Environment: Get set up for successful PL/SQL development.
- Working with Oracle Database Tools: Learn to effectively utilize tools for PL/SQL development and management.
- Core Language Features:
- DECLARE Clause: Understand variable declaration and data types.
- BEGIN Clause: Master the structure of PL/SQL blocks.
- EXCEPTION Clause: Implement robust error handling.
- Explicit Cursors: Learn to navigate and manipulate data with explicit cursors.
- Nested Blocks: Utilize nested blocks for complex logic.
- Declared Subprograms: Create reusable PL/SQL subprograms.
Part II: Advanced PL/SQL Techniques
- Preparing Your Environment: Continue building your development foundation.
- Database Program Units: Explore the structure and organization of program units within the database.
- Working with Stored Procedures and Functions:
- Stored Procedures: Create and execute reusable procedures.
- Functions: Develop and utilize functions for data calculations.
- Maintaining Stored Procedures and Functions: Learn best practices for managing your code.
- Creating and Maintaining Packages: Organize and group related procedures and functions.
- Advanced Cursor Techniques:
- Cursor Variables: Utilize cursor variables for dynamic data handling.
- Cursor Expressions: Employ cursor expressions for powerful data manipulation.
- Using System Supplied Packages: Leverage pre-built packages for common tasks.
- Creating Database Triggers: Automate actions based on database events.
- Trigger Maintenance: Manage and maintain your database triggers.
- Working with System Event Triggers: Utilize system event triggers for advanced automation.
Throughout the course, we encourage active participation! Don't hesitate to ask questions using the Q&A feature during video playback.
Intellezy offers a vast library of technical training videos covering desktop applications, business skills, and more. Our engaging video content includes assessments to gauge knowledge and is regularly updated to reflect the latest software changes. Benefit from our in-house video development capabilities for custom content tailored to your organization's needs. Explore all that Intellezy has to offer and elevate your skills!
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.