Database Training classes near me in Bannerghatta Main Road, Bangalore

I am a seasoned Trainer having experience of 15 Years. Working as a Corporate Trainer and Delivered programs across many client locations in India.

I have an experience of 6 years in Software companies. My skills are Informatica,MS SQLServer,Oracle,Unix/Linux.

?Below is the list of training's scheduled for the month of ?Nov-Dec 2016, If any of you or your friends/Colleagues/Team mates are interested in taking any of the below training's. Appreciate if you could help me circulate this hands-on training details to your friends circle, there may be few people who are interested in getting trained on these technologies. 1. OpenStack Cloud Computing - Hands-On Training November 2016, 25th- 26th (3 Days) Introduction to OpenStack BEGINNER LEVEL This 1-day training focuses on the operation and architecture of the various OpenStack® components, which are called Projects. It provides an introduction to the tools, processes, and resources developers will need to get started to work on OpenStack®. This course has been updated for the Icehouse release of OpenStack®. This course offers flexible navigation and can be completed from start to finish or alternatively, only selected portions viewed according to individual needs. Optional self-study lab exercises are included for those that choose to explore the material via hands-on activities. INTERMEDIATE LEVEL This 2-day course will take students through an in depth look at the OpenStack Network service Neutron. The result will be the skills to design and build a scalable extensible network within an OpenStack environment. The students will get hands-on lab experience of many of the course topics in a dedicated, pre-built OpenStack environment. DAY-1 ============== 1) OpenStack Compute 2) OpenStack Object Storage 3) OpenStack Image Service DAY-2 ============== 4) OpenStack Networking 5) OpenStack Dashboard 6) OpenStack Orchestration 7) OpenStack Identity DAY-3 ============== 8) OpenStack Metering 9) OpenStack Block Storage 10) InfraStack-Labs Public Cloud OMegha, Bangalore 2. Oracle 11g R2 DBA – Hands-On Training, December 2nd – 4th (3 Days) Course Topics: Exploring the Oracle Database Architecture · Oracle Database Architecture Overview · Oracle ASM Architecture Overview · Process Architecture · Memory structrues · Logical and physical storage structures · ASM storage components Installing your Oracle Software · Tasks of an Oracle Database Administrator · Tools Used to Administer an Oracle Database · Installation: System Requirements · Oracle Universal Installer (OUI) · Installing Oracle Grid Infrastructure · Installing Oracle Database Software · Silent Install Creating an Oracle Database · Planning the Database · Using the DBCA to Create a Database · Password Management · Creating a Database Design Template · Using the DBCA to Delete a Database Managing the Oracle Database Instance · Start and stop the Oracle database and components · Use Oracle Enterprise Manager · Access a database with SQLPlus · Modify database installation parameters · Describe the stages of database startup · Describe database shutdown options · View the alert log · Access dynamic performance views Manage the ASM Instance · Set up initialization parameter files for ASM instance · Start up and shut down ASM instances · Administer ASM disk groups Configuring the Oracle Network Environment · Use Enterprise Manager to create and configure the Listener · Enable Oracle Restart to monitor the listener · Use tnsping to test Oracle Net connectivity · Identify when to use shared servers and when to use dedicated servers Managing Database Storage Structures · Storage Structures · How Table Data Is Stored · Anatomy of a Database Block · Space Management in Tablespaces · Tablespaces in the Preconfigured Database · Actions with Tablespaces · Oracle Managed Files (OMF) Administering User Security · Database User Accounts · Predefined Administrative Accounts · Benefits of Roles · Predefined Roles · Implementing Profiles Managing Data Concurrency · Data Concurrency · Enqueue Mechanism · Resolving Lock Conflicts · Deadlocks Managing Undo Data · Data Manipulation · Transactions and Undo Data · Undo Data Versus Redo Data · Configuring Undo Retention Implementing Oracle Database Auditing · Describe DBA responsibilities for security · Enable standard database auditing · Specify audit options · Review audit information · Maintain the audit trail Database Maintenance · Manage optimizer statistics · Manage the Automatic Workload Repository (AWR) · Use the Automatic Database Diagnostic Monitor (ADDM) · Describe and use the advisory framework · Set alert thresholds · Use server-generated alerts · Use automated tasks Performance Management · Performance Monitoring · Managing Memory Components · Enabling Automatic Memory Management (AMM) · Automatic Shared Memory Advisor · Using Memory Advisors · Dynamic Performance Statistics · Troubleshooting and Tuning Views · Invalid and Unusable Objects Backup and Recovery Concepts · Part of Your Job · Statement Failure · User Error · Understanding Instance Recovery · Phases of Instance Recovery · Using the MTTR Advisor · Media Failure · Archive Log Files Performing Database Backups using RMAN · Backup Solutions: Overview · Oracle Secure Backup · User-Managed Backup · Terminology · Recovery Manager (RMAN) · Configuring Backup Settings · Backing Up the Control File to a Trace File · Monitoring the Flash Recovery Area Performing Database Recovery · Opening a Database · Data Recovery Advisor · Loss of a Control File · Loss of a Redo Log File · Data Recovery Advisor · Data Failures · Listing Data Failures · Data Recovery Advisor Views Data Replication · Describe ways to move data · Create and use directory objects · Use SQL*Loader to move data · Use external tables to move data · General architecture of Oracle Data Pump · Use Data Pump export and import to move data 3. Oracle 11g R2 Real Application Clusters - Hands-On training, December 2016, 9th-11th (3 Days) DAY-1 1 Overview 1.1 Prerequisites 1.1.1 Hardware Minimum Requirements 1.2 Making This training Successful 1.3 Training Tips 1.3.1 Storage Overview 1.3.2 Networking Overview 2 Planning Your Time 2.1 Overview 2.2 Time 3 Hardware and Windows Preparation 3.1 Hardware and Windows Minimum Requirements 3.1.1 Hardware Minimum Requirements 3.1.2 Windows Preparation 3.1.3 Hardware Verificaton 3.1.3.1 Processor 3.1.3.2 Memory 3.1.3.3 Hard Disks 3.1.3.3.1 Second Hard Disk 3.1.3.3.2 Free Space Requirements 3.1.4 Login Accounts 3.1.4.1 Creating a Local Admin Account 3.1.4.2 Verifying the Login Account 3.2 Install VirtualBox Server 3.3 Setup Virtual Networks 3.4 Setup Virtual Storage 3.5 Download Oracle Enterprise Linux 4 Linux Install 4.1 Create VM 4.2 Prep for OS Installation 4.3 OS Installation 4.4 Wrap-up OS Installation 4. ?5 ? Prep for Oracle 5 Create Cluster 5.1 Create Interconnect 5.2 Create Shared Disks 5.3 Copy VM 5.4 Configure Disks 5.5 Configure Node 1 5.6 Configure Node 2 5.7 SSH and CVU DAY-2 ============= 6 Grid Install (ASM) 6.1 Setup ASMLIB 6.2 Cluster Verification Utility (ASM) 6.3 Install Grid Infrastructure (ASM) 6.4 Increase CRS Fencing Timeout (ASM) 6.5 Setup ASM 7. RAC Install 7.1Install Database Software 8. Create Database 8.1Create DB DAY-3 ============= 9. Rolling Patches 9.1Patching Grid and Database Software 9.1.1Patching Overview 9.1.2Support Status and Known Issues 9.1.3Practice Rolling Application 10. Clusterware Testing 10.1Clusterware and Fencing 10.2Clusterware Callouts 11. Services, Failover and Load Balancing 11.1 Install Instant Client 11.2 Service Failover 11.3 Connection Failover 11.4 Runtime Failover 11.5 Client Load Balancing 11.6 Server Load Balancing 12. RAC Backups and Recovery 12.1 Setup Backups 12.2 Flashback Database 12.3 Block Change Tracking 12.4 Archived Logs 12.5 Database Backups 12.6 Database Recovery

