Course Outline
Fundamentals of Database Systems
- Defining a database
- Categorizing databases: relational, hierarchical, and NoSQL
- Identifying appropriate use cases for database implementation
Database Management Systems (DBMS)
- Examining DBMS architecture
- Reviewing major platforms such as SQL Server, MySQL, PostgreSQL, and Oracle
- Outlining the core functions of a DBMS
Data Modeling and Architecture
- Analyzing entities, attributes, and their relationships
- Creating Entity-Relationship (ER) diagrams
- Translating conceptual models into database tables
The Relational Model and Normalization
- Working with tables, rows, and columns
- Utilizing primary and foreign keys
- Applying 1NF, 2NF, 3NF, and strategies for denormalization
Foundational SQL for Data Interaction
- Implementing SELECT, INSERT, UPDATE, and DELETE commands
- Performing filtering, sorting, and joining operations
- Using aggregate functions and constructing subqueries
Database Security and User Governance
- Managing user roles and permission sets
- Configuring authentication and access controls
- Protecting data both during transmission and when stored
Backup, Recovery, and Routine Maintenance
- Developing effective data backup strategies
- Considering factors for disaster recovery
- Conducting regular maintenance and system monitoring
Conclusion and Future Directions
Requirements
- A solid grasp of general IT principles
- Proficiency in computer usage and navigating file systems
- Foundational knowledge of data structure and file organization
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 8000 € + 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.
