The Introduction to Oracle SQL training course is designed to demonstrate a thorough introduction to interactive SQL and basic SQL*Plus operations.
The course begins with an examination of single table operations and moves into a discussion on the complexities of accessing multiple tables using joins or subqueries. Next, it explores the basic SQL*Plus operations required to enter, edit, and run SQL statements, produce reports, and write interactive SQL scripts through SQL*Plus. The course concludes with an exploration of Oracle's New Features.
Purpose
|
Learn the basics of interactive SQL and SQL*Plus operations. |
Audience
|
Programmers, Analysts, Database Administrators, and Users who access data in an Oracle database. |
Role
| Software Developer |
Skill Level
| Introduction |
Style
| Hack-a-thon - Learning Spikes - Workshops |
Duration
| 3 Days |
Related Technologies
| SQL |
Productivity Objectives
- Describe data retrieval operations
- Use multi-table operations
- Identify Data Manipulation Operations
- Associate row functions
- Discover group functions
- Review subqueries