Working Experience: One year experience in Teaching Programming Language. Company: NIIT JP Nagar, Bangalore Role: Faculty Duration: July 2013 to June 2014. One and Half year experience in Teaching Computer Science. Company: Mrs. KMPM Inter College, Jamshedpur, Jharkhand Role: Working as Faculty of Computer Science Department. Duration: July 2010 to Dec 2011. One and Half Years experience in programming with XML. Company: Binary Softtech Solutions, Jamshedpur, Jharkhand Role: Working as Software Developer managing Design and development of software from its complete life cycle (Including Database Design to Implementation and Support). Duration: January 2009 to June 2010. Two years experience in Teaching Computer Science. Company: CRC Infotech Pvt. Ltd., Delhi Role: Working as Trainee and Faculty for Various subjects like C, C++, Java, VB, Java Script, DBMS, and RDBMS According to BCA and MCA syllabus. Also doing web site management and updating tasks. Duration: July 2006 to June 2008

I have 5+ yr experience on MSBI, as SSIS,SSRS,SSAS,MDX and SQL server AND data warehousing concept if any one interested, i can provide practical training on MSBI

I am oracle DBA. I am working in a reputed company as senior dba. I have expertise in performance stunning have 11+ yrs of experience.

I have more than 8 years of teaching experience in Computer Science and Information Technology field. I worked as an Assistant professor in Neotia Institute of Technology Management and Science, JIS College of Engineering, Asutosh College in West Bengal. Area of Interests: 1)Database Management System 2)Data structure 3) Operating System 4)Software Engineering 5)Numerical Analysis 6)Computer Graphics 7)Networking 8)Languages: C, C++,Java,SQL,HTML 9) Manual Testing, QTP,QC,SELENIUM

I have an IT Experience of 2 years, and have lot to teach when it comes to Logic, Maths, Science , Computer programming etc. I Primarily take behavioral teaching at my organization,Where i help the newly joined graduates to adapt to IT industry. Be Smart, along with that have a sense of behavior. let the world look up to you ad see the model of decorum from you