Complete tutorial and interview Question collection of SQL and PL-SQL
Below is list of SQL and PL-SQL topics covered in the app:
SQL:-
Introduction
Create Table
Alter Table
Rename and Drop Table
Insert into Table
Update and Delete Statements
SELECT Statement
Components of SQL Statement
Truncate Table
BETWEEN Operator
DISTINCT/UNIQUE
WHERE Clause
INSERT Function
DUAL (Dummy table)
SQL Functions
Implicit & Explicit Conversion
Using CASE in SQL
Date Functions
GROUP BY Clause
HAVING Clause
Group Functions
SQL Joins
Inner Vs Outer Join
Views & Inline Views
Indexes
Create User and Grants
Interview Questions collection on SQL
Interview Questions collection on PL/SQL