Curso
Oracle PL SQL Course
In this course we will talk about the Oracle PLSQL, the Oracle is one of the leaders in the database market. With years of industry experience and a solid technology, this database is used in various companies: from those that have little data to multinationals with thousands of terabytes. In this course we will study a key aspect for those who want to begin working with Oracle Database: the PL/SQL language, which is the dialect of the SQL language used to manipulate data. The course is designed for those who never work with any database and is divided into 30 video lessons that address topics such as the installation of the product, views, constraints, indexes, variables, control structures, functions, stored procedure, packages, triggers, and others. Focusing on the novice user, this course provides step by step each of the examples and demos used during the videos, allowing detailed tracking of what is being displayed for all video course lectures to a total of 10 hours.
Esse curso inclui:
Suporte em tempo real
Certificado
Carga horária:
40 horas
(10 aulas)
Aula 1 - Installing the Oracle 11g Express R2
This video shows how to download the Oracle 11g Express R2 from the OTN (Oracle Technology Network) and proceed with the installation.
Aula 2 - Introduction to the Environment
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.
Aula 3 - Working with the basic SELECT Statement
This video shows the basic syntax of the SELECT statement with the FROM clauses.
Aula 4 - Filtering and sorting data
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.
Aula 5 - Single-Row Functions
This video explain the character, number, date, conversion and general categories of functions manipulates the data about Single-Row Functions in Oracle PLSQL.
Aula 6 - Showing data from multiple tables
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.
Aula 7 - Aggregating data
This video explain how to work the aggregation functions AVG(), COUNT(), MAX(), and MIN() in order to obtain a data summary.
Aula 8 - Subqueries
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().
Aula 9 - SQLPlus options
This video shows how to connect to an Oracle instance, work with SQLplus variables, show and set parameters, and run scripts inside SQLPlus.
Aula 10 - Manipulating Data
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.
Veja outros cursos de Canal Mais
T-SQL Step by Step Course
Introduction to MongoDB
Course OLAP with open source tools