Office Productivity Online Course by Udemy, On Sale Here
Writing programs to interact and manipulate Oracle databases using PL/SQL programming language
An excellent training about Oracle
Understanding and using Oracle PL/SQL programming language
This course will give and overview of the OraclePL/SQL programming language. This course is a must have for anyone considering learning more about databases and database managementWhether as a DBA or Database application developer, PL/SQL is foundations to understanding how Oracle works and how to change data within the database. We cover all the fundamental aspects of the language and use real world example to manipulate databases. Topic covered Include:-Explanation of PL/SQL- Language Syntax, Sections, Operators, Assignments and Variables- Using PL/SQL toautomaticallydoupdates, inserts and deletion of records of an Oracle Database- PL/SQLCursors – to bring in large data sets to work with- PL/SQL Loops – to loop through tables of data- PL/SQL Exceptions – to trap and handle coding exceptions both user and machine generated-PL/SQL Triggers – to have the table automatically change data based on the other data- PL/SQL Functions – to return a frequently used value and avoid duplicate coding- PL/SQL Procedures – to get anonymous blocks into reusable coding procedures- PL/SQL Packages – to put PL/SQL objects together to quicker retrieval
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.