i-Run Systems Solution also offers Oracle SQL/PLSQL training. Interested parties please call or SMS us at 0928 297 4677 or 0919 462 7010 or visit us at #79 VEG Bldg., Gen. Maxilom Ave., Cebu City, next to St. Theresa's College in Mango. Come inside the Call Center Academy.
ORACLE SQL and PLSQL Outline
I. An introduction to SQL
An introduction to relational databases and SQL
How to use Oracle SQL Developer and other tools
II. The essential SQL skills
How to retrieve data from a single table
How to retrieve data from two or more tables
How to code summary queries
How to code subqueries
How to insert, update, and delete data
How to work with data types and functions
III. Database design and implementation
How to design a database
How to create tables, indexes, and sequences
How to create views
How to manage database security
IV. The essential PL/SQL skills
How to write PL/SQL code
How to manage transactions and locking
How to create stored procedures and functions
How to create triggers
V. Advanced data types
How to work with timestamps and intervals
How to work with large objects