Simple play icon Course
Skills

Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Procedures and Using Parameters

by Mike McQuillan

This course will teach you how to create and use stored procedures in Oracle Database. It covers the key information you will need to ace the stored procedures section of Oracle exam 1Z0-149.

What you'll learn

Are you taking the Oracle 1Z0-149 exam, or just want to know about Oracle stored procedures? In this course, Oracle Database Program with PL/SQL Exam Number: 1Z0-149 - Creating Procedures and Using Parameters, you’ll learn how to create, use, and view stored procedures. First, you’ll explore how to create, change and drop stored procedures. Next, you’ll discover ways to execute stored procedures and how to super-charge them using parameters! Finally, you’ll learn how to handle any exceptions your stored procedures might encounter (we all have to deal with them!). When you’re finished with this course, you’ll have the skills and knowledge of Oracle Database needed to use and manage stored procedures, allowing you to ace that part of the Oracle 1Z0-149 exam..

About the author

Mike is a polyglot architect/developer who loves to mess around with data. He runs a consultancy company in the UK, helping organizations to build better systems and databases. Mike is married and has one daughter and two dogs, Dolly and Bertie. They keep his feet warm when he's working on courses and articles. Mike has written a book on SQL Server and writes regular articles for sqlservercentral.com. He also likes collecting old computers like the Commodore 64 and Sinclair Spectrum. No, he doe... more

Ready to upskill? Get started