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

11 Educators providing Assistant courses in Northampton

Cabe

cabe

Northampton

The role of CABE’s Presidential Team and Board is to set out the strategic objectives and aims of the Association and to ensure their delivery. All representatives on the board are members of CABE are nominated to the position by Chartered Members. They represent a mixture of views from different specialities and areas across the industry making sure there is a variety of perspectives to help shape CABE’s unifying voice. CABE Patron Lord John Lytton BSc FCABE (Hon) IRRV FRICS In his role as patron of CABE, Lord Lytton acts as an influential figurehead, creating valuable partnerships with organisations across the globe through his extensive network of industry and Governmental contacts and assisting the Association in raising its profile and influence within the building and construction industry. Lord Lytton is a leading chartered surveyor and an active contributor to the House of Lords. He is chairman of the boundaries and party walls professional panel of the Royal Institution of Chartered Surveyors and a Vice Chairman of the All Party Parliamentary Group for Excellence in the Built Environment as well as being newly appointed to the House of Lords Information Committee. He has been an Honorary Fellow of ABE since 1997, and CABE since its formation in 2014. Presidential Team Joseph Birt PCABE FCABE – President Joseph Birt worked for 22 years within Local Authority Building Control in various posts; the latter 12 years as Specialist Support Officer for a Cluster of Councils, which included responsibility for advising on fire safety aspects of the Building Regulations. He was, for ten years, a Director of the William Keown Charitable Trust, which champions equality in the built environment and celebrates the achievements of people with disabilities. He has been elected twice as Chairman of the Northern Ireland Fire Safety Panel. By Ministerial Appointment he served two terms on the Northern Ireland’s Building Regulations Advisory Committee (BRAC) where he contributed to the development of the current Northern Ireland Building Regulations. He has also served two terms on the Department of Communities, Historic Buildings Council. Joseph is a Chartered Building Engineer, who continues to be active within his local CABE Region; currently Treasurer and past Chairman of the CABE Northern Ireland Region’. He is now the Technical Director of FRSNI Ltd. Richard Smith VPCABE FCABE – Vice-President Richard Smith commenced his employment as a YTS Trainee in Building Control back in 1989 and has progressed his career to become the Head of Standards and Innovation and Research at NHBC where he oversees the delivery and implementation of NHBC's Technical Standards, Technical policy, Acceptance of innovative and non-traditional construction methods and leads the NHBC Foundation. Richard is also a member of The Building Regulations Advisory Committee and support a number of Sub Committees including new building broadband connectivity, Part M Working Group and Building Act 1984 working group. Richard Flynn CEng CEnv CWEM VPCABE FCABE – Vice-President Richard is an independent private practitioner trading as Flynn & Shaw, Chartered Building Engineers. As well as being a Chartered Building Engineer, he is a Chartered Engineer, Chartered Environmentalist, Chartered Water and Environment Manager, Registered Building Surveyor and Certified Site Assessor. Richard is a recognised expert in the area of onsite wastewater treatment and provides a complete site suitability assessment, treatment system design, and certification of installation for onsite wastewater treatment systems throughout Ireland. Richard has been Chair of the CABE Membership and Professional Standards Committee (MPSC) since its inception in 2019 as well as member of the Southern Ireland Region committee of CABE. Stewart C McArthur BSc (Hons) PPCABE FCABE RICS Dip BC – Past President Stewart has 30 years’ experience in the house building industry. He has a degree in Fire Risk Engineering from Glasgow Caledonian University. During his studies he also attended seminars at Maryland University and had the privilege of being tutored by some of the most widely respected experts in the fire engineering sector. Stewart began his career in building standards before moving into the warranty sector. He also has recent experience as a site manager. This broad experience has given him a greater understanding of the house building industry from all perspectives. He has been a member of CABE since 2001 and has played an active part in the regional committee for the past ten years. CABE Board Daniel Fordham FCABERussell Urwin FCABETony Harvey-Soanes FCABEPaul Grinyer FCABEDavid Courtney CEnv FCABE Lindsay Richards BSc MBA MCABE Chartered Building EngineerZoe Cox FCABEMishka Scott MCABE Chartered Building EngineerDavid Kitcatt FCABEIsacc Sunder Packianathan FCABE Executive Team Dr Gavin Dunn BSc (Hons) MSc PhD FCABE – Chief Executive Originally trained as an architect, Gavin initially practised in North America with a large construction engineering firm before returning to the UK to specialise in the energy and environmental performance of buildings in 1998. Gavin advanced this specialism through positions at the Welsh School of Architecture, and Elmhurst Energy, where he helped develop some of Europe’s leading building energy certification and labelling systems. In 2013 Gavin was appointed Director of Building Performance at the Building Research Establishment (BRE) where he was responsible for a portfolio of BRE's globally leading services including BREEAM and CEEQUAL the world’s foremost environmental assessment methods for the built environment. In 2018, Gavin was appointed as Chief Executive of CABE where he works to help enable a more professional construction sector that works to create better, safer and more sustainable buildings that enhance people’s lives. Gavin was a member of the Building Regulations Advisory Committee (BRAC) of the UK Government from 2015 to 2022 where he served as Chairman of the Future Homes Standard Working Group. Jackie Macaulay – Chief Operating Officer Jackie is responsible for all aspects of the organisations operations and internal processing. Her remit includes compliance, legal services, HR, OD & change management, IT, facilities, PR & communications, membership processing and deputising for the CEO in his absence. Her experience spans a range of manufacturing, construction and not-for-profit organisations with her first Director position as HR Director for Electrolux in 2004. Jackie has worked across the UK, Ireland and internationally across Europe and Asia managing diverse and multi-disciplined teams. She brings to CABE the senior expertise that will develop the organisation as it moves forward with its modernisation and development strategy. Richard Harral BA BArch FCABE RIBA – Technical Director Richard Harral is the Technical Director for CABE. He has previously worked as an architect in both public and private sector practice, and as a policy official in the Building Regulations Division of MHCLG between 2007 and 2014 where he oversaw introduction of policies on accessible housing, security standards, broadband and the national space standard for new homes. He was subsequently Head of Technical Policy in the period 2014-2017. He currently sits on the CIC Competence Steering Group, and chairs a number of competence working groups including on Designer and Architect Competence. He was Technical author for Flex 8670, the recently published British Standard on Competence for building safety in Built environment industries. Alison Duckles CBE – Professional Development Director Alison has worked in the Construction sector for over 24 years, predominantly with Laing O’Rourke. She previously held roles with the Chartered Institution of Waste Management and Eastern Group plc in the power sector. Predominantly focused on learning and development while driving competence, professional standards, and futures skills requirement; Alison worked extensively on the creation of new construction apprenticeships, engaging employers, providers, sector bodies and Government. In her role with CABE Alison is responsible for continuing to strengthen partnerships with academic institutions, provide members with quality training and CPD opportunities and Support the Association’s ambition to drive competency and professional responsibility in the construction sector. CABE Staff Membership Services Team – membership@cbuilde.com Our friendly, experienced membership team is always on hand to offer the best possible advice on becoming a member of CABE, advising you on the best route to membership and helping you to progress through our grades as your career develops. Amy Chatfield – Membership Services Manager Amy leads the Membership Team, which is responsible for all membership processing, professional interviews for CABE Chartered Membership and registrations for both the Engineering Council and Society for the Environment. With a strong background in customer service, Amy joined CABE in 2015. She has held a variety of positions, including roles in the Publications Team – working on the building engineer journal – and the Events & Marketing Team. After building extensive knowledge of the membership journey, she moved into the Membership Team in 2018; since then, she has worked continuously to improve processes, ensuring that the Association provides excellent customer service to all new and existing members. Alongside her role as Membership Services Manager, Amy is a trained Mental Health First Aider (MHFA), providing wellbeing support for her colleagues. Sabrina Miah Professional Review Co-ordinator Tara Talley Membership Services Co-ordinatorJoshua Law Membership Services Administrator Communications Team – info@cbuilde.com The Communications team deliver vital resources, news, and information to our membership, keeping them up-to-date with industry changes, standards, and opinions. This is done through direct contact with our membership, delivering our monthly journal, BuildingEngineer . Laura Richardson - Head of Communications Laura has been with CABE since 2018 when she joined as PR and Communication manager. She is responsible for implementing the communications strategy across the Association’s communication streams including PR, Marketing, and Digital Infrastructure functions. She joined CABE from Booker, where she gained experience in website marketing and design. Along with her previous experience working in publications and marketing roles in the construction industry she brings a lot of skills and strengths to the team. Maya Bullock Communications & Digital Designer Abigail Crook Communications Administrator Professional Development Team – training@cbuilde.com CABE provides a range of services to our members and the wider industry to assist in the expansion of knowledge in respect of the built environment. Our Professional Development Team facilitate this by ensuring opportunities such as our suite of regional conferences, annual conference & exhibition, training courses, local/regional CPD and our 12 UK & ROI regions run smoothly and offer the highest possible quality in their delivery. Kirri Porter-White - Competency & Learning Lead Kirri has been with the association since 2015, working initially within the Regional Services and Events team to provide support for the regional committees over CABE’s 12 regions in the UK and Ireland, as well as our international Chapters. Kirri is responsible for the development and deployment of CABE’s training and learning infrastructure, focusing on both technical competency and wellbeing within the construction industry. Kirri’s team also work with the Professional Development Director on academic accreditation and relationships with universities. Rosemary Brewill Regional Services Co-ordinatorShaneka Foster Professional Development Administrator Operations Team – info@cbuilde.com The Operations Team are involved in the day-to-day activities of the Association, to ensure the smooth running of all CABE’s activities, including Finance, IT, Legal and Facilities. Carl Pearson - Head of Legal and Governance Services Carl has worked both private practice and in-house roles, within the sectors of welfare law, housing law, debt law, consumer law, compliance law, and commercial law. Joining CABE in 2018 from Dixons Carphone, Carl is responsible for providing the Association with internal legal advice on its business practices, activities and contractual relationships, development and review of various internal policies and procedures and day-to-day management of disciplinary and complaints investigations. Jacky Lonsdale - Head of Finance Jacky joined CABE in November 2021 and brings a wealth of experience having worked for a number of both large corporate companies and smaller businesses including JVC, Total Oil Marine, Bosch Security Systems and Vinci Construction. Before joining CABE she worked for the Auto-Cycle Union, a motorcycle membership organisation. As Head of Finance Jacky is responsible for the delivery of financial information to the management team. Finance encompasses all areas of accounting processes, monthly management accounts, forecasts, annual budgets and financial statements. It also covers all aspects of audit liaison and statutory return requirements. Jacky’s mission is to ensure financial reporting is accurate, concise and on time. Helena Wootton Reception and Office ManagerAlison Lodge Executive AssistantCharlotte Taylor Finance Assistant Hong Kong Office – info@cbuilde.com Vivian Sie BA (Hons) MA MSc - General Manager Vivian is the General Manager of CABE Hong Kong Chapter responsible for daily operation, enhancing communication with members and working partners, upholding the reputation of one of the international recognised associations in Hong Kong and beyond.Before joining CABE, Vivian had experience in the areas of corporate governance and public sector management where she was instrumental in providing efficient secretarial support to a local leading professional institute and a regulatory body. Her remit included membership processing and benefits, media relations, disciplinary proceedings, set-up of Biennale Foundation and Beijing Representative Office, key event planning and execution. After graduating with BA honours in translation, Vivian obtained a distinction in the Master of Arts in International Communication from the Macquarie University, Australia. She has a Master of Science in Public Sector Management. Mable Hung Administrator

