Description
Seller-provided details for this listing.
Oracle 11g SQL and PL/SQL Course Contents
ORACLE 11g 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 private and public synonyms
Regular Expression Functions
REGEXP_REPLACE
ORACLE 11g PLSQL
Introduction to PL/SQL
Describe the need for PL/SQL
Visit www.futurepointtech.com for course curriculum
http://www.futurepointtech.com/oracle-11g-sql-pl-sql-
ORACLE 11g 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 private and public synonyms
Regular Expression Functions
REGEXP_REPLACE
ORACLE 11g PLSQL
Introduction to PL/SQL
Describe the need for PL/SQL
Visit www.futurepointtech.com for course curriculum
http://www.futurepointtech.com/oracle-11g-sql-pl-sql-