VTC Legacy
Home / Programming

Introduction to Oracle 11g

by Gavin Powell
139 lessons14 chapters11.3 hReleased 20125 free
Start the free chapter

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.

Course content

Introduction5 lessons
Oracle Installation & Configuration11 lessons
Tools & Configuration6 lessons
The Relational Database8 lessons
The Architecture of Oracle11 lessons
Working with Tables20 lessons
The SELECT Statement15 lessons
Restricting & Filtering Data16 lessons
Sorting Data6 lessons
Single Row Functions9 lessons
Joining Tables14 lessons
Aggregating Using GROUP BY16 lessons
Conclusion1 lessons
Credits1 lessons