oracle-training-westdelhi

Professional Oracle Training



Programme Outcome:

SQL
Introduction to Oracle Database
  • Basic of relational database
  • Different types of SQL statements
  • SQL SELECT Statement
  • List the capabilities of SQL SELECT statements
  • Select All Columns
  • Select Specific Columns
  • Arithmetic Operators and Operator Precedence
  • Restrict and Sort Data
  • Describe WHERE clause
  • Comparison operators and logical operators
  • Describe ORDER BY clause
  • Single-Row Functions
  • Differences between single row and multiple row functions
  • String manipulation functions
  • Describe ROUND, TRUNC, and MOD functions
  • Arithmetic with date
  • Manipulate dates with the DATE functions
  • Conversion Functions and Conditional
  • Describe TO_CHAR and TO_DATE functions
  • Handle NULL values
  • Use conditional IF THEN ELSE logic in a SELECT statement
  • Group Functions – Aggregate the data
  • Describe the use of the aggregation functions
  • Describe GROUP BY clause
  • Describe HAVING clause
  • Joins – Get data from multiple tables
  • Access data from more than one table
  • Type of joins – Self joins, Outer joins, equi joins
  • Sub-queries
  • Describe the types of problem that sub-queries can solve
  • Describe sub-queries
  • List the types of sub-queries
  • Explain single-row and multiple-row sub-queries
  • SET Operators in Oracle
  • Describe the SET operators
  • Control the ordering

    Data Manipulation Statements
  • Describe different type of DML statement
  • Describe INSERT statement
  • Describe UPDATE statement
  • Describe DELETE statement
  • Describe COMMIT and
  • ROLLBACK statements
  • Explain read consistency
  • DDL Statements - Create and Manage Tables
  • Categorize the main database objects
  • Review the table structure
  • List the data types
  • Add constraints to the table
  • Schema Objects in Oracle
  • Simple and Complex view
  • Retrieve data from views
  • Explain Sequences
  • Explain Indexes
  • Explain Synonyms
  • Control User Access
  • Type of privileges - system
  • privileges and object privileges
  • Describe Users and Roles
  • Grant System Privileges
  • Grant Object Privileges
  • How to pass on privileges
  • Revoke Object Privileges
  • Schema Objects management
  • Add, Modify, and Drop a Column
  • Add, Drop, and Defer a Constraint
  • Enable and Disable a Constraint?
  • Flashback
  • Data Dictionary Views
  • Data dictionary - Overview
  • USER_OBJECTS and ALL_OBJECTS Views
  • Query the dictionary views for constraint
  • information
  • Data Dictionary Views
  • Data dictionary - Overview
  • USER_OBJECTS and ALL_OBJECTS Views
  • Query the dictionary views for constraint
  • information
  • PLSQL
  • Introduction to PL/SQL
  • Overview
  • Simple Anonymous Block
  • PL/SQL Identifiers
  • Types of Identifiers
  • Declarative Section
  • Variables
  • Data Types
  • %TYPE Attribute
  • Bind Variables
  • Executable Statements
  • Basic PL/SQL Block
  • Nested Blocks
  • Operators in PL/SQL
  • Interaction with the Oracle Server
  • SELECT Statements in PL/SQL
  • Retrieve Data in PL/SQL
  • SQL Cursor
  • SQL Cursor Attributes
  • Control Structures
  • Conditional processing using IF Statements and CASE Statements
  • Type of Loops - simple Loop, While Loop, For Loop
  • Continue Statement
  • Composite Data Types
  • PL/SQL Records and %ROWTYPE Attribute
  • DML using PL/SQL Records
  • INDEX BY Tables
  • INDEX BY Table of Records
  • Explicit Cursors
  • Overview
  • Declare, Open, Fetch and Close the Cursor
  • Cursor FOR loop
  • The %NOTFOUND and %ROWCOUNT Attributes
  • FOR UPDATE Clause and WHERE CURRENT Clause
  • Exception
  • Exceptions - Overview
  • Predefined and Non-Predefined Oracle Server Errors
  • User-Defined Exceptions
  • Propagate Exceptions
  • RAISE_APPLICATION_ERROR Procedure
  • Procedures
  • Overview
  • Benefits of using PL/SQL Subprograms
  • Differences between Anonymous Blocks and Subprograms
  • Create, Call, and Remove Stored Procedures
  • Procedures Parameters and Parameters Modes
  • Functions
  • Overview
  • Create, Call, and Remove a Stored Function
  • Advantages of using Stored Functions
  • Invoke User-Defined Functions in SQL
  • Restrictions when calling Functions
  • How to debug Functions and Procedures?
  • Packages
  • Overview
  • Overview and advantages of Packages
  • Develop a Package
  • Package Specification and Body
  • Invoke the Package Constructs
  • Overloading Subprograms in PL/SQL
  • Forward Declarations
  • Examples of some of the Oracle-Supplied Packages
  • DBMS_OUTPUT, UTL_FILE Packages
  • Dynamic SQL
  • Execution Flow of SQL
  • Dynamically Executing a PL/SQL Block
  • Configure Native Dynamic SQL to Compile PL/SQL Code
  • DBMS_SQL Package
  • EXECUTE IMMEDIATE
  • Triggers
  • Overview
  • Trigger Event Types and Body
  • Identify the Trigger Event Types, Body, and Timing
  • Statement Level and Row Level Triggers
  • Instead of Triggers
  • DDL Triggers
  • Database-Event and System-Events Triggers
  • Manage Dependencies
  • Overview
  • USER_DEPENDENCIES View
  • Invalidation of Dependent Objects
  • Display the Direct and Indirect Dependencies
  • Understand Remote Dependencies
  • Duration:30 Hours

    >Week Days(Monday-Friday): 1.5 Hour/day

    Weekends(Saturday-Sunday): 2.5 Hour/day




    Quick Enquiry