594 Courses in London

Database Design and Data Normalization Course Summary Relational Databases & Data Normalisation Overview Training Courses London. Learn how to decide which tables and columns are required for a database, plan relationships, how to decide on data types and how to relate tables. Database Design and Data Normalization Course Description Session 1: Introduction to Relational Databases The Database Approach Database Management Systems The function of a Database Management System The Processing Architecture The Schema Architecture The Storage Architecture An overview of Database System Development An overview of general database principles Session 2: Conceptual Data Models Overview of Entity Models Entities and how to identify them Attributes and how to identify them Relationships and their qualities Building an Entity Relationship Diagram Resolving many-to-many relationships Sub-type and Super-type Relationships Arc Relationships Recursive Relationships Constraints and Assumptions Normalization to the First Normal Form (1NF) Normalization to the Second Normal Form (2NF) Normalization to the Third Normal Form (3NF) Exercises: Analyzing a specification Creating an Entity Relationship Diagram from it Session 3: The Relational Model Relational Structure Relational Terminology Domains A Relational schema Candidate keys and Primary Keys Foreign Keys Key Constraints Attribute Constraints Implementing Sub-type/Super-type Relationships Views Denormalization using Pre-joined Tables Denormalization using Derived Data An Introduction to Structured Query Language (SQL) Simple Queries Simple Updates of the Data Included in the Database Design and Data Normalization Courses: Database Design and Data Normalization Course Certificate on completion Database Design and Data Normalization Course Manual Practical Database Design and Data Normalization Course exercises, Database Course Homework / Database Course Revision work After the course, 1 free session for questions online Database Course via Gotomeeting.com. Max group size, online and in classroom, on this Database Course is 4.

Developing a network of MHFA Champions is a key step in creating a mentally healthy workplace. The MHFA Champion one-day course will give you all the skills you need to be an MHFA Champion. This one-day course trains you as an MHFA Champion, giving you: An understanding of common mental health issues Knowledge and confidence to advocate for mental health awareness Ability to spot signs of mental ill-health Skills to support positive wellbeing 1 Introduction to MHFA and understanding mental health (3 hours 30 mins) About Mental Health First Aid About mental health and stress in the workplace Stigma and discrimination Depression Anxiety disorders Other mental health issues (eating disorders, self-harm, psychosis) Early warning signs of mental ill-health Alcohol, drugs and mental health 2 MHFA Champion in practice (3 hours 30 mins) Applying the Mental Health First Aid action plan Action 1: Approach the person, assess and assist with any crisis Suicide Action 2: Listen and communicate non-judgementally Action 3: Give support and information Action 4: Encourage the person to get appropriate professional help Action 5: Encourage other supports Recovery Building a mentally healthy workplace Action planning for using MHFA

