Unicorn groups j

Unicorn Soft Labs is a leading quality ecommerce and Online Education Service Provider, we provide latest Information Technology/Systems solutions. We surface with development knowledge and teaching exposure. We have been providing creative and effective IT solutions to global companies. Our Expertise “Web Designing” Web designing is a process of creating design and code with visual effects and functionality. The major skills need to design a website are Photo shop, Dream weaver, J query, HTML5 CSS3 and Java Script. Learn to create responsive website which works on all devices. Expert faculty and that elevate the performance of your business. We impart hands on training via house projects on web design and development, so as to enhance skills acquired theoretically. Give us a privilege to inform you that to be Web designer, you need not posses any high-fi degree or be Graduate with exceptional talent. We Provide Interactive & Practical Classroom Training on Web Designing, All the sessions are completely PRACTICAL with programming & Real time training. We provide training for almost all IT & Software technologies, i.e.: C, C++, JAVA, J2EE, DOTNET, SAP, ORACLE, DBA, TESTING TOOLS, WEB DESIGNING, ACCOUNTING PACKAGE, TALLY, ANROID DEVELOPMENT, MEDICAL TARNASCRIPTION, FASHION DESIGNING and LIVE PROJECTS. We have excellent instructors who have real time experience 12 yrs plus expert orientation Training. Experience the Quality Training with 12 YRS of Experience faculty. Contact: Ms.Parveen Begum 040-

LOADRUNNER”Client Server Archetype: VuGen & Vusers - Types of Vusers - Analyzing number of Virtual Users - Determining the Hardware Configuration - Vuser Script Generation - Rendezvous Points: Inserting & Using Rendezvous Points - Controlling Load Peaks in Server - Setting Rendezvous Attributes - Load Runner Controller: Creating Scenario - Vuser Groups - Execution of Scenario - Test Result Analysis: Starting the Analysis - Collating Execution Result - Using Scenario Graphs and Reports - What-If Analysis with Cross Result Graphs - Load Performance Problems - Database Users - Vugen: Recording with Vuser - Generator - Parameters - Correlated Queries - Advanced Techniques. We Provide Interactive & Practical Classroom Training on Load Runner, All the sessions are completely PRACTICAL with programming & Real time training. We provide training for almost all IT & Software technologies, i.e.: C, C++, JAVA, J2EE, DOTNET, SAP, ORACLE, DBA, TESTING TOOLS, WEB DESIGNING, ACCOUNTING PACKAGE, TALLY, ANROID DEVELOPMENT, MEDICAL TARNASCRIPTION, FASHION DESIGNING and LIVE PROJECTS. We have excellent instructors who have real time experience 9 yrs plus expert orientation Training. Experience the Quality Training with 9 YRS of Experience faculty. Contact: Ms.Parveen Begum 040-

J Meter Course Content Introduction: Overview of Performance Testing Performance Testing Concepts Performance Testing Types Why to use performance Testing tool? What is JMeter? Running JMeter: JMeter's Classpath Using a Proxy Server Non-GUI Mode Distributed Mode Introduction to Elements of JMeter Test Plan: Thread Group Controllers Samplers Logic Controllers Listeners Timers Assertions Configuration Elements Pre-Processor Elements Post-Processor Elements Building a Test Plan: Adding and Removing Elements Loading and Saving Elements Configuring Tree Elements Running a Test Plan Adding Users: Adding Default HTTP Request Properties Adding Cookie Support Adding HTTP Requests Adding Post-Processor for Correlation Adding a Listener to View/Store the Test Results Saving the Test Plan Running the Test Plan Recording Tests Using JMeter: Creation of Thread Group Adding HTTP Proxy Server Configuring HTTP proxy server Configuring the browser for recording the test script Capturing the test steps using JMeter Handling the dynamic server values: Handling User Sessions with URL Rewriting Using a Header Manager Handling the dynamic server values Parameterize the user sessions Parameterize with test data: Identifying the test data on AUT Open a csv file with JMeter Reading the data from CSV files Using the parameters in JMeterTests Adding Assertions to the test script: Validating the response data related issues Validating the response size related issues Validating the threshold for the server response times Running the tests and analyzing the Assertion results Building a Monitor Test Plan: Adding Server Adding HTTP Requests Adding Constant Timer Adding a Listener to View/Store the Test Results Adding Monitor Results Saving the Test Plan Running the Test Plan Running Mutiple Scripts with JMeter: Creating multiple test thread groups Calling the multiple thread groups from a test plan Configuring the threads groups with respetive users numbers and ratios Running the load test for multiple thread groups from a Single Test Analyze the user group specific issues Analyze the Test plan specific issues for all user groups Reporting and Analyzing the Results: Adding the Assertion Results and monitoring Configuring and Generating the Distribution Graph Configuring and Generating the Graph Full Results Generating the Monitor Results Saving the data through Simple Data Writer Configuring and Generating the Spline Visualizer Generating the Aggregate Graph for multi group test Generating the Aggregate Report for multi thread group test Generating the Summary Report Best Practices: Limit the Number of Threads Where to Put the Cookie Manager Where to Put the Authorization Manager Reducing resource requirements BeanShell server Distributed Testing Thanks&Regards Elegant IT Services, #nd Floor, Varthur main road, Opp Safal Fresh, Near Railway Fly Over,Maratha halli, Bangalore - .

