Find number of NULL values in a column #sqlinterview #sqlinterviewquestions
AviW Codes
Find number of NULL values in a column #sqlinterview #sqlinterviewquestions
0:16
Skip footer rows while creating pandas dataframe #pandasdataframe #pythonpandas #pythonprogramming
AviW Codes
Skip footer rows while creating pandas dataframe #pandasdataframe #pythonpandas #pythonprogramming
0:25
find latest record of each employee based on created date. #sql #sqlinterview #sqlinterviewquestions
AviW Codes
find latest record of each employee based on created date. #sql #sqlinterview #sqlinterviewquestions
0:20
pandas dataframe from json file #pythonpandas #pandasdataframe #pythonprogramming
AviW Codes
pandas dataframe from json file #pythonpandas #pandasdataframe #pythonprogramming
0:22
Create beautiful 😍 hill using #matplotlib #python #pythonprogramming @aviwcodes
AviW Codes
Create beautiful 😍 hill using #matplotlib #python #pythonprogramming @aviwcodes
0:29
Create 3D stem plot using #matplotlib #python @aviwcodes
AviW Codes
Create 3D stem plot using #matplotlib #python @aviwcodes
0:29
Create 3D sphere surface using #matplotlib #python #pythonprogramming
AviW Codes
Create 3D sphere surface using #matplotlib #python #pythonprogramming
0:33
skip unwanted rows while creating pandas df #pythonpandas #pandasdataframe #pythonprogramming
AviW Codes
skip unwanted rows while creating pandas df #pythonpandas #pandasdataframe #pythonprogramming
0:22
3D wireframe plot using #matplotlib #python #pythonprogramming
AviW Codes
3D wireframe plot using #matplotlib #python #pythonprogramming
0:25
Plot contour curves in 3D using #matplotlib #python #pythonprogramming
AviW Codes
Plot contour curves in 3D using #matplotlib #python #pythonprogramming
0:20
pandas df from CSV file without header #pandasdataframe #pythonpandas #python
AviW Codes
pandas df from CSV file without header #pandasdataframe #pythonpandas #python
0:29
Amazing 3D voxel plot using #matplotlib #python #pythonprogramming
AviW Codes
Amazing 3D voxel plot using #matplotlib #python #pythonprogramming
0:29
pandas df from CSV file with custom delimiter #pandas #pandasdataframe #pythonpandas
AviW Codes
pandas df from CSV file with custom delimiter #pandas #pandasdataframe #pythonpandas
0:25
excellent 3D surface with #matplotlib #python
AviW Codes
excellent 3D surface with #matplotlib #python
0:33
SQL Questions and Answers Part 2 | SQL Interview Preparation
AviW Codes
SQL Questions and Answers Part 2 | SQL Interview Preparation
4:58
attractive 3D scatterplot with #matplotlib #pythonprogramming
AviW Codes
attractive 3D scatterplot with #matplotlib #pythonprogramming
0:29
Create nice pie chart using #matplotlib #piechart #piecharts #python
AviW Codes
Create nice pie chart using #matplotlib #piechart #piecharts #python
0:40
SQL MERGE | How to insert, update and delete rows in a table using one SQL query
AviW Codes
SQL MERGE | How to insert, update and delete rows in a table using one SQL query
7:01
Create pleasing ♡ ♥💕❤ scatter plot. #matplotlib #pythonprogramming #attractive
AviW Codes
Create pleasing ♡ ♥💕❤ scatter plot. #matplotlib #pythonprogramming #attractive
0:40
SQL Questions and Answers Part 1 | SQL Interview Preparation
AviW Codes
SQL Questions and Answers Part 1 | SQL Interview Preparation
5:10
Create attractive bar chart with matplotlib. #matplotlib #attractive #python
AviW Codes
Create attractive bar chart with matplotlib. #matplotlib #attractive #python
0:40
Merge pandas df with different column names. #pythonpandas #pandasdataframe #pythonprogramming
AviW Codes
Merge pandas df with different column names. #pythonpandas #pandasdataframe #pythonprogramming
0:28
What % of total salary is given to employee per dept. #sql #sqlinterviewquestions #sqlinterview
AviW Codes
What % of total salary is given to employee per dept. #sql #sqlinterviewquestions #sqlinterview
0:22
Explode list items across rows in pandas df #pythonpandas #pythonprogramming #pandasdataframe
AviW Codes
Explode list items across rows in pandas df #pythonpandas #pythonprogramming #pandasdataframe
0:23
What % of total salary is given to each employee. #sql #sqlinterviewquestions #sqlinterview
AviW Codes
What % of total salary is given to each employee. #sql #sqlinterviewquestions #sqlinterview
0:21
Merge/join 2 pandas dataframes. #pandasdataframe #pythonpandas #pythonprogramming
AviW Codes
Merge/join 2 pandas dataframes. #pandasdataframe #pythonpandas #pythonprogramming
0:40
Add column in df by extracting values from dictionary #pandas #pythonpandas #pythonprogramming
AviW Codes
Add column in df by extracting values from dictionary #pandas #pythonpandas #pythonprogramming
0:41
add new column in pandas df based on existing column values. #pandas #python #pythonpandas
AviW Codes
add new column in pandas df based on existing column values. #pandas #python #pythonpandas
0:35
SQL query to find income per product. #sql #sqlinterviewquestions #sqlinterview
AviW Codes
SQL query to find income per product. #sql #sqlinterviewquestions #sqlinterview
0:29
add a new column to pandas df with static value. #pythonpandas #python #pythonprogramming #pandas
AviW Codes
add a new column to pandas df with static value. #pythonpandas #python #pythonprogramming #pandas
0:16
create pandas dataframe from python dictionary. #pythonpandas #python #pythonprogramming
AviW Codes
create pandas dataframe from python dictionary. #pythonpandas #python #pythonprogramming
0:21
create pandas dataframe from python list. #pythonpandas #python #pythonprogramming #pandasdataframe
AviW Codes
create pandas dataframe from python list. #pythonpandas #python #pythonprogramming #pandasdataframe
0:28
SQL query to find cities that contains character o. #sql #sqlinterviewquestions
AviW Codes
SQL query to find cities that contains character o. #sql #sqlinterviewquestions
0:15
sql query to find cities with 2nd char as a. #sql #sqlinterviewquestions
AviW Codes
sql query to find cities with 2nd char as a. #sql #sqlinterviewquestions
0:16
SQL query to find firstname from fullname. #sql #sqlinterviewquestions
AviW Codes
SQL query to find firstname from fullname. #sql #sqlinterviewquestions
0:27
create spark dataframe from CSV. #apachespark
AviW Codes
create spark dataframe from CSV. #apachespark
0:20
create spark dataframe from seq. #apachespark
AviW Codes
create spark dataframe from seq. #apachespark
0:23
find number of customers with same number of orders.#sql #sqlinterviewquestions
AviW Codes
find number of customers with same number of orders.#sql #sqlinterviewquestions
0:25
find customers who placed more than 5 orders #sql #sqlinterviewquestions
AviW Codes
find customers who placed more than 5 orders #sql #sqlinterviewquestions
0:28
Find employees earning 3rd highest salaries in their departments. #sql #sqlinterviewquestions
AviW Codes
Find employees earning 3rd highest salaries in their departments. #sql #sqlinterviewquestions
0:33
row_number, rank and dense_rank in SQL #sql #sqlinterviewquestions #sqlinterview
AviW Codes
row_number, rank and dense_rank in SQL #sql #sqlinterviewquestions #sqlinterview
0:27
SQL query to find customer who did not order anything. #sql #sqlinterviewquestions #sqlinterview
AviW Codes
SQL query to find customer who did not order anything. #sql #sqlinterviewquestions #sqlinterview
0:29
Get products of category that has highest no. of products. #sql #sqlinterviewquestions #sqlinterview
AviW Codes
Get products of category that has highest no. of products. #sql #sqlinterviewquestions #sqlinterview
0:21
SQL query to find product having 2nd highest price. #sql #sqlinterview #sqlinterviewquestions
AviW Codes
SQL query to find product having 2nd highest price. #sql #sqlinterview #sqlinterviewquestions
0:31
SQL DELETE Statement | Deleting records from a table | Deleting specific records from a table
AviW Codes
SQL DELETE Statement | Deleting records from a table | Deleting specific records from a table
2:47
SQL query to find products with price more than avg price. #sql #sqlinterviewquestions #sqlinterview
AviW Codes
SQL query to find products with price more than avg price. #sql #sqlinterviewquestions #sqlinterview
0:17
SQL UPDATE Statement | Update values of columns for specific records and all records
AviW Codes
SQL UPDATE Statement | Update values of columns for specific records and all records
4:46
SQL query to find total income per product. #sql #sqlinterviewquestions #sqlinterview #sqljoins
AviW Codes
SQL query to find total income per product. #sql #sqlinterviewquestions #sqlinterview #sqljoins
0:29
SQL query to delete duplicate records. #shorts #sql #sqlinterviewquestions #sqlinterview #aviwcodes
AviW Codes
SQL query to delete duplicate records. #shorts #sql #sqlinterviewquestions #sqlinterview #aviwcodes
0:25
SQL query to find moving average. #sql #sqlinterviewquestions #aviwcodes
AviW Codes
SQL query to find moving average. #sql #sqlinterviewquestions #aviwcodes
0:20
Find cumulative sum/running total. #sql #sqlwindowfunction #aviwcodes
AviW Codes
Find cumulative sum/running total. #sql #sqlwindowfunction #aviwcodes
0:17
Find latest order date for all customers. #shorts #sql #sqljoins #sqlinterviewquestions #aviwcodes
AviW Codes
Find latest order date for all customers. #shorts #sql #sqljoins #sqlinterviewquestions #aviwcodes
0:14
Find number of orders placed by each customer. #shorts #aviwcodes #sql #sqljoins #sqlinterview
AviW Codes
Find number of orders placed by each customer. #shorts #aviwcodes #sql #sqljoins #sqlinterview
0:19
SQL query to find number of customers from each country and city. #short #aviwcodes #sql
AviW Codes
SQL query to find number of customers from each country and city. #short #aviwcodes #sql
0:15
SQL INSERT INTO Statement | Insert records into a table | Insert records from a table to another
AviW Codes
SQL INSERT INTO Statement | Insert records into a table | Insert records from a table to another
11:05
SET Operators if data types are inconsistent
AviW Codes
SET Operators if data types are inconsistent
7:15
SQL SET Operators
AviW Codes
SQL SET Operators
6:03
SQL NATURAL JOIN
AviW Codes
SQL NATURAL JOIN
10:38
SQL CROSS JOIN
AviW Codes
SQL CROSS JOIN
4:16
SQL OUTER JOIN | LEFT OUTER JOIN | RIGHT OUTER JOIN | FULL OUTER JOIN
AviW Codes
SQL OUTER JOIN | LEFT OUTER JOIN | RIGHT OUTER JOIN | FULL OUTER JOIN
9:13
SQL INNER JOIN | SELF JOIN | Fetching data from multiple tables
AviW Codes
SQL INNER JOIN | SELF JOIN | Fetching data from multiple tables
10:54
Why is data stored in separate tables and Why we need JOIN operation?
AviW Codes
Why is data stored in separate tables and Why we need JOIN operation?
2:38
SQL HAVING Clause
AviW Codes
SQL HAVING Clause
6:44
SQL GROUP BY
AviW Codes
SQL GROUP BY
7:23
SQL DISTINCT Keyword | Selecting unique records from a dataset
AviW Codes
SQL DISTINCT Keyword | Selecting unique records from a dataset
3:37
SQL ORDER BY | Sorting data | Sorting records based on multiple columns
AviW Codes
SQL ORDER BY | Sorting data | Sorting records based on multiple columns
2:30
WHERE Clause and Operators
AviW Codes
WHERE Clause and Operators
18:42
SQL SELECT Statement | Selecting data from columns having complex data type
AviW Codes
SQL SELECT Statement | Selecting data from columns having complex data type
15:51
Creating tables and loading data on snowflake
AviW Codes
Creating tables and loading data on snowflake
28:52
What is SQL? Creating free Snowflake account.
AviW Codes
What is SQL? Creating free Snowflake account.
9:37