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.
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.
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.
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
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
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
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.