Enterprise Data Architect

About The Program

A 4-month program that explores the comprehensive discipline of enterprise-scale data infrastructure design, focusing on the strategic planning, governance, and optimization of critical database systems. It builds a robust foundation with essential SQL for data definition and manipulation, then establishes core principles for security, resilience, and high performance within the SQL Server ecosystem.

The curriculum culminates with advanced data warehouse architecture, teaching you to design scalable analytical platforms that support business intelligence and decision-making. Overall, this program equips you with the holistic expertise to design, secure, and manage the reliable, high-performance data backbones that underpin modern enterprises.

What Will You Learn

How to utilize SQL for core data operations, including schema design (DDL), complex querying (DML), and managing database objects.
How to architect and implement data protection strategies using Transparent Data Encryption (TDE), data masking, and Always Encrypted.
How to diagnose performance bottlenecks using execution plans, monitoring tools, and dynamic management views (DMVs).
How to design and implement SQL Server Audit for compliance tracking and security monitoring at both server and database levels.

How to design and implement a comprehensive security model using logins, users, roles, permissions, and the principle of least privilege.
How to plan, configure, and execute enterprise-grade backup strategies and disaster recovery solutions to ensure business continuity.
How to optimize database performance through strategic indexing, query rewriting, parameter tuning, and managing concurrency.
How to design dimensional models and data warehouse architectures, including star/snowflake schemas and slowly changing dimensions (SCDs).