Enhance your skills in process control and instrumentation with EnergyEdge's comprehensive classroom training. Enroll now and take your career to new heights.
Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.
Why Learn Vectorworks Spotlight Training Courses? VectorWorks Spotlight Course offers strong 2D drawing tools and lighting skills. while. Spotlight goes beyond fundamentals, offering solution for designing, modeling, and sharing entertainment projects. It's the industry standard for lighting, scenery, sets, corporate events, theater, and exhibits. Click here for more info: Website When can I book this course? 1-on-1 training. Duration: 16 hrs, Flexible scheduling (Mon to Sat, 9 am - 7 pm). Choose your own day and time. Training Course: Vectorworks Spotlight Duration: 16 hours Course Overview: I. Introduction to Vectorworks (1 hour) Overview of Vectorworks software and its diverse applications Familiarization with the user interface and navigation Customizing preferences and settings to optimize workflow II. 2D Drawing Tools (2 hours) Utilizing basic drawing tools for creating lines, rectangles, circles, and polygons Implementing text and dimension tools for annotations Applying modify tools for object editing and transformation Organizing elements using layers and classes III. 3D Modeling Tools (3 hours) Introduction to extrude, revolve, sweep, and loft tools for 3D modeling Creating 3D objects from 2D shapes for spatial representation Modifying and refining 3D models Exploration of the 3D modeling environment IV. Advanced 3D Modeling Tools (2 hours) Utilization of solid modeling tools for complex geometry creation Performing Boolean operations to combine or subtract shapes Creation and use of symbols for efficient workflow V. Introduction to Spotlight (1 hour) Overview of the Spotlight workspace and its features Adding and configuring lighting devices for stage and event design Creation and modification of lighting positions for precise placement VI. Spotlight Tools and Techniques (3 hours) Creation and editing of lighting instruments for customized setups Use of visualization tools for lighting simulations Creation and application of labels and legends for documentation Generation of worksheets and reports for lighting analysis VII. Advanced Spotlight Techniques (2 hours) Utilization of video and projection tools for multimedia presentations Incorporation of audio and sound systems for immersive experiences Understanding rigging and hoisting for stage setup Management of paperwork and documentation for effective planning VIII. Integration with Other Software (1 hour) Importing and exporting files for collaborative work with other software Utilizing Vectorworks in CAD and BIM workflows for seamless interoperability Exploration of plugins and add-ons for expanded functionality IX. Project-based Exercises (1 hour) Application of learned techniques to real-world scenarios Creation of a lighting plan for a concert or theater production Designing a 3D model of a building or interior space Free 30-day BIM & CAD Software Trial Request: Vectorworks After completing Vectorworks 2D | 3D and Spotlight Training Course? Vectorworks Proficiency: Master Vectorworks software, including interface and tools. 2D Drafting: Create precise technical drawings using fundamental 2D tools. 3D Modeling: Develop skills in 3D modeling, modification, and spatial representation. Spotlight Expertise: Learn stage and event design tools, focusing on lighting setups. Advanced Techniques: Explore complex 3D modeling and Spotlight features. Interdisciplinary Integration: Integrate Vectorworks with other software in CAD and BIM workflows. Project Application: Apply skills to real-world scenarios, creating plans and models. Job Opportunities: CAD Technician: Draft detailed plans for architecture and engineering firms. Stage Designer: Plan lighting, sound, and multimedia setups for events. Event Planner: Design event layouts with lighting and audio-visual setups. Architectural Drafter: Create accurate architectural plans and models. Interior Designer: Visualize interior spaces in 2D and 3D for clients. Lighting Designer: Specialize in various lighting applications, from buildings to stages. BIM Specialist: Work with architectural firms on Building Information Modeling projects. Freelance Designer: Offer services in 2D/3D modeling, event planning, or architectural visualization. What is Vectorworks Spotlight? Vectorworks Spotlight is a specialized package tailored for entertainment design professionals, offering both 2D and 3D capabilities. It is the industry-standard CAD software for entertainment design, ideal for lighting, scenery, sets, events, theater, and exhibits. Training Details: Duration: 16 hrs (flexible scheduling) Method: Personalized 1-on-1 training (In-person or Live Online over Zoom) Tailored content, adaptable pace, individual support Differences from Vectorworks Fundamentals: Vectorworks Fundamentals serves general modeling and drawing needs, while Spotlight provides comprehensive solutions for design, modeling, documentation, and collaborative project sharing, catering specifically to industry experts. Applications of Spotlight: Spotlights have diverse uses, including emergency situations and when a powerful light source surpassing a flashlight is required. Interior Designers and Vectorworks: Yes, interior designers use Vectorworks software, particularly Vectorworks Architect, for efficient workflow and effective realization of creative visions. Course Structure: Individualized Instruction (1-2-1) Customized Content Adaptable Learning Pace Flexible Scheduling: Monday to Saturday, 9 am to 7 pm Get Vectorworks: For more information and to download Vectorworks, visit Vectorworks Website. Individualized Training: Get personalized attention and tailored guidance during your training sessions. Flexible Timings: Select your preferred schedule and training days to fit your convenience. Post-Training Assistance: Access complimentary online support even after course completion. Comprehensive Resources: Receive detailed PDF notes and handouts for effective learning. Certification of Completion: Receive a recognition certificate upon successfully finishing the course. Affordable Pricing: Take advantage of budget-friendly training rates. Software Setup Support: Receive assistance in configuring the software on your device. Referral Benefits: Recommend a friend and enjoy discounts on upcoming courses. Group Training Offers: Benefit from special discounts for group training programs. Convenient Hours: Attend sessions from Monday to Sunday, with extended operating hours. Tailored Learning: Experience customized training designed to meet your specific requirements.
Essential skill for all mental health professionals This 2-day workshop gives you the opportunity to see demonstrated, experience, and practice the steps of this powerful technique in a small group under the careful guidance of our expert tutor… Accredited CPD Certificate : 12 hours Length 2 days (9:30am - 4:00pm) Excellent course. A brilliantly encouraging and supportive environment in which to learnHARRIET, WORKSHOP PARTICIPANT Life-changing! A great weight has been lifted off my shoulders.NURSE (PREVIOUSLY TRAUMATISED BY A CAR ACCIDENT) Why take this course We have over 20 years of experience in teaching the rewind technique to health and welfare professionals – we’ve drawn on that experience to develop a course which gives you enough time to thorough absorb and practice the technique, understand why it works and to experience it yourself, so that you leave confident in your ability to use the rewind safely and effectively. The Rewind Technique* is an effective psychological intervention for successfully treating trauma and phobias and one of the most important skills you need to master to be able to work successfully with any anxiety disorder or condition which may have developed as a result of unresolved trauma. Even the most severe phobic and post-traumatic stress (PTSD) symptoms can be successfully addressed using the the rewind technique taught on this 2-day course, which has been refined* in line with understandings from neuroscience to make it as safe and reliably effective as possible. An essential therapeutic technique to have in your therapeutic ‘toolkit’, it is important to learn and practice it under the careful guidance of our expert tutor – you will leave the course knowing how to use the rewind technique safely and effectively having watched live demonstrations, had plenty of time to practice the steps involved with fellow students, the opportunity to experience the technique yourself and more. Our workshop has limited numbers so you will have plenty of opportunities for asking questions and the tutor, who has extensive clinical experience. Using the rewind technique you can, often surprisingly quickly, detraumatise bad memories, stop flashbacks and other PTSD symptoms, cure phobias, banish nightmares and reduce anxiety so you can help the victims of abuse, rape, violence, car accidents, fire, terrorism and panic attacks, heart attacks and other life-threatening experiences. Another key benefit of this technique is non disclosure – there is no need for people to repeatedly revisit or talk about specific details of the events that have traumatised them. This helps avoid embedding the trauma further and making the situation worse – as can sometimes inadvertently happen in other therapeutic approaches to treating trauma – and helps prevent the therapist or counsellor being vicariously traumatised by what they might hear. It is also invaluable when working therapeutically with people who have suffered persistent physical or sexual abuse, and people with OCD. People suffering from other conditions, such as depression, addictions or uncontrollable anger, may have experienced a traumatic event, which needs to be successfully detraumatised in order for them to move on with their lives. As a result of our training in the rewind technique – which we have been delivering for over 20 years – our graduates have brought relief to literally thousands of people (eg. case history / PTSD Resolution). Please note This is a powerful technique, which needs to be implemented with care – we recommend you take the time to learn it in person in a small group with a skilled and highly experienced tutor who can guide you through the important steps involved, oversee you as you practise them, answer your questions and give you crucial direct feedback. The version of the rewind technique* you will learn on this course has been refined in line with understandings from neuroscience to make it as safe and reliably effective as possible. The course is taught over two days to ensure you have enough time to thoroughly absorb and practice the steps involved so that you are confident in using it and know how to do so safely and effectively with clients. You will also learn when it is NOT appropriate to use this technique and how to ensure you avoid embedding any trauma further, or making a phobia worse. Guided imagery and visualisation skills form an essential part of the rewind technique, which is why they are a requirement for attending this course. This has huge potential to change people's lives for the better. I can't wait to put what I've learnt here to good usePSYCHIATRIC SUPPORT WORKER What will you learn How to detraumatise people quickly and safely The necessary skills to treat even severe phobias Why this version of the rewind technique is so effective, and how it works Under careful guidance from the tutor, you will: revisit key skills for relaxing clients in order to successfully work using the technique walk and talk through a step-by-step breakdown of the rewind technique see a live demonstration of working with a phobia or trauma practice each stage of the rewind technique in pairs practice the entire process, with other course participants, under supervision You will also gain: Vital tools for psycho-education – both adding to your own understanding and to pass on to clients A clear understanding of the fear response and how PTSD and phobias develop The detrimental impact traumas and phobias can have on a person’s life The crucial role of the pattern-matching processes in the brain in triggering phobic responses and post traumatic stress symptoms How the main treatment techniques for treating post traumatic stress disorder (PTSD), sub-threshold trauma and phobias (including EMDR, EFT and CBT) work – their advantages and disadvantages Why the rewind technique draws on the innate ability we all have to recover from trauma Pre-disposing factors for suffering a problematic post-traumatic response (or developing a phobia) Why critical incident debriefing increases the incidence of PTSD How this version of the rewind technique has been modified to make it safer and more reliable Trauma-focused rewinding: the psycho-biological reason why this refined rewind technique works so consistently well A step-by-step breakdown of the essential stages of the rewind technique The chance to see a live demonstration of working with a phobia or trauma You will leave with: The confidence to begin using the technique ethically and safely A clear understanding of the advantages of using a non-intrusive psychological technique to treat trauma, PTSD and phobias (where the client does not have to go into details about or repeatedly ‘revisit’ what has traumatised them) What to do if a client as an abreaction Important information about when not to use this technique – and what can be done instead An understanding of how the rewind technique can be used to work with Complex Trauma and cases involving ‘freeze’, shutdown or dissociative responses How you can carefully apply this technique to relieve a huge range of anxiety disorders Greater confidence in dealing with anxiety disorders and distress caused by trauma, phobias and flashbacks An understanding of how rapidly transformative this technique can be; on the last afternoon we view a filmed therapy session (and follow up) in which Joe Griffin uses the rewind technique to relieve a young man of his severe shark phobia There is also plenty of opportunity for you to ask questions and to experience and practice, under careful guidance, the various stages of the rewind technique yourself. Who is this course suitable for? Anyone working with distressed, phobic or traumatised people, who has already taken our Guided Imagery and Visualisation workshop (and ideally the Therapeutic Power of Language workshop too) as these skills are essential components of the rewind technique. If you help traumatised people (including children) or people suffering from any form of phobia or anxiety disorder – this includes: psychotherapists, counsellors, mental health nurses, OTs, health visitors, social workers, psychiatrists, GPs, clinical psychologists, midwives, welfare officers, youth workers, hypnotherapists and those working with traumatised members of public services, such as: firefighters, police, paramedics and military personnel – you will find the rewind technique and associated skills hugely helpful. Course requirements Guided imagery, relaxation and visualisation are an integral component of the Rewind Technique – if you don’t already have experience in using these skills therapeutically with others you must complete our Guided Imagery and Visualisation for Therapeutic Change workshop before attending this course (this is always run the day before our rewind technique training). This is to ensure you get the most out of this 2-day course and also have the necessary skills for practising the rewind technique safely and effectively. You would also find it useful to attend the Therapeutic Power of Language workshop beforehand if you can. All 3 workshops count towards Part 1 of the HG Diploma. Ros Townsend’s live online training Trauma: Patterns of the past is also useful for anyone working with or supporting someone suffering from unresolved trauma, or who would like to understand their own experiences of trauma better. She also runs a workshop on working with Complex Trauma. *About the Rewind Technique The Rewind Technique originated from one developed by Richard Bandler, one of the founders of NLP, when it was called the Visual/Kinaesthetic Dissociation protocol. A variant of this was developed by Dr David Muss, who called it the Rewind Technique. The version of the Rewind Technique you will learn on this 2-day course was refined by Joe Griffin and Ivan Tyrrell, co-founders of the human givens approach, to make it as reliably effective and safe as is possible by aligning the method with their insights into how trauma and phobias are processed in the brain. HG Therapists now follow a specific Rewind Protocol which follows the essential steps of the process that Griffin and Tyrrell set out. Course format This intense 2-day training proceeds through a blend of talks, live demonstrations, skill-developing exercises, practice sessions (under careful guidance) and deconstruction of filmed examples of the technique being used, including one with a severely traumatised young woman. There is also plenty of opportunity for networking and discussion during the breaks. The course was previously entitled: The fast phobia and trauma (PTSD) cure – a 2-day workshop in the rewind technique This course has been independently accredited by the internationally recognised CPD Standards Office for 12 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.
Essential skills for successfully treating a wide range of conditions – such as trauma, addictions, anxiety and depression – as well as making long-lasting behaviour changes and much more… Accredited CPD Certificate : 6 hours Length 1 day (9.30am - 4.00pm) This has been a priceless experience. Life-changing. Brilliant, simply brilliant!COUNSELLOR / EX IT SERVICE MANAGER Why take this course Strong emotions focus and lock attention – keeping people trapped in problem behaviours. Therapeutic change cannot happen until the emotional arousal is reduced. This is why all health and welfare professionals need to know how to induce the relaxation response in their clients. Guided imagery and visualisation not only reduce emotional arousal quickly but can be used to reframe life circumstances through metaphor and to rehearse in the imagination any required changed behaviours and/or feelings, which dramatically increases the likelihood of those changes taking place in ‘real life’. If you want to be able to help people effectively, this is a key course to attend – guided imagery is an essential skill required for removing phobias, curing PTSD, lifting depression and overcoming addictions or self-harm, and is also useful for raising self-confidence and increasing motivation. When you become confident in using these skills, you can begin to bring patients out of the emotionally-driven trance states of a wide range of conditions such as anxiety disorders, addiction, anger, stress overload, trauma, depression, chronic pain and much more. That is why guided imagery is one of the most powerful psychotherapeutic tools available to us – and one you need in your ‘toolkit’. Fascinating way of working with clients – relaxation techniques very powerful. Extremely relevant to practice. Good techniques and strategies learnt to use with clients to help them problem solve and move forward.HEALTH VISITOR What will you learn Powerful new ways to improve treatment outcomes Training and practice in using one of the most effective psycho- therapeutic tools available for treating a wide range of emotional and physical conditions Invaluable ways to motivate people, reframe life circumstances and instigate changes in behaviour Insight into how the mind/body communication system works Greater confidence when working with a wide variety of conditions Supervised practise in generating healing trances The core skills you need to acquire for the rewind technique for treating PTSD and phobias A variety of ways to help people relax Ways to reduce pain, including in childbirth Increased understanding of trance states and their role in everyday life Effective skills for helping people improve their performance – sports, public speaking etc. The opportunity to experience relaxation, guided imagery and visualisation yourself A scientifically-sound knowledge of why the various techniques and skills you will gain are so valuable And much more Good to know The skills you will learn on this course are an essential pre-requisite for taking the The Rewind Technique – Effective treatment for trauma (PTSD) and phobias course. You will also need them for the following courses too: Brief Therapy for Stopping Addictions How to Lift Depression Overcoming Self-harm Further guided imagery techniques can be learnt and practised on our NEW workshop: Guided Imagery 2 – essential techniques Course Programme The ‘Guided imagery and visualisation for therapeutic change’ course starts at 9.30am and runs until 4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am What guided imagery is and why it works 11.00am Discussion over tea/coffee 11.30am The essence of all relaxation inductions: an easy way to start 1.00pm Lunch (included) 1.45pm Why it is important to be flexible: a range of techniques 2.45pm Discussion over tea/coffee 3.00pm Guided imagery and counselling: the essential steps 4.00pm Day ends Who is this course suitable for? Anyone who wants to help people effectively and for the long-term, particularly those involved in mental and physical healthcare would benefit from attending Psychotherapists, counsellors and mental health workers – these skills are essential to have to work with a wide range of conditions and for ensuring long-term behaviour change (see list below) Trained hypnotherapists looking to extend and build on their existing skillset and understanding The information and skills taught are extremely useful for dealing with: Stress; addictions; agoraphobia; allergies; anorexia; anger; asthma; bed wetting; blood pressure; bulimia; depression; lack of confidence; chronic pain; eczema; frustration; guilt; grief; hay fever; inhibition; insomnia; irritable bowel (IBS); relationship/marital difficulties; migraine; nightmares; obsessions (OCD); pain control; panic attacks; phobias (all kinds); sexual difficulties (impotence, premature ejaculation and vaginismus); shyness; skin disorders and trauma (PTSD); flashbacks; ulcers; warts and worrying. You can also control blood pressure, stimulate the immune system, promote healing of damaged skin tissue and bones and give birth easier using guided imagery and visualisation. This course has been independently accredited by the internationally recognised CPD Standards Office for 6 hours of CPD training. On completion of this training you’ll receive CPD certificates from the College and the CPD Standards Office.