Simple ideas and quickly what you need to find to write a query for joining of two tables explained.
In this post, I have answered one tricky SQL-view interview question. Views availability after the base table modified confuses many developers. I provided an answer to this.
I have explained on how to give multiple conditions in the SQL WHERE clause with examples
Explained examples on SQL Right and Left functions to handle Strings and to get Substring correctly.
Explained the top ideas on how to insert values into a new table using SELECT and INSERT in SQL
How to embed SQL and establish connection in Python, Java and C# well explained.
Explained the best SQL example of NOT NULL constraint.
Ideas on how to write a sub query quickly in your projects.