Oracle – SQL
Course content:
- Relational Database Concepts
- Study of Data Manipulation Language (DML), Data Definition Language (DDL) and Data Control Language (DCL)
- Write SQL and SQL*Plus scripts and use iSQL*Plus.
- Retrieve data using advanced techniques such as ROLLUP, CUBE, set operators and hierarchical retrieval
Book Information:
- The Sybex Oracle DBA Certification Kit books are used for the Oracle DBA track.
- OCP: Oracle Database 11g Adminsitrator Study Guide – Biju Thomas. Sybex, ISBN: 978-0-470-39512-7
System Requirements for doing Labs:
- Processor: Dual Core. Must be a x64 processor with hardware-assisted virtualization support (Intel VT-x or AMD-V).
- Memory: 4GB RAM
- Disk Space: 50GB of free hard drive space
- OS: Vista or Windows7/8
Want to take this class? Let us know by clicking here.