120 likes | 240 Views
Smartmind online training provides complete knowledge regarding all core concepts and it gives enough confidence about Oracle 11g DBA . We can say Smartmind is the best Oracle 11g DBA Training platform for freshers because here we start every concept from the ground level and we explain concepts by taking real time scenarios, so Students get good understanding about subject. Smartmind online training helps you to gain depth knowledge on Oracle 11g DBA and it makes you ready to become a real time Software Developers.
E N D
About us: Smart Mind Online Training following a succeeding career in IT sector. Smart Mind Online is a global leading IT Training provider. We specialized in providing Online Training services on hadoop, java, oracle and sap all modules. We teach students and train them for IT profession. Also, we will provide job support by IT professionals for job.
Oracle 11g DBA Concepts: • INTRODUCTION TO ORACLE DBA • 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
Overview of Service Oriented Architecture(SOA): • SOA to a layman • Overview of SOA • Advantage in using SOA • Why is SOA 11g Important • Building Blocks of SOA • Overview of XML, XSD, Web-Services, SOAP, UDDI, WSDL
DATABASE CREATION • Different Startup Modes • Different Shutdown Modes • Types of Database Creation • Manual Method of Creation •Table space 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)
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)
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 • UNDO MANAGEMENT • What is Undo?• Why Undo required?• Pending offline status• Brief idea about Rollback segments• Flashback Features
FLASHBACK FEATURES • LOGICAL BACKUP • PHYSICAL BACKUP • PEFORMANCE TUNING • ADVANCED SQL Topics • HOW TO USE SAS MACROS IN SQL • SQL-LOADER
smartmind providing ORACLE 11G DBA Online Training Online Training supported specific desires of the learners particularly we arae going to offer innovative one to at least one category that hs nice opportunities within the present IT market. We provide corporate course to challenge today’s competitive IT world. Learners will grasp the technology-subject from our extremely skilled & certified trainers which is able to be serving to the Students to figure in real time projects. Learners will select either regular course or weekend coaching categories. We are the one in the entire highest leading ORACLE 11G DBA online Training provider from India http://smartmindonlinetraining.com/oracle-11g-dba-online-training/
Contact us: India:+91 9949599844 USA :+1-347-606-2716 E-mail:contact@hyderabadsy.com