Sql server database administrator

-
loading
Ads with pictures

SQL SERVER & SQL SERVER DBA ONLINE TRAINING

Online Classes and training for SQL Server & Microsoft SQL Server Database administrator with real time scenarios and flexible timings
Hyderabad (Andhra Pradesh)

ORACLE DATABASE ADMINISTRATOR WITH 2 4 YRS OF EXPERIENCE

Skills and Competencies: • Verbal and written communication skills, problem solving skills, customer service and interpersonal skills. • Strong ability to work independently and manage working time. • Strong knowledge in SQL, PLSQL, Oracle, etc. • Enough exposure in JAVA. Major Job Duties and Responsibilities: • Installing and upgrading the database server and application tools • Allocating system storage and planning future storage requirements for the database system • Modifying the database structure, as necessary, from information given by application developers • Enrolling users and maintaining system security • Ensuring compliance with database vendor license agreement • Controlling and monitoring user access to the database • Monitoring and optimizing the performance of the database • Planning for backup and recovery of database information • Maintaining archived data • Backing up and restoring databases • Contacting database vendor for technical support • Generating various reports by querying from database as per need
India

SHAREPOINT ADMINISTRATOR TRAINING ON

1.Introduction of Sharepoint 2013 •Sharepoint Three Tier Architecture •Sharepoint version history •Sharepoint 2013 Structure and capabilities •Significant changes from sharepoint 2010 •Hardware & software prerequisites for sharepoint 2013 2.Installation and Sharepoint Farm configuration •Hardware & Software Requirements •Install and configure Windows server 2008 r2 service pack1/ windows server 2012 •Install active directory domain services •Install sql server 2008 r2 service pack 1/ sql server 2012 •Install & configure sharepoint server 2013 3.Sharepoint site hierarchy •Creating Web application •Creating sitecollection •Creating list •Managing list columns and views •Using site columns, lookup fields •Check in/ check out and versioning settings for document library 4.Creation and configuration of wikis, blogs and surveys •Blogs •Survey •Discussion board 5.Security and permission management •Permission settings at site collection, sub sites list and item level •Configuring custom permission •Stop parent permissions •App identity 6.Managing web application and recommendation for port number, database and security •Web application settings •Content database •IIS websites 7.Managing Site collection and databases •Site collection and database quota •Add multiple content databases with single web application •Creating group and assigning permission accordingly 8.Retention Policy Management though Workflow •Configuration of Retention Policy •Creation of Workflow •Attaching workflow for Retention Policy •Retention Policy Workflow Timer Job configuration 9.Enterprise managed metadata services and user profile services •Creating terms and term stores •Using managed metadata in lists in libraries •User profile service configuration •User profile properties management •Synchronization services •My sites 10.Sharepoint designer, Logical structure of site and External content type •Installation of sharepoint designer 2013 •Creating and opening site in sharepoint designer 2013 •Creating and opening List/ library in sharepoint 2013 •Creating connection with external data source (Sql Server) 11.Search service application •Search service application overview •Site search configuration •Result types •Query rules •Search webparts 12.Backup and restore using PowerShell and running PowerShell script using Powershell_ISE •Overview of Backup options •Farm/ site backup and restore •Content backup and restore •Granular Backup of site collection 13.Upgrade and migration •Migration path and approaches •DB attach migration
India

ORACLE DBA TRAINING IN HYDERABAD

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
India

PROFESSIONAL TRAINING ON ORACLE 11G DBA: 3RI TECHNOLOGIES, P

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.
India

PROFESSIONAL TRAINING ON ORACLE 11G DBA: 3RI TECHNOLOGIES, P

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.
India

PROFESSIONAL TRAINING ON ORACLE 11G DBA: 3RI TECHNOLOGIES,

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.
India

ORACLE DBA ONLINE TRAINING IN INDIA

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
Hyderabad (Andhra Pradesh)

ORACLE DBA CLASSROOM TRAINING IN INDIA

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
Hyderabad (Andhra Pradesh)

FOREST SURVEY OF INDIA RECRUITMENT

