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 BIAnalytical functionsLAGLEADFIRST VALUELAST VALUECUME DISTPERCENTILE COUNTPERCENTILE DISCPERCENTILE RANKSNAPSHOT ISOLATIONREAD/WRITE/MODIFY JASON DATASTORED PROCEDURESINDEXESCOLUMNSTORE INDEXESSynapse Analytics: SQL on demandMachine Learning Enable DWData Lake integrationAzure Data ShareDQPSQL On DemandSQL On Demand CSV FilesSQL Query Json FilesAzure 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 Modern 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
