Batch Date: Jun 25th & 26th @ 9AM - 6PM

Faculty: Mr. Suman

Duration: 2 Days Wrokshop

Location : Madhapur , Hyderabad.

Venue :
DURGA SOFTWARE SOLUTIONS At Madhapur
Plot No : 58, IInd Floor , Sai Nagar,
Madhapur, Hyderabad-500034
Ph.No : 9505905786 

Syllabus:

1.Fundamentals of Database
 DBMS Concepts
 RDBMS Concepts
 Oracle versions
 Features of Oracle 8i/9i/10g/11G/12c
 What is E-R Model?
2. STRUCURE QUERY LANGUAGE( SQL )
 What is SQL?
 Role of SQL in RDBMS
 Sub-languages in SQL
 What is SQL, SQL*PLUS and ISQL*PLUS
 Oracle data types
3. LANGUAGES
Data Definition Language (DDL) Commands
 CREATE
 ALTER (ADD,MODIFY)
 TRUNCATE
 DROP
 RENAME
Data Manipulation Languages(DML) Commands
 INSERT
 UPDATE
 DELETE
 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
 Use Of JOINS
 Types of JOINS (Cross, Equi ,Non Equi, Self and Outer Joins)
7.SUB- QUERIES
 Single row sub-queries
 Multi-row sub-queries
 Correlated Sub-Queries
 Use of EXISTS / NOT EXISTS /ANY
8. SQL OBJECTS
8.1. VIEWS
 What is a view?
 Importance of View.
 Types of Views
 Simple views
 Composite views
 Inline views
 Materialized views
8.2. INDEXES
 What is a INDEX
 Types of Indexes
8.3. SYNONYMS
 Use of Synonym
 Types of Synonyms(PUBLIC,PRIVATE)
 How and when to create synonyms?
8.5. CLUSTERS
 Use of cluster
 Creation of cluster
 Advantages of clusters
8.6. SEQUENCE
 Creating sequence
 Using sequences
9. PARTITIONS
 What is partition
 Types of partition
10. SQL FUNCTIONS
Categories of Functions
 Group or Aggregate Functions
 Scalar or Single Row Functions
Types of Functions
 Numerical Functions
 String Functions
 Conversion Functions
 Date 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
 Data types, Executable Stmts.
 What are the blocks in the program structure?
 DECLARE Block
 BEGIN Block
 EXCEPTION Block
 END
11.1. TYPES OF PROGRAMS
 Static Programs
 Dynamic Programs
 Worked Examples and Assignments
11.2. Type Compatibility keywords
 Declaring variables Dynamically --%TYPE
 Declaring Table Type Record Variables--%ROWTYPE
11.3 SUB PROGRAMS
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
CONDITIONAL STATEMENTS
 Simple IF
 IF—THEN—ELSE
 COMPOUND IF
 ELSIF Construct
 Worked Examples and Assignments
LOOPS
 Simple Loop
 While Loop
 For Loop
CURSORS
 Types: Implicit and Explicit cursors
 Cursor Variables
What is BULK COLLECT?
EXCEPTION HANDLING AND THEIR TYPES
 Predefined Exceptions
 User defined Exceptions
 Pragma_ Exception_init
 RISE_APPLICATION_ERROR
PL/SQL RECORDS AND TABLES
 Composite Data Types
 PL/SQL Records & Tables
 Nested Records
 Using Record in a Table
 And Examples
FUNCTIONS
 What is a Function?
 When we have to create a function?
 How to call it?
 With and without arguments
PL/SQL Collections
 VARRAYS
 RECORDS (user defined)
TRIGGERS
 What is a Trigger Program?
 When we need a Trigger?
 Parts of a Trigger
 Types of Triggers
 Database Triggers
 Row Triggers with Ex.
 Statement Triggers
 Instead-of Triggers - Views with Ex.
PACKAGES
 Structure
 Implementation
 Accessing procedures and functions from a package