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:

Be able to install and configure Oracle Database 21c XE.
Understand and administer the HR demo database.
Create an interactive Power BI dashboard using Oracle data.
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:

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

Hardware and Software Requirements:

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
Operating System:
- Windows 10/11 (64-bit) or Linux (64-bit)
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:

Programming Basics (Optional)
- Exposure to programming languages like Python or Java can help with understanding PL/SQL concepts.
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:

When filling the online application form; please take note of your desired Training Month, Duration in Weeks and Training Session. This will give us the exact dates you will be attending your classes.

Also note that Tuition Fees must be paid upfront on or before training start date. This is to ensure that all resources are made availabe for you before you start. You will not be allowed into training if fees are not paid and verified.

Also note that Tuition Fees Cancellations must be made 14 business working days before the starting date of training. This will allow us to do a 50% refund of the total amount paid. If cancellations are made thereafter note that no refund will be made to delegates.

Tuition Fees include teas and lunch as well as either a laptop or tablet which a delegate will take home free of charge.

Tuition Fee DOES NOT include Accommodation, Dinners and other Extra Curricular Activities or Incidentals. Delegates are expected to fund this on their own. AATICD will not be held accountable for any incidents to delegates.

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