3 thousand subscribers
157 videos
34. Find And Replace Values | Power Query Editor
21. Transact-SQL IN OPERATOR | IN and NOT IN Operator SQL Server | T-SQL Demo
35. Handle Null Values with PySpark
32. Structtype & StructField | Schema Definition in PySpark
34. NOT NULL Constraint in SQL Server | Specify Not Null Constraint
32. DROP DATABASE Statement | How to Delete A Database in SQL SERVER | T-SQL Demo
01. What is PySpark ? | Introduction to PySpark | Why we use PySpark ? | Overview
09. SHOW in PySpark | Display Dataframe as Table | Show() Function
23. Calculate The Sum Of A Column | Power Query Editor | Calculate Sum
09. SELECT DISTINCT STATEMENT | QUERY DISTINCT / UNIQUE VALUES IN T-SQL | SQL SERVER
24. Transact-SQL GROUP BY STATEMENT | Using GROUP BY in SQL Server | T-SQL Demo
39. Join Tables / Merge Queries | Joins in Power Query Editor
07. Read Parquet Files to Dataframe Using PySpark | Databricks Demo
13. Microsoft Fabric Lakehouse | Convert Files to Delta Table | Using Notebooks | Append / Overwrite
2. Upload CSV File Directly Into Microsoft Fabric Lakehouse | From Local System
19. Change Column Datatype in Dataframe | Using PySpark
15. Create Your First KQL QUERYSET in Microsoft Fabric | Kusto Query Language
17. Transact-SQL SUM() Function | How to Calculate SUM in T-SQL | SQL SERVER DEMO
07. Remove Rows using Power Query Editor | Remove Top Rows | Bottom Rows
27. SQL Server SELECT INTO Statement | How to Create A New Table From An Existing Table | T-SQL Demo
3. Upload TSV File Directly Into Microsoft Fabric Lakehouse | From Local System
18. Modify Existing Column Values in Dataframe | PySpark
42. Count Distinct Values In Column | PySpark countDistinct
How to Install Adventure Works on SQL Server | SQL Server Management Studio | Sample DB | Windows PC
01 Introduction to T-SQL | T SQL Tutorial (Free Course) | TSQL For Beginners | SQL Server
37. Extract Range of Characters From Column | Power Query Editor
24. How To Use SQL In Databricks | Spark SQL | PySpark
37. Time Functions in PySpark | Current_Timestamp() | To_Timestamp() | Hour() | Minute() | Second()
6. Create Your First Pipeline in Microsoft Fabric
14. OneLake Shortcuts in Microsoft Fabric | How To Create Shortcuts on Tables in Lakehouse ...
16. Transact-SQL AVG() Function | Find Average of Data in T-SQL Table | SQL Server Demo
43. Array From Column In Dataframe | PySpark | collect_list() | collect_set()
50. Get First and Last Values From a Column | PySpark | first() | last()
44. Get Maximum and Maximum Value From Column | PySpark Max Min
Stock Data Type in Excel: A Step-by-Step Guide
How to Plot Indian Pincodes in Power BI
Track Mutual Fund and ETF Prices in Google Sheets | 20 Seconds | Easy Method
Web Scraping in Microsoft Fabric | End to End Project
How to Install Adventure Works Database on Mac M1 & M2 | SQL Server, Docker and Azure Data Studio
9. Create Your First Power BI Dataset with Microsoft Fabric
02 How to Ingest Data into Azure Data Explorer | ADLS Blob | CSV | JSON | Excel etc...
02 Types of TSQL Statements | TSQL Tutorial (Free Course) | TSQL For Beginners | SQL Server
Stock Trading Transaction Logs into a Dynamic Portfolio & Dashboard | Microsoft Excel
20. Derive Columns Based on Existing Columns | Using PySpark
Must Have iPad Apps for Data Science and Data Analysts
12. Upload Local Files to KQL Database | Microsoft Fabric | CSV | JSON | Parquet
15. Transact-SQL COUNT() FUNCTION | Using the COUNT Function in T-SQL | SQL SERVER DEMO
11. Create KQL Database in Microsoft Fabric | Real-Time Analytics in Fabric Tutorial |
03. Upload Files Directly Into The Databricks File Store or DBFS | CSV | PARQUET | JSON | DELTA etc.
8. How to Create DATAFLOW GEN 2 | Microsoft Fabric | Data Factory
22. Drop Columns In A Dataframe | Using PySpark