Extract domain name from email ID - both SQL and Excel sheet solution || Basic series

This video is small data analytics tutorial with teachings on ways to pull domain name from email ID. It teaches both in excelsheets and in SQL;

tools used: EXCEL, PostgresSQL (postgre shell, psql)

Excel: select column- data- text to column- pass delimiter as @ - hit finish

final SQL query used in the video:

select *,substring(email,(position('@' in email)+1),length(email)) as domain from email_rep;

main psql functions used in this video -SUBSTRING,LENGTH, POSITION

note: use CHARINDEX() in place of position(), if you are using M S sqlserver;

blog version of the video: ########coming soon#########

Social media handles:
####coming soon##############