AviW Codes

0:16

Find number of NULL values in a column #sqlinterview #sqlinterviewquestions

0:25

Skip footer rows while creating pandas dataframe #pandasdataframe #pythonpandas #pythonprogramming

0:20

find latest record of each employee based on created date. #sql #sqlinterview #sqlinterviewquestions

0:22

pandas dataframe from json file #pythonpandas #pandasdataframe #pythonprogramming

0:29

Create beautiful 😍 hill using #matplotlib #python #pythonprogramming @aviwcodes

0:29

Create 3D stem plot using #matplotlib #python @aviwcodes

0:33

Create 3D sphere surface using #matplotlib #python #pythonprogramming

0:22

skip unwanted rows while creating pandas df #pythonpandas #pandasdataframe #pythonprogramming

0:25

3D wireframe plot using #matplotlib #python #pythonprogramming

0:20

Plot contour curves in 3D using #matplotlib #python #pythonprogramming

0:29

pandas df from CSV file without header #pandasdataframe #pythonpandas #python

0:29

Amazing 3D voxel plot using #matplotlib #python #pythonprogramming

0:25

pandas df from CSV file with custom delimiter #pandas #pandasdataframe #pythonpandas

0:33

excellent 3D surface with #matplotlib #python

4:58

SQL Questions and Answers Part 2 | SQL Interview Preparation

0:29

attractive 3D scatterplot with #matplotlib #pythonprogramming

0:40

Create nice pie chart using #matplotlib #piechart #piecharts #python

7:01

SQL MERGE | How to insert, update and delete rows in a table using one SQL query

0:40

Create pleasing ♡ ♥💕❤ scatter plot. #matplotlib #pythonprogramming #attractive

5:10

SQL Questions and Answers Part 1 | SQL Interview Preparation

0:40

Create attractive bar chart with matplotlib. #matplotlib #attractive #python

0:28

Merge pandas df with different column names. #pythonpandas #pandasdataframe #pythonprogramming

0:22

What % of total salary is given to employee per dept. #sql #sqlinterviewquestions #sqlinterview

0:23

Explode list items across rows in pandas df #pythonpandas #pythonprogramming #pandasdataframe

0:21

What % of total salary is given to each employee. #sql #sqlinterviewquestions #sqlinterview

0:40

Merge/join 2 pandas dataframes. #pandasdataframe #pythonpandas #pythonprogramming

0:41

Add column in df by extracting values from dictionary #pandas #pythonpandas #pythonprogramming

0:35

add new column in pandas df based on existing column values. #pandas #python #pythonpandas

0:29

SQL query to find income per product. #sql #sqlinterviewquestions #sqlinterview

0:16

add a new column to pandas df with static value. #pythonpandas #python #pythonprogramming #pandas

0:21

create pandas dataframe from python dictionary. #pythonpandas #python #pythonprogramming

0:28

create pandas dataframe from python list. #pythonpandas #python #pythonprogramming #pandasdataframe

0:15

SQL query to find cities that contains character o. #sql #sqlinterviewquestions

0:16

sql query to find cities with 2nd char as a. #sql #sqlinterviewquestions

0:27

SQL query to find firstname from fullname. #sql #sqlinterviewquestions

0:20

create spark dataframe from CSV. #apachespark

0:23

create spark dataframe from seq. #apachespark

0:25

find number of customers with same number of orders.#sql #sqlinterviewquestions

0:28

find customers who placed more than 5 orders #sql #sqlinterviewquestions

0:33

Find employees earning 3rd highest salaries in their departments. #sql #sqlinterviewquestions

0:27

row_number, rank and dense_rank in SQL #sql #sqlinterviewquestions #sqlinterview

0:29

SQL query to find customer who did not order anything. #sql #sqlinterviewquestions #sqlinterview

0:21

Get products of category that has highest no. of products. #sql #sqlinterviewquestions #sqlinterview

0:31

SQL query to find product having 2nd highest price. #sql #sqlinterview #sqlinterviewquestions

2:47

SQL DELETE Statement | Deleting records from a table | Deleting specific records from a table

0:17

SQL query to find products with price more than avg price. #sql #sqlinterviewquestions #sqlinterview

4:46

SQL UPDATE Statement | Update values of columns for specific records and all records

0:29

SQL query to find total income per product. #sql #sqlinterviewquestions #sqlinterview #sqljoins

0:25

SQL query to delete duplicate records. #shorts #sql #sqlinterviewquestions #sqlinterview #aviwcodes

0:20

SQL query to find moving average. #sql #sqlinterviewquestions #aviwcodes

0:17

Find cumulative sum/running total. #sql #sqlwindowfunction #aviwcodes

0:14

Find latest order date for all customers. #shorts #sql #sqljoins #sqlinterviewquestions #aviwcodes

0:19

Find number of orders placed by each customer. #shorts #aviwcodes #sql #sqljoins #sqlinterview

0:15

SQL query to find number of customers from each country and city. #short #aviwcodes #sql

11:05

SQL INSERT INTO Statement | Insert records into a table | Insert records from a table to another

7:15

SET Operators if data types are inconsistent

6:03

SQL SET Operators

10:38

SQL NATURAL JOIN

4:16

SQL CROSS JOIN

9:13

SQL OUTER JOIN | LEFT OUTER JOIN | RIGHT OUTER JOIN | FULL OUTER JOIN

10:54

SQL INNER JOIN | SELF JOIN | Fetching data from multiple tables

2:38

Why is data stored in separate tables and Why we need JOIN operation?

6:44

SQL HAVING Clause

7:23

SQL GROUP BY

3:37

SQL DISTINCT Keyword | Selecting unique records from a dataset

2:30

SQL ORDER BY | Sorting data | Sorting records based on multiple columns

18:42

WHERE Clause and Operators

15:51

SQL SELECT Statement | Selecting data from columns having complex data type

28:52

Creating tables and loading data on snowflake

9:37

What is SQL? Creating free Snowflake account.