Important Note: Please note that this is NOT a full course but Two module of the full-length course, and intended to cover very basic fundamental concepts for Azure Synapse Analytics. This module is NOT GOOD for you if: You are already experienced in this technologyYou are looking for an intermediate or advance conceptsYou are looking for practical examples or demoThis module is GOOD for you if: You want to understand the basic fundamental concepts of hot technology Azure Synapse AnalyticsThis is a free module to help others. If you are not in the intended audience, I request you to please feel free to unenroll. Where I can find a full-length course?Please look at the bonus lecture in the end. What will students learn in this course?What is Synapse AnalyticsAzure Synapse Integrity With Azure EcosystemAzure Synapse Advantage and LimitationsModern Data warehouse ArchitectureHow to Create Azure Synapse WorkspaceCreate SQL Pool Azure Synapse WorkspaceAzure Synapse Analytics StudioSynapse Studio Activity Hub DetailsSynapse Studio Data HubDevelop Hub- Power BI[Note]: This is the free version of this course. In case if you are interested to learn below synapse topics further, you can look at my profile for the full version of this course. Analytical functionsLAGLEADFIRST VALUELAST VALUECUME DISTPERCENTILE COUNTPERCENTILE DISCPERCENTILE RANKSNAPSHOT ISOLATIONREAD/WRITE/MODIFY JASON DATASTORED PROCEDURESINDEXESCOLUMNSTORE INDEXESPerformance TuningTABLE DISTRIBUTIONTABLE PARTITIONSMATERIALIZED VIEWCOPY COMMANDSRESULT SET CACHINGRESOURCE CLASSESDYNAMIC MANAGEMENT VIEWSAZURE DATA SHAREDQPSQL ON DEMAND QUERY JSON VALUE Azure Synapse Analytics -Architecture overview in SparkSynapse Job serviceSynapse Spark Instance workflowCreating Spark PoolJDBC and PolybaseCreate Notebook on files storageLibrary Management-PythonLevelBeginnersIntended AudienceData EngineersBig data DeveloperData ScientistSolution ArchitectDatabase DeveloperSQL DeveloperAzure Cloud EngineerLanguageEnglishIf you are not comfortable in English, please do not take a course, captions are not good enough to understand the course. Expected OutcomesIn this courseYou will learn Azure synapse Analytics basic feature advantage and limitation You will learn Mordern data warehouse architecture You will learn how to create the Syanpse workspace You will learn how to use SQL Pool in azure SynapseYou will learn how to use Synapse StudioYou will learn how to use Synapse Activity HubYou will learn how to use Synapse Data HubPrerequisitesBasic Database conceptsAzure Free trial SubscriptionCourse In DetailAzure Synapse Analytics Beginner guide Full moduleYou will learn the Azure synapse basic details and Synapse Studio detailsHow use Synapse studio Activity HubHow to use Synapse Studio Data HubHow can use Synapse data hub for Storage accountSynapse Developer hub benefitsHow to use developer Hub notebookHow to use Developer hub Dataflow Tunning the Develop Hub -Data Flows Optimize Synapse Studio Monitor HubHow to use Manage Linked Service How to is use Manage Integration RuntimeHow to use Manage Access controlHow to use Manage Integration Run timeData MovementSql Analytics Functions LAGLEADFIRST VALUELAST VALUECUME DISTPERCENTILE COUNTPERCENTILE DISCPERCENTILE RANKSNAPSHOT ISOLATIONREAD/WRITE/MODIFY JASON DATASTORED PROCEDURESINDEXESCOLUMNSTORE INDEXESSynapse Job serviceSynapse Spark Instance workflowCreating Spark PoolJDBC and PolybaseCreate Notebook on files storageLibrary Management-Python[Tags]Microsoft SQL Server, Azure SQL Server, Azure SQL Data Warehouse, Data Factory, Data Lake, Azure Storage, Azure Synapse Analytics Service, PolyBase, Azure monitoring, Azure Security, Data Warehouse, SSISAre there any course requirements or prerequisites?Basic Database conceptsAzure Free trial SubscriptionWho this course is for: Beginners in Azure PlatformData EngineersData ScientistDatabase and BI developersDatabase AdministratorsData Analyst or similar profiles
