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