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.
How to write JOIN SQL query with Using keyword instead of JOIN on
Format your SQL query using these tips. You can spot errors easily and quickly.
SQL count(*) in query is little tricky. This post explains why you need to use group by along with count aggregate function
In this post I have given top online resources where you can do practice of MySQL without install it on your laptop.