Search results
06/04/2014
Video tutorial
Managing dependencies - Oracle PL SQL Course - Lesson 35
This video explain the scenarios and situations where object dependency is an issue in Oracle and provide some examples that show how an object can be invalid because of a broken chain on dependency.
05/26/2014
Video tutorial
Table Statistics - Oracle PL SQL Course - Lesson 31
This video explain how are statistics and histograms and how why they are important. The examples show how to gather the statistics using the ANALYZE command and check the blocks size allocation in the DBA_TABLES and the DBA_INDEXES views.
05/14/2014
Video tutorial
Triggers - Oracle PL SQL Course - Lesson 28
This video explain the trigger concept and show the details of timming, event, type, when clause, firing sequence, :NEW and :OLD qualifiers, and the internal DELETING, INSERTING and UPDATING variables.
04/29/2014
Video tutorial
Creating Functions - Oracle PL SQL Course - Lesson 24
This video will discuss the details about the creation of functions in Oracle: the differences from procedures, the type of return values, what can and cannot be inside a function, the parameters types and how to execute the functions.
04/29/2014
Video tutorial
Creating procedures - Oracle PL SQL Course - Lesson 23
This video discuss about the following advantages of procedures in Oracle: modularity, reusability, extensibility, maintainability, data security, integrity, improved performance and code clarity.
03/27/2014
Video tutorial
Control Structures - Oracle PL SQL Course - Lesson 19
This video shows how to use the IF, ELSE, ELSEIF, CASE, LOOP, WHILE and FOR statements inside a PL/SQL block by explaining the purpose, the syntax and how these commands can be used in very simple examples.
03/26/2014
Video tutorial
Custom Filter - Introduction to Angular JS Course - Part 7
In this video we will dive deeper into filters by creating our own. We will use the module to build our own filter and create a filter called canDrive, which will use the age of a person to decide whether this person can or cannot drive.