Oracle Database: Introduction to SQL

Learn the concepts of relational database and control privileges at the object and system level, as well as the essential SQL skills to write queries against single and multiple tables, manipulate data in tables, and create database objects.

In this workshop, you will learn how to create reports of sorted and restricted data, run data manipulation statements (DML) to update data, control database access to specific objects, manage schema objects, manage objects with data dictionary views, and retrieve row and column data from a table.

Course topics include:

-Introducing Oracle Database 11g
-Retrieving data using the SQL SELECT Statement
-Restricting and sorting data
-Using single-row functions to customize output
-Using conversion functions and conditional expressions
-Reporting aggregated data using the group functions
-Displaying data From multiple tables using joins
-Using sub-queries to solve queries
-Using the SET Operators
-Manipulating data
-Using DDL Statements to create and manage tables
-Creating other schema objects
-Controlling user access
-Managing schema objects
-Managing objects with data dictionary views
-Manipulating large data sets
-Managing data in different time zones
-Retrieving data using sub-queries

This workshop, which is presented by Lone Star Corporate College in partnership with the University of Houston, is designed for application developers, business analysts, data warehouse administrators, developers, forms developers, PL/SQL developers, and system analysts (NOTE: While appropriate for a 10g audience, there are differences between 10g and 11g features).

Dates: October 15-November 15
Meets: Monday & Thursdays, 6-10 p.m.
Location: Lone Star College University Park, 20515 State Highway 249 at Louetta, Houston, 77070

Hours: 40
Cost: $1,500