Oracle SQL
Course
In Manchester, London, Birmingham and 3 other venues
Description
-
Type
Course
-
Location
-
Duration
3 Days
By the end of this course, the delegate will be able to; describe the basic structure of a relational database, use the command line features of SQL*Plus, use SQL Developer to access an Oracle Database, create SQL statements to select data from an Oracle Database and yse SQL run time parameters. Delegates will also be able to use aggregate functions, use numeric, character, date, conversion and miscellaneous functions, use subqueries, create and alter tables, indexes and views, create.
Facilities
Location
Start date
Start date
Start date
Start date
Start date
Start date
Start date
Reviews
Course programme
- The Structure of a Relational Database
- UsingSQL*Plus
- UsingSQLDeveloper
- The BasicSQLSelect Statement
- Selecting Data from Multiple Tables
- Inner Joins, Outer Joins and Self Joins
- Grouping and Sorting Output
- Sub-queries and In-line Views
- Character, Date and Numeric Functions
- SQL*Plus Run-time Parameters and Variables
- Creating and Changing Tables and Views
- Constraints and Indexes
- Inserting, Updating and Deleting Data
- Basic Transaction Control
- Controlling Access to the Database
- Related Data Dictionary Tables and Views
Oracle SQL