Courses matching "Assistant"

Show all 120

Phlebotomy Training - Beginner to Advanced PACKAGE

4.6(39)

By Geopace Training

THIS COURSE PACKAGE INCLUDES: 1: INTRODUCTION TO PHLEBOTOMY COURSE (GPT003) - Level 3 (Ireland Level 5) 2: ADVANCED PHLEBOTOMY COURSE (GPT005) - Level 4 (Ireland Level 6) 3: GEOPACE COMPETENCY CERTIFICATE - CPD Certified (optional with Virtual Classroom) Learn how to take blood ... train as a Phlebotomist FAST-TRACK YOUR PHLEBOTOMY TRAINING WITH OUR COMPLETE TRAINING PACKAGE 20% off - Multi-Course Discount Cover all stages from beginner through to Level 4 Available as Classroom or Virtual Classroom Complete your beginner to advanced training in 2 days Awards 2 accredited qualifications - Introduction to Phlebotomy and Advanced Phlebotomy qualifications Both courses are dually accredited (OCN & CPD) Geopace Certificate of Competency included with classroom attendance or available as an option when booking virtual classroom Covers all steps up to live blood draw Learn advanced skills and techniques Virtual Classroom options include comprehensive Practise@Home Training Kits (yours to keep) Basic understanding of English language required OPEN TO ALL APPLICANTS

