Introduction to the Azure Data Lake and U-SQL

Abandon ETL with the Azure Data Lake, using U-SQL to query raw data files and create databases.

Building good reporting structures can be difficult, especially when those pesky users keep asking for new reports. Throw Big Data into the mix and things become a lot more complicated. What if you didn’t need to build any data models at all, or you could build models that could be quickly put up and torn down? In this course, Introduction to the Azure Data Lake and U-SQL, you'll be introduced to Azure Data Lake and the U-SQL language, and learn how to abandon ETL. First, you'll delve into querying by using the powerful U-SQL language, built straight into the Azure Data Lake. Next, you'll discover how to throw your files into the Data Lake and query them directly without needing to load them into a database. Finally, you'll learn about how Azure Data Lakes offers the best of both worlds, with support for unstructured files and structured databases. By the end of this course, you’ll not only know what a Data Lake is, you’ll know how to populate it, query it, and develop for it using Visual Studio. Software required: Visual Studio 2017 Community Edition and Azure subscription (optional).

• Course Overview 1min
• Abandoning ETL with an Azure Data Lake and U-SQL 30mins
• Tool Time – Saving Money with Visual Studio 26mins
• Cutting Development Timescales 40mins
• Building Dams - Structuring the Data Lake 35mins
• Converting and Manipulating Data 36mins