Scan to get the app

App Icon

SQL and PL/SQL Tutorial

SQL & PL/SQL Tutorial

education

Verifed

Verifed

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.

ScreenshotScreenshotScreenshotScreenshotScreenshotScreenshotScreenshotScreenshot

Safety starts with understanding how developers collect and share your data. The developer provided this information and may update it over time.

Data privacy and security practices may vary based on your use, region and age The developer provided this information and may update it over time. Icon image