Oracle DBA - Intro to SQL

Class times are from 9 A.M. to 5 P.M

Description

This course offers students an extensive introduction to data server technology.

The class covers the concepts of both relational and object relational databases and the powerful SQL programming language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. Students learn to retrieve data using advanced techniques such as ROLLUP, CUBE, set operators, and hierarchical retrieval. They also learn to write SQL and SQL*Plus script files to generate report-like output using the iSQL*Plus tool. Demonstrations and hands-on practice reinforce the fundamental concepts.

Audience

• Applications Developer
• Database Administrators
• System Analysts
• Technical Support Professionals

Required Prerequisites

• Farmiliarity with data processing cencepts and techniques.

Suggested Prerequisites

Ability to use graphical user interface (GUI).

Course Objectives

• Describe relational and object relational database concepts
• Retreive, insert, update and delete data
• Create and maintain database objects
• Control transactions
• Control data / user access
• Use advanced techniques to retreive data using ROLLUP, CUBE, set operators, correlated sbqueries, and hierarchical queries, and scalar subqueries
• Use the new single row DATETIME and NVL2 functions introduced in Oracle9i
• Using GROUPING SETS and the WITH clause
• Solve problems using multicolumn subqueries, subqueries in the FROM clause of a SELECT statement, correlated subqueries, and scalar subqueries. 
• Perform multi-table INSERTs and use External Tables
• Write SQL scripts which use SQL to generate SQL
• Use basic iSQL*Plus commands
• Use iSQL*Plus to format reports

Course Topics

• Introduction
• Writing a basic SQL statement
• Restricting and sorting data
• Single row functions
• Displaying data from multiple tables
• Aggregating data using group functions
• Writing subqueries
• Produsing readable output with iSQL*Plus
• Manipulating data
• Creating and managing tables
• Including constraints
• Creating views
• Other database objects
• Controlling user access
• SQL workshop
• Using set operators
• Enhancement to the GROUP BY clause
• Hierarchical retrieval
• Advanced subqueries
• Writing scripts to generate scripts

Suggested Next Courses

Please check with your Education Representative to determine the appropriate follow up course.

Related Courses

No related Technology Bases Training Courseware is currently available.

- top -

[home] [about us] [people] [products] [investors] [training] [conferences] [news] [contact us]

Copyright RPC Data 2005
Site Design and Development by MindQ