ETL Developer
- Level 1 – ETL Developer & Data WarehouseWhat is ETL ?7m 46sETL Developer Overview4m 18sData Pipeline Design Patterns17m 44sWhat is a Data Warehouse9m 37sDatabase vs Data Warehouse vs Data Lake8m 10sData Warehouse Architecture16m 26sSchema Model7m 29sNormalization Data12m 44sData Mapping4m 46sHow To Build Data WarehouseData Warehouse TestingSQL Basic3m 19sEvaluation Test ETL Level 1Feedback
- Level 2 – Basic SQL & ETL Using TalendSQL In PostgresData Testing & QualityDatabase Tuning & Partitioning Strategy20m 55sTalend Overview35m 53sTalend Architecture6m 37sETL Using Talend50m 9sTalend DB Connection & Import From FileTalend String, Null & Date HandlingTalend Data ValidationBuild First ETL Job Using TalendTalend Deployment and Scheduling ETL Job21m 57sEvaluation Test Level 2 – SQL ChallangeEvaluation Test Level 2 – Dwh & ETL Tools TestFeedback
- Level 3 – Advance SQL & ETL Using PandasAdvanced SQL – Using SQL String Functions to Clean DataAdvanced SQL – SQL Performance TuningAdvanced SQL – Pivoting Data In SQLAdvanced SQL – Nested and Repeated DataAdvanced SQL – Common Table ExpressionsAdvanced SQL – Windowing FunctionPython Pandas – Overview16m 20sPython Pandas – Installation VS Code, Python & Pandas21m 49sPython Pandas – Series11m 7sPython Pandas – Dataframes9m 3sPython Pandas – Panel5m 4sPython Pandas – Descriptive Statistics6m 35sPython Pandas – Common TechniquePython Pandas – Sql Analytical Function In Pandas20m 13sPython Pandas – Process Huge Data Sets in Pandas10m 4sETL Using Pandas – SQL Server to PostgreSQL10m 41sETL Using Pandas – CSV File to Oracle13m 40sETL Using Pandas – CSV To SQL Server26m 39sEvaluation Test Level 3 – Advance SQL ChallengesEvaluation Test Level 3 – Pandas ChallengesFeedback
- Level 4 – ETL In Big DataBig Data – What is BigData ?4m 35sBig Data – Big Data in Real World11m 29sBig Data – Big Data Engineering ToolsHadoop Overview6m 21sHadoop Installation15m 59sApache Hive Overview3m 42sApache Hive Installation & Operation38m 3sApache Spark Overview12m 41sApache Spark Architecture, Pipeline & Machine Learning14m 3sApache Spark Installation8m 3sJupyter Notebook15m 36sApache Spark Using Python (PySpark)1h 49m 2sApache Spark SQL & DataFrame Basics17m 13sETL Using PySpark I8m 32sETL Using PySpark IIEvaluation Test Level 4
- Level 5 – Hybrid ETL Platform (On Premise & Cloud)What is cloud platform?7m 55sOn Premise VS Cloud Computing – Pros and Cons Comparison3m 41smoving on premise to cloud based0sSetting up a simple ETL pipeline using Google Cloud Function0sETL Processing on Google Cloud Using Dataflow and BigQuery0sImplementing ETL on GCP0sETL Cloud Tools With Use Cases – Overview, Factors and Benefits0sWhat is hybrid cloud? Strategy and benefits guide6m 36sWhat is hybrid cloud storage?0sHybrid vs On-Premise3m 41sQuiz Level 5 – ETL
- Feedback
This course is needed for those of you who want to improve your ETL Developer skills.
