Description
Seller-provided details for this listing.
Oracle 12c SQL and PL/SQL Course Contents
ORACLE 12c SQL
DBMS Concepts
What is Database?
What is Database System?
RDBMS
ORDBMS
Difference Between DBMS, RDBMS & ORDBMS
SQL
What is SQL?
Using SQL*PLUS, Using SQL Developer
SELECT statements
Order by Clause
Distinct Clause
Operators
Comparison Conditions
Where Clause
SINGLE-ROW FUNCTIONS
Describe various types of functions that are available in SQL
Use character, number, and date functions in SELECT statements
Describe the use of conversion functions
Identify the available group functions
GROUP FUNCTIONS
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
JOINS - Displaying Data from Multiple Tables
Access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Cartesian product from two or more tables
SUBQUERIES
What is a subqueries
Types of problems that subqueries can solve
Single-row and multiple-row subqueries
Solve problems with correlated subqueries
DML Statements
Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
DDL Statements
Database objects
Table structure and the data types for columns
Create a table
Creating constraints at the time of table creation
Managing Database Objects with Data Dictionary Views
Other Database Objects
Simple and complex views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms
Regular Expression Functions
REGEXP_LIKE
REGEXP_REPLACE
REGEXP_INSTR
REGEXP_SUBSTR
REGEXP_COUNT
ORACLE 12c PLSQL
Introduction to PL/SQL
Describe t
ORACLE 12c SQL
DBMS Concepts
What is Database?
What is Database System?
RDBMS
ORDBMS
Difference Between DBMS, RDBMS & ORDBMS
SQL
What is SQL?
Using SQL*PLUS, Using SQL Developer
SELECT statements
Order by Clause
Distinct Clause
Operators
Comparison Conditions
Where Clause
SINGLE-ROW FUNCTIONS
Describe various types of functions that are available in SQL
Use character, number, and date functions in SELECT statements
Describe the use of conversion functions
Identify the available group functions
GROUP FUNCTIONS
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause
JOINS - Displaying Data from Multiple Tables
Access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Cartesian product from two or more tables
SUBQUERIES
What is a subqueries
Types of problems that subqueries can solve
Single-row and multiple-row subqueries
Solve problems with correlated subqueries
DML Statements
Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions
DDL Statements
Database objects
Table structure and the data types for columns
Create a table
Creating constraints at the time of table creation
Managing Database Objects with Data Dictionary Views
Other Database Objects
Simple and complex views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms
Regular Expression Functions
REGEXP_LIKE
REGEXP_REPLACE
REGEXP_INSTR
REGEXP_SUBSTR
REGEXP_COUNT
ORACLE 12c PLSQL
Introduction to PL/SQL
Describe t