Export import training

Export import training available for new students and those who wanted to start company.practical oriented.GST updated. highly experianced chartered engineer will take classes. Real time work will be given.Classes at cochin or manjeri (mob)9.4.9.5.77.0.364

Hello friends & students Arrow creative class welcome you all for a new updated export & import training program., Practical classes taken by a real time exporter who is currently doing consignment to overseas market. We focus on, company Introduction business Intro iec product Search product List product Choosing promotion Activities search Buyers business Categories seo geo social Media mobile Apps pricing quotation & terms deec professional communication with buyers payment terms shipping transaction incentive claiming leads conversion. We also help the new entrepreneurs in importing all kind of goods from overseas market. Touch with us. mr.Selvam

Export Business Training, Export Import Training, Export Business Training in Madurai, Export Training in Tamil, Export Business Consultant, Export Business Consultancy, Export Business Training Center, Export Training Centre, Export Training in Tamil Nadu, Export Business Coaching Classes, Export Coaching Classes, Export Business Tactics, Export Marketing Tactics

let me introduce our company Aryan incorporation, we are export importer doing business many years. we provide full training of export import practical knowledge, port visit, communication skill, how to find foreign buyers, all documentation. complete knowledge of foreign trading as all necessary help to start your own business we provide with every single detail. we will help you to bstart your own company and settle it on bright track.

Special RESIDENTIAL TRAINING From 12 July to 15 July 2017 With Lifetime Support Special 25% Discount With Free AC Hotel STAY and FOOD EXPORT IMPORT PRACTICAL TRAINING Become successful Exporter Training on your Product

Want distance learning courses from reputed university? which will help you build a great career for yourself.complete your (Executive)MBA and MBA in Export & Import Management from Karnataka State Open University, and HR Remedy will provide you training and job assistance for more information call gunjan- or walk-in to HR Remedy, baner road,pune office.

Job oriented course, Placement assistance!!!! Well trained and experienced faculties. Diploma in logistics and transport Certificate in logistics & transports MBA In (Shipping & Logistics) FEATURES • Quality Management System • Talented faculty • Excellent Practical Training facility • Career Guidance and Counselling • Placement and Training • Industrial Visit / Industrial Projects • On Campus and Off Campus Interviews • Value Addition Programs • Aptitude Tests, Group Discussions and Technical Tests Affordable Fees Structure with Easy EMI Qualification Details: 10th, 12th to Any Degree (Pass/Fail, Discontinue)

We conduct Training Program for Freshers for a career in Customs Clearing and Forwarding(C&F) Industry- Export/Import/ Sea/Air (Field Work only)- Job Placement Guidance given-Male Fresher’s only: Education:+2 pass/ or any Degree < 30 Yrs age can apply. Experienced candidates can also apply.

Learn how to do export and import effectively. Enroll for Export and Import management program as well as Online Marketing program along with Practical Training by iiiEM. Start your career in booming industry. Prfoessional export and import programs by iiiEM that sharpen your skills.

Based at Madurai, we, "Happy Export Learning Program (HELP) Center" is India's Premier Training Institute engaged in providing effective training to our clients in Export Business Management. Our range of services includes providing assistance to the clients in their Export Business and Export License. We are one of the renowned Export Training Institutes of the city involved in providing knowledge and excellence to our clients about foreign trade. With the support of our Export Consultants and Export Training Consultants, we are able to provide reliable consultancy services to the patrons. As the international trade industry is continually growing, there is an increasing need of professional proficiency in this domain. In the forthcoming Foreign Trade Policy, the Government of India is taking efforts towards tripling export turnover. Our institute has become the main scientific and professional referral for trade sector. We aim to provide a broad spectrum of activities including research, training and consultation services. Due to globalization, there is a great opportunity to participate in world of global market. To meet the competitiveness of products in the world markets, right type of guidance and training is needed. We, in all aspects, encourage and promote the study of policy and practice of international trade. Our Team With the aid of our team of diligent professionals, we are able to offer full assistance and guidance to our trainees in the field of foreign trade. Our institute has maintained a strict criteria for the selection of professionals based on education and knowledge. These professionals have great knowledge of export and import management. All the trainers at our institute have vast experience of serving in this domain. Under the guidance of expert professionals, excellent training sessions are held. Training consultants aim to give the best possible solution to the problems of our valued patrons.

