Give your user community that competitive edge with this local Oracle Workshop. The course starts out with a complete overview of the Oracle architecture so students can get an understanding of how Oracle works. Attendees will learn how to access data from Oracle using the SQL language. The focus of this course is to give a working knowledge of SQL to non-IT people, or to people who are new to the relational database world. TOAD is a very popular Oracle SQL Query and Development tool. The attendees have the opportunity to construct various SQL statements to solve simple and complex business questions. This course includes how to update data, delete data, create tables, data relationships, and will touch briefly on using indexes to aid in the performance of the SQL. This course also covers creating various types of reports and web reports using the SQL*Plus interface.
Before taking this course, a working knowledge of a PC is helpful but not required.
2 Days/Lecture & Lab
This course is designed to give a working knowledge of SQL to non-IT people, or to people who are new to the relational database world.