SQL

Structured Query Language is mainly designed for managing data stored in relational database management system (RDBMS). SQL can be used to perform task like retrieving data or updating data in a database. There are n-number of relational database management system available in market that use SQL which includes Oracle, Sybase, Access, Microsoft SQL Server etc., and SQL is considered as the standard language for interacting with any RDBMS.

Syllabus

Introduction to SQL statements

How to write Basic SQL statements

Restricting and sorting data

Single Row functions

How to display the data from multiple tables

Aggregating data using group functions

Sub Queries

Producing Readable output with iSQL Plus

Creating and managing tables

Manipulating Data

Constraints

Views

Other Database Objects

GROUP BY clause

PL/SQL

PL/SQL is extension of SQL along with the procedural features of programming language. It supports conditional looping, variables and exceptions. It was introduced by Oracle Corporation in early 1990’s to enhance the features of SQL.

Syllabus

Anonymous Block

Functions

Triggers

Packages

Procedures

Array Handling

Various control Statements

Conditional statements