Oracle database 11g development.

In this class students learn the concepts of relational databases and the powerful sql programming language. This course provides the essential SQL skills that allow developers to write queries as needed. Every Organization either its Small or big has lots of data with confidential information and it’s not possible to handle them manually which leads need of database and Oracle is a big and secure database which is capable to store a large volume of database.

COURSE CONTENT

Oracle: PL/SQL Basics
  • Introduction to Database
  • Difference between SQL,PL/SQL and MYSQL
  • Command Line Interpreter and GUI supported for Oracle
  • Data types in oracle PL/SQL
  • Database objects, creating database object
  • Normalization
  • Operators in PL/SQL
Oracle : PL/SQL Setting Environment for Database Development.                
  • Installing oracle on machine.
  • Setting environment for oracle tools.
  • Getting familiar with SQL*plus & SQL developer.
  • Creating objects in Oracle database using SQL*plus & SQL developer.
  • Introduction to sample database.
  • Types of keys, constraints.
  • Types of relationships.
Oracle : PL/SQL Writing Queries
  • Learn to restrict and sort data using Where clause Like operator.
  • SQL operators
  • Set Operator (Union; Union all ; Intersect; Minus)
  • Arithmetic operators ( +,-,/,*)
  • Character operator ( || )
  • Comparison operators ( = , <> , < , <= , >, >= , In, not in , exists, All, between, Null, Not null)
  • Logical operators (Not, AND, OR)
  • Altering Tables , Joins on tables, retrieving data from multiple tables
  • Types of Joins
Oracle :PL/SQL Pre defined functions                 
  • String function
  • Arithmetic functions
  • Aggregate functions
  • Analytical functions
  • Group-by and having clause
  • Difference between where and having
  • Null elimination function
  • Decode function
  • Date time functions
  • Conversion functions
  • Regular Expressions
Oracle : PL/SQL Programming Language                        
  • PL/SQL Block
  • DML : Insert , update , delete
  • DDL : Select, group by
  • TCL : commit, rollback, save point
  • Pseudcolumns in PL/SQL
Oracle : PL/SQL StoredProcedures & Functions                             
  • Introduction to stored procedure
  • Introduction to User defined function
  • Introduction to cursors
  • Creating Dynamics stored procedures and user-defined function
  • Execution plans and advantages of creating stored procedure & functions.
Oracle : Collections                                 
  • Describe and use nested tables
  • Describe and use varrays
  • Describe and use associative arrays
  • Describe and use string indexed collections
  • Describe and use nested collections
  • Write PL/SQL programs that use collections
  • Describe the common collection exceptions and how to code for them
  • Compare associative arrays to collections
Oracle : Bulk Loading Data                       
  • Oracle * loader concept
  • Loading bulk data from external source ( eg: excel, csv etc)
Oracle : PL/SQL Control Structure                  
  • Testing conditions ( if and case statements)
  • Controlling loop interactions ( loop, exit , null)
  • Nested if-then-else
Basic of excel
  • Database function in excel Vloopup Transpose Basic of creating Macros
  • Modifying data and applying features in excel
  • Conditional filters
Oracle : PL/SQL Triggers
  • DML Triggers
  • System Triggers
  • Instead of triggers
  • Exception handling
  • Data dictionary
Oracle :PL/SQL Variables
  • Variable
  • Declaring variables in PL/SQL
  • Assigning values to variables
  • Local variable/Global variable
  • Scope of variable
  • Constant variable
Oracle: PL/SQL Tuning
  • Sub queries and co-related sub queries
  • Performance tuning
  • Explain Plan
  • SQL hints
  • Indexing
  • Types of indexing
  • Concept of Table partitioning
Oracle : Architecture
  • Overview of Oracle Architecture
  • How oracle Handles Programming with the Background process.

Oracle Application Express (Oracle APEX) is Oracle’s primary tool for developing Web applications with SQL and PL/SQL. Using only a web browser, you can develop and deploy professional Web-based applications for desktops.
Oracle Application Express (Apex) is one of the most exciting application development tools and is a true Rapid Application Development environment that can take an idea from concept to a working production level application in a short period of time.

Audience:
The student should have a basic understanding of Oracle database administration and application development with PL/SQL.  This Oracle Application Express (Apex) course also assumes a basic knowledge of DBA structures including tables, indexes and constraints
1) Having Basic Knowledge of writing Queries.
2) Understanding PL/SQL queries.

COURSE CONTENT

Installing APEX 
configuring APEX
Apex Administration I.                
  • Development basics
  • Creating a workspace
  • Apex development best practices
Apex users and schema management
  • Apex authentication and user management
  • Apex conditions and authorization schema
  • Apex data security
Oracle Apex Data Workshop                 
  • Importing Data
  • Exporting Data
Apex SQL Workshop                        
  • SQL Command Processor
  • Explain Plan
  • Browsing Database Objects
  • Query by example
  • UI Defaults
  • Scripts
Learning the Apex Application Builder                            
  • Apex Application Attributes
  • Apex Pages
  • Apex Regions
  • Apex Page Rendering
  • Apex Conditional Processing
  • Apex Shared Components
  • Apex Wizards
  • Apex Utilities
  • CSS and Image Files
  • Export/Import
Application Deployment with Oracle Apex                                 
  • Loading Apex pictures and images
  • Using Apex tabs
  • Using breadcrumbs
  • Deploying your Apex application to a production
  • Using Application Builder Utilities to Deploy Your Apex Application
  • Export/Import
  • CSS and Image Files
  • The Export Repository
Creating Web Pages with Apex                       
  • Apex Forms
  • Apex Reports
  • Apex Charts
  • Apex Buttons
  • Items
  • Apex List of Values (LOVs)
  • Calendars
  • Shortcuts
Apex Navigation
                  
  • NavBar
  • Tabs
  • Menus
  • Buttons
  • Trees

Apex Debugging

Oracle Database 11g : Administration Workshop I

Prerequisite
Oracle Database 11g : SQL

COURSE CONTENT

Installing and Configuring Oracle Database.
Prerequisite : Oracle Database 11g : SQL
Take Aways            
  • Installing and Configuring Oracle Database.
  • Manage schema objects
  • Perform database backup & recovery
Course Contents
  •         Oracle Database
  •         Oracle Instance
  •         Database Memory Structure
  •         Database Storage Structures
  •         Administering User Security
  •         Schema Objects
  •         Data Pumps
  •         Transport Tablespaces.
  •         Managing Tablespaces and Datafiles.
  •         Data and Concurrency
  •         Managing Undo Data
  •         Oracle Database Security
  •         Oracle Network Environment
  •         Proactive Maintenance
  •         Performance Management
  •         Backup and Recovery Concepts
  •         Database Backup
  •         Hot and Cold Backup’s
  •         Database Recovery
  •         Flashback
  •         Moving Data

Course Highlights –

  • Every course is trained by working professionals only
  • Ample practical assignments are given to the trainees
  • Real time project and examples to support practical learning
  • Mock interviews to simulate and help students face job interviews
  • Repeat the whole course with no extra cost
  • Flexible weekend classes and special weekday classes
  • Confirmation Letter / Training Letter / Project Letter : For Degree Pursing Candidates To Submit In Colleges
  • Experience Certificates : All students would be given experience certificates after successful completion of project.

Print Friendly

Leave a Reply