Oracle Training in Chennai

Oracle Database Training in Chennai

Sakthi Software Solutions, Anna Nagar, Chennai Offers Best Oracle Training in Chennai.

Linux/Solaris

• Directory and file commands
• System files and files directories
• Files and directory security
• VI Editor
• Shell Scripts
• Scheduling jobs
• AWK programming
• Administrator Commands
• Monitoring memory and processor
• Disk Maintenance
• LVM

Oracle Database Programming

SQL

• Introduction to RDBMS
• Data types
• Sql Languages
• Constraints
• Single row and multirow functions
• Conversion functions
• Conditional expressions
• Operators
• SET operators
• Joins
• Sub Queries
• Co-related Sub Queries
• Views
• Sequence
• Synonyms
• Indexes
• User Access
• Rollup and Cube
• Time Zone
• External Tables
• Multiple Table Inserts
• Workshop With Scenarios
• Assessment

PL/SQL

• Introduction to PLSQL Environment
• Variables and Data Types
• Languages
• Control Structures
• Cursors
• Exceptions Procedures
• Functions
• Triggers
• Packages
• Oracle inbuilt Packages
• Dynamic SQL
• REF Cursors
• PLSQL Tables
• Workshop with Scenarios
• Assessments

SQL Tuning

• Oracle optimizer modes
• Interpreting execution plan
• Trace Events
• Using proper indexes
• Workshop with Scenarios
• Assessments

Contact:

Sakthi Software Solutions Pvt Ltd,

RVR Towers, 1st Street, 3rd Main Road,

Annanagar,

Behind Nalli Silks, Chennai 600 040.

044-43016888 / www.sssedu.in

Mega Job Fair for Freshers in Chennai 2013

Sakthi Software Solutions Hosts Fresher’s IT Job fair 2013 exclusively for 2013 Pass outs

Qualification: Fresher’s BE / BTECH (CSE/IT/EEE/ECE/EIE), MCA, M.Sc/ B.Sc & BCA & MBA 

Fresher’s IT Job fair 2013 

Date: 24th February 2013 (Sunday)                            

                                                 

Time: 10a.m to 4p.m

Venue: Anna Nagar, Chennai

SSS Initiative

·         Initial Screening by SSS with Prior Hall Tickets

·         Total Fresher’s Recruitment & Job fair Participation at Zero Cost

·         Aspiring Fresher’s under one roof

·         Scheduled Entry of Candidates

·         100% Facilitation to Employers to find the Right talent

·         Right Talent for the Right Opportunity

·         Immediate Joining of your Talent Hunt

Contact:

Sakthi Software Solutions Pvt Ltd
4th Floor, RVR Towers, No.1 AA Block,
1st Street, 3rd Main Road,
Anna Nagar, Chennai - 600 040

E-Mail: sssjobfair2013@gmail.com

Freshers Job Fair in Chennai 2013

Sakthi Software Solutions Hosts Fresher’s IT Job fair 2013 exclusively for 2013 Pass outs

Qualification: Fresher’s BE / BTECH (CSE/IT/EEE/ECE/EIE), MCA, M.Sc/ B.Sc & BCA & MBA  

Fresher’s IT Job fair 2013 

Date: 24th February 2013 (Sunday)                            

                                                 

Time: 10a.m to 4p.m

Venue: Anna Nagar, Chennai

SSS Initiative

·         Initial Screening by SSS with Prior Hall Tickets

·         Total Fresher’s Recruitment & Job fair Participation at Zero Cost

·         Aspiring Fresher’s under one roof

·         Scheduled Entry of Candidates

·         100% Facilitation to Employers to find the Right talent

·         Right Talent for the Right Opportunity

·         Immediate Joining of your Talent Hunt

Contact:

Sakthi Software Solutions Pvt Ltd

4th Floor, RVR Towers, No.1 AA Block,
1st Street, 3rd Main Road,
Anna Nagar, Chennai - 600 040

E-Mail: sssjobfair2013@gmail.com

Oracle DBA Training in Chennai

