DATABASE PACKAGES

  • Eligibility
    1. candidate should have 60% through out his/her academics
    2. should have good communication skills
  • TOPICS

    1. PL/SQL Syllabus
      • Introduction
        1. Course Objectives
        2. Course Agenda
        3. Describe the Human Resources (HR) Schema
        4. PL/SQL development environments available in this course
        5. Introduction to SQL Developer
      • Introduction to PL/SQL
        1. Overview of PL/SQL
        2. Identify the benefits of PL/SQL Subprograms
        3. Overview of the types of PL/SQL blocks
        4. Create a Simple Anonymous Block
        5. How to generate output from a PL/SQL Block?
      • Declare PL/SQL Identifiers
        1. List the different Types of Identifiers in a PL/SQL subprogram
        2. Usage of the Declarative Section to Define Identifiers
        3. Use variables to store data
        4. Identify Scalar Data Types
        5. The %TYPE Attribute
        6. What are Bind Variables?
        7. Sequences in PL/SQL Expressions
      • Operating System Fundamentals
        1. Personal Computer Operating Systems
        2. Windows User Interface Components
        3. Windows File System Management
        4. Windows System Management Tools
      • Write Executable Statements
        1. Describe Basic PL/SQL Block Syntax Guidelines
        2. Learn to Comment the Code
        3. Deployment of SQL Functions in PL/SQL
        4. How to convert Data Types?
        5. Describe Nested Blocks
        6. Identify the Operators in PL/SQL
      • Interaction with the Oracle Server
        1. Invoke SELECT Statements in PL/SQL
        2. Retrieve Data in PL/SQL
        3. SQL Cursor concept
        4. Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
        5. Data Manipulation in the Server using PL/SQL
        6. Understand the SQL Cursor concept
        7. Use SQL Cursor Attributes to Obtain Feedback on DML
        8. Save and Discard Transactions
      • Control Structures
        1. Conditional processing using IF Statements
        2. Conditional processing using CASE Statements
        3. Describe simple Loop Statement
        4. Describe While Loop Statement
        5. Describe For Loop Statement
        6. Use the Continue Statement
      • Composite Data Types
        1. Use PL/SQL Records
        2. The %ROWTYPE Attribute
        3. Insert and Update with PL/SQL Records
        4. INDEX BY Tables
        5. Examine INDEX BY Table Methods
        6. Use INDEX BY Table of Records
      • Explicit Cursors
        1. What are Explicit Cursors?
        2. Declare the Cursor
        3. Open the Cursor
        4. Fetch data from the Cursor
        5. Close the Cursor
        6. Cursor FOR loop
        7. The %NOTFOUND and %ROWCOUNT Attributes
        8. Describe the FOR UPDATE Clause and WHERE CURRENT Clause
      • Exception Handling
        1. Understand Exceptions
        2. Handle Exceptions with PL/SQL
        3. Trap Predefined Oracle Server Errors
        4. Trap Non-Predefined Oracle Server Errors
        5. Trap User-Defined Exceptions
        6. Propagate Exceptions
        7. RAISE_APPLICATION_ERROR Procedure
      • Stored Procedures
        1. Create a Modularized and Layered Subprogram Design
        2. Modularize Development With PL/SQL Blocks
        3. Understand the PL/SQL Execution Environment
        4. List the benefits of using PL/SQL Subprograms
        5. List the differences between Anonymous Blocks and Subprograms
        6. Create, Call, and Remove Stored Procedures
        7. Implement Procedures Parameters and Parameters Modes
        8. View Procedure Information
      • Stored Functions and Debugging Subprograms
        1. Create, Call, and Remove a Stored Function
        2. Identify the advantages of using Stored Functions
        3. Identify the steps to create a stored function
        4. Invoke User-Defined Functions in SQL Statements
        5. Restrictions when calling Functions
        6. Control side effects when calling Functions
        7. View Functions Information
        8. How to debug Functions and Procedures?
      • Packages
        1. Listing the advantages of Packages
        2. Describe Packages
        3. What are the components of a Package?
        4. Develop a Package
        5. How to enable visibility of a Package’s Components?
        6. Create the Package Specification and Body using the SQL CREATE Statement and SQL Developer
        7. Invoke the Package Constructs
        8. View the PL/SQL Source Code using the Data Dictionary
      • Deploying Packages
        1. Overloading Subprograms in PL/SQL
        2. Use the STANDARD Package
        3. Use Forward Declarations to solve Illegal Procedure Reference
        4. Implement Package Functions in SQL and Restrictions
        5. Persistent State of Packages
        6. Persistent State of a Package Cursor
        7. Control side effects of PL/SQL Subprograms
        8. Invoke PL/SQL Tables of Records in Packages
      • Implement Oracle-Supplied Packages in Application Development
        1. What are Oracle-Supplied Packages?
        2. Examples of some of the Oracle-Supplied Packages
        3. How does the DBMS_OUTPUT Package work?
        4. Use the UTL_FILE Package to Interact with Operating System Files
        5. Invoke the UTL_MAIL Package
        6. Write UTL_MAIL Subprograms
      • Dynamic SQL
        1. The Execution Flow of SQL
        2. What is Dynamic SQL?
        3. Declare Cursor Variables
        4. Dynamically Executing a PL/SQL Block
        5. Configure Native Dynamic SQL to Compile PL/SQL Code
        6. How to invoke DBMS_SQL Package?
        7. Implement DBMS_SQL with a Parameterized DML Statement
        8. Dynamic SQL Functional Completeness
      • Design Considerations for PL/SQL Code
        1. Standardize Constants and Exceptions
        2. Understand Local Subprograms
        3. Write Autonomous Transactions
        4. Implement the NOCOPY Compiler Hint
        5. Invoke the PARALLEL_ENABLE Hint
        6. The Cross-Session PL/SQL Function Result Cache
        7. The DETERMINISTIC Clause with Functions
        8. Usage of Bulk Binding to Improve Performance
      • Triggers
        1. Describe Triggers
        2. Identify the Trigger Event Types and Body
        3. Business Application Scenarios for Implementing Triggers
        4. Create DML Triggers using the CREATE TRIGGER Statement and SQL Developer
        5. Identify the Trigger Event Types, Body, and Firing (Timing)
        6. Differences between Statement Level Triggers and Row Level Triggers
        7. Create Instead of and Disabled Triggers
        8. How to Manage, Test and Remove Triggers?
      • Creating Compound, DDL, and Event Database Triggers
        1. What are Compound Triggers?
        2. Identify the Timing-Point Sections of a Table Compound Trigger
        3. Understand the Compound Trigger Structure for Tables and Views
        4. Implement a Compound Trigger to Resolve the Mutating Table Error
        5. Comparison of Database Triggers to Stored Procedures
        6. Create Triggers on DDL Statements
        7. Create Database-Event and System-Events Triggers
        8. System Privileges Required to Manage Triggers
      • PL/SQL Compiler
        1. What is the PL/SQL Compiler?
        2. Describe the Initialization Parameters for PL/SQL Compilation
        3. List the new PL/SQL Compile Time Warnings
        4. Overview of PL/SQL Compile Time Warnings for Subprograms
        5. List the benefits of Compiler Warnings
        6. List the PL/SQL Compile Time Warning Messages Categories
        7. Setting the Warning Messages Levels: Using SQL Developer, PLSQL_WARNINGS Initialization Parameter, and the DBMS_WARNING Package Subprograms
        8. View Compiler Warnings: Using SQL Developer, SQL*Plus, or the Data Dictionary Views
      • Manage PL/SQL Code
        1. What Is Conditional Compilation?
        2. Implement Selection Directives
        3. Invoke Predefined and User-Defined Inquiry Directives
        4. The PLSQL_CCFLAGS Parameter and the Inquiry Directive
        5. Conditional Compilation Error Directives to Raise User-Defined Errors
        6. The DBMS_DB_VERSION Package
        7. Write DBMS_PREPROCESSOR Procedures to Print or Retrieve Source Text
        8. Obfuscation and Wrapping PL/SQL Code
      • Manage Dependencies
        1. Overview of Schema Object Dependencies
        2. Query Direct Object Dependencies using the USER_DEPENDENCIES View
        3. Query an Object’s Status
        4. Invalidation of Dependent Objects
        5. Display the Direct and Indirect Dependencies
        6. Fine-Grained Dependency Management in Oracle Database 11g
        7. Understand Remote Dependencies
        8. Recompile a PL/SQL Program Unit
    1. MS Sql Syllabus
      • SQL Server 2005

          Overview of SQL Server 2005

        1. Introduction to SQL Server 2005
          1. Role of a Database Server
          2. SQL Server 2005 Components
          3. The .NET Framework
          4. Features of SQL Server 2005
          5. SQL
        2. Identifying SQL Server 2005 Tools
          1. SQL Server Management Studio
          2. SQL Server Business Intelligence Development Studio
          3. Database Engine Tuning Advisor
          4. SQL Server Configuration Manager
          5. SQL

        3. Querying Data

        4. Retrieving Data
          1. Identifying Data types
          2. Retrieving Specific Attributes
          3. Retrieving Selected Rows
        5. Using Functions to Customize the Result Set
          1. Using String Functions
          2. Using Date Functions
          3. Using Mathematical
          4. Using System Functions
        6. Summarizing and Grouping Data
          1. Summarizing Data by Using Aggregate Functions
          2. Grouping Data

        7. Querying Data Using Joins and Sub Queries

        8. Querying Data By Using Joins
          1. Using an Inner Join
          2. Using an Outer Join
          3. Using a Cross Join
          4. Using a Self Join
          5. SQL

        9. Managing Databases and Tables

        10. Managing Databases
          1. Identifying the System Databases in SQL Server 2005
          2. Identifying the Database Files
          3. Creating a User-Defined Databases
          4. Renaming a User-Defined Databases
          5. Dropping a User-Defined Databases
        11. Managing Tables
          1. Creating a Table
          2. Implementing Data Integrity
          3. Creating a Partitioned Table
          4. Modifying a Table
          5. Renaming a Table
          6. Dropping a Table

        12. Manipulating Data in Tables

        13. Manipulating Data by Using DML Statements
          1. Storing Data in a Table
          2. Updating Data in a Table
          3. Deleting Data from a Table
        14. Manipulating the XML Data
          1. oStoring XML Data in a Table
          2. Retrieving the XML Data from the Table
          3. Modifying the XML Data

        15. Implementing Indexes, Views and Full Text Search

        16. Creating and Managing Indexes
          1. Identifying the Types of Indexes
          2. Creating Indexes
          3. Creating XML Indexes
          4. Managing Indexes
        17. Creating and Managing Views
          1. Creating Views
          2. Indexing Views
          3. Managing Views
        18. Implementing Full-Text Search
          1. Configuring Full-Text Search
          2. Searching Data by Using a Full-Text Search

        19. Implementing Stored Procedures and Functions

        20. Implementing Batches
          1. Creating Batches
          2. Using Constructs
          3. Handling Errors and Exceptions
        21. Implementing Stored Procedures
          1. Creating Stored Procedures
          2. Creating Parameterized Stored Procedures
          3. Returning Values from Stored Procedures
          4. Calling a Procedure from Another Procedure
        22. Implementing Functions
          1. o Creating UDFs

        23. Working with Triggers and Transactions

        24. Implementing Triggers
          1. o Identifying Types of Triggers
          2. Creating Triggers
          3. Managing Triggers

        25. Implementing Managed Code

        26. Understanding Managed Code
          1. Understanding Managed Code
          2. Identifying the need for managed code
        27. Creating Managed Database Objects
          1. Importing and Configuring Assemblies
          2. Creating Managed Database Objects

        28. Implementing HTTP Endpoints

        29. Introduction to HTTP Endpoints
          1. Introduction to SOA
          2. Introduction to Web Services
          3. Identifying the role of HTTP Endpoints in a Native Web Service Architecture
        30. Implementing the HTTP Endpoints
          1. Creating HTTP Endpoints
          2. Securing HTTP Endpoints

        31. Implementing Services for Message-Based Communications

        32. Message Based Communication
          1. Introduction to Service Broker
          2. Introduction to Service Broker
        33. Implementing Service Broker
          1. Creating Messages
          2. Creating Queues
          3. Creating Contracts
          4. Creating Services
    1. Oracle DBA Syllabus
      • Introduction to 11g New Features
        1. Inside 11g New Features
        2. Oracle 11g DBA New Features
        3. Oracle 11g High Availability & RAC new features
        4. OEM - Enterprise Manager Oracle 11g new features
        5. Oracle 11g New Features Programming Language Support
        6. Oracle 11g PL/SQL New Features
        7. Oracle SQL optimizer (CBO) Improvements
        8. Oracle 11g SQL New Features
        9. 11g Performance Tuning Optimization New Features
        10. Oracle 11g Security & Auditing New Features
        11. Oracle 11g New RMAN Features
        12. HTML-DB 11g Enhancements
        13. Oracle 11g Business Intelligence & OLAP
        14. Oracle 11g data mining
      • 11g New DBA Features
        1. 11g for the DBA
        2. Partitioning Enhancements
        3. Interval Partitioning
        4. System Partitioning
        5. Reference Partitioning
        6. Virtual Column-Based Partitioning
        7. Composite Partitioning Enhancements
        8. Enhanced Partition Pruning Capabilities
        9. Enhanced Information Lifecycle Management
        10. The Oracle 11g ILM Assistant
        11. New Index Features
        12. Invisible indexes
        13. Improved table compression
        14. Improved NFS Performance/Management
        15. Database Resident Connection Pooling
        16. Oracle Call Interface (OCI) Consistent Client Cache
        17. Virtual column
        18. Oracle 11g Binary XML data storage
        19. Incident Packaging Service
        20. Enhanced Read-only tables
        21. Faster DML triggers
      • High Availability and RAC New Features
        1. Background of Oracle RAC
        2. Scalability
        3. Automatic Workload Repository
        4. Services
        5. Putting Load Balancing into Action
        6. Cloning a Cluster to another Cluster
        7. Scalability Conclusion
        8. Cluster Performance
        9. ADDM for RAC
        10. High Availability
        11. Cluster ware Rolling Upgrades
        12. ASM Rolling Upgrades
      • OEM Oracle 11g new features
        1. Introduction to OEM
        2. Improved Database Home Page and Performance changes
        3. Integrated Interface for Log Miner
        4. Advanced Replication Interface
        5. Wait Activity Detail Enhancement
        6. Easy Oracle Text Management
        7. Better OEM Grid Tools
        8. Clone Database Enhancements
        9. Migrate Database (and more!) to ASM
        10. Workspace Manager
        11. Find Referential Integrity Constraints
        12. Compress a Workspace
        13. Manage System Parameters
        14. Privilege Management
      • Oracle 11g PL/SQL New Features
        1. 11g PL/SQL New Features
        2. PL/SQL Sequence Access
        3. SIMPLE Number Types
        4. The CONTINUE Statement
        5. PL/SQL Subprogram Inclining
        6. PL/SQL Compound Triggers
        7. PL/SQL Trigger Enhancements
        8. Cross-Session PL/SQL Function Result Cache
      • Oracle 11g SQL New Features
        1. 11g SQL
        2. SQL PIVOT and UNPIVOT Operators
        3. Regular Expressions Enhancements
        4. regexp_instr
        5. regexp_substr
        6. regexp_count
        7. Result Cache Hint
        8. HASH OUTER JOINS
      • 11g Performance Tuning Features
        1. New Performance Tuning Features
        2. A trip to the SPA – Inside the 11g SQL Performance Analyzer
        3. Decision Support and Expert Systems Technology
        4. Inside the Oracle 11g SQL Performance Analyzer
        5. A trip to the SPA
        6. Comparing the SPA Results
        7. Extended Optimizer Statistics
        8. Inside Extended Optimizer Statistics
        9. Automatic Diagnostic Repository
      • Oracle 11g Security Enhancements
        1. New Password Security Features
        2. Enhances hashing algorithm
        3. Passwords with symbols in 11g
        4. Case sensitive passwords
        5. Case sensitive passwords and database upgrade to 11g
        6. How to enable the Oracle 11g EXCLUSIVE MODE
        7. Enforcing complex passwords
        8. How to find accounts with default passwords in 11g
        9. Other Hacking Prevention Features
        10. Auditing by DEFAULT in 11g
        11. Strong Authentication for SYSDBA and SYSOPER in 11g
        12. Limiting Access to External Networking Services
        13. How to create and manage ACLs with PL/SQL
        14. How to create and manage ACLs with OEM
        15. Other network security features
        16. Transparent Data Encryption Features in 11g
        17. External Master Key Storage using Hardware Security Module
        18. TDE with Log miner and Logical Standby Database
        19. TDE with Export Data Pump
        20. Transparent Table space Encryption
        21. TDE with Enterprise Manager
        22. Intelligent LOB Encryption with Secure File LOBs
        23. Secure file Lobs at work
        24. Secure file Lobs at work with OEM
        25. Virtual Private Catalogues for RMAN
        26. Other security aspects about backup in 11g
      • 11g New Features Streams and Data Guard
        1. Data Guard
        2. Physical Standby + Real-Time Query
        3. Snapshot Standby
        4. Creation of Standby Database
        5. Dynamic Setting of Oracle Data Guard SQL Apply Parameters
        6. Streams
        7. Streams Performance
        8. Streams Topology
        9. Materialized Views
      • Oracle 11g Change Management
        1. RAT - Real Application Testing
        2. Testing with a snapshot standby database
        3. SQL Performance Analyzer (SPA)
        4. SQL Performance Analyzer using PL/SQL
        5. SQL Performance Analyzer using OEM
        6. Database Replay
        7. Database replay using the command line
        8. Preparing the system for capture
        9. Capturing the workload
        10. How to capture a workload in a 10g database for replay in an 11g database
        11. Preparing the testing system for workload replay
        12. Workload replay and analysis on the testing system
        13. Database replay in the GUI
      • SQL Management
        1. SQL Plan Management with SQL Plan Baselines
        2. How Automatic SQL Plan Management works
        3. Use cases for Automatic SQL Plan Management
        4. SQL Plan Management in OEM
        5. How Manual SQL Plan Loading works
        6. Integration of SQL Plan Management with Automatic SQL Tuning
      • Oracle 11g Flashback
        1. A brief history of FLASHBACK functionalities
        2. TRANSACTION BACKOUT in Oracle 11g
        3. Transaction back out without OEM using PL/SQL
        4. Transaction back out with OEM
        5. Oracle Total Recall
        6. The Technology Behind It
        7. Enabling Flashback Data Archive
        8. What is in the Flashback Data Archive?
        9. DDL limitations for Flashback Data Archive
        10. What’s new about UNDO and transactions in 11g?
        11. Optimized UNDO BACKUP with RMAN
      • Oracle 11g ASM Enhancements
        1. ASM Security Enhancements
        2. SYSASM role in 11g
        3. UPGRADING ASM to 11g
        4. ASM disk group attributes
        5. Resetting the CSSd
        6. ASM Rolling Upgrade
        7. ASM Fast Mirror Resync
        8. ASM Performance Enhancements
        9. Variable size of Allocation Units
        10. ASM Fast Rebalance
        11. Stretched ASM cluster configuration with ASM Preferred Mirror Read in 11g
        12. ASMCMD new features
        13. Automatic and manual ASM disk repair in 11g
        14. ASM Disk Group Checks Enhanced ASM metadata

    Benefits of Database

      1. students will be getting government authorized certificate and will be valid worldwide
      2. Sharp Mind Info Train provides excellent coaching for the students who are looking to build high career goals.

      3. Sharp Mind not only provides professional teachers but also the necessary material required for the students and takes them to the next level of knowledge.

      4. The institute helps to gain fresh perspectives on your personal challenges and opportunities.

      5. In the era of cut-throat competition, there is huge competition in all the fields. Our institute makes the way for you easy by teaching all the new technologies to be a good competitor and ease your way to reach your goals.

      6. We provide competitive environment to you to make you more and more stable technically with all the best skills.

      7. We have company environment.

      8. All the courses available here are cost effective. The institute also provides 100% career assistance.

  • <