Phlebotomy Training - Beginner to Advanced PACKAGE
Delivered in Portsmouth + 17 more or Online + more
£495

L 3: Teaching Assistant Course

5.0(6)

By Learn More Academy Ltd

Level 3 Supporting Teaching and Learning in Schools Certificate is a RQF qualification & this course play a major role by working with pupils & supporting teachers. This course has been designed to teach the knowledge required to be a teaching assistant and support children’s learning from birth to nineteen years. The course covers various requirements needed to work as an assistant within schools and how to approach a career in the education sector.  ABOUT THIS COURSE: Level 3 Award in Supporting Teaching and Learning is a knowledge only qualification. Experience in the real work environment is not required and the entire course is completed online. Please note that this is a knowledge only Level 3 qualification and does not require any practical assessments. COURSE ASSESSMENT: To pass this course learners must pass 4 assignments. These are completed after navigating through the corresponding lessons and writing your answers to assignment questions. Once these have been read and marked by your personal tutor, feedback and marks are provided to students which contain helpful tips to improve work in future assignments. UNITS COVERED: • Unit 1: Schools and Colleges as Organisations • Unit 2: Support Health and Safety in a Learning Environment • Unit 3: Understand how to Safeguard Children and Young People • Unit 4: Understand How Children and Young People Develop HOW MUCH THIS COURSE COST? Level 3: Award in Supporting Teaching and Learning Course will cost for Distance Learning / Online £249.99 and for class based £349.99. There is no any hidden fess/cost. 

