SQL and PL/SQL Tutorial

Complete tutorial on Oracle SQL and PL/SQL covering all definitions and syntax with examples. This tutorials will help you to learn basic SQL and PL/SQL programming language and help you to understand the designing of database. SQL and PL/SQL topics are covered in this tutorial.

SQL Topics :

SQL-Introduction

SQL-Database

SQL-RDBMS concept

SQL-Syntax

SQL-Data types

SQL-Operators

SQL-Expressions

SQL-Create database

SQL-Drop database

SQL-Create table

SQL-Drop table

SQL-Alter table

SQL-Truncate table

SQL-Insert statement

SQL-Select statement

SQL-Where clause

SQL-AND & OR clause

SQL-Update statement

SQL-Delete statement

SQL-Like operator

SQL-Order by clause

SQL-Group by clause

SQL-Distinct keyword

SQL-Min and Max function

SQL-Count, Avg and Sum function

SQL-Constraints

SQL-Alias

SQL-Wildcards

SQL-Date function

SQL-Null value

SQL-Sub queries

SQL-Join

SQL-Index

SQL-View

SQL-Having clause

SQL-Transactions

SQL-Sequence

SQL-Duplicate handling

PL/SQL Topics :

PL/SQL-Basic Syntax

PL/SQL-Data Types

PL/SQL-Variables

PL/SQL-Constant and Literals

PL/SQL-Operators

PL/SQL-Conditions

PL/SQL-Loops

PL/SQL-Strings

PL/SQL-Arrays

PL/SQL-Procedures

PL/SQL-Functions

PL/SQL-Cursors

PL/SQL-Records

PL/SQL-Exceptions

PL/SQL-Triggers

PL/SQL-Packages

PL/SQL-Collections

PL/SQL-Transactions

PL/SQL-Date and Time

Features of SQL & PL/SQL App:

1. SQL & PL/SQL include in one app.

3. User Interface (UI) well designed.