SQL (Oracle9i): Introduction |
|
|
|
Overview: |
Receive instruction in using Oracle SQL and iSQL*Plus commands for database development. Discover techniques to develop complex queries, subqueries and joins for sorting, restricting, merging, updating and deleting data are presented. You also explore the use of row and group functions, control of user access, script utilization and report creation with iSQL*Plus. |
Who Should Attend? |
Managers, systems analysts or programmers who want to learn SQL for systems implementation |
Prerequisites: |
Familiarity with DMS or any major database language. |
Additional Information: |
Have a question? - See our Evening Programs FAQ Go to the Evening Programs webpage Online Bookstore |
Objectives: |
Complex queries and subqueries with Oracle commandsSorting and restricting access to dataSelect, insert, merge and update dataComplex joinsOracle scriptsOutput reporting using iSQLoPlus commandsSingle row and group functions |
|
|