SQL Questions and Answers Part 2 | SQL Interview Preparation

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

SQL Questions and Answers Part 1 | SQL Interview Preparation

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

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

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

SET Operators if data types are inconsistent

SQL SET Operators

SQL NATURAL JOIN

SQL CROSS JOIN

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

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

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

SQL HAVING Clause

SQL GROUP BY

SQL DISTINCT Keyword | Selecting unique records from a dataset

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

WHERE Clause and Operators

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

Creating tables and loading data on snowflake

What is SQL? Creating free Snowflake account.