Skip to content

Booksellers & Trade Customers: Sign up for online bulk buying at trade.atlanticbooks.com for wholesale discounts

Booksellers: Create Account on our B2B Portal for wholesale discounts

Oracle Demystified

by Infowave Mrv
Save 7% Save 7%
Current price ₹1,337.00
Original price ₹1,444.00
Original price ₹1,444.00
Original price ₹1,444.00
(-7%)
₹1,337.00
Current price ₹1,337.00

Imported Edition - Ships in 18-21 Days

Free Shipping in India on orders above Rs. 500

Request Bulk Quantity Quote
+91
Book cover type: Paperback
  • ISBN13: 9798338417348
  • Binding: Paperback
  • Subject: N/A
  • Publisher: Independently Published
  • Publisher Imprint: Independently Published
  • Publication Date:
  • Pages: 202
  • Original Price: GBP 11.41
  • Language: English
  • Edition: N/A
  • Item Weight: 481 grams
  • BISAC Subject(s): General

Oracle Demystified: A Practical Guide for Beginners

Table of contents:

  1. Introduction to Oracle Database
    • Overview of Oracle Database
    • The Importance of Oracle in the Industry
  2. Setting Up Your Oracle Environment
    • Installation of Oracle Database
    • Configuration Basics
    • Connecting to the Database
  3. Understanding Oracle Architecture
    • Key Components and Structure
    • Oracle Instance vs. Database
  4. Basic SQL Queries
    • Introduction to SQL
    • SELECT, INSERT, UPDATE, DELETE Commands
  5. Database Objects and Structures
    • Tables, Views, and Indexes
    • Schemas and Users
  6. Data Types and Constraints
    • Common Data Types
    • Implementing Constraints (Primary Key, Foreign Key, etc.)
  7. PL/SQL Basics
    • Introduction to PL/SQL
    • Writing and Executing PL/SQL Blocks
  8. Procedures and Functions
    • Creating Stored Procedures
    • Building Functions for Reusable Code
  9. Triggers and Exception Handling
    • Understanding Triggers
    • Exception Handling in PL/SQL
  10. Transactions and Concurrency Control
    • Concepts of Transactions
    • Managing Transactions and Isolation Levels
  11. Data Management and Security
    • Backup and Recovery Techniques
    • User Management and Security Best Practices
  12. Performance Tuning Basics
    • Understanding Query Performance
    • Basic Tuning Techniques
  13. Working with Oracle Tools
    • Oracle SQL*Plus
    • Oracle SQL Developer and Other GUI Tools
  14. Data Modeling and Design
    • Entity-Relationship Models
    • Normalization and Denormalization
  15. Advanced SQL Queries
    • Joins, Subqueries, and Set Operations
    • Analytical Functions
  16. Understanding and Using Views
    • Creating and Managing Views
    • Materialized Views
  17. Introduction to Oracle RAC
    • Concepts of Real Application Clusters (RAC)
    • Benefits and Basic Configuration
  18. Data Warehousing with Oracle
    • Basics of Data Warehousing
    • ETL Processes and Oracle Data Warehouse
  19. Oracle Cloud Services
    • Overview of Oracle Cloud Offerings
    • Migrating to Oracle Cloud
  20. Best Practices and Troubleshooting
    • Common Pitfalls and How to Avoid Them
    • Troubleshooting Techniques and Tools
Feel free to adjust or expand any chapters based on the specific focus you want to have!

Trusted for over 49 years

Family Owned Company

Secure Payment

All Major Credit Cards/Debit Cards/UPI & More Accepted

New & Authentic Products

India's Largest Distributor

Need Support?

Whatsapp Us