|
Oracle Database 11g: A Comprehensive Hands-On IntroductionDeveloping Database Applications with Oracle Database Tools
Course: 926
Type: Hands-On Training
Duration: 4 Days
You Will Learn How To
- Design, build and manage Oracle 11g database applications
- Establish a data model and a storage framework
- Retrieve and manipulate data efficiently using SQL Developer
- Create and manage database tables, sequences and synonyms
- Ensure data integrity, enforce security and enhance performance
- Write structured PL/SQL code to develop stored procedures, triggers and packages
Course Benefits The Oracle Database 11g server enables high-speed transactions, better business decisions and sophisticated applications. These capabilities provide users the functionality to build high-quality and efficient database applications. In this course, you gain a solid foundation to maximize Oracle 11g and develop robust databases for your organization.Who Should Attend Those who are new to Oracle databases as well as those planning to move to an Oracle database environment. Relational database experience and familiarity with basic programming concepts are helpful. Experience with Oracle databases is not required.Hands-On Training Throughout this course, exercises provide hands-on experience building Oracle 11g databases, including:
- 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
Course 926 Content
- The Oracle database product offering
- Relational database concepts
- Applying data modeling techniques
- Oracle database tools: SQL Developer and SQL*Plus
- Defining memory structures, processes and SGA
- Establishing a storage framework
- Installing and configuring Oracle Database 11g
- Working with Oracle Enterprise Manager
- Leveraging the Oracle Data Dictionary
- Selecting, restricting and ordering data
- Avoiding pitfalls in null values
- Exploiting built-in SQL functions
- Joins, outer joins and ANSI joins
- Grouping data and applying aggregate functions
- Combining result sets with set operators
- Comparing simple and correlated subqueries
- Inserting, updating, deleting and merging data
- Controlling transactions with ROLLBACK and COMMIT
- Locking data to preserve integrity
- Mapping logical model to physical design
- Creating users and schemas
- Defining column datatypes
- Altering and dropping columns
- Restoring data with Flashback and the recycle bin
- Filtering data with views
- Generating unique IDs with sequences
- Streamlining access to objects with synonyms
- Implementing referential integrity with primary, unique and foreign keys
- Incorporating business rules with check constraints
- Managing transactions and data with deferred and enforced constraints
- Authenticating users with password aging
- Controlling access with system and object privileges
- Simplifying privilege management with roles
- Guidelines for creating indexes
- Indexing the data for optimal access
- Managing unique, non-unique and composite indexes
- Declaring and initializing variables
- Controlling logic with IF and CASE statements
- Performing iterations with WHILE and FOR LOOPs
- Defining and managing PL/SQL records
- Trapping errors with exception handlers
- Declaring cursors to perform row-level operations
- Passing parameters to cursors to increase flexibility
- Simplifying cursors with FOR LOOPs
- Improving insert and delete performance with CURRENT OF or ROWID
- Terminating loops with cursor attributes
- Constructing procedures and functions
- Passing parameters to subprograms
- Debugging programs with DBMS_OUTPUT
- Advantages of deploying packages
- Bundling subprograms in packages
- Defining statement and row-level triggers
- Governing triggers with conditional predicates
|
Related Courses
Oracle is a registered trademark of Oracle Corporation.
|
|
|
|
Print Friendly
E-mail a Colleague
Course FAQ
Course PDF
Home