Why choose Vectorworks Garden Design Training Course? Vectorworks, a user-friendly industry-standard software, is perfect for interior design, architectural planning, 3D modeling, and landscaping projects. Its versatility makes it suitable for both home enthusiasts and professionals. Course Info Scheduling: 1-on-1 training, your schedule. Book any hour, Mon to Sat, 9 am - 7 pm. Call 02077202581 to reserve. Duration: 16 hours. Method: In-person face-to-face sessions and live online instruction. Vectorworks Garden Design Training Course: Master the art of garden design with Vectorworks software in our specialized training program. Led by certified tutors and industry experts, this course equips you with comprehensive skills and techniques tailored to garden design. Create stunning 2D layouts and 3D landscapes, visualize designs, and produce professional documentation for your projects. Benefits: In-Person and Live Online Options: Choose between in-person or live online sessions for flexible learning. Certified Tutors and Experts: Learn from experienced tutors passionate about garden design. Comprehensive Curriculum: Cover essential aspects of garden design using Vectorworks. Lesson Recordings: Access valuable session recordings for review and reinforcement. Lifetime Email Support: Receive ongoing assistance from industry experts for continuous growth. Course Duration: 16 hours Course Description: This advanced Vectorworks course is tailored for individuals who already possess basic knowledge of the software and wish to enhance their skills to become proficient users. Participants will learn more advanced 2D and 3D techniques, including advanced 3D modeling, rendering, visualization, and customizing Vectorworks to suit their specific needs and workflows. The course will cover topics such as creating custom tools, working with planting plans, and integrating with AutoCAD. Course Outline: Module 1: Vectorworks Interface and Basic Concepts - Understanding the Vectorworks interface and palettes - Opening, saving, and managing files - Creating and editing objects and shapes - Utilizing Undo/Redo and Snaps for precision - Applying graphic attributes and working with dimensions Module 2: Modeling and Drawing Techniques - Exploring advanced tools and commands in detail - Integrating with AutoCAD and data exchange - Creating, modifying, and editing text - Utilizing callout text tool for annotations - Organizing information using design layers and classes Module 3: Working with Buildings and Models - Utilizing design layers and sheet layers for architectural projects - Assigning objects to layers and classes - Working with viewports and sheet layers for presentation - Drawing buildings, including walls and roofs - Setting up and rendering perspective views Module 4: Creating Site and Landscape Plans - Importing land surveys or architects' files - Drawing site surveys and working with hard landscape elements - Adding and customizing plantings using the plant tool - Editing plant definitions and creating custom plant symbols - Generating plant schedules and reports Module 5: Vectorworks Architect Features - Setting up files and scaling the drawing - Customizing text styles and dimension standards - Working with scanned images and creating site models - Designing floors, doors, and windows using standard Vectorworks elements - Creating and managing title blocks, labels, notes, and keynotes Module 6: Working Drawings and Final Project - Developing the final project with 2D and 3D elements - Applying site modifiers and stairs to the design - Generating printing layouts for presentations - Creating working drawings with detailed plans and elevations Download Vectorworks Trial https://www.vectorworks.net/trial Proficiently use Vectorworks software for garden design, including creating accurate site plans and garden layouts. Apply 2D and 3D modeling techniques to visualize garden designs and present them professionally. Incorporate plants, hardscape elements, and other design elements into garden layouts effectively. Generate detailed construction drawings for seamless implementation of garden projects. Understand the key features and functionalities of Vectorworks specific to garden design. Demonstrate proficiency in utilizing Vectorworks tools for various garden design tasks. Interact collaboratively in face-to-face or online learning environments, engaging with instructors and peers. Utilize lesson recordings to review and reinforce course concepts for continuous learning. Seek personalized guidance and assistance through lifetime email support from certified tutors and industry experts. Transform creative garden design ideas into practical and stunning real-world projects using Vectorworks software.

This one-day workshop focuses on building a professional presentation from scratch, giving you essential hints and tips on how to utilise the key features of PowerPoint, including speaker notes, inserting charts, diagrams and pictures, and utilising slide transitions and animation. You will also learn about PowerPoint templates and themes to ensure your presentations have the best impact. This course will help participants: Using Slide Master Create a presentation using a template Insert slides and change the layout Manage slides and control formats Enhance slides using animation, pictures, charts and graphics Work with tables, rows, cells and columns Create and control paragraph lists Insert titles and labels Effectively use slide show controls and presenter view Print slides, handouts and notes 1 Introduction to PowerPoint Navigating the features Creating a simple presentation Inserting new slides and changing layouts Creating speaker notes 2 Using Layouts in Slide Master Editing templates in slide master Adding a design theme Adding transitions, pictures and logos Using Slide Show View 3 Drawing shapes and SmartArt Using Drawing Tool Formats Creating shapes Aligning shapes and stacking order Creating a cycle graphic Creating an organisation chart 4 Animation Visually enhancing slides with animation Using text and object animation Adding animation to lists Making animation work for you 5 Presenting Confidently running a presentation Using presenter view Using the slide show controls

