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.

Oracle SQL Tips

<—– 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 —–>

1 thought on “SQL Tutorial”

  1. udhaya

    Its really helpful for me to understand where i lost in my previous interview. Thanks.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top
Scroll to Top