Oracle Training in Chandigarh


Oracle Technology finds a better scope as a DBA(DataBase Admin) and Data Management Solution. CNT Technologies provides complete Database Training including Storage, Deployment and Managing. Highly qualified and experienced faculty will be available to work on this training module. We are providing training in all Oracle technologies like 10g,11g, 12c etc. You may directly enroll for complete Oracle training.


Oracle 12 DBA

Module 1: Database Administrator (DBA Track)

  • Relational and object relational database concepts
  • Retrieve, insert, update, and delete data
  • Use the Single row and Group functions
  • Multicolumn Sub-queries, FROM clause of a SELECT statement
  • Use the iSQL*Plus environment
  • Write scripts to generate script files
  • Generate reports using iSQL*Plus
  • Create and maintain database objects
  • Control transactions
  • Control data/user access
  • Use the Oracle9i Single row functions
  • Use GROUPING SETS and the WITH clause
  • Use the Oracle9i extensions to DML and DDL statements
  • Apply techniques in real life simulation

Module 2: Oracle9i Database Administration: Fundamentals

  • Manage table-spaces, segments, extents, and blocks
  • Manage users, privileges, and resources
  • Create an operational database
  • Start up and shut down an Oracle instance and database
  • Manage Oracle database files
  • Use Globalization Support features

Module 3: Oracle9i Database Administration: Fundamentals II

  • Define networking requirements and the solutions provided by Oracle
  • Perform database and datafile backups with and without Recovery Manager (RMAN)
  • Configure the network environment for an Oracle client-server system
  • List the different Oracle backup methods and recovery operations
  • Describe the database utilities (Export and Import) and the situations where they can be used
  • Develop network configuration and recovery techniques through various workshop scenarios
  • List the Oracle architecture components related to backup and recovery operations

Module 4: Oracle9i Database Administration: Performance Tuning

  • Design and configure an Oracle database with an emphasis on good performance
  • Perform day-to-day monitoring on an operational database
  • Learn important steps in a tuning methodology
  • Employ Oracle tools to diagnose performance problems
  • Perform tuning tasks with Oracle Enterprise Manager and with the command line interface
  • Reconfigure file structures for performance
  • Identify and resolve I/O, data storage and database configuration problems
  • Optimize sort operations
  • Configure Oracle Shared Server
  • Configure Resource Manager to control resource usage

Module 5: ORACLE 10G

  • Oracle Database 10g: Administration I
  • Install Oracle Database 10g and configure a database
  • Manage the Oracle instance
  • Manage the Database storage structures
  • Create and administer user accounts
  • Perform backup and recovery of a database
  • Configure Oracle Net services
  • Monitor, troubleshoot, and maintain a database
  • Configure Oracle Net services
  • Move data between databases and files

Module 6: Oracle Database 10g: Administration II

  • Use RMAN to create and manage backup sets and image copies
  • Recover the database to a previous point in time
  • Use Oracle Secure Backup to backup and recover a database
  • Use Oracle's Flashback technology to recover your database
  • Detect block corruptions and take appropriate measures to correct them
  • Use the various Database advisors and views to monitor
  • Control database resource usage with the Resource Manager
  • Simplify management tasks by using the Scheduler
  • Review database log files for diagnostic purposes
  • Customize language-dependent behavior for the database
  • Implement a secure database
  • Transport data across platforms

Module 7: Data Storage, Retrieval, and Sharing

  • Saving and Loading Files
  • Including Static Files as Resources
  • File Management Tools
  • Databases in Android
  • Introducing SQLite
  • Cursors and Content Values
  • Working with Android Databases
  • Using Content Providers
  • Native Android Content Providers
  • Creating a New Content Provider
  • Creating and Using an Earthquake Content Provider

Module 8: Geocoding, and Location-Based Services

  • Using Location-Based Services
  • Setting up the Emulator with Test Providers
  • Updating Locations in Emulator Location Providers
  • Create an Application to Manage Test Location Providers
  • Selecting a Location Provider
  • Finding the Available Providers
  • Finding Providers Based on Requirement Criteria
  • Finding Your Location
  • “Where Am I?” Example
  • Tracking Movement
  • Updating Your Location in “Where Am I?
  • Using Proximity Alerts
  • Using the Geocoder
  • Reverse Geocoding
  • Forward Geocoding
  • Creating Map -Based Activities
  • Creating a Map-Based Activity
  • Configuring and Using Map Views
  • Using the Map Controller

Module 9: Working in the Background

  • Creating and Controlling Services
  • Binding Activities to Services
  • Using Background Worker Threads
  • Creating New Threads
  • Synchronizing Threads for GUI Operations
  • Moving the Earthquake Service to a Background Thread
  • Let’s Make a Toast
  • Customizing Toasts
  • Using Toasts in Worker Threads
  • Using Alarms
  • Using Alarms to Update Earthquakes

REGISTER HERE