 |
Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and Oracle Enterprise Manager. This tutorial will explain how to maintain the Logical Database, and the difference between the Logical Database and the Physical database. You will be guided, in great detail, in the following areas: retrieving, changing, adding, and deleting data from the Database. From there, you will learn about Logical Database objects, Security, Select Statements, and much more. Introduction to Oracle SQL and PL/SQL will cover areas for the Oracle Certification course (1Z0-007). To get started, click one of the movie topics below.
Access the complete Oracle: Introduction to Oracle SQL and PL/SQL Training title online with just your Web browser.
Join our Online University and have unlimited access to these tutorials for Oracle: Introduction to Oracle SQL and PL/SQL plus all our 400+ other titles for one low price!
LEARN MORE or
SIGN UP NOW FOR INSTANT ACCESSOR
Learn Oracle: Introduction to Oracle SQL and PL/SQL from our PC and Mac compatible CDRom.
The affordable price of $99.95 gives you high quality software training that is easy for anyone to understand and follow.
Start training straight away with our Free lesson links on the right or BUY THIS CD NOW! |
|
|
|
Are you ready to start your learning RIGHT NOW?
You can have immediate access to more than 2500 hours of VTC Training just minutes from now, and for the incredibly low price of $30/month OR LESS!
The VTC Online University provides unlimited 24/7 access to ALL of VTC's incredible training content.
|
|
-- More Info /
Subscribe Now! --
|
|
FREE Updates
VTC adds training for new software every week, and with the VTC Online University, you get immediate access to these new titles, for no additional cost! There are currently over 450 different software titles, and more are added EVERY MONTH!
|
|
-- More Info /
Subscribe Now! --
|
|
No Long Term Committment
With the VTC Online University, you can signup for as little as ONE MONTH only! There is no minimum time committment, and you can cancel your membership at any time.
|
|
-- More Info /
Subscribe Now! --
|
|
Training a Group?
Our Multi-User Online Account makes training groups of
people efficient and cost effective. Businesses, Schools
(from Elementary through Post Secondary), and Government
Departments alike all over the world enjoy the freedom
and benefits of our online training and tutorials from office, school, home, and
on the go.
|
|
-- Multi-User Licensing Info --
|
|
|
Oracle: Introduction to Oracle SQL and PL/SQL
- Information About This Title -
|
| Proper Title: |
Oracle: Introduction to Oracle SQL and PL/SQL |
| Description: |
Click here to open / close full description
Virtual Training Company's Introduction to Oracle SQL and PL/SQL tutorial will cover the relational Database Model, the Oracle Architecture and the Physical database. The tutorial is aimed at programmers, and individuals who have had prior SQL and relational database experience. Gavin Powell, your instructor, will begin teaching you many Oracle tools such as the SQL Plus, SQL Plus Worksheet, and Oracle Enterprise Manager. This tutorial will explain how to maintain the Logical Database, and the difference between the Logical Database and the Physical database. You will be guided, in great detail, in the following areas: retrieving, changing, adding, and deleting data from the Database. From there, you will learn about Logical Database objects, Security, Select Statements, and much more. Introduction to Oracle SQL and PL/SQL will cover areas for the Oracle Certification course (1Z0-007). To get started, click one of the movie topics below.
-Close-
|
| Instructor: |
Gavin Powell (more by this author) |
| Instruction: |
165 Tutorials - Duration: 12 hrs |
| First Release: |
2003-03-15 |
| Compatitibility: |
Vista, XP, NT, 2000, 98, Mac OS9, Mac OS X 10.1+ |
| In Stock? |
Yes - 2-5 days shipping |
| Price: |
$99.95 |
|
|
|
Why Learn With VTC?!
|
- Let an expert teach you Oracle: Introduction to Oracle SQL and PL/SQL
- No classrooms or schedules - you learn on YOUR terms
- No books to read - watch instructional video right on your computer
- VTC training methods ensure the highest possible retention and fastest learning
- Use VTC materials for future reference / refresher
- Share CDRom training with others, friends, colleagues
- Used by many schools, universities, and big business world wide
- The most cost effective training available for Oracle: Introduction to Oracle SQL and PL/SQL
|
|
|
| |
Below is content list
for all of the lessons included with the
Oracle: Introduction to Oracle SQL and PL/SQL Training. Click on the linked lessons to watch Free.
You must have Quicktime
installed on your computer - if you are using a recent computer, then chances are you
already do. |
| Free Demo Lessons |
Welcome
 Welcome