General Consultancies, Readymade Garment Consultancy, Fashion Design, Readymade Manufacturing, Import And Export Consultancy, Project Report Consultancy, Enterprise Establishments Consulting Services, TRAINING COURSES, Fashion Design Classes, Import Export Management Classes, Digital Photography Classes, Entrepreneurship Development Classes, Spoken English Classes, Preparation For Banking Classes, Preparation For CBLR Exam Customs House Agent Brocker Classes, Preparation for Gcard Custom Brokers Assistant Exam Classes

Best TERA DATA Training Institute in Chennai with placement… No 1. Best TERA DATA training institute in Chennai adyar.. Course Name : TERA DATA Course Duration : 40-45 Hrs For More details contact 9790855020 “Peridot systems provide professional Training in Chennai with live projects and 100% job assistant.” Benefits of peridot systems: Mock interviews to simulate and help students face job interviews Real time project and examples to support practical learning Every course is trained by working professionals only Flexible weekend classes and special weekday classes Teradata Course Syllabus INTRODUCTION TO TERADATA Architecture Comparative Study between Teradata an Other RDBMS Database Components and function Parallel Architecture and processing the table Factor affecting data storage and distribution RDBMS & Normalization { 1st – 3rd Normal form } Data-warehouse Concepts { Surrogate Keys , SCD etc} Administrative tools TERADATA SQL Data Dictionary Primary keys, Foreign keys, Primary Indexes, and Secondary Indexes in a Teradata system Advance SQL SQL Performance Tuning TERADATA APPLICATION UTILITIES BTEQ (Export/Import), Fast Export, Fast Load, MultiLoad and Tpump for batch processing Internal working of above utilities Using utilities – Choose above utilities when and why TPT and its advantage over traditional utilities like Fast Load, MultiLoad etc. Contact us: 9790855020 Land Line No : 044-42115526 Mail To: syed.noor@peridotsystems.in Website: http://www.peridotsystems.in Related Tags: Teradata Training in Chennai | Best Teradata Training in Chennai | Corporate Training for Teradata |Corporate Training for Teradata. | Best Teradata Online Training in Chennai

Best TERADATA Training with placements in Chennai- Peridot Systems is the one of the best IT training institute in Chennai. Our training reflects the latest techniques and technologies and that are developed from practical knowledge gathered from years of experience. Learning from the real time working professionals is the only way to gain knowledge thatr how actually happens in the real IT world. Beneficiary •We get the job referral information from various industries •We have tie ups with India’s leading consultancies and companies who recruit fresher and laterals. •Free Demo sessions •Free of software installation •Full-fledged Lab facility •Technical support till one year by our faculty Teradata Course Details •Architecture •Comparative Study between Teradata an Other RDBMS •Database Components and function •Parallel Architecture and processing the table •Factor affecting data storage and distribution •RDBMS & Normalization { 1st – 3rd Normal form } •Data-warehouse Concepts { Surrogate Keys, SCD etc} •Administrative tools TERADATA SQL •Data Dictionary •Primary keys, Foreign keys, Primary Indexes, and Secondary Indexes in a Teradata system •Advance SQL •SQL Performance Tuning TERADATA APPLICATION UTILITIES •BTEQ (Export/Import), Fast Export, Fast Load, MultiLoad and Tpump for batch processing •Internal working of above utilities •Using utilities – Choose above utilities when and why •TPT and its advantage over traditional utilities like Fast Load, MultiLoad etc. Contact Details: Contact Person-Sinduja Contact Number- Venue: No-84/8 venkatarathinam nagar, LB road, Adyar, Chennai- Tags: Best Teradata Training with placements in Chennai || Best Teradata Training instititue in Chennai || Best Teradata training course in chennai

