Data Lake First Versus Data Warehouse First StrategyData Lake First StrategyData Warehouse First StrategyDeciding On a StrategyDefining Your Data ModelDatabase Schemas, Users, and GroupsStar Schema, Denormalized, NormalizedStudent Information Learning Transactional DatasetCreate Data Models for Student Information
Learning Transactional DatasetIngest Data for the Student Learning Transaction DatasetStudent Information Learning Analytics DatasetCreate Data Models for Student Information
Learning Analytics DatasetLoad Batch Data into Amazon RedshiftUsing the COPY CommandIngest Data for the Student Learning Analytics DatasetBuilding a Star SchemaContinuous File Ingestion from Amazon S3Using AWS Glue for TransformationsManual Loading Using SQL CommandsUsing the Query Editor V2Load Real-Time and Near Real-Time DataNear Real-Time Replication Using AWS Database Migration ServiceAmazon Aurora Zero-ETL Integration with Amazon RedshiftUsing Amazon AppFlowStreaming IngestionOptimize Your Data StructuresAutomatic Table Optimization and AutonomicsDistribution StyleSort KeyCompression EncodingSummary