Intermediate Oracle (Self-Paced Tutorial) Online Certificate Course
Learn how to write powerful and flexible PL/SQL programs
NOW ONLY
US$149
Save US$550 (79%)OFF RRP US$699
Learn how to write powerful and flexible PL/SQL programs
Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL).
This course will give you the skills you need to write powerful and flexible programs using that language. You'll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions. Then, you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.
Course Fast Facts:
- Learn the fundamentals of Oracle programming language
- Comprehensive 12 module Intermediate Oracle (Self-Paced Tutorial) Online Certificate Course
- Study along with simple instructions & demonstrations
- Written and developed by leading Oracle programming language experts
- Receive one-on-one online help & support
- Certificate of completion awarded with passing score for the online assessment
- Study at your own pace with no rigid class timetables, 24/7 from any computer or smart device
Course Delivery
Courses are accessed online by any device including PC, tablet or Smart Phone. Upon purchase an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device.
Recognition & Accreditation
All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email.
Lesson 1 - Introduction to PL/SQL
In the first lesson, you'll master the basics of PL/SQL and discover how you can best get started using this powerful language. You'll also learn the differences between SQL, SQL*Plus, and PL/SQL.
Lesson 2 - Datatypes and Block Structure
The block is the basic unit of PL/SQL programming. In this lesson, you'll learn and understand the various datatypes available to you when declaring variables. You'll also explore the PL/SQL's block structure, its use, and its impact on the scope of variable declarations.
Lesson 3 - Operators, Expressions, and Datatype Conversions
In this lesson, you're going to learn how to use operators to manipulate variables. You'll build simple expressions that compute two values, as well as complex expressions that consist of function calls, operations using variables, and relational comparisons. You'll also learn about datatype conversions for expressions that contain operands of multiple datatypes.
Lesson 4 - PL/SQL Functions, IF Statements, and Looping Statements
In this lesson, you'll take a closer look at how to create your own functions. The two main reasons for writing functions are the reduction of code and their ease of use. You'll learn how to code PL/SQL functions, how to define parameters in the functions, and how to store them. The lesson will also show you how to control the execution of PL/SQL blocks using the IF and looping statements. Then, you'll explore the various IF statements and how they operate, and you'll gain experience working with a simple loop.
Lesson 5 - GOTO Statement, Statement Labels, and Loop Constructs
In this lesson, you'll begin to master more methods for changing the order of execution of PL/SQL blocks. You'll explore statement labels, the GOTO statement, and the different kinds of loops. You'll learn how to branch by using the GOTO statement followed by a statement label. After that, the lesson will discuss why the statement label must appear in the same block and within the same scope as the GOTO statement. Next, you'll look at control structures. You'll learn about the different kinds of loops and how they operate. Finally, you'll discover techniques for exiting loops and how to simulate a REPEAT UNTIL loop.
Lesson 6 - Oracle's Built-In Functions
You'll look at a number of Oracle's built-in functions in this lesson, including string functions, number functions, date functions, and conversion functions.
Lesson 7 - Procedures and Packages
In this lesson, you'll focus on procedures and packages and how they allow you to organize your PL/SQL code into logical groups for uncomplicated maintenance and implementation.
Lesson 8 - Errors and Exceptions
Errors that occur from hardware or network failures, application logic errors, data integrity errors, and other sources are called exceptions. This lesson will introduce you to the concepts behind PL/SQL exception handling. It will explain the different types of exceptions and show you how to identify and handle errors in your code.
Lesson 9 - Types of SQL Statements, Declaring Variables in PL/SQL, and Transaction Management
Structured Query Language (SQL) is the industry standard for accessing data from relational databases. This lesson will address the connection to the underlying Oracle database through SQL (Structured Query Language). It will cover the usage of SQL's Data Manipulation Language (DML) commands within a PL/SQL block. Then you'll learn how to define DML transactions that insert, update, delete, and query the information.
Lesson 10 - Using Cursors
PL/SQL cursors provide a method for selecting multiple rows of data from the database and processing each row individually. You can use cursors for simple procedures and complex processing. This lesson will introduce you to cursors and how they may be used.
Lesson 11 - Database Triggers, Advanced Cursor Concepts, and Managing PL/SQL Code
In this lesson, you'll learn about triggers and experiment with implementing a few different types of functionality. The lesson will discuss advanced cursor concepts, which include the SELECT...FOR UPDATE statement, the WHERE CURRENT OF clause, and subqueries in cursors. Finally, you'll learn techniques to managing PL/SQL code.
Lesson 12 - Debugging Your Code
Although some may never admit to it, everyone makes mistakes, so you will inevitably make some coding errors. These errors are usually comprised of syntax and logic errors. The final lesson will demonstrate how to find these bugs and then how to reduce the number of coding mistakes you may encounter.
Entry requirements
Students must have basic literacy and numeracy skills.
Minimum education
Open entry. Previous schooling and academic achievements are not required for entry into this course.
Computer requirements
Students will need access to a computer and the internet.
Minimum specifications for the computer are:
Windows:
- Microsoft Windows XP, or later
- Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome)
All systems
- Internet bandwidth of 1Mb or faster
- Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome)
Students will also need access the following applications:
Adobe Acrobat Reader
Note: This course is not suitable for Macintosh users.
Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.
Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.
Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.
The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews
No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.
No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.
This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.
Yes, this course is online. Through well-crafted lessons, expert online instruction and interaction with your tutor, participants in this course gain valuable knowledge. You have the flexibility to study at your own pace combined with enough structure and support to complete the course. You can access the classroom 24/7 from anywhere with an Internet connection.
After you have completed payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.
This is a self-paced course that can be started at anytime as long as you have internet access and a computer.
Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.
You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).
You have unlimited access for 3 months. You may start and finish the course at your own time and learn at your own pace.
Individual courses are very comprehensive and can take up to 24 hours to complete.
If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:
- 2 course bundle is 2 x 24 hours = 48 hours
- 3 course bundle is 3 x 24 hours = 72 hours
- 5 course bundle is 5 x 24 hours = 120 hours
- 10 course bundle is 10 x 24 hours = 240 hours
Yes, there is tutor support, a dedicated professional instructor is available via email, answering questions and providing feedback.
The onetime fee includes all training materials, including online content, diagrams, videos if included, interactive instructions and quizzes, plus you will receive a certificate upon completion.
All the required material for your course is included in the online system, you do not need to buy anything else.
Yes, all our courses are interactive.
Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.
You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and potential employers. Also, include it in your resume/CV, professional social media profiles and job applications.
Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"
Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.
No, it is not equivalent to a college or university credit.
This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.
Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.
The Certificates are valid for life and do not need renewing.
Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.
We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at , to pay via bank transfer.
 |
