Oracle Training

Home / Oracle Training

SQL Technologies provides the Oracle Training in Chandigarh since last 15 years. Our experienced Trainers guide the students to respective training procedures at both basic and advance Oracle level during our 100% job oriented advanced Oracle course in Chandigarh and Mohali. Our wide range of Course for Oracle for fresher as well as working professionals. At the end of the courses, students will be given Live Projects Training. Our institute in sector 34, Chandigarh is the oldest Company in Chandigarh/Mohali, Tricity for extensive Oracle Industrial training.

Introduction to 11g SQL:-
Writing SQL select Statements
Restricting and Sorting Data
Using Single Row Functions to Customize Output
Reporting Aggregated Data using the Group Functions
Displaying Data from Multiple Tables
Using Sub-queries to Solve Queries
Using the SET Operators
Manipulating Large Data Sets
Using DDL Statements to Create and Manage Tables
Creating Other Schema Objects
Managing Objects with Data Dictionary Views
Controling User Access
Manage Schema Objects
Manipulating Large Data Sets
Generating Reports by Grouping Related Data
Managing Data in Different Timezones
Searching Data Using Advanced Sub Queries
Hierarchal Retrieval
Regular Expression Support

ADMINISTRATION WORKSHOP 1:-
Exploring the Oracle Database Architecture
Installing your Oracle Software
Creating an Oracle Database Using DBCA
Managing the Database Instance
Managing the ASM Instance
Configuration the Oracle Network Environment
Managing Database Storage Structures
Administering User Security
Managing Data Concurrency
Managing Undo Data
Implementing Oracle Database Auditing
Database Maintenance
Performance Management
Backup and Recovery Concepts
Performing Database Backups
Performing Database Recovery
Moving Data
Working with Support

ADMINISTRATION WORKSHOP 2:-
Core Concepts and Tools of the Oracle Database
Configuring for Recoverability
Using the RMAN Recovery Catalog
Configuring Backup Settings
Creating Backups with RMAN
Restore and Recovery Tasks
Using RMAN to Perform Recovery
Monitoring and Tuning RMAN
Diagnosing the Database
Using Flashback Technology-1
Using Flashback Technology-2
Performing Flashback Database
Managing Memory
Managing Database Performance
Managing Performance by SQL Tuning
Managing Resources
Automating Task with the scheduler
Managing Space
Managing Space for the Database
Duplicating a Database