Oracle Introduction for Experienced SQL Users
Course
In London
£ 795
+ VAT
Description
-
Type
Course
-
Location
London
This course is designed to give experienced SQL users practical experience in accessing an Oracle Database. This course is suitable for users of versions 9i, 10g and 11g.
Facilities
Location
Start date
London
See map
Clerks Court 18-20 Farringdon Lane Clerkenwell, EC1R 3AU
Start date
On request
Reviews
Have you taken this course?
Subjects
- SQL
- IT
Course programme
Introduction
- Oracle - a brief overview
- Users and roles
- Object naming rules
- Oracle datatypes
- The data dictionary
- Using SQL*Plus
- Entering and executing SQL statements
- Creating, editing and running SQL scripts
- Using SQL Developer
- Starting SQL Developer
- Configuring a Connection
- Navigation Tabs
- SQL Worksheet
- Overview of the basics
- Traditional Oracle v. ANSI-standard table joins
- Set operators
- Using aggregate functions
- Subqueries and in-line views
- Using the WITH clause
- Hierarchical queries
- Using the table dual
- Numeric functions
- Formatting numeric output
- Character functions and string concatenation
- Default date and timestamp formats
- Accessing the current date and time
- Date and time arithmetic
- Date functions
- Formatting date and time output
- Conversion functions
- NVL and NVL2
- DECODE
- The simple CASE expression
- The searched CASE expression
- The ROLLUP extension
- The CUBE extension
- The GROUPING function
- The GROUPING_ID function
- The GROUPING SETS extension
- Creating tables
- Defining datatypes
- Specifying constraints
- Table, column and constraint operations
- Recovering dropped tables
- Temporary tables
- External tables
- Index-organized tables
- Handling B-tree indexes
- Creating and using views
- Creating and using sequences
- Inserting rows
- Updating rows
- Deleting rows
- Verifying updates
- Multi-table inserts
- Merging rows
- Basic transaction control
- System privileges
- User accounts and roles
- Granting and revoking object privileges
- Using synonyms
- Data dictionary tables
- Querying the data dictionary
- Useful SQL statements
- RANK and DENSE_RANK
- NTILE and WIDTH_BUCKET
- Analytic aggregates
- Reporting aggregate functions
- Windowing aggregate functions
Oracle Introduction for Experienced SQL Users
£ 795
+ VAT