Azure Synapse | Azure Synapse Analytics [Full Course] ☁️
308,347
Published 2021-10-07
In this Learn with the Nerds event, Mitchell Pearson will teach you how you can use Synapse Analytics to solve the paradox of analytics with a unified analytical platform where your data analysts, data engineers and data scientists can all perform essential tasks in the same workspace. Mitchell will discuss Dedicated and Serverless SQL Pools, integration with Azure Data Lake, performing ETL with pipelines and data flows, Synapse notebooks and finally the built-in Power BI integration capabilities! So come and join Mitchell as you explore the many features which make Synapse Analytics the industry-leading analytics platform.
What You'll Learn:
✔️ SQL Pools
✔️ Integration with Azure Data Lake
✔️ Perform ETL with pipelines and data flows
✔️ Synapse notebooks
✔️ Built-in Power BI integration capabilities
After you finish this course:
📄 If you have completed this class and would like a certificate, fill out this form - share.hsforms.com/1Pb8VndxSTd65rciS9OROtw8xue
👉 Download The Nerd's Guide to Azure Synapse for FREE!
tinyurl.com/ytpbkye6
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: prag.works/lwtn-trial
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-training/hackathons/
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-mentoring/
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-training/customized-ent…
🔗Pragmatic Works Blog: blog.pragmaticworks.com/
Let's connect:
✔️Twitter: twitter.com/PragmaticWorks
✔️Facebook: www.facebook.com/pragmaticworks/
✔️Instagram: www.instagram.com/pragmatic.works
✔️LinkedIn: www.linkedin.com/company/pragmaticworks
✔️YouTube: youtube.com/pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: [email protected]
#PragmaticWorks #MitchellPearson #Training #Microsoft #Azure #AzureSynapse #Cloud #LearnWithTheNerds
**Any sale mentioned in the video are no longer valid. Offers are subject to change with/without notice and are for a limited time only.
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Component Library - B...
~-~~
All Comments (21)
-
30 minutes into the course and I am already happy with this presentation. Thank you
-
This is absolutely gem of a session and helps to bring a lot of clarity about ASA, huge thanks for sharing it! 🙌
-
2:03:33 I had the same issue, but instead of enabling All IP's in Synapse, I went to the SQL Database and under the "Set server firewall" option made sure "Allow Azure services and resources to access this server" was set to true. I'm sure you already knew this, but I also know in the midst of a live demo we are all quick to do what comes to mind first. ;)
-
Gifted , humble and generous giver. thanks !
-
Amazing learning material for a data engineer / scientist. Highly recommended
-
Great stuff, thank you! One question, how can we do real time sync with external table with application operational data using event handlers like azure function or web hooks. I want to push real time data from my daily operational data stores to external tables
-
What a great course - thank you, it was very instructive and covered a lot of ASA topics !
-
WoW! This video is heavily enriched with information. It took me 3 days to finish it up! :)
-
The complete restructure of Data Lake using only one line of code was crazy!
-
Huge thanks for this explaination it really helped me to understand ASA concept with ADF.
-
Brilliant workshop 👍 live debugging made it even more useful 👏
-
Brilliant tutorial, comprehensive and well explained thanks you!
-
This was great, thank you so much Mitchell Pearson and Matt!
-
Mitch is an amazing instructor!
-
Very concise presentation. Quick question - when yoiiu use spark on synapse, what is the metastore that spark uses to create tables?
-
I'm new to azure. I find the video very helpful. I have a doubt regarding my project. I want to do analysis on streaming data using py-spark, pandas (as for using sql we use stream analytics). HD insight is one of the options but it costs per cluster. Is it possible to achieve it by either using databricks or synapse analytics?
-
Great Video. Do companies also use Synapse serverless pool for datawarehousing? with external tables and stuff or could you rather use an sql database or dedicated pool. I work mostly with small companies that have max 1,5 TB data and use mostly not unstructured data. And how about incremental loads. I see in every example you did, it's a full load. Can you also do incremental loads to .parquet files for example? if so how? if you have the time i'd love to hear your story.
-
Thank you so much for this video. This was very helpful for me to get an understanding of how to use ASA.
-
Love your camera smile at the Very beginning 😚
-
Wonderful session, thanks for putting this together and presenting it so nicely!