Database system concepts fifth

Database system concepts, fifth edition by Abraham silberschatz, Henry, sudarshan

Database system concepts and Let us C books in good condition

Module: SAP Basis SAP BASIS is a complete administration of the SAP system. SAP BASIS consultant mostly works on SAP administration. From The Installation of the software, maintaining the efficient database, optimizing the system, security of the system etc. is the role of the BASIS consultant. There is always a demand for Good BASIS consultant who understands the System in and out from administration perspective.  Prerequisite for training  Bachelor degree in engineering and computer application (BCA)  Postgraduate degree/diploma (MCA, MCS etc.)  Working experience in related field (Database, UNIX, etc.) would be an added advantage  Training Course Content  Introduction  Introduction to SAP R/3  SAP R/3 Architecture  Central System  Distributed Presentation  2-Tier Configuration  3-Tier Configuration  System Landscape & Flow  Single System Landscape  Two System Landscape  Three System Landscape  Multi System Landscape  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  GUI Administrator  Optimization  Security  Operation Modes  Manual Switching of OP Modes  Exceptional Mode  Monitoring  Profile Maintenance & Parameter Setting  System Profile  Transport Profile  Client Profile  Authorization Profile  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  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  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  Change and Transport System  Releasing and Transporting Change Request and Tasks  Customizing, Workbench, Transport Organizer  Importing Change Requests  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  Patch and Kernel Administration  Checking the Patch, Spam, Kernel levels  Downloading Installing Patches, Kernel  Applying at OS Level, SAPNET, Front-End  Troubleshooting Various Issues  CCMS  Introduction to CCMS  CCMS Monitors  Alert Monitors  Analyzing Alerts and Performance Tuning  Background Processing  Background Dialogs Concept  Defining Jobs  Analyzing Jobs  Maintenance Jobs  Distributed R/3 System  Creating Regular Instance  Creating Logon Groups for Load Balancing  OSS and SNote Concepts  How to Use for Different Purposes  Manually Applying OSS note on SAP Standard Program  SAP Router  Installation of SAP Router  Creating Route Permission Table  Setting Route String Entry for SAP Router  Using Various Administrative Options  Database Management  Introduction to Oracle  Oracle Architecture  Introduction to SAPDBA  Creating Tables and Table Space Adjustment  Database Backup, Restore and Recovery  Performance Tuning  OS, H/W Performance Considerations  Memory, Management  R/3 Buffers, Page Buffers, Extended and Heap Memory, PRIV Mode  System Monitoring  Daily, Weekly, Monthly Tasks  SAP Implementation Strategy  Connectivity between R/3 and BW  BW Architecture  Defining and Assigning Logical Systems  Workbench Administration  SAP NetWeaver  Trainer’s Profile  Working consultants, Module Leads and Project Managers with CMM level 5 companies  Freelancers  Extensive exposure on various projects covering end-to-end implementation, upgrades, rollouts, enhancements, supports etc.  Excellent flair of consulting and training  Course Duration  Flexible training schedule  60+ hours of class room training  Weekdays & Weekend batches  Course Fee  Rs. 30,000 (INR)  System Access  24X7 access to SAP software via internet across globe.  Additional Features:  Fully comprehensive and practical approach in transferring knowledge  Provision of configuration steps  Provision of study material strictly from interview point of view  Comprehensive test towards the end of the course  Preparation for interview  Reformatting of CV  Contact detail  +91-9325793756 (info@learninghub.co.in)

Compiler Design by Alfred VAho Database System Concepts by S Sudarshan, F Korth, Abraham Cputer Organization by Carl Haamcher (The bible) Introduction to Algorithms by Thomas H Cormen Digital Logic and Computer Design by M Morris Mano Discrete Mathematics and it's Application by Keneth Rosen An introduction to Formal Languages and Automata Arihant GATE with all newly added topics and latest syllabus A free gift AHandbook on Computer Science and IT Made Easy Short and Formula Guide

Type Tutoring ETL Testing Online Training from Hyderabad Course Content: DATA WAREHOUSING CONCEPTS: DBMS and RDBMS What is Data Warehousing and necessity of it? Data warehousing architecture OLAP,ROLAP, MOLAP Data mining Meta data Tables, views Constraints Fact and Dimensional Tables Partitioning of tables Concepts of Referential Integrity Concepts of Modeling Database Schema Concepts of normalization Concepts of Slowly Changing Dimensions Concepts of Data Mart Full and Incremental extraction Process Change Data capture SQL CONCEPTS: DDL, DML commands All the basic functions Joins Practice SQLs for some sample test scenarios ETL TESTING: What is ETL and importance of ETL testing? Creating, running and analyzing sessions/workflows in Informatica Preparation of Test strategy, Test plan and estimations Testing scenarios, creation of test cases and scripts Test case execution and defect tracking and reporting REPORT TESTING: Validation of the report data with DB and UI testing Preparation of Test data LEVELS OF TESTING Unit testing Integration testing Module testing System testing UAT PRACTICE SESSIONS ON ETL TESTING

