Ekta Aggarwal
Window Functions in SQL
A detailed tutorial containing everything about window functions
top of page
All Posts...
Search
Ekta Aggarwal
- Jan 14, 2021
PROC PRINT in SAS
A detailed tutorial about PROC PRINT, how it can be used with DROP, KEEP , WHERE and RENAME and a title can be added.
Ekta Aggarwal
- Jan 12, 2021
GROUP BY and HAVING in SQL (aggregate functions)
This tutorial explains how GROUP BY and HAVING can be used together in SQL.
Ekta Aggarwal
- Jan 12, 2021
CAST function in SQL
In SQL, CAST function is used to change the datatype of an already existing column to a specified data type...
Ekta Aggarwal
- Jan 12, 2021
String functions in SQL
There are various string manipulations which can be done in SQL. In this tutorial we will be working on several string functions.
Ekta Aggarwal
- Jan 12, 2021
JOINS in SQL
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.
Ekta Aggarwal
- Jan 12, 2021
CASE WHEN in SQL (IF ELSE in SQL)
An in-depth tutorial containing all the situations where CASE WHEN statements can be used in SQL.
Ekta Aggarwal
- Jan 12, 2021
Subqueries in SQL
An in-depth tutorial of subqueries - suitable for interview questions.
Ekta Aggarwal
- Jan 12, 2021
UNION, UNION ALL, INTERSECT, EXCEPT in SQL
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
Ekta Aggarwal
- Jan 12, 2021
Coalesce in SQL
An in-depth explanation of COALESCE function used in SQL with examples.
Ekta Aggarwal
- Jan 12, 2021
TRUNCATE, DROP and DELETE in SQL
A detailed tutorial explaining the difference between TRUNCAT, DROP and DELETE
Ekta Aggarwal
- Jan 12, 2021
Adding quotes to a column in output
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...
Ekta Aggarwal
- Jan 12, 2021
WHERE statement in SQL (filtering the data)
A detailed tutorial of WHERE statement, which is used to filter for rows satisfying a particular condition
Ekta Aggarwal
- Jan 11, 2021
Sorting data in SQL (ORDER BY)
Learn ORDER BY command in SQL which is used to sort the data on the basis of column(s) in ascending/descending order.
Ekta Aggarwal
- Jan 11, 2021
Aggregate functions and GROUP BY in SQL
Learn aggregate functions like min, max, avg, count, sum and GROUP BY in SQL
Ekta Aggarwal
- Jan 11, 2021
SELECTing only some of the columns
Learn how to select all or some of the columns and distinct values in SQL
Ekta Aggarwal
- Jan 11, 2021
UPDATE-SET in SQL (Updating column values for some specific rows)
In SQL, to change the values in the rows satisfying a particular condition in an already existing table UPDATE-SET queries are used.
Ekta Aggarwal
- Jan 11, 2021
ALTER TABLE in SQL
Alter table can be used for various purposes. This tutorial covers all of the uses in detail
Ekta Aggarwal
- Jan 11, 2021
selecting TOP N rows in SQL
Tutorial to view first N rows in Miscrosoft SQL server, MySQL, MS Access and Oracle
Ekta Aggarwal
- Jan 11, 2021
CONSTRAINTS in SQL
Understanding various constraints like PRIMARY KEY, NOT NULL, UNIQUE, FOREIGN KEY etc. in SQL and the differences
Ekta Aggarwal
- Jan 11, 2021
PRIMARY KEY in SQL
Detailed tutorial for understanding PRIMARY KEY in SQL with examples.
bottom of page