Forest Survey of India (FSI) Dehradun invites applications for engagement of Technical Professionals for DIP / GIS / MIS related work under various Projects/ Plan Scheme. The last date for submission of applications is 4th September . About: Forest Survey of India (FSI) is a national organization under the Ministry of Environment, Forests & CC, Government of India and is responsible for forest resource assessment of the country. Name of the Post: Technical Associates No of Vacancies: 28 Emoluments (Per Month): % HRA) Name of the Post: Solution Architect (Application/ Software's) No of Vacancies: /- All inclusive Name of the Post: Senior Developer -GIS Expert No of Vacancies: 01 Emoluments (Per Month): /- All inclusive Name of the Post: Database Administrator No of Vacancies: 01 Emoluments (Per Month): /- All inclusive Name of the Post: Softwares Supports Executives (Application) No of Vacancies: 01 Emoluments (Per Month): /- All inclusive Name of the Post: GIS Analyst No of Vacancies: 01 Emoluments (Per Month): /- All inclusive Age Limit: The upper age limit is 30 years as on the last date of submission on online application. The upper age limit is relaxable upto 5 year in the case of candidates belonging to SC/ST/OBC/PH. Educational Qualifications: Technical Associate -> Post Graduate in Science/ Environmental Science/ Applied Science/ M.A Geography OR Post Graduate/ Diploma in RS & GIS from a recognised University/Institution. Working knowledge of DIP/GIS. Solution Architect (Application/ Softwares) -> Essential - Must have a graduation degree in Engineering or MCA or M. Tech. Must have a minimum 8+ years' experience in Solution Design. Desirable - Should be responsible for creating or selecting the most appropriate architecture for a system (or systems), such that it suits the needs, satisfies user requirements, and achieves the desired results under given constraints. Senior Developer/ GIS expert -> Essential - Should have a Post Graduation degree in Geo-Sciences/ Geo-Informatics/MCA. Minimum 7 years technical experience working within the GIS domain. Desirable - Should have Expert in GIS solutions like: ArcGIS Server and extensions Desktop and extensions, ArcGIS Mobile, AGOL/PFA, ArcGIS Pro,Other GIS Software's. Database Administrator -> Essential - Should have a graduation degree in Engineering or MCA or M. Tech with relevant industry certifications Should have a minimum 7+ years' experience in Database Administration. Desirable - Must have experience in managing 2-3 GIS technology Projects / Spatial databases. Software Support Executive -> Should be B.E./B.Tech. Computers Science / M.C.A. 6+ Years of Experience as a programming and testing for GIS technology solutions. Skilled in Flex,.NET,php frame work. Desirable - Knowledge of using relational database, Microsoft SQL, Postgre SQL, MySQL. GIS Analyst -> Essential - Should be Masters in Science/Geography / Remote Sensing / Computer Science/Geo informatics / Geology/ Environmental Science. Must have an experience of 4+ years in performing GIS related work, on server & Desktop Applications. Desirable - Experience handling Spatial Data bases / Remote Sensing / Image processing / Socio-economic data with GIS applications and Working in reputed organisation. Selection Process: The short listed candidates will have to produce the original application form duly signed and photograph affixed on it on the day of selection test. The candidates will have to produce all their original documents on the day of selection test. The selection test may comprise of a written test and/or hands on test and/or interview. Selection will be done on the basis of their qualification, experience and their performance in the written test and/or hands on test and/or interview. Decision of the Director General, FSI will be final. No TA/ DA will be paid for appearing in the test/ interview. The short listed candidates will be intimated over phone and/or e-mail for a selection test which is tentatively scheduled in the third / fourth week of September, . How To Apply: The duly filled up application form after signature has to be scanned and sent as e-mail attachment to FSI (e-mail: ). The scanned copy of the application form along with attested copy of experience certificate should reach FSI through e-mail latest by 5.30 pm of . Detailed Advertisement: http://fsi.nic.in/uploads/documents/doc__requirement_of_ technical_professionals_at_fsi-.pdf Download Application Format: http://fsi.nic.in/uploads/documents/doc__application_for _technical_professionals_at_fsi-.pdf
India

SELENIUM BEST ONLINE TRAINING @ JSVITSOLUTIONS

NATURAL ADABAS SAP-HANA ORACLE BPM TABLEAU QLIKVIEW SELENIUM MS-BI (SSIS, SSRS, SSAS) UI Developer (Html, CSS, JavaScript, JQuery, Bootstrap, Angular JS, Node) TIBCO BW /BE Tibco Spotfire INFORMATICA IDQ INFORMATICA DATASTAGE COGNOS BI SHAREPOINT 2013 (DEV & ADMIN) SQL SERVER DBA SALESFORCE BUSINESS ANALYSIS.NET (C#, ASP) SAS Base SAS Advance SAS training Clinical SAS BI/DI training JBOSS / JBPM MS-AX DYNAMIC TECHNICAL ITIL – Foundation Python MariaDB Mule ESB Appian DevOps IBM BLUEMIX INGRES (Database) AWS (Amazon web services) Dell BOOMI SPLUNK AEM Administrator (Adobe Experience Manager) APACHE SPARK SCALA CASSANDRA SCOM (System Center Operations Manager) SAP-Lumira IBM SERVICE NOW IBM MAXIMO IBM LOMBARDI BPM (IBM BPM) Workday Studio Integration Workday HCM PEOPLE SOFT HRMS DIGITAL MARKETING MICROSOFT AZURE INFORMATICA MDM HADOOP (BIGDATA) HADOOP (BI) Business intelligence HADOOP TESTING PEGA BPM (PRPC) PEGA TESTING MongoDB Angular JS Contact Person: pradeep Contact Number: 91-9866955524 USA: 001-318-707-8350 WhatsApp: 9866955524
Hyderabad (Andhra Pradesh)


Free Classified ads - buy and sell cheap items in India | CLASF - copyright ©2019 www.clasf.in.