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.