This advanced training is designed for learners who already understand SQL fundamentals and want to develop professional-level database skills. Participants will explore advanced querying techniques, performance optimization, indexing strategies.
The course combines theoretical concepts with hands-on implementation through a real-world e-commerce database project. Students will learn how to design scalable solutions, optimize complex queries, and build production-ready database systems used in modern applications.
Module 1 — Advanced Joins
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- Multiple joins
Module 2 — GROUP BY & HAVING
- Aggregation
- GROUP BY
- HAVING
- Analytics queries
Module 3 — Subqueries
- Nested queries
- EXISTS
- IN
- Correlated subqueries
Module 4 — Indexes & Performance
- What is an index
- B-Tree Index
- GIN Index
- Query optimization
Module 5 — PostgreSQL Advanced Features
- JSONB
- ARRAY
- UUID
- ENUM
Module 6 — Views, Functions, Triggers
- VIEW
- FUNCTION
- PROCEDURE
- TRIGGER
Module 7 — Real Project
E-Commerce Database
Tables:
- users
- products
- categories
- carts
- orders
- payments
- reviews
Features:
- Product filtering
- Order system
- Payment tracking
- Reports
- Admin analytics
Practical Exercises
- Real-world SQL challenges
- Coding interview problems
- End-to-end project implementation
TRAINING DETAILS
Training format: hybrid
Training duration: 16 hours / 8 days / 2 per lesson
Training fee: 85.000 AMD (for the entire course)
.jpeg)
