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
Fundamentals of Databases
- Defining a database.
- Database classifications: relational, hierarchical, and NoSQL.
- Scenarios and reasons for utilizing databases.
Database Management Systems (DBMS)
- Architectural overview of DBMS.
- Leading platforms including SQL Server, MySQL, PostgreSQL, and Oracle.
- Key functions and responsibilities of a DBMS.
Data Modeling and Design
- Defining entities, attributes, and their relationships.
- Creating Entity-Relationship (ER) diagrams.
- Translating conceptual models into table structures.
Relational Modeling and Normalization
- Structure of tables, rows, and columns.
- The role of primary and foreign keys.
- Understanding normal forms (1NF, 2NF, 3NF) and denormalization.
Essential SQL for Data Access
- Core commands: SELECT, INSERT, UPDATE, DELETE.
- Techniques for filtering, sorting, and joining data.
- Utilizing aggregate functions and subqueries.
Database Security and User Administration
- Managing user roles and access permissions.
- Authentication mechanisms and access control strategies.
- Protocols for securing data both in transit and at rest.
Backup, Recovery, and Maintenance Essentials
- Formulating data backup strategies.
- Considerations for disaster recovery planning.
- Performing routine maintenance and monitoring tasks.
Conclusion and Future Pathways
Requirements
- A solid grasp of general IT fundamentals.
- Familiarity with computer usage and navigating file structures.
- Foundational knowledge regarding data organization and file management.
Target Audience
- IT support specialists.
- Database administrators.
- Developers or analysts looking to transition into data-centric roles.
40 Hours
Testimonials (4)
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.
- UNIFI
Course - NoSQL Database with Microsoft Azure Cosmos DB
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated