| Details: |
Duration: 12 hrs Oracle 9i SQL covers the relational Database Model, the Oracle Architecture, & the Physical database. This CD Rom training tutorial is aimed at programmers and individuals with prior SQL and relational database knowledge.
Author Gavin Powell begins with numerous Oracle tools such as the SQL Plus Worksheet, SQL Plus, and Oracle Enterprise Manager. He then explains how to maintain the Logical Database and the difference between it and the Physical database. You will be guided in great detail through retrieving, changing, adding and deleting data from the Database. From there you will discover Logical Database objects, Select Statements, Security, and more. This Oracle 9i SQL training course also covers areas for the Oracle Certification course (1Z0-007).
Welcome
Welcome
Useful Web Sites
What is Oracle Software?
History of Databases
History of Oracle
About this Training Course
The Relational Database Model
The Relational Database Model
The Concerts Schema
Normalization part 1
Normalization part 2
Denormalization part 1
Denormalization part 2
Oracle SQL and PL/SQL Tools
What are the Oracle SQL and PL/SQL Tools?
SQL Plus
Formatting Output
SQL Plus Worksheet
iSQL Plus
Oracle Enterprise Manager
Oracle Enterprise Manager part 2
Architecture
Oracle Database and Oracle Instance part 1
Oracle Database and Oracle Instance part 2
Control Files, Logging, Archiving and Recoverability
Creating Database Objects
Oracle Simple Datatypes part 1
Oracle Simple Datatypes part 2
Oracle Complex and Object Datatypes
Types of Tables
Methods of Table Creation
Create Table Syntax
Example Table Creations part 1
Example Table Creations part 2
Altering and Dropping Tables part 1
Altering and Dropping Tables part 2
What are Constraints?
Creating, Changing and Dropping Constraints
Types of Indexes part 1
Types of Indexes part 2
Creating, Altering and Dropping Indexes
Sequence Counters
Synonyms
Views part 1
Views part 2
Metadata Views and Error Messages
Users & Security in Oracle
Schemas, Users, Privileges and Roles part 1
Schemas, Users, Privileges and Roles part 2
Schemas, Users, Privileges and Roles part 3 in Oracle
Types of Users
Creating Users part 1
Creating Users part 2
Altering and Dropping Users
Security
System Privileges
Object Privileges
Granting and Revoking Privileges part 1
Granting and Revoking Privileges part 2
Grouping Privileges Using Roles part 1
Grouping Privileges Using Roles part 2
Setting Roles
Retrieving Data from the Database
The SELECT Statement part 1
The SELECT Statement part 2
The SELECT Statement part 3
Types of SELECT Statement part 1
Types of SELECT Statement part 2
The DUAL Table part 1
The DUAL Table part 2
What is a NULL?
Pseudo-Columns part 1
Pseudo-Columns part 2
More About SQL Plus Formatting part 1
More About SQL Plus Formatting part 2
More About SQL Plus Formatting part 3
Oracle Built In Functions
Types of Functions part 1
Types of Functions part 2
String Functions part 1
String Functions part 2
String Functions part 3
Number Functions
Date Functions part 1
Date Functions part 2
Other Functions part 1
Other Functions part 2
Datatype Conversion Functions part 1
Datatype Conversion Functions part 2
Custom Functions Using PL/SQL
Filtering SELECT Statements
The WHERE Clause
Conditional Comparisons
Using the WHERE Clause
Using Logical Operators part 1
Using Logical Operators part 2
Using Conditional Comparisons part 1
Using Conditional Comparisons part 2
Sorting SELECT Statements
The ORDER BY Clause
Sorting Methods
Joining Multiple Tables in Oracle
What is a Join?
Two Join Syntax Formats
Types of Joins part 1
Types of Joins part 2
Types of Joins part 3
Cross Join or Cartesian Product
Natural or Inner Join part 1
Natural or Inner Join part 2
Natural or Inner Join part |
