-
WhatsApp + 91-9999487949
-
Send Email info@softapptechnologies.com
-
Office No-51/3, 1st floor, Corenthum tower-B, near electronic city metro station, Sector 62, Noida, Uttar Pradesh 201309
Oracle Training Course
Oracle Corporation is an integrated technology company based in Austin, Texas. Oracle offers a collection of cloud technologies, applications, databases, storage and servers to empower modern business. Oracle was founded by Larry Ellison in 1977.
Oracle is a computer technology corporation best known for its software products and services like Java. Through the company's four main business segments—cloud and license, hardware, and services—Oracle sells its cloud-engineering services and systems and database management systems.
Oracle is a computer technology corporation best known for its software products and services like Java. Through the company's four main business segments—cloud and license, hardware, and services—Oracle sells its cloud-engineering services and systems and database management systems.
Introduction Database
Understanding DBMS vs RDBMS
Operators in Oracle
Gone through SQL Standards
Sub languages of SQL
Installation of 12c
About SQL*Plus and use of developer tool
Datatypes in Oracle
Difference between 10g vs 11g vs 12c
Understanding Schema design and objects
Understanding DBMS vs RDBMS
Operators in Oracle
Gone through SQL Standards
Sub languages of SQL
Installation of 12c
About SQL*Plus and use of developer tool
Datatypes in Oracle
Difference between 10g vs 11g vs 12c
Understanding Schema design and objects
Table creation using CREATE statement
Creating table from another table
Renaming the column of a table
Dropping a table using DROP command
Modifying the column datatype in a table
Altering the column of a table
Renaming an entire table
Using truncate command
Difference between Delete and Truncate command
Creating table from another table
Renaming the column of a table
Dropping a table using DROP command
Modifying the column datatype in a table
Altering the column of a table
Renaming an entire table
Using truncate command
Difference between Delete and Truncate command
How to add constraints to an existing table?
How to declare column level constraints?
Types of integrity constraints
--Not null
--Unique key
--Primary key
--Check integrity
--Referential integrity
How to declare row level constraints
How to enable and disable constraints
How to get information about constraints
How to declare column level constraints?
Types of integrity constraints
--Not null
--Unique key
--Primary key
--Check integrity
--Referential integrity
How to declare row level constraints
How to enable and disable constraints
How to get information about constraints
How to use select statement in different ways to retrieve records?
Working with Column alias
Clauses and its types in oracle
Working with Table alias
--Where clause
--Using clause
--Having clause
--From clause
--Order by clause
--Group by clause
--Constraint clause
--For update clause
Data filtering and sorting with in single table
Working with Column alias
Clauses and its types in oracle
Working with Table alias
--Where clause
--Using clause
--Having clause
--From clause
--Order by clause
--Group by clause
--Constraint clause
--For update clause
Data filtering and sorting with in single table
Different types of inserting row to an existing table
How to copy data from one table to another table
Deleting a particular record from a table
Using merge & insert all command
How to copy the structure alone from a table?
Updating any value of with in a record using UPDATE command
How to copy data from one table to another table
Deleting a particular record from a table
Using merge & insert all command
How to copy the structure alone from a table?
Updating any value of with in a record using UPDATE command
Working with group by clause
Working with having clause
Max()
Count()
Sum()
Avg()
Min()
Difference between WHERE and HAVING clause
Working with having clause
Max()
Count()
Sum()
Avg()
Min()
Difference between WHERE and HAVING clause
Working with pseudo columns using the following
ROWID
ROWNUM
How to use set operators in a single table content
Working with set operator types
UNION
UNION ALL
INTERSECT
MINUS
ROWID
ROWNUM
How to use set operators in a single table content
Working with set operator types
UNION
UNION ALL
INTERSECT
MINUS
Working with data query language using TCL
How to create users and roles
Use of commit and rollback
How to give system privileges to an user
Use of savepoint and set transaction
How to invoke and revoke object privileges
Working with data control language commands
How to create users and roles
Use of commit and rollback
How to give system privileges to an user
Use of savepoint and set transaction
How to invoke and revoke object privileges
Working with data control language commands
Informal introduction to PL/SQL
Program structure of PL/SQL
Advantages of PL/SQL
Embedding SQL statements
Datatypes in PL/SQL
Using conditional statements and loops
Program structure of PL/SQL
Advantages of PL/SQL
Embedding SQL statements
Datatypes in PL/SQL
Using conditional statements and loops
Using DML trigger & DDL trigger
How to create triggers
Benefits of trigger
How to trigger a trigger
What are database level trigger
How to audit database using triggers
How to create triggers
Benefits of trigger
How to trigger a trigger
What are database level trigger
How to audit database using triggers