UNISOL
SYLLABUS
MY-SQL

Introduction to DBMS                   

  • What is DBMS

  • Relational Data Models

  • Data integrity rules

  • Normalization

  • Oracle Architecture

SQL                      

  • Creating Tables

  • Integrity Constraints

  • Adding, updating and dropping columns

  • Transaction and locking

  • Functions

  • Grouping data

  • Using ROLLUP and CUBE

  • Joining tables

  • ANSI Join

  • Sub queries

  • Views

  • Materialized Views

  • SQL performance tuning

  • Using indexes and clusters

  • Report generation using SQL*Plus commands

OOPS in Oracle

  • Why should objects be used ?

  • Object types

  • Features of objects

  • Implementing object views and its benefits

  • Nested tables

  • Variable arrays

  • Referencing objects

PL/SQL Programming

  • What is PL/SQL

  • Structure of PL/SQL block

  • Control statement

  • CASE expression

  • Exception handling

  • Cursor handling

  • PL/SQL Database objects

  • Writing stored procedures and functions

  • Overloading procedures and functions

  • Autonomous transactions

  • Oracle Packages

  • Database triggers

  • Native dynamic SQL

  • MERGE statement

  • Multitable insert

  • PL/SQL Security

  • Using Regular Expressions