Ekta AggarwalJan 14, 2021PROC PRINT in SASA detailed tutorial about PROC PRINT, how it can be used with DROP, KEEP , WHERE and RENAME and a title can be added.
Ekta AggarwalJan 12, 2021GROUP BY and HAVING in SQL (aggregate functions)This tutorial explains how GROUP BY and HAVING can be used together in SQL.
Ekta AggarwalJan 12, 2021CAST function in SQLIn SQL, CAST function is used to change the datatype of an already existing column to a specified data type...
Ekta AggarwalJan 12, 2021String functions in SQLThere are various string manipulations which can be done in SQL. In this tutorial we will be working on several string functions.
Ekta AggarwalJan 12, 2021JOINS in SQLThere 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 AggarwalJan 12, 2021CASE 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 AggarwalJan 12, 2021Subqueries in SQLAn in-depth tutorial of subqueries - suitable for interview questions.
Ekta AggarwalJan 12, 2021UNION, UNION ALL, INTERSECT, EXCEPT in SQLIf 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 AggarwalJan 11, 2021Coalesce in SQLAn in-depth explanation of COALESCE function used in SQL with examples.
Ekta AggarwalJan 11, 2021TRUNCATE, DROP and DELETE in SQLA detailed tutorial explaining the difference between TRUNCAT, DROP and DELETE
Ekta AggarwalJan 11, 2021Adding quotes to a column in outputIt 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 AggarwalJan 11, 2021WHERE statement in SQL (filtering the data)A detailed tutorial of WHERE statement, which is used to filter for rows satisfying a particular condition
Ekta AggarwalJan 11, 2021Sorting 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 AggarwalJan 11, 2021Aggregate functions and GROUP BY in SQLLearn aggregate functions like min, max, avg, count, sum and GROUP BY in SQL
Ekta AggarwalJan 11, 2021SELECTing only some of the columnsLearn how to select all or some of the columns and distinct values in SQL
Ekta AggarwalJan 11, 2021UPDATE-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 AggarwalJan 11, 2021ALTER TABLE in SQLAlter table can be used for various purposes. This tutorial covers all of the uses in detail
Ekta AggarwalJan 11, 2021selecting TOP N rows in SQLTutorial to view first N rows in Miscrosoft SQL server, MySQL, MS Access and Oracle
Ekta AggarwalJan 11, 2021CONSTRAINTS in SQLUnderstanding various constraints like PRIMARY KEY, NOT NULL, UNIQUE, FOREIGN KEY etc. in SQL and the differences
Ekta AggarwalJan 11, 2021PRIMARY KEY in SQLDetailed tutorial for understanding PRIMARY KEY in SQL with examples.