SQL and PL-SQL Tutorial 1.0

SQL and PL-SQL Tutorial 1.0

Sushant Sharma  ❘ Freeware
Android
out of 235 votes
Latest Version
1.0
Safe to install
VERY GOOD User Rating

This comprehensive tutorial on Oracle SQL and PL/SQL provides a detailed exploration of definitions, syntax, and practical examples that are beneficial for both novices and experienced users alike.

Below is a list of the SQL topics included in the tutorial:

  • Create Table
  • Alter Table
  • Rename and Drop Table
  • Insert into Table
  • Update and Delete Statements
  • Transaction Control Statements
  • SELECT Statement
  • Components of SQL Statements
  • Truncate Table
  • BETWEEN Operator
  • DISTINCT/UNIQUE
  • Character Manipulation: CONCAT
  • WHERE Clause
  • INSTR Function
  • DUAL (Dummy Table)
  • SQL Functions
  • Conversion Functions
  • DECODE Function
  • Implicit & Explicit Conversion
  • Using CASE in SQL
  • NVL, NVL2 & COALESCE
  • Date Functions
  • GROUP BY Clause
  • GROUP BY Clause with Filter
  • HAVING Clause
  • Group Functions
  • SQL Joins
  • Inner Vs Outer Join
  • COMMIT-ROLLBACK Data State
  • Locking in SQL
  • MERGE Statement
  • Types of Tables
  • RR & DD Date Format
  • Pseudo-columns
  • SQL Constraints
  • Views & Inline Views
  • WITH CHECK OPTION in Views
  • Indexes
  • Create User and Grants
  • Synonyms

The following topics are covered in PL/SQL:

  • PL/SQL Block
  • Types of Variables
  • SQL Functions in PL/SQL
  • Conditional/Selection Control
  • Loops in PL/SQL
  • Cursors in PL/SQL
  • Cursors with Parameters </ li >   
  • PL/SQL Reference Cursors </ li >   
  • Bulk Collect and Bulk Bind </ li >   
  • PL/SQL Records Data Type </ li >   
  • Composite Data Type - VARRAY </ li >   
  • Composite Data Type - NESTED TABLES </ li >   
  • Composite Data Type - INDEX BY TABLE </ li >   
  • Implicit Exceptions </ li >   
  • Explicit Exceptions </ li >   
  • Exception Trapping Functions </ li >   
  • PL/SQL PROCEDURE </ li >   
  • PL/SQL FUNCTION </ li >   
  • PL/SQL PACKAGE </ li >   
  • Trigger </ li > </ ul >

Overview

SQL and PL-SQL Tutorial is Freeware software in the Education category developed by Sushant Sharma.

The latest version of SQL and PL-SQL Tutorial is 1.0, released on 12/27/2024. It was initially added to our database on 12/27/2024.

SQL and PL-SQL Tutorial runs on the following operating systems: Android.

Users of SQL and PL-SQL Tutorial gave it a rating of 4 out of 5 stars.

Screenshots (click to enlarge)

Latest Reviews


Ram

Unlock Your Computer's Potential with Ram

BlueMail

BlueMail: A Feature-Rich Email Client for All Your Needs

Joyn

Joyn: Your All-in-One Entertainment Hub

Shotcut

Shotcut: free, open-source cross-platform video editor with broad format support

Advanced Renamer

Easily organize and rename your files with Advanced Renamer.

Twixtor

Twixtor: Optical-flow retiming plugin for smooth slow motion and speed changes

Stay up to date
with UpdateStar freeware.
UpdateStar Premium Edition UpdateStar Premium Edition
UpdateStar Premium: Keeps Windows Software Updated with Extensive Database Coverage
Google Chrome Google Chrome
Google Chrome: fast, secure, free browser with strong Google integration
Microsoft Edge Microsoft Edge
Microsoft Edge: a Copilot-powered browser with strong security and battery savings
Microsoft OneDrive Microsoft OneDrive
Microsoft OneDrive: reliable cloud sync and backup across Windows, Mac, and mobile
Microsoft Visual C++ 2015 Redistributable Package Microsoft Visual C++ 2015 Redistributable Package
Boost your system performance with Microsoft Visual C++ 2015 Redistributable Package!
Microsoft Visual C++ 2010 Redistributable Microsoft Visual C++ 2010 Redistributable
Essential Component for Running Visual C++ Applications

Latest Updates


YourMusic - ad-free player for YT music 1.0.13.0

Music App is a Windows application that brings several music streaming services into a single interface. Rather than switching between separate apps and browser tabs, users can search, browse, and organize songs from different platforms in…

Wallpapers 2026 1.0.4.70

Wallpapers 2026 is a desktop background application offering a large library of high-resolution images for personal computers, laptops, and lock screens.

Transitions DJ 1.8.124.0

Transitions DJ is an ad-free desktop application for DJing and mixtape production. It supports live performance as well as preparing recordings, and it includes SoundCloud access, beatmatched mixing, tempo adjustment, looping, cue…

PC Uptime 6.1.0.0

PC Uptime is a lightweight desktop application for Windows 10 and Windows 11 that tracks how long a system has been running. It records uptime and distinguishes between active and idle time, while maintaining a history of user sessions.

Armoury Crate SE 3.1.7.0

Purpose and ScopeArmoury Crate SE is a free utility from ASUSTeK COMPUTER INC. for the ROG Ally handheld. It is listed in the Utilities & tools category of the Microsoft Store and focuses on device customization, bringing system…

Lovable 1.10.17.0

Lovable is a platform that generates working web and mobile applications and websites from plain-language descriptions. Rather than producing prototypes, it aims to deliver apps that are ready to launch, with design, logic, and backend…