Database Management Systems Courses

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.

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.

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.

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.

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.

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.

Key Skills You'll Learn

• Understand core database integration using SQL server integration services (SSIS) principles and how they fit together in practice.
• Apply practical techniques for error handling & logging in day-to-day implementation.

Key Skills You'll Learn

• Prepare budgets and forecasts for data engineering, database and ERP operations.
• Calculate total cost of ownership across on-premises, hybrid and cloud options.

Key Skills You'll Learn

• Explain how relational databases store and relate data using tables, keys and constraints.
• Design a normalised database and document it with an entity relationship diagram.

Key Skills You'll Learn

• Translate governance and privacy requirements into enforceable technical controls.
• Classify data and design role-based and attribute-based access models.

Key Skills You'll Learn

• Evaluate data platform architectures and recommend direction that fits business needs and budget.
• Specify reliability targets, service levels and monitoring for pipelines and databases.

Key Skills You'll Learn

• Evaluate data architecture options across databases, warehouses, lakes and cloud services.
• Interpret data models and write basic SQL to examine data quality and performance.