Sakthi Software Solutions, Anna Nagar Offers Best Oracle DBA Training in Chennai.

Concepts and Administration
•Oracle installation in Linux and Solaris
•Configuration kernel parameters
•Oracle architecture
•10G Automatic management
•Program Global Area
•Start-up and shutdown options
•Creating database
•Managing control files
•Managing log file
•Managing table spaces
•Managing data files
•Managing tables and indexes
•Materialized views
•Partitions
•Locks
•Data integrity
•Space and storage parameters
•Undo
•Temp management
•Temporary database
•Users
•Roles and privileges
•Profiles
•Scheduler
•DBMS_JOBS
•Workshop with Scenarios
•Assessments

Backup and recovery
•Export
•Import and Data pump
•RAID
•SAN
•NAS
•NFS Storage
•User Managed backup (UMB)
•UMB Cloning
•User Managed Recovery
•Point in time to recover (PITTR)
•Configuration RMAN
•RMAN Backups
•RMAN Cloning
•Merge Backups
•RMAN PITTR
•Maintaining Recovery Catalog
•Workshop with Scenarios
•Assessments

Network Administrator
•Client server configuration
•Tnsnames
•LDAP and Naming Servers
•Listiner Control utility
•Unix Tools: FTP, SFTP, SCP, WINSCP
•Workshop with Scenarios
•Assessments
Oracle Utilities
•Exp/imp, Expdp, impdp
•NID
•CSSCAN,CSALTER
•Oerr
•Dbverify
•Oraenv
•Orapwd
•Spidr
•Tnsping
•Wrap
•Workshop with Scenarios
•Assessments

Performance Tuning
•Why Tuning?
•SQL Tuning
•Application Tuning
•Tuning Sorts
•Resizing SGA/PGA
•Detecting I/O Issues
•Latch Contention
•DBMS_STATS

Configuration Stats pack and AWR
•Levels of Tracing
•Active Session History
•SQL tuning Advisor
•SQL Access Advisor
•10046 and 10053 trace events
•Using TKPROF
•Interpreting AWR and Stats pack
•Optimizer Modes and Parameters
•Network Tuning
•OS Tuning
•Workshop with Scenarios
•Assessments

Patching And Up gradation
•Oracle 9i to 10g to 11g Up gradation
•Version migration (10.2.0.1 to 10.2.0.4)
•Implementing Opatch
•Workshop with Scenarios
•Assessments

Oracle Security
•Db Vault
•Fine Grain Access Control (FGA)
•VPD Policies
•Workshop with Scenarios
•Assessments

Data guard
•Data guard Architecture
•Protection modes
•Configuration physical standby
•Configuration logical standby
•Switchover and failover
•Cascaded standby Database

Other Utilities
•Using Quest Toad
•Using ERWLN (Data Modeling)
•Using putty and Xmanager tolls
•Workshop with Scenarios
•Assessments

Contact:
Sakthi Software Solutions Pvt Ltd,
RVR Towers, 1st Street, 3rd Main Road,
Anna Nagar, Behind Nalli Silks,
Chennai-600 040.
044-43016888 / www.sssedu.in

Oracle Database Training in Chennai

Oracle Database Training in Chennai

Sakthi Software Solutions, Anna Nagar, Chennai Offers Best Oracle Training in Chennai.

Linux/Solaris

• Directory and file commands
• System files and files directories
• Files and directory security
• VI Editor
• Shell Scripts
• Scheduling jobs
• AWK programming
• Administrator Commands
• Monitoring memory and processor
• Disk Maintenance
• LVM

Oracle Database Programming

SQL

• Introduction to RDBMS
• Data types
• Sql Languages
• Constraints
• Single row and multirow functions
• Conversion functions
• Conditional expressions
• Operators
• SET operators
• Joins
• Sub Queries
• Co-related Sub Queries
• Views
• Sequence
• Synonyms
• Indexes
• User Access
• Rollup and Cube
• Time Zone
• External Tables
• Multiple Table Inserts
• Workshop With Scenarios
• Assessment

PL/SQL

