Database Design for Relational Databases - eLearning
450,00 EUR
- 20 hours
Take your database skills to the next level with this comprehensive Design & Architecture of Relational Database Training. In today’s data‑driven world, designing efficient and scalable relational databases is a core skill for software engineers, data professionals, and architects. This course teaches you how to think like a database designer — from core principles to real‑world implementation. You’ll understand how to plan, model, and implement database systems that are efficient, maintainable, and aligned with industry best practices. Relational database skills form the backbone of many tech stacks used in enterprises around the world.
Key features
Language
Course and materials in English
Level
Beginner to intermediate level
Access
1 year access to the learning platform
15+ hours of video material
with 20+ hours recommended study time
10 Auto-Graded Assessments
and 26 Guided Hands-On Exercises
37 Recall Quizzes
and 3 Assignments
Certification
Certificate of completion of the program included
Learning outcomes
By the end of this course, you will be able to:
Plan
Plan, analyze, and design an effective software development lifecycle
Components
Understand the key components of a database architecture
Integrity
Learn how important data integrity is and which strategies help maintain it
Discover
Examine data redundancy and dependencies and how to manage them
OLTP
Gain insights into online transaction processing systems (OLTP)
Course schedule
Introduction to Relational Databases
Lesson 01
- Module introduction
- Introduction to Databases
- Hierarchical and network database management systems
- NoSQL-DBMS
- Object-oriented and relational database systems
- DBMS vs. RDBMS
- Open-source vs. licensed databases
- Popular relational databases – Oracle
- Popular relational databases – Microsoft SQL
- Popular relational databases – MySQL
- Popular relational databases – PostgreSQL
- Introduction to the Software Development Life Cycle (SDLC)
- Planning, analysis, design, development, testing and integration
- Maintenance and production support
Architecture of relational databases
Lesson 02
- Database architecture and layers
- Layers of database architecture
- Database Architecture: Tiers vs. Layers
- Components of the database architecture
- Centralized and distributed database systems
Important aspects of relational databases
Lesson 03
- SQL sublanguages
- Example of an SQL library
- SQL standardization
- Data integrity
- Principles of data integrity
- How data integrity can be compromised
- Meaning of data integrity
- Improving data integrity
- Transaction
- ACID compliance
- BASE model
Database structure and design
Lesson 04
- Database objects
- Rules and restrictions for data integrity
- entity relationship
Database design
Lesson 05
- Database design
- What is database normalization
- data redundancy
- Data dependencies
- Rules for Data Normalization
- First Normal Form (1NF)
- Second normal form (2NF)
- Third Normal Form (3NF)
- Boyce–Codd normal form (BCNF)
- ER diagram
- Entity
- Attribute
- ER Diagram: Notations and Relationships
- Data model
- Phases of the data model
- Conceptual data model
- Logical data model
- Physical data model
- data modeling tools
Data modeling methods
Lesson 06
- Data modeling methods
- What is online transaction processing (OLTP)?
- Examples of OLTP
- Characteristics of OLTP
- Challenges of OLTP
- OLTP data model example
- Introduction to Data Warehousing
- Data warehouse functions
- Phases of the data warehouse
- Data Warehouse vs. OLTP Database
- What is a data mart?
- Data Mart Example
- Fact and dimension tables
- Star and snowflake schema
- Top-down design approach for data warehouses
- Bottom-up approach to data warehouse design
- What is a Data Vault?
- Data Vault example
- Use of Data Vault
- Data Lake
- Differences between databases, data lakes and data warehouses
SQL components
Lesson 07
- data definition language
- data manipulation language
- data query language
- Handling NULL
- Aggregate data with GROUP BY
- Filtering aggregated data with the HAVING clause
- Data Control Language
Transactions and Concurrency
Lesson 08
- Transactions and Concurrency: An Introduction
- Database transactions
- COMMIT and ROLLBACK
- SAVE POINT
- Problems with transaction concurrency
- Transaction isolation levels
- Deadlock
Database joins and performance tuning
Lesson 09
- SQL-Joins
- Subquery and its types
- Optimization of database performance
- Database monitoring
- information schema
Database backup, recovery and security
Lesson 10
- Database backup, recovery, and security
- Database backups
- Logical backup
- Physical security
- Types of backups
- Restore and Recover
- Database security
- Database Security – Best Practices
On-prem vs. cloud databases
Lesson 11
- Local versus cloud databases
- Local and cloud databases
- Deployment models for cloud databases
- Differences between local and cloud databases
Who is this program suitable for?
Requirements
- Basic knowledge of SQL and database concepts is recommended.
- Prior knowledge of SQL enhances the learning experience.
- This course is designed to accommodate learners with varying levels of prior knowledge in SQL.
Prospective database specialists
Software developers & engineers
Data Engineers & Data Analysts
IT Architects & System Designers
Statements
Licensing and accreditation
This course is offered in accordance with the partner program agreement and complies with the requirements of the license agreement.
gender equality policy
Applicants are encouraged to contact the AVC for advice and support throughout the entire adjustment process.
Frequently Asked Questions
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!