About this course
Master the basic concepts, tools and techniques that you will need to create fully functional, robust and portable oracle PL/SQL applications.
Build a Powerful Foundation in PL/SQL With This Course For Beginners.
Oracle 11g and SQL developer installation and configuration.
Anonymous blocks, subprograms, exceptions, triggers and packages.
Transaction control statements. Loops, conditionals and sequence.
A powerful and lucrative skill at your fingertips.
Mastering the fundamentals of PL/SQL puts a very lucrative skill at your fingertips. Oracle and SQL developer are free, easy to learn and use. PL/SQL is the only language used to build business logic within an oracle database. Jobs in PL/SQL development are plentiful and very lucrative. Mastering PL/SQL could double your income if you are already an SQL developer. This is true for other third generation developers (c++, java). PL/SQL will help you improve performance by pushing your business logic to the database.
Content and Overview.
Suitable for beginning programmers, through this course of 63 lectures over two and a half hours, you will learn PL/SQL fundamentals and establish a powerful understanding of the concepts behind procedural programming. Each chapter ends with a recap and a quiz to reinforce your knowledge.
Starting with the installation and configuration of oracle and SQL developer, through lexical units to variables. Next you create anonymous blocks which will establish a strong understanding of variables and the DBMS_OUTPUT package.
With the basics mastered, the course will take you through advanced topics like flow control (loops, GOTO), subprograms (functions and procedures) and transaction control (SAVEPOINT, ROLLBACK).
After completing this course, you will have the skills to build professional, production ready, business applications. You will also be able to answer 100 practical PL/SQL interview questions.
The course includes working code samples which you could adapt for your study or professional projects.
What are the requirements?
- Check your computer processor type (32 or 64 bit operating system). On windows go to the start menu and right click on the This PC option. You will need this to determine which version of oracle to download.
What am I going to get from this course?
- Over 63 lectures and 2.5 hours of content!
- Write fast optimised PL/SQL programs
- Answer tricky interview and exam questions.
- Hit the ground running on a new job with a PL/SQL component.
- Be able to build end to end PL/SQL applications.
What is the target audience?
- This course is meant for newbies who are not familiar with PL/SQL syntax. It could also serve as a refresher for intermediate level PL/SQL developers. However, a beginner to intermediate level competence in SQL is highly recommended. No previous procedural programming experience is required.