Hello there everybody Impeccable preparing for PTE, IELTS and Spoken English. Get free demo classes for 3 days. 100% achievement rate from last few months. Guarantee least 7 groups for freshers. Simply join for demo you will get to think about our educating system. week by week classes accessible for workers. Early morning groups accessible for understudies and workers. Don't hesitate to contact with us. Between am to 6.00pm. Good fortunes Respects T J Mam

Greetings everybody Immaculate getting ready for PTE, IELTS and Spoken English. Get free demo classes for 3 days. 100% achievement rate from last few months. Guarantee smallest 7 social occasions for freshers. Simply join for demo you will get to consider our training system. week by week classes open for masters. Early morning groups open for understudies and workers. Don't dither to contact with us. Between am to 6.00pm. Ideal circumstances Respects T J Mam

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

MIS GVT is one of the best IT Institutes, registered ISO (QMS) certified, with assurance of 100% placement. GVT Institute is not just another institute. It’s a humble birth of a significant education system and institution where every action and thought is student oriented, personal attention to every student is ensured, and “LEAD” is the Philosophy we follow. Management information systems are typically computer systems used for managing three primary components: technology, people (individuals, groups, or organizations), and data (information for decision making). Management information systems are distinct from other information systems, in that they are used to analyze and facilitate strategic and operational activities. SCOPE Scope of MIS Management Information Systems can be defined as 'The combination of human and computer based resources that results in the collection, storage, retrieval, communication and use of data for the purpose of efficient management of operations and for business planning. COURSE CONTENT:- a. Advance Excel b. Macros Access c. VBA/VBE d. Create Macro e. Excel metro recorder f. Macro programming g. SQL h. Use of SQL i. SQL Functions j. Access

Splunk Course Topics A.Machine Data Basics •Application Logs •Web Access Logs •Web Proxy Logs •Call Detail Records •Clickstream Data •Message Queuing •Packet Data •Configuration Files •Database Audit Logs and Tables •File System Audit Logs •Management and Logging APIs •OS Metrics, Status, and Diagnostic Commands •Other Machine Data Sources B.The Story of Splunk •Splunk to the Rescue in the Datacenter •Splunk to the Rescue in the Marketing Department •Approaching Splunk •Splunk: The Company and the Concept •How Splunk Mastered Machine Data in the Datacenter •Operational Intelligence •Operational Intelligence at Work C.Getting Data In •Machine Data Basics •Types of Data Splunk Can Read •Splunk Data Sources •Downloading, Installing, and Starting Splunk •Bringing Data in for Indexing •Understanding How Splunk Indexes Data D.Searching with Splunk •The Search Dashboard •SPL™: Search Processing Language •Pipes •Implied AND •top user •fields – percent •The search Command •Tips for Using the search Command •Subsearches E.SPL: Search Processing Language •Sorting Results •sort •Filtering Results •where •dedup •head •Grouping Results •transaction •Reporting Results •top •stats •chart •timechart •Filtering, Modifying, and Adding Fields •fields •replace •eval •rex •lookup F.Enriching Your Data •Using Splunk to Understand Data •Identifying Fields: Looking at the Pieces of the Puzzle •Exploring the Data to Understand its Scope •Preparing for Reporting and Aggregation •Visualizing Data •Creating Visualizations •Creating Dashboards •Creating Alerts •Creating Alerts through a Wizard •Tuning Alerts Using Manager •Customizing Actions for Alerting •The Alerts Manager G.Recipes for Monitoring and Alerting •Monitoring Recipes •Monitoring Concurrent Users •Monitoring Inactive Hosts •Reporting on Categorized Data •Comparing Today’s Top Values to Last Month’s •Finding Metrics That Fell by 10% in an Hour •Charting Week Over Week Results •Identify Spikes in Your Data •Compacting Time-Based Charting •Reporting on Fields Inside XML or JSON •Extracting Fields from an Event •Alerting Recipes •Alerting by Email when a Server Hits a Predefined Load •Alerting When Web Server Performance Slows •Shutting Down Unneeded EC2 Instances •Converting Monitoring to Alerting H.Grouping Events •Introduction •Recipes •Unifying Field Names •Finding Incomplete Transactions •Calculating Times within Transactions •Finding the Latest Events •Finding Repeated Events •Time Between Transactions •Finding Specific Transactions •Finding Events Near Other Events •Finding Events After Events •Grouping Groups I.Lookup Tables •Introduction •lookup •inputlookup •outputlookup •Further Reading •Recipes •Setting Default Lookup Values •Using Reverse Lookups •Using a Two-Tiered Lookup •Using Multistep Lookups •Creating a Lookup Table from Search Results •Appending Results to Lookup Tables •Using Massive Lookup Tables •Comparing Results to Lookup Values •Controlling Lookup Matches •Matching IPs •Matching with Wildcards J.Splunk Quick Reference Guide & Advanced topics •Case Sensitivity •Top Commands •Top Resources •Events •Sources and Sourcetypes •Hosts •Indexes •Fields •Tags •Event Types •Reports and Dashboards •Apps •Permissions/Users/Roles •Transactions •Forwarder/Indexer •SPL •Subsearches •Relative Time Modifiers •Common Search Commands •Optimizing Searches •Search Examples •Eval Functions •Common Stats Functions •Regular Expressions •Common Splunk STRPTIME Functions

