During this comprehensive 12-week program, the participants have learnt to extract data out of various systems, such as databases, files, online- and streaming sources. In addition, they have gained knowledge on how to clean, correct and transform data with SQL, Python and DAX. The participants were taught to design and create an operational database and a modern data warehouse, and they have gotten an understanding on how to load data into on-prem and cloud database. There was emphasis on learning data visualization and how to analyze with both Power BI and Python. Additionally, they gained insights into Machine Leaning models. Working with streaming data and SPARK technologies were part of the program. The participants have gained the required knowledge and skills needed to start their career in data engineering-related projects.
Program Content
Data profiling SQL Language SQL Analytical queries SQL Server ETL processing Data Transformation and Correction Operational (OLTP) Database modeling |
Data Warehouse modeling Database implementation Snowflake Python in data engineering Azure data services PySpark and streaming data Synapse Analytics, Data Factory and Databricks |
AW Academy
At AW Academy, we believe that learning is a process that occurs when the individual interacts with others, to embrace and implement knowledge, skills, and competence. Consequently, we place great emphasis on identifying and developing the individual’s capacity for learning. Besides learning new subjects’ areas, individuals at AW Academy get to practice our pedagogical methods which lay a great foundation for their skill in learn-to-learn.