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.
Hi there! I'm Victor and I am a senior business intelligence consultant for high tech and financial corporations. Some of my previous clients include SAP AG, Oracle, Lloyds Bank, O2, and HSBC. I am currently working on big data and SAP Hana projects. I am also a published author and public speaker.
My role for the last 15 years generally involves leading the delivery of business intelligence solutions. Specifically, this includes integrating data warehouse databases (oracle, SQL server) with ETL (SAP data services) and reporting t (SAP crystal reports, web intelligence) to give the best insights to senior management.
My motivation to create Udemy courses is two fold. First, I struggled for years to master PL/SQL and other programming languages. The second reason is that, when I interview unsuccessful candidates for PL/SQL roles, their understanding of the fundamental principles was always lacking.
Thus I decided to create simple, clear, coherent and concise courses which will prepare students for their professional life. Just so they do not struggle as much as I did when I was coming up.