Oracle: Performance Tuning (1Z0-033)

Welcome
Welcome
Useful Web Sites
What is Oracle Software?
The History of Databases
The History of Oracle
About this Course

The Oracle Relational Database Model
The Relational Database Model
The Concerts Schema
Oracle PL SQL Normalization Tutorials 1
Normalization 2
Denormalization 1
Denormalization 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 1
Oracle Enterprise Manager 2

The Architecture of Oracle
The Oracle Database and Oracle Instance 1
The Oracle Database and Oracle Instance 2
Control Files, Logging, Archiving and Recoverability

Creating Database Objects
Oracle Simple Datatypes 1
Oracle Simple Datatypes 2
Oracle Complex and Object Datatypes
Types of Tables
Methods of Table Creation
Create Table Syntax
Example Table Creations Tutorials 1
Example Table Creations 2
Altering and Dropping Tables 1
Altering and Dropping Tables 2
What are Constraints?
Creating, Changing and Dropping Constraints
Types of Indexes 1
Types of Indexes 2
Creating, Altering and Dropping Indexes
Sequence Counters
Synonyms
Views Tutorials 1
Views 2
Metadata Views and Error Messages

Users and Security
Schemas, Users, Privileges and Roles 1
Schemas, Users, Privileges and Roles 2
Schemas, Users, Privileges and Roles 3
Types of Users
Creating Users Tutorials 1
Creating Users 2
Altering and Dropping Users
Security
Oracle SQL PL System Privileges
Object Privileges
Granting and Revoking Privileges Tutorials 1
Granting and Revoking Privileges 2
Grouping Privileges Using Roles 1
Grouping Privileges Using Roles 2
Setting Roles

Retrieving Data from the Database
Oracle PL SQL SELECT Statement Tutorials 1
The SELECT Statement 2
The SELECT Statement 3
Types of SELECT Statement 1
Types of SELECT Statement 2
The DUAL Table 1
The DUAL Table 2
What is a NULL?
Pseudo-Columns 1
Pseudo-Columns 2
More About Oracle PL SQL Plus Formatting 1
More About SQL Plus Formatting 2
More About SQL Plus Formatting 3

Oracle Built In Functions
Types of Functions Tutorials 1
Types of Functions 2
String Functions 1
String Functions 2
String Functions 3
Number Functions
Oracle PL SQL Date Functions 1
Date Functions 2
Other Functions 1
Other Functions 2
Datatype Conversion Functions 1
Datatype Conversion Functions 2
Custom Functions Using PL/SQL

Filtering SELECT Statements
The WHERE Clause
Conditional Comparisons
Using the WHERE Clause
Using Logical Operators Tutorials 1
Using Logical Operators 2
Using Conditional Comparisons 1
Using Conditional Comparisons 2

Sorting SELECT Statements
The ORDER BY Clause
Sorting Methods Tutorials 1
Sorting Methods 2
Sorting Methods 3

Joining Multiple Tables
What is a Join?
Two Join Syntax Formats
Types of Joins Tutorials 1
Types of Joins 2
Types of Joins 3
Cross Join or Cartesian Product
SQL PL Natural or Inner Join 1
Change the Concerts Schema 1
Change the Concerts Schema 2
Oracle PL SQL Outer Join 1
Outer Join 2
Self Join
Equi-Joins, Anti-Joins and Range-Joins
Mutable and Complex Joins

Summarizing with GROUP BY
What does GROUP BY Do?
The GROUP BY Clause
Types of Grouping Functions 1
Types of Grouping Functions 2
Special Behavior 1
Special Behavior 2
Summary Functions
Statistical Functions
Other Functions
Filtering GROUP BY with the HAVING Clause
Extending the GROUP BY Clause Tutorials 1
Extending the GROUP BY Clause 2

Subqueries and Other Advanced Queries
What is a Subquery?
Types of Subqueries
Comparison Conditions Revisited 1
Comparison Conditions Revisited 2
Comparison Conditions Revisited 3
Regular vs. Correlated Subqueries
Nested Subqueries and Replacing Joins
Where Can PL SQL Subqueries be Used?
Hierarchical Queries
Set Operators and Composite Queries

Oracle Data Manipulation Language (DML)
What is DML?
Adding Data with INSERT
Multiple Table INSERT Tutorials 1
Multiple Table INSERT 2
Changing Data with UPDATE 1
Changing Data with UPDATE 2
Remove Data with DELETE or TRUNCATE Tutorials 1
Remove Data with DELETE or TRUNCATE 2
Merging Tables with MERGE 1
Merging Tables with MERGE 2
Transactional Control
Locking and Visibility of Data Changes
COMMIT vs ROLLBACK

PL SQL (Programming Language SQL)
What is PL/SQL?
Anonymous Procedures
Modular Structure
Named Procedures
Functions
Packages
Oracle PL SQL Triggers Tutorials 1
Triggers 2
Variables and Types in PL/SQL 1
Variables and Types in PL/SQL 2
Objects and Object Datatypes
More About Objects 1
More About Objects 2
Programming Control Structures
Simple Database Access in PL/SQL
Cursors and Implicit Cursors 1
Cursors and Implicit Cursors 2
Explicit Cursor Tutorials 1
Explicit Cursors 2
Dynamic SQL
Provided (DBMS_) Packages