Type Tutoring The Best Abinitio Online Training Institute From Hyderabad,India Course Content: Introduction to Data Warehousing Role of ETL Introduction to Ab Initio Ab Initio Tool Components Architecture of Ab Initio Connectivity between GDE and CO What Ab Initio Programming? Graph Components Graph Components DML – Data Manipulation Language To Prepare the Data (.dat) file Component Layouts Graph Development, Execution and debugging Dataset components Input file Output file Lookup file Intermediate fileInput table Output table Partition Concepts Data parallelism Pipeline parallelism Component parallelism Partition & De-Partition components Broadcast Partition by key Partition by Expression Partition by Percentage Partition by Range Partition by Round-Robin Partition with load balancing De- Partition Components Concatenate Gather Interleave Merge MFS (Multi-File system) MFS file system concepts Difference between serial and MFS file system Introduction to Sub-graphs Parameters and Input parameters Variables, Statements and Business Rules Sort components Sort Sort within groups Sample Find splitter Partition by key and sort Transform Components Aggregate Filter by Expression Roll-up Scan Scan with roll-up Join De-dup Sorted Match- sorted Reformate Multi-reformate Normalize and De-Normalize Database Components Input table Output table Truncate table Update table Join with DB Multi update table Run SQL Compress Components Compress Deflate Inflate Uncompress FTP Components FTP to FTP from Miscellaneous Components Gather Logs Redefine format Replicate Run Program Throttle Trash Generate EME (Enterprise Meta Environment) Tool Introduction and Overview

Contact us: +91-, The Best SAP BO Online Training Institute From Hyderabad, India Course Content: Introduction to Data Warehousing Role of ETL Introduction to Ab Initio Ab Initio Tool Components Architecture of Ab Initio Connectivity between GDE and CO What Ab Initio Programming? Graph Components Graph Components DML – Data Manipulation Language To Prepare the Data (.dat) file Component Layouts Graph Development, Execution and debugging Dataset components Input file Output file Lookup file Intermediate fileInput table Output table Partition Concepts Data parallelism Pipeline parallelism Component parallelism Partition & De-Partition components Broadcast Partition by key Partition by Expression Partition by Percentage Partition by Range Partition by Round-Robin Partition with load balancing De- Partition Components Concatenate Gather Interleave Merge MFS (Multi-File system) MFS file system concepts Difference between serial and MFS file system Introduction to Sub-graphs Parameters and Input parameters Variables, Statements and Business Rules Sort components Sort Sort within groups Sample Find splitter Partition by key and sort Transform Components Aggregate Filter by Expression Roll-up Scan Scan with roll-up Join De-dup Sorted Match- sorted Reformate Multi-reformate Normalize and De-Normalize Database Components Input table Output table Truncate table Update table Join with DB Multi update table Run SQL Compress Components Compress Deflate Inflate Uncompress FTP Components FTP to FTP from Miscellaneous Components Gather Logs Redefine format Replicate Run Program Throttle Trash Generate EME (Enterprise Meta Environment) Tool Introduction and Overview

Contact us: Vani, +91-, ETL Testing Online Training from Hyderabad Course Content: DATA WAREHOUSING CONCEPTS: DBMS and RDBMS What is Data Warehousing and necessity of it? Data warehousing architecture OLAP,ROLAP, MOLAP Data mining Meta data Tables, views Constraints Fact and Dimensional Tables Partitioning of tables Concepts of Referential Integrity Concepts of Modelling Database Schema Concepts of normalization Concepts of Slowly Changing Dimensions Concepts of Data Mart Full and Incremental extraction Process Change Data capture SQL CONCEPTS: DDL, DML commands All the basic functions (Character Functions, Conversion Functions, Advanced functions, Mathematical Functions and Date Functions) Joins Practice SQLs for some sample test scenarios ETL TESTING: What is ETL and importance of ETL testing? Creating, running and analysing sessions/workflows in Informatica Preparation of Test strategy, Test plan and estimations Testing scenarios, creation of test cases and scripts Test case execution and defect tracking and reporting REPORT TESTING: Validation of the report data with DB and UI testing Preparation of Test data LEVELS OF TESTING Unit testing Integration testing Module testing System testing UAT PRACTICE SESSIONS ON ETL TESTING