• Introduction to PLSQL Environment
• Variables and Data Types
• Languages
• Control Structures
• Cursors
• Exceptions Procedures
• Functions
• Triggers
• Packages
• Oracle inbuilt Packages
• Dynamic SQL
• REF Cursors
• PLSQL Tables
• Workshop with Scenarios
• Assessments

SQL Tuning

• Oracle optimizer modes
• Interpreting execution plan
• Trace Events
• Using proper indexes
• Workshop with Scenarios
• Assessments

Contact:

Sakthi Software Solutions Pvt Ltd,

RVR Towers, 1st Street, 3rd Main Road,

Annanagar,

Behind Nalli Silks, Chennai 600 040.

044-43016888 / www.sssedu.in

Job Fair in Chennai 2013

Sakthi Software Solutions, Anna Nagar, Chennai hosts IT Job Fair 2013 Exclusively for 2013 Freshers.

Oracle DBA Training in Chennai

Sakthi Software Solutions, Anna Nagar Offers Best Oracle DBA Training in Chennai.

Concepts and Administration

•Oracle installation in Linux and Solaris

•Configuration kernel parameters

•Oracle architecture

•10G Automatic management

•Program Global Area

•Start-up and shutdown options

•Creating database

•Managing control files

•Managing log file

•Managing table spaces

•Managing data files

•Managing tables and indexes

•Materialized views

•Partitions

•Locks

•Data integrity

•Space and storage parameters

•Undo

•Temp management

•Temporary database

•Users

•Roles and privileges

•Profiles

•Scheduler

•DBMS_JOBS

•Workshop with Scenarios

•Assessments

Backup and recovery

•Export

•Import and Data pump

•RAID

•SAN

•NAS

•NFS Storage

•User Managed backup (UMB)

•UMB Cloning

•User Managed Recovery

•Point in time to recover (PITTR)

•Configuration RMAN

•RMAN Backups

•RMAN Cloning

•Merge Backups

•RMAN PITTR

•Maintaining Recovery Catalog

•Workshop with Scenarios

•Assessments

Network Administrator

•Client server configuration

•Tnsnames

•LDAP and Naming Servers

•Listiner Control utility

•Unix Tools: FTP, SFTP, SCP, WINSCP

•Workshop with Scenarios

•Assessments

Oracle Utilities

•Exp/imp, Expdp, impdp

•NID

•CSSCAN,CSALTER

•Oerr

•Dbverify

•Oraenv

•Orapwd

•Spidr

•Tnsping

•Wrap

•Workshop with Scenarios

•Assessments

Performance Tuning

•Why Tuning?

•SQL Tuning

•Application Tuning

•Tuning Sorts

•Resizing SGA/PGA

•Detecting I/O Issues

•Latch Contention

•DBMS_STATS

Configuration Stats pack and AWR

•Levels of Tracing

•Active Session History

•SQL tuning Advisor

•SQL Access Advisor

•10046 and 10053 trace events

•Using TKPROF

•Interpreting AWR and Stats pack

•Optimizer Modes and Parameters

•Network Tuning

•OS Tuning

•Workshop with Scenarios

•Assessments

Patching And Up gradation

•Oracle 9i to 10g to 11g Up gradation

•Version migration (10.2.0.1 to 10.2.0.4)

•Implementing Opatch

•Workshop with Scenarios

•Assessments

Oracle Security

•Db Vault

•Fine Grain Access Control (FGA)

•VPD Policies

•Workshop with Scenarios

•Assessments

Data guard

•Data guard Architecture

•Protection modes

•Configuration physical standby

•Configuration logical standby

•Switchover and failover

•Cascaded standby Database

Other Utilities

•Using Quest Toad

•Using ERWLN (Data Modeling)

•Using putty and Xmanager tolls

•Workshop with Scenarios

•Assessments

Contact:

Sakthi Software Solutions Pvt Ltd,

RVR Towers, 1st Street, 3rd Main Road,

Anna Nagar, Behind Nalli Silks,

Chennai-600 040.

044-43016888 / www.sssedu.in