DP-900 Azure Data Fundamentals Exam Prep

Topic 1 Explore Core Data Concepts

• Data formats
• File storage
• Transactional data processing
• Analytical data processing
• Data roles and services
• Job roles in the world of data
• Data services

Topic 2 Explore Relational Data in Azure

• Overview of relational data
• Normalization
• Explore SQL
• Describe database objects
• Explore relational database services in Azure
• Azure SQL services and capabilities
• Azure services for open-source databases

Topic 3 Explore Non-Relational Data in Azure

• Azure blob storage
• Azure DataLake Storage Gen2
• Azure Files
• Azure Tables
• Azure Cosmos DB

Topic 4 Explore Data Analytics in Azure

• Large-scale data warehousing
• Data ingestion pipelines5 min
• Analytical data stores8 min
• Fundamentals of real-time analytics
• Batch and stream processing
• Common elements of stream processing architecture
• Azure Stream Analytics
• Apache Spark on Microsoft Azure
• Overview of Data visualization
• Power BI tools and workflow
• Overview of data modeling

Practice Exam

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 on Azure
• Azure Database Administrator
• Data Scientist (using Azure tools)
• Business Intelligence Developer on Azure
• Azure Data Solutions Architect
• Data Analytics Specialist on Azure
• Database Developer (migrating to Azure)
• Big Data Specialist on Azure
• Machine Learning Engineer (utilizing Azure data services)
• Data Warehouse Architect on Azure
• IT Professionals (seeking data specialization on Azure)
• Cloud Data Consultant
• ETL Developer on Azure
• Azure Data Lake Specialist
• Data Migration Specialist on Azure.

Peter Cheong :  I am a ACLP certied trainer. Specialise In IT related knowlege and conduct IT Training which Include Microsoft Window Server Technology (Wintel) and Linux - Centos/Red Hat. Comptia ,ITIL , Motorola Solution Trunking System and Cisco Networking. I was worked in Motorola Solutions Conduct Motorola Astro 25 Trunking System For Police Force Malaysia (RMPnet),Taiwan Navy, Indonesia METRO POLDA (Police Force). After that I Join As IT Group Manager For W-Group which include 17 subsidiaries Companies in Real Estate Developer,Plantation, Building Management Services ,Contruction and also Fiber Opti Service Provider in Sabah,Malaysia.

Truman Ng: I am a ACLP certified trainer. With In-depth and diversified experiences from Project Management DevOps, Blockchain, Project Management, Education, IT and even Numerology, I am passionate to meet good people and generate new ideas, in pursuit of realization of better world!

Agus Salim : I am a professional with more than 10 years of experience in Project Management, IT Solutions Management, and Systems Integration both in waterfall and agile methodology. He started out his career as a Web Developer before moving on to Business Analyst/Project Manager. He has strong leadership and the capability of leading a team with a proven ability to deliver projects with tight timelines. Besides his experiences in managing projects, he has good knowledge in Cybersecurity and hands-on experience in Next Generation Firewall such as Check Point. During his free time, he likes to explore Cloud Technology, especially on Microsoft Azure.

Sanjiv Venkatram: Sanjiv i is an ACTA certified experienced leader with a proven track record in business / finance consulting and in developing i) business intelligence (BI) solutions ii) data analytics/analysis solutions and iii) IOT lead BI solutions. Sanjiv's goal through Prudentia Consulting, is to promote the simple joy and excitement of actively using the Microsoft Platform. He believes that the agility afforded by the Microsoft platform helps businesses get time back for deeper business thinking and to spend more time with their end customers

Sanjiv has rich experiences in diverse/complex high-tech businesses, turn around environments and strategic transformations. His functional expertise is in sales analytics, financial planning and analysis, engineering and program management. He has worked across discrete manufacturing, professional services and higher education verticals. He also has a working knowledge of equities portfolio management within the financial services domain.Sanjiv is the CEO of Prudentia Consulting, an organization committed to promoting the active usage of the Microsoft Platform. Prior to this, he has worked at Microsoft (US & APAC: 9.2 years), Cognizant Tech Solutions (3.3 years), Yazaki North America (8 years) and until recently at Oracle. Here are a few of his BI/analytics projects driven at scale: Built APAC wide BI dashboard using the Power BI umbrella tool set (Power BI online, Power BI desktop and Power Pivot) and a KPI lake (SQL DB), Helped develop key KPIs – identified key KPIs and helped land this in the DB, Developed a budget audit tool that captured budget inputs from a host of countries across the globe, Developed a business unit P&L reporting tool (functional architecture) in Business Objects for the world-wide financial planning and analysis team.