Oracle Database Program with PL/SQL Exam Number: 1Z0-149 – Creating Procedures and Using Parameters
Oracle’s 1Z0-149 exam demands procedural fluency—and most candidates stumble on parameter handling. This focused Pluralsight course cuts straight to what examiners test: building robust procedures with IN, OUT, and IN/OUT parameters, plus real error-handling patterns you’ll use in production.
AIU.ac Verdict: Ideal for Oracle DBAs and developers preparing for 1Z0-149 certification or strengthening PL/SQL fundamentals. The 66-minute format is efficient but assumes you’ve already grasped basic SQL syntax—absolute beginners may need prerequisite grounding first.
What This Course Covers
You’ll work through procedure creation from declaration through execution, with emphasis on parameter modes and how they control data flow. The course covers IN parameters for passing values into procedures, OUT parameters for returning results, and IN/OUT parameters for bidirectional communication—each with practical sandbox labs where you write and test real code. Mike McQuillan walks through common pitfalls: parameter naming conventions, default values, and how parameter scope affects variable visibility.
Beyond syntax, the course addresses why parameter design matters in enterprise systems. You’ll see how poorly designed parameters create maintenance headaches, then learn the patterns that prevent them. Error handling within procedures gets attention too, since the exam tests your ability to handle exceptions gracefully. By the end, you’re not just passing 1Z0-149—you’re writing procedures that colleagues won’t cringe at in code review.
Who Is This Course For?
Ideal for:
- Oracle Database certification candidates: Preparing for 1Z0-149 exam with structured, exam-aligned content from a trusted Pluralsight author.
- PL/SQL developers levelling up: Already writing basic SQL but need to master procedures and parameters for production-grade code.
- Database administrators transitioning to development: Need procedural logic skills to automate tasks and build maintainable database objects.
May not suit:
- SQL novices: Course assumes solid SELECT/INSERT/UPDATE/DELETE foundation; start with SQL fundamentals first.
- Non-Oracle database professionals: Content is Oracle-specific; PostgreSQL, MySQL, or SQL Server developers need vendor-specific alternatives.
Frequently Asked Questions
How long does this Oracle Database Program with PL/SQL course take?
The course is 1 hour 6 minutes of video content. Most learners complete it in one sitting or across 2–3 focused sessions, though hands-on lab time may extend that depending on how deeply you practise.
Will this course prepare me for the 1Z0-149 exam?
Yes—the course is explicitly aligned to 1Z0-149 objectives around procedures and parameters. However, it focuses narrowly on that topic; you’ll want supplementary study for other exam domains like triggers, packages, and dynamic SQL.
Do I need Oracle Database installed locally?
No. Pluralsight provides sandboxed lab environments, so you can practise without installing anything. That said, having a local Oracle instance (or free Oracle Express Edition) is valuable for deeper experimentation after the course.
What’s the teaching style—lecture or hands-on?
Mike McQuillan uses expert-led video with embedded labs and live code demonstrations. Expect clear explanations paired with practical sandbox exercises where you write and test procedures yourself.
Course by Mike McQuillan on Pluralsight. Duration: 1h 6m. Last verified by AIU.ac: March 2026.
Related Products
