Introduction to Oracle 10g Programming (SQL*Plus & SQL) 100$
On this course, students will learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools.
The course is targeted at application developers, database administrators, system administrators and users who write applications and procedures that access an Oracle 10g database.
Pre-Requisites
A good knowledge of computing principles, no formal programming experience necessary.
Course Outline
- Relational Database and SQL Overview
- Using Oracle SQL*Plus
- SQL Queries - The SELECT Statement
- Scalar Functions
- SQL Queries - Joins
- Aggregate Functions and Advanced Techniques
- Data Manipulation and Transactions
- Data Definition and Control Statements
- Other Database Objects
- Data Dictionary