Splunk Course Topics phno: 040- A.Machine Data Basics •Application Logs •Web Access Logs •Web Proxy Logs •Call Detail Records •Clickstream Data •Message Queuing •Packet Data •Configuration Files •Database Audit Logs and Tables •File System Audit Logs •Management and Logging APIs •OS Metrics, Status, and Diagnostic Commands •Other Machine Data Sources B.The Story of Splunk •Splunk to the Rescue in the Datacenter •Splunk to the Rescue in the Marketing Department •Approaching Splunk •Splunk: The Company and the Concept •How Splunk Mastered Machine Data in the Datacenter •Operational Intelligence •Operational Intelligence at Work C.Getting Data In •Machine Data Basics •Types of Data Splunk Can Read •Splunk Data Sources •Downloading, Installing, and Starting Splunk •Bringing Data in for Indexing •Understanding How Splunk Indexes Data D.Searching with Splunk •The Search Dashboard •SPL™: Search Processing Language •Pipes •Implied AND •top user •fields – percent •The search Command •Tips for Using the search Command •Subsearches E.SPL: Search Processing Language •Sorting Results •sort •Filtering Results •where •dedup •head •Grouping Results •transaction •Reporting Results •top •stats •chart •timechart •Filtering, Modifying, and Adding Fields •fields •replace •eval •rex •lookup F.Enriching Your Data •Using Splunk to Understand Data •Identifying Fields: Looking at the Pieces of the Puzzle •Exploring the Data to Understand its Scope •Preparing for Reporting and Aggregation •Visualizing Data •Creating Visualizations •Creating Dashboards •Creating Alerts •Creating Alerts through a Wizard •Tuning Alerts Using Manager •Customizing Actions for Alerting •The Alerts Manager G.Recipes for Monitoring and Alerting •Monitoring Recipes •Monitoring Concurrent Users •Monitoring Inactive Hosts •Reporting on Categorized Data •Comparing Today’s Top Values to Last Month’s •Finding Metrics That Fell by 10% in an Hour •Charting Week Over Week Results •Identify Spikes in Your Data •Compacting Time-Based Charting •Reporting on Fields Inside XML or JSON •Extracting Fields from an Event •Alerting Recipes •Alerting by Email when a Server Hits a Predefined Load •Alerting When Web Server Performance Slows •Shutting Down Unneeded EC2 Instances •Converting Monitoring to Alerting H.Grouping Events •Introduction •Recipes •Unifying Field Names •Finding Incomplete Transactions •Calculating Times within Transactions •Finding the Latest Events •Finding Repeated Events •Time Between Transactions •Finding Specific Transactions •Finding Events Near Other Events •Finding Events After Events •Grouping Groups I.Lookup Tables •Introduction •lookup •inputlookup •outputlookup •Further Reading •Recipes •Setting Default Lookup Values •Using Reverse Lookups •Using a Two-Tiered Lookup •Using Multistep Lookups •Creating a Lookup Table from Search Results •Appending Results to Lookup Tables •Using Massive Lookup Tables •Comparing Results to Lookup Values •Controlling Lookup Matches •Matching IPs •Matching with Wildcards J.Splunk Quick Reference Guide & Advanced topics •Case Sensitivity •Top Commands •Top Resources •Events •Sources and Sourcetypes •Hosts •Indexes •Fields •Tags •Event Types •Reports and Dashboards •Apps •Permissions/Users/Roles •Transactions •Forwarder/Indexer •SPL •Subsearches •Relative Time Modifiers •Common Search Commands •Optimizing Searches •Search Examples •Eval Functions •Common Stats Functions •Regular Expressions •Common Splunk STRPTIME Functions

