Oracle Introduction for Experienced SQL Users

By the end of this course, the delegate will be able to use SQL*Plus and SQL Developer effectively and write SQL statements to query an Oracle Database. The delegate will also be able to create and run SQL script files, use Oracle's numeric, character and date functions, implement Oracle's enhanced grouping functions and create and alter tables, indexes and views. Delegates will also be able to insert, update, merge and delete rows, grant and revoke access privileges and access the Data Dictionary Course content

• Overview of Oracle Database features
• UsingSQL*Plus andSQLDeveloper
• Querying the Oracle Database
• Subqueries and in-line views
• Numeric functions
• Character functions
• Common date and timestamp functions
• Actual and hypothetical data ranking
• Decoding data
• Enhanced grouping features
• Tables, indexes, views and sequences
• External and temporary tables
• Data manipulation and transaction control
• Access control
• The Data Dictionary