This repository contains reference links to contents on my youtube channel where I create contents on data analytics.
SQL Interview Question | Concat Email ID Associated With Each Dept ID | SQL Practice Questions
Tricky SQL Interview Question | Data Analyst| Data Engineer| Data Scientist| Min-Max Group Sequence
Solving SQL Interview Question with MULTIPLE Solutions | SQL Interview | 3 Solutions Explained
Data Analyst SQL Interview Question | Amazon | Google | SQL Interview Question
Generate a Sequence of Continuous Dates Using SQL | Perfect Calendar in SQL
SQL Interview Question | Symmetric Data Pairs | Data Analyst Interview Question
Data Analyst SQL Interview Question | Meta Interview Question | StrataScratch
SQL Interview Question| Find Max Customer Id Who Placed Only One Order| Data Analyst SQL Interview
SQL Interview Question | Find Percentage of Shippable Orders | Data Analyst Interview Question
Tricky SQL Interview Question | New Products Launched | Data Analyst Interview Question
SQL Functions | ALTER TABLE Statement in SQL | Modify Tables
Tricky SQL Interview Question | Calculate Average User Session Time | Data Analyst Interview
Change Column Data Types to Appropriate Data Types | SQL - Better Data Management
SQL Interview Question | Monthly Percentage Revenue Difference
Extract Date Parts Without Using Date Functions in SQL
Complex SQL Interview Question | Find Start date and End date of Project | Project Planning
Complex SQL Interview Question | Coding Challenges | SQL Analytical Functions
Top 10 Advanced SQL Interview Questions | Frequently Asked Questions | Explained in Detail
Most Commonly Asked SQL Interview Question | Frequently Asked Question | SQL
Master SQL with These 3 Engaging Games | Fun Practice to Boost Your SQL Skills
Number of Shipments per Year-Month | Using CONVERT
How to Write Better SQL | 5 Tips for Better SQL Queries
Number of times each word appear in draft | CROSS APPLY Function
How to retrieve distinct records not using DISTINCT keyword
Find the popularity percentage for each user on Meta/Facebook
SQL Interview Question | Bikes Last Used
Calculate percentage spam post among viewed post
Top 10 SQL Interview Questions | Intermediate to Advanced
Ranking Most Active Guests | Stratascratch | Airbnb Interview Question
Add a column only if it does not already exist | Data Error Handling
Query Data Type of all Columns in a Table
Create a Match Schedule | Each team play with every other team Once & Twice
Top 10 Commonly Asked SQL Interview Questions
Combine Multi-Row Data into Single Row
Recommend pages for a person based on the pages liked by his friends
Ungroup Data in SQL | Recursive CTE
WITH Clause in SQL | Common Table Expression
Find Friend Request Acceptance Rate by Date?
3 Methods to Delete Duplicate Data using SQL
Group Sold Products By The Date
UNPIVOT data in SQL | Convert data from Column into Row | UNPIVOT Function
SQL Interview Questions | LeetCode Interview Questions | FAANG Interview Questions | Part - 3
Complex SQL Interview Question | Find Customers Who Bought All Products
Tricky SQL JOINS Interview Question | JOINS and UNION Explained | Predict the output?
SQL Interview Questions | LeetCode Interview Questions | FAANG Interview Questions | Part - 2
Dealing with SQL Divide by Zero Error || 2 Methods to Avoid Divide by Zero Error
Tricky SQL Interview Question | Preprocess Incorrect Input Table and Solve Query| Important Question
SQL RANK Functions in Detail | Window Functions | Important SQL Interview Question|SQL Analytics
Converting a String to Date in SQL | CAST | CONVERT | TRY_CAST |TRY_CONVERT|SQL
Select Common Records from Tables Without using JOINS | SQL Interview Question | SQL
Tricky SQL Interview Question | Pivot Column Values Under a Header Sorted Alphabetically | SQL
Clustered and Non-Clustered Index in SQL | Improve Query Performance with Index | SQL INDEX
CASE Statement for Conditional Logic in SQL | Assign Customer Tier Based on Order Count | CASE WHEN
SQL Interview Questions | SQL Practice Queries | Part - 2
SQL | Comparing DELETE, DROP and TRUNCATE Statement in SQL|Confusing Interview Question
SQL Interview Questions | SQL Practice Queries | Part - 1
Restore and Backup Database in SQL Server Database | SQL Server | Restore Database
Find the employee earning the highest bonus from the employee and bonus table ? | SQL
SQL | Integer to Decimal conversion in SQL | CAST and CONVERT
SQL | Find the employees from the employee table who are also managers ?
SQL | Random Sampling with SQL | Sampling Records from Large Datasets
Market Basket Analysis using SQL | Items which are frequently bought together | Product Association
STRING Functions in SQL | PATINDEX | REVERSE | REPLICATE |SUBSTRING | SQL Functions
Solving a query with COLUMN SPECIFICATION instead of JOIN and WINDOW function|SQL Interview Question
Learn to write Subquery in SQL | Multi-row Subqueries | Subquery in FROM clause | PART 2
How to write Subquery ? | Scalar Subqueries | Subqueries for Column values | PART 1
Tricky SQL Interview Question | Reset Running Sum Value When Negative | Complex Interview Question
SQL | PIVOT Data in SQL | PIVOT Function
SQL | Null Function in SQL | ISNULL | COALESCE | IFNULL | NVL
SQL | Compare single column value with range of other values in SQL | ALL and ANY Operators
Display consecutive days for which conditions are satisfied | Tricky SQL Interview Question
SQL Interview Question | Solving Complex SQL Questions | WINDOW Functions | CTE
SQL Query Execution Order and Query Syntax Order | How SQL Query Execute ?
Shortest Distance Between Points on Plane | Solving Equations with SQL | POWER | SQRT
Identify and Manage Reverse Pair Duplicate Data with SQL | 2 Methods | Reverse pair SQL Query
SQL | BETWEEN operator on Text, Number and Date | Filtering data with BETWEEN
SQL Interview Query | Intermediate level SQL query asked in Interview
Delete Duplicate Data from Base Table with SQL | SQL Query to remove duplicates | SQL
SQL | PIVOT data | Convert data from ROW level to COLUMN level | Using CASE
SQL | CROSS JOIN | Cartesian Product of Tables in SQL | Cartesian Join
SQL|PERCENTILE_DISC and PERCENTILE_CONT|Finding Median and Quartiles in SQL|SQL Analytical functions
SQL | Appending data in SQL | Combine result set of two or more SELECT | UNION and UNION ALL
SQL Query| Find records from table for which employee name start with vowels ?|Using Wildcard in SQL)
SQL | Sorting and Filtering data in SQL | Different filtering methods | LIKE | IN | = |
SQL| Find managers for every employee in the table|Common SQL interview question|Self Join explained
SQL | Join with Exclusion in SQL | Full outer join with exclusion | Left/Right Join with exclusion
SQL | Delta Records in SQL | Difference between two tables using SQL | Delta Record | Using 3 method
SQL | Running SUM and Normal SUM in SQL | Define window for SUM function | Cumulative SUM in SQL
SQL|Comparing COUNT(*)-COUNT(1)-COUNT('a')-COUNT(col_nm)-COUNT(DISTINCT col_nm)|Common SQL question?
SQL | Import Data from Excel file into Microsoft SQL Server | Insert large records to tables
Solving Complex SQL Query | Find new inserts and deletes from a table | SQL Interview Questions
SQL | LEFT (OUTER) JOIN and RIGHT (OUTER) JOIN in SQL | Combine rows from multiple tables | SQL join
Update Database Table from Tableau Dashboard | Tableau Advanced
Word Cloud in Tableau | Tag Cloud | Tableau Visualization
Bump Chart in Tableau | Rank Chart | Tableau Visualization
Map with Pie Chart in Tableau | Tableau Visualization | How to add Pie Charts into Your Maps
Create an Area Chart in Tableau
Create a Histogram Chart in Tableau | Tableau Visualization | Histogram
Sunburst Chart in Tableau | Tableau Visualization
Create a Button to Clear All Filters in Tableau | Reset All Visuals in Tableau using a Reset Button
Create a Button to Clear All Filters in Tableau | Reset All Visuals in Tableau using a Reset Button
Combined Axis vs Dual Axis Chart in Tableau |Combo Chart |Blended Axis Chart | Data Visualization
Context Filter in Tableau | Dimension Filter & Context Filter | Tableau Filters
Bubble Chart in Tableau | Comparing Measures in Tableau | Tableau Charts
Scatter Plot in Tableau | Identify Variable Relationship or Correlation | Tableau Chart
Tableau Calendar Chart | Tableau Charts | Data Visualization
Bar Chart using Tableau|Tableau Visualization|Bar Chart
Pareto Chart using Tableau|Tableau Visualization|Pareto Chart
Heat Map using Tableau|Tableau Visualization|Heat Map
Waterfall Chart using Tableau|Tableau Visualization|Waterfall Chart
Line Chart using Tableau|Tableau Visualization|Line Chart
Bubble Chart using Tableau|Tableau Visualization|Bubble Chart
Dual Axis Chart using Tableau|Tableau Visualization|Dual Axis Chart
Box Plot using Tableau|Tableau Visualization|Creating Box Plot Manually|Box and Whisker Plot
Time Series Chart using Tableau|Tableau Visualization|Time Series Chart|Time Series Graph
Tableau - How to Dynamically Show or Hide Charts on dashboard
Tableau Calendar Chart | Tableau Charts | Data Visualization
Ribbon Chart in PowerBI|PowerBI Visualization|Ribbon Chart
Waterfall Chart in PowerBI|PowerBI Visualization|Waterfall Chart
Treemap in PowerBI|PowerBI Visualization|Treemap Chart
Scatter Plot in PowerBI|PowerBI Visualization|Scatter Chart|Live Scatter Plot
Time Series Chart in PowerBI | PowerBI Visualization | Line Chart
Decomposition tree in Power BI|Power BI Visualization|Drill down dimensions with Decomposition tree
Retail Store Dashboard created using Data Studio|Google data studio|BigQuery|Looker Studio
Entity Relationship Diagram (ERD) || DBMS || Create in SSMS || Data Modeling