Finding Specific Transactions •Finding Events Near Other Events •Finding Events After Events •Grouping Groups I.Lookup Tables •Introduction •lookup •inputlookup •outputlookup •Further Reading •Recipes •Setting Default Lookup Values •Using Reverse Lookups •Using a Two-Tiered Lookup •Using Multistep Lookups •Creating a Lookup Table from Search Results •Appending Results to Lookup Tables •Using Massive Lookup Tables •Comparing Results to Lookup Values •Controlling Lookup Matches •Matching IPs •Matching with Wildcards J.Splunk Quick Reference Guide & Advanced topics •Case Sensitivity •Top Commands •Top Resources •Events •Sources and Sourcetypes •Hosts •Indexes •Fields •Tags •Event Types •Reports and Dashboards •Apps •Permissions/Users/Roles •Transactions •Forwarder/Indexer •SPL •Subsearches •Relative Time Modifiers •Common Search Commands •Optimizing Searches •Search Examples •Eval Functions

Visualizing Data • Creating Visualizations • Creating Dashboards • Creating Alerts • Creating Alerts through a Wizard • Tuning Alerts Using Manager • Customizing Actions for Alerting • The Alerts Manager G. Recipes for Monitoring and Alerting • Monitoring Recipes • Monitoring Concurrent Users • Monitoring Inactive Hosts • Reporting on Categorized Data • Comparing Today’s Top Values to Last Month’s • Finding Metrics That Fell by 10% in an Hour • Charting Week Over Week Results • Identify Spikes in Your Data • Compacting Time-Based Charting • Reporting on Fields Inside XML or JSON • Extracting Fields from an Event • Alerting Recipes • Alerting by Email when a Server Hits a Predefined Load • Alerting When Web Server Performance Slows • Shutting Down Unneeded EC2 Instances • Converting Monitoring to Alerting H. Grouping Events • Introduction • Recipes • Unifying Field Names • Finding Incomplete Transactions • Calculating Times within Transactions • Finding the Latest Events • Finding Repeated Events • Time Between Transactions • Finding Specific Transactions • Finding Events Near Other Events • Finding Events After Events • Grouping Groups I. Lookup Tables • Introduction • lookup • inputlookup • outputlookup • Further Reading • Recipes • Setting Default Lookup Values • Using Reverse Lookups • Using a Two-Tiered Lookup • Using Multistep Lookups • Creating a Lookup Table from Search Results • Appending Results to Lookup Tables • Using Massive Lookup Tables • Comparing Results to Lookup Values • Controlling Lookup Matches • Matching IPs • Matching with Wildcards J. Splunk Quick Reference Guide & Advanced topics • Case Sensitivity • Top Commands • Top Resources • Events • Sources and Sourcetypes • Hosts • Indexes • Fields • Tags • Event Types • Reports and Dashboards • Apps • Permissions/Users/Roles • Transactions • Forwarder/Indexer • SPL • Subsearches • Relative Time Modifiers • Common Search Commands • Optimizing Searches • Search Examples • Eval Functions • Common Stats Functions • Regular Expressions • Common Splunk STRPTIME Functions

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on or email at Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.

