Course Outline
Introduction to Databases
- Definition and nature of databases
- Database classifications: relational, hierarchical, and NoSQL
- Purpose and strategic application of databases
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 Design
- Identification of entities, attributes, and relationships
- Construction of Entity-Relationship (ER) diagrams
- Translating conceptual models into physical tables
Relational Model and Normalization
- Structure of tables, rows, and columns
- Definition and use of primary and foreign keys
- Application of 1NF, 2NF, 3NF and the concept of denormalization
Essential SQL for Data Access
- Commands for SELECT, INSERT, UPDATE, and DELETE
- Techniques for filtering, sorting, and joining data
- Utilization of aggregate functions and subqueries
Database Security and User Administration
- Assignment of user roles and permissions
- Implementation of authentication and access control
- Protection of data both in transit and at rest
Backup, Recovery, and Maintenance Essentials
- Formulation of data backup strategies
- Considerations for disaster recovery
- Execution of routine maintenance and monitoring
Conclusion and Future Directions
Requirements
- Familiarity with general IT principles
- Practical experience in computer usage and file system navigation
- Foundational knowledge of data and file structuring
Target Audience
- IT support specialists
- Database administrators
- Developers or analysts moving into data-centric positions
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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.
