Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to Databases
- Defining a database
- Database types: relational, hierarchical, and NoSQL
- Purpose and use cases for databases
Database Management Systems (DBMS)
- Overview of DBMS architecture
- Leading platforms (SQL Server, MySQL, PostgreSQL, Oracle)
- Core functions of a DBMS
Data Modeling and Design
- Exploring entities, attributes, and relationships
- Creating Entity-Relationship (ER) diagrams
- Translating conceptual models into table structures
Relational Model and Normalization
- Structure of tables, rows, and columns
- The role of primary and foreign keys
- Normalization forms 1NF, 2NF, 3NF, and the concept of denormalization
Basic SQL for Data Access
- Core commands: SELECT, INSERT, UPDATE, and DELETE
- Data filtering, sorting, and joining tables
- Utilizing aggregate functions and subqueries
Database Security and User Management
- Configuring user roles and permissions
- Implementing authentication and access control mechanisms
- Protecting data whether it is in motion or stored
Backup, Recovery, and Maintenance Basics
- Strategies for data backup
- Planning for disaster recovery
- Standard maintenance and monitoring procedures
Recap and Future Learning Pathways
Requirements
- Familiarity with general IT concepts
- Proficiency in using computers and navigating file systems
- Foundational understanding of data and file organization
Target Audience
- IT support specialists
- Database administrators
- Developers or analysts moving into data-focused roles
40 Hours
Testimonials (3)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
