Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Central London
City
England
Berkshire
Greater Manchester
Prices exclude VAT.
Why do prices vary? Using CourseMonster, you search the schedules of over 100 training companies in one convenient location. Choose the city, date and price that best suits you.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview This class is applicable to Oracle9i and Oracle8i users. In this course students gain an understanding of Oracle's relational and object relational database management systems through the powerful SQL language. The SQL commands, functions, and operators supported by Oracle as extensions to standard SQL are emphasized. Students learn to create and maintain database objects such as tables, indexes, views, constraints, and sequences. Students also learn to store, retrieve by using advanced techniques such as grouping sets, SET operators, and hierarchical retrieval, and manipulate data. They also learn to write SQL script files using iSQL*Plus tool, and to generate report-like output. Demonstrations and hands on practices reinforce the fundamental concepts. Audience Database Administrators, System Analysts. Skills Gained - Use SQL*Plus and iSQLPlus effectively
- Write SQL statements to query an Oracle Database
- Create and run SQL script files
- Use Oracle's numeric, character and date functions
- Analyse data using Oracle's analytic functions
- Implement Oracle's enhanced grouping functions
- Create and alter tables, indexes and views
- Insert, update, merge and delete rows
- Grant and revoke access privileges
- Access the Data Dictionary
Prerequisites Proficiency in standard SQL, Familiarity with database concepts.
How to make a booking for the OD9-SES course
|