Oracle DBA Training Course Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today. Database Administrator Job Growth DBAs play an important and responsible role in every company's Information Technology (IT) department. PRE-REQUISITES: SQL, PL/SQL,LINUX. INTRODUCTION TO ORACLE Exploring the Oracle Database Architecture Creating an Oracle Database Managing the Database Instance Managing Database Storage Structures (Table spaces & Segments) Administering User Security Managing Data Concurrency Managing Undo Data Configuring the Oracle Network Environment Backup and Recovery Concepts (cold, hot & RMAN) Use of RMAN Recovery Catalog & Configuring Backup Settings Performing Database Backups with RMAN Performing Database Recovery Moving Data - Export & Import, External Tables & SQL Loader Using Flashback Technology I Using Flashback Technology II Implementing Oracle Database Auditing Implementing Oracle Database Auditing Database Maintenance Performance Management Managing Performance by SQL Tuning Diagnosing the Database Managing Space Managing Space for the Database Managing the ASM Instance Duplicating a Database / Cloning Database Data Guard Installing your Oracle Software Database Patches & Database Upgrades Introduction to Real Application Clusters OLTP vs OLAP Data modeling Snake-Flow diagram Dimensions and Facts IQD preparation IQD publishing Cube generation Cube publishing into portal Validations Adhoc reports Zero suppression reports Performance and Tuning with OLAP Backup and recovery in OLAP If you want to know more about Oracle DBA Training do not hesitate to call +91-9393 002 123 or mail us on info@unitedglobalsoft.com

ORACLE DBA TRAINING Oracle DBA Training Course Overview Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today. Database Administrator Job Growth DBAs play an important and responsible role in every company's Information Technology (IT) department. PRE-REQUISITES: SQL, PL/SQL,LINUX. INTRODUCTION TO ORACLE Exploring the Oracle Database Architecture Creating an Oracle Database Managing the Database Instance Managing Database Storage Structures (Table spaces & Segments) Administering User Security Managing Data Concurrency Managing Undo Data Configuring the Oracle Network Environment Backup and Recovery Concepts (cold, hot & RMAN) Use of RMAN Recovery Catalog & Configuring Backup Settings Performing Database Backups with RMAN Performing Database Recovery Moving Data - Export & Import, External Tables & SQL Loader Using Flashback Technology I Using Flashback Technology II Implementing Oracle Database Auditing Implementing Oracle Database Auditing Database Maintenance Performance Management Managing Performance by SQL Tuning Diagnosing the Database Managing Space Managing Space for the Database Managing the ASM Instance Duplicating a Database / Cloning Database Data Guard Installing your Oracle Software Database Patches & Database Upgrades Introduction to Real Application Clusters OLTP vs OLAP Data modeling Snake-Flow diagram Dimensions and Facts IQD preparation IQD publishing Cube generation Cube publishing into portal Validations Adhoc reports Zero suppression reports Performance and Tuning with OLAP Backup and recovery in OLAP

