Oracle SQL Fundamentals
Course
In London and Edinburgh
Description
-
Type
Course
-
Location
-
Duration
5 Days
By the end of this course, the delegate will be able to: Describe the structure of a relational database, Use the command line features of SQL*Plus and SQL Developer, Create SQL statements to select data from an Oracle database, Use single row functions, Use enhanced grouping functions, Generate hierarchical queries, Generate scripts, Use SQL run time parameters, Create and. Suitable for: This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the following examinations: Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007) Oracle Database SQL Expert (IZ0-047) Oracle Database 11g: SQL Fundamentals (IZ0-051)
Facilities
Location
Start date
Start date
Start date
About this course
An understanding of IT is required.
Reviews
Subjects
- SQL
Course programme
This course is designed for anyone who needs to access and work with an Oracle Database. This course is suitable for delegates intending to sit the following examinations:
Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007)
Oracle Database SQL Expert (IZ0-047)
Oracle Database 11g: SQL Fundamentals (IZ0-051)
Objectives:
By the end of this course, the delegate will be able to:
- Describe the structure of a relational database
- Use the command line features of SQL*Plus and SQL Developer
- Create SQL statements to select data from an Oracle database
- Use single row functions
- Use enhanced grouping functions
- Generate hierarchical queries
- Generate scripts
- Use SQL run time parameters
- Create and alter tables, indexes and views
- Use external tables
- Create, update and delete records
- Create users, profiles and roles
- Grant and revoke access privileges
- Access the data dictionary
Exams are not included as part of the course. Before taking any exam, delegates must ensure they have the recommended experience.
Topics Covered:
- The Structure of a Relational Database
- Using SQL*Plus and SQL Developer
- The Basic SQL Select Statement
- Using Oracle and ANSI-Compliant Inner and Outer Joins
- Sub-Queries and Sub-Query Operators
- In-line views and Top-'N' Analysis
- Hierarchical Queries
- Grouping and Sorting Output
- Advanced Grouping Expressions and Functions
- Character, Date and Numeric Functions
- Timestamp and Interval Datatypes and Functions
- CASE Expressions
- Regular Expression Notation and Related Functions
- Creating and Changing Tables and Views
- Constraints and Indexes
- Inserting, Updating and Deleting Data
- Creating and Using External Tables
- Multitable Insert Statements
- Merge Rows in a Table
- External Tables
- Flashback Operations
- Basic Transaction Control
- Controlling Access to Objects
- Data Dictionary Tables and Views
An understanding of IT is required.
Oracle SQL Fundamentals