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

243 Assistant courses

AAT Level 1 Award in Bookkeeping

By London School of Science and Technology

This Level 1 qualification introduces the role of a bookkeeper and the underpinning knowledge to identify and carry out simple different bookkeeping activities, such as income and expenditure, profit and loss, and assets and liabilities. Course Overview This Level 1 qualification introduces the role of a bookkeeper and the underpinning knowledge to identify and carry out simple different bookkeeping activities, such as income and expenditure, profit and loss, and assets and liabilities. It also offers an introduction into the role, and the benefits and risks associated with bookkeeping software. The jobs it can lead to: • Cashier • Clerical assistant • Trainee bookkeeping assistant Entry requirements: If you have no prior accounting knowledge or bookkeeping knowledge, this entry-level bookkeeping qualification will give you an understanding of manual, single-entry bookkeeping basics. For the best chance of success we recommend that students begin their studies with a good standard of English and maths. It provides a solid grounding for students before moving on to the Level 2. Course Content: Bookkeeping fundamentals: This unit introduces students to the role of a bookkeeper and simple bookkeeping techniques, while providing an understanding on why it’s important to keep accurate and up to date financial information in business. Students will learn how to identify a range of bookkeeping transactions including income, expenses, and profit and loss, as well as gaining an understanding of the benefits and risks associated with bookkeeping software and the importance of ethical behaviour. Learning outcomes: • Understand the role of the bookkeeper. • Understand financial transactions. • Process customer and supplier transactions. • Process receipts and payments. • Understand the benefits and risks of using accounting software to complete bookkeeping tasks. DURATION 110 Hours WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

AAT Level 1 Award in Bookkeeping
Delivered In-PersonFlexible Dates
£395

About this Training Course In our pursuit to discover oil & gas in deeper horizons, wells are often drilled in a HPHT environment. To be considered a HPHT well, the downhole conditions will have pressures in excess of 10,000 psi (69 MPa) and 300° F (150° C). To drill these usually expensive wells successfully, the planning and execution phase has to be of an exceptionally high standard. Therefore, both operator and drilling/service contractor staff must be seamlessly aligned and work as a coherent team to reach and then harness the well objectives. This is particularly important when speciality services such as Managed Pressure Drilling (MPD) are being applied with crews and/or supervisors who are not intricately familiar with complicated well control incidents. As we seek to prevent costly non-productive time, attention will also be paid to enabling technologies like expandable solid tubulars, mud coolers and specialty mud. The 3 full-day course will explain the key characteristics and challenges of HPHT Planning and Well Control. This includes: Differences between HPHT and standard (conventional) wells and what this entails for well design. The challenges unique to HPHT and the impact of Pore Pressure Prediction (PPP). Static and Dynamic Equivalent Mud Density and the factors that influence the ultimate Bottom Hole Pressure (BHP). Control practices such as 'fingerprinting' to identify what's happening downhole. HPHT shut-in procedures and practices. Specific HPHT equipment and drilling tool requirements and advantages of Managed Pressure Drilling (MPD). Well control on/off bottom, bull-heading and dealing with kick-loss situations. Mud management, tolerance on mud properties and challenges in cementing. Case history on emergency control. Drills, team effort, checklists, human factor and 'getting everybody on board'. Training Objectives By the end of this course, participants will be able to: Recognize the main differences in planning/design between HPHT and standard (conventional) wells as well as the challenges that will have to be faced. Explain drilling and tripping operational challenges and practices as well as how to manage these effectively. Identify wellbore breathing (a.k.a. ballooning) and how to safely deal with this within the narrow window for mud density selection. Apply practices of consistent fingerprinting and how to develop procedures for this to benefit the rig team. Measure and understand bottom hole pressure and the effect of influencing factors such as temperature, rotation and flow rate. Understand the critical mud properties to alleviate barite sag, general mud density control techniques and specify the essentials in cementing. Manage losses and low fracture gradients with well bore strengthening methods. Execute sound HPHT shut-in procedures. Understand how MPD can assist in the safe and efficient drilling and hole cleaning of HPHT wells. Understand the use of MPD Influx Management Envelopes. Identify critical Early Kick Detection Systems (EKDS) and HPHT well control equipment. Execute safe secondary well control practices in a H2S environment, bull-heading, on and off bottom and handling of gas at surface, using MGS and hydrate mitigation measures. Target Audience The course is intended for: Office-based staff engaged in HPHT well planning and day-to-day operations Field-based rig staff working as front-line supervisors - from Assistant Drillers to Senior Toolpushers Field-based rig staff working for service companies supporting the execution of HPHT wells (MPD, mud and mudlogging services etc.) Trainer Your expert course leader has over 45 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil & gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