L 3: Teaching Assistant Course
Delivered in Birmingham + 7 more or OnlineFlexible Dates
£249.99 to £349.99

Advanced Phlebotomy - Skills & Techniques (GPT005)

4.6(39)

By Geopace Training

The UK's first and only Level 4 qualification in Phlebotomy (equivalent to Ireland Level 6) FDSc (Foundation Degree Level) qualification Nationally Recognised certificate Dually accredited: Open College Network and CPD Covers both aspirated and evacuated systems Covers specialised blood collection systems & methods Classroom or Virtual Classroom learning options Comprehensive Training Kit is provided when booking our Virtual Classroom option (yours to keep) Complete your training from beginner to advanced level This course either follows on from our Introduction to Phlebotomy Course or can be combined with our introductory course as part of a course package (see below) Available to candidates who have completed (or are currently enrolled to complete) our Introduction to Phlebotomy Course or have previous phlebotomy practical experience.

Advanced Phlebotomy - Skills & Techniques (GPT005)
Delivered in Liverpool + 17 more or Online + more
£195

Introduction to Phlebotomy Course (GPT003) - 1 DAY Classroom - Part 1 online + Part 2 Classroom

4.6(39)

By Geopace Training

Learn how to take blood ... train as a Phlebotomist Nationally Recognised Qualification No previous experience or qualifications needed OCN Accredited - Level 3 (advanced) CPD Accredited (The CPD Certification Service) Covers all steps up to live blood draw Practise on artificial arm and fake blood! Basic understanding of English language required OPEN TO ALL APPLICANTS

