SQL and PL-SQL Tutorial

SQL and PL-SQL Tutorial Free App

Rated 4.07/5 (191) —  Free Android application by Sushant Sharma

About SQL and PL-SQL Tutorial

Complete tutorial on Oracle SQL and PL-SQL covering all definitions and syntax with examples.
Below is list of SQL and PL-SQL topics covered in the app:

SQL:-
1. Create Table
2. Alter Table
3. Rename and Drop Table
4. Insert into Table
5. Update and Delete Statements
6. Transaction Control Statements
7. SELECT Statement
8. Components of SQL Statement
9. Truncate Table
10. BETWEEN Operator
11. DISTINCT/UNIQUE
12. Character Manipulation: CONCAT
13. WHERE Clause
14. INSTR Function
15. DUAL (Dummy table)
16. SQL Functions
17. Conversion Functions
18. DECODE Function
19. Implicit & Explicit Conversion
20. Using CASE in SQL
21. NVL, NVL2 & COALESCE
22. Date Functions
23. GROUP BY Clause
24. GROUP BY Clause with Filter
25. HAVING Clause
26. Group Functions
27. SQL Joins
28. Inner Vs Outer Join
29. COMMIT-ROLLBACK Data State
30. Locking in SQL
31. MERGE Statement
32. Types of Tables
33. RR & DD Date Format
34. Pseudo-coloumns
35. SQL Constraints
36. Views & Inline Views
37. WITH CHECK OPTION in Views
38. Indexes
39. Create User and Grants
40. Synonyms


PL-SQL:-
1. PL SQL Block
2. Types of Variables
3. SQL Functions in PL-SQL
4. Conditional/Selection Control
5. Loops in PL-SQL
6. Cursors in PLSQL
7. Cursors with Parameters
8. PL-SQL Reference Cursors
9. Bulk Collect and Bulk Bind
10. PL/SQL Records Data Type
11. Composite Data Type - VARRAY
12. Composite Data Type - NESTED TABLES
13. Composite Data Type - INDEX BY TABLE
14. Implicit Exceptions
15. Explicit Exceptions
16. Exception Trapping Functions
17. PL/SQL PROCEDURE
18. PL/SQL FUNCTION
19. PL/SQL PACKAGE
20. Trigger

How to Download / Install

Download and install SQL and PL-SQL Tutorial version 1.0 on your Android device!
Downloaded 10,000+ times, content rating: Everyone
Android package: com.ssand.app.edu.oraclesqlandplsql, download SQL and PL-SQL Tutorial.apk

All Application Badges

Free
downl.
Android
2.2+
For everyone
Android app

App History & Updates

More downloads  SQL and PL-SQL Tutorial reached 10 000 - 50 000 downloads

What are users saying about SQL and PL-SQL Tutorial

M70%
by M####:

Delete query syntax is wrong. Guys validate all.

X70%
by X####:

Hard to read on lessons, wrap the text.

H70%
by H####:

No example are given .... No explanation are there

X70%
by X####:

It's really good for me...

J70%
by J####:

Thanks

L70%
by L####:

Awesome app

H70%
by H####:

good reference

X70%
by X####:

Good app

G70%
by G####:

Waste

Y70%
by Y####:

V.good for beginners

X70%
by X####:

Worst app ever.

J70%
by J####:

Very well apps

X70%
by X####:

It is very usefull for all persons!!! good job

M70%
by M####:

Best app for the newbies and experienced ones..

X70%
by X####:

Good but can be improved

X70%
by X####:

Wowww Tq Helpfull App

Y70%
by Y####:

I love it lot

X70%
by X####:

Very good app

B70%
by B####:

Great app but u should also improve its page marging. Page has stretch and seems some prblm. So plz solve it. And gives updates...

U70%
by U####:

Nice, simple and easy. Good work.

U70%
by U####:

Wonderful application and easy to learn

U70%
by U####:

I love it, I can practice anytime anywhere

U70%
by U####:

Nice app..it is simply and easy to get useful for app

U70%
by U####:

Good work sharma thanks for the apps

U70%
by U####:

Nice understanding query I love it..great..

A70%
by A####:

Nice one...really awesome and helpful..

U70%
by U####:

Really working

R70%
by R####:

nice app for bigners

D70%
by D####:

Thanks

D70%
by D####:

Thanks

U70%
by U####:

Excellent

U70%
by U####:

Nice

K70%
by K####:

It makes me employee

T70%
by T####:

It's useful for last time preparations

U70%
by U####:

Good for learning sql

U70%
by U####:

Super app

Z70%
by Z####:

Really good for learners

U70%
by U####:

Nice app to learn

U70%
by U####:

Best tutorial

U70%
by U####:

Good app


Share The Word!


Rating Distribution

RATING
4.15
191 users

5

4

3

2

1