Oracle Database Administration with Power BI Integration

This hands-on course provides participants with the skills to install Oracle Database 21c Express, set up the HR demo database, and create a Power BI dashboard using the pre-existing HR tables and views. The course emphasizes practical application and administrative concepts.

Expected Outcomes:

By the end of the course, participants will:

1. Be able to install and configure Oracle Database 21c XE.
2. Understand and administer the HR demo database.
3. Create an interactive Power BI dashboard using Oracle data.
4. Grasp essential database administration and performance tuning techniques.

Who Can Attend?

• Database Administrators (DBAs)
• Developers
• Data Analysts and BI Professionals
• Data Engineers
• IT and Computer Science Students
• Recent Graduates
• Non-IT Professionals (Career Switchers)
• Project Managers and Team Leads
• Business Power Users
• Corporate Teams

Pre-Requisites 

To ensure participants can fully benefit from the course, the following prerequisites are recommended:

Technical Knowledge:

1. Basic Understanding of Databases
   • Familiarity with fundamental database concepts such as tables, rows, columns, primary keys, and foreign keys.
2. SQL Basics
   • Ability to write basic SQL queries (SELECT, INSERT, UPDATE, DELETE).
   • Knowledge of joins and basic functions is advantageous but not mandatory.
3. General IT Skills
   • Comfortable with file systems, folder navigation, and command-line usage.
   • Experience with basic software installation and configuration.

Hardware and Software Requirements:

1. Laptop or PC with the following minimum specifications:
   • Processor: Intel Core i5 or equivalent
   • RAM: 8 GB or more
   • Storage: At least 20 GB of free disk space
2. Operating System:
   • Windows 10/11 (64-bit) or Linux (64-bit)
3. Installed Software:
   • Oracle Database 21c Express (provided during the course if not pre-installed)
   • SQL Developer (optional, for database interactions)
   • Power BI Desktop (latest version, free download available)

Recommended Prior Experience:

1. Programming Basics (Optional)
   • Exposure to programming languages like Python or Java can help with understanding PL/SQL concepts.
2. Familiarity with Reporting Tools
   • Knowledge of any reporting tool like Excel, Tableau, or others can ease the transition to Power BI.

Mindset and Expectations:

• Willingness to learn through hands-on labs and exercises.
• Openness to troubleshoot technical challenges during setup and tasks.

Participants who meet these prerequisites will be able to progress smoothly through the course and maximize their learning outcomes.

 

---

Location:

South Africa

Training Dates:

Each course starts every Monday of each week. Please book your training on a date that is a Monday.

Course Duration: 2 Weeks

Unit Standard: 114048

NQF Level: 5

Number of Credits: 9

Course Fees

Note: Please fill in the online application form on the left or bottom if this page to receive a quotation with detailed pricing from AATICD.

How to Apply:

To Apply Simply Fill in the Online Enquiries / Applications form on the Right Sidebar or Bottom of this website https://www.aaticd.co.za

NB: Terms and Conditions for Payment and Refunds

1.1. Full payment for the training workshop must be made at least 5 days before the scheduled workshop date.

1.2. Payment can be made via bank transfer, credit card, or any other agreed-upon method.

1.3. A confirmation of payment will be issued upon receipt of funds.

1.4. Any form of Payment means that trainee / delegate / client receiving the training accepts the training and agrees to these terms and conditions.

2. Cancellation and Refund Policy

2.1. Cancellations made 30 days or more before the workshop date will be eligible for a full refund, minus any administrative fees.

2.2. Cancellations made 15 to 29 days before the workshop date will be eligible for a 50% refund of the total payment.

2.3. Cancellations made less than 14 days before the workshop date will not be eligible for a refund.

2.4. Participants who fail to attend the workshop without prior notice will not be eligible for a refund.

3. Rescheduling

3.1. If a participant wishes to reschedule, a request must be submitted at least 14 days in advance, subject to availability.

3.2. A rescheduling fee may apply.

4. Workshop Cancellation by the Organizer