All the books are in excellent condition. All are latest edition. Ready to sell even single book also. 1) Communication System by Singh (TMH) 2) Fundamentals of Computer Algorithms by Horowitz 3) Data Structures by Lipshutz (TMH) 4) Database Management Concepts by Ashutosh Kumar Dubey 5) Electronic Device and Circuits by Sanjay Sharma 6) Computer System Architecture by Mano (Pearson) 7) Analog and Digital Communication by J S Katre

Contact Person: Monika People Click Techno Solutions pvt. ltd. , 080 Solution Manager 1. over view of solution manager 2. Pre-requisites and Installation 3. Incident Management 4. Change request management 5. Test Management 6. Business process Monitoring 7. E learning 8. Solution Implementation 9. Solution Documentation 10. Solman RFC Creation 11. Managed system connection 12. Basis stuffs on Solution manager 13. Organisation Structure 14. Service Level Agreement 15. Authorization and Security (Solution manager Related) -Roles and responsibilities 16. Early Watch Alert 17. ABAP Custom code (Solution manager Related) 18. Client copy 19. CDMC, DVM, RBPD 20. Solman Database archival concepts

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

TekSlate’s syndicate of online trainers are experienced experts in knowledge transfer. The best place for learning, if you are aiming to learn the crux of any technology Big Data Green Plum DBA Online Training Course Content: Greenplum Architecture Greenplum Master Greenplum Segments Greenplum Interconnect Greenplum Concepts, Features and Benefits Redundancy and Failover in Greenplum Database Segment Mirroring Master Mirroring Data Distribution in greenplum Checking for Uneven Data Distribution Database Installation and Configuration Lab – Database Installation and Configuration Access Control and Security Managing Roles and Privileges Security Best Practices for Roles and Privileges Creating New Roles (Users) Altering Role Attributes Creating Groups (Role Membership) Managing Object Privileges Configuring Client Authentication Allowing Connections to Greenplum Database Editing the pg_hba.conf File Limiting Concurrent Connections Accessing the Database Establishing a Database Session Supported Client Applications Greenplum Database Client Applications PgAdmin III for Greenplum Database Database Application Interfaces Third-Party Client Tools Troubleshooting Connection Problems Lab Managing Workload and Resources Overview of Greenplum Workload Management How Resource Queues Work in Greenplum Database Steps to Enable Workload Management Configuring Workload Management Resource Queues Database Administration Defining Database Objects (databases, schema, table, sequence etc) Creating and using databaseso Creating and using schemas Creating and Using Sequences Indexes in Greenplum Database Creating and Managing Views Managing Data Vacuuming the Database Querying Data Query Performance EXPLAIN Output, EXPLAIN ANALYZE Output Partitioning Large Tables Understanding Table Partitioning in Greenplum Database Deciding on a Table Partitioning Strategy Creating Partitioned Tables Loading Partitioned Tables Maintaining Partitioned Tables Lab Greenplum Database Loading Tools Overview About External Tables About gpload About COPY Using the Greenplum Parallel File Server (gpfdist) System Administration Starting and Stopping Greenplum Routine admin tasks Uploading Configuration File Changes Only Configuring Your Greenplum System About Greenplum Master and Local Parameters Setting Configuration Parameters Setting a Local Configuration Parameter Setting a Master Configuration Parameter Enabling Alerts and Notifications Checking for Failed Segments Recovering a Failed Segment Recovering a Failed Master Backing up and Restoring Databases Backup and Restore Operations Expanding a Greenplum System Lab Monitoring a Greenplum System Monitoring Database Activity and Performance Monitoring System State Enabling System Alerts and Notifications Checking System Stateo Checking Disk Space Usage Routine System Maintenance Tasks Routine Vacuum and Analyze System Catalog Maintenance Managing Greenplum Database Log Files Performance Tuning Common Causes of Performance Issues Identifying Hardware and Segment Failures Managing Workload Maintaining Database Statistics Identifying Statistics Problems in Query Plans Tuning Statistics Collection Optimizing Data Distribution Optimizing Your Database Design Lab GP-development Functions Basic shell scripts Investigating a Performance Problem Checking System State Checking Database Activity Checking for Active Sessions (Workload) Checking for Locks (Contention) Checking Query Status and System Utilization Troubleshooting Problem Queries gp_toolkit administration schema System catalog Performance issues and tips Automation scripts for GPDB administration Lab Materials/tools used 1. Training ppts 2. Greenplum admin guide. 3. Greenplum installation guide. 4. Pg admin installer for windows. (Greenplum client for windows) 5. Greenplum community edition. 6. Putty 7. GP connectivity tools. Expected from audience (for Lab) 1. Laptop or desktop with centos installed. 2. Internet.

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.