Relational Databases & Data Modelling - 2 days Online Classroom
1.450,00 EUR
- 2 days
Build a strong foundation in relational database design and data modelling with this practical two-day course. Learn how to organise and structure data using industry-standard techniques, including entity relationship diagrams (ERDs), normalisation, relational schemas, and database constraints. You'll also gain an introduction to SQL, enabling you to retrieve and update data confidently. Ideal for aspiring database professionals, developers, and business analysts, this course provides the essential knowledge needed to design scalable, reliable, and efficient relational databases.
Key Features
Language
Course and materials are in English
Level
Intermediate level
2 days (8 hours / day) live classroom
with accredited trainers
30+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Understand
Understand the core architecture of relational databases, including processing, schema, and storage layers. Learn how DBMS design influences performance, scalability, and reliability.
Shape
Learn to model many-to-many, recursive, and other complex relationships using entity relationship diagrams (ERDs) that accurately reflect business requirements.
Maintain
Explore primary, foreign, and candidate keys, along with database constraints, to maintain data integrity, consistency, and reliable relationships.
Improve
Discover how views and denormalisation improve reporting and query performance while supporting scalable and efficient database design.
Course timeline
Day 1
Lesson 01
- Understand relational database concepts, DBMS functions, and system architecture.
- Explore processing, schema, and storage layers in database systems.
- Identify entities, attributes, and relationships for data modelling.
- Create Entity Relationship Diagrams (ERDs) using industry best practices.
- Model complex relationships, including many-to-many, recursive, and inheritance structures.
- Apply database constraints and assumptions to improve model accuracy.
- Perform database normalisation through First, Second, and Third Normal Forms (1NF–3NF).
Day 2
Lesson 02
- Reinforce normalisation techniques with practical modelling exercises.
- Understand the relational model, schemas, and database terminology.
- Define candidate, primary, and foreign keys to maintain data integrity.
- Apply key and attribute constraints across relational tables.
- Implement subtype/supertype relationships and database views.
- Optimise database design using denormalisation techniques.
- Build and query relational databases using basic SQL and data updates.
Who Should Enroll in this Program?
Software developers and application developers
Database administrators and aspiring DBAs
Business and data analysts
Data architects and solution designers
IT professionals working with structured data
Anyone new to database design or preparing for SQL/MySQL training
Prerequisites
There are no formal prerequisites for this course. A basic understanding of IT concepts and computer systems is helpful but not required, making it suitable for beginners who want to learn relational databases and data modelling from the ground up.
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.