1147 Power courses in Cardiff delivered Live Online

An exciting 10-week course to build your Spanish skills from scratch. Practical applications for travel & conversation. Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

Duration 1 Days 6 CPD hours This course is intended for To ensure success, students should have completed Excel Essentials and Excel Functions Including Pivot Tables and Lookups or have the equivalent knowledge and experience. Overview Upon successful completion of this course, students will be able to enhance productivity and efficiency by streamlining workflow, collaborate with others, and audit and analyse data. This course is designed for students desiring to gain skills necessary to create macros, collaborate with others, audit and analyse data, incorporate multiple data sources, and import data. Working with Multiple Worksheets and Workbooks Working with Named Ranges Link Cells Across Worksheets and Workbooks Use 3D References to Calculate Across Worksheets Consolidate Data Use Formula Auditing and Error Checking Reveal Formulas Trace Cell Precedents and Dependents Locate Errors in Formulas Watch and Evaluate Formulas Reviewing and Protecting Workbooks Control Data Entry via Data Validation Protect Workbook Access Protect Worksheets and Cell Content Add and Edit Comments Prepare a Workbook for Distribution Modify Excel's Default Settings Using Macros to Automate Workbook Functionality Create Macros via Recording Run Macros via Buttons and Shortcuts Assign Macros to the Quick Access Toolbar and Ribbon Assign Macros to Objects View Macro Code Forecasting and Analysis Data Use Conditional Formatting to Highlight, Sort and Filter Key Data Advanced Conditional Formatting using Formulas Create Sparklines to Visualise Data Add Trendlines to Charts to Visualise and Forecast Trends Use Data Tables and Scenarios to Project Potential Outcomes Use Goal Seek to Calculate Outcomes Forecast Data Trends Using Solver

Read and discuss these two gripping stories of race, identity and sexuality Highlights Join this book club and gain extra motivation to read in English 7 hours of live classes to help you develop fluent speaking in English Read and discuss these important novels about race, identity and sexuality Be corrected by an expert English teacher to remove errors and mistakes Practise and develop your English online in this advanced course featuring Passing (1928) and Giovanni's Room (1956). Each week you read some chapters, discuss them in class and improve specific areas of vocabulary or grammar while also examining literary aspects of the novel. Personalised feedback improves your grammar, vocabulary and pronunciation. The Book Club books Passing by Nella Larsen: Clare Kendry "passes" as a white woman. She is married to a white man who is unaware of her African-American heritage. On meeting her childhood friend Irene, both women examine and reassess their marriages, confronting their past lies & fears for the future. Nella Larsen's intense, gripping story & insight into identity established her as a key author of America's Harlem Renaissance. Giovanni's Room by James Baldwin: David, a young American in 1950s Paris, plans to get married. However, while waiting for his fiancée to return from holiday, he meets Giovanni, a handsome Italian barman, starting a passionate affair. Tortured by his sexual identity, he has to decide who he is and who to spend his life with. 'Audacious... remarkable... elegant and courageous' Caryl Phillips 'Gorgeous, fearless, tempered by dark knowledge and pain ... the greatest American prose stylist of his generation' Colm Tóibín Geoff says: "These two short novels are both important contributions to literature by black writers. Passing (1929) established Nella Larson as one of the most important black female novelists in American history. Recently made into a Netflix film, Passing is the second and last of Larson's novels, and considered a classic work. She was a pioneer in writing about sexuality, race and the secret suffering of women. James Baldwin's powerful and controversial second novel is his most sustained treatment of sexuality, and a classic of gay literature."

