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
Foundations of Databases
- Defining a database
- Database categories: relational, hierarchical, NoSQL
- Scenarios and reasons for database implementation
Database Management Systems (DBMS)
- Architectural overview of DBMS
- Leading platforms (SQL Server, MySQL, PostgreSQL, Oracle)
- Core functions and responsibilities of a DBMS
Data Modeling and Architecture
- Identifying entities, attributes, and connections
- Creating Entity-Relationship (ER) diagrams
- Translating conceptual models into tabular structures
Relational Frameworks and Normalization
- Components: tables, rows, and columns
- Significance of primary and foreign keys
- Levels 1NF, 2NF, 3NF and the concept of denormalization
Introductory SQL for Data Interaction
- Commands: SELECT, INSERT, UPDATE, DELETE
- Techniques for filtering, ordering, and joining data
- Utilizing aggregate functions and subqueries
Database Protection and User Administration
- Defining user roles and access rights
- Authentication methods and access control mechanisms
- Ensuring data security during transmission and storage
Backup, Restoration, and Upkeep Fundamentals
- Strategies for data backup
- Considerations for disaster recovery
- Scheduled maintenance and performance monitoring
Recap and Future Directions
Requirements
- Familiarity with general IT concepts
- Proficiency in operating computers and navigating file structures
- Fundamental understanding of data and file organization
Target Audience
- IT support specialists
- Database administrators
- Developers or analysts moving into data-centric positions
40 Hours
Testimonials (2)
personalised to our understanding and data
Vincent Long - ASSMANG PTY LTD
Course - Business Intelligence with SSAS
The training instruments provided.
