Oracle Database Syllabus

 Introduction to Oracle DB


  What is Oracle, Version history and different editions
 Basic Features Components and Tools
  Starting and Stopping Oracle Instances / Services

 Building the Database Schema


 Creating tables and columns
 Building tables with CREATE TABLE
 Modifying table structure with ALTER TABLE
 Adding columns to an existing table
 Removing tables with DROP TABLE

 Working with Constraints


 Unique
 Not NULL
 Primary Key
  Default Check Foreign Key
 Datatypes in SQL Server

 Working with Queries (DQL)


 Understanding Select Statement
 Usage of Top, Distinct, Null etc...keywords
 Using String and Arithmetic Expressions
 Exploring Where Clause with Operators
 Using Advanced Operators
 Sorting data using Order By clause
 Working with basic of Sub Queries

 Aggregate Functions


 Using functions in Queries
 Count, Sum, Min, Max, Avg Group By and Having Clause
 Using Group By with Rollup and Cube

 Joins and Set Operations


 Introduction to Joins - Cross Joins
 Inner Join
 Outer Join
 Self Join
 Co-related Sub Queries
 Set Operations using Unions, Intersect and Except

 Implementing Views


 Introduction & Advantages of Views
 Creating, Altering, Dropping Views
 Advance Options while Creating a View

 Data Control language (DCL)


 Creating Users & Roles
 Granting & Revoking of Roles & privileges

 Working with Stored Procedures and Functions


 Introduction to stored procedures
 Benefits of Stored Procedures
 Creating, Executing Modifying, Dropping
 Input–Output and Optional Parameters
 System defined SP’s and Functions.
 User defined Functions

 Implementing Triggers


 Introduction to triggers
 Constraints vs Triggers
 Creating, Altering, Dropping triggers
 for/after/instead of triggers

 Working with Cursors


 Creating Cursors
 Cursors vs. Select
 Types of cursors
 Locks on cursors
 Advantages of cursors



For more details, feel free to contact us!

Send A Message

Send Message

Contact Information

  • kambojrohit42@gmail.com
  • +91 9897783223