Share this program with friends or teammates.
Duration: 40H
Category: Database
Type: Database
Topics and modules covered in oracle
Introduction Database
Understanding DBMS vs RDBMS
Gone through SQL Standards
Sub languages of SQL
Difference between 10g vs 11g vs 12c
Installation of 12c
About SQL*Plus and use of developer tool
Datatypes in Oracle
Operators in Oracle
Understanding Schema design and objects
How to use select statement in different ways to retrieve records?
Working with Column alias
Working with Table alias
Data filtering and sorting with in single table
Clauses and its types in oracle
Where clause
Having clause
From clause
Group by clause
Order by clause
Using clause
Constraint clause
For update clause
Table creation using CREATE statement
Creating table from another table
Dropping a table using DROP command
Altering the column of a table
Modifying the column datatype in a table
Renaming the column of a table
Renaming an entire table
Using truncate command
Difference between Delete and Truncate command
How to copy data from one table to another table?
How to copy the structure alone from a table?
Different types of inserting row to an existing table
Updating any value of with in a record using UPDATE command
Deleting a particular record from a table
Using merge & insert all command
How to declare column level constraints?
How to declare row level constraints ?
How to add constraints to an existing table?
Types of integrity constraints
Not null
Unique key
Primary key
Referential integrity
Check integrity
Understanding Single row functions
How to use single row functions using dummy table?
Types of single row functions
String functions
Date functions
Mathematical functions
Conversion functions
Special functions
Analytical functions
Working with multi row functions
Working with aggregate function
Count()
Sum()
Max()
Min()
Avg()
Working with group by clause
Working with having clause
Difference between WHERE and HAVING clause
Understanding joins and its uses
Types of joins
Equi join
Non ? equi join
Self join
Outer join
Left & Right outer join
Full outer join
Cross join
How to use set operators in a single table content?
Working with set operator types
UNION
UNION ALL
INTERSECT
MINUS
Importance of sub queries
Using different types of sub queries
Single row sub queries
Multi row sub queries
Nested queries
Multi column sub queries
Correlated sub queries
Creating and working with Views
Working with Synonyms
Creating Index and clusters
Working with in materialized view
Understanding sequences and its types
Informal introduction to PL/SQL
Advantages of PL/SQL
Datatypes in PL/SQL
Program structure of PL/SQL
Embedding SQL statements
Using conditional statements and loops
Creating And Using Cursors
Understanding Exception Handling
Creating & Using Functions
Creating & Using Packages
Triggers In PL/SQL
Collections In PL/SQL
