SQL and PL-SQL Tutorial 1.0
Free Version
Publisher Description
SQL and PL-SQL Tutorial - Tutorial on SQL & PL-SQL covering all definitions & syntax with examples.
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
About SQL and PL-SQL Tutorial
SQL and PL-SQL Tutorial is a free app for Android published in the Teaching & Training Tools list of apps, part of Education.
The company that develops SQL and PL-SQL Tutorial is Sushant Sharma. The latest version released by its developer is 1.0.
To install SQL and PL-SQL Tutorial on your Android device, just click the green Continue To App button above to start the installation process. The app is listed on our website since 2015-09-22 and was downloaded 5 times. We have already checked if the download link is safe, however for your own protection we recommend that you scan the downloaded app with your antivirus. Your antivirus may detect the SQL and PL-SQL Tutorial as malware as malware if the download link to com.ssand.app.edu.oraclesqlandplsql is broken.
How to install SQL and PL-SQL Tutorial on your Android device:
- Click on the Continue To App button on our website. This will redirect you to Google Play.
- Once the SQL and PL-SQL Tutorial is shown in the Google Play listing of your Android device, you can start its download and installation. Tap on the Install button located below the search bar and to the right of the app icon.
- A pop-up window with the permissions required by SQL and PL-SQL Tutorial will be shown. Click on Accept to continue the process.
- SQL and PL-SQL Tutorial will be downloaded onto your device, displaying a progress. Once the download completes, the installation will start and you'll get a notification after the installation is finished.