4.1. AATICD reserves the right to cancel or reschedule the workshop due to unforeseen circumstances, including but not limited to low enrolment, trainer unavailability, or force majeure events.

4.2. In the event of cancellation by AATICD, participants will be offered a full refund or the option to attend a rescheduled session.

4.3. AATICD is not responsible for any additional costs incurred by participants, such as travel or accommodation expenses.

5. Refund Processing

5.1. Approved refunds will be processed within 7 business days from the date of cancellation approval.

5.2. Refunds will be issued using the original payment method unless otherwise agreed.

6. Contact Information

For any questions regarding payments and refunds, please contact us at:

Email: apply@aaticd.co.za

Phone: +27 73 016 5042

By registering for the workshop, participants agree to abide by these terms and conditions.

In-House Trainings are also available for 3 or more delegates for any duration. Please consult with our Administration for such In-House training bookings.

---

Course Outline

Day 1: Oracle Database Overview and Installation

Morning Session:

• Introduction to Oracle Databases
  • What is a database?
  • Overview of Oracle Database Editions (XE, SE, EE)
  • Features of Oracle 21c Express
• System Requirements and Preparation
  • Understanding hardware/software requirements for Oracle XE
  • Setting up a virtual machine or server (if required)

Afternoon Session:

• Installing Oracle 21c XE
  • Step-by-step installation on Windows/Linux
  • Post-installation verification
  • Exploring Oracle tools (SQL Developer, SQL*Plus)
• Hands-On Lab
  • Perform installation and validate setup

---

Day 2: Oracle Database Basics and HR Demo Database Setup

Morning Session:

• Database Architecture Overview
  • Instance and database
  • Tablespaces, datafiles, and control files
  • Background processes and memory structures

Afternoon Session:

• HR Demo Database Setup
  • Overview of HR schema and data model
  • Importing and configuring the HR demo database
  • Validating schema integrity and relationships
• Hands-On Lab
  • Set up the HR schema and explore its tables/views

---

Day 3: Database Administration Essentials

Morning Session:

• User and Role Management
  • Creating and managing users
  • Assigning roles and privileges
  • Understanding system and object privileges
• Managing Storage Structures
  • Tablespaces and datafile management
  • Quota assignments for users

Afternoon Session:

• Backup and Recovery Basics
  • Introduction to RMAN
  • Performing a simple backup and recovery
• Hands-On Lab
  • Create users, roles, and manage storage

---

Day 4: SQL for Administrators

Morning Session:

• Introduction to SQL for Administration
  • SELECT statements and joins
  • Filtering and sorting data
  • Using aggregate functions

Afternoon Session:

• Advanced SQL
  • Views, sequences, and indexes
  • Working with PL/SQL basics (stored procedures, triggers)
• Hands-On Lab
  • Write and execute SQL to query and manage HR tables

---

Day 5: Power BI Integration with Oracle

Morning Session:

• Introduction to Power BI
  • Overview of Power BI Desktop
  • Connecting Power BI to Oracle Database
• Data Transformation in Power BI
  • Importing Oracle tables into Power BI
  • Cleaning and transforming HR data

Afternoon Session:

• Creating a Data Model
  • Relationships between HR tables
  • Designing measures and calculated columns
• Hands-On Lab
  • Set up Power BI connection and import data

---

Day 6: Power BI Dashboard Design

Morning Session:

• Dashboard Fundamentals
  • Designing user-friendly dashboards
  • Best practices for visualizations

Afternoon Session:

• Building the HR Dashboard
  • Visualizing employee data (departments, salaries, locations)
  • Adding interactivity with slicers and filters
  • Publishing the dashboard
• Hands-On Lab
  • Create and finalize the HR dashboard

---

Day 7: Performance Tuning and Course Review

Morning Session:

• Performance Tuning Basics
  • Query optimization techniques
  • Understanding indexes and execution plans
  • Monitoring database performance

Afternoon Session:

• Final Project and Review
  • Presenting the Power BI HR dashboard
  • Course recap and Q&A
  • Feedback and next steps
• Hands-On Lab
  • Optimize queries and finalize dashboards