Profile
e-Catalog
Contact
Search
Cart
|
Profile |
|
Contact |
Search |
Cart |
 |
Oracle Introduction: SQL and SQL*Plus |
| Course Status: | Released |
| Course Language: | English |
| Course Duration: | 4 Hours |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
| Audience |
| Trainee database administrators and application developers |
| Prerequisites |
| Familiarity with programming techniques would be an advantage |
| Course Aim |
| To introduce SQL and SQL*Plus, and to explain the differences between them |
| Learning Objectives |
| Understand the terms RDBMS and ORDBMS. Describe the differences between SQL and SQL. PLUS. Discuss the benefits of PL/SQL. |
| Topics Covered |
| Introduction - Database concepts - Characteristics of ORDBMS - Benefits of PL/SQL Basic SQL statements - Building SQL statements - Arithmetic expressions - Column aliases and concatenation Introducing SQL*Plus - Overview - Editing commands - File commands - Hands-on: Using SQL* Plus Restricting and sorting data - Comparison operators - Logical operators - The ORDER BY clause - Hands-on: Using the WHERE and ORDER BY clauses |