Help with chronic pain – learn the powerful psychological and behavioural techniques that alleviate persistent pain and accelerate healing with pain specialist Dr Grahame Brown Accredited CPD Certificate: 6 hours Length: 1 day (9.30am - 4.00pm GMT) Fantastic to have the opportunity to train with this specialist. Thoroughly enjoyed this online course – the best I have attended...CLINCIAL HYPNOTHERAPIST Live online training – Join Dr Grahame Brown on Wednesday 24th April 2024 for this practical live online training event via Zoom, you will have plenty of opportunities to ask questions. Simply book your place and we will email you the Zoom link 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?  Register your interest and we’ll let you know when there’s another. Why you should attend Pain is endemic in our society and whatever the cause – back pain, migraine, arthritic pain, dental pain, irritable bowel (IBS), labour/menstrual pain, cancer pain, psychogenic pain, psychosomatic pain – it can be incapacitating. Chronic pain is any pain which lasts for more than three months and it is estimated that between 25–40% of our population suffer from persistent or chronic pain. The sociological and economic costs of this are enormous but it is in the personal human suffering involved – mental as well as physical – that the real costs should be measured. Many are desperate for effective help to relieve their pain and the associated effects, such as insomnia and depression. This online workshop – with leading pain and musculoskeletal medicine consultant Dr Grahame Brown – gives you important new information about how we experience pain – derived from the latest neuroscience – and a powerful range of psychological techniques for managing pain naturally, preventing it from escalating and speeding up healing. You will discover how people can be helped out of the vicious cycle of chronic pain and how, by working holistically through the bio-psycho-social model, suffering can be dramatically reduced. You don’t need to have any prior medical knowledge to learn from and enjoy the day – you will leave with a much clearer understanding of what is going on in the mind/body system, what you can do to reduce suffering when pain persists and ways to prevent chronic ongoing pain from developing. It is a key event if you work with people suffering from pain at any stage (from recent onset, recurrent to persistent) or if you would like to find out how to successfully manage pain without medication. You will learn a wide variety of pain management techniques, which can easily be integrated into your work, to help relieve pain and promote recovery – often in just one session. Dr Grahame Brown has a real gift for helping people heal themselves – I know: I’m one of them!CHRISTOPHER BUCKLEY, PROFESSOR OF RHEUMATOLOGY, UNIVERSITY OF BIRMINGHAM What will you learn An increased understanding of how we perceive pain (from the latest neuroscientific research) and what is happening in the mind/body system A road map for helping people out of the vicious cycle of chronic pain, or to stop it developing in the first place The confidence and skills to help patients suffering from persistent pain of whatever cause – no need to feel ‘heart-sink’ with some patients anymore An understanding of what is going on when pain persists – and what you can do about it How to reduce the risk of chronic pain developing – prevention is better than cure – and identify the factors that make it likely A range of psychological chronic pain management techniques to use with your patients or yourself The importance of the bio-psycho-social model in reducing pain and accelerating healing How to produce significant pain relief by changing the way people think about their pain – in minutes An understanding of the value of pain displacement and how to use the brain’s ‘reality simulator’ What the latest neuroscience tell us about the experience of pain How to use guided imagery, relaxation and distraction to promote chronic pain relief How to deal with constant pain and promote healing How healthcare professionals can make their consultations more therapeutic How to avoid labelling patients’ pain as ‘purely psychological’ The many myths about pain – and why some well-intentioned pain management techniques don’t work and more… No prior medical knowledge is needed for you to benefit from the day. Course Programme The ‘Effective Pain Management’ live online course starts at 9.15am and runs until 4.00pm. (GMT). 9.15am Join the Zoom meeting 9.30am Understanding pain 11.00am Comfort break and discussion 11.30am Assessing a person with persistent pain 1.00pm Lunch break 1.45pm Psychological & Behavioural treatment interventions 2.45pm Comfort break and discussion 3.00pm Practical demonstration of interventions 4.00pm Day ends Who is this course suitable for? This course is designed to enhance the skills and knowledge of health care professionals of any discipline who work on a regular or occasional basis with people in pain to improve outcomes, including: • doctors • surgeons • nurses • dentists • neurologists • osteopaths • chiropractors • palliative care workers • psychiatrists • midwives • physiotherapists • occupational therapists • psychologists • health visitors • support/care workers • psychotherapists • counsellors – it is perfect CPD If you personally experience persistent pain then you will gain much from the workshop but please be aware the programme is not designed to be a treatment day and the tutor will be unable to give opinions to individuals with pain problems unless (with consent) their problem can be discussed for the benefit of all participants Anyone who would like to understand more about their own experience of pain, or that of someone they care for, and what can be done to manage ongoing pain and alleviate suffering This course has been independently assessed 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.

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to MongoDB for DBAs (TTDB4680) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Why choose SketchUp Training Course for Interior Designers and Architects? Course info During this training course, you will begin with an introduction to SketchUp, exploring its interface, fundamental concepts, including design tools, component, color and texture, and importing from 3D Warehouse related to interior design. Duration: 6 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. Advantages of SketchUp: Intuitive and Fast: Compared to other 3D modeling software, SketchUp is simple, fast, and easy to use. Quick Learning Curve: Within a few hours, users can create simple models and get started with SketchUp. Efficient Modeling: SketchUp allows for the creation of models with fewer faces, optimizing performance. Versatility: Its non-parametric modeling principle makes SketchUp suitable for various applications. Rich Component Library: Access a vast collection of free components in the 3D Warehouse. Extensive Plugins: Benefit from numerous free plugins. Interior Designers' SketchUp Training Course Course Duration: 6 hours I. Introduction to SketchUp (1 hour) Overview of SketchUp for interior design Familiarization with the interface and essential tools Navigating the 3D environment efficiently Project creation and management II. Creating Floor Plans (1 hour) Importing and drawing floor plans accurately Wall, window, and door precision Effective floor level management Organizing designs with Layers and Scenes III. Furniture and Fixtures (2 hours) Accessing 3D Warehouse for furniture and fixtures Crafting custom elements for unique designs Strategic arrangement within the space Materials and textures customization IV. Advanced Modeling (1 hour) Utilizing advanced tools for intricate 3D models Organizing models with groups and components Adding details and finishes for high-quality design V. 3D Visualization (1 hour) Creating immersive 3D models Applying textures to walls, floors, ceilings Mastering rendering for realistic presentations VI. Importing and Exporting (30 minutes) Seamless collaboration with other software File formats and compatibility understanding Preparing models for 3D printing VII. Conclusion and Next Steps (30 minutes) Comprehensive review and key takeaways Further learning resources and improvement avenues Interactive Q&A and feedback collection SketchUp - SketchUp trial https://www.sketchup.com Unlock Your Design's Full Potential With SketchUp's Powerful 3D Software. VR Model Viewing. Free Trial Available. Secure Payment Options. Types: SketchUp Go, SketchUp Pro.

Python Data Analytics with Python using Numpy, Pandas, Dataframes. Most attendees are in-work Data Professional. Private individuals are very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led

Master Plant Tinctures made by a master herbalist in Peru.

This offering is for an initial session exploring your enneagram map report , which is included. The test I use is from Aephoria, and it will give you your tritype (your strategies for thinking, feeling and doing) as well as your instinctual variant, which is helpful information about where you tend to focus your attention. Once you have your map, we will unpack the information together, and if you wish, go on to explore it over a series of sessions, using creative tools and practices to find its meaning and wisdom for you in your life.

This offering is for an initial session exploring your enneagram map report , which is included. The test I use is from Aephoria, and it will give you your tritype (your strategies for thinking, feeling and doing) as well as your instinctual variant, which is helpful information about where you tend to focus your attention. Once you have your map, we will unpack the information together, and if you wish, go on to explore it over a series of sessions, using creative tools and practices to find its meaning and wisdom for you in your life.