Course Outline
Introduction to Databases
- What is a database?
- Types of databases: relational, hierarchical, NoSQL
- When and why to use databases
Database Management Systems (DBMS)
- Overview of DBMS architecture
- Popular systems (SQL Server, MySQL, PostgreSQL, Oracle)
- Responsibilities of a DBMS
Data Modeling and Design
- Entities, attributes, and relationships
- Entity-Relationship (ER) diagrams
- From models to tables
Relational Model and Normalization
- Tables, rows, and columns
- Primary and foreign keys
- 1NF, 2NF, 3NF and denormalization
Basic SQL for Data Access
- SELECT, INSERT, UPDATE, DELETE
- Filtering, sorting, and joins
- Aggregate functions and subqueries
Database Security and User Management
- User roles and permissions
- Authentication and access control
- Securing data in transit and at rest
Backup, Recovery, and Maintenance Basics
- Data backup strategies
- Disaster recovery considerations
- Routine maintenance and monitoring
Summary and Next Steps
Requirements
- An understanding of general IT concepts
- Experience with using computers and navigating file systems
- Basic knowledge of data and file organization
Audience
- IT systems support personnel
- Database administrators
- Developers or analysts transitioning into data-related roles
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)
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
I found his methods very informative
