Oracle 19C - (SQL & PL/SQL)
Oracle 19C - (SQL & PL/SQL)
Oracle 19C - (SQL & PL/SQL)
Courses
SCJP SCWCD Design patterns EJB CORE JAVA AJAX Adv. Ja
Offered:
Duration : 45 Days
Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202, IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.
Syllabus:
http://durgasoft.com/Oracle19C-Dinesh-Online.asp 1/8
6/26/2021 DURGA SOFTWARE SOLUTIONS
• 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?
• 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
• 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
7. SUB - QUERIES
8. SQL OBJECTS
http://durgasoft.com/Oracle19C-Dinesh-Online.asp 3/8
6/26/2021 DURGA SOFTWARE SOLUTIONS
8.1. VIEWS
• What is a view?
• Importance of View.
• Types of Views
• Simple views
• Composite views
• Inline views
• Materialized views
• Force views
8.2. INDEXES
• What is a INDEX
• Necessity of Index
• Types of Indexes
Simple Index
Composite Index
Bitmap Index
Function based index
8.3. CLUSTERS
• Use of cluster
• Creation of cluster
• Advantages of clusters
8.4. SEQUENCES
• Creating sequence
• Uses of sequences
http://durgasoft.com/Oracle19C-Dinesh-Online.asp 4/8
6/26/2021 DURGA SOFTWARE SOLUTIONS
8.5. SYNONYMS
• Use of Synonym
• Types of Synonyms(PUBLIC,PRIVATE)
• How and when to create synonyms?
9. PARTITIONS
• What is partition?
• Types of partitions
Range partition
List partition
Hash partition
Categories of Functions
• Group or Aggregate Functions
• Scalar or Single Row Functions
Types of Functions
• Numerical Functions
• String Functions
• Conversion Functions
• Date Functions
• Analytical functions
11. PL/SQL
• Introduction to PL/SQL
• What is a Program block?
• Advantages of PL/SQL.
• Architecture of PL/SQL Engine
• Features, Structure of Program Block
http://durgasoft.com/Oracle19C-Dinesh-Online.asp 5/8
6/26/2021 DURGA SOFTWARE SOLUTIONS
• Static Programs
• Dynamic Programs
• Worked Examples and Assignments
Stored Procedures
• What is a procedure?
• How to create it?
• What are the advantages of procedures?
• Types of stored procedures
• Static Procedures (without Arguments)
• Dynamic Procedures (with Arguments)
• Arguments or Parameters Mode
• IN OUT INOUT
CONTOL STRUCTURES
CONDITIONAL STATEMENTS
• Simple IF
• IF—THEN—ELSE
• COMPOUND IF
• ELSIF Construct
• Worked Examples and Assignments
LOOPS
• Simple Loop
http://durgasoft.com/Oracle19C-Dinesh-Online.asp 6/8
6/26/2021 DURGA SOFTWARE SOLUTIONS
• While Loop
• For Loop
CURSORS
• Types: Implicit and Explicit cursors
• Cursor Variables
• FOR loop cursor
• Parameterized cursor
• REF_CURSOR
FUNCTIONS
• What is a Function?
• When we have to create a function?
• How to call it?
• With and without arguments
PL/SQL Collections
• VARRAYS
• Associative Arrays
• Nested tables/ PLSQL TABLES
TRIGGERS
• What is a Trigger Program?
• When we need a Trigger?
http://durgasoft.com/Oracle19C-Dinesh-Online.asp 7/8
6/26/2021 DURGA SOFTWARE SOLUTIONS
• Parts of a Trigger
• Types of Triggers
• Database Triggers
• Row Level Triggers with Ex.
• Statement Level Triggers
• Instead-of Triggers - Views with Ex.
PACKAGES
• What is a PACKAGE?
• Structure of package
• Package Spec and Body
• Accessing procedures and functions from a package
Supporting
Interview Tips
Interview Questions
Resume Preparation tips
Durgasoft
11,331 likes
http://durgasoft.com/Oracle19C-Dinesh-Online.asp 8/8