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
Overview of Database Systems
- Definition and purpose of a database
- Database classifications: relational, hierarchical, and NoSQL
- Scenarios and rationale for database implementation
Database Management Systems (DBMS)
- Architecture of DBMS components
- Leading platforms (SQL Server, MySQL, PostgreSQL, Oracle)
- Core responsibilities of a DBMS
Data Modeling and Architecture
- Identifying entities, attributes, and relationships
- Creating Entity-Relationship (ER) diagrams
- Translating conceptual models into table structures
Relational Framework and Normalization
- Understanding tables, rows, and columns
- Role of primary and foreign keys
- Normal forms 1NF, 2NF, 3NF, and the concept of denormalization
Foundational SQL for Data Interaction
- Commands for SELECT, INSERT, UPDATE, and DELETE
- Techniques for filtering, sorting, and joining tables
- Utilization of aggregate functions and subqueries
Database Security and Access Control
- Configuration of user roles and permissions
- Authentication mechanisms and access restrictions
- Protocols for securing data in transit and at rest
Backup, Recovery, and Upkeep Essentials
- Strategies for data backup
- Considerations for disaster recovery
- Standard maintenance routines and system monitoring
Conclusion and Future Directions
Requirements
- A solid grasp of general IT principles
- Proficiency in using computers and navigating file systems
- Foundational knowledge of data and file organization
Target Audience
- IT systems support staff
- Database administrators
- Developers or analysts moving into data-centric roles
40 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
