Oracle PL SQL Course

This video shows how to download the Oracle 11g Express R2 from the OTN (Oracle Technology Network) and proceed with the installation.

This video shows how to download, extract and use the SQL Developer tool in order to understand how to work with the scripts through the course.

This video shows the basic syntax of the SELECT statement with the FROM clauses.

In this video we will see some examples of the operators AND, OR and NOT to control how more than one filter can be used to filter the rows in a SELECT statement.

This video explain the character, number, date, conversion and general categories of functions manipulates the data about Single-Row Functions in Oracle PLSQL.

This video explain how to use more than one table on the SELECT statetment via aliases and how to perform simple joins in the tables of the sample HR schema provided by Oracle.

This video explain how to work the aggregation functions AVG(), COUNT(), MAX(), and MIN() in order to obtain a data summary.

The video explain the context, the details, the requirements and the usage of subqueries with aggregated functions and with the operators IN(), ANY(), and ALL().

This video shows how to connect to an Oracle instance, work with SQLplus variables, show and set parameters, and run scripts inside SQLPlus.

This video shows examples of how to insert the data with and without the columns names, how to update the values of columns with the UPDATE statement and how to remove some rows of the tables with the DELETE statement.