SQL and PL/SQL Tutorial

Description

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.