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 AfricaTraining 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.zaNB: 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