SQL Tutorial

SQL (pronounced as “ess-que-el”) stands for Structured Query Language.

SQL is used to modify and access data from a database and is used by most common relational database management systems like Oracle, Sybase, Microsoft SQL Server, Access, etc.

<—– SQL Tutorial —–>

1. SQL Interview Questions and Answers – 1
2. Difference Between DDL, DML and DCL Commands
3. What is the Difference between Truncate and Delete in Oracle
4. How to Delete Duplicate Rows from a Table
5. Joins – Left outer, Right outer and full outer
6. Transpose Rows into Columns
7. Transpose Rows to Columns/Columns to Rows in Oracle
8. The following method will help you to create PIVOT tables in Oracle.
9. SQL Tips: LAG and LEAD Analytic Functions
10. Difference in RANK, DENSE_RANK, FIRST and LAST Analytic Functions
11. NVL, DECODE, NVL2, COALESCE-NULL Functions in Oracle
12. How to Create Index in Oracle SQL with Example
13. How to use LPAD and RPAD Function
14. Alter Table Command in Oracle SQL
15. Create Normal Table and Global Temporary Table in Oracle
16. Create a Table from another Table in Oracle SQL

Time to time we update SQL tutorial so keep visiting our website……

<—– End SQL Tutorial —–>