Databases for Software Developers
Earn an internationally recognized certificate and master the design and use of modern databases. This micro-credential will teach you SQL, MongoDB, and how to create effective data models for real-world applications.
Register now!
Secure your place in this unique course
This micro-credential focuses on database design and management in software development. Participants will learn to design data models for both relational and non-relational databases, understand their differences and advantages, use SQL to query relational databases, and work with the document-oriented database MongoDB. The course covers both theoretical fundamentals (relational model, normalization) and practical skills (schema creation, advanced queries, indexing, transactions).
29. 9. - 21. 12. 2026
Full-time, 5x4hForm12 490 Kč incl. VATPriceJankovcova 49/1037, Praha 7Adress
29. 9. - 21. 12. 2026
Online, 5x4hForm12 490 Kč incl. VATPriceMS TeamsAdress
About course
Do you want to gain practical skills in databases and data handling for developing modern applications? This microcertificate will guide you through the key principles of designing, managing, and using both relational and non-relational databases. You’ll learn to work with both SQL and NoSQL approaches, understand their differences, and learn when to use each in practice.
Throughout the course, you will master data model design, data normalization and denormalization, database schema creation, and advanced querying techniques. The course also covers working with document databases, particularly MongoDB, including CRUD operations, aggregations, indexing, and designing efficient data structures.
The emphasis is on the practical application of knowledge—through exercises and projects, you will practice designing and implementing database solutions for real-world applications. The course also introduces modern approaches to combining different types of databases and working with data in contemporary software systems.
Upon completing the micro-certificate, you will be able to independently design database solutions, work effectively with data, and select appropriate technologies based on specific use cases.
6 ECTSTotal ECTS creditsAdvancedLevelCZLanguage
Course content and schedule
Block 1
Module 1: Introduction to Databases and Data Models
- Types of databases (relational, document, graph, network, vector, etc.)
- SQL vs. NoSQL: When to Use Which?
- Introduction to Data Model Design (ER diagrams, application requirements)
Block 2
Module 2: The Relational Model and Normalization
- Fundamentals of the relational model: tables, primary/foreign keys, integrity
- Normalization: 1NF, 2NF, 3NF – principles and examples
- Denormalization – when it is appropriate
Module 3: SQL: basic data handling
- SELECT, INSERT, UPDATE, DELETE
- WHERE, JOIN (INNER, LEFT, RIGHT, FULL), GROUP BY, HAVING
- Subqueries and Aggregations (COUNT, SUM, AVG…)
Module 4: SQL: schematic design and advanced techniques
- Creating tables, data types, constraints
- Indexes – types, uses, and impact on performance
- Transactions – the ACID principle, COMMIT, ROLLBACK, isolation
- Views, stored procedures, triggers
Module 5: Practical Exercise: Design and Implementation of a Relational Database
- Modeling a specific application (e.g., an e-shop, a reservation system)
- Implementation in PostgreSQL / MySQL / SQLite
- Query optimization, index tuning
Block 3
Module 6: Introduction to NoSQL and MongoDB
- The Concept of Document-Oriented Databases
- Document Structure (JSON/BSON)
- Data Modeling in MongoDB – Embedded vs. Referenced
Module 7: Working with MongoDB – Basic Operations
- Inserting, reading, updating, and deleting documents (CRUD)
- Querying using Mongo Query Language (MQL)
- Searching, sorting, and paginating results
Module 8: Advanced MongoDB Usage
- Aggregation Pipeline
- Indexes – types and behavior, compound indexes, TTL indexes
- Transactions in MongoDB – multiple documents, multiple collections
- Data validation using schema rules (JSON Schema)
Module 9: Practical Exercise: Designing and Implementing a MongoDB Model
- Modeling non-standard data structures (e.g., chat logs, real-time data)
- Implementation, query optimization, and working with aggregates
Block 4
Module 10: Comparison of Approaches and Hybrid Architecture
- Choosing the Right Database Type Based on Use Cases
- Combining SQL and NoSQL in a Single Application
- Data Migration Between SQL and NoSQL
- Introduction to ORM (e.g., Mongoose, Sequelize)
“Databases for Software Developers”At the end of the course you will receive a MICROCERTIFICATE
Vstupní požadavky
For a smooth course experience, the following technical requirements must be met:
At least a high school education
Personal Laptop or Tablet
Bring the device you normally use for work, and don’t forget your charger.
Basic knowledge of programming in any language (e.g., JavaScript, Python, Java)
Basic proficiency with the command line and a text editor/IDE
Basic understanding of data structures (arrays, objects, JSON) is a plus, but not required
Who is this course for?
Intermediate developers who want to expand their knowledge of database systems and learn how to design data models that meet the real-world needs of applications.
Front-end or back-end developersFront-end and back-end developers who want to expand their knowledge of databases and understand how to work with the data layer when developing applications.
Technical Analysts and Data SpecialistsData professionals who need to better understand data structures, query processing, and the differences between relational and non-relational databases.
DevOps and System AdministratorsProfessionals who work with databases and want to gain a better understanding of their design, administration, and operation.
Graduates of introductory programming coursesIndividuals interested in further specialization who wish to develop their skills in database design and data handling.
Methods of teaching
This course combines theoretical fundamentals with practical demonstrations and exercises to give participants a comprehensive overview of database design and management in modern applications.
- Interactive lectures with demonstrations (SQL, PostgreSQL, MySQL, MongoDB).
- Hands-on workshops: designing data models, working with queries, and implementing database solutions.
- Independent exercises and case studies focused on real-world scenarios.
- A final project and an exam assessing the ability to design and work with database solutions.
What You Will Gain from the Course
You will understand the differences between SQL and NoSQL databases and their practical applications.
Ability to design data modelsYou'll learn how to create effective prompts for consistent and useful results.
Optimizing Performance and Data SecurityYou will learn how to use indexes and transactions to work with data efficiently and securely.
Overview of Database ArchitecturesYou will gain an understanding of approaches that combine different types of databases within a single application.
Who Will Teach You?
Bc. Josef Drašnar
An instructor with experience since 1991 in the design and development of database applications and information systems. He has been with Unicorn since 2001, where he has held various positions in the banking sector, the automotive industry, and systems for retail chains. In addition to his extensive experience with databases on various platforms, he also teaches databases at Unicorn University, for which he has contributed to the creation of teaching materials focused on database issues.
