Microsoft Fabric: Administration, T-SQL, and Data Analytics

Microsoft Fabric    |    Intermediate
  • 18 videos | 2h 19m 10s
  • Includes Assessment
  • Earns a Badge
Effective Microsoft Fabric administration enables organizations to manage resources, streamline workflows, and maintain secure, collaborative environments for data operations. By leveraging T-SQL and advanced analytics, businesses can optimize data quality, uncover actionable insights, and drive informed decision-making. In this course, learn the fundamentals of Fabric administration, including managing workspace roles and permissions, configuring admin portal options, and exploring Fabric capacities for resource allocation. Next, learn about Git integration in Fabric, Power BI file formats, and compare standard SQL and T-SQL. Finally, explore supported and unsupported T-SQL constructs in Fabric warehouses, useful T-SQL constructs, data profiling techniques, and descriptive, diagnostic, predictive, and prescriptive analytics. This course is part of a series that prepares learners for Exam DP-600: Implementing Analytics Solutions Using Microsoft Fabric.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    List the important categories of settings for workspace administration
    Identify what permissions each workspace role has
    Recognize what operations can be performed on the admin portal
    Describe the characteristics of microsoft fabric capacities
    Outline how to integrate fabric workspaces with git for version control
    Identify how to deploy fabric items using deployment pipelines
    Recognize how to choose the right power bi file format for different use cases
    Outline the features of transact-sql (t-sql) for querying databases
  • Differentiate between the features of standard sql and t-sql
    List the t-sql supported operations
    Differentiate between t-sql support in fabric lakehouses and warehouses
    Recognize the t-sql operations that are not supported in warehouses
    Identify useful sql constructs for different use cases
    List the steps for data profiling
    Recognize how to choose the right kind of analysis to answer your questions
    Describe the characteristics and use cases of predictive and prescriptive analysis
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 1m 44s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 6m 19s
    After completing this video, you will be able to list the important categories of settings for workspace administration. FREE ACCESS
  • Locked
    3.  Fabric Workspace Roles and Permissions
    10m 28s
    Upon completion of this video, you will be able to identify what permissions each workspace role has. FREE ACCESS
  • Locked
    4.  The Admin Portal and Tenant Settings
    7m 28s
    Through this video, you will be able to recognize what operations can be performed on the admin portal. FREE ACCESS
  • Locked
    5.  Microsoft Fabric Capacities
    8m 20s
    In this video, we will describe the characteristics of Microsoft Fabric capacities. FREE ACCESS
  • Locked
    6.  Git Integration in Fabric
    11m 54s
    After completing this video, you will be able to outline how to integrate Fabric workspaces with Git for version control. FREE ACCESS
  • Locked
    7.  Deployment Pipelines for Fabric Workspaces
    10m 12s
    Upon completion of this video, you will be able to identify how to deploy Fabric items using deployment pipelines. FREE ACCESS
  • Locked
    8.  Power BI File Formats
    13m 18s
    Through this video, you will be able to recognize how to choose the right Power BI file format for different use cases. FREE ACCESS
  • Locked
    9.  Transact-SQL (T-SQL)
    6m 27s
    After completing this video, you will be able to outline the features of Transact-SQL (T-SQL) for querying databases. FREE ACCESS
  • Locked
    10.  Standard SQL vs. T-SQL
    7m 59s
    In this video, we will differentiate between the features of standard SQL and T-SQL. FREE ACCESS
  • Locked
    11.  Supported Operations in T-SQL
    7m 26s
    Upon completion of this video, you will be able to list the T-SQL supported operations. FREE ACCESS
  • Locked
    12.  T-SQL in Fabric Lakehouses and Warehouses
    10m 36s
    After completing this video, you will be able to differentiate between T-SQL support in Fabric lakehouses and warehouses. FREE ACCESS
  • Locked
    13.  Unsupported T-SQL Constructs in Fabric Warehouses
    3m 45s
    Through this video, you will be able to recognize the T-SQL operations that are not supported in warehouses. FREE ACCESS
  • Locked
    14.  Useful T-SQL Constructs
    11m 16s
    In this video, we will identify useful SQL constructs for different use cases. FREE ACCESS
  • Locked
    15.  Data Profiling
    4m 56s
    After completing this video, you will be able to list the steps for data profiling. FREE ACCESS
  • Locked
    16.  Descriptive and Diagnostic Analytics
    9m 27s
    Through this video, you will be able to recognize how to choose the right kind of analysis to answer your questions. FREE ACCESS
  • Locked
    17.  Predictive and Prescriptive Analytics
    5m 23s
    Upon completion of this video, you will be able to describe the characteristics and use cases of predictive and prescriptive analysis. FREE ACCESS
  • Locked
    18.  Course Summary
    2m 11s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Course Microsoft Fabric: Advanced DAX Queries and Tools to Manage Semantic Models
Rating 4.5 of 2 users Rating 4.5 of 2 users (2)
Book Mastering Microsoft Fabric: SAASification of Analytics
Course Managing Modern Desktops: Managing & Monitoring Devices
Rating 4.5 of 23 users Rating 4.5 of 23 users (23)