Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Explore the SQL database capabilities within Microsoft Fabric in this comprehensive 22-minute technical video. Learn about OneLake's foundational role in Microsoft Fabric and how it integrates with various data services, including Purview and AI capabilities. Discover the necessity for transactional SQL databases within the Fabric ecosystem and understand how SQL databases function specifically in this environment. Follow along with a practical demonstration of creating and using a SQL database in Fabric, including working with both SQL and analytics endpoints. Gain insights into Copilot integration for enhanced productivity, understand the pricing model for SQL databases in Fabric, and receive guidance on selecting the appropriate SQL database solution for your specific needs. The video covers external data integration capabilities and provides a decision framework for choosing between different SQL database options within the Microsoft ecosystem.
Syllabus
00:00 - Introduction
00:18 - Joy of OneLake
01:06 - Fabric use of OneLake
03:27 - Integration with Purview and AI
04:01 - External data integration
05:15 - Need for transactional SQ databases
06:30 - SQL in Microsoft Fabric
11:28 - Creating a SQL DB in Fabric
14:07 - Using the SQL DB
16:22 - Using the SQL and analytics endpoints
17:33 - Copilot help
17:41 - Pricing
18:50 - How to pick the right SQL database
21:15 - Summary
21:49 - Close
Taught by
John Savill's Technical Training