Classified listing

Oracle SQL PlSQl Training at FuturePoint

Photos

No photos were provided for this listing.

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