Transact-SQL is a powerful declarative language that lets you explore and manipulate your database. As the complexity of your programs increase, so does the risk of errors occurring.

In this learning path, the student is exposed to various ways to:

Row-level security (RLS) allows you to create a single or a set of reports that targets data for a specific user. In this module, you'll learn how to implement RLS by using either a static or dynamic method and how Microsoft Power BI simplifies testing RLS in Power BI Desktop and Power BI service.

Learn how to construct transactions to control the behavior of multiple Transact-SQL statements. You'll learn how to determine whether an error has occurred, and when to roll back statements.

Charts allow any audience to understand a topic and quickly make decisions. This course will teach you how to use chart elements to your advantage while creating visualizations based on various types of data.

This course offers a deep dive into addressing dataset incompleteness. From basic drop methods to intricate regression imputations, emerge equipped to tackle any missing data challenge with confidence.

This course shows how R’s capabilities can help you retrieve data from relational databases and make it available to R for adding value with other operations, such as analysis and visualization.

In this course, you’ll learn how to use Pandas index objects for advanced data analysis. You'll learn how to create and use numerical, interval, period, categorical, date-time, time-delta, and multi-indexing in Pandas to retrieve and manipulate data.

Data ingestion is crucial in analytics. Microsoft Fabric's Data Factory offers Dataflows for visually creating multi-step data ingestion and transformation using Power Query Online.

Explore how Microsoft Fabric enables you to ingest and orchestrate data from various sources (such as files, databases, or web services) through dataflows, notebooks, and pipelines.

Discover how to use Apache Spark and Python for data ingestion into a Microsoft Fabric lakehouse. Fabric notebooks provide a scalable and systematic solution.

Master insurance risk assessment using the Monte Carlo method with Spark. Learn how to simulate risk scenarios and use big data processing to make more accurate predictions and improve decision-making in the insurance sector.