Oracle Database 11g: A Comprehensive Hands-On Introduction

Frequently Asked Questions

What is this course about? This course offers a comprehensive introduction to Oracle Database 11g. You learn how to design, build and manage robust database applications with Oracle database tools. Oracle 11g is a large, complex system. This course provides an overview of the power and flexibility of Oracle databases and serves as the foundation for other courses in the Learning Tree Oracle Databases curriculum. Extensive hands-on exercises provide invaluable, practical experience building Oracle 11g databases. The knowledge you learn in this course can be immediately applied to your job when you go back to work. Who will benefit from this course? This course benefits a wide range of professionals, including: Developers, analysts, administrators, managers, programmers, consultants, power users and others who design and write Oracle applications using Oracle 11g Database administrators who want to become proficient in querying and manipulating an Oracle database Data processing professionals with experience working in a traditional database system (hierarchical or network), who are now moving to a client/server or Web environment Technology managers and project leaders who need a general overview of Oracle 11g What background should I have? Some experience working with a relational database and familiarity with basic programming concepts are helpful but not required. If you have a strong background in a dialect of SQL other than Oracle, a small part of this course may be familiar to you, but you still benefit from the Oracle-specific material presented. Does this course cover the new features of Oracle 11g? This course does not spend a great deal of time covering the new features of Oracle 11g. Instead, this course focuses on the database principles and skills needed to develop robust databases for your organization. You gain a solid foundation on which to build your skills with Oracle 11g. If I have taken Course 925, SQL Programming Language: A Comprehensive Hands-On Introduction, should I take this course? No. Course 925 provides you with adequate SQL experience to prepare you for Course 927, Oracle® Database 11g Administration: Hands-On. There is overlap in the concepts taught in Course 925 and this course. What are the differences between Course 593, Oracle® Database 10g: A Comprehensive Hands-On Introduction, and this course? This course covers Oracle 11g, which is newer, upgraded software from Oracle 10g. This course is also one day shorter and has reduced coverage of SQL, PL/SQL and data management material. A chapter on OEM and DBA has been added, as well as coverage of Oracle development tools - SQL Developer and SQL*Plus. How much time is spent on each topic? Content Hours Introduction to Oracle 11g technology 1.5 Database installation and administration 3.5 Accessing and manipulating data 4.0 Creating and managing database objects 3.5 Maintaining integrity, security and performance 4.5 Programming with PL/SQL 3.0 Implementing server-side logic 3.0 Times, including the workshops, are estimates; exact times may vary according to the needs of each class. Should I take Course 593 as well as this course? No, you should take only one of the two introductory courses. These courses cover basic introductory features of Oracle databases, including how to build, query and manipulate an Oracle database. This course introduces the latest advances in Oracle 11g, as well as fundamental topics relevant to Oracle 9i and higher. Course 593 covers Oracle 9i and 10g fundamentals, and participants perform exercises on an Oracle 10g database. What kinds of hands-on exercises are included in the course? The hands-on exercises provide immediate reinforcement of the material covered. Exercises include: Designing a database with a data model Navigating the dictionary with Enterprise Manager Coding with SQL Developer and SQL*Plus Retrieving and manipulating data with SQL constructs Creating tables, sequences, views and synonyms Managing security, integrity and performance Programming with cursors, loops and control logic Debugging PL/SQL programs Building procedures, packages and triggers How does this course relate to other Learning Tree courses? Learning Tree offers a number of courses that will help you expand upon the knowledge gained in this course and further your skills in several key areas. Those courses include: 927, Oracle® Database 11g Administration: Hands-On  594, Oracle® Database 10g Administration: Hands-On  518, Hands-On Oracle® Database 10g: Backup, Recovery and Server Tuning  234, Developing SQL Queries for Oracle® Databases: Hands-On  382, Relational Database Design, Tools and Techniques: Hands-On  492, Application Development and Tuning for Oracle® Databases: Hands-On  493, Oracle® PL/SQL Programming: Hands-On

Oracle is a registered trademark of Oracle Corporation.