SQL and PL-SQL Tutorial APK

Download SQL and PL-SQL Tutorial 1.0 APK

App Description

SQL and PL-SQL Tutorial is ssand,oraclesqlandplsql,education,pl-sql,tutorial, content rating is Everyone (PEGI-3). This app is rated 5 by 1 users who are using this app. To know more about the company/developer, visit Sushant Sharma website who developed it. com.ssand.app.edu.oraclesqlandplsql.apk apps can be downloaded and installed on Android 2.2.x and higher Android devices. The Latest Version of 1.0 Available for download. Download the app using your favorite browser and click Install to install the application. Please note that we provide both basic and pure APK files and faster download speeds than APK Mirror. This app APK has been downloaded 76+ times on store. You can also download com.ssand.app.edu.oraclesqlandplsql APK and run it with the popular Android Emulators.

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 

App ChangeLog

App Screens

24e09f789d13119c47ace5cf472013fecbfc22cf.apk
Name:com.ssand.app.edu.oraclesqlandplsql.apk
Name:1567116712670.apk

Apk scan results

Apk Scaned By TotalVirus Antivirus,com.ssand.app.edu.oraclesqlandplsql.apk Was Pure And Safe.

Scan Stats:harmless:0|type-unsupported:11|suspicious:0|confirmed-timeout:0|timeout:0|failure:0|malicious:0|undetected:64|
Name:24e09f789d13119c47ace5cf472013fecbfc22cf.apk
Name:com.ssand.app.edu.oraclesqlandplsql.apk
Name:1567116712670.apk
SHA-1:24e09f789d13119c47ace5cf472013fecbfc22cf
SHA-256:c1a4883fb3825f94364eef1f399c75bd10430ab4766cc7a102ea49083159dd5f
SSDEEP:98304:ToWSDNiJ9CZ4ZFM1Try8F/ff/y0o6lmMFDvFpGFOu9xm38Ir3B3zG1YZNGZnxxDv:Tox/Z4HM13Hi+l5D2ADJUrgNU
File type:Android
Magic:Java archive data (JAR)
File size:6145208
Uncompressed Size:8105955
Contained Files	:437
Contained Files By Type:xml:55,map:2,MF:1,svg:1,RSA:1,jpg:1,js:6,dex:1,png:290,eot:1,SF:1,ttf:1,css:70,