SQL &PL-SQL Tutorial

完整的教程和SQL的面試問題收集和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