Oracle® 10g Training Courses
Batky-Howell's Oracle 10g training curriculum includes eight classes covering advanced topics like Oracle 10g New Features, Database Administration, and Real Application Clusters as well as introductory topics like SQL Programming and PL/SQL Programming. Click on a course title below to read more about each of our offerings:
- Introduction to Oracle Programming (5 days)
-
This course is a combination of “Introduction to Oracle SQL Programming” and “Introduction to Oracle PL/SQL Programming.” Students will learn how to create, retrieve, and manipulate objects in Oracle Database 10g Structured Query Language (SQL). Students will also be introduced to Oracle10g features and tools. Students will learn the fundamentals of the PL/SQL programming language, writing stored procedures, functions, packages, and triggers.
- Introduction to Oracle SQL Programming (2 days)
-
In this class, students will 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.
- Introduction to Oracle PL/SQL Programming (3 days)
-
Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.
- Advanced Oracle SQL Programming (3 days)
-
In this class, students will 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.
- Advanced Oracle PL/SQL Programming (2 days)
-
This advanced course helps PL/SQL programmers take advantage of language features, advanced techniques, and packages and facilities provided by Oracle to develop and tune efficient and effective PL/SQL subprograms.
- Oracle 10g Database Administration (5 days)
-
This class will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class. This class will also address issues for DBAs having to support Oracle8i and Oracle9i databases.
- Oracle10g New Features for Administrators (5 days)
-
This class will introduce the experienced Oracle DBA to the new features contained in Oracle Database 10g. As students are introduced to the various new features, labs will reinforce the material presented in this course. Once this course is completed, the student will have gained the foundational knowledge to begin to administer Oracle10g databases.
- Oracle 10g Real Application Clusters for Administrators (5 days)
-
This hands-on course teaches students all aspects of Oracle 10g RAC administration. Students will begin with a solid foundation in Oracle Clusterware and RAC architecture. Students will then install and configure both Clusterware and the database software, as well as cover the administration of both pieces of software using command line utilities. Important topics such as failover, flashback, and backup and recovery are all covered in detail. Students will get hands-on experience with Automatic Storage Management. The course ends with troubleshooting and tuning a RAC system.
Want to speak with someone? Contact us at 1-800-868-2202 or This e-mail address is being protected from spambots. You need JavaScript enabled to view it .
Delivery Options
All eight Oracle 10g training classes can be delivered at your location, or at our Denver, Colorado Training Center. These courses are also available as live online deliveries using our virtual classroom.
For individual students, we regularly schedule our Introduction to Oracle 10g SQL Programming class as well as our Oracle 10g Database Administration class on our public calendar.
Outstanding technical mastery. The instructor clearly knows Oracle SQL backwards and forwards and is excellent at explaning it. I have taken many classes and by far this is one of the best for the money it costs. Great job.
About the Technology
A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. The Structured Query Language (SQL) is the international standard language for relational database management systems. SQL is robust enough to be used by, users with non-technical backgrounds, as well as professional developers and administrators. PL/SQL is Oracle’s Procedural Language for SQL. It is Oracle’s database programming language for creating stored procedures, functions, database triggers, and object methods. PL/SQL can be used for implementing business rules, computing algorithms, manipulating data, and for stand-alone programs.
I love the workbook and use my SQL book from last year often. I'm sure the PL/SQL book for this course will get a lot of use in the future also.
About Batky-Howell
In our 20 years of existence, we have taught over 40,000 students across North America, Europe, and Asia in topics ranging from VMware to Oracle Database Administration. We deliver our hands-on, instructor-led training classes both onsite and live online. Read more about our story and what we do.
