Oracle Database 10g: SQL Fundamentals I

This course offers students an introduction to Oracle Database 10g database technology. In this class, students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.

Demonstrations and hands-on practices reinforce the fundamental concepts.

Learn to:

• Use SQL Statements to retrieve data from tables
• Create and Manage Tables
• Employ SQL functions to generate and retrieve customized data
• Run data manipulation statements (DML) to update data in the Oracle Database 10g

Audience:

• Database Beheerder
• Eindgebruiker
• Applicatie Ontwikkelaar met PL/SQL

Course Objectives:

• Identify the major structural components of Oracle Database 10g
• 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
• Create reports of aggregated data
• Write SELECT statements that include queries
• Use the SET operators to create subsets of data
• Run data manipulation statements (DML) to update data in the Oracle Database 10g
• Create tables to store data
• Utilize views to display and retrieve data
• Create sequences to generate numbers
• Obtain meta data by querying the dictionary views.

Required Prerequisites:

• Familiarity with Data Processing Concepts and Techniques
• Ability to use a graphical user interface (GUI)