Useful Web Sites
What is Oracle Software?
The History of Databases
The History of Oracle
About this Course
The Relational Database Model
The Relational Database Model
The Concerts Schema
Normalization pt. 1
Normalization pt. 2
Denormalization pt. 1
Denormalization pt. 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 pt. 2
... More lessons below ...
Would you like to continue? You can have instant access to the rest of this training for just $30.00 through our Online University, or you can purchase
the CDRom version!
|
The Architecture of Oracle
The Oracle Database and Oracle Instance pt. 1
The Oracle Database and Oracle Instance pt. 2
Control Files, Logging, Archiving and Recoverability
Creating Database Objects
Oracle Simple Datatypes pt. 1
Oracle Simple Datatypes pt. 2
Oracle Complex and Object Datatypes
Types of Tables
Methods of Table Creation
Create Table Syntax
Example Table Creations pt. 1
Example Table Creations pt. 2
Altering and Dropping Tables pt. 1
Altering and Dropping Tables pt. 2
What are Constraints?
Creating, Changing and Dropping Constraints
Types of Indexes pt. 1
Types of Indexes pt. 2
Creating, Altering and Dropping Indexes
Sequence Counters
Synonyms
Views pt. 1
Views pt. 2
Metadata Views and Error Messages
Users and Security
Schemas, Users, Privileges and Roles pt. 1
Schemas, Users, Privileges and Roles pt. 2
Schemas, Users, Privileges and Roles pt. 3
Types of Users
Creating Users pt. 1
Creating Users pt. 2
Altering and Dropping Users
Security
System Privileges
Object Privileges
Granting and Revoking Privileges pt. 1
Granting and Revoking Privileges pt. 2
Grouping Privileges Using Roles pt. 1
Grouping Privileges Using Roles pt. 2
Setting Roles
Retrieving Data from the Database
The SELECT Statement pt. 1
The SELECT Statement pt. 2
The SELECT Statement pt. 3
Types of SELECT Statement pt. 1
Types of SELECT Statement pt. 2
The DUAL Table pt. 1
The DUAL Table pt. 2
What is a NULL?
Pseudo-Columns pt. 1
Pseudo-Columns pt. 2
More About SQL Plus Formatting pt. 1
More About SQL Plus Formatting pt. 2
More About SQL Plus Formatting pt. 3
Oracle Built In Functions
Types of Functions pt. 1
Types of Functions pt. 2
String Functions pt. 1
String Functions pt. 2
String Functions pt. 3
Number Functions
Date Functions pt. 1
Date Functions pt. 2
Other Functions pt. 1
Other Functions pt. 2
Datatype Conversion Functions pt. 1
Datatype Conversion Functions pt. 2
Custom Functions Using PL/SQL
Filtering SELECT Statements
The WHERE Clause
Conditional Comparisons
Using the WHERE Clause
Using Logical Operators pt. 1
Using Logical Operators pt. 2
Using Conditional Comparisons pt. 1
Using Conditional Comparisons pt. 2
Sorting SELECT Statements
The ORDER BY Clause
Sorting Methods
Joining Multiple Tables
What is a Join?
Two Join Syntax Formats
Types of Joins pt. 1
Types of Joins pt. 2
Types of Joins pt. 3
Cross Join or Cartesian Product
Natural or Inner Join pt. 1
Natural or Inner Join pt. 1
Natural or Inner Join pt. 1
Outer Join pt. 1
Outer Join pt. 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 pt. 1
Types of Grouping Functions pt. 2
Special Behavior pt. 1
Special Behavior pt. 2
Summary Functions
Statistical Functions
Other Functions
Filtering GROUP BY with the HAVING Clause
Extending the GROUP BY Clause pt. 1
Extending the GROUP BY Clause pt. 2
Subqueries and Other Advanced Queries
What is a Subquery?
Types of Subqueries
Comparison Conditions Revisited pt. 1
Comparison Conditions Revisited pt. 2
Comparison Conditions Revisited pt. 3
Regular vs. Correlated Subqueries
Nested Subqueries and Replacing Joins
Where can Subqueries be Used?
Hierarchical Queries
Set Operators and Composite Queries
Oracle's Data Manipulation Language (DML)
What is DML?
Adding Data with INSERT
Multiple Table INSERT pt. 1
Multiple Table INSERT pt. 2
Changing Data with UPDATE pt. 1
Changing Data with UPDATE pt. 2
Remove Data with DELETE or TRUNCATE pt. 1
Remove Data with DELETE or TRUNCATE pt. 2
Merging Tables with MERGE pt. 1
Merging Tables with MERGE pt. 2
Transactional Control
Locking and Visibility of Data Changes
COMMIT vs ROLLBACK
PL/SQL (Programming Language SQL)
What is PL/SQL?
Modular Structure
Anonymous Procedures
Named Procedures
Functions
Packages
Triggers pt. 1
Triggers pt. 2
Variables and Types in PL/SQL pt. 1
Variables and Types in PL/SQL pt. 2
Objects and Object Datatypes
More About Objects pt. 1
More About Objects pt. 2
Programming Control Structures
Simple Database Access in PL/SQL
Cursors and Implicit Cursors pt. 1
Cursors and Implicit Cursors pt. 2
Explicit Cursors pt. 1
Explicit Cursors pt. 2
Dynamic SQL
Provided (DBMS_) Packages
|
|
|
|
|
