MYISYS BEST/TOP COACHING/TRAIING CENTRE/INSTITUTE FOR ORACLE IN COIMBATORE

Type Computer MYISYS offers various software courses like: 1) C++, 2) java, 3).net, 4) Oracle which includes both DBA and developer, 5) Tally, 6) Embedded Systems, 7) AutoCAD, 8) Testing and 9) Basic computers which includes Microsoft word Excel and Internet. CONTENTS FOR BOTH ORACLE DBA AND DEVELOPER --------------------------------------------------------------------------------------- A) ORACLE DBA ------------------ 1) Introduction to SQL - Here you will know the basics of SQL like SELECT, WHERE clause etc and then you will learn about joins, subquery and then you will learn about users, roles etc. 2) Admin 1 - Once you finish your SQL you will start your with administration. You will learn architecture, and how to administration skill like creation of database, controlfiles, redo log files, tablespaces& datafiles etc. 3) Admin 2 - Once you acquire knowlege in Admin 1 which gives you knowlege of administration skills, in admin 2 you will move to backup and recovery, performance tuning etc. 4) Advanced Concepts - After finishing your regular admin 1 and admin 2 you have to move to advanced concepts like 1) Database cloning 2) Data Guard 3) Migration and Upgradation 5) Emerging, new and popular Software in Oracle DBA in companies - 1) RAC (Real Application Clusters) - we will teach you how to install RAC, How to add nodes and How to switch from one node to another node B) ORACLE DEVELOPER ---------------------------------------- 1) SQL - Here you will know the basics of SQL like SELECT, WHERE clause etc and then you will learn about joins, subquery and then you will learn about users, roles etc. 2) PL/SQL - Once you finish your sql then you will move to PL/SQL where you can study the basics of PL/SQL and also advance pl/sql like cursors, triggers, procedures etc.