HPHT Planning and Well Control
Delivered in Internationally or OnlineFlexible Dates
£2,063 to £2,399

BAG & ACCESSORY DESIGN MASTERCLASS - 1 Week Course

5.0(52)

By The London Leather Workshop

COURSE DESCRIPTION: BAG AND ACCESSORY DESIGN MASTERCLASSThis course is tailored for beginners and intermediate-level participants, offering a distinctive group class format designed to assist aspiring designers or those seeking guidance in bringing to life a practical and viable collection of bags and/or accessories.Through this course, you will gain a comprehensive grasp of fundamental skills in accessory design and what it requires to become a bag designer. It empowers you to transform your creative concepts into tangible realities by providing instruction on the essential steps required for prototyping and manufacturing your collection.In addition to acquiring the skills to design bags and accessories accurately and understanding what information to convey to a prototype maker, this course will guide you through the process of creating patterns and constructing a three-dimensional mock-up for one your design. WHY THIS COURSE DIFFERS FROM THE TYPICAL ‘ACCESSORY DESIGN’ PROGRAMMEThis course has been meticulously designed by a team comprising designers, prototype makers, and handbag manufacturers. It offers a blend of theoretical and practical elements, providing you with the knowledge required by the industry to comprehend and accurately translate your ideas into finished products.Unlike courses that solely focus on creating aesthetically pleasing drawings, this programme emphasizes providing a comprehensive understanding of the intricate and extensive processes involved in designing a collection of handbags. It aims to equip you with the insights necessary to navigate the complexities, ensuring you are well-prepared before and during the design phase. By doing so, the course aims to save you time, expense, and potential frustration when it comes to prototyping and manufacturing your collection.This intensive course will equip you with the skills to potentially save thousands of pounds on product development for your designs and the assistance needed to make your project viable for construction.WHY WE DEVELOPED A FASHION DESIGN COURSEAfter years of designing and developing collections for our clients, we noticed a significant lack of clear information on what it truly takes to become a designer of handbags and fashion accessories.This course is crafted to assist both emerging and struggling designers in developing and articulating their ideas effectively for the prototyping phase. It addresses the needs and challenges faced by our customers, aiming to support and streamline the creative process for project realization. WHO IS THIS COURSE FOR?This course is tailored for aspiring designers seeking professional advice from industry experts, individuals at the beginning of their design careers who require guidance to enhance their design process, or those simply looking to refine their drawing techniques for personal enjoyment.No previous experience is necessary. WHAT WILL BE TAUGHT?Below is a list of topics covered during the classes:Understanding the role of a bag designerBefore designing: understanding and analsing crucial external aspects that will influence your business successAbout your business idea and profile: understanding the target audience, market placement, pricing strategy and moreUnderstanding what a moodboard is and how to use itUnderstanding the differences and purposes of illustrations vs technical drawingsUnderstanding the importance of construction and its impact on your designOverview of the anatomy of a handbag, lining and reinforcementsUnderstanding the structure of a collection: the use of a collection planLearning how to plan a balanced collection of fashion accessoriesUnderstanding finishing options for your designsUnderstanding hardware and its impact on the cost price of your collectionOverview of leather and vegan leatherIdentifying the right materials for your collectionLearning how to draw three-dimensional bagsSketching technical drawingsGoing through the product development of three designsDeveloping patterns and realising 1 three-dimensional mock-up of a bagProviding technical information about your collection to the prototype makerUnderstanding the prototyping processManufacturing your collection: how it works and what the options are. HOW WILL THE CLASS BE TAUGHT?The class will take place in person at our London studio, and the lessons will alternate between theoretical instruction and practical exercises.Some homework will be assigned to students between lessons. HOW LONG IS THIS TUITION?:This course spans an entire week, running from Monday to Friday, 10 am to 5 pm, with a 30-minute lunch break. INCLUDED IN THE COURSE:You will also receive access to a collection of handouts providing relevant information, useful resources and support in continuing your designing process independently.The handouts will contain:– A glossary containing essential key words related to the topic of the lesson– An illustrated glossary containing information about type of bags and bags’ features– An illustrated guide on common hardware used in bags and accessories– Documents about leather types, finishings, tanning processes– Information about perspective and guides to be used as reference to develop your drawings– A list of recommended suppliers for both leather and fittings (physically in London and online) WHAT ARE THE ENTRY REQUIREMENTS?You should be able to use measurements and understand verbal and written English instructions. ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING?Materials to exercise with are included.Feel free to bring a notepad, if you would like to take some notes, we will provide the rest.

