• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

136 Advisor courses in Sheffield delivered Live Online

ISO 27701 Internal Auditor

By Training Centre

  Being ISO 27701 Certified proves your Information Privacy Systems Audit experience, skills and knowledge, and demonstrates you are capable in the assessment of vulnerabilities, Compliance with GDPR and institutional controls within the enterprise.   * Gain an in-depth understanding of GDPR solutions and how they map to compliance requirements * Learn how to perform and lead Privacy Information Management System (PIMS) certification audits to ISO 19011 standards * Enhance your existing or learn with new skills in the field of Data Protection * Candidates deliver Assurance services to organisations by advising on conformance with PIMS requirements * Become a Technical expert on the preparation required for ISO 27701 Certification * Understand a Privacy Information Management System (PIMS) and its processes based on ISO/IEC 27701 * Identify the relationship between ISO/IEC 27701, ISO/IEC 27001, ISO/IEC 27002, and other standards and regulatory frameworks * Acquire the competences of the auditor's role in planning, leading, and following up on a management system audit in accordance with ISO 19011. * Learn how to interpret the requirements of ISO/IEC 27701 in the context of a PIMS audit ABOUT THIS COURSE   ISO 27701 Internal Auditor Certification;    * Confirms your knowledge and experience  * Quantifies and markets your expertise  * Demonstrates that you have gained and maintained the level of knowledge required to meet the dynamic challenges of a modern enterprise  * Is globally recognized as the mark of excellence for the Information Privacy Audit professional  * Increases your value to your organization  * Gives you a competitive advantage over peers when seeking a new role * Is administered by the International Examination & Certification Board (IECB), based in Estonia, and fully aligned to the ISO/IEC 17024:2012 standard (Conformity assessment - General requirements for bodies operating certification of persons)   Certified Individuals:    * Are highly qualified, experienced professionals in the field of Data Protection Systems Audit  * Provide the enterprise with a Certification route for Information Privacy Assurance that is recognized by multinational clients, lending credibility to the enterprise  * Are excellent indicators of proficiency in control requirements creation and monitoring  * Demonstrate competence in five domains, including standards and practices; organization and management; processes; integrity, confidentiality and availability; and software development, acquisition and maintenance  * Demonstrate a commitment to providing the enterprise with trust in and value from your Privacy Compliance Framework  * Maintain ongoing professional development for successful on -the -job performance   The below job practice is organized by domains. Each domain is covered in the course.   * Domain 1-The Process of Auditing Information Privacy Systems and Solutions   Provide audit services in accordance with ISO 19011 audit standards to assist the organization in protecting and controlling information privacy systems.    * Domain 2 - Governance and Management of Information Privacy Technology   Provide assurance that the necessary leadership and organizational structures and processes are in place to achieve objectives and to support the organization's strategy.    * Domain 3-Information Systems Acquisition, Development and Implementation   Provide assurance that the practices for the acquisition, development, testing and implementation of information systems meet the organization's strategies and objectives.    * Domain 4-Information Systems Operations, Maintenance and Service Management Provide assurance that the processes for information systems operations, maintenance and service management meet the organization's strategies and objectives.   * Domain 5-Protection of Personally Identifiable Information (PII) Assets   Provide assurance that the organization's policies, standards, procedures and controls ensure the confidentiality, integrity and availability of PII.   PREREQUISITES   A thorough understanding of current Data Protection legislation, Information Security & Risk Management knowledge as well as ISO 19011 Auditing Standards is required to successfully pass the examination. WHAT'S INCLUDED?   * Teas, Coffees, refreshments and a full Lunch* * Course Slides * Study Guide * Exam Fees * For Classroom based Courses only ACCREDITATION     WHO SHOULD ATTEND?   * Auditors seeking to perform and lead Privacy Information Management System (PIMS) certification audits * Managers or consultants seeking to master a PIMS audit process * Individuals responsible for maintaining conformance with PIMS requirements * Technical experts seeking to prepare for a PIMS audit * Expert advisors in the protection of Personally Identifiable Information (PII)   ASSESSMENT     Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 12 question, essay type exam on Day 3 of the course. The overall passing score is 70%, to be achieved within the 150 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success. OUR GUARANTEE   * We are an approved IECB Training Partner. * You can learn wherever and whenever you want with our robust classroom and interactive online training courses. * Our courses are taught by qualified practitioners with commercial experience. * We strive to give our delegates the hands-on experience. * Our courses are all-inclusive with no hidden extras.  The one-off cost covers the training, all course materials, and exam voucher. * Our aim: To achieve a 100% first time pass rate on all our instructor-led courses. * Our Promise: Pass first time or 'train' again for FREE.   *FREE training offered for retakes - come back within a year and train for free. PROVIDED BY   This course is Accredited by NACS [http://www.nacs.ee] and Administered by the IECB [https://www.iecb.org]

ISO 27701 Internal Auditor
Delivered Online
Dates arranged on request
£1250

M.D.D GET ME SOME DATES PACKAGE (SINGLES)

4.9(27)

By Nia Williams Miss Date Doctor Dating Coach London, Couples Therapy

* A few dates arranged for you * Dating Coach support * Dating arrangements scheduled * Support and Dating Coach advisory system for a client and potential dates Social Cues and emotional intelligence training * Overview of dating skills https://relationshipsmdd.com/product/get-me-some-dates-package/ [https://relationshipsmdd.com/product/get-me-some-dates-package/]

M.D.D GET ME SOME DATES PACKAGE (SINGLES)
Delivered in-person, on-request, onlineDelivered Online & In-Person in London & 2 more
£1200

RCN Accredited Asthma and COPD Course NORFOLK ICB ONLY

By BBO Training

'RCN Accredited Asthma and COPD' Course This course is a collaborative offering between your employer and BBO Training Ltd., designed to equip experienced healthcare professionals working in primary care settings with a comprehensive and holistic approach to managing patients with asthma and COPD. Even for those already holding a Diploma in either of these areas, the course has proven to be highly valuable, as indicated by positive evaluations from healthcare professionals. Course Aim The primary objective of this course is to provide qualified healthcare professionals with the necessary knowledge and skills to deliver effective asthma and COPD services in collaboration with their medical colleagues within the community healthcare setting. The course aims to raise awareness of these chronic conditions within the community, ensuring safe practice through the utilization of Patient Group Directions (PGDs) and protocols where appropriate. Participants will be clinically and theoretically prepared to establish and manage review and diagnostic clinics within their competency framework. Furthermore, the course emphasizes the clear differentiation between asthma and COPD. Clinical Practice Program and Competencies Throughout the course, you, along with your primary mentor, will organise and validate your clinical engagements, both under supervision and independently. By the time of your final assessment, these forms should be fully completed and ready for submission, accompanied by both your and your mentor's evaluations. Additionally, maintaining a log of all clinical hours and interactions is required, with a minimum of 36 hours. Teaching and Learning Approach Upon completing this course, students will have the opportunity to: 1. Participate in various sessions, including workshops, simulations, discussions, seminars, and tutorials, which can be conducted either virtually or in-person. 2. Gain practical experience in asthma and COPD management within their local healthcare settings. 3. Develop an in-depth understanding of treatments, including their composition, efficacy, indications, contraindications, and mechanisms of action, through clinical practice. 4. Enhance advisory skills related to respiratory care on a broader scale. 5. Attend dedicated sessions for clinical practice. 6. Document a minimum of 36 hours of supervised clinical practice and maintain an ongoing reflective diary. Expected Course Content Workshops, Discussion Groups, Lectures, and Assessment: 40 hours Clinical Practice: A minimum of 36 hours Visits and Private Study: 44 hours Private study time is essential for reading, conducting factual research on treatments through online sources, and accessing the library for literature searches. This time will facilitate writing, referencing, completing your reflective diary, and preparing for the final assessment. Assessment Successful completion of all components is required. Components 2 to 4 must be passed to complete the course. A resit option is available for any component that is not initially passed, limited to one attempt. 1. Reflective Diary: This ongoing document, produced by the student throughout the course, is validated by both the student and mentor. While not directly marked, its completion is integral to your portfolio of evidence. 2. Clinical Outcomes: These must be validated and passed by your mentor, with all outcomes achieved, along with a log of clinical hours. 3. VIVA: A minimum pass mark of 50% is required. 4. Test of Knowledge: A minimum pass mark of 50% is necessary (conducted at the end of the initial study days). Learning Outcomes Upon completion of this course, students will be capable of: 1. Evaluating and showcasing clinical competence through a reflective diary/log. 2. Demonstrating clinical assessment and treatment proficiency in a VIVA examination and knowledge assessment. 3. Effectively educating individuals about self-management and enhancing their understanding of their condition. 4. Displaying sensitivity and competence in obtaining comprehensive patient histories. 5. Adapting care for diverse patient groups and their unique needs. 6. Fulfilling professional responsibilities, including meticulous record-keeping and maintaining confidentiality. 7. Teaching the use of various inhalers and assessment equipment. 8. Developing fundamental assessment and examination techniques for respiratory conditions. 9. Operating with Patient Group Directions and protocols for asthma and COPD care. 10. Assessing, planning, implementing, and evaluating individual patient needs comprehensively.

RCN Accredited Asthma and COPD Course NORFOLK ICB ONLY
Delivered Online
Dates arranged on request
£1200

Clean Hydrogen Derivatives - Ammonia, Methanol and Synthetic Hydrocarbon - Virtual Instructor Led Training (VILT)

By Asia Edge

Elevate your expertise in clean hydrogen derivatives - ammonia, methanol, and synthetic hydrocarbon with EnergyEdge's course. Enroll now for virtual instructor-led training!

Clean Hydrogen Derivatives - Ammonia, Methanol and Synthetic Hydrocarbon - Virtual Instructor Led Training (VILT)
Delivered in-person, on-request, onlineDelivered Online & In-Person in Internationally
£1099 to £1199

AWS Cloud Financial Management for Builders

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Solutions architects Developers Cost-optimization leads System administrators Overview In this course, you will learn to: Explain the cost of core AWS services Determine and predict costs associated with current and future cloud workloads Use strategies and best practices to reduce AWS costs Use AWS tools to manage, monitor, alert, and optimize your AWS spend Apply strategies to monitor service costs and usage Implement governance standards, including resource tagging, account structure, provisioning,permissions, and access This course is for individuals who seek an understanding of how to manage, optimize, and predict costs as you run workloads on AWS. You learn how to implement architectural best practices, explore cost optimization strategies, and design patterns to help you architect cost-efficient solutions on AWS. MODULE 0: COUSE OVERVIEW * Course introduction MODULE 1: INTRODUCTION TO CLOUD FINANCIAL MANAGEMENT * Introduction to Cloud Financial Management * Four pillars of Cloud Financial Management MODULE 2: RESOURCE TAGGING * Tagging resources Hands-On Lab: Cost optimization: Control Resource Consumption Using Tagging and AWS Config MODULE 3: PRICING AND COST * Fundamentals of pricing AWS Free Tier Volume discounts Savings plans and Reserved Instances Demonstration: AWS Pricing Calculator MODULE 4: AWS BILLING, REPORTING, AND MONITORING * Understanding AWS invoices Reporting and planning AWS Cost Explorer AWS Budgets Demonstration: AWS Billing Console Demonstration: AWS Cost Explorer Demonstration: Trusted Advisor Hands-On Lab: Cost optimization: Deploy Ephemeral Environments Using Amazon EC2 Auto Scaling MODULE 5: ARCHITECTING FOR COST: COMPUTE * Evolution of compute efficiency Amazon EC2 right-sizing Purchasing options Architect for Amazon EC2 Spot Instance Impact of software licensing Demonstration: Compute Optimizer Demonstration: Spot Instance Advisor Hands-On Lab: Cost optimization: Right Size Amazon EC2 Instances Using Amazon CloudWatch Metrics MODULE 6: ARCHITECTING FOR COST: NETWORKING * Data transfer costs Understand data costs for different services How to triage network costs Hands-On Lab: Cost optimization: Reduce Data Transfer Costs Using Amazon CloudFront and Endpoints MODULE 7: ARCHITECTING FOR COST: STORAGE * Amazon EBS cost, pricing, and best practices Amazon S3 cost, pricing, and best practices Amazon EFS cost, pricing, and best practices Hands-On Lab: Cost optimization: Reduce Storage Costs Using Amazon S3 Lifecycle Management MODULE 8: ARCHITECTING FOR COST: DATABASES * Amazon RDS cost, pricing, and best practices Amazon Aurora cost, pricing, and best practices Amazon DynamoDB cost, pricing, and best practices Amazon ElastiCache cost, pricing, and best practices Amazon Redshift cost, pricing, and best practices MODULE 9: COST GOVERNANCE * Setting up AWS Organizations AWS Systems Manager Hands-On Lab: Cost optimization: Reduce Compute Costs Using AWS Instance Scheduler MODULE 10: COURSE SUMMARY * Course review

AWS Cloud Financial Management for Builders
Delivered on-request, onlineDelivered Online
Price on Enquiry

B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0)

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Data Modelers Participants will learn the full scope of the metadata modeling process, from initial project creation, to publishing a dynamic cube, and enabling end users to easily author reports and analyze data. INTRODUCTION TO IBM COGNOS DYNAMIC CUBES * Define and differentiate Dynamic Cubes * Dynamic Cubes characteristics * Examine Dynamic Cube requirements * Examine Dynamic Cube components * Examine high level architecture * IBM Cognos Dynamic Query * Review Dimensional Data Structures * Dynamic Cubes caching * CREATE & DESIGN A DYNAMIC CUBE * Explore the IBM Cognos Cube Designer * Review the cube development process * Examine the Automatic Cube Generation * Manual development overview * Create dimensions * Model the cube * Best practice for effective modeling DEPLOY & CONFIGURE A DYNAMIC CUBE * Deploy a cube * Explore the Estimate Hardware Requirements * Identify cube management tasks * Examine Query Service administration * Explore Dynamic Cube properties * Schedule cube actions * Use the DCAdmin comment line tool ADVANCED DYNAMIC CUBE MODELLING * Examine advanced modeling concepts * Explore modeling caveats * Calculated measures and members * Model Relative Time * Explore the Current Period property * Define period aggregation rules for measures ADVANCED FEATURES OF CUBE DESIGNER * Examine multilingual support * Examine ragged hierarchies and padding members * Define Parent-Child Dimensions * Refresh Metadata * Import Framework Manager packages * Filter measures and dimensions OPTIMIZE PERFORMANCE WITH AGGREGATES * Identify aggregates and aggregate tables * In-memory aggregates * Use Aggregate Advisor to identify aggregates * User defined in-memory aggregates * Optimize In-Memory Aggregates automatically * Aggregate Advisor recommendations * Monitor Dynamic Cube performance * Model aggregates (automatically vs manually) * Use Slicers to define aggregation partitions DEFINE SECURITY * Overview of Dynamic Cube security * Identify security filters * The Security process - Three steps * Examine security scope * Identify scope rules * Identify roles * Capabilities and access permissions * Cube security deep dive MODEL A VIRTUAL CUBE * Explore virtual cubes * Create the virtual cube * Explore virtual cube objects * Examine virtual measures and calculated members * Currency conversion using virtual cubes * Security on virtual cubes INTRODUCTION TO IBM COGNOS ANALYTICS * Define IBM Cognos Analytics * Redefined Business Intelligence * Self-service * Navigate to content in IBM Cognos Analytics * Interact with the user interface * Model data with IBM Cognos Analytics * IBM Cognos Analytics components * Create reports * Perform self-service with analysis and Dashboards * IBM Cognos Analytics architecture (high level) * IBM Cognos Analytics security * Package / data source relationship * Create Data modules * Upload files ADDITIONAL COURSE DETAILS: Nexus Humans B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

