Database Management Systems Training in Kampala, Uganda

Key Skills You'll Learn

• Understand core advanced SQL querying principles and how they fit together in practice.
• Apply practical techniques for design and structuring in day-to-day implementation.
• Strengthen evaluation, reporting and quality-assurance capability.

Key Skills You'll Learn

• Design normalised relational schemas and document them with entity relationship diagrams.
• Write SQL queries using joins, subqueries, aggregation, window functions and views.
• Tune queries with indexes, execution plans and sound transaction handling.

Key Skills You'll Learn

• Design normalised relational schemas and dimensional models for reporting.
• Write efficient SQL using joins, window functions and common table expressions.
• Tune queries with indexes, execution plans and sensible partitioning.

Key Skills You'll Learn

• Understand core data modeling and database design principles and how they fit together in practice.
• Apply practical techniques for entity and data modeling in day-to-day implementation.
• Strengthen evaluation, reporting and quality-assurance capability.

Key Skills You'll Learn

• Understand core database administration using MS SQL server principles and how they fit together in practice.
• Apply practical techniques for strategy and integration in day-to-day implementation.
• Strengthen evaluation, reporting and quality-assurance capability.

Key Skills You'll Learn

• Understand core database architect principles and how they fit together in practice.
• Apply practical techniques for OLTP vs. OLAP processing in day-to-day implementation.
• Strengthen evaluation, reporting and quality-assurance capability.