Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: Mar 8th @ 9:00 AM

Faculty: Mr. Shareef (19+ Yrs of Exp,..)

Duration : 45 Days

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202, IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

ORACLE 19c - (SQL & PL/SQL)

1. Fundamentals of Database

• What is Data Base and Why is Data Base?
• DBMS Concepts
• RDBMS Concepts
• Oracle versions
• What is oracle 12c?
• What is MULTITENANT DATABASE?
• Features in Oracle 12c
• Advantages of Oracle 12c
• What is DATA MODEL for any OLTP RDBMS?

2. STRUCURE QUERY LANGUAGE( SQL ) AND CLIENT TOOLS

• What is SQL?
• Role of SQL in RDBMS
• Sub-languages in SQL
• CLIENT INTERFACE TOOS
• SQL * PLUS
• SQL DEVELOPER
• PLSQL DEVELOPER
• TOAD
• Oracle data types

3. SQL LANGUAGES

Data Definition Language (DDL) Commands
• CREATE
• ALTER
• TRUNCATE
• DROP
• RENAME

Data Manipulation Languages(DML) Commands
• INSERT
• UPDATE
• DELETE

Data Query Language / Retrieval Language
• SELECT

Transaction Control Languages(TCL) Commands
• ROLLBACK
• COMMIT
• SAVEPOINT

Data Control Languages(DCL) Commands
• GRANT
• REVOKE

4. DATA INTEGRITY CONSTRAINTS

• KEY Constraints
• DOMAIN Constraints
• REFERENTIAL INTEGRITY Constraints

5. OPERATORS

• Arithmetic Operators
• Relational Operators
• Relation Negation Operators
• Logical Operators
• Set Operators (Union, Union All, Intersect, Minus)

6. JOINS

• Purpose Of JOINS

• Types of JOINS

• Cross join
• Equi join
• Inner Join
• Self Join
• Outer joins
  • left Outer join
  • Right Outer join
  • Full Outer join