SAP Live Project Training with 100% Assured Placements in MNC Company! L o o k i n g f o r 1 s t S A P J o b s !!! •Do you thing SAP fresher can get a job! •Do you thing SAP Certified fresher can get a job! •Do you thing End User can get a job! •Do you thing Domain Expert can get a job! Then how the Fresher can enter into SAP World !!! We need to focus 2 things one is 3 years Exposure and another one is 3 Years’ Experience. Then how to get 3 years Exposure? Please go through the project deliverable clearly.. We are going to start a new project in Coimbatore; The client would be Pricol Industries. And the team members would be 15 candidates. SAP Functional Module: SAP MM, SAP SD, SAP PP, SAP QM, SAP FI-CO, SAP PM,PS. SAP Technical module: SAP ABAP, BASIS, SEC, BI/ BO. Interested trainees feel free to send your fresher CV to . Technical shortlisted candidates would be eligible to do the project. The duration of the project would be 2 months. Project Exposure Fees: INR. Duration: 45 Days. Location: Coimbatore Mode: Online/Offline SAP FICO Module deliverable:- 1.Enterprise Structure:- •Client •Company Code •Chart of Account •Profit Center •Cost Center •Fiscal Year Variant •Posting Period Variant •Field Status Variant •Posting Keys •Tolerance Groups •Document Types 2.SAP FICO Master Data a.GL Master Data b.Customer Master Data c.Vendor Master Data d.Asset Master Data e.Bank Master Data 3.FICO Business Process:- 3.1 Accounts Payable (Purchase Order, Goods Receipt, Invoice, Payment) 3.2 Accounts Receivable (Sales Order, Delivery, Invoice, Payment Receipt) 3.3 Asset Depreciation Process 3.4 GL Accounting Parking, Sample & Recurring Document. 3.5 Internal Order and Profit Center Accounting.

SAP Live Project Training with 100% Assured Placements in MNC Company! L o o k i n g f o r 1 s t S A P J o b s !!! •Do you thing SAP fresher can get a job! •Do you thing SAP Certified fresher can get a job! •Do you thing End User can get a job! •Do you thing Domain Expert can get a job! Then how the Fresher can enter into SAP World !!! We need to focus 2 things one is 3 years Exposure and another one is 3 Years’ Experience. Then how to get 3 years Exposure? Please go through the project deliverable clearly.. We are going to start a new project in Coimbatore; The client would be Pricol Industries. And the team members would be 15 candidates. SAP Functional Module: SAP MM, SAP SD, SAP PP, SAP QM, SAP FI-CO, SAP PM,PS. SAP Technical module: SAP ABAP, BASIS, SEC, BI/ BO. Interested trainees feel free to send your fresher CV Technical shortlisted candidates would be eligible to do the project. The duration of the project would be 2 months. Project Exposure Fees: INR. Duration: 45 Days. Location: Coimbatore Mode: Online/Offline SAP FICO Module deliverable:- 1.Enterprise Structure:- •Client •Company Code •Chart of Account •Profit Center •Cost Center •Fiscal Year Variant •Posting Period Variant •Field Status Variant •Posting Keys •Tolerance Groups •Document Types 2.SAP FICO Master Data a.GL Master Data b.Customer Master Data c.Vendor Master Data d.Asset Master Data e.Bank Master Data 3.FICO Business Process:- 3.1 Accounts Payable (Purchase Order, Goods Receipt, Invoice, Payment) 3.2 Accounts Receivable (Sales Order, Delivery, Invoice, Payment Receipt) 3.3 Asset Depreciation Process 3.4 GL Accounting Parking, Sample & Recurring Document. 3.5 Internal Order and Profit Center Accounting.

