info@unnatisoft.com 040–40182330 9866822330

STRUCTURED QUERY LANGUAGE

STRUCTURED QUERY LANGUAGE

Introduction-Explaining the brief history of SQL

The SELECT Statement

The SELECT Statement

Functions

SQL Clauses

SQL Joins

SQL Joins in detail with Examples

Sub Queries

Data manipulation

Creating and Managing Tables)

Creating Views and Indexes

Transactions Controlling

DB Security

Advanced topics in SQL

SQL and its Dynamic Uses

Improving Performance-Streamlining SQL Statements

Use Views and Retrieve information from the Data Dictionary

Generate SQL Statements

PL/SQL:An Introduction

Transact-SQL:An Introduction

SQL*Plus

Common SQL Mistakes/Errors and Resolutions

PLSQL

Introduction.

Conventions

PLSQL fundamentals

Variables/Program Data

SConditional control and Sequential Control

Loops

DB Interaction

Cursors in PL/SQL

Named Program Units

Triggers

Packages

Calling PL/SQL Functions in SQL

Oracle's Object Oriented Features

Collections

External Procedures

Java Language Integration

Unnatisoft

Your success lies in choosing right learning paths

We maintain a constant check on training activities and trainee progress. Our happiness lies in your success

Contact Us Now

Copyright 2017, UNNATI SOFTWARE TECHNOLOGIES