Data Management and Processing in Microsoft Fabric

An outline of this training course

This course encompasses navigating OneLake for data upload and management, securing data through authentication and authorization, leveraging shortcuts for workflow efficiency, and understanding lakehouse versus warehouse architectures. It deeply explores Apache Spark's role in data engineering, offering practical experience with notebooks in web and VS Code environments, and concludes with techniques for monitoring Spark jobs. This concise curriculum is tailored to equip learners with essential skills for effective data management and analysis within the Microsoft Fabric ecosystem.

What are needed to take this course 

Participants should understand cloud computing and data management basics, have programming skills in languages like Python or SQL, and access to Microsoft Fabric. Familiarity with Apache Spark, Visual Studio Code, a reliable computer with internet, and analytical skills will also enhance your learning experience.

Who is this course for

Designed for data engineers, data scientists, IT professionals, developers interested in data analytics, and educators or students in data-focused fields, aiming to enhance their expertise in cloud-based data management and analysis with Microsoft Fabric.

Details of what you will learn during this course

During this Microsoft Fabric course, participants will learn:

1. Navigating OneLake: Understand how to upload, manage, and organize data within OneLake, Microsoft Fabric's data lake solution, including using OneLake Explorer for file management.

2. Data Security: Master the concepts of authentication and authorization to secure data within the Microsoft Fabric environment, ensuring that sensitive information is protected and access is controlled.

3. Workflow Optimization: Discover how to use shortcuts within Microsoft Fabric to streamline data workflows, making data processing tasks more efficient and less time-consuming.

4. Lakehouse vs. Warehouse Architecture: Gain insights into the differences between lakehouse and warehouse architectures in data management, learning how each can be leveraged for different types of data storage and analysis needs.

5. Apache Spark Fundamentals: Dive deep into the essentials of Apache Spark for data engineering within Microsoft Fabric, understanding its role in processing large datasets for analytics purposes.

6. Notebook Usage: Get hands-on experience with notebooks in both web-based and Visual Studio Code environments, learning how to execute code, analyze data, and visualize results interactively.

7. Monitoring Spark Jobs: Learn techniques for monitoring and optimizing Spark jobs to ensure efficient processing of data tasks, including using the monitoring hub and Spark UI for performance insights.

What you get with the course

This course will provide participants with detailed Microsoft Fabric materials, hands-on exercises, expert insights on Spark jobs, and interactive notebook sessions. Participants will earn a completion certificate and join a community for support and networking, equipping them with practical skills and knowledge in data management and analysis.

Program Level

Intermediate

Field(s) of Study

Data Engineering, Cloud Computing, Data Analytics

Instruction Delivery Method

QAS Self-study

***This course was published in March 2024***

Enterprise DNA is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org