classroom/online Training SAP Basis, SAP Basis institute Elegant it services in Marathahalli. INTRODUCTION TO ERP • Introduction to SAP R/3 2. SAP R/3 ARCHITECTURE • Central System • Distributed Presentation • 2-Tier Configuration • 3-Tier Configuration 3. SYSTEM LANDSCAPE AND FLOW • Single System Landscape • Two System Landscape • Three System Landscape • Multi System Landscape 4. INSTALLATION OF SAP • Installation Concepts on Windows & UNIX and Quick Sizing • Naming Convention, Software Kit, SAP Licensing • Installation Procedure - Windows Application Server for UNIX SAP System • R/3 Directory Structure, Kernel 5. OPERATION MODES AND SYSTEM HEALTH CHECKS. • Daily,Weekly health checks. • Manual Switching of OP Modes • Exceptional Mode • Monitoring 6. PROFILE MAINTENANCE & PARAMETER SETTING • System Profile • Transport Profile • Client Profile • Authorization Profile 7. USER ADMINISTRATION • Creating and Maintaining Master Records, Architecture • Logon and Password Security, Protecting Special Users • Creating and Maintaining Single and Mass Users and User Groups • Copying, Deleting, Locking/Unlocking Users • Explanation of Terms Object Class, Authorization Object, Authorization, Profile • Create/Maintaining Authorization/Profile Manually • Create/Maintaining Roles/Generating Profiles by using PFCG 8. CLIENT ADMINISTRATION • Client Maintenance • Copying Client within R/3 System (Local) • Copying client between R/3 Systems (Remote) • Export/Import • Protecting Client • Monitoring and Verifying a Client Copy • Deleting Client • Tips and Troubleshooting 9. TRANSPORT MANAGEMENT SYSTEM • TMS Terminology and Concepts • Configuring TMS and Checking Transport Directory • Configuring Transport Domain, Domain Controller and Group • Configuring Virtual SAP System and Displaying Configuration • Including SAP systems in the Transport Domain • Creating Consolidation and Delivery Routes • Maintaining SAP Systems without Common Transport Directory • Configuring External Systems • Locking and Unlocking TMS for a SAP System • Deleting SAP System from the Transport Domain • Deleting TMS Configuration. • Importing Transport Requests. 10. SPOOL ADMINISTRATION • Print related Terminology in OS/SAP Level • Setting Local, Remote and Front-End Printing • Logical and Real Spool Server • Managing Spool Requests using Output Controller • Connecting Output Devices to Window System • SAPLPD, TemSE, Authorization 11. PATCH AND KERNEL ADMINISTRATION • Checking the Patch, Spam, Kernel Levels • Downloading Installing Patches, Kernel • Applying at OS Level, SAPNET, Front-End • Troubleshooting Various Issues. 12. CCMS • Introduction to CCMS • CCMS Monitors • Alert Monitors • Analyzing Alerts and Performance Tuning. 13. BACKGROUND PROCESSING • Background Dialogs Concept • Defining Jobs • Analyzing Jobs • Maintenance Jobs 14. OSS AND SNOTE CONCEPTS • How to Use for Different Purposes • Manually Applying OSS note on SAP Standard Program 15. DATABASE MANAGEMENT • Introduction to Oracle • Oracle Architecture • Introduction to SAPDBA • Creating Tables and Table Space Adjustment • Database Backup, Restore and Recovery 16. PERFORMANCE TUNING • OS, H/W Performance Considerations • Memory, Management • R/3 Buffers, Page Buffers, Extended and Heap Memory, PRIV Mode 18.SAP NETWEAVER JAVA. • Concepts of Java Thanks&Regards Elegant IT Services, #nd Floor,Aswath Nagar Varthur main road,Near Railway Fly Over Maratha halli,Land mark: Chemmunar Jewellers, Bangalore

We have the best translators for Document translation, Machine Installations, Board meetings, Export Import business, Trade Fares, Conference, and Tourism or other services We are in this field for past 18 years. Our motive is to provide great service at best price with good degree of satisfaction of the customers. Related CHINESE TO ENGLISH, ENGLISH TO CHINESE GERMAN TO ENGLISH, ENGLISH TO GERMAN ITALIAN TO ENGLISH, ENGLISH TO ITALIAN FRENCH TO ENGLISH, ENGLISH TO FRENCH DUTCH TO ENGLISH, ENGLISH TO DUTCH PROTUGUSE TO ENGLISH, ENGLISH TO PROTUGUSE HINDI TO ENGLISH, ENGLISH TO HINDI PUNJABI TO ENGLISH, ENGLISH TO PUNJABI URDU TO ENGLISH, ENGLISH TO URDU KOREAN TO ENGLISH, ENGLISH TO KOREAN JAPANESE TO ENGLISH, ENGLISH TO JAPANESE

