BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Excel Business Institute - ECPv6.15.20//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Excel Business Institute
X-ORIGINAL-URL:https://excelbi.co.za
X-WR-CALDESC:Events for Excel Business Institute
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20250101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20260928T090000
DTEND;TZID=UTC:20261002T130000
DTSTAMP:20260921T104059
CREATED:20260416T075243Z
LAST-MODIFIED:20260416T075243Z
UID:10000819-1790586000-1790946000@excelbi.co.za
SUMMARY:Certificate: Technology: Database Development
DESCRIPTION:Course Overview:\nThis course provides the foundational knowledge and practical skills to design\, build\, query\, and manage modern\, secure\, and efficient databases. \nTarget Audience: Aspiring Database Developers\, Data Analysts\, IT professionals\, and software developers. \nOutline\nModule 1: Database Design and Modeling\n\nRelational Database Concepts and Principles.\nEntity-Relationship (ER) Diagramming.\nNormalization (1NF\, 2NF\, 3NF).\nTranslating Business Requirements into a Data Model.\n\nModule 2: SQL and Query Optimization\n\nCore SQL: DDL\, DML\, DQL (SELECT\, JOINs\, WHERE\, GROUP BY).\nWriting Advanced Queries: Subqueries\, Functions.\nIndexing and Query Performance Tuning.\nUnderstanding Execution Plans.\n\nModule 3: Data Warehousing Concepts\n\nData Warehouse Architecture (OLAP vs. OLTP).\nDimensional Modeling: Stars and Snowflakes Schemas.\nETL (Extract\, Transform\, Load) Processes.\nIntroduction to BI and Reporting.\n\nModule 4: Database Security and Management\n\nUser Authentication and Authorization.\nImplementing Data Encryption.\nBackup\, Recovery\, and Disaster Planning.\nRoutine Maintenance and Monitoring.\n\nModule 5: Emerging Trends in Database Technology\n\nIntroduction to NoSQL Databases (Document\, Key-Value).\nCloud Database Services (e.g.\, AWS RDS\, Azure SQL).\nBig Data Fundamentals.\nOverview of Data Lakes.
URL:https://excelbi.co.za/event/certificate-technology-database-development/2026-09-28/
LOCATION:Excel BI\, 484 Hilda Street\, Hatfield\, Pretoria\, Gauteng\, 0083\, South Africa
CATEGORIES:Technology
ATTACH;FMTTYPE=image/jpeg:https://excelbi.co.za/wp-content/uploads/2026/04/3darts-renders-k9o7KiAzcis-unsplash.jpg
ORGANIZER;CN="Excel BI":MAILTO:info@excelbi.co.za
END:VEVENT
END:VCALENDAR