Sign Up for Seminars from Over 600 Providers

Oracle Database 10g: A Comprehensive Hands-On Introduction - Developing Database Applications with SQL and PL/SQL

Fee:

$3,190

· QuickCode:

QQBTMQ

· Print Page · Email Page

Provider:
Learning Tree International

Topic(s):
Computers & Software > Data Base

Who Should Attend?
This Course benefits those who are, or will be, working with Oracle 10g. Relational database experience and familiarity with basic programming concepts are useful. Oracle experience is not required.

Full Seminar Description

You will learn how to

• Build, query and manipulate Oracle 10g databases to create powerful applications
• Retrieve and manipulate data efficiently using powerful SQL features
• Create and manage database tables, views and sequences
• Maintain data integrity and enforce security with privileges and roles
• Compose reusable structured PL/SQL code with cursors and procedures
• Enhance performance through indexes and PL/SQL optimization
• Program with packages and triggers

Course benefits

In this course, you gain the skills to utilize the Oracle Database 10g server. Hands-on exercises provide experience in applying relational database concepts, leveraging the SQL language and programming with PL/SQL.

Who should attend

Hands-on training

• Designing a database
• Creating tables, views and sequences
• Producing queries using joins, set operators, groupings and subqueries
• Merging large datasets and inserting across multiple tables
• Imposing business rules utilizing declarative constraints
• Enforcing security with roles
• Enhancing performance with indexes
• Controlling logic and handling exceptions
• Building PL/SQL procedures, triggers and packages

Course content

• Relational database concepts
• Logical data modeling
• Specifying attributes, entities, relationships and candidate keys
• Installation, configuration and architecture
• Defining SGA, processes and database files

RETRIEVING AND CONTROLLING DATA

• Working with SQL*Plus and iSQL*Plus
• Configuring environment settings
• Defining connections using login.sql
• Implementing case-insensitive queries
• Assessing SQL fundamentals
• Selecting, filtering and ordering results
• Avoiding pitfalls in null values
• Pattern matching with regular expressions
• Combining result sets with set operators
• Exploiting SQL techniques
• Oracle joins vs. ANSI joins
• Constructing outer joins and self joins
• Grouping and aggregating data
• Simple and correlated subqueries
• Comparing CASE and DECODE functions
• Manipulating data
• Inserting, updating and deleting data
• Streamlining DML with MERGE
• Locking data and managing transactions

DESIGNING AND FORMULATING THE DATABASE

• Applying the physical design
• Mapping logical model to physical design
• Establishing a storage framework
• Creating users and schemas
• Defining LOB and TIMESTAMP data
• Constructing and managing tables
• Building tables with CREATE TABLE
• Altering and dropping tables
• Restoring data with Flashback
• Accessing OS files with external tables
• Leveraging the data dictionary
• Creating scripts against the data dictionary
• Developing views and sequences
• Assembling views to filter data
• Generating unique IDs using sequences
• Maintaining integrity
• Determining referential integrity with primary, unique and foreign keys
• Imposing business rules with CHECK constraints
• Handling transactions and data with deferred and enforced constraints

OPTIMIZING SERVER PROGRAMMING

• Invoking PL/SQL fundamentals
• Declaring variables and constants
• Defining stored procedures and functions
• Writing structured code with %TYPE and %ROWTYPE
• Establishing program control
• IF...THEN...ELSE vs. CASE statements
• Creating WHILE LOOPs and FOR LOOPs
• Error handling with predefined exceptions
• Operating with cursor types
• Controlling implicit and explicit cursors
• Passing parameters to cursors
• Simplifying cursors with FOR LOOPs
• Improving performance with ROWID
• Handling concurrency with FOR UPDATE

IMPLEMENTING DEVELOPMENT TECHNIQUES

• Assembling triggers
• Distinguishing statement and row triggers
• Regulating triggers with predicates
• Building triggers to validate, derive and audit data
• Constructing procedures and packages
• Choosing best parameter types
• Creating and administering packages
• Advantages of employing packages
• Debugging programs with DBMS_OUTPUT

ADVANCING SECURITY AND PERFORMANCE

• Enforcing security
• Verifying with password aging
• Classifying system and object privileges
• Controlling access with roles
• Accessing schemas via synonyms
• Enriching performance
• Guidelines for defining optimal indexes
• Creating unique, non-unique and composite indexes
• Monitoring index usage

Are You Ready to Learn... Anywhere?

Attend live, instructor-led Learning Tree classes via your computer from wherever you want with NEW Learning Tree AnyWare™. Now you can learn from the world's best instructors and gain the management, leadership or IT skills you need to become even more effective in your job... from wherever you are!

You participate in every aspect of the live course exactly as if you were in the physical classroom! With our groundbreaking Learning Tree AnyWare user portal, you can attend from anywhere with live video streaming over the Internet.

• See and hear your instructor live, presenting and annotating the course materials on the in-class dual-screen MagnaLearn™ course content delivery system.
• Communicate in real-time directly with the instructor and your classmates both by voice and through the use of a Chat pod. Ask questions. Provide comments. Participate in the class discussions. Engage in collaborative "breakout" sessions.
• Perform the same hands-on exercises, with live assistance from your expert instructor, using the same in-class computers and software as the participants in the classroom, except that you perform them from anywhere!

