Industreal Training & Internship Programs For 6 Weeks And 6Months
At CREATIVE ARTS, we cultivate the fate of innovation by improving the abilities and capacities of every person to get ready them according to the business necessity.
We at CREATIVE ARTS are answerable for giving innovations that use business measures. We offer a month and a half summer preparing in Oracle DBA for understudies which is a completely work arranged undertaking based preparing that empowers understudies to chip away at Live activities from the business. We give Oracle DBA confirmation preparing in Chandigarh.We are giving Best Oracle DBA course in Chandigarh that can be a defining moment for all the understudies who has gone through B.tech, BCA, MCA, BBA, MBA course and some more. In this time of PCs and innovation it’s almost difficult to land Positions with just degrees or certificates.
One should have the option to comprehend and have profound information in no less than one of the important innovations that is a piece of under systems administration, programming, web advancements, HR, Finance and bookkeeping programming and so forth For understudies to create the abilities as needed by the business CREATIVE ARTS gives the best Oracle DBA preparing in Chandigarh with completely prepared labs and different assets. Inventive ARTS India program assembles an amazing preparing instrument that can be executed in homerooms just as in the business.
We offer wide scope of projects for 4 a month and a half preparing under the direction of the best mechanical experts.We are pleased to be granted every year as the best Oracle DBA preparing establishment in Chandigarh, CREATIVE ARTS gives the best 4 a month and a half preparing program in delhi and NCR and can dominate in space as the consequence of the group’s meticulous efforts.Project based preparing in Oracle DBA in Chandigarh centers around ongoing to give help with work.
A month and a half Oracle DBA preparing program is intended to give an encounter of the business for the understudies and help them to begin with their vocations as experts. Our group of expertsenior mentors cooperate with involved insight on LIVE undertaking that comes from different various businesses domains.At CREATIVE ARTS, we assist you with picking your profession appropriately with the right Oracle DBA training,you can be guaranteed that you are on the right vocation path.
The members of preparing will get acquainted with different fundamental parts of Oracle DBA with continuous tasks and quickly
Industrial Training in Oracle 10g/11g DBA is a modular 6 weeks course. The course curriculum of Industrial Training in Oracle 10g/11g DBA comprises of
-
- What is DBA ?
- Why a Company needs a DBA?
- Roles & Responsibilities of DBA
- Oracle Architecture
- Physical and Logical Phase of Database
- Types of files(Control file, Redolog file and Datafile)
- Different types of Datafiles
- Instance
- SGA(System Global Area) and Background Process
- DATABASE CREATION
- Different Startup Modes
- Different Shutdown Modes
- Types of Database Creation
- Manual Method of Creation
- TABLESPACE MANAGEMENT
- Introduction to Table space
- Types of Table space(BIG & SMALL)
- Temporary Table space
- Altering/Renaming a Table space
- Renaming a data file
- Temporary Groups
- Table space Encryption(11g)
- STORAGE PARAMETERS
- What are segments?
- What are extents?
- What is Blocks?
- Oracle Blocks
- Estimation of Extents
- Dictionary Managed Table space
- Locally Managed Table space
- Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)
- USER MANAGEMENT
- Who are Database Users?
- Why to create a User?
- Creation of Users
- Assigning Privileges
- Creating and granting Roles
- Allocating table space Quotas to Users
- Assigning default table space for the Users
- Setting Profiles for the Users
- Levels of Authentication
- Schema Management(11g)
- Security(11g)
- UNDO MANAGEMENT
- What is Undo?
- Why Undo required?
- Pending offline status
- Brief idea about Rollback segments
- Flashback Features
- Flashback Table
- Flashback query
- Flashback Version query
- What is spfile?
- Difference between spfile and pfile
- Advantages of spfile
- What is OMF?
- Advantages of OMF
- Files conventions of OMF
- NETWORKING IN ORACLE
- Introduction to Oracle Networking
- Network default location
- Editing Network file
- Tnsnames.ora
- Introduction to Database Links
- Types of Database Links
- Introduction to Materialized views
- Advantages of Materialized view
- Refresh Modes
- REDO-LOG & CONTROLFILE MANAGEMENT
- Introduction to Redo log
- Status of Redo logs
- Multiplexing the Redo log files
- Re-creation of Control file
- Renaming the Database
- Multiplexing the Control file
- LOGICAL BACKUP
- What is a logical backup
- Why it is required
- Export/import Utility
- Data Pump
- Difference between Data Pump and Traditional Export/import
- Impdp/expdp
- Transportable Table spaces
- PHYSICAL BACKUP
- Introduction to Physical backup
- Types of Physical backup
- Cold & Hot backup
- Recovery scenarios
- RMAN backup
- RMAN Point in time recovery
- RMAN 11g new features
- PEFORMANCE TUNING
- What is Performance Tuning?
- Why Tuning required?
- Types of Tuning
- Database Tuning
- Tuning
- SQL Tuning
- Memory Tuning
- Network Tuning
- Partitioning and Indexes
- Partitioning Enhancements
- AWR/ASH/ASMM/ADDM
- RAT(Real Application Testing)(11g)
- SQL Performance Analyses (11g)
- Row chaining and Row migration
- Resemble Table spaces