Introduction to Phlebotomy Course (GPT003) - 1 DAY Classroom - Part 1 online + Part 2 Classroom
Delivered In-Person in Bedford + 5 more + more
£285

Route to Competency Masterclass - Live Blood Sessions

4.6(39)

By Geopace Training

AVAILABLE ONLY TO APPLICANTS WHO HAVE ENROLLED ON (OR HAVE PREVIOUSLY COMPLETED) OUR INTRODUCTION TO PHLEBOTOMY COURSE Geopace Certificate of Competency Add live blood draws to your training Follow and complete a Competency Checklist Obtain tutor sign-off for live draws Awards a CPD Accredited Certificate Awards a Geopace Certificate of Competency Half day or evening sessions

Route to Competency Masterclass - Live Blood Sessions
Delivered In-Person in Bedford + 18 more + more
£159

Level 4 Diploma in Construction Site Supervision

By BAB Business Group

The NVQ Level 4 Diploma in Construction Site Supervision is appropriate for individuals who work as a Construction Site Supervisor/ Foreman or Assistant Site Manager in the construction sector and are looking to become eligible for the Gold ‘Site Supervisor’ CSCS Card. Our team will discuss the qualification process with you prior to signing up in order to ensure that you will be able to complete the qualification. Every candidate is assigned a competent and experienced assessor who will provide advice and guidance throughout the programme to ensure that candidates are supported in the successful completion of the qualification. CSCS Cards We can provide CSCS tests and CSCS cards alongside your qualification without the need to attend the test centre. Speak to our friendly and helpful team for more information.

Level 4 Diploma in Construction Site Supervision
Delivered In-Person in Heywood or UK WideFlexible Dates
£2,200

Level 4 Diploma in Construction Site Supervision – Retrofit

By BAB Business Group

The NVQ Level 4 Diploma in Construction Site Supervision – Retrofit is appropriate for individuals who work as a Construction Site Supervisor/ Foreman or Assistant Site Manager in the Retrofit construction sector and are looking to become eligible for the Gold ‘Site Supervisor’ CSCS Card. Our team will discuss the qualification process with you prior to signing up in order to ensure that you will be able to complete the qualification. Every candidate is assigned a competent and experienced assessor who will provide advice and guidance throughout the programme to ensure that candidates are supported in the successful completion of the qualification. CSCS Cards We can provide CSCS tests and CSCS cards alongside your qualification without the need to attend the test centre. Speak to our friendly and helpful team for more information.

Level 4 Diploma in Construction Site Supervision – Retrofit
Delivered In-Person in Heywood or UK WideFlexible Dates
£2,200

NVQ Level 4 Diploma in Construction Site Supervision (Construction)

5.0(29)

By Site Competence

Gold CSCS Card NVQ Level 4 Diploma in Construction Site Supervision This qualification is for managers on-site who are working as a site supervisor or assistant site manager. You should be liaising with contractors, supervisors, and construction site management, organising resources, and have responsibility for health and safety and quality control such as inductions, briefings toolbox talks and inspections. You may work across one or more of the following Pathways: Building and Civil Engineering Highways Maintenance Residential Development Conservation Demolition Induction - As soon as you register you will be given a dedicated assessor. They will arrange an induction and together with your assessor you'll get to decide on the pathway which best proves your competency. The induction is used to plan out how you will gather the relevant evidence to complete the course. During the course - The assessor will work with you to build a portfolio of evidence that allows you to showcase your knowledge, skills and experience. The assessor will also regularly review and provide you with feedback. This will allow you to keep on track to progress quickly. You will be assessed through various methods such as observations, written questions, evidence generated from the workplace, professional discussion and witness testimonials. On completion - Once all feedback has been agreed, the Internal Quality Assurer will review your portfolio and in agreement with the assessor your certificate will be claimed. To download our PDF for this course then please click here.

NVQ Level 4 Diploma in Construction Site Supervision (Construction)
Delivered In-Person in Market Rasen or UK WideFlexible Dates
£1,440

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

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