Duration: 5 days
view class outline
Oracle 10g SQL Training Overview
In Accelebrate's Oracle 10g SQL Programming training, students learn how to create, retrieve, and manipulate objects in Oracle 10g Structured Query Language (SQL). Students will also be introduced to Oracle 10g database features and tools. Students also develop deeper insight into relational database design and RDBMS operation, learn concepts and specific SQL syntax for extended Oracle datatypes, learn analysis and tuning techniques to increase SQL performance, and master advanced features of Oracle® SQL for large data sets and data warehouses.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. áTo see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=course&page=SQL104.
Oracle 10g SQL Training Prerequisites
No prior experience is presumed.
This course is 60% hands-on, 40% discussion, with the longest discussion segments lasting 20 minutes.
Oracle 10g SQL Training Materials
All students receive comprehensive courseware and a related textbook.
Software Needed on Each Student PC
- A complete installation of Oracle 10g
Please contact us for detailed setup instructions if you have purchased this class.
Oracle 10g SQL Training Objectives
All attendees will learn:
- A summation of relational database principles and an introduction to the Oracle relational database server.
- Using the iSQL*Plus web-based database interface and other traditional interfaces.
- Writing simple SQL queries and moderately complex SQL queries using various join techniques.
- Summarizing, grouping and sorting data.
- Advanced query techniques such as correlated subqueries.
- Developing simple SQL*Plus reports.
- Creating and maintaining database tables.
- Taking advantage of new features such as the use of regular expressions.
- Moving beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
- Understanding basic database security and object privileges.
- Using the powerful set of built-in SQL functions.
- Protecting the database and extending the basic data model using declarative constraints.
- Performing advanced SQL queries such as grouping and cube operations and SQL99 join syntax.
- Developing complex SQL*Plus reports and using SQL*Plus scripts.
- Use the SQL99 join syntax. Also, performing advanced SQL queries using techniques such as grouping and cube operations.
- Move beyond basic table definitions, consideration of defining the full range of database objects, such as advanced table definitions, indexes, sequences, views and others.
- Understand basic database security and object privileges.
- Use the powerful set of built-in SQL functions.
- Protect the database and extending the basic data model using declarative constraints.
- Develop complex SQL*Plus reports and using SQL*Plus scripts.