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.
Duration 40 hours
Course Outline
Introduction to Databases
- Defining a database
- Database categories: relational, hierarchical, and NoSQL
- Rationale for database implementation
Database Management Systems (DBMS)
- Architectural overview of DBMS
- Leading platforms (SQL Server, MySQL, PostgreSQL, Oracle)
- Core functions of a DBMS
Data Modeling and Design
- Entities, attributes, and inter-relationships
- Creating Entity-Relationship (ER) diagrams
- Translating models into table structures
Relational Model and Normalization
- Structure of tables, rows, and columns
- Role of primary and foreign keys
- First, second, and third normal forms (1NF, 2NF, 3NF) and denormalization
Basic SQL for Data Access
- Core commands: SELECT, INSERT, UPDATE, DELETE
- Data filtering, ordering, and joining operations
- Utilizing aggregate functions and subqueries
Database Security and User Management
- Managing user roles and permissions
- Authentication methods and access controls
- Protecting data during transmission and while stored
Backup, Recovery, and Maintenance Basics
- Strategies for data backup
- Considerations for disaster recovery
- Standard maintenance and monitoring practices
Summary and Next Steps
Requirements
- General understanding of IT fundamentals
- Familiarity with computer usage and file system navigation
- Basic awareness of data and file organization structures
Intended Audience
- IT systems support staff
- Database administrators
- Developers or analysts moving into data-centric roles
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.
