DP-602T00 Implement a Data Warehouse with Microsoft Fabric

Topic 1 Introduction to end-to-end analytics using Microsoft Fabric

• Explore end-to-end analytics with Microsoft Fabric
• Data teams and Microsoft Fabric
• Enable and use Microsoft Fabric

Topic 2 Get started with data warehouses in Microsoft Fabric

• Understand data warehouse fundamentals
• Understand data warehouses in Fabric
• Query and transform data
• Prepare data for analysis and reporting
• Secure and monitor your data warehouse
• Analyze data in a data warehouse

Topic 3 Load data into a Microsoft Fabric data warehouse

• Explore data load strategies
• Use data pipelines to load a warehouse
• Load data using T-SQL
• Load and transform data with Dataflow Gen2
• Load data into a warehouse in Microsoft Fabric

Topic 4 Query a data warehouse in Microsoft Fabric

• Use the SQL query editor
• Explore the visual query editor
• Use client tools to query a warehouse
• Query a data warehouse in Microsoft Fabric

Topic 5 Monitor a Microsoft Fabric data warehouse

• Monitor capacity metrics
• Monitor current activity
• Monitor queries
• Monitor a data warehouse in Microsoft Fabric

Topic 6 Secure a Microsoft Fabric data warehouse

• Explore dynamic data masking
• Implement row-level security
• Implement column-level security
• Configure SQL granular permissions using T-SQL
• Secure a warehouse in Microsoft Fabric

Promotion Code

Your will get 10% discount voucher for 2nd course onwards if you write us a Google review.

Minimum Entry Requirement

Knowledge and Skills

• Able to operate using computer functions
• Minimum 3 GCE ‘O’ Levels Passes including English or WPL Level 5 (Average of Reading, Listening, Speaking & Writing Scores)

Attitude

• Positive Learning Attitude
• Enthusiastic Learner

Experience

• Minimum of 1 year of working experience.

Target Age Group: 18-65 years old

Minimum Software/Hardware Requirement

Software:

TBD

Hardware: Window or Mac Laptops

• Data Engineer
• Microsoft Fabric Developer
• Big Data Engineer
• Cloud Data Architect
• Data Analytics Consultant
• Apache Spark Developer
• Data Solutions Architect
• Machine Learning Engineer
• Business Intelligence Developer
• Microsoft Fabric Administrator
• Database Administrator
• Delta Lake Engineer
• ETL Developer
• Data Science Engineer
• Cloud Solutions Engineer
• Real-Time Data Engineer
• Data Platform Specialist
• Data Pipeline Developer
• Microsoft 365 Data Engineer
• Data Governance Specialist

Ken Hiong: Ken Hiong is a ACTA certified trainer. Ken has over 20 years of work experience in the healthcare and pharmaceutical industry, having assumed various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning. With an interest and experience in scripting, Ken has worked on projects using HTML, CSS, PHP, MySQL, WordPress, MS Office, VBA, Power BI, etc. Notably, Ken is a proven expert Excel user at work who has made efficient many work processes, improved data analysis and enhanced the quality of business planning and reporting for organizations.

Ken graduated with a Pharmacy degree, holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide. An ardent advocate of lifelong learning, Ken is ACTA trained and seeks to continually upgrade his IT skills through various channels of learning and Microsoft certifications. With MS Office Master qualification, Ken looks forward to assisting individuals and corporations improve their computer skills, productivity and business outcomes.

Dr. Alvin Ang: Dr. Alvin Ang is a ACTA certified trainer. Dr. Alvin Ang did his Ph.D., Masters and Bachelors from NTU, Singapore. Previously he was a Principal Consultant (Data Science) as well as an Assistant Professor. He was also 8 years SUSS adjunct lecturer. His focus and interest is in the area of real world data science. Though an operational researcher by study, his passion for practical applications outweigh his academic background. He owns a startup externally.

Mohamed Afiq: Mohamed Afiq is a ACTA certifed trainer. Mohamed Afiq startup CTO for 3 years building proprietary delivery system from scratch and then managing a team of 20 developers. He builted multiple web apps using MEAN or similar stacks. He is also a founder and sole developer for PlayTours: https://playtours.app/ . He leads instructor at CodeNinja, teaching coding to kids 9-16 years old and teach adults front-end and back-end for web development.