Oracle Berkeley - DB Administration
( Duration: 4 Days )COURSE AGENDA
1
Introduction to Berkeley DB
- Berkeley DB Concepts
- Environments
- Key-Data Pairs
- Storing Data
- Duplicate Data
- Replacing and Deleting Entries
- Secondary Keys
- Access Methods
- Selecting Access Methods
- Choosing between BTree and Hash
- Choosing between Queue and Recno
- Database Limits and Portability
- Exception Handling
- Error Returns
- Getting and Using DB
2
Database Environments
- Opening Database Environments
- Closing Database Environments
- Environment Properties
- Opening Databases
- Closing Databases
- Database Properties
- Administrative Methods
- Error Reporting Functions
- Managing Databases in Environments
3
The Direct Persistence Layer
- Direct Persistence Layer First Steps
- Entity Stores
- Opening and Closing Environments and Stores
- Persistent Objects
- Saving and Retrieving Data
4
Working with Indices
- Accessing Indexes
- Accessing Primary Indices
- Accessing Secondary Indices
- Creating Indexes
- Declaring a Primary Indexes
- Declaring Secondary Indexes
- Foreign Key Constraints
5
Saving and Retrieving Objects
- A Simple Entity Class
- Placing Objects in an Entity Store
- Retrieving Objects from an Entity Store
- Retrieving Multiple Objects
- Cursor Initialization
- Working with Duplicate Keys
- Key Ranges
- Join Cursors
- Deleting Entity Objects
- Replacing Entity Objects
6
Database Records
- Using Database Records
- Reading and Writing Database Records
- Writing Records to the Database
- Getting Records from the Database
- Deleting Records
- Data Persistence
- Using the BIND APIs
- Numerical and String Objects
- Serializable Complex Objects
- Custom Tuple Bindings
7
Using Cursors
- Opening and Closing Cursors
- Getting Records Using the Cursor
- Searching for Records
- Working with Duplicate Records
- Putting Records Using Cursors
- Deleting Records Using Cursors
- Replacing Records Using Cursors
8
Database Configuration
- Setting the Page Size
- Overflow Pages
- Locking
- IO Efficiency
- Page Sizing Advice
- Selecting the Cache Size
- BTree Configuration
- Allowing Duplicate Records
- Setting Comparison Functions
9
Transactions Introduction
- Transaction Benefits
- A Note on System Failure
- Application Requirements
- Multi-threaded and Multi-process Applications
- Recoverability
- Performance Tuning
10
Enabling Transactions
- Environments
- File Naming
- Error Support
- Shared Memory Regions
- Security Considerations
- Opening a Transactional Environment and Store or Database
11
Transaction Basics
- Committing a Transaction
- Non-Durable Transactions
- Aborting a Transaction
- Auto Commit
- Nested Transactions
- Transactional Cursors
- Using Transactional DPL Cursors
- Secondary Indices with Transaction Applications
- Configuring the Transaction Subsystem
Encarta Labs Advantage
- One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
- All courses are delivered by Industry Veterans
- Get jumpstarted from newbie to production ready in a matter of few days
- Trained more than 50,000 Corporate executives across the Globe
- All our trainings are conducted in workshop mode with more focus on hands-on sessions
View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php
Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.
Notice
X