BAG & ACCESSORY DESIGN MASTERCLASS - 1 Week Course
Delivered In-Person in London + more
£1,017

1 to 1 with Sid Sottung

By Sid Sottung Academy Edinburgh

The history and story of Sid Sottung Academy's humble foundations and superb success. Humble Beginnings Sid Sottung started off as we all do, a beginner! At the age of 14 working as an assistant in a traditional Italian barbershop in New York, but so eager to make his mark on the industry, Sid at 18 began a his career with Vidal Sassoon by training in their Downtown New York salon as a stylist. After successful stints in their New York & Washington D.C salons he rose to Assistant Creative Director. On the back of a decorated career in Sassoon salons, Sid graduated to their academies as an educator teaching both hairdressing & barbering. Sid’s first stop was the Santa Monica Academy also working for television and teaching at international shows as far afield as China After parting ways with Sassoon, Sid pursued an exciting freelance career guesting & teaching in exclusive salons & barbershops. He was also, proudly a member of the hair team, working on the 2005 blockbuster Pride & Prejudice. Building On Success Having trained educators & written curriculums for other academies, Sid felt that 2014 was the correct time to open his very own academy. Having travelled the globe educating and as a host of other leading industry names, Sid opened the doors of the Sid Sottung Academy in February 2014. “Our academy offers the rare opportunity to study directly under the tutorage of an internationally recognised educator.” After winning various awards and years of success, Sid opened up another location in 2018: his salon and Advanced Academy, Haus of Sottung. As per today his latest venture is the Edinburgh Academy, a bespoke training centre in the beautiful city centre where he offers bespoke training 1:1 or to small groups.

1 to 1 with Sid Sottung
Delivered In-Person in EdinburghFlexible Dates
£500

Level 3 (RQF) Emergency First Aid at Work

5.0(5)

By Amplio Training - First Aid Training Sidmouth

Fun, Interactive Level 3 Emergency First Aid (RQF) training course

Level 3 (RQF) Emergency First Aid at Work
Delivered In-Person in Sidmouth + more
£120

Easter Revision Courses

By Rochester Independent College

https://rochester-college.org/study-with-us/short-courses/easter-revision

Easter Revision Courses
Delivered In-PersonFlexible Dates
£675

Level 1 Safeguarding

5.0(50)

By Pochat Training

FAA Level 1 Award In Awareness Of Safeguarding (RQF) Face-to-Face Classroom: Half-day course Virtual Classroom: 2 sessions of 2 ½ hours For those who work with children, young people and vulnerable adults Promotes awareness of safeguarding, enabling learners to identify problems and show where to report these to Course Contents: Safeguarding legislation and guidance Key safeguarding roles Different types of abuse Signs and indicators of abuse and neglect Actions to take when a safeguarding concern arises Benefits of this course: In 2018/2019, 415,050 concerns of abuse were raised In 2018/2019, there were nearly 400,000 children in need 52,300 children were subject to a child protection plan 63% of adult safeguarding concerns are for people over 65 1 in every 42 adults aged 85+ have required safeguarding enquires... Child abuse often goes unreported and unrecorded - till it is picked up on by someone who then does something about it. This Level 1 Safeguarding Awareness course gives people the knowledge to make a real difference to a person's life! This basic Safeguarding course is a nationally recognised, Ofqual regulated qualifications accredited by First Aid Awards Ltd. This means that you can be rest assured that your Level 1 in Safeguarding Certificate provides information for best practice to make a real difference to protect the health and wellbeing of the most vulnerable in our society. The Ofqual Register number for this course is 603/5635/2

Level 1 Safeguarding
Delivered in Chesterfield or Online + more
£85

Awareness of First Aid for Mental Health

By Madeleys First Aid Plus

