Duration 1 Days 6 CPD hours This course is intended for The primary audience for this course is data professionals who are familiar with data modeling, extraction, and analytics. It is designed for professionals who are interested in gaining knowledge about Lakehouse architecture, the Microsoft Fabric platform, and how to enable end-to-end analytics using these technologies. Job role: Data Analyst, Data Engineer, Data Scientist Overview Describe end-to-end analytics in Microsoft Fabric Describe core features and capabilities of lakehouses in Microsoft Fabric Create a lakehouse Ingest data into files and tables in a lakehouse Query lakehouse tables with SQL Configure Spark in a Microsoft Fabric workspace Identify suitable scenarios for Spark notebooks and Spark jobs Use Spark dataframes to analyze and transform data Use Spark SQL to query data in tables and views Visualize data in a Spark notebook Understand Delta Lake and delta tables in Microsoft Fabric Create and manage delta tables using Spark Use Spark to query and transform data in delta tables Use delta tables with Spark structured streaming Describe Dataflow (Gen2) capabilities in Microsoft Fabric Create Dataflow (Gen2) solutions to ingest and transform data Include a Dataflow (Gen2) in a pipeline This course is designed to build your foundational skills in data engineering on Microsoft Fabric, focusing on the Lakehouse concept. This course will explore the powerful capabilities of Apache Spark for distributed data processing and the essential techniques for efficient data management, versioning, and reliability by working with Delta Lake tables. This course will also explore data ingestion and orchestration using Dataflows Gen2 and Data Factory pipelines. This course includes a combination of lectures and hands-on exercises that will prepare you to work with lakehouses in Microsoft Fabric. 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 Knowledge Check Get started with lakehouses in Microsoft Fabric Explore the Microsoft Fabric Lakehouse Work with Microsoft Fabric Lakehouses Exercise - Create and ingest data with a Microsoft Fabric Lakehouse Use Apache Spark in Microsoft Fabric Prepare to use Apache Spark Run Spark code Work with data in a Spark dataframe Work with data using Spark SQL Visualize data in a Spark notebook Exercise - Analyze data with Apache Spark Work with Delta Lake Tables in Microsoft Fabric Understand Delta Lake Create delta tables Work with delta tables in Spark Use delta tables with streaming data Exercise - Use delta tables in Apache Spark Ingest Data with DataFlows Gen2 in Microsoft Fabric Understand Dataflows (Gen2) in Microsoft Fabric Explore Dataflows (Gen2) in Microsoft Fabric Integrate Dataflows (Gen2) and Pipelines in Microsoft Fabric Exercise - Create and use a Dataflow (Gen2) in Microsoft Fabric
This comprehensive, hands-on course empowers beginners with essential web development skills. From HTML, CSS, and JavaScript to GitHub and Bootstrap, master the tools of the trade. Learn to build, style, and deploy websites effortlessly. No prior knowledge of programming or web development is needed.
Legionella Responsible Person is suitable for any persons wanting to gain an understanding of Legionella and how to prevent or control the risk of exposure to Legionella bacteria.
Become a browser automation master with Selenium WebDriver, JavaScript, and Node.js
Learning and applying new techniques can often be a daunting experience. This course helps you out with 100+ tips and tricks on Stata with each video designed to be stand-alone and taking no more than 2 minutes. If you want to learn more about Stata but don't have a lot of time, this is the course for you!
Empower your school with inclusive practices for SEND. This course covers understanding SEND, the Code of Practice, safeguarding, and creating an accessible learning environment, ensuring every child’s needs are met. Ideal for educators and administrators in both domestic and international schools.
Learn Python OOP language used diversely in applications like data science, game/web development, machine learning, and AI. This course provides all you need to master OOPs like classes, objects, data abstraction, methods, overloading, and inheritance. The course primarily aims to help you tackle complex programming and use OOP paradigms efficiently.
This course will help you become familiar with the process of building web applications in Python. From understanding Python fundamentals, to studying the database structure to building, and deploying applications, you will learn it all with the help of interesting activities
Building a parser is one of the early steps of designing a compiler. And to build a parser, it is important to learn about the different parsing techniques and how they work. In this course, we are going to learn just that.
Access Introduction generally navigate through Access Database, get data fast, update data records by entering, update data and delete data. Run available report, use available forms, create simple forms and reports via wizards. This style tuition helps to maximise the value that you get from the day.