About this Course |
 |
Learn how to write powerful and flexible PL/SQL programs
Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL).
This course will give you the skills you need to write powerful and flexible programs using that language. You'll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions. Then, you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.
Course Fast Facts:
- Learn the fundamentals of Oracle programming language
- Comprehensive 12 module Intermediate Oracle (Self-Paced Tutorial) Online Certificate Course
- Study along with simple instructions & demonstrations
- Written and developed by leading Oracle programming language experts
- Receive one-on-one online help & support
- Certificate of completion awarded with passing score for the online assessment
- Study at your own pace with no rigid class timetables, 24/7 from any computer or smart device
Course Delivery
Courses are accessed online by any device including PC, tablet or Smart Phone. Upon purchase an automated welcome email will be sent to you (please check your junk email inbox if not received as this is an automated email), in order for you to access your online course, which is Available 24/7 on any computer or smart mobile device.
Recognition & Accreditation
All students who complete the course receive a certificate of completion with a passing score (for the online assessment) and will be issued a certificate via email.
Lesson 1 - Introduction to PL/SQL
In the first lesson, you'll master the basics of PL/SQL and discover how you can best get started using this powerful language. You'll also learn the differences between SQL, SQL*Plus, and PL/SQL.
Lesson 2 - Datatypes and Block Structure
The block is the basic unit of PL/SQL programming. In this lesson, you'll learn and understand the various datatypes available to you when declaring variables. You'll also explore the PL/SQL's block structure, its use, and its impact on the scope of variable declarations.
Lesson 3 - Operators, Expressions, and Datatype Conversions
In this lesson, you're going to learn how to use operators to manipulate variables. You'll build simple expressions that compute two values, as well as complex expressions that consist of function calls, operations using variables, and relational comparisons. You'll also learn about datatype conversions for expressions that contain operands of multiple datatypes.
Lesson 4 - PL/SQL Functions, IF Statements, and Looping Statements
In this lesson, you'll take a closer look at how to create your own functions. The two main reasons for writing functions are the reduction of code and their ease of use. You'll learn how to code PL/SQL functions, how to define parameters in the functions, and how to store them. The lesson will also show you how to control the execution of PL/SQL blocks using the IF and looping statements. Then, you'll explore the various IF statements and how they operate, and you'll gain experience working with a simple loop.
Lesson 5 - GOTO Statement, Statement Labels, and Loop Constructs
In this lesson, you'll begin to master more methods for changing the order of execution of PL/SQL blocks. You'll explore statement labels, the GOTO statement, and the different kinds of loops. You'll learn how to branch by using the GOTO statement followed by a statement label. After that, the lesson will discuss why the statement label must appear in the same block and within the same scope as the GOTO statement. Next, you'll look at control structures. You'll learn about the different kinds of loops and how they operate. Finally, you'll discover techniques for exiting loops and how to simulate a REPEAT UNTIL loop.
Lesson 6 - Oracle's Built-In Functions
You'll look at a number of Oracle's built-in functions in this lesson, including string functions, number functions, date functions, and conversion functions.
Lesson 7 - Procedures and Packages
In this lesson, you'll focus on procedures and packages and how they allow you to organize your PL/SQL code into logical groups for uncomplicated maintenance and implementation.
Lesson 8 - Errors and Exceptions
Errors that occur from hardware or network failures, application logic errors, data integrity errors, and other sources are called exceptions. This lesson will introduce you to the concepts behind PL/SQL exception handling. It will explain the different types of exceptions and show you how to identify and handle errors in your code.
Lesson 9 - Types of SQL Statements, Declaring Variables in PL/SQL, and Transaction Management
Structured Query Language (SQL) is the industry standard for accessing data from relational databases. This lesson will address the connection to the underlying Oracle database through SQL (Structured Query Language). It will cover the usage of SQL's Data Manipulation Language (DML) commands within a PL/SQL block. Then you'll learn how to define DML transactions that insert, update, delete, and query the information.
Lesson 10 - Using Cursors
PL/SQL cursors provide a method for selecting multiple rows of data from the database and processing each row individually. You can use cursors for simple procedures and complex processing. This lesson will introduce you to cursors and how they may be used.
Lesson 11 - Database Triggers, Advanced Cursor Concepts, and Managing PL/SQL Code
In this lesson, you'll learn about triggers and experiment with implementing a few different types of functionality. The lesson will discuss advanced cursor concepts, which include the SELECT...FOR UPDATE statement, the WHERE CURRENT OF clause, and subqueries in cursors. Finally, you'll learn techniques to managing PL/SQL code.
Lesson 12 - Debugging Your Code
Although some may never admit to it, everyone makes mistakes, so you will inevitably make some coding errors. These errors are usually comprised of syntax and logic errors. The final lesson will demonstrate how to find these bugs and then how to reduce the number of coding mistakes you may encounter.
Entry requirements
Students must have basic literacy and numeracy skills.
Minimum education
Open entry. Previous schooling and academic achievements are not required for entry into this course.
Computer requirements
Students will need access to a computer and the internet.
Minimum specifications for the computer are:
Windows:
- Microsoft Windows XP, or later
- Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome)
All systems
- Internet bandwidth of 1Mb or faster
- Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome)
Students will also need access the following applications:
Adobe Acrobat Reader
Note: This course is not suitable for Macintosh users.
Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.
Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.
Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.
The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews
No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.
No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.
This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.
Yes, this course is online. Through well-crafted lessons, expert online instruction and interaction with your tutor, participants in this course gain valuable knowledge. You have the flexibility to study at your own pace combined with enough structure and support to complete the course. You can access the classroom 24/7 from anywhere with an Internet connection.
After you have completed payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.
This is a self-paced course that can be started at anytime as long as you have internet access and a computer.
Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.
You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).
You have unlimited access for 3 months. You may start and finish the course at your own time and learn at your own pace.
Individual courses are very comprehensive and can take up to 24 hours to complete.
If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:
- 2 course bundle is 2 x 24 hours = 48 hours
- 3 course bundle is 3 x 24 hours = 72 hours
- 5 course bundle is 5 x 24 hours = 120 hours
- 10 course bundle is 10 x 24 hours = 240 hours
Yes, there is tutor support, a dedicated professional instructor is available via email, answering questions and providing feedback.
The onetime fee includes all training materials, including online content, diagrams, videos if included, interactive instructions and quizzes, plus you will receive a certificate upon completion.
All the required material for your course is included in the online system, you do not need to buy anything else.
Yes, all our courses are interactive.
Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.
You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and potential employers. Also, include it in your resume/CV, professional social media profiles and job applications.
Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"
Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.
No, it is not equivalent to a college or university credit.
This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.
Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.
The Certificates are valid for life and do not need renewing.
Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.
We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at , to pay via bank transfer.
We provide a 7 Day Money Back Refund on all Courses
Special Offer
|
Training 2 Or More People?
| Empower your business with access to 500+ job & soft skills online training courses. |
|
SUCCESS PRO - For Business |
Course Summary
| Course ID: | 007IOSP |
|---|---|
| Delivery Mode: |
Online |
| Access: | 3 months |
| Tutor Support: | Yes |
| Time: | 40 Hours |
| Duration: | 24 Hours |
| Assessments: | Yes |
| Qualification: | Certificate of Completion |
- Call +1 845-764-9167
- Chat to us live
- Send us an enquiry
- Print this course page