Prerequisites • Strong knowledge of Oracle SQL • Strong conceptual knowledge of RDBMS concepts. About the Course We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS. Topics Covered DBA-I Topics Covered 1. Oracle 11g Installation • Pre-Installation Tasks a. Logging In to the System as root b. Checking Hardware Requirement c. Checking Software Requirement d. Checking Network Setup e. Creating Operating System Groups and Users f. Configuring kernel parameters g. Identifying Required Software Directories h. Identifying or Creating ORACLE_BASE directory i. Installation screens 2. Oracle Database Architect • System Global Area (SGA) a. Shared Pool b. Database Buffer Cache c. The Redo Log Buffer d. Java Pool e. Large pool f. Stream Pool • Fixed SGA a. Automatic Shared Memory Management b. The Oracle Background Process 3. Oracle Data Block Management • Introduction • Data block Overview a. Header (Common and Variable) b. Table Directory c. Row Directory d. Overhead e. Row Data f. Free Space • Free Space Management a. Availability and Optimization of Free Space in a Data Block b. Row Chaining and Migrating c. PCTFREE, PCTUSED, and Row Chaining d. The PCTFREE Parameter e. The PCTUSED Parameter f. PCTUSED g. How PCTFREE and PCTUSED Work Together • Extent Overview a. When Extents Are Allocated b. Determine the Number and Size of Extents c. How Extents Are Allocated d. When Extents Are Deallocated e. Extents in Nonclustered Tables f. Extents in Clustered Tables g. Extents in Materialized Views and Their Logs h. Extents in Indexes i. Extents in Temporary Segments j. Extents in Rollback Segments • Segment Overview a. Introduction to Data Segments b. Introduction to Index Segments c. Introduction to Temporary Segments d. Operations that Require Temporary Segments e. Segments in Temporary Tables and Their Indexes f. How Temporary Segments Are Allocated g. Allocation of Temporary Segments for Queries h. Allocation of Temporary Segments for Temporary Tables and Indexes • Undo Management a. Undo Quota b. Automatic Undo Retention c. External Views 4. Managing Tablespaces • Using Multiple Tablespaces • Creating Tablespaces • Locally Managed Tablespace a. Creating a Locally Managed Tablespace b. Segment Space management in locally managed tablespace • Big File tablespace a. Creating big file Tablespace b. Altering a Bigfile Tablespace c. Identifying a Bigfile Tablespace • Dictionary Managed Tablespace a. Creating Dictionary Managed Tablespace b. Specifying Tablespace Default Storage Parameters c. Specifying Tablespace Default Storage Parameters d. Coalescing Free Space in Dictionary-Managed Tablespaces e. Manually Coalescing Free Space 5. Managing User Privileges And Roles • Understanding User Privileges and Roles a. System Privileges b. Accessing Objects in the SYS Schema c. Object Privileges d. User Roles e. Creating Role • Granting Privileges and Roles • Grant With Admin Option DBA-II Topics Covered 1. Oracle Data Pump • Data Pump Component • Data Pump New Features • How Does Data Pump Access Data? a. Direct Path Loads and Unloads b. Situations in Which Direct Path Load Is Not Used c. Situations in Which Direct Path Unload Is Not Used d. External Tables • Accessing Data Over a Database Link • What Happens During Execution of a Data Pump Job? a. Coordination of a Job b. Tracking Progress within a Job c. Filtering Data and Metadata During a Job d. Transforming Metadata during a Job e. Maximizing Job Performance f. Loading and Unloading of Data g. Monitoring Job Status h. Monitoring the Progress of Executing Jobs • File Allocation a. Specifying Files and Adding Additional Dump Files b. Default Locations for Dump, Log, and SQL Files • Moving Data Between Different Database Versions • Original Export and Import Versus Data Pump Export and Import • How Data Pump Export Parameters Map to Those of the Original Export Utility • How Data Pump Import Parameters Map to Those of the Original Import Utility 2. RMAN Concepts • Configuring the Environment for RMAN Backups a. Showing and Clearing Persistent RMAN Configurations b. Configuring the Default Device for Backups: Disk or SBT c. Configuring the Default Type for Backups: Backup Sets or Copies d. Configuring Channels e. Configuring Control File and Server Parameter File Autobackups f. Configuring RMAN to Make Backups to a Media Manager g. Configuring the Backup Retention Policy h. Configuring Backup Optimization i. Configuring Oracle Flashback Database and Restore Points • About RMAN Channels a. Channel Control Options for Manual and Automatic Channels b. Channel Failover • About RMAN Backups About Image Copies • RMAN Backup Types a. Incremental Backups b. RMAN Backup Errors c. Tests and Integrity Checks for Backups d. Detecting Physical and Logical Block Corruption e. Backup Validation with RMAN • Restoring Files with RMAN a. Mechanics of Restore Operations b. File Selection in Restore Operations c. Datafile Media Recovery with RMAN d. Mechanics of Recovery: Incremental Backups and Redo Logs e. Incomplete Recovery f. Tablespace Point-in-Time Recovery g. Block Media Recovery with RMAN • Database Duplication with RMAN (CLONING) 3. User-Managed Backups • Cold Backup (consistent Backup) a. Take details of database Files& proceed with backup • Cold Backup (inconsistent Backup) a. Querying V$ Views to Obtain Backup Information b. Listing Database Files Before a Backup c. Determining Datafile Status for Online Tablespace Backups d. Making User-Managed Backups of the Whole Database e. Backing Up the Control File to a Binary File f. Backing Up the Control File to a Trace File • Running the DBVERIFY Utility Who should attend • Freshers to make their career into IT / Software Field as Data Base Administrator(DBA). • BPO guys, people who are working in different fields and want to become a DBA. What you need to bring We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course." Call us on Key Takeaways • Strong RDMBS knowledge • Way to proceed for the next step which is Oracle Performance Tuning at Administrator level.