379 Office courses in London

Learn to use Excel’s most powerful features on this 2-day advanced Excel training course. This course is hands-on. It includes plenty of time to experiment with what you are being taught and ask questions. By the time you finish, you’ll be an expert Excel user.  ✔ A complete course that covers all of Excel’s most advanced functions.  ✔ Friendly expert trainers, small groups and a comfortable place to learn.  ✔ Ongoing support & help with any issues you may have after the course. Our courses are delivered in Guildford, London, Online, or even on-site at your offices!

Microsoft Excel® in Depth: In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Revit face to face training customised and bespoke. Online or Face to Face

The PRINCE2® Practitioner course provides delegates with in-depth knowledge of project management methodologies. In this 2-day PRINCE2® Practitioner course enables learners to tailor the PRINCE2® methodology to any given project scenario. At the end of this PRINCE2® Practitioner course, delegates will be able to do delegating tolerances Course Overview The PRINCE2® Practitioner course provides delegates with in-depth knowledge of project management methodologies. In this 2-day PRINCE2® Practitioner course enables learners to tailor the PRINCE2® methodology to any given project scenario. They will learn about various essential topics such as communication management approach, tailoring the SU process, giving Ad Hoc direction, setting up the project controls, risk management procedure, PRINCE2® quality requirements, PRINCE2® approach to plan, tailoring SB, and many more. At the end of this PRINCE2® Practitioner course, delegates will be able to do delegating tolerances and report actual and forecast progress effectively. They will also be able to properly prepare the risk management, change control approach, quality management, and communication management approaches. The PRINCE2® Practitioner enables learners to apply their acquired knowledge and obtain highly reputed jobs with upgraded salaries. Concepts covered: • Balance of justification • Create the project plan • Quality audit trail • Quality review technique • Designing a plan • Gantt chart and tailoring • Change control approach Who should attend this PRINCE2® training course? This PRINCE2® Practitioner training course is for anybody interested in the field of project management. This PRINCE2® course is also intended for anyone looking to build their knowledge of how to tailor the PRINCE2® method to workplace scenarios. Other individuals that would benefit from undertaking PRINCE2® certifications include: • Project Managers • Aspiring Project Managers • Project Board Members • Project Support Staff • Office Support and Line Managers • Product Deliver Managers • Senior Responsible Owners • Change Analysts PRINCE2® Practitioner Prerequisites: It is required that delegates provide sufficient evidence of having satisfied the prerequisites before attending the PRINCE2® Practitioner training course. Delegates must hold the 2009 or 2017 version of the PRINCE2® Foundation certification or another valid qualification such as PMP, CAPM, or an IPMA Level A-D qualification. What’s Included in this PRINCE2® Practitioner Training Course? The following is included in this PRINCE2® Practitioner course: • PRINCE2® Practitioner Examination • Pre-course material • Post-course material • PDUs • Experienced PRINCE2® Instructor • Certificate • Refreshments Course Content: Module 1: Organisation Theme: • Four Levels of Management • PRINCE2® Organisation Requirements • Project Management Team • Project Management Team Roles • Project Board • Project Assurance • Change Authority • Project Support • Communication Management Approach Module 2: Starting Up a Project (SU): • Process Overview • Feasibility Study and Mandate • Appoint the Executive and the Project Manager • Capture Previous Lessons • Design and Appoint the Project Management Team • Prepare the Outline Business Case • Project Product Description • Select the Project Approach and Assemble the Project Brief • Plan the Initiation Stage • Tailoring the SU Process Module 3: Directing a Project (DP): • Authorise Initiation • Authorise the Project • Authorise a Stage or Exception Plan • Authorise Project Closure • Give Ad Hoc Direction • Tailoring the DP Process • Theme Overview • Balance of Justification • Continued Business Justification • PRINCE2® Requirements • Contents of a Business Case • Business Case Development • Benefits Management Approach • Key Responsibilities Module 4: Initiating a Project (IP): • Agree the Tailoring Requirements • Prepare the Risk Management Approach • Prepare the Change Control Approach • Prepare the Quality Management Approach • Prepare the Communication Management Approach • Set Up the Project Controls • Create the Project Plan • Prepare the Benefits Management Approach • Assemble the Project Initiation Documentation • Tailoring the IP process Module 5: Risk Theme: • Risk Definition • Effective Risk Management • PRINCE2® Risk Requirements • Risk Management Approach • Probability/Impact Grid • Risk Register • Risk Management Procedure • Identify Step • Risk Budget • Key Responsibilities Module 6: Quality Theme: • Quality Definitions • Quality Management • Quality Planning and Control • What is Quality Assurance? • PRINCE2® Quality Requirements • PRINCE2® Quality Documentation Requirements • Quality Management Approach • Quality Audit Trail • Project Product Description • Product Description • Quality Review Technique • Quality Review Roles/Responsibilities • Quality Review Meeting • Off-Specifications and Concessions • Review Follow-Up • Quality Review Benefits • Key Responsibilities • Communication Management Approach Module 7: Plans Theme: • Dealing with the Planning Horizon • PRINCE2® Planning Requirements • Documentation Requirements • Project and Stage Plans • Team Plans and Work Packages • Plans Relationship • What is in a Plan? • PRINCE2® Approach to Plans • Designing a Plan • Delivery Approaches • Defining and Analysing the Products • Product Breakdown Structures • Product Description • Product Flow Diagram • Identify the Activities and Dependencies • Preparing Estimates • Preparing a Schedule • Documenting the Plan • Analysing Risks to a Plan • Gantt Chart and Tailoring • Key Responsibilities Module 8: Progress Theme: • Progress Definition • PRINCE2® Requirements • Progress Control • Management by Exception • Delegating Tolerances and Reporting Actual and Forecast Progress • Types of Control • Management Products and Progress Control Module 9: Change Theme: • Issue Definition • PRINCE2® Approach to Change • PRINCE2® Change Documentation • Issue Register • Change Control Approach • Change Budget • Issue and Change Control Procedure • Issue Report • Exception Report Module 10: Controlling a Stage (CS): • Activity Breakdown • Authorise a Work Package • Work Package • Review Work Package Status • Receive Completed Work Packages • Review the Management Stage Status • Report Highlights • Highlight Report • Capture and Assess Issues and Risks • Escalate Issues and Risks • Take Corrective Action • Tailoring CS Module 11: Managing Product Delivery (MP): • Accept a Work Package • Execute a Work Package • Checkpoint Report • Deliver a Work Package • Tailoring MP Module 12: Managing a Stage Boundary (SB) : • Plan the Next Management Stage • What is in a Plan? • Update the Project Plan • Update the Business Case • Report the Management Stage End • End-Stage Report • Produce an Exception Plan • Tailoring SB Module 13: Closing a Project (CP): • Prepare Planned Closure • Hand Over Products • Evaluate the Project • End Project Report • Recommend Project Closure • Tailoring CP DURATION 2 Days WHATS INCLUDED Course Material Case Study Experienced Lecturer Refreshments Certificate

