Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/swtutori/public_html/tecwallet.com/header_footer_.php on line 4

Warning: mysql_connect(): Headers and client library minor version mismatch. Headers:100618 Library:100505 in /home/swtutori/public_html/tecwallet.com/header_footer_.php on line 4
PL_SQL Online training- Tecwallet

Home » Training ยป PL_SQL Online training

PL_SQL Online training



Course Content

Structured Query Language(SQL)

  • Introduction to SQL
  • Predefined Data Types
  • Introduction to database objects
  • Table,View

 Commands in SQL

  • Data Defination Language(DDL)
  • Data Manipulation Language(DML)
  • Data Control Language(DCL)
  • Transaction Control Language(TCL)
  • Database Security and Privileges(DCL)

 Working with DDL,DML,TCL Commands

  • Operators
  • Conditional,Logical,Comparison,SET
  • Functions
  • Date,Number,Character,String,Group,Group by,Having clause
  • Transformation Functions
  • DECODE,TRANSLATE
  • NVL,NVL2(9i)
  • Aggregate Functions

 Integrity Constraints

  • Different Types of Integrity Constraint
  • Use of Integrity Constraint in table

 Joins

  • Usage of Joins
  • Different Types of Joins
  • Equi Join
  • Cartesian join
  • Self Join
  • Outer join

 Sub Queries

  • Need of Sub Queries
  • Nested Sub queries
  • Co-related Sub Quries
  • Flash Back Queries (9i)

 View

  • Importance of views
  • Creating,Manipulating Views
  • Materialized views(9i)

 Working with database objects

  • Sequences and synonyms
  • Index,Cluster,Creating cluster table

 Using External Tables(9i)

  • System Privileges
  • Table Privileges

 Locks and SQL Plus editor commands 
 PL/SQL

  • Introduction to PL/SQL
  • Advantage of PL/SQL
  • Data Types in PL/SQL
  • Variables and Constants
  • Referencing NON-PL/SQL Variable
  • Using built in Functions
  • Conditional and iterative Statements
  • SQL in PL/SQL
  • Composite Data Types
  • Cursors
  • Exceptions:-Predefined ,User Defined
  • Records and PL/SQl table types

 Advanced PL/SQL

  • Introduction to Triggers
  • Types of Triggers : - Row level,Statement Level
  • Before and After ,Instead of Triggers
  • Procedures,Functions in PL/SQL
  • User Defined Packages
  • Dropping triggers,Procedures,Functions

Leaderboard

RankScoreTime Taken (h:m:s)Student


sql





Featured Courses


Comments ( To Post Your Comment Please Login First! )

$40

Start Date:07/20/2015
End Date:08/20/2015
Organiser: Vish Singh
Category: SQL




Vish Singh  
(7)

Biography
Enrolled Students : 0

Copyright 2016-17 © TecWallet