Introductory Oracle SQL and SQL*Plus class designed for developers, DBAs, analysts, IT managers and other professionals who are new to relational databases. Hands-on class covers an introduction to relational databases including concepts, structure, terminology and statements; in-depth introduction to Oracle 10g, SQL*Plus and iSQL*Plus; Queries (simple SELECT, advanced filters, joins, set operators, subqueries and grouping data); Tables and Indexes; Views and Synonyms; Datatypes and Functions; data manipulation, transaction and concurrency control; other Database Objects and an intro to SQL Tuning. 

Class Description:

This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases. Students with experience with some other relational database, but new to Oracle database should attend our Introduction to Oracle and SQL for Experienced Developers course.

Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts.

Hands-on workshops constitute approximately 50% of the class.

Relational database experience is helpful but not required. Previous experience with Oracle or SQL is not required.

Audience:  

Developers, Analysts, DBAs, Quality Assurance personnel, I.T. Management