Essential self-care for helping professionals New research gives us practical ways to prevent overwhelm or burnout in ourselves and others, manage workplace stress, avoid ‘compassion fatigue’ and much more… Accredited CPD Certificate: 6 hours Length: 1 day (9.15am - 4.00pm GMT) Really interesting and engaging online course with lots of tips to support ourselves and our clientsCOMPLEMENTARY THERAPIST Live Online Training – Join Emily Gajewski on Thursday 11th April 2024 to take some important time out for yourself, or to help those you support. Once you’ve booked your place we will email you confirmation and you will receive details of how to join the Zoom workshop the day before the event. Bonus Recording – the training is recorded, in case anyone experiences technical difficulties on the day, so you will also get a recording for a limited time afterwards to maximise your learning. Can’t make this date? Then please register your interest below – and we’ll email you when a new date is available. To help others effectively, we need to have enough ‘spare capacity’, which means looking after our own wellbeing too – new research shows us how… Why you should take this course When our day-to-day jobs involve continually listening to other people’s emotional difficulties, how do we avoid being overwhelmed by them ourselves or succumbing to compassion fatigue? We are the ‘tool’ of our trade. It could be argued that we have a duty to those we work with to prioritise our own mental health and wellbeing so that we can give them the best possible service. This live online training events shows you how. ‘Burnout’ is commonly defined as a physical and emotional state caused by excessive or overwhelming workplace stress. This is often specifically related to work but of course feelings of burnout can be impacted or compounded by other life events and caring roles too. Even if we know good stress management techniques, this often isn’t enough. Burnout is a very common phenomena in the ‘helping professions’, A 2018 research review paper published in the Journal of Clinical Psychology analysed 30 years of research on this topic, involving 9,000 psychotherapists. Over half of the therapists they sampled reported “moderate-high levels of stress and burnout”. The good news is that burnout, overwhelm and empathy fatigue are not a given of working in roles where we are consistently exposed to others’ emotional pain. New research and insights into ‘buffering’ the impact of this work mean that we can consciously choose to put in safeguards to our own mental wellbeing, whilst also remaining connected and present with our clients. Emily Gajewski’s online course draws on her extensive experience of working as a therapist and clinical supervisor, in the NHS and privately, for over 20 years. Throughout the day she examines the many ways working in the caring professions can impact us personally and gives you a wealth of practical steps you can take to mitigate them. She also covers the most up-to-date guidance on keeping ourselves well and thriving in caring roles and will help you develop a realistic plan for your own continuing wellbeing. Excellent online training…. very insightful and thought provokingHILARY KEARNS, ACUPUNCTURIST What you will learn The latest research on how to prevent burnout in your working life How to identify burnout in ourselves and others – the warning signs you need to look out for Easy, practical steps to protect yourself in stressful work situations How to avoid ‘compassion fatigue’ Evidence based ‘top tips’ for optimal working practices to maintain your own wellbeing The Cycle of Stress – how to ‘work with it’ for optimal health An understanding of vicarious trauma – and how to avoid it Techniques to calm yourself in client sessions when you are ‘triggered’ by something they bring up Understanding the difference between compassion fatigue and empathy fatigue Reducing your own risk of depression when you’re worried about your clients The joy of creating ‘flow’ in our working life Constructive ways to manage difficult feelings that arise as a result of your work Practical techniques for grounding and ‘letting go’ of clients How to safely explore our own areas of vulnerability Useful tips for ongoing stress management What you need to maintain your own mental health How to re-ground yourself if you’re feeling overwhelmed or derailed by a client An opportunity for you to reflect on your own practice and wellbeing, take some time to step back, learn what works for you and how you can create more spare capacity Time to relax, try out techniques and refresh your tools to support your wellbeing and build resilience How to utilise what you’ve learnt to create your own realistic wellbeing plan. Very useful and practical. The term ‘burnout’ is become as over-used as ‘wellbeing’ and ‘stress’. This online course provides clarity on what the term ‘burnout’ means in reality ... with strategies to counter the effectsHEADTEACHER SUPPORT SERVICE COUNSELLOR Course Programme The ‘How to avoid burnout’ live online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding Burnout and how to halt the journey towards it 11.00am Comfort break and discussion 11.30am Exploring practical self-care steps that can work for YOU! 1.00pm Lunch break 1.45pm How to manage difficult feelings that arise as a result of our work 2.45pm Comfort break and discussion 3.00pm Creating a plan for your own wellbeing 4.00pm Day ends Who this workshop is suitable for Anyone who works within a role that involves caring for others – including: medical professionals – including GPs and nurses health and social care professionals therapists and mental health workers counsellors educators, teachers professional carers (foster carers and non-paid carers) social workers occupational therapists outreach workers volunteers holistic practitioners etc. 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.