RQF level 1 Awareness of First Aid for Mental Health Each year approximately 1 in 4 people in the UK will experience a mental health condition and at least 1 in 6 employees experience common mental health problems in the workplace. Research has shown that work is the biggest cause of stress which can stop people performing at their best. Mental health conditions are often hidden due to stigma and fear of discrimination and research has shown that a culture of fear and silence around mental health is costly to employers. The HSE guidance 'First aid needs assessment’ refers to mental health in the workplace. This 4-hour qualification provides learners with the knowledge to recognise a range of mental health conditions, how to start a supportive conversation and when and how to signpost a person to seek appropriate professional help. Learners will know how to recognise and manage stress. Learners will not diagnose or treat mental health conditions as this can only be carried out by healthcare professionals but will gain the knowledge to identify when a person may have a condition and know where they can go to get help. Suitability - Who should attend? Here are some examples of who may benefit from attending the RQF Level 1 Award in Awareness of First Aid for Mental Health: Employees and workers: This course is relevant for individuals in any industry who may encounter colleagues or clients experiencing mental health difficulties. It can be particularly valuable for human resources personnel, line managers, supervisors, or team leaders responsible for the well-being of employees. Teachers and educators: Professionals working in schools, colleges, or other educational institutions can benefit from this training to better understand and support the mental health needs of students. Healthcare and social care workers: Individuals working in healthcare or social care settings, such as nurses, care assistants, support workers, or counsellors, can enhance their understanding of mental health issues and improve their ability to provide appropriate support. Community and voluntary workers: People involved in community or voluntary organizations, including youth workers, social workers, volunteers, or community leaders, can gain valuable insights into mental health awareness and support. Personal relationships and caregivers: The Level 1 training can also be beneficial for individuals who have personal relationships with someone experiencing mental health challenges. This may include family members, friends, or caregivers who want to enhance their understanding and offer appropriate assistance. It is important to note that the Level 1 Award in Awareness of First Aid for Mental Health RQF is an introductory course and does not qualify participants to provide formal mental health interventions or therapy. However, it serves as a foundation for further training and can contribute to creating a more mentally healthy and supportive environment in various settings. Outcome / Qualification etc. Upon successful completion of the RQF Level 1 Awareness of First Aid for Mental Health course, participants can expect to achieve the following outcomes: Increased Awareness and Understanding: Participants will develop a basic awareness and understanding of mental health and mental health issues. They will gain knowledge about common mental health conditions, their signs and symptoms, and the importance of mental health in overall well-being. Recognition of Mental Health Signs: Participants will learn to recognize common signs of mental health issues in themselves and others. They will gain an understanding of the importance of early identification and intervention in promoting mental health and seeking appropriate support. Reduced Stigma and Improved Attitudes: The course aims to challenge stigmas and stereotypes associated with mental health. Participants will develop a more empathetic and supportive attitude towards individuals experiencing mental health challenges, promoting a positive and inclusive environment. Enhanced Communication Skills: Participants will learn basic communication skills for engaging with individuals experiencing mental health issues. They will gain an understanding of the importance of active listening, empathy, and non-judgmental communication in providing initial support. Signposting and Seeking Help: Participants will be equipped with knowledge about available resources, services, and support networks for mental health. They will learn about signposting individuals to appropriate professional help and self-help resources. Self-Care and Well-being Strategies: The course may provide participants with practical strategies for maintaining their own mental well-being. They may learn basic self-care techniques and stress management strategies to support their own mental health. Certificate of Completion: Upon successful completion of the course, participants will receive a certificate indicating their achievement of the RQF Level 1 Awareness of First Aid for Mental Health qualification. It's important to note that the Level 1 course provides a basic introduction to mental health awareness and first aid. It is not intended to provide participants with the qualifications or skills to diagnose or treat mental health conditions. Instead, it aims to promote mental health literacy, reduce stigma, and provide individuals with the knowledge to offer initial support and signposting to individuals in need. The Level 1 course can serve as a foundation for further learning and progression in the field of mental health. Individuals may choose to pursue higher-level courses or qualifications to develop more advanced skills and knowledge in mental health first aid or other related areas. Training Course Content MODULE 1 INTRODUCTION Session content Trainer/assessor introduction Learner introductions Course information • Administration • Learning outcomes and assessment criteria • Reasonable adjustments • Certification • Complaints and appeals • Assessment information Session duration 15 minutes MODULE 2 WHAT IS FIRST AID FOR MENTAL HEALTH? Session content Definitions Role and responsibilities of a First Aider The impact of mental health issues Mental health stigma Statistics Session duration 25 minutes MODULE 3 IDENTIFYING MENTAL HEALTH CONDITIONS Session content Mental health continuum Mental health risk factors Early warning signs Session duration 25 minutes MODULE 4 PROVIDING ADVICE AND STARTING A CONVERSATION Session content How to start a difficult conversation Non-judgemental listening skills When to contact the emergency services The First Aider’s own health and emotions Session duration 40 minutes MODULE 5 STRESS Session content What is stress? Causes of stress Effects of stress Coping strategies Session duration 25 minutes MODULE 6 MENTAL HEALTH CONDITIONS Session content Depression Anxiety Psychosis Eating disorders Suicide Self-harm Session duration 70 minutes MODULE 7 ASSESSMENT AND COURSE CLOSURE Session content Written assessment paper Course administration Course closure Session duration 40 minute Course delivery details Classroom-Based A minimum of 4 hours spread over at least one day. Ideally, the course should be run in one day, but must be completed within 2 weeks of starting the course, with each training session a minimum of two hours. Online/Virtual classroom The qualification has 2 assigned guided learning hours (GLH) and 5 hours total qualification time (TQT). GLH indicates the number of contact hours that the learner will have with the trainer/assessor. TQT includes GLH but considers unsupervised learning and is an estimate of how long the average learner will take to achieve the qualification. Why choose Madeleys First Aid Plus Founded in 2021 after Louise left 30 years in the NHS as an Advanced practitioner in A&E/ITU, had spent 1.5 years in Covid ITU Won FSB Best start-up business in the West Midlands in May 2023 Now trained 100's of delegates in Physical and Mental Health First Aid Expenses Travel costs and lunch required, there are many cafes and sandwich bars here in Much Wenlock to buy your lunch, you may eat it in the training room. All training material, books, qualification certificates are included in the price. Continuing Studies After completing the RQF Level 1 Awareness of First Aid for Mental Health course, individuals can consider various progression options to further their knowledge and skills in mental health support. Here are some potential pathways: RQF Level 2 Award in First Aid for Mental Health: This qualification builds upon the knowledge gained in the Level 1 course and provides a more comprehensive understanding of mental health issues and how to provide appropriate support. It covers topics such as recognizing mental health conditions, promoting well-being, and providing initial support to those in crisis. RQF Level 3 Award in Supervising First Aid for Mental Health: For individuals who aspire to take on leadership or supervisory roles in mental health support, the Level 3 qualification is a logical progression. It provides in-depth knowledge and skills to supervise and manage a team of individuals providing first aid for mental health. Continued Professional Development (CPD): Engaging in ongoing CPD activities is essential for staying updated with the latest developments in mental health support. Individuals can attend workshops, seminars, or conferences related to mental health, trauma, or specific areas of interest within the field. Applied Practice: Applying the knowledge gained from the Level 1 course in real-world settings is crucial for developing practical skills. Individuals can seek opportunities to work or volunteer in environments where mental health support is needed, such as community organizations, schools, or helplines. Mental Health Support Training Programs: There are various specialized training programs available that focus on specific aspects of mental health support, such as suicide prevention, trauma-informed care, or supporting individuals with specific mental health conditions. These programs can provide individuals with additional expertise and deepen their understanding of specific areas within mental health support. Higher Education: Individuals who wish to pursue a more in-depth study of mental health can consider higher education programs in psychology, counseling, social work, or related fields. These programs provide comprehensive knowledge and training in mental health support and may lead to professional certifications or degrees. It's important for individuals to research and explore progression options that align with their specific career goals, interests, and local requirements. Different countries or regions may have varying certification or training requirements for mental health support roles, so it's advisable to check with relevant regulatory bodies or professional associations for specific guidance.

