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


TeamViewer QuickSupport 15.83.7

Effortless Remote Assistance with TeamViewer QuickSupport

TeamViewer Host 15.83.7

TeamViewer Host — powerful, secure unattended remote access with some device-specific limitations

TeamViewer 15.83.7

TeamViewer: Established Remote Access and Support Platform for Desktop and Mobile

Hospital Organizer: Tidy Game 1.6

Hospital Organizer: Tidy Game is a puzzle title in which players sort supplies, arrange medicine cabinets, and restore order across several hospital departments.

Cake Making Bakery Chef Game 2.3

Indulge in a delightful culinary experience with this cake-making game designed for an engaging experience. Discover an assortment of addictive and remarkable cake collections awaiting you in this charming bakery-themed cooking game.

Bear on the walk 9.0

There is a simple task in this game: leap over the animal.