arrow_back
Synapse Study Material
AZURE SYNAPSE ANALYTICS Material Download & Unzip
SYNOPSYS Material
Synapse Videos Sessions
SESSION-1 Synapse Introduction diff bw ADF ADB and synapse
SESSION-2 Modern DWH and its problems
SESSION-3 Components of Azure Synapse Analytics(1)
SESSION-4 Creating Synapse workspace
SESSION-5 Creating and working with synapse workspace
SESSION-6 Serverless Sql pool Introduction
SESSION-7 Serverless SQL Pool Architecture DQP
SESSION-8 How to query in synapse TSQL Queries
SESSION-9 Querying Data in serverless SQL Pool
SESSION-10 Querying and fixing collation warning
SESSION-11 Creating database to solve potential concersion Error
SESSION-12 Creating External Datasource
SESSION-13 Creating New External Datasource
SESSION-14 Creating End point at location of datasource
SESSION-15 Creating Database Scope Credential
SESSION-16 Managed Identity
SESSION-17 MAnaged Identity contd
SESSION-18 Creating External File Format
SESSION-19 Creating External File Format part2
SESSION-20 Create External table as select CETAS
SESSION-21 CREATE External Table part2
SESSION-22 External Table part-2 and Data Processing before Spark
SESSION-23 Pyspark features
SESSION-24 Creating Apache Spark Pool and Pyspark Transformation
SESSION-25 Creating Apache Spark pool and markdowns
SESSION-26 pyspark Resource Distribution
SESSION-27 Databricks Community Edition
SESSION-28 Pyspark Transformations
SESSION-29 Pyspark Select and selectExpr
SESSION-30 Pyspark Select Expr
SESSION-31 Pysparl filtering operations
SESSION-32 Organizing Notebooks to a folder
SESSION-33 Handling Nulls and missing values
Session-34 Handling NULLs and missing values part2
SESSION-35 Replacing NULLS
SESSION-36 Data Transformation and Manipulation
SESSION-37 withColumn inserting and updating
SESSION-38 Data Transformation and Manipulation
SESSION-39 Generating updating renamingcolumns and MSsparkutils
SESSION-40 MSSparkUtils Envutils
SESSION-41 File System Utilities and Mounting Storage
SESSION-42 Mounting storage and FSutils
SESSION-43 FSutils and Notebookutils
SESSION-44 Requesting to increase Vcore quota
SESSION-45 MSspark Notebook utility
SESSION-46 MSSparkutils Notebook utility part2
SESSION-47 Attaching a spark pool to 2 notebooks and magic commands
SESSION-48 Creating mount point and accessing mountpoint from other notebookON 6-05-2025
SESSION-49 mounting process
SESSION-50 Mount point and SQL Temp Views
SESSION-51 Creating and Rading SQL Temp Views and Lake DAtabase
SESSION-52 LAke Database and creating manged tables and spark sql
SESSION-53 spark sql Manged Tables VS External tables
SESSION-54 Creating managed Tables
SESSION-55 Creating External tables
SESSION-56 Integration Between spark pool and serverless sql pool
SESSION-57 Join Operations(1)
SESSION-58 Union Tand Join Transformations and string manipulation functions
SESSION-59 spark String manipulations and string functions
SESSION-60 String manipulations and string functions part2
SESSION-61 Window Functions
SESSION-62 Window functions part2 ON 24-05-2025
SESSION-63 Pivoting and unpivoting
SESSION-64 Pivoting and unpivoting
SESSION-65 todate and schema definition and schema mangement
SESSION-66 Schema management and schema Definition and UDFs Introduction
SESSION-67 Creating UDF methods and annotations
SESSION-68 Dedicated Sql pool Introduction
SESSION-69 Architecture of Dedicated SQL Pool
SESSION-70 Creating Dedicated Sql pool
SESSION-71 Diff ways to copy data to Dedicated sql pool
SESSION-72 Cluster column store index and various Sharding patterns
SESSION-73 Pipeline to copy Data to Dedicated Sql Pool
SESSION-74 Copying data to Dedicated sql pool using Bulk copy
SESSION -75 Pyspark Stages and Tasks
SESSION-76 Pyspark Optimization Techniques
SESSION-77 Spark Optimizations Techniques
SESSION-78 Various optitmization techniques part3
SESSION-79 Spark Optimization technique-Avoid collect
SESSION-80 Avoid Inferschema
SESSION-81 Serialization and Se-serialization Introduction
SESSION-82 using cache and persist
SESSION-83 With and without cache and persist
SESSION-84 Diff persist options