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
Getting Started with Databases
- Definition and purpose of a database
- Database types: relational, hierarchical, and NoSQL
- Scenarios and benefits of utilizing databases
Database Management Systems (DBMS)
- Architectural overview of DBMS
- Leading platforms (SQL Server, MySQL, PostgreSQL, Oracle)
- Key responsibilities of a DBMS
Data Modeling and Architecture
- Identifying entities, attributes, and relationships
- Creating Entity-Relationship (ER) diagrams
- Translating models into table structures
Relational Structures and Normalization
- Concepts of tables, rows, and columns
- Defining primary and foreign keys
- Normalization levels (1NF, 2NF, 3NF) and denormalization strategies
Core SQL for Data Retrieval
- Commands for SELECT, INSERT, UPDATE, and DELETE
- Data filtering, sorting, and joining tables
- Using aggregate functions and subqueries
Data Security and Access Control
- Configuring user roles and permissions
- Authentication methods and access restrictions
- Protecting data during transmission and storage
Backup, Recovery, and Maintenance
- Strategies for data backup
- Considerations for disaster recovery planning
- Standard maintenance and monitoring tasks
Recap and Future Pathways
Requirements
- Familiarity with general IT principles
- Proficiency in computer operation and file system navigation
- Foundational knowledge of data and file organization
Target Audience
- IT support staff
- Database administrators
- Developers or analysts moving into data-centric positions
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.
