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


Outlook on the Desktop

Outlook on the Desktop: Your Email, Always Within Reach

Imagine

Unlock Your Creativity with Imagine by Sejin Chun

Bricscad

BricsCAD: Versatile CAD Software for Every Architect and Engineer

EasyBilling

Streamline Your Invoicing with EasyBilling

USB Redirector Technician Edition

USB Redirector Technician Edition: remote servicing of USB devices over the internet

Thorium

Revolutionize your digital publishing with Thorium by EDRLab

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


Name Ringtone Maker - FDMR.Party 1.2.7

FDMR.party's Name Ringtone Maker is an outstanding app that has been enabling users to create personalized name ringtones since 2017.

WhatsApp Business 26.45.74

Streamline Your Business Communication with WhatsApp Business

Shadow Of Death 2: Awakening 2.23.3

Shadow Legends: Dark Fantasy Fighting Action RPG Games In this review, we will be discussing the features and gameplay of Shadow Legends, a dark fantasy fighting action RPG game that offers an immersive experience.

MSI APP Player 10.42.167.6308

MSI App Player: BlueStacks-powered Android emulator for PC and handheld gaming

AnyDesk 9.8.4

AnyDesk: fast, low-latency remote desktop with a free testing option

DJV Media Review 3.7.7

DJV is a free, open-source media review application developed by Darby Johnston for visual effects, animation and film production work.