This workshop-based bite-size will provide space to explore some practical tools and ideas on how to be more resilient when faced with challenging and tough situations. There is an opportunity to do a self assessment and bring it to the day as a means to identify areas to work on and begin to master skills that will enhance resilient thinking. There will be time to explore what resilience is and understand the range of practical tools and techniques available that can be used beyond the workshop itself. By the end of the workshop participants will be able to: Discuss and evaluate their personal strengths and areas for development in being more resilient at work Understand what resilience involves and how to identify and challenge their own beliefs that undermine resilience Understand the four aspects of resilience - confidence, adaptability, building support and maintaining a clear perspective Understand how to use resiliency tools to help to cope better with the challenge of change Review and evaluate their learning and have an action plan to take back and implement in the workplace 1 Welcome, introductions and objectives Breaking the ice 2 Identifying current challenges in relation to work How we handle these challenges 3 Defining resilience and how and why it helps our personal effectiveness and thinking 4 Resilience skills and how to develop them 5 Learning a resilience tool that promotes new ways of thinking / working 6 Review and evaluation of learning Action planning

Self-understanding is a prerequisite for leading and managing others responsibly and honourably. The field of Neuro Linguistic Programming has helped us to gain a better insight into how we all think and behave. Upon completion of this course participants will be able to: Gain an insight into the purpose and functions of the unconscious mind Develop flexibility to increase their for behaviours in different circumstances Appreciate how different people experience the world Create and set effective goals and direction Understand the NLP Model of Communication Adapt their communication style to maximise effectiveness Influence and persuade others by connecting with people Understand how empowerment can make life easier Appreciate how creativity works Learn creativity techniques to tap into the power of the team 1 Self-awareness Autopilot - your unconscious mind Developing flexibility How identify, values & beliefs shape our behaviour Models of the world 2 Creating direction Describing present and desired state Designing your direction Making it happen Self-mastery 3 Communication The NLP Model of Communication Insights to the way people think Understanding representation systems Reframing the way people think about negative experiences Using metaphor 4 Influence and persuasion Building trust Connecting with people Purpose intention and outcomes The difference empowerment makes 5 Creativity and innovation Hindrances to creativity and innovation Your natural state of creativity Getting unblocked Creativity techniques 6 Action plan Course summary and presentation of action plans

Conflict within a workplace can appear in many forms, from personality conflicts between employees to employee and supervisor issues. This course will equip you with the knowledge of conflict management strategies and the practical skills to take steps to help to resolve situations of conflict.

