Oracle Database 11g: SQL Fundamentals Tutorial

A complete free tutorial for download about Oracle Database 11g: SQL Fundamentals course material and training, PDF document under 500 pages for advanced users.

With this Oracle Database 11g training, you can start your way to becoming the indispensable Oracle DBA in your business.

This Oracle Database 11g training gives you solid foundations to exploit Oracle 11g and build robust databases.

During this Oracle Database 11g DBA training, you will learn the installation, management, architecture, and components of an Oracle database, as well as the interactions between the different elements.

Table of contents

• Lesson Objectives
• Lesson Agenda
• Course objectives, agenda, and appendixes used in the course
• Overview of Oracle Database 11g and related products
• Overview of relational database management concepts and terminologies
• Introduction to SQL and its development environments
• The HR schema and the tables used in this course
• Oracle Database 11g documentation and additional resources

Course Objectives

After completing this course, you should be able to:

• Identify the major components of Oracle Database 11g
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted and restricted data
• Employ SQL functions to generate and retrieve customized data