Be There with Learning Tree AnyWare

Take the Next Step…

Click on a "REMOTE TRAINING" date above to enroll online as a Learning Tree AnyWare participant.

Sponsor Background:

Learning Tree International is a world leader in Hands-on training for Management and Technology Professionals. Since 1974, over 1,700,000 course participants from over 13,000 organizations around the world have enhanced their skills through intensive hands-on exercises under the guidance of expert instructors with real-world experience.

Virtually every major company and government agency has relied on Learning Tree to provide its managers and employees with the skills they need to succeed in their job functions.

10 Reasons to Choose Learning Tree

... over 1.7 million professionals have trained with Learning Tree

1 Benefit from 32 Years of Training Excellence

Learning Tree International has trained over 1,700,000 IT and management professionals and managers from more than 13,000 organizations around the world. Virtually every major technologyoriented organization and government agency has trusted and relied on us to provide their employees with the training they need to master the latest technologies and management skills.

2 Learn from Expert Instructors

Learning Tree instructors are active practitioners who average more than 20 years experience in their field. Because they use the very technologies and skills they teach, they've already solved the same problems you are likely to encounter, so you and your organization gain the knowledge from their years of hands-on expertise. In addition to their extensive real-world experience, our instructors only qualify to teach Learning Tree Courses after completing our rigorous industryleading screening and training program.

3 Experience Superior Course Design

Learning Tree Courses are developed through a stringent, time-tested process that ensures every course is practical and relevant. Our development teams include multiple subject experts drawn from our worldwide network-and our courses are constantly updated to ensure what you learn is always up to date.

4 Courses are Available Anywhere, Anytime

In addition to our Education Centers located in North America, Europe and the Pacific Rim, Learning Tree has the infrastructure and logistical capabilities to assemble, customize and deliver world-class training anywhere in the world. Whether it's a single course at your own facility, or a complete curriculum you need to present in different locations around the globe, location is not a problem.

5 Acquire Practical Skills with Hands-On Instructor-led Training

Each of our intensive hands-on courses is designed to help you gain the skills you need-quickly and in depth. Our courses are taught in a collaborative, supportive classroom-based environment, not on a Web site where you get instruction in a vacuum. And when you return to work, you can apply your new skills, tools and techniques right away, so you and your organization reap the benefits immediately.

6 Retain New Knowledge and Skills Longer

Learning Tree Courses are developed around the principles of Active Learning, the most advanced and effective method of adult education. You are immersed in your subject through individual and group activities that significantly increase your understanding, retention and ability to apply new knowledge and concepts to maximum effect.

7 Learn in a Superb Training Environment

Our modern, comfortable Education Centers are designed to ensure the comfort, ease and maximum effectiveness of your learning experience. We provide state-of-the-art equipment featuring MagnaLearn(tm), our proprietary Instructional Enhancement Technology-which helps you learn more quickly, in greater depth and with increased retention.

8 Achieve Professional Certification

We offer 45 Certification Programs that give you professional recognition and document your expertise. Achieving Learning Tree Certification demonstrates your mastery of the essential skills required to excel in your role.

9 Earn College Credit or Continuing Education Credit

Learning Tree Courses are recommended for college credit to more than 1,500 Universities and Colleges by the American Council on Education (ACE). Our courses are also eligible for PDU credits from the Project Management Institute, as well as CPE credits from the National Association of State Boards of Accountancy.

10 Vendor-Independent Training

Learning Tree was, is and will continue to be independent of vendor influences. That means you get training that is unbiased. We present an objective, evenhanded treatment of the pros and cons of new products, techniques and technology. You even learn about third-party alternatives that the vendors themselves would never tell you about.

Learning Tree Management Training

For over 32 years, Learning Tree has been dedicated to meeting the professional development needs of people like you. Now, more than ever, superior management, leadership and interpersonal skills are critical to individual and organizational success. And it is equally critical to be able to apply those skills in complex, technology-intensive environments.

Experience the Quality...of Learning Tree Hands-On Training

Learning Tree is committed to providing the most effective high-quality education for IT professionals and managers. Our high standards for Course Development, Instructor Training and state-of-the-art facilities provide a learning experience that ensures your training investment produces the results you and your organization expect.

Active Training Ensures That "You Learn by Doing"

For over 32 years, Learning Tree has been a pioneer in the application of Active Training, which is the most advanced and effective method of adult education. And today, we are still leading the way.

In our courses, you learn by doing. Our instructors do more than just lecture--they actively involve you in your training. Brief lectures are followed by hands-on exercises so that you master new skills right away.

Get Real-World Solutions from Expert Instructors

Learning Tree instructors are active practitioners who work full time in high-tech companies, R & D labs and other business environments where they use the very technologies and skills they teach. Because they have already solved the same problems you are likely to encounter, our instructors are equipped to share their real-world experience and practical solutions with you. Everything you learn is practical, relevant and up to the minute.

This seminar has 7 upcoming dates & cities. To quickly return to this seminar later, you can search by its QuickCode: QQBTMQ.

Get updated when new dates are added for this seminar.
Get a free personalized recommendation from our experts!