Supporting Women in Leadership Throughout The UK Our women in leadership course is specifically designed to target challenges and support women in developing their leadership and management careers. AWARD WINNING LEADERSHIP DEVELOPMENT PROGRAMME Discover Our Women in Construction Management Course The Power Within is dedicated to helping women in construction across England and Scotland achieve business success through our Motivational Intelligence framework. Motivational Intelligence is the third level of intelligence, and the science behind it has won a Nobel Prize. Our women leadership in construction course supports women by improving their motivation, self-belief, decision-making, and leadership skills. This programme is designed to help female business leaders adapt more quickly to their environment, handle adversity more effectively, take productive action, and thrive during times of change. Each is a vital skill needed in today’s ever-changing business environment. When completed, you’ll have the skills needed to make decisions more effectively that help your business grow, become more resilient, and take opportunities when others are stuck. "This course has completely changed my outlook on my responsibilities as a manager/leader. In 26 years with Pfizer, I have never participated in a programme that has as profoundly changed my perspective on my role, my responsibilities and my ability to positively impact my team." FEMALE DIRECTOR OF BUSINESS SERVICES, PFIZER LEADING WITH MOTIVATIONAL INTELLIGENCE What is our Women in Construction Course? In the past five years, we’ve supported thousands of business leaders and managers in nurturing the skills and mindset needed to achieve and exceed their business goals. The Power Within knows women are incredibly effective and consistent at applying our Motivational Intelligence techniques to their lives and business. Our women in construction management course is designed to give you the skills you need to take charge of your business and ensure constant growth while future-proofing your business. The training is perfect for women in construction who are managers or leaders looking to: Quickly Adapt Their Team to Change Effectively Mentor Every Team Member Improve Communication and Collaboration Gain More Buy-In to New Goals or Strategies Transform Their Team Culture Increase Initiative and Self-Motivation Across Their Team How We Help Women in the Construction Industry Our course focuses on imparting fundamental skills, tactical best practices, and powerful insights into the human side of the business. You’ll be provided with valuable knowledge needed to be successful leaders and managers of all levels. We’ll focus on addressing the challenges new businesses around the world face, like leading teams and developing businesses in turbulent and transitional times as well as overcoming the challenges of being women in the construction industry. Throughout the course, particular emphasis is given to helping leaders raise motivational intelligence and foster a growth mindset within their team. LEADING WITH MOTIVATIONAL INTELLIGENCE Our Leading with Motivational Intelligence (MQ) Executive Diploma Programme is specifically designed to help participants create the “complete game” of leadership and management. Leveraged by more than 40% of the largest Fortune 500 companies and implemented around the world, the Leading with Motivational Intelligence (MQ) consistently receives a participant buy-in rate in excess of 97%. However, the most important statistic is: 12 months after completing the course more than 93% of participants continue to use the skills and techniques taught on a daily basis. SQA APPROVED EXECUTIVE DIPLOMA What Skills Do We Help Women in Construction Develop? The skills we teach through our women in construction management courses are delivered through seven modularised sessions, each between three and three-and-a-half hours per session, with all sessions starting at 9:30 am via Zoom. An additional two hours per week is spent working on the online training assignments and leadership development plan. Each session will provide the education and information needed to establish yourself in your business. Here is more information regarding each session and the skills taught: SESSION 1: SELF-LEADERSHIP & THE SECRET TO PERSONAL SUCCESS Our first module is focused on setting course expectations and creating the right environment for learning. We’ll introduce the format and logistics, then discuss leading through turbulent times and how we can take control of ourselves, our thoughts, and our actions to lead growth. There is also a discussion on adult learning techniques and how leaders can leverage them to improve the effectiveness of their teams. We’ll also explore how turbulence and transition have changed how we manage and lead our teams. SESSION 2: THE ROLE OF INTELLIGENCE WHEN LEADING In this session, we’ll discuss the three levels of human intelligence and show how they each play in an individual’s performance and behaviors. Through two distinct mindsets, you’ll be shown how an individual’s motivational intelligence ultimately influences their emotional intelligence and intelligence quotient (IQ). Depending on which mindset a person operates under ultimately dictates their view of themselves, opportunities, and the work at which they will allow themselves to succeed. Finally, we’ll discuss switching your team to a growth mindset. SESSION 3: THE PILLARS OF HUMAN PERFORMANCE Completing this session will allow you to deconstruct the components that create a motivational intelligence growth mindset. Through discussion, you’ll see how most organizational challenges can be directly tied back to lapses in these components. We’ll review the leaders who’ve had the most significant influence on the meeting participants and shows the commonalities that make these leaders stand out. Lastly, we’ll introduce terminology, tools, and techniques that leaders can leverage to better coach and mentor their team. SESSION 4: MANAGEMENT VERSUS LEADERSHIP: THE TWO CRITICAL AND CO-DEPENDENT SKILLSETS FOR CREATING TEAM SUCCESS We’ll discuss the difference between a manager’s and a leader’s focus. The discussion focuses on the two most common management mistakes and how they undermine team culture and individual performance. The final debate focuses on the five critical best practices of excellent management, including clearly defining and communicating goals, creating alignment and buy-in, setting proper expectations, monitoring performance, and recognizing and rewarding performance. Our final portion will work to define what management is. Session 5: Exploring and Defining Leadership: Dispelling the Myths that Surround It Session 5 strives to define leadership. Building on this definition is a follow-up discussion regarding how people develop their leadership abilities. We’ll explore the underpinnings of what creates a successful leader. It also includes the importance of asking questions and active listening. We’ll review the five behavioral characteristics associated with motivational intelligence and how leaders can assess the relative strengths or weaknesses of the characteristics within their team. Lastly, we’ll explore great leaders’ five critical best practices, including communicating a compelling vision, modeling the correct behaviors, establishing a team culture anchored in responsibility, consistently building team confidence and self-esteem, and proactively coaching and mentoring. SESSION 6: BUILDING A LEADERSHIP TOOLBOX FOSTERING ADAPTABILITY, RESILIENCE, AND COURAGE We’ll provide information regarding tools and techniques that leaders can utilize to foster greater accountability and ownership win their teams. The Power Within will explore self-esteem’s critical role in the relative strength or weakness of a person’s motivational intelligence and adaptability in life. We’ll discuss how self-esteem has formed and how it will influence how a person interprets feedback in life. Lastly, we’ll explore levels of self-esteem and the associated behaviors of each. SESSION 7: HELPING EMPLOYEES DEVELOP A HEALTHY PERSPECTIVE AND RESILIENT ATTITUDE During the final session, we’ll explore self-esteem’s critical role in the relative strength or weakness of a person’s motivational intelligence and adaptability in life. We’ll talk about how self-esteem is formed and how it influences how a person interprets feedback. Finally, we’ll explore levels of self-esteem and the behaviors of each and the influence of comfort zones, and the tools that leaders can use to help people escape the fear of change. Our Course Leaders The Power Within was founded by husband and wife team James and Enas Fleming, to inspire people worldwide to think bigger, be better, and achieve more. They both work on a personal level with individuals, businesses, and organisations to help them create leaders and build environments where they can thrive. James and Enas challenge the limits with the Motivational Intelligence formula to help you broaden your perspective and create a future on your terms. Here is more about your course instructors: James Fleming James Fleming – James Fleming, the co-creator of The Power Within. He wanted to inspire people around the world to think better, be better, and achieve more. James believes everyone can do whatever they set their minds to. Founding The Power Within allowed James to turn that deep knowledge into a business that helps others think bigger, better, and achieve more daily. He strives to give leaders the tools and knowledge to achieve their full potential while increasing their self-confidence and self-belief through the Motivational Intelligence Revolution. James wants to support today’s businesses to become tomorrow’s leaders. Mari Steyn Mari is the go-to person for building self-esteem, offering new perspectives and stepping up in Life. With an endless abundance of excitement and love for all people, combined with degrees in Psychology, Knowledge and Information Management and is a Master NLP and Transformation Coach and International NLP and Coaching Trainer and Executive Coach, Mari offers an attractive, fresh, expert approach to Emotional Freedom, Motivational Intelligence, Leadership Development and ReWriting your Story. We undoubtedly have the power within to alchemize ourselves and any situation! Seeing the light go on in someone’s eyes is my ultimate joy. Take Charge with Our Women in Construction Course The Power Within is a Motivational Intelligence company dedicated to helping businesses and leaders become more accountable, resilient, adaptable, and capable of handling all challenges, regardless of the complexity. Our women in construction management course build upon best practices, strategic insights, and lessons learned over three decades of building leadership universities for Fortune 500 companies. Throughout the course, emphasis is given to helping leaders raise their motivational intelligence and foster a growth mindset within their team. You’ll gain the skills you need to successfully lead your team and overcome adversity while ensuring your company is profitable. To learn more about our course or to register, reach out today.

This ilm recognised programme builds on the coaching fundamentals to focus on enhancing the coach’s self-awareness and coaching techniques, refining both practice and skill to develop a coaching style of leadership.

We invite adults, children, complete beginners, and advanced pianists alike to join us at our studio on Baker Street for the finest and most comprehensive piano lessons London has to offer, thanks to a wonderful team of piano instructors. Please contact us for in-person or online lesson availability.