Azure Synapse Analytics: Introduction [Introduction to Azure Synapse Analytics Series - Ep. 1]

This is the first video in a series of videos that will be released each Tuesday explaining and walking through the different aspects of Azure Synapse Analytics. Mitchell will explain the purpose of ASA and the different services contained within. This includes Azure Data Lake, Serverless SQL Pools, Dedicated Pools, Apache Spark and Notebooks, Pipelines and Data Flows and Power BI Integration!

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: [phone]
#PragmaticWorks #MitchellPearson #Azure #AzureSynapse

-~-~~-~~~-~~-~-
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
-~-~~-~~~-~~-~-

[data]

Pragmatic Works always coming through. Great, timely playlist; thanks.

[JoscelinTrouwborst]

Hats off!
A couple of weeks ago I have started to watch videos on Synapse. By now I was expecting it can be used as you put forward. The Microsoft Synapse team can learn from you.

[mabenba]

Great Video. I can't wait for the next episode!
Thanks for sharing your wisdom.

[ksathish]

This was a very nice start for me, thank you so much.

[tbzkwxe]

Great video, just the knowledge I wish for and need.

[bedsup]

Well Done. Very well explained and easy to understand

[MariusHanrieder]

Thank you, Mitchell.
I really appreciate your videos and presentation skills. I will leave the same comment and a like under each of your Azure Synapse videos. These videos are all you need to get started with Azure Synapse!
Regards from Germany,
Marius

[ammarahmed]

Couldn't be better then this. Big ups.

[shafa]

Nice vedio. Looking forward for watching the whole if you are going to do a series.

[samanthapikus]

Hi there. Just want to say, I love your videos and the way you engage with and come across to your audience. You explain things so well. You spoke of Optimising Data warehousing and Materialised views. How do I learn Data Warehousing Techniques without being in a situation that allows me to do this? How do I gain the experience to do these things? or is it not worth learning how to do this because of the changing landscape? I did a degree in IT at 43. Essentially, I have always had analytical roles but predominately on the front end like Power BI and Excel. I would love to be a full stack BI Developer or a Data Engineer. Guidance Needed.

[sudhavishnu]

Hi sir. I am new to azure. Can i directly learn synapse analytics or should i start with something else? Please reply sir

[TheyCalledMeT]

if the sizing of the DWH is kind of modest (<200GB) pretty much all data sources are SQL Databases and Power BI is out of the picture (for political reasons.)
Is there a case for using ASA with a serverless SQL Pool instead of a dedicated ASQL Pool in combination with ADF?

the higher price of ASA compared to a basic ASQL Pool with ADF as ETL tool, makes me question wether it's worth it .. or not.

[musthakhahammed]

Great video sir,
Waiting for the next video.
I have a question.
I'm new to Azure. Do I need to learn about ADF before I start with Synapse?
I'm also wondering, Do I need to learn SSIS anymore?

[sonsangsom]

Nice, do you have a release schedule for this?

[nasarazam]

Can I use Synapse ETL part to move data from on prem SQL to Cloud, and on prem to on prem SQL (basically replacing SSIS).?

[nasarazam]

If I am not interested in Data warehousing part, and just interested in the ETL part, should I be learning ADF or ASA? What I learn in ADF, can that be applied to the ASA ETL part?
I have a subscription to Pragmatics works through my company "Feeding America"... FYI