Microsoft Excel® in Depth The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

This practical workshop covers the unique challenges of working with complex trauma cases and gives you clear guidance on the most effective ways to help Accredited CPD: 6 hours Length: 1 day (9.30am - 4.00pm) Absolutely jam-packed with techniques/information and resources. Ros is superlative. A calm, confident and articulate trainer...J YAP, THERAPIST Why take this course Clients suffering from Complex PTSD (C-PTSD) or who have experienced trauma in a shutdown or dissociative state, can present unique challenges to practitioners working with them – but with the right knowledge and skills we can help sufferers move forward in their lives. In this hands-on, experiential workshop you will learn more about what makes trauma ‘complex’, why shutdown or dissociation are often experienced by sufferers, and how to best work with such presentations using the Human Givens framework of understanding. You will also have the chance to collaborate with other experienced practitioners and clinicians during exercises designed to further your understanding, add to your existing skillsets, and bring wider context to an often-misunderstood area of work. During this intensive day of live, in-person training, experienced psychotherapist Ros Townsend will introduce you to a framework within which you can set your understanding of complex trauma presentations and discover the opportunities that we have to help clients move forward from their difficulties. You will learn more about the neurobiology of the automatic survival options that we have available to us, especially dissociative and ‘shutdown’ states, and leave with an understanding of how to use this knowledge to inform your work, giving you greater confidence to work creatively and flexibly with such presentations. From understanding the symptoms that are now recognised as distinguishing C-PTSD, to adapting existing HG techniques and strategies and introducing new tools and skills, this course will explore how we, as clinicians, can approach such complex presentations without getting lost in the complexity ourselves. Using case histories and discussion you will have the chance to understand more about the unique challenges that such work presents and to leave feeling more confident in your ability as a therapist to work effectively and contextually with these. Such a thought-provoking and informative day. Complex PTSD is a real buzz word at present, this took the mystery out of it in a clear and understandable way – highly recommend...MELISSA DERRICOURT What will you learn What Complex PTSD (C-PTSD) is What other symptoms a client may present with in addition to those meeting the criteria for ‘classic’ PTSD How to effectively work with these within the Human Givens framework of understanding Vital tools for psycho-education – both adding to your own understanding and to pass on to clients Why individuals enter into a dissociative or ‘shutdown’ state The difference between ‘freeze’ and ‘shutdown’ Why anger can present when an individual comes out of a ‘shutdown’ state How to help a client deal effectively with anger if it does arise The crucial role of the pattern-matching processes in the brain in post-traumatic stress symptoms – and how the kinds of templates stored can subtly differ in more complex trauma How to adapt existing techniques – such as rewind and deconditioning molar memories – to work creatively with such presentations The Dos and Don’ts when working with Guided Imagery in complex presentations How to refine your Guided Imagery skillset to powerfully benefit clients who have experienced trauma in a shutdown state Why any work that we do must be informed by the innate ability we all have to recover from trauma How to avoid negatively reframing trauma and making symptoms worse The most effective ways to help clients towards recovery and post-traumatic growth Under careful guidance from the tutor, you will: Explore and discuss the different survival options available to us as humans in traumatic situations Learn more about the neurobiology of these states – including our passive survival responses Develop a new framework of understanding within which to set your work with all kinds of trauma Understand more about why ‘shutdown’ or ‘dissociation’ are often associated with complex presentations Understand why addictions and self-harming behaviours are often a part of the picture Work collaboratively with peers and colleagues to extend and develop your own skillsets and knowledge Explore how guided imagery can be adapted and used to most powerfully benefit clients suffering in this way You will leave with: The confidence to work creatively and flexibly with a wider range of presentations A clear understanding of a framework within which you can work and continue to develop and adapt your tools and skillsets An appreciation of the importance of taking your time with such work and proceeding at a pace right for each individual client An understanding of how to support clients in moving forward from the use of faulty coping strategies – such as addiction and self-harm Greater confidence in creating metaphors that work powerfully for clients An understanding of how helping a client to meet their emotional needs is particularly key to recovery in the most complex cases Throughout the day there will be plenty of opportunity for you to ask questions and to engage in collaborative work and discussion with the tutor and with experienced colleagues and practitioners. Important note Working with Complex PTSD requires specific skills and experience and thus is only suitable for practitioners either already working in this area and looking to extend their skillset or those who are already practicing as therapists and wish to begin working in this area. If you are an experienced practitioner from another modality, we recommend you familiarise yourself a little with the HG approach before you attend, see: About HG therapy, benefits of the approach, and what is RIGAAR. Who is this course suitable for? Any qualified therapist working with distressed or traumatised people. In order to take full benefit from the course, you will ideally have already taken our Guided Imagery and Visualisation for therapeutic change and Rewind Technique workshops. NB If you are an experienced practitioner from another modality, we recommend you familiarise yourself a little with the HG approach before you attend, see: About HG therapy, benefits of the approach, and what is RIGAAR. Any qualified practitioner in the field of psychiatry, psychology, psychotherapy or counselling can attend; again you would benefit most by having previously attended our Guided Imagery and Visualisation and Rewind Technique workshops and familiarising yourself a little with the HG approach to therapy. Course Programme This intense 1-day training proceeds through a blend of talks, skill-developing exercises, discussions and deconstruction of real-life case-studies. There is also plenty of opportunity for networking and discussion during the breaks. The training runs from 9.30am–4.00pm. From 8.30am Registration (Tea and coffee served until 9.25am) 9.30am What is complex trauma? A framework for understanding 11.00am Discussion over tea/coffee 11.30am Adapting our toolkit: working creatively with complex presentations 1.00pm Lunch (included) 1.45pm Self-efficacy: supporting a client to become an active agent in life 2.45pm Discussion over tea/coffee 3.00pm Reframing: adding context in complex cases 3.30pm Serving clients well 4.00pm Day ends 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.

Microsoft Excel® in Depth (In-Person) This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses.This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables

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.

FourSquare Training specialise in private, corporate Power Automate courses delivered at your premises and tailored to your needs.