SAP HANA COURSE CONTENT ******************* SAP HANA 1.0 ********************** Lesson 1. Overview SAP HANA 1.0 Lesson 2. Product Availability Matrix(Supported H/w Vendors Platform) Lesson 3. Architecture 3.1 SAP HANA Appliance Architecture View 3.2 SAP HANA Database Engine View 3.3 SAP HANA Data-Loading View 3.4 SAP HANA Data-Modeling View 3.5 SAP HANA Reporting View 3.6 SAP HANA Administrator View Lesson 4. SAP HANA System Landscapes Lesson 5. SAP HANA System Sizing Guidelines Lesson 6. Data Provisioning 6.1 Via Data Services 6.2 Via Replication (Landscape Transformation) Lesson 7. SAP HANA Studio view Lesson 8. SAP HANA Modeling 8.1 Attribute View 8.2 Analytic View 8.3 Calculation View 8.4 Export & Import Lesson 9 SAP HANA Reporting 9.1 Client connectivity options 9.2 SAP BO BI 4.0 9.3 MS-Excel 9.4 SAP BO Analysis Thanks Saritha Reddy Contact: +91-9972971235,+91-9663233300 Madhukar.dwbi@gmail.com http://www.sap-bo-online-training.com/sap_hana_sp7.php

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today. Database Administrator Job Growth DBAs play an important and responsible role in every company's Information Technology (IT) department. PRE-REQUISITES: SQL, PL/SQL,LINUX. INTRODUCTION TO ORACLE Exploring the Oracle Database Architecture Creating an Oracle Database Managing the Database Instance Managing Database Storage Structures (Table spaces & Segments) Administering User Security Managing Data Concurrency Managing Undo Data Configuring the Oracle Network Environment Backup and Recovery Concepts (cold, hot & RMAN) Use of RMAN Recovery Catalog & Configuring Backup Settings Performing Database Backups with RMAN Performing Database Recovery Moving Data - Export & Import, External Tables & SQL Loader Using Flashback Technology I Using Flashback Technology II Implementing Oracle Database Auditing Implementing Oracle Database Auditing Database Maintenance Performance Management Managing Performance by SQL Tuning Diagnosing the Database Managing Space Managing Space for the Database Managing the ASM Instance Duplicating a Database / Cloning Database Data Guard Installing your Oracle Software Database Patches & Database Upgrades Introduction to Real Application Clusters OLTP vs OLAP Data modeling Snake-Flow diagram Dimensions and Facts IQD preparation IQD publishing Cube generation Cube publishing into portal Validations Adhoc reports Zero suppression reports Performance and Tuning with OLAP Backup and recovery in OLAP

SADGURUTECHNOLOGIES - 8179736190 04040154733 • INTRODUCTION to ORACLE • Exploring the Oracle Database Architecture • Creating an Oracle Database • Managing the Database Instance • Managing Database Storage Structures (Tablespaces & Segments) • Administering User Security • Managing Data Concurrency • Managing Undo Data • Configuring the Oracle Network Environment • Backup and Recovery Concepts (cold, hot & RMAN) • Use of RMAN Recovery Catalog & Configuring Backup Settings • Performing Database Backups with RMAN • Performing Database Recovery • Moving Data - Export & Import, External Tables & SQL Loader • Using Flashback Technology I • Using Flashback Technology II • Implementing Oracle Database Auditing • Database Maintenance • Performance Management • Managing Performance by SQL Tuning • Diagnosing the Database • Managing Space • Managing Space for the Database • Managing the ASM Instance • Duplicating a Database / Cloning Database • Data Guard • Installing your Oracle Software • Database Patches & Database Upgrades • Introduction to Real Application Clusters Contact Us: SADGURU TECHNOLOGIES H. No: 7-1-621/10, Flat No: 102, SaiManor Apartment, S.R. Nagar Main Road, Hyderabad-500038, Landmark: Beside Umesh Chandra Statue,Mob: 91-8179736190, Ph: 040-40154733

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.

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.

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.