B6063 IBM Cognos Cube Designer - Design Dynamic Cubes (v11.0)
Delivered on-request, onlineDelivered Online
Price on Enquiry

Supporting the Wellbeing of Your Colleagues

By Mpi Learning - Professional Learning And Development Provider

Well-being isn't just a 'nice to have' - it should be a core part of your employee strategy.

Supporting the Wellbeing of Your Colleagues
Delivered in-person, on-request, onlineDelivered Online & In-Person in Loughborough
£445

Autodesk AutoCAD | 3ds Max Training

By London Design Training Courses

Why Learn Autodesk AutoCAD | 3ds Max Training Course? Course Link [https://www.londondesigntrainingcourse.co.uk/product-page/autodesk-autocad-3ds-max-training-course] 3ds Max serves as a powerful tool in architectural modeling, product design, games and films. Engaging with 3ds Max tutorials proves invaluable, particularly for game designers, as it can significantly enhance their professional growth and career prospects. Duration: 16 hrs Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. AutoCAD and 3ds Max Training Course: * Tailored Learning Experience: Benefit from personalized, one-on-one training tailored to your individual needs and learning pace. * Flexibility in Learning: Choose between attending in-person sessions or participating in live online classes, granting you the flexibility to learn from anywhere at your convenience. * Accessible Lesson Recordings: Access recorded lessons to revisit concepts, practice techniques, and reinforce your understanding whenever you need. * Ongoing Email Support: Receive continuous assistance and expert guidance through lifetime email support, ensuring you never feel left behind in your learning journey. * Learn from Certified Tutors and Industry Experts: Be educated by experienced professionals proficient in both Autodesk AutoCAD and 3ds Max, providing valuable insights into industry best practices. * Complimentary Career Advice: Take advantage of our career advisory services to receive valuable guidance in navigating your professional path and making informed decisions. Download Autodesk Autocad and 3ds max [https://www.autodesk.co.uk/products] AutoCAD and 3ds Max Training Course. Course Duration: 16 hours Course Overview: Join our training program to master AutoCAD and 3ds Max. Suitable for beginners and experienced 2D/3D modelers, this course equips you with essential skills to create stunning designs in both 2D and 3D. Course Outline: Part 1: Introduction to AutoCAD * Familiarizing with the AutoCAD interface * Understanding the drawing environment * Mastering basic 2D geometry creation * Exploring essential drawing tools and commands * Introduction to blocks and symbols for efficient design Part 2: Advanced AutoCAD Techniques * Delving into advanced drawing techniques * Manipulating and editing 2D geometry like a pro * Creating custom symbols and blocks for enhanced productivity * Working with text and annotations for clear communication * Utilizing layers and line types for organized design Part 3: Plans sections and Elevations * Entering the realm of Plans sections and Elevations * Crafting Plans and 2D construction detailing precision * Modifying and manipulating 2D seamlessly * Crafting custom materials and textures for realistic designs Part 4: Introduction to 3ds Max * Embracing the 3ds Max interface and workspace setup * Mastering navigation within 3ds Max * Understanding the viewport for optimized design * Exploring basic 3D modeling techniques in 3ds Max Part 5: Materials and Textures in 3ds Max * Applying and modifying textures to elevate designs * Unraveling the art of UVW mapping for precise texturing * Utilizing the material editor for creative freedom * Crafting custom materials to suit your design vision * Harnessing the power of Vray materials for realistic renders Part 6: Lighting in 3ds Max * Introducing various lighting techniques * Understanding light properties for impactful designs * Setting up lights strategically to enhance scenes * Illuminating scenes using Vray lights Part 7: Cameras in 3ds Max * Mastering camera systems in 3ds Max * Exploring camera properties for cinematic effects * Creating animation with cameras for dynamic scenes * Utilizing Vray cameras to achieve stunning renders Part 8: Rendering in 3ds Max * Unveiling the art of rendering * Utilizing Vray Global Illumination for realistic lighting * Leveraging Vray Physical Cameras for precise control * Enhancing scenes with Vray HDRI Lighting * Following a Vray Rendering Workflow for professional results Part 9: Advanced Modeling Techniques * Crafting complex geometry with finesse * Utilizing modifiers for intricate designs * Exploring polygonal modeling for versatile creations * Creating organic and inorganic models with expertise * Unleashing the potential of advanced modeling techniques Part 10: Projects * Applying all learned skills to create real-world scenes * Designing a simple interior scene with attention to detail * Crafting a captivating exterior scene for visual impact * Creating a complex scene with multiple objects and materials Course Requirements: * A computer with AutoCAD [https://www.autodesk.co.uk/products/autocad/overview?term=1-YEAR&tab=subscription]and 3ds Max installed * Basic knowledge of computer operations * An interest in 2D and 3D modeling and design

Autodesk AutoCAD | 3ds Max Training
Delivered in-person, on-request, onlineDelivered Online & In-Person in London
£480

Oracle 12c Administration II

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is for all Oracle Professionals. Specifically Database Administrators, Web Server Administrators, System Administrators, CIOs and other IT Management Professionals. Overview Upon successful completion of this course, students will be able to perform many of the day-to-day administration tasks required of an Oracle database administrator. This course introduces many of the powerful capabilities of the Oracle database. In this course, students will learn about day-to-day administration tasks. It will also address administration sub-specialties. INTRODUCTION: MANAGING THE DATABASE INSTANCE * The Database Management Tools * EM Database Express * EM Cloud Control * SQL Developer * Database Administrator INTRODUCTION: DATABASE ARCHITECTURE REVIEW * Database Instance Configurations * Memory Structures * Process Structures * Storage Architecture INTRODUCTION: STARTING & STOPPING DATABSE SERVICES * Start & Stop the Database Listener * ABOUT DATABASE STARTUP/SHUTDOWN * SYSOPER * SYSDBA * DATABASE STATE & STAGES * STARTUP WITH EM CLOUD CONTROL * STARTUP WITH SQL*PLUS * SHUTDOWN WITH EM CLOUD CONTROL * SHUTDOWN WITH SQL*PLUS * USING MS WINDOWS SERVICES INTRODUCTION: ORACLE NETWORK ENVIRONMENT * Oracle Net Services Architecture * ORACLE NET CONFIGURATION ASSISTANT * ORACLE NET MANAGER * USING EM CLOUD CONTROL * ADVANCED NETWORK COMPRESSION * TROUBLESHOOTING NETWORK PROBLEMS INTRODUCTION: DIAGNOSTICS & ORACLE SUPPORT * About Database Diagnostics * Fault Diagnosability Infrastructure * DATABASE INSTANCE HEALTH SNAPSHOT * THE SUPPORT WORKBENCH * PROACTIVE DATABASE HEALTH CHECKS * PACKAGE DIAGNOSTIC DATA * WORKING WITH THE KNOWLEDGE BASE STORAGE: TABLESPACE MANAGEMENT * Starter Tablespaces * CREATE TABLESPACE WITH EM CC * CREATE TABLESPACE WITH SQL * MANAGE TABLESPACES WITH EM CC * MANAGE TABLESPACES WITH EM DE * MANAGE TABLESPACES WITH SQL * DROP TABLESPACE * ALTER TABLESPACE * STORAGE: ADVANCED TABLESPACE MANAGEMENT * Managing Temporary Tablespaces * TEMP TABLESPACE GROUPS WITH EM * TEMP TABLESPACE GROUPS WITH SQL * DEFAULT PERMANENT TABLESPACES * BIGFILE TABLESPACES * MANAGING THE SYSAUX TABLESPACE STORAGE: DATA FILES & TEMP FILES MANAGEMENT * Manage Data Files with EM * ACCESS METADATA WITH SQL * MANAGE DATA FILES WITH SQL * MANAGE TEMP FILES * ORACLE-MANAGED FILES (OMF) STORAGE: UNDO DATA & UNDO TABLESPACES * About UNDO Space Management * GUARANTEE UNDO RETENTION * MONITOR UNDO SPACE WITH SQL * USE THE EM UNDO ADVISOR SECURITY & SCHEMAS: SECURITY OVERVIEW & DATABASE PRIVILEGES * Database Security Principles * DATABASE SYSTEM PRIVILEGES * DATABASE OBJECT PRIVILEGES * SUPER ADMINISTRATOR ROLES * PRIVILEGE ANALYSIS SECURITY & SCHEMAS: USER SECURITY * Create & Manage User Accounts * MANAGE USERS WITH EM * MANAGE USERS WITH SQL * CREATE USER * ALTER USER * DROP USER * GRANT & REVOKE PRIVILEGES * RESOURCE LIMITS VIA PROFILES * ALTER PROFILE * DROP PROFILE * PASSWORD MANAGEMENT VIA PROFILES * ROLE-BASED SECURITY MANAGEMENT * ALTER USER...DEFAULT ROLE * SET ROLE * DELEGATING PRIVILEGE AUTHORIZATION * WITH ADMIN OPTION & System Privileges * WITH GRANT OPTION & Object Privileges * PRINCIPLE OF LEAST PRIVILEGE CHECKLIST SECURITY & SCHEMAS: DATABASE AUDITING * Auditing Database Activity * Traditional Auditing * Unified Auditing * Create Audit Policy SECURITY & SCHEMAS: SQL LOADER * Loader Concepts * Loader From the Command Line * control File Options * Load Methods * Loader Express Mode * Loader From EM SECURITY & SCHEMAS: EXPORT & IMPORT * Manage Directory Objects * The Data Pump Architecture * Data Pump Export * Data Pump Import * Data Pump Dictionary Views * Using the EM CC Interface PERFORMANCE & AVAILABILITY: MANAGING PERFORMANCE & SQL TUNING * Management Advisory Framework * Performance Monitoring & AWR * The SQL Tuning Advisor * Monitoring Exceptions with Metrics PERFORMANCE & AVAILABILITY: DATA CONCURRENCY * About System & User Locks * Monitor & Manage User Locks * Moitor Locks with Data Dictionary * Manage Locks with EM PERFORMANCE & AVAILABILITY: BACKUP & RECOVERY CONCEPTS * Backup & Recovery Structures * Managing REDO Data * Configuring for Recoverability * Instance Recovery * Recoverability Checklist ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 12c Administration II training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c Administration II course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Oracle 12c Administration II
Delivered on-request, onlineDelivered Online
Price on Enquiry

Oracle Database 12c R2 - Backup and Recovery Workshop Ed 3

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse Administrator Database Administrators Support Engineer Technical Administrator Technical Consultant Overview Use Oracle Flashback Technologies to recover from human error Use Recovery Manager (RMAN) to create backups and perform recovery operations Use the Data Recovery Advisor to diagnose and repair failures Plan effective backup and recovery procedures Describe the Oracle Database architecture components related to backup and recovery operations Perform an encrypted database backup and restore Perform tablespace point-in-time recovery Configure the database for recoverability Describe Cloud Tooling for Backup and Recovery Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations. INTRODUCTION * Curriculum Context * Assess your recovery requirements * Categories of failures * Oracle backup and recovery solutions * Oracle Maximum Availability Architecture * Oracle Secure Backup * Benefits of using Oracle Data Guard * Basic Workshop Architecture GETTING STARTED * Core Concepts of the Oracle Database, critical for Backup and Recovery * Oracle DBA Tools for Backup and Recovery * Connecting to Oracle Recovery Manager (RMAN) CONFIGURING FOR RECOVERABLILITY * RMAN commands * Configuring and managing persistent settings * Using the Fast Recovery Area (FRA) * Control File * Redo Log File * Archiving Logs USING THE RMAN RECOVERY CATALOG * Creating and Configuring the Recovery Catalog * Managing Target Database Records in the Recovery Catalog * Using RMAN Stored Scripts * Maintaining and Protecting the Recovery Catalog * Virtual Private Catalogs BACKUP STRATEGIES AND TERMINOLOGY * Backup Solutions Overview and Terminology * Balancing Backup and Restore Requirements * Backing Up Read-Only Tablespaces * Data Warehouse Backup and Recovery: Best Practices * Additional Backup Terminology PERFORMING BACKUPS * RMAN Backup Types * Incrementally Updated Backups * Fast Incremental Backup * Block Change Tracking * Oracle-Suggested Backup * Reporting on Backups * Managing Backups IMPROVING YOUR BACKUPS * Compressing Backups * Using a Media Manager * Backup and Restore for Very Large Files * Creating RMAN Multi-section Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets * Creating and Managing Archival Backups * Backing Up Recovery Files * Backing Up the Control File to a Trace File * Cataloging Additional Backup Files USING RMAN-ENCRYPTED BACKUPS * Creating RMAN-Encrypted Backups * Using Transparent-Mode Encryption * Using Password-Mode Encryption * Using Dual-Mode Encryption DIAGNOSING FAILURES * Reducing Problem Diagnosis Time * Automatic Diagnostic Repository * Data Recovery Advisor * Handling Block Corruption RESTORE AND RECOVERY CONCEPTS * Restoring and Recovering * Instance Failure and Instance/Crash Recovery * Media Failure * Complete Recovery (Overview) * Point-in-Time Recovery (Overview) * Recovery with the RESETLOGS Option PERFORMING RECOVERY, PART I * RMAN Recovery in NOARCHIVELOG Mode * Performing Complete Recovery (of critical and noncritical data files) * Restoring ASM Disk Groups * Recovery with Image Files * Performing Point-in-Time (PITR) or Incomplete Recovery PERFORMING RECOVERY, PART II * Recovery of Server Parameter File, Control File (One and All) * Redo Log File Loss and Recovery * Password Authentication File Re-creation * Index, Read-Only Tablespace, and Temp file Recovery * Restoring the Database to a New Host * Disaster Recovery * Restoring RMAN Encrypted Backups RMAN AND ORACLE SECURE BACKUP * Oracle Secure Backup Overview and Interface Options * RMAN and OSB: Overview and Basic Process Flow * Starting with Oracle Secure Backup * Configuring Oracle Secure Backup for RMAN * RMAN Backup and Restore Operations * Oracle Secure Backup Jobs * Displaying OSB log files and transcripts for RMAN activities USING FLASHBACK TECHNOLOGIES * Flashback Technology: Overview and Setup * Using Flashback Technology to Query Data * Flashback Table * Flashback Transaction (Query and Back out) * Flashback Drop and the Recycle Bin * Flashback Data Archive USING FLASHBACK DATABASE * Flashback Database Architecture * Configuring Flashback Database * Performing Flashback Database * Best Practices for Flashback Database TRANSPORTING DATA * Transporting Data Across Platforms * Transporting Data with Backup Sets * Database Transport: Using Data Files PERFORMING POINT-IN-TIME RECOVERY * When to use TSPITR * TSPITR Architecture * Performing RMAN TS Point-in-time Recovery * Recovering Tables from Backups DUPLICATING A DATABASE * Using a Duplicate Database * Duplicating Database with 'push' and 'pull' techniques * Choosing Database Duplication Techniques * Creating a Backup-up Based Duplicate Database * Understanding the RMAN Duplication Operation RMAN TROUBLESHOOTING AND TUNING * Interpreting RMAN Message Output * Tuning Principles * Diagnosing Performance Bottlenecks * RMAN Multiplexing * Restore and Recovery Performance Best Practices CLOUD TOOLING FOR BACKUP AND RECOVERY * Backup Destinations * Customize Backup Configuration * On-Demand Backup and Recovery * Oracle Backup Cloud Service * Installing the Backup Module BACKUP AND RECOVERY WORKSHOP * Workshop Structure and Approach * Business Requirements for Database Availability and Procedures * Diagnosing the Failures

Oracle Database 12c R2 - Backup and Recovery Workshop Ed 3
Delivered on-request, onlineDelivered Online
Price on Enquiry