Term Archives

  1. SQL Server Backup and Recovery Database is used to store data that are has some importance for us.This training lesson covers the important topic of full SQL Server Backup and Recovery.
  2. SQL Server Database objects In this training course you learn about SQL Server Database objects , SQL Server Database objects are Used to monitor activity in running an instance of SQL Server. Object is simply any server resource. Example- Window process and server lock.
  3. SQL Server Architecture SQL server Architecture provide you depth detail about servers architecture, In detail How they work,parts,layer and many more things.SQL is just a query language,not a database. To perform SQL query,we need to install database. example PostGre SQL, MySql, SQL Server. In this SQL training course we discuss about SQL Server.
  4. PL/SQL - Exception Handling In PLSQL-Exception Handling an error condition during a program execution is called an exception.PL/SQL provide a feature to handle these type error which is called PLSQL-Exception Handling ,Using exception handling you can avoid it from exiting.Here you learn how to handle all error for better error free programming.  
  5. PLSQL - Collections A plsql-collections is an  ordered groups of elements having the same data types,Each element have unique subscript that represent its position. In PL/SQL three collection types: Nested table Index-by tables or Associative array Variable- Size array or Varry
  6. PL/SQL - Triggers PLSQL-Triggers is a stored programmer,which is executed when a DML statement like insert,Update and delete is executed on db table. PLSQL-Triggers have benefits like: Auditing Generating some derived column values automatically Synchronous replication of table Event logging and storing information on table access Imposing security authorizations Enforcing referential integrity
  7. PL/SQL - Cursors In PL/SQL Oracle creates a memory are that is known as a context area,for processing an SQL statement.Contain all information needed for processing the statement,A PLSQL Cursors is a pointer to the context area. There are two type PLSQL Cursors : Implicit cursors Explicit cursors  
  8. PL/SQL - Functions In this training course lesson you will learn about PLSQL-Functions ,how to create,why?.A PLSQL-Functions is a named block,similar to procedural. Main difference between procedures and function is procedures may or not may be return value but a function always returns value, we have to type returns  type.





Skip to toolbar
  • USA : +1-(917) 328-1140
  • UK : +44-(773) 940-0806
  • INDIA : +91-(779) 205-1814
  • KUWAIT : +965-(514) 31-431
  • DUBAI : +971-(557) 964-969
  • MALAYSIA : +91-(779) 205-1814
  • AUSTRAILIA : +91-(779) 205-1814