About
Austin is a Jacksonville native who graduated from The Baptist College of Florida in 2012. He previously worked as a manager in the retail service industry. He enjoys spending time with his wife and two kids. His primary focus at Pragmatic Works is on Azure Synapse Analytics and teaching the best practices for data integration, enterprise data warehousing, and big data analytics. He also enjoys helping customers learn the ins and outs of Power BI and showing people new ways to grow their business with the Power Platform.Certifications
PL-300: Power BI Data Analyst Associate
Microsoft
AZ-900: Azure Fundamentals
Microsoft
DP-900: Azure Data Fundamentals
Microsoft
AZ-305: Azure Solutions Architect Expert
Microsoft
PL-900: Power Platform Fundamentals
Microsoft
AZ-400: DevOps Engineer Expert
Microsoft
DP-600: Fabric Analytics Engineer Associate
Microsoft
AZ-104: Azure Administrator Associate
Microsoft
Course
Advanced Azure Data Factory
The Advanced Azure Data Factory (ADF) course is designed to provide a comprehensive overview of Azure Data Factory and the integration with other cloud technologies.
This course offers a comprehensive training experience focused on empowering participants with advanced skills in dynamic ETL using pipelines, Spark Data Flows, Azure DevOps integration, and security and monitoring practices within the Azure environment. This course covers the design and execution of dynamic ETL pipelines, enabling flexible data movement through parameterization and expressions. Participants will explore the transformative capabilities of Spark Data Flows for complex data transformations, while seamlessly integrating Azure Data Factory with Azure DevOps for collaborative development through version control and automated deployment workflows. The class also delves into security measures, including RBAC and data encryption, and demonstrates effective monitoring strategies using Azure Monitor and Log Analytics. By engaging in real-world use cases and best practices, participants will acquire the skills needed to architect efficient, secure, and highly monitored data integration solutions in Azure.
Course
Advanced Data Flows in Azure Synapse Analytics
ETL can be easy with Synapse. Mapping data flows are visually designed data transformations in Azure Synapse Analytics. Data flows provide an entirely visual experience with no coding required. This course goes through the principles of a data flow and then covers the different transformations that are available for users to move and transform their data. Whether you are working with JSON or building out advanced data flows with Window transformations this course is here to assist you.
Course
Delta Lake in Databricks
The "Delta Lake in Databricks" class is a comprehensive course designed to provide you with the knowledge and skills to effectively leverage Delta Lake, a powerful data management and processing solution, within the Databricks environment.
Delta Lake is an open-source storage layer that brings reliability, scalability, and performance optimizations to data lakes. In this course, you will gain a deep understanding of Delta Lake's architecture, core concepts, and best practices for managing and processing data.
By the end of the course, you will have a solid foundation in using Delta Lake to efficiently manage data in your Databricks environment. You will be equipped with the skills to optimize data pipelines, ensure data integrity, improve query performance, and facilitate collaboration among data engineers and data scientists.
Course
Introduction to Azure Data Factory
Azure Data Factory (ADF) is a cloud-based service for data integration. ADF is used to integrate disparate data sources from across your organization including data in the cloud and data that is stored on-premises. In this course, you will learn how to create data-driven pipelines to direct the movement of data.
Course
Introduction to Azure SQL Database
In the Azure SQL Database course you will learn the basics of configuring and managing a database in Microsoft’s cloud. This course will help you understand how to do common tasks like configuring database backups, implementing security and setting up highly available solutions.
Course
Introduction to the Data Lakehouse with Azure Synapse
**The data lakehouse, combines the best features of a data lake and a data warehouse. Students will learn how to build and maintain a data lakehouse using modern big data technologies such as Apache Spark, Delta Lake, and Azure Synapse Analytics. They will also explore how to integrate and query various types of data, including structured, semi-structured, and unstructured data. Additionally, the course may cover data governance, security, and privacy considerations in a data lakehouse environment. By the end of the course, students will have the knowledge and skills to design and implement a scalable and efficient data lakehouse solution that can meet the needs of modern data-driven organizations.**
Course
Learn with The Nerds - Creating a Microsoft Fabric End-To-End Solution (Recorded Live Event)
After you finish this course:
📄 [Certification](https://share.hsforms.com/117hIoz2IQ9aucdUAXsCQLw8xue?utm_source=youtube&utm_medium=organic&utm_content=certificate&utm_campaign=lwtn-creating-a-microsoft-fabric-end-to-end-solution)
Prepare to revolutionize your data universe! Are you tired of battling against disruptive data silos that sabotage your organization's natural flow? Have you grown weary of futile attempts to construct a data warehouse or lakehouse, realizing the colossal waste of time and energy? And let's not forget those individuals lost in the labyrinth, desperately seeking access to the elusive data required for their crucial reports.
Fear not, for salvation has arrived in the form of Microsoft Fabric!
Microsoft Fabric is the veritable holy grail of analytics solutions, encompassing a breathtaking array of full-service capabilities. Behold the marvel of seamless data movement, awe-inspiring data lakes, and the sheer power of data engineering, integration, science, real-time analytics, and business intelligence all in one extraordinary package.
Delve into the boundless possibilities of Power BI, Synapse, and Data Factory as you unlock the mysteries of this groundbreaking offering. Whether you're a daring data engineer, a visionary scientist, a sharp-witted analyst, or even a wordsmith weaving reports, Microsoft Fabric unveils a world of limitless potential.
Prepare to be mesmerized as we unravel the enigmatic wonders of OneLake, the crown jewel of Microsoft Fabric. Within this lake-centric architectural masterpiece, data professionals and the business elite unite, forging an unbreakable bond of collaboration on daring data projects.
Get ready to transcend the ordinary and embrace the extraordinary. Microsoft Fabric awaits, ready to propel your organization into an exhilarating new era of data-driven success!
Course
Serverless SQL in Azure Synapse Analytics
The Serverless SQL in Synapse Analytics course is designed to teach students how to use serverless SQL to query data in Azure Synapse Analytics. The course covers topics such as setting up a serverless SQL queries, creating external tables and views, and writing SQL queries to retrieve data from files in the data lake. Students will also learn how to use serverless SQL to perform ETL with data in Synapse Analytics. The course provides hands-on experience through practical exercises and labs. Upon completion of the course, students will have a solid understanding of how to use serverless SQL in Synapse Analytics to analyze and process large amounts of data efficiently and effectively.
Course
Transforming Data with SQL Pivots
The SQL Pivots class offers a comprehensive exploration of the powerful pivot operations in SQL, enabling you to transform row-based data into columnar structures. In today's data-driven world, the ability to effectively analyze and present data is crucial, and this course equips you with the skills to do just that.
The class will cover various pivot techniques, starting with simple pivots, where you'll discover how to pivot data using static column values. You'll then progress to dynamic pivots, which allow for more flexible and adaptable transformations. These techniques are particularly useful when dealing with changing data sets or when you need to automate the pivot process.
Through a series of hands-on exercises and real-world examples, you'll gain practical experience in constructing pivot queries, specifying pivot columns, defining aggregate functions, handling null values, and managing pivot table layouts. The class emphasizes a hands-on approach, ensuring that you can immediately apply your newfound knowledge in your professional or personal projects.
By the end of the SQL Pivots class, you'll have a solid foundation in pivoting and unpivoting data, enabling you to efficiently extract meaningful information from large datasets. You'll be equipped with the skills to transform data into a more structured format, facilitating better analysis and decision-making. Whether you're a data analyst, a business intelligence professional, or a database developer, this class will empower you to leverage the full potential of SQL pivots and unlock valuable insights from your data.
Course
Working with SQL Server Views
SQL Server, a robust and widely used relational database management system, offers a powerful feature known as views. SQL Server views provide a mechanism for simplifying complex queries, improving data retrieval efficiency, and enhancing overall database performance. We will explore the concept of SQL Server views, their benefits, and how they contribute to the effectiveness of database-driven applications.
SQL Server views play a pivotal role in simplifying data retrieval, improving query efficiency, and enhancing overall database performance. By abstracting complexity, offering data security, and enabling performance optimization, views empower developers and database administrators to build efficient and scalable applications. Understanding the benefits of SQL Server views and applying optimization techniques can significantly enhance the performance and responsiveness of database-driven systems. As SQL Server continues to evolve, views remain a valuable tool in managing data complexity and achieving optimal query performance.
Course
Learn With The Nerds - Data Engineering in Microsoft Fabric (Recorded Live Event)
Download your certificate of completion after you finish this course:
📄 https://prag.works/data-engineering-i...
Get ready for an in-depth exploration of Microsoft Fabric's data engineering capabilities in our upcoming Learn with the Nerds!
Dive into the world of data factory pipelines and Spark notebooks, where we'll unravel the secrets behind designing efficient data pipelines and leveraging interactive notebooks for seamless data processing.
Whether you're a seasoned data engineer or just stepping into the realm of data architecture, this will be your guide to mastering the tools that make data collection, storage, and analysis a breeze.
Course
AZ-900: Azure Fundamentals Review
Dive deep into the realm of cloud computing essentials with our comprehensive AZ-900 Microsoft Azure Fundamentals review course! Designed to equip you with the foundational knowledge required to excel in the field, our program offers a journey through the fundamental principles and concepts of Microsoft Azure. Whether you're a novice seeking to establish a solid understanding or a seasoned professional aiming to validate your expertise, our course provides a structured learning path tailored to suit various skill levels. Through a combination of expert-led instruction, hands-on exercises, and interactive challenges, you'll gain practical experience in navigating the Azure platform, exploring its key services, and understanding its core functionalities. By the end of the course, you'll be well-prepared to conquer the AZ-900 exam with confidence, earning yourself the esteemed certification in Azure Fundamentals and unlocking a world of opportunities in the ever-expanding realm of cloud computing.
Course
Delta Lake in Microsoft Fabric
Embark on a journey to proficiently manage big data using Delta Lake within the Microsoft Fabric ecosystem. Guided by data engineer Austin Libal from Pragmatic Works, this course explores how Delta Lake integrates the flexibility of data lakes with the performance of data warehouses through the innovative lakehouse architecture. You'll learn to address big data challenges—volume, velocity, variety, and veracity—by leveraging Delta Lake's features like transaction logs, ACID compliance, and time travel for accessing historical data versions.
Through practical modules, discover multiple methods to create and integrate Delta tables, dynamically evolve schemas without rewriting entire tables, and optimize data management with partitioning, vacuuming, and performance tuning techniques. Understand the nuances between "overwrite" and "append" modes for data ingestion, and how to maintain data integrity and efficiency. By course end, you'll be equipped to leverage Delta Lake in Microsoft Fabric to build robust, scalable, and efficient data engineering solutions.
Course
Introduction to Fabric Data Warehouses
In this introductory course, you will explore the foundational concepts of Fabric Data Warehouses, guided by expert instructor Austin Libal. Together, you’ll learn how these specialized data systems bring together information from different sources, allowing organizations to make more confident business decisions. Along the way, you’ll gain insight into why data warehouses are essential for dealing with large amounts of data, as well as how they help streamline analytics and reporting tasks.
By the end of the course, you’ll be equipped with a high-level understanding of the core principles behind setting up and managing a Fabric Data Warehouse. We’ll talk through how data moves in and out of these systems, the key roles and responsibilities involved, and best practices for ensuring smooth operations. Whether you’re new to data warehousing or looking for a friendly introduction, this course will give you a solid overview of the building blocks needed to excel in today’s data-driven environments.
What our clients say
Popular on-demand courses
Pragmatic Works On-Demand Learning courses offer beginner to advanced classes taught by Microsoft MVPs and authors.
.svg)
Get our special offers directly to your email
.png?width=564&height=618&name=Vector%20(2).png)
-2.png?width=380&height=384&name=Vector%20(14)-2.png)