Awareness of First Aid for Mental Health
Delivered in Much Wenlock or Online + more
£60

Oracle database administration

5.0(3)

By Systems & Network Training

Oracle Database 12c Admin training course description This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. What will you learn Administer an Oracle database instance. Monitor an Oracle database. Configure the Oracle network environment. Create and manage database storage structures. Manage users, profiles, privileges and roles. Manage undo data and temporary segments. Monitor and resolve lock conflicts. Maintain database security. Implement database auditing. Monitor the performance of the Database. Load and unload data. Use the job scheduler. Configure a database for backup and recovery. Oracle Database 12c Admin training course details Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. Duration 5 days Oracle Database 12c Admin training course contents Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

Oracle database administration
Delivered in Internationally or OnlineFlexible Dates
£2,797

Drilling Essentials for New Engineers and Non-Technical Professionals in Oil & Gas

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course Time is money in the oil business. Drilling time is big money. Whether in a technical, managerial or supporting role, you are a valuable asset to ensuring that project delivery targets are met and profits are realised. As drilling activities continue, professionals like you must grasp the language and technology of drilling operations in order to maximise expenditures throughout the producing life of a well. Drilling equipment and procedures have a unique language that must be conquered for maximum benefit. Clear and understandable explanations of drilling rig equipment, procedures, and their complex interactions provide an excellent foundation for smooth communication and increased efficiency in inter-department project team efforts. Drilling Essentials will help you de-mystify activities around the rig and well planning. It will explain the fundamentals of drilling with an emphasis on key areas such as logistical considerations, costing, and analysis of drilling contracts. Understand the urgency of drilling requests, know more about the cost implications of drilling-related problems, and understand the risks involved in a drilling contract. With the course director's drilling knowledge and skills, this is your opportunity to explore and understand important drilling concepts, principles, and technology which are presented in a reader-friendly format and illustrated with examples. As a non-drilling professional, you too can grow with the drilling industry with a deeper understanding of the critical role you play in contributing to its success! Training Objectives By attending this industry fundamentals Virtual Instructor Led Training (VILT) course, you will be better able to: Understand drilling terminology & drilling processes for completing onshore & offshore wells Appreciate major cost components of drilling operations and its impact for better project planning and management Better visualise major drilling equipment and their technical functions to promote a deeper understanding of the logistical and technical considerations Gain valuable insights on the drilling industry with a synopsis of recent technology developments that impact the drilling process Target Audience This Virtual Instructor Led Training (VILT) course has been developed for new engineers and forward-looking executives in the following fields who are interested in enhancing their knowledge and awareness of the drilling process for increased productivity & contribution to the team they're supporting: Accounting Commercial Finance & Administration General Management Logistics Procurement Tender Contract Administration E & P IT Finance Joint Ventures Materials Planning Sourcing Training Business Development Estimation & Proposal HSE Legal Planning & Budgeting Supply Chain Drilling Fluids Organisational Impact Your expert course leader has over 45 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in the well engineering domain. After being employed in 1974 by Shell, one of the major oil & gas producing operators, he worked as an apprentice on drilling rigs in the Netherlands. After a year, he was sent for his first international assignment to the Sultanate of Oman where he climbed up the career ladder from Assistant Driller, to Driller, to wellsite Petroleum Engineer and eventually on-site Drilling Supervisor, actively engaged in the drilling of development and exploration wells in almost every corner of this vast desert area. At that time, drilling techniques were fairly basic and safety was just a buzz word, but such a situation propels learning and the fruits of 'doing-the-basics' are still reaped today when standing in front of a class. After some seven years in the Middle East, a series of other international assignments followed in places like the United Kingdom, Indonesia, Turkey, Denmark, China, Malaysia, and Russia. Apart from on-site drilling supervisory jobs on various types of drilling rigs (such as helicopter rigs) and working environments (such as jungle and artic), he was also assigned to research, to projects and to the company's learning centre. In research, he was responsible for promoting directional drilling and surveying and advised on the first horizontal wells being drilled, in projects, he was responsible for a high pressure drilling campaign in Nigeria while in the learning centre, he looked after the development of new engineers joining the company after graduating from university. He was also involved in international well control certification and served as chairman for a period of three years. In the last years of his active career, he worked again in China as a staff development manager, a position he nurtured because he was able to pass on his knowledge to a vast number of new employees once again. After retiring in 2015, he has delivered well engineering related courses in Australia, Indonesia, Brunei, Malaysia, China, South Korea, Thailand, India, Dubai, Qatar, Kuwait, The Netherlands, and the United States. The training he provides includes well control to obtain certification in drilling and well intervention, extended reach drilling, high pressure-high temperature drilling, stuck pipe prevention and a number of other ad-hoc courses. He thoroughly enjoys training and is keen to continue taking classes as an instructor for some time to come. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Drilling Essentials for New Engineers and Non-Technical Professionals in Oil & Gas
Delivered in Internationally or OnlineFlexible Dates
£2,321 to £2,699