We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
This VTC course introduces some of the basics of Oracle Database including: installing Oracle on Windows and Linux, Oracle tools, some database modeling, underlying architecture (the files), creating and dropping tables, selecting data, filtering data, sorting data, built-in functions, joining tables, and aggregating with the GROUP BY clause. The course content is not focused on Oracle Certification but it will give you a good start towards coding SQL and will also get you started with basic installation and configuration. To begin learning today, simply click on the movie links.
Preparing a Linux Server pt. 1
Preparing a Linux Server pt. 2
Install Oracle Client Software
Download & Install Oracle Docs
Deinstalling & Reinstalling Oracle
Rerunning netca / ntemgr / dbca
Oracle Enterprise Manager (OEM)
Download & Install SQL Developer
Sample Models Used in this Course
Types of Databases (OLTP & DW)
Normalization & Normal Forms pt. 1
Normalization & Normal Forms pt. 2
Generating Tables from a Data Model
Some Advanced CREATE TABLE Syntax
Naming Constraints & More Syntax
Primary & Foreign Key Indexing
Unique Constraints / Non-FK Inversions
Check Constraints & Default Values
Global Temporary / Tablespaces / Logging
Partitions / Externals / Compression
Basic Dropping & Altering Tables
WHERE Clause Comparison Conditions
Logical / Compound Operators pt. 1
Logical / Compound Operators pt. 2
Logical / Compound Operators pt. 3
Making Queries Run Faster pt. 1
Making Queries Run Faster pt. 2
Making Queries Run Faster pt. 3
Making Queries Run Faster pt. 4
Every course on the vtc.com website contains free movies that let you assess the quality of our tutorials before you subscribe - just click on the blue links to watch them. Become a member today to access over 100,000 instructional videos!
Sign Up NowIf you are already an active vtc.com member, please log in to access the tutorials.