Databases: SQL Server & MongoDB
Designed for beginners and developers looking to consolidate their database design and querying skills. Deeply covers relational databases (Microsoft SQL Server / T-SQL) as well as document-oriented NoSQL stores (MongoDB).
(VAT included)
Total track tuition: €1400 (VAT included)
Pay in 4 monthly installments of €350 (or €1,300 upfront payment)
Prices for individual enrollments include VAT. Corporate billing applies VAT according to current tax regulations.
Detailed Module Breakdown
Each module combines core engineering theory with practical hands-on exercises drawn directly from enterprise production codebases.
Module 1: Database Fundamentals & Relational Data Modeling
- Relational database management systems (RDBMS) architecture and concepts
- Entity-Relationship Diagrams (ERD) and conceptual database design
- Database normalization (1NF, 2NF, 3NF) and referential integrity constraints
Module 2: Complex Querying with T-SQL
- DDL (CREATE, ALTER, DROP) and DML (SELECT, INSERT, UPDATE, DELETE) commands
- JOIN operations in depth: INNER, LEFT, RIGHT, and FULL OUTER joins
- Aggregate functions, GROUP BY, and HAVING filtering clauses
- Subqueries, correlated subqueries, and Common Table Expressions (CTEs)
Module 3: Advanced SQL Server Programmability
- Stored Procedures and User-Defined Functions (UDF) for business logic
- Database triggers and event-driven automation
- Transaction control (BEGIN TRANSACTION, COMMIT, ROLLBACK) and ACID properties
Module 4: Performance Tuning & Indexing Strategies
- Index architectures: Clustered vs Non-Clustered and covering indexes
- Analyzing execution plans to diagnose query bottlenecks
- Identifying deadlocks, resolving concurrency issues, and optimizing large tables
Module 5: NoSQL Document Databases with MongoDB
- Architectural differences between relational SQL and NoSQL document models
- Installation, collection setup, BSON documents, and core query syntax
- Advanced CRUD operations, array manipulations, and projection operators
Module 6: NoSQL Aggregations & Practical Integration
- MongoDB aggregation pipeline ($match, $group, $lookup, $project, $unwind)
- Indexing and query performance tuning in large document collections
- Capstone integration project: data export, migration pipelines, and automated reporting
Looking to deliver this curriculum internally for your technical team?
We can customize every module directly on your company's codebase or assign an independent senior trainer per diem (€600 – €1,500 / day).
What You Need to Know Before Starting
The syllabus is calibrated to ensure progressive, hands-on mastery:
- Basic computer literacy
- Analytical mindset and attention to detail
- B1 English proficiency
Everything Included in Your Enrollment
End-to-end learning, practitioner mentoring, and career placement support:
- Direct applicability to Junior Database Developer or Data Analyst roles
- Portfolio with complex SQL scripts and functional NoSQL models
- Deep understanding of performance optimization and indexing techniques
- Technical preparation for database interview assessments
Reserve your seat in the next cohort of Databases: SQL Server & MongoDB
Cohorts are strictly limited to 12 participants to ensure 1-on-1 mentor guidance and line-by-line code review.