SQL and PL-SQL Tutorial for PC

Published by Sushant Sharma

Category
Education
Developer
Sushant Sharma
Downloads
50000+
Android Version
2.2 and up
Content Rating
Everyone

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 Install SQL and PL-SQL Tutorial for Windows PC or MAC:

SQL and PL-SQL Tutorial is an Android Education app developed by Sushant Sharma and published on the Google play store. It has gained around 50000 installs so far, with an average rating of 4.0 out of 5 in the play store.

SQL and PL-SQL Tutorial requires Android with an OS version of 2.2 and up. In addition, the app has a content rating of Everyone, from which you can decide if it is suitable to install for family, kids, or adult users. SQL and PL-SQL Tutorial is an Android app and cannot be installed on Windows PC or MAC directly.

Android Emulator is a software application that enables you to run Android apps and games on a PC by emulating Android OS. There are many free Android emulators available on the internet. However, emulators consume many system resources to emulate an OS and run apps on it. So it is advised that you check the minimum and required system requirements of an Android emulator before you download and install it on your PC.

Below you will find how to install and run SQL and PL-SQL Tutorial on PC:

Firstly, download and install an Android emulator to your PC
Download SQL and PL-SQL Tutorial APK to your PC
Open SQL and PL-SQL Tutorial APK using the emulator or drag and drop the APK file into the emulator to install the app.
If you do not want to download the APK file, you can install SQL and PL-SQL Tutorial PC by connecting your Google account with the emulator and downloading the app from the play store directly.

If you follow the above steps correctly, you should have the SQL and PL-SQL Tutorial ready to run on your Windows PC or MAC. In addition, you can check the minimum system requirements of the emulator on the official website before installing it. This way, you can avoid any system-related technical issues.

Download SQL and PL-SQL Tutorial For PC

SQL and PL APK 1.0	5.86 MB	1.0