Oracle SQL and SQL*Plus for End Users
- Recommended Duration:
- 3 Days
- Version
- Oracle 10g, Oracle 9i, or Oracle8i. Also suitable for Oracle8 or Oracle 7 shops.
- Benefits
- Introduces participants to the Oracle database and its most commonly used tools. Numerous hands-on exercises will provide practice using SQL, and SQL*Plus. SQL is used to create, query, and modify database tables and views. SQL and database efficiency are emphasized while showing how SQL is used to solve queries.
- Audience
- People who will use Oracle's Relational Data Base and its various tools to solve queries and simple business problems.
- Prerequisites
- No prior knowledge of SQL or Oracle is required. Some familiarity with computer terminals (or PCs ) is helpful.
- Major Topics
-
- Relational database concepts
- SQL syntax and usage
- SELECT statements
- Joins
- Nested SQL queries
- Table / View / Synonym creation
- INSERT, UPDATE, DELETE, GRANT,REVOKE
- Exercises
- There are twelve machine exercises and two optional exercises.