All Posts...

A detailed tutorial about PROC PRINT, how it can be used with DROP, KEEP , WHERE and RENAME and a title can be added.

This tutorial explains how GROUP BY and HAVING can be used together in SQL.

In SQL, CAST function is used to change the datatype of an already existing column to a specified data type...

There are various string manipulations which can be done in SQL. In this tutorial we will be working on several string functions.

There are majorly 5 types of joins in SQL: Inner Join,Left Join, Right Join, Full Join,Cross Join In this tutorial we'll cover all of them.

An in-depth tutorial containing all the situations where CASE WHEN statements can be used in SQL.

An in-depth tutorial of subqueries - suitable for interview questions.

If you need to filter entries which are either present in one table, or both, or anti-join: learn UNION, UNION ALL,EXCEPT and INTERSECT

An in-depth explanation of COALESCE function used in SQL with examples.

A detailed tutorial explaining the difference between TRUNCAT, DROP and DELETE

It is a common problem that sometimes while copying the data from SQL to MS-Excel, some data formats of string columns can change (in my...

A detailed tutorial of WHERE statement, which is used to filter for rows satisfying a particular condition

Learn ORDER BY command in SQL which is used to sort the data on the basis of column(s) in ascending/descending order.

Learn aggregate functions like min, max, avg, count, sum and GROUP BY in SQL

Learn how to select all or some of the columns and distinct values in SQL

In SQL, to change the values in the rows satisfying a particular condition in an already existing table UPDATE-SET queries are used.

Alter table can be used for various purposes. This tutorial covers all of the uses in detail

Tutorial to view first N rows in Miscrosoft SQL server, MySQL, MS Access and Oracle

Understanding various constraints like PRIMARY KEY, NOT NULL, UNIQUE, FOREIGN KEY etc. in SQL and the differences

Detailed tutorial for understanding PRIMARY KEY in SQL with examples.

INSERT INTO statement in SQL