In this course, you will learnWhat is data warehousing?A basic introduction to data warehousingHistory and evolution of data warehousingHistory of data warehousing from the 1970s to dateLimitation of traditional data warehouseWhat is the limitation of the traditional data warehouse?Modernization of data warehouseHow modern technological advances helped to define the modern data warehousesTerminologies and Concepts Part IWhat is OLTP and OLAP?What is ETL and ELT?What is Micro-Batch and Change Data Capture (CDC)?What is Star and Snowflakes Schema?Introduction to Azure SynapseIntroduction to Azure SynapseKey features and benefits of Azure SynapseAzure Synapse Analytics (Putting in altogether)Structure of Azure Synapse DemoA demo of Azure SynapseUse cases of Azure SynapseIntroduction to Synapse Analytics StudioWhat are the activity hubs of Synapse Studio?Introduction to Overview HubDemo of Overview HubIntroduction to Data HubDemo of Data HubIntroduction to Develop HubDemo of Develop HubIntroduction to Orchestrate HubDemo of Orchestrate HubIntroduction to Manage HubDemo of Manage HubIntroduction to Monitoring HubDemo of Monitoring HubAzure Synapse SQL AnalyticsIntroduction to Azure Synapse SQL ArchitectureAzure Synapse SQL Architecture (SQL Pool) and Data Warehouse UnitsWhat is HTAP (Hybrid transactional/analytical processing)?Azure Synapse Link
