Name: Conflict Management 1 Day Training in Brighton
Price: 595 GBP
Availability: InStock

Burton Upon Trent

<h1 dir="ltr" id="isPasted" fr-original-style="" style="box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Course Overview:</span></h1><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">This training based on leading teams will help you to develop anyone that leads a team or is involved in a leadership role. It is also useful for those that are about to embark on a position of leadership or need to develop their leadership skills.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Contents:</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Having an effective team around you is crucial. However, it is an area that is often left to chance, which can lead to de-motivated individuals that do not feel part of the business and consequently do not perform. This course looks at what it takes to lead an effective team and how you can get the best out of the people in it by understanding the role of the leader, both personally and from the point of view of the team.</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Topics:</strong></span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Qualities of an Effective Leader</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Identifying the key characteristics of effective leaders, rating themselves against them and establishing key actions to develop the skills.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Leader or Manager?</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Establishing the difference between the two and comparing themselves to those qualities.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">That Vision Thing</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Making the business vision &lsquo;live&rsquo; for the team by answering key questions.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Developing Your Team Goals</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Reviewing an action plan that develops clear goals for their team based on the business vision.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Motivation</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Determining the &lsquo;Why&rsquo; for their staff and developing an understanding of emotions in a business context.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What Motivates?</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Looking at specific motivators for individuals and understanding that everyone is motivated by different things.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Being Consistently Different</strong>&nbsp;</span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&ndash; Going against popular leadership theory and identifying that each staff member needs to be treated differently.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dealing With Difficult Team Members</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Understanding why team members are difficult. Looking at different behavior types and strategies for responding to them. Also, realizing that &lsquo;difficult&rsquo; behavior sometimes has its benefits.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Using a simple method of coaching, including action plans.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Three Key Skills of Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Looking at the skills required to be an effective coach.</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Instant Results Coaching</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Coaching in a hurry!</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Can Do Coaching Practice</strong></span><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">&nbsp;&ndash; Putting the learning into practice</span></p></li></ul><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Feature:</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">By the end of this training you will be able to:</span></p><ul fr-original-style="" style="box-sizing: border-box;"><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the qualities of an effective leader</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Benchmark themselves against those qualities and develop actions to improve</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the difference between leading and managing</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Explain the value of sharing the business vision with the team</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Develop team goals based on the business vision</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Motivate their staff by understanding their drivers and developing actions to support them</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Deal with difficult staff members</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Challenge staff in a meaningful and effective way</span></p></li><li dir="ltr" style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Coach staff effectively using a simple process</span></p></li></ul><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Certification:</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Once after the training you receive course completion certificate from Mangates</span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who can Attend?</strong></span></p><p dir="ltr" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style="color:#000000;">Anybody who is interested in learning Effective Skills to Lead a Team.</span></p>

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
Events do not just happen, they take time to plan, develop, and create. This workshop is designed to give your participants the tools needed to host a great event. They will touch on planning and administrative techniques that will give them the confidence to run an engaging event that will leave a positive and lasting impression on each attendee.
With our Event Planning workshop y,our participants will explore ways to work with vendors, security, technicians, and wait staff. They will touch on different event types such as awards ceremonies, charity events, and business conferences. By utilizing the correct skill set you will be provided the details to pull off a successful event.
Target Audience:
Anybody who is interested in learning Event Planning Skills
Learning Objectives:
By the end of the course, participants will be able to understand:
Types of Events
Brainstorming
Types of Entertainment
Support Staff
Technical Staff
Vendors
Finalize the Plan
Administrative Tasks
Get Organized
Post Event Activities
Wrapping Up
Agenda:
Module One: Types of Events
Awards
Charity
Conferences and Seminar
Holiday
Case Study
Module One: Review Questions
Module Two: Brainstorming
Determine the Event’s Purpose
Determine a Theme
Write Down & Review Ideas
Determine a Date
Case Study
Module Two: Review Questions
Module Three: Types of Entertainment
Games
Activities
Speakers
Performers
Case Study
Module Three: Review Questions
Module Four: Support Staff
Security
Valet
Wait Staff
Clean up Crew
Case Study
Module Four: Review Questions
Module Five: Technical Staff
Visual Technician (lighting)
Media Technician (website, Facebook, etc.)
Audio Technician (Sound)
Specialized Electrical Equipment Technician (for performers)
Case Study
Module Five: Review Questions
Module Six: Vendors
Food
Equipment
Decorations and Furnishing
Photography/ Video
Case Study
Module Six: Review Questions
Module Seven: Finalize the Plan
Venue
Registration
Entertainment
Cuisine and Decor
Case Study
Module Seven: Review Questions
Module Eight: Administrative Tasks
Create a Budget
Branding and Marketing
Insurance and Permits
Contracts (for event staff, entertainment, rentals, and vendors)
Case Study
Module Eight: Review Questions
Module Nine: Get Organized
Form a Team
Timeline
Checklists
Backup Plans
Case Study
Module Nine: Review Questions
Module Ten: Post Event Activities
Survey
Share Media (photos and video)
Send Thank you Notes
Start planning the Next Event!
Case Study
Module Ten: Review Questions
Module Eleven: Wrapping Up
Words From The Wise
Review Of The Parking Lot
Lessons Learned
Recommended Reading
Completion Of Action Plans And Evaluations

Mangates

Event Planning 1 Day Training in Burton Upon Trent

The Ultimate Guide to Event Planning - 1 Day Workshop in Burton Upon Trent

The sale ends 5 days before the event starts.

Early Bird Fee

The sale ends 10 days before the event starts.

Standard Fee

<h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">The popular Her Biz start-up programme returns via Zoom starting this January, with the chance to win &pound;500 towards your start-up costs!</h2><h2 id="isPasted" fr-original-style="" style="box-sizing: border-box;">Are you thinking about setting up a new business? Her Biz, the &#39;virtual&#39; Women&#39;s Start-Up programme is returning to support aspiring female entrepreneurs in East Sussex and Kent.</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Her Biz is designed specifically to encourage more women to start a business, why not, turn your idea/hobby into a reality with the chance to <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">WIN &pound;500</strong></strong>!</p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Workshop dates/times:</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">The programme consists of<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;4 x 2.5 hour&nbsp;</strong></strong>sessions, each from <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">10 am to 12:30 pm.</strong></strong></p><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Friday 17th January - Exploring your idea and shape your business plan</strong></strong></li><li value="2" fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Friday 24th January<strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></strong>- Understanding financials and funding options</strong></strong></li><li value="3" fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Friday 31st January<strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></strong></strong></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">- Marketing, social media and online presence</strong></strong></li><li value="4" fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Friday 7th February</strong></strong><strong id="isPasted" fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;</strong></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">- Practicalities of getting started</strong></strong></li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Closing date for applications is Wednesday 8th January 2025.</strong></strong></p><h2 fr-original-style="" style="box-sizing: border-box;">Her Biz: What&rsquo;s it about?</h2><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">To increase female entrepreneurship locally, we are offering women living in East Sussex and Kent a fantastic opportunity to come together to develop the knowledge, skills and confidence they need to launch a successful business.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This inspiring programme has been specifically created to help encourage women to set up a new business. From refining your business idea to marketing and managing your finances, we can help you to prepare to successfully start your business.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">That&#39;s why we also include an optional competition to give you the chance to&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">win &pound;500&nbsp;</strong></strong>towards your start-up costs. Following the course, you will have 6 weeks to submit your completed business plan to enter, and it&#39;s open to all those selected to participate on the course.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">So far, we have held over 30 successful rounds of the Her Biz programme across East Sussex and Kent over the past 5 years, each one over-subscribed, so we urge you to apply now to avoid disappointment!</p><h2 fr-original-style="" style="box-sizing: border-box;">The programme will help you to:</h2><ul fr-original-style="" style="box-sizing: border-box;"><li value="1" fr-original-style="" style="box-sizing: border-box;">Explore and clarify your business idea</li><li value="2" fr-original-style="" style="box-sizing: border-box;">Research your target market and understand your competitors</li><li value="3" fr-original-style="" style="box-sizing: border-box;">Develop your business model and kick-start your business plan</li><li value="4" fr-original-style="" style="box-sizing: border-box;">Help you to understand the numbers, create projections and explore funding options</li><li value="5" fr-original-style="" style="box-sizing: border-box;">Start shaping your marketing strategy incl. online and social media presence</li><li value="6" fr-original-style="" style="box-sizing: border-box;">Set your business goals</li><li value="7" fr-original-style="" style="box-sizing: border-box;">Overview of business types, tax and insurance, accounting software, bank accounts</li><li value="8" fr-original-style="" style="box-sizing: border-box;">Tools to help with taking the next step</li><li value="9" fr-original-style="" style="box-sizing: border-box;">Gain peer support from like-minded people</li><li value="10" fr-original-style="" style="box-sizing: border-box;">The programme also includes a 1-2-1 session our Start-Up Coach to refine your business plan or discuss your business on a deeper level.</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">These FREE sessions will take place via Zoom, you can access Zoom easily from your desktop computer, laptop, tablet or mobile phone. Join our experienced Start-Up Coaches for a series of 4 x 2.5 hour sessions starting Friday 17th January 2025.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Please note that previous participants have done so whilst caring for children and juggling other distractions. So don&#39;t let that be a barrier and if you have any specific needs or cannot attend all the sessions in your location please just drop us a line to info@ldbgroup.co.uk and we can discuss options.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Eligibility:</strong></strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Identify as female</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Living/based in East Sussex/Kent</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">Open to anyone that&#39;s not yet up and running or has registered as self-employed or a company within the last 12 months.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">We look forward to hearing from you!</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This popular programme is delivered by&nbsp;<a href="https://www.letsdobusinessgroup.co.uk/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.letsdobusinessgroup.co.uk/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Let&#39;s Do Business Group</a>&nbsp;in partnership with NatWest.</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><a href="https://letsdobusinessgroup.co.uk/privacy-policy/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://letsdobusinessgroup.co.uk/privacy-policy/" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">Please click here to see our Privacy Policy</a>. Please note that your details may be shared with NatWest who are funding this project.</p>

The popular Her Biz start-up programme returns via Zoom starting this January, with the chance to win £500 towards your start-up costs!
Are you thinking about setting up a new business? Her Biz, the 'virtual' Women's Start-Up programme is returning to support aspiring female entrepreneurs in East Sussex and Kent.
Her Biz is designed specifically to encourage more women to start a business, why not, turn your idea/hobby into a reality with the chance to WIN £500!
Workshop dates/times:
The programme consists of 4 x 2.5 hour sessions, each from 10 am to 12:30 pm.
Friday 17th January - Exploring your idea and shape your business plan
Friday 24th January - Understanding financials and funding options
Friday 31st January - Marketing, social media and online presence
Friday 7th February - Practicalities of getting started
Closing date for applications is Wednesday 8th January 2025.
All applicants will be contacted by telephone after the closing date to discuss eligibility to participate in the workshops, please note that booking onto the course does not guarantee a place on the workshop.
Her Biz: What’s it about?
To increase female entrepreneurship locally, we are offering women living in East Sussex and Kent a fantastic opportunity to come together to develop the knowledge, skills and confidence they need to launch a successful business.
This inspiring programme has been specifically created to help encourage women to set up a new business. From refining your business idea to marketing and managing your finances, we can help you to prepare to successfully start your business.
That's why we also include an optional competition to give you the chance to win £500 towards your start-up costs. Following the course, you will have 6 weeks to submit your completed business plan to enter, and it's open to all those selected to participate on the course.
So far, we have held over 30 successful rounds of the Her Biz programme across East Sussex and Kent over the past 5 years, each one over-subscribed, so we urge you to apply now to avoid disappointment!
The programme will help you to:
Explore and clarify your business idea
Research your target market and understand your competitors
Develop your business model and kick-start your business plan
Help you to understand the numbers, create projections and explore funding options
Start shaping your marketing strategy incl. online and social media presence
Set your business goals
Overview of business types, tax and insurance, accounting software, bank accounts
Tools to help with taking the next step
Gain peer support from like-minded people
The programme also includes a 1-2-1 session our Start-Up Coach to refine your business plan or discuss your business on a deeper level.
These FREE sessions will take place via Zoom, you can access Zoom easily from your desktop computer, laptop, tablet or mobile phone. Join our experienced Start-Up Coaches for a series of 4 x 2.5 hour sessions starting Friday 17th January 2025.
Please note that previous participants have done so whilst caring for children and juggling other distractions. So don't let that be a barrier and if you have any specific needs or cannot attend all the sessions in your location please just drop us a line to info@ldbgroup.co.uk and we can discuss options.
Eligibility:
Identify as female
Living/based in East Sussex/Kent
Open to anyone that's not yet up and running or has registered as self-employed or a company within the last 12 months.
We look forward to hearing from you!
This popular programme is delivered by Let's Do Business Group in partnership with NatWest.
Please click here to see our Privacy Policy. Please note that your details may be shared with NatWest who are funding this project.

Let’s Do Business Group

Are you thinking about setting up a new business? Her Biz, the 'virtual' Women's Start-Up programme is returning to support aspiring female entrepreneurs in East Sussex and Kent.

Her Biz: Free Women's Start-up Programme (Kent & E.Sussex) - Jan/Feb 2025

General Admission

Bournemouth

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session
Course Overview:
The meaning of Soft Skills can sometimes be difficult to describe. It can be that unique attribute or characteristic that facilitates great communication. It can be the special way that you show confidence in a challenging situation. The events can become more easily managed with this great workshop.
With our 10 Soft Skills You Need workshop your participants will begin to see how important it is to develop a core set of soft skills. By managing and looking at how people interact and seeing things in a new light, your participants will improve almost every aspect of their careers.
Target Audience:
Professionals who are interested in learning 10 Soft Skills.
Learning Objectives:
After completing this course, Individuals will be able to demonstrate their understanding of:
What are Soft Skills?
Effective Communication
Teamwork
Problem Solving
Time Management
Attitude and Work Ethic
Adaptability/Flexibility
Self-Confidence
Ability to Learn From Criticism
Networking
Agenda:
Module One: What are Soft Skills?
Definition of Soft Skills
Empathy and the Emotional Intelligence Quotient
Professionalism
Learned vs. Inborn Traits
Case Study
Module One: Review Questions
Module Two: Soft Skill 1: Communication
Ways We Communicate
Improving Non-Verbal Communication
Listening
Openness and Honesty
Case Study
Module Two: Review Questions
Module Three: Soft Skill 2: Teamwork
Identifying Capabilities
Get Into Your Role
Learn the Whole Process
The Power of Flow
Case Study
Module Three: Review Questions
Module Four: Soft Skill 3: Problem Solving
Define the Problem
Generate Alternative Solutions
Evaluate the Plans
Implementation and Re-evaluation
Case Study
Module Four: Review Questions
Module Five: Soft Skill 4: Time Management
The Art of Scheduling
Prioritizing
Managing Distractions
The Multitasking Myth
Case Study
Module Five: Review Questions
Module Six: Soft Skills 5 and 6: Attitude and Work Ethic
What Are You Working For?
Caring for Others vs. Self
Building Trust
Work Is Its Own Reward
Case Study
Module Six: Review Questions
Module Seven: Soft Skill 7: Adaptability/Flexibility
Getting over the Good Old Days Syndrome
Changing to Manage Process
Changing to Manage People
Showing You"'re Worth Your Weight in Adaptability
Case Study
Module Seven: Review Questions
Module Eight: Soft Skill 8: Self-Confidence
Confident Traits
Self-Questionnaire
Surefire Confidence Building Tactics
Build Up Others
Case Study
Module Eight: Review Questions
Module Nine: Soft Skill 9: Ability to Learn From Criticism
Wow, You Mean I’m Not Perfect?
Listen With An Open Mind
Analyze and Learn
Clear the Air and Don"t Hold Any Grudges
Case Study
Module Nine: Review Questions
Module Ten: Soft Skill 10: Networking
Redefining Need
Identifying Others" Interests
Reaching Out
When to Back Off
Case Study
Module Ten: Review Questions
Module Eleven: Wrapping Up
Words From The Wise
Review Of The Parking Lot
Lessons Learned
Recommended Reading
Completion Of Action Plans And Evaluations

10 Soft Skills You Need 1 Day Training in Bournemouth

Building Better Careers with Soft Skills: 1-Day Workshop in Bournemouth

Cork

10 Soft Skills You Need 1 Day Training in Cork

Building Better Careers with Soft Skills: 1-Day Workshop in Cork

Norwich

10 Soft Skills You Need 1 Day Training in Norwich

Building Better Careers with Soft Skills: 1-Day Workshop in Norwich

Heathrow

10 Soft Skills You Need 1 Day Training in Heathrow

Building Better Careers with Soft Skills: 1-Day Workshop in Heathrow

Stoke-on-Trent

10 Soft Skills You Need 1 Day Training in Stoke-on-Trent

Building Better Careers with Soft Skills: 1-Day Workshop in Stoke-on-Trent


Join our next Open Programme
This programme is designed with management success and performance in mind.  It will provide the most benefit to people who are currently employed in a management role.
The ‘Mastering Management Fundamentals Open Programme’ enables anybody, at any level of management, to reflect upon and develop their people management skill-set, in an immersive and refreshingly different development format.
Including a personality assessment, personalised report, access to a management expert, being part of a diverse cohort of managers and achieving actionable improvement.  This programme gives you the practical tools and insight to be able to make changes and directly improve your people management skills.

Covering Mastery of 5 Core Areas of Management

Personal Management
Team Management
Team Development
Performance Management
Management Communication


DCo - The Development Company UK Ltd

Managerial

Performance Management

Leadership

Team Management

People Management

Business & Management

Management Skills

The ‘Mastering Management Fundamentals Open Programme’ is a 5 module online course that is designed to improve your management success and performance. It will give you the practical tools and insight to be able to make changes and directly improve your management skills over a 5-6 month period. 

Mastering Management Fundamentals

Chorley

Certificate: Course Completion Certificate | Language: English
Duration: 1 Day | Credits: 8 PDUs
Course Delivery: Classroom | Virtual Live
Lunch and Beverages are included in a classroom session

Course Overview:
Disagreements, differences of opinion and conflicting perspectives on key issues inevitably arise in any context where people are working together.
Research has shown that workplace conflicts can become highly destructive. Negative emotions may be stirred up, poisoning team morale, creating stress and destroying relationships.
Conflict may emerge between managers and their staff, between team members or departments.
Conflict may be expressed openly, but it may also be hidden, in the form of irritation, resentment, loss of morale and lack of commitment. Hidden conflict is easy to miss and therefore can be particularly damaging.
Ultimately, this is likely to have an adverse effect on team and company performance, costing time and money.
It is therefore vital to manage conflict constructively.
As a team member and leader, your ability to deal with and resolve conflicts defines your success in the longer term.
Our one day workshop in Conflict Management and Communication Skills immerses you in the most advanced conflict management tools, strategies and practices applicable today. You will gain hands-on practice on proven frameworks, go through simulations and exercises that will train you to be a highly effective professional and leader, starting day one.
Target Audience:
Anybody who is interested in learning Conflict Management Skills

Learning Objectives:
Getting a handle on and gaining insights into your conflict management style through self-assessments (TKI®).
Role playing to practice techniques and new skills in a safe environment.
Proven best practices for approaching conflict management.
Practices for resolving conflict as a third party mediator.
Scientifically validated frameworks on effective communication in stressful situations.
Transferring your learning back to your work environment using job aids, templates and other resources.
How Will You Benefit?
Build trust and credibility with colleagues and team members
Leverage potential conflict situations as opportunities for critical conversations that enhance work relationships.
Gain confidence in holding difficult conversations calmly and assertively.
Manage difficult situations proactively.
Increase your effectiveness in managing conflict.
See growth in your overall performance
Agenda:
Science behind workplace conflicts
Understanding Human Behavior
Different Personality Types
Conflict Management Styles
Conflict Management Strategies
Workplace Conflicts
Conflict Resolution Agreements
Working with difficult people
Relationship and reputation management
Certification:
Once after the training we will provide you with the course completion certificate.

Conflict Management

Conflict Management 1 Day Training in Chorley

Brighton

Conflict Management 1 Day Training in Brighton

<p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">Are you looking to enter the dynamic world of real estate?</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);">Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);">At the end of the course, you&#39;ll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector.</p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">On this course, you will&hellip;</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Become familiar with the players, structure, general terminology and overall needs of Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">Learn what is Real Estate and why it is different from other asset classes</li><li fr-original-style="" style="box-sizing: border-box;">Get to grips with the overall size and structure of the UK Real Estate Market</li><li fr-original-style="" style="box-sizing: border-box;">Learn and analyse the links between the different parts of the property market</li><li fr-original-style="" style="box-sizing: border-box;">Understand who works in the Real Estate Market, their qualifications and their job descriptions</li><li fr-original-style="" style="box-sizing: border-box;">Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc&hellip;</li><li fr-original-style="" style="box-sizing: border-box;">Learn how to read a real estate market report</li><li fr-original-style="" style="box-sizing: border-box;">Understand how current affairs, politics and economics affects Real Estate Investment</li><li fr-original-style="" style="box-sizing: border-box;">Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Who will benefit from this course:</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Graduates or undergraduates studying economics, finance.</li><li fr-original-style="" style="box-sizing: border-box;">Professionals working in Marketing or Accounting teams within Real Estate firms.</li><li fr-original-style="" style="box-sizing: border-box;">APC students.</li><li fr-original-style="" style="box-sizing: border-box;">Anyone interested in Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">School leavers/A-Level Students looking to gain an understanding of Real Estate.</li><li fr-original-style="" style="box-sizing: border-box;">Non cognate students who wish to transfer into Real Estate/Finance careers.</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Outline</strong></strong></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 1: What is and why buy Real Estate?</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The property Market</li><li fr-original-style="" style="box-sizing: border-box;">The Size and Structure of the UK property market</li><li fr-original-style="" style="box-sizing: border-box;">The impact of Real Estate in the Economy</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 2: The Real Estate Market System</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The Space Market</li><li fr-original-style="" style="box-sizing: border-box;">The Asset Market</li><li fr-original-style="" style="box-sizing: border-box;">The Development Market</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 3: How to value Real Estate</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">An Introduction to Financial Mathematics</li><li fr-original-style="" style="box-sizing: border-box;">The difference between Price, Value and Worth</li><li fr-original-style="" style="box-sizing: border-box;">Property Yield</li><li fr-original-style="" style="box-sizing: border-box;">Conventional Valuation Methods</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 4: How to read a Real Estate Market Report</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">Property Market Indicators: Stock Indicators</li><li fr-original-style="" style="box-sizing: border-box;">Property Market Indicators: Investment Indicators</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><em fr-original-style="" style="box-sizing: border-box;"><em fr-original-style="" style="box-sizing: border-box;">Module 5: Who works in Real Estate?</em></em></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">The build Environment by Cobalt Recruitment</li><li fr-original-style="" style="box-sizing: border-box;">Rea; Estate Agents</li><li fr-original-style="" style="box-sizing: border-box;">Examples of Real Estate Market Agents CVs</li><li fr-original-style="" style="box-sizing: border-box;">Real Estate Network</li></ul><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><br fr-original-style="" style="box-sizing: border-box;"></p><p style="color: rgb(111, 114, 135); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Included in the Course</strong></strong></p><ul style="color: rgb(111, 114, 135); box-sizing: border-box;" fr-original-style=" color: rgb(111, 114, 135);"><li fr-original-style="" style="box-sizing: border-box;">CPD Accredited Certificate</li><li fr-original-style="" style="box-sizing: border-box;">12 Months Access to the Course</li><li fr-original-style="" style="box-sizing: border-box;">Course Files</li><li fr-original-style="" style="box-sizing: border-box;">Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)</li><li fr-original-style="" style="box-sizing: border-box;">Post Course Support - Two Months of Questions &amp; Answers, and One year of support is available for an additional fee</li></ul><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></p><p id="isPasted" fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">For more information about the Introduction to Real Estate, please contact Sam on the Bayfield Training Sales team:</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">E - s.musgrave@bayfieldtraining.com</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">T - 01223 517851</p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">W - <a href="https://www.bayfieldtraining.com/" target="_blank" rel="nofollow noopener noreferrer ugc" title="https://www.bayfieldtraining.com/" data-airgap-id="125" fr-original-style="" style="user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;">www.bayfieldtraining.com</a></p>

Are you looking to enter the dynamic world of real estate?
Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.
At the end of the course, you'll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector.


On this course, you will…
Become familiar with the players, structure, general terminology and overall needs of Real Estate.
Learn what is Real Estate and why it is different from other asset classes
Get to grips with the overall size and structure of the UK Real Estate Market
Learn and analyse the links between the different parts of the property market
Understand who works in the Real Estate Market, their qualifications and their job descriptions
Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc…
Learn how to read a real estate market report
Understand how current affairs, politics and economics affects Real Estate Investment
Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector


Who will benefit from this course:
Graduates or undergraduates studying economics, finance.
Professionals working in Marketing or Accounting teams within Real Estate firms.
APC students.
Anyone interested in Real Estate.
School leavers/A-Level Students looking to gain an understanding of Real Estate.
Non cognate students who wish to transfer into Real Estate/Finance careers.


Course Outline
Module 1: What is and why buy Real Estate?
The property Market
The Size and Structure of the UK property market
The impact of Real Estate in the Economy


Module 2: The Real Estate Market System
The Space Market
The Asset Market
The Development Market


Module 3: How to value Real Estate
An Introduction to Financial Mathematics
The difference between Price, Value and Worth
Property Yield
Conventional Valuation Methods


Module 4: How to read a Real Estate Market Report
Property Market Indicators: Stock Indicators
Property Market Indicators: Investment Indicators


Module 5: Who works in Real Estate?
The build Environment by Cobalt Recruitment
Rea; Estate Agents
Examples of Real Estate Market Agents CVs
Real Estate Network


Included in the Course
CPD Accredited Certificate
12 Months Access to the Course
Course Files
Online Learning Platform access - Further Learning Resources (Reading, Files and Videos)
Post Course Support - Two Months of Questions & Answers, and One year of support is available for an additional fee


For more information about the Introduction to Real Estate, please contact Sam on the Bayfield Training Sales team:
E - s.musgrave@bayfieldtraining.com
T - 01223 517851
W - www.bayfieldtraining.com

Bayfield Training

Financial Modelling & Analysis

Real Estate Finance

Financial Modelling

Financial Analysis

Professional Development

Continuous Professional Development (CPD)

Are you looking to enter the dynamic world of real estate?

Our course is designed to equip you with the knowledge and tools you need to communicate effectively with real estate professionals and develop key skills in real estate investment strategy and analytics.

At the end of the course, you'll be able to read and interpret real estate market reports, and have a firm grasp of how iconic buildings, cities, and companies fit into the overall picture of the real estate sector.



On this course, you will…

Become familiar with the players, structure, general terminology and overall needs of Real Estate.
Learn what is Real Estate and why it is different from other asset classes
Get to grips with the overall size and structure of the UK Real Estate Market
Learn and analyse the links between the different parts of the property market
Understand who works in the Real Estate Market, their qualifications and their job descriptions
Recognise how and when to use basic real estate concepts: Rent, Value, Yield, Risk and Return, etc…
Learn how to read a real estate market report
Understand how current affairs, politics and economics affects Real Estate Investment
Use household names and iconic companies, cities and buildings to help consolidate your appreciation of this exciting sector


Who will benefit from this course:

Graduates or undergraduates studying economics, finance.
Professionals working in Marketing or Accounting teams within Real Estate firms.
APC students.
Anyone interested in Real Estate.
School leavers/A-Level Students looking to gain an understanding of Real Estate.
Non cognate students who wish to transfer into Real Estate/Finance careers.


Course Outline

Module 1: What is and why buy Real Estate?

The property Market
The Size and Structure of the UK property market
The impact of Real Estate in the Economy


Module 2: The Real Estate Market System

The Space Market
The Asset Market
The Development Market


Module 3: How to value Real Estate

An Introduction to Financial Mathematics
The difference between Price, Value and Worth
Property Yield
Conventional Valuation Methods


Module 4: How to read a Real Estate Market Report

Property Market Indicators: Stock Indicators
Property Market Indicators: Investment Indicators


Module 5: Who works in Real Estate?

The build Environment by Cobalt Recruitment
Rea; Estate Agents
Examples of Real Estate Market Agents CVs
Real Estate Network


An Introduction to Real Estate (12 Hours Online Self-Study)

<p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;">This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate. &nbsp;98% Employment rate after completion of the course.</p><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><div style="color: rgb(255, 255, 255) !important; box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(255, 255, 255) !important;"><div style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(102, 102, 102);"><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course &ndash; Join your lesson from wherever you are.&nbsp;</strong></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><span style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">This intensive&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">9 weeks</strong>&nbsp;Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate.&nbsp;</span><em style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">&nbsp;</em></p><p fr-original-style="" style="color: var(--text); font-size: var(--font-size); box-sizing: border-box;"><em style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">98% Employment rate after completion of the course.</strong></em></p></div><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">&nbsp;<img src="https://images.cademy.co.uk/8fcf7dda-bd82-4e1f-89f2-918b2aab2c30/ca03ba64-8a66-45eb-9cee-8309e1551f24/original.jpeg" style="color: rgb(65, 65, 65); width: 175px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(65, 65, 65); width: 175px;" fr-original-class="fr-draggable"></p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">How will you learn?</strong><br fr-original-style="" style="box-sizing: border-box;">Apart of our traditional class-based tuition, we also offer Virtual Learning courses.<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong>On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone.&nbsp;The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification.</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">We provide A-Z guidance starting from<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">&nbsp;before</strong> and <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">after</strong> the course. Your tutor will guide you through&nbsp;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">the online course to graduation</strong>&nbsp;which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!!</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">You will have:</strong><br fr-original-style="" style="box-sizing: border-box;">According to the timetable- 1 lessons per week for 9 consecutive weeks.<br fr-original-style="" style="box-sizing: border-box;">Exams and final exam based on which the certificate will be issued.<br fr-original-style="" style="box-sizing: border-box;">On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment.&nbsp;</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">What is Flight Attendant?<br fr-original-style="" style="box-sizing: border-box;"></strong>Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees.&nbsp;A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an&nbsp;aircrew&nbsp;team , who operate a commercial,&nbsp;business or even military aircraft while travelling domestically or internationally.&nbsp;</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Flight Attendant benefits:</strong></p><ul style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><li fr-original-style="" style="box-sizing: border-box;">Getting paid for travelling the world</li><li fr-original-style="" style="box-sizing: border-box;">Lifestyle</li><li fr-original-style="" style="box-sizing: border-box;">Flexible Work Schedules</li><li fr-original-style="" style="box-sizing: border-box;">Meeting Interesting People</li><li fr-original-style="" style="box-sizing: border-box;">Free Food &amp; Accommodation</li><li fr-original-style="" style="box-sizing: border-box;">Excellent Compensation</li><li fr-original-style="" style="box-sizing: border-box;">The uniforms</li><li fr-original-style="" style="box-sizing: border-box;">Working Environment</li></ul><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><a href="https://waterlooacademy.co.uk/airline-cabin-crew-course-career-progression-with-london-waterloo-academy/" target="_blank" rel="noopener noreferrer" style="color: rgb(46, 163, 242); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(46, 163, 242);"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);">How to become successful Flight Attendant job candidate?</span><br fr-original-style="" style="box-sizing: border-box;"></a></strong>Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation.<br fr-original-style="" style="box-sizing: border-box;">Airline companies look for individuals who share their values and can act as ambassadors for the company&rsquo;s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous.<br fr-original-style="" style="box-sizing: border-box;">Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round.&nbsp;</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Student &ndash; Cabin Crew Flying Support Group</strong><br fr-original-style="" style="box-sizing: border-box;">As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going <em fr-original-style="" style="box-sizing: border-box;">extra nautical mile</em> to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners.&nbsp;</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><span style="color: rgb(51, 51, 51); box-sizing: border-box;" fr-original-style=" color: rgb(51, 51, 51);"><a href="https://waterlooacademy.co.uk/airline-cabin-crew-course-career-progression-with-london-waterloo-academy/" target="_blank" rel="noopener noreferrer" style="color: rgb(51, 51, 51); user-select: auto; font-size: var(--font-size); box-sizing: border-box; cursor: pointer; text-decoration: inherit;" fr-original-style=" color: rgb(51, 51, 51);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Why London Waterloo Academy?</strong></a></span></p><ul style="color: rgb(102, 102, 102); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><li fr-original-style="" style="box-sizing: border-box;">Top Airline Cabin Crew course provider in London</li><li fr-original-style="" style="box-sizing: border-box;">98% Employment rate after completion of the course</li><li fr-original-style="" style="box-sizing: border-box;">Individual support on the journey from the course to a job placement</li><li fr-original-style="" style="box-sizing: border-box;">With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview.</li><li fr-original-style="" style="box-sizing: border-box;">We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge.</li><li fr-original-style="" style="box-sizing: border-box;">Our graduates are now flying with <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviaci&oacute;n, Air France,Titan, Norwegian B737 Short Haul&nbsp;</strong>and many more.</li><li fr-original-style="" style="box-sizing: border-box;">We will enhance your CV</li><li fr-original-style="" style="box-sizing: border-box;">Guidance through the job application process (free of charge)</li><li fr-original-style="" style="box-sizing: border-box;">Gain an insight into the airline selection process and final one-to-one interview</li><li fr-original-style="" style="box-sizing: border-box;">The vast global experience of our instructors</li><li fr-original-style="" style="box-sizing: border-box;">This course has been developed in accordance with EASA PART-CC</li></ul><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);">&nbsp;<img src="https://images.cademy.co.uk/8fcf7dda-bd82-4e1f-89f2-918b2aab2c30/fd1ef116-4fe7-4987-8285-628fe0517098/original.png" style="color: rgb(65, 65, 65); width: 184px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(65, 65, 65); width: 184px;" fr-original-class="fr-draggable"><img src="https://images.cademy.co.uk/8fcf7dda-bd82-4e1f-89f2-918b2aab2c30/258a6a37-0b1d-49a2-99d6-af09ce43753c/original.png" style="color: rgb(65, 65, 65); width: 182px; cursor: pointer; padding: 0px 1px; user-select: none; max-width: 100%; position: relative; box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(65, 65, 65); width: 182px;" fr-original-class="fr-draggable"></p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Working together &ndash;&nbsp;</strong>Starting&nbsp;a new career isn&rsquo;t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories.</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course Entry Requirements:<br fr-original-style="" style="box-sizing: border-box;"></strong>English Language at B2 (CEFR) level or above.<br fr-original-style="" style="box-sizing: border-box;">There are&nbsp;no other special requirements&nbsp;for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job.&nbsp;This course has been developed for all candidates, independent of their background, wishing to start a new career.&nbsp;</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Dates (choose one for your &nbsp;course):<br fr-original-style="" style="box-sizing: border-box;"></strong><span style="color: rgb(102, 102, 102); box-sizing: border-box;" id="isPasted" fr-original-style="color: rgb(102, 102, 102);">15 May 2024 &ndash; 10 July 2024, Wednesday classes</span><br fr-original-style="" style="box-sizing: border-box;">18 September 2024 &ndash; 6 November 2024, Wednesday classes<br fr-original-style="" style="box-sizing: border-box;">14 November 2024 &ndash; 9 January 2025, Thursday classes</p><p style="color: rgb(102, 102, 102); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(102, 102, 102);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course duration&nbsp;&ndash;</strong> 9 weeks<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Classes</strong> &ndash; once a week <strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;">Lesson Time &ndash;&nbsp;</strong>10am to 5pm &ndash; London time<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;"><br fr-original-style="" style="box-sizing: border-box;"></strong><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Course fee</strong><em fr-original-style="" style="box-sizing: border-box;">&nbsp;&ndash;&nbsp;</em>&pound;529 (we offer flexible payment plan and accept weekly instalments)<br fr-original-style="" style="box-sizing: border-box;"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Registration fee&nbsp;</strong>&ndash; &pound;300 &nbsp;(includes: examination, &nbsp;Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)</p><iframe allowfullscreen="" frameborder="0" data-src="https://www.youtube.com/embed/u77OnxZwK2c" src="https://www.youtube.com/embed/u77OnxZwK2c" name="fitvid1" fr-original-style="" style="box-sizing: border-box;"><span class="fr-mk" style="display: none;">&nbsp;</span></iframe><br fr-original-style="" style="box-sizing: border-box;"><iframe allowfullscreen="" frameborder="0" data-src="https://www.youtube.com/embed/vUxlDmhge8Y" src="https://www.youtube.com/embed/vUxlDmhge8Y" name="fitvid0" fr-original-style="" style="box-sizing: border-box;"><span class="fr-mk" style="display: none;">&nbsp;</span></iframe><iframe title="YouTube video player" allowfullscreen="" frameborder="0" data-src="https://www.youtube.com/embed/Ro9ScXAJ7b0" src="https://www.youtube.com/embed/Ro9ScXAJ7b0" name="fitvid2" fr-original-style="" style="box-sizing: border-box;"><span class="fr-mk" style="display: none;">&nbsp;</span></iframe></div>

This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate. 98% Employment rate after completion of the course.



Virtual Airline Cabin Crew which is also known as Air Hostess, Flight Attendant and Stewardess course – Join your lesson from wherever you are. 
This intensive 9 weeks Virtual Airline Cabin Crew course will give you all the information and tools you will need to become successful job candidate.  
98% Employment rate after completion of the course.

How will you learn?
Apart of our traditional class-based tuition, we also offer Virtual Learning courses.
On our Virtual (live stream via Zoom) lessons, we provide the same quality of tuition as in the classroom. You only need a laptop, PC or tablet with either built in (or external) camera and microphone. The virtual platform is very interactive with a sense of real classroom at the Academy. You will study from the comfort of your own home and communicate with your tutor and classmates via video chat (by using your phone or computer camera) and you will receive outstanding tuition, qualification, and certification.
We provide A-Z guidance starting from before and after the course. Your tutor will guide you through the online course to graduation which you will be welcome to attend. What a joy it would be to meet your tutor and classmates in real life!!
You will have:
According to the timetable- 1 lessons per week for 9 consecutive weeks.
Exams and final exam based on which the certificate will be issued.
On successful completion you will hold: Airline Cabin Crew certificate in Current Airline Training Standards and Equipment. 
What is Flight Attendant?
Flight attendant/Airline Cabin Crew/Stewardess/Air Hostess are the most visible, glamorous jobs of all airline employees. A Flight Attendant is someone whose primary duty is to ensure the safety and comfort of passengers during a flight. They are members of an aircrew team , who operate a commercial, business or even military aircraft while travelling domestically or internationally. 
Flight Attendant benefits:
Getting paid for travelling the world
Lifestyle
Flexible Work Schedules
Meeting Interesting People
Free Food & Accommodation
Excellent Compensation
The uniforms
Working Environment
How to become successful Flight Attendant job candidate?Our Aviation Team understands each candidate who wish to become Airline Cabin Crew or start a career in Aviation.
Airline companies look for individuals who share their values and can act as ambassadors for the company’s brand. Cabin Crew are the face of the airline company which means they deliver a fantastic service that makes airline world famous.
Airline companies prefer candidates with knowledge of Cabin Crew role. Airline companies have selection day or online tests as a first stage of recruitment, after which, they will take a closer look at applicants CV, skills and experience. If you completed Airline Cabin Crew course, your application will stand out and you can get an offer from the first round. 
Student – Cabin Crew Flying Support Group
As a market leading Airline Cabin Crew Training Company with a wealth of experience in Aviation and recruitment, we constantly upgrading our course and going extra nautical mile to guide and support all our students to ensure they can reach their goals. Graduates who are already flying, offer their full support to us and new students. They share an insight of the airline they already fly with, and help new students through the process of joining them at that airline. It gives a flying start to a career to new learners. 
Why London Waterloo Academy?
Top Airline Cabin Crew course provider in London
98% Employment rate after completion of the course
Individual support on the journey from the course to a job placement
With years of experience in Airline Cabin Crew industry, London Waterloo Academy has been recognised by major TV, radio channels who have invited our Aviation Team for expert advice or interview.
We are recognised by major airline companies in Europe and overseas who have approached London Waterloo Academy to deliver internal cabin crew training, corporate training and to recruit our graduates as a result of their high qualification standards and knowledge.
Our graduates are now flying with Etihad, Saudi Air, Hainan Airlines, Small Planet, British Airways, Qatar, EasyJet, Thomas Cook, Ryanair, Cubana de Aviación, Air France,Titan, Norwegian B737 Short Haul and many more.
We will enhance your CV
Guidance through the job application process (free of charge)
Gain an insight into the airline selection process and final one-to-one interview
The vast global experience of our instructors
This course has been developed in accordance with EASA PART-CC


Working together – Starting a new career isn’t easy and often it can seem like a lonely and impossible process. Our Aviation Department stays behind each learner, supporting every step of the way, we give you all the tools, skills and assistance you need to succeed. Our success, built on the success of our students and a long list of graduates with successful stories.
Course Entry Requirements:
English Language at B2 (CEFR) level or above.
There are no other special requirements for this Airline Cabin Crew course. We will teach you from scratch and support after the course when applying for the job. This course has been developed for all candidates, independent of their background, wishing to start a new career. 
Dates (choose one for your course):
15 May 2024 – 10 July 2024, Wednesday classes
18 September 2024 – 6 November 2024, Wednesday classes
14 November 2024 – 9 January 2025, Thursday classes
Course duration – 9 weeks
Classes – once a week 
Lesson Time – 10am to 5pm – London time
Course fee – £529 (we offer flexible payment plan and accept weekly instalments)
Registration fee – £300 (includes: examination, Airline Cabin Crew certificate in Current Airline Training Standards and Equipment)




London Waterloo Academy

Flight Attendant

Stewardess

VIRTUAL AIRLINE CABIN CREW COURSE

Registration Fee

Course Fee

Why Video is Essential For Business
In today's competitive business landscape, video stands out as an indispensable tool for effective business promotion, solidifying its place as a cornerstone in your marketing toolkit.
This interactive workshop is your key to mastering the art of creating impactful and high-quality video content tailored for your business needs.
Imagine being able to tap into the incredible potential of video to boost your business promotion and enhance your service offerings.
Empower Your Business with Video
What You Will Learn:
Get hands-on with the key skills for impactful video production:
Video Dynamics: Understand what makes visuals engaging and effective.
Essential Equipment: Choose the right equipment for your needs.
Planning Perfection: Set the stage for a smooth and successful shoot.
Framing Fundamentals: Compose shots that tell a story.
Audio & its Importance: Capture clear and professional sound.
Lighting Mastery: Master techniques for beautiful visuals.
On-Camera Confidence: Deliver your message with poise and presence.
Directing for Impact: Get the best performances from others.
Cutaway Creativity: Enhance your storytelling with strategic cuts.
Shoot Savvy: Plan efficient and productive filming sessions.
Who Should Take This Workshop?
This workshop is ideal for business owners, entrepreneurs, and marketing professionals who want to incorporate video into their marketing strategies but lack prior video experience.
Workshop Prerequisites:
A basic understanding of computers and the internet
A willingness to learn and practice new skills
Workshop Format:
This workshop is delivered online on Zoom.
Workshop Duration:
This workshop has been broken down into three sessions and runs over three weeks. Each session is run on a Friday from 12 to 2 PM so there is no information overload. You will receive a recording of each session on completion so that you can review the work at your leisure.
Don't miss out on this opportunity to empower your business with the power of creating videos. Enrol in our ‘Creating Videos With Your Phone’ workshop today and start creating captivating videos that drive engagement, boost conversions, and elevate your business to new heights of success.
If you would like to find out more about creating and using video in your business then feel free to book a 121 with us.
You might also want to consider joining our 'Video Creators Club' which has everything that you need to get started using video in your business.

Clockwork Eye Video

Photography & Video

Video

Video Marketing

Video Creation

Mobile Video Production

Film & Video

Video Design

Videography

Video Production

Video Editing

Video & Mobile Marketing

Learn to craft top-notch videos for your business using your mobile phone in this interactive workshop. Enhance marketing, visibility, and attract more clients through video. All-in-one workshop for diving into the world of business videos. #VideoCreation #BusinessBoost

Creating Video For Business (Interactive Workshop)

London

<div>
	                  <h5>MS Power BI Course summary</h5>
	               </div>
	               <div></div>
	               <p> 
				   
							   Data Visualization Courses London. 
					   In this Power BI Course, you will learn how to translate data trends, summaries, statistics and insights from your data into powerful and inspirational Visualations
This course is ideal for managers and data analysts who need to make business descisions based on data.

					   
						<br /><br />The course duration is 1 day.

				   </p>
				   <div id="PBITaster">
	                  <h5>MS Power BI 1-Hour Taster</h5>
	               </div>
	               <div></div>
	               <p> 
				   
							   Our 1 hour Power BI taster gives an excellent summary of Power BI. Is give you the basics, so that you could decide on a full course, or teach yourself from there.
						<br />Terminology overview, Get Data, Visual Basics, Format The Visual, Change the Formulae, Add KPI's, Add Dynamic Filters, Addd the visual to a Dashboard	
						<br />Contact us for a time and date, and then the 1 hour.
						<br />
						</p>

				   <p></p>
				   
	               <div>
	                  <div>
							<h5>MS Power BI 1-day Full Course Description</h5>
	                  </div>
	                  <div></div>
 
												 
						<div>
							<strong> Introduction: </strong> 
											<p> 
							Connect to your data source and various data sources. 
							<br />Understand MS POWER BI terminology and interface. 	 
						</p>
						</div>
					   <div>
							<strong> Visuals:  </strong>  
							<p>  
								Creating visuals, 
								<br />Chart types, 
								<br />Geographic maps, 
								<br />Heat maps, 
								<br />Tree maps, 
								<br />Pie charts, 
								<br />bar charts and many other types of charts, 
								<br />Importing custom designs and custom chart types. 
								<br />Choosing suitable chart types. 
								<br />Single measures, multiple measure, 
								<br />double axes, displaying dates, drilldown, sorting visuals. 
								<br />Analysis Lines. 
								<br />Filters and slicers. 
							</p>
						</div>	
						<div>
							<strong> Formatting:  </strong>  
							<p>   
							Formatting visuals. 
							</p>
						</div>	
								 
						<div>
							<strong> Working with the data:  </strong>  
							<p>  
								Preparing data using queries.
								<br />Calculations: Create calculated columns and measures. 
								<br />Columns vs Measures. 
								<br />Quick Measures.  
							</p>
						</div>	
						<div>
							<strong> Functions:  </strong>  
							<p>  Built-in Functions for dates, maths and strings. 
								 
							</p>
						</div>
						<div>
							<strong> DAX calculations:  </strong>  
							<p>  Relationships 
								<br />DAX calculations.
								 
							</p>
						</div>		
						<div>
							<strong> Final presentation:  </strong>  
							<p>  
								Final presentation: Reports, publish reports, create dashboards
							</p>
						</div>	
 
 
 
 
	               </div>
	               <div id="cincluded">
	                  <div>
	                     <h5>What is included in the MS Power BI Courses:</h5>
	                  </div>
	                  <div>
	                     <ul>
	                        <li>MS Power BI Course Certificate on completion  </li>
	                        <li>MS Power BI Course notes</li>
	                        <li>Practical MS Power BI Course exercises, MS Power BI Course Homework / MS Power BI Course Revision work</li>
	                         
	                        <li>After the course, 1 free session for questions online MS Power BI Course via Gotomeeting.com.</li>
	                        <li>Max group size, online and in classroom, on this MS Power BI Course is 4. </li>
	                     </ul>
	                  </div>
	               </div>

MS Power BI Course 
 Data Visualization Courses London. In this Power BI Course, you will learn how to translate data trends, summaries, statistics and insights from your data into powerful and inspirational visualizations
This course is ideal for managers and data analysts who need to make business decisions based on data. 

The course duration is 1 day. 
MS Power BI 1-day Course Description
Introduction:
 Connect to your data source and various data sources. 
Understand MS POWER BI terminology and interface. 
Visuals:
 Creating visuals, 
Chart types, 
Geographic maps, 
Heat maps, 
Tree maps, 
Pie charts, 
bar charts and many other types of charts, 
Importing custom designs and custom chart types. 
Choosing suitable chart types. 
Single measures, multiple measure, 
double axes, displaying dates, drilldown, sorting visuals. 
Analysis Lines. 
Filters and slicers. 
Formatting:
 Formatting visuals. 
Working with the data:
 Preparing data using queries. 
Calculations: Create calculated columns and measures. 
Columns vs. Measures. 
Quick Measures. 
Functions:
 Built-in functions for dates, math, and strings. 
DAX calculations:
 Relationships 
DAX calculations. 
Final presentation:
 Final presentation: Reports, publish reports, create dashboards 
What is included in the MS Power BI Courses:
MS Power BI Course Certificate on completion
MS Power BI Course notes
Practical MS Power BI Course exercises, MS Power BI Course homework, and MS Power BI Course Revision work
After the course, 1 free session for questions online MS Power BI Course via Gotomeeting.com.
Max group size, online and in classroom, on this MS Power BI Course is 4.

PCWorkshops

Microsoft Power BI

Data Science

Data Visualization

Business Intelligence (BI)

Data Analyst

 Data Visualization Courses London. In this Power BI Course, you will learn how to translate data trends, summaries, statistics and insights from your data into powerful and inspirational visualizations
This course is ideal for managers and data analysts who need to make business decisions based on data.

MS POWER BI COURSE

General admission

<article>
<div>
<h5>Learn SQL Course, 1-Day</h5>
</div>
<div></div>
<p>  						 
	</p><div>
	<ul>
		<p>
		<b>SQL Queries Course, 1-Day. </b>Basic SQL syntax. 
		<br />Most attendees are in-work IT Professional.
		<br />Private individuals are also very welcome. 
		<br />Evening courses also running.
		<br /><b>Our Style: </b>Hands-on, Practical  
		<br /><b>Location:  </b>Online, Instructor-led  
		<br /><b>Download:  </b>anaconda.com
		<br /><b>Duration:  </b>6 weeks, 1 evening per week, 6pm - 8pm
		<br /><b>Times: </b>arrange a time for your time zone
	    </p>
	</ul>	

<p></p>
</div></article>

<div>
	  <div>
		 <h5>Learn SQL Course, 1-Day</h5>
	  </div>
	  <div></div>
	  <p> With SQL Queries, you could learn SQL in a day, and master the basics of SQL, get interesting, insightful and essential business intelligence from data by using SQL queries on this SQL Course London, UK. 
	  <br />Queries are made easy and simple, saving hours of online training.
 
		<br />This 1 Day course is packed with power query techniques.

<br /><br />This SQL Introduction Course is hands-on, practical with many excellent query examples.
<br /><br />This course is Platform Independent.
<br /><br />This SQL course is hands-on and practical, to give you in-depth, practical experience of the topics covered.
<br /><br />Ask your SQL questions in small, friendly classroom SQL Course. 
<br /><br />Online, Instructor-led, Interactive, full screen sharing.

	  </p>
	<div>
	<h5> Learn SQL Relational Database Concepts:</h5>
	</div>
	<div></div>
	<div> 
					<p>  <strong>Database:</strong>  
					<br />What is a Relational Database?
<br />Tables, Rows and Columns
<br />Indexes, Primary Keys and Foreign Keys
<br />Data Types  
					</p> 
			 
				 
			</div>
	<div>
	<h5>Learn SQL Essentials:</h5>
	</div> <div></div>
	<div> 
				<p> <strong>Basics.</strong>
					<br />SQL Language Essentials:
<br />The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
<br />SQL Arithmetic Operations, Expression Queries
<br />SQL Column Aliases
<br />Limit/Top, Distinct

				 
				</p>
			</div>
	<div>
	<h5>Summarizing and Grouping Data:</h5>
	</div> <div></div>
	<div> 
				<p>  <strong>Group by</strong>
				<br />
Aggregate Functions (Sum, Avg, Count, Max, Min)
<br />The Group By Clause
<br />The Having Clause
				 
				</p>
			</div>
	<div>
	<h5>Querying Multiple Tables:</h5>
	</div> <div></div>
	<div>
				<p>   <strong>Joins</strong>
					<br />
Joining Tables
<br />Inner Joins, Outer Joins, Self Joins, Full Joins, 
<br />Cross Joins
<br />Alternative Join Syntax
				</p>
			</div>

	 
	
	 
	<div>
	<h5>Basic Subqueries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Sub-queries</strong>
			<br />Basics of CTE tables
			<br />SQL subqueries 
			<br />Using subqueries in the from clause
			<br />Using subqueries in the where clause
			<br />Using subqueries in the select clause
			<br />Using subqueries in the having clause 
			
		</p>
	</div>
	<div>
	<h5>Combine Queries</h5>
	</div> 
	<div></div>
	<div>	 
		<p> <strong>Combine Queries</strong>
			<br />The Union Operator
			<br /> Intersect and Minus Operators
			<br /> Simulating combine Intersect and Minus queries by using sub-queries
					   

			 

		</p>
	</div>
	  
</div>
 

<div>   

	   <div id="cincluded">
		  <div>
			 <h5>What is included</h5>
		  </div>

		  <article>
		  <div>
			 <ul>
				<li>PCWorkshops Course Certificate on completion  </li>
									   
				<li>SQL Course Notes</li>
				<li>SQL Code Examples</li>
				<li>Practical SQL Course exercises and Code Samples</li>
				<li>After the course: 1-Hour personalised online revision session</li>
			 </ul>
		  </div>
		  </article>
	   </div>
				    
<div>
	                  <div>
	                     <h5 id="cincluded2">Book the SQL Course</h5>
	                  </div>
 
	 
 <div id="eventbrite-widget-container-100389112538"></div>




									
					
					 
</div>
				   <div id="caboutus">
	                  <div>
	                     <h5>About us</h5>
	                  </div> 
	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_m8v4lCcicRynaFxnT4tD2JOVCitkIkMwzh0sIQRc9Toth01PZo"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>
				   
				   
	        </div>

Learn SQL Course, 1-Day
This SQL course is platform independent.
SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 
Evening courses also running. 

Details
Our Style: Hands-on, Practical 
Location: Online, Instructor-led 
Download: anaconda.com 
Duration: 6 weeks, 1 evening per week, 6pm - 8pm 
Times: arrange a time for your time zone 
Join us on your booked dates on https://meet.goto.com/910697125
Learn SQL Course, 1-Day Online Instructor-led
With SQL Queries, you could learn SQL in a day, and master the basics of SQL, and get interesting, insightful, and essential business intelligence from data by using SQL queries on this SQL Course in London, UK. 
Queries are made easy and simple, saving hours of online training. 
This 1 Day course is packed with power query techniques. 

This SQL Introduction Course is hands-on, practical with many excellent query examples.
This SQL course is hands-on and practical to give you in-depth, practical experience of the topics covered.
Ask your SQL questions in a small, friendly classroom SQL course. 

Learn SQL. Relational Database Concepts:
 Database: 
What is a Relational Database?

Tables, Rows and Columns

Indexes, Primary Keys and Foreign Keys

Data Types 
Learn SQL Essentials:
 Basics. 
SQL Language Essentials:

The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values

SQL Arithmetic Operations, Expression Queries

SQL Column Aliases

Limit/Top, Distinct 
Summarizing and Grouping Data:
 Group by 

Aggregate Functions (Sum, Avg, Count, Max, Min)

The Group By Clause

The Having Clause 
Querying Multiple Tables:
 Joins 

Joining Tables

Inner Joins, Outer Joins, Self Joins, Full Joins, 
Cross Joins

Alternative Join Syntax 
Basic Subqueries
 Sub-queries 
Basics of CTE tables 
SQL subqueries 
Using subqueries in the from clause 
Using subqueries in the where clause 
Using subqueries in the select clause 
Using subqueries in the having clause 
 
 Combine Queries 
The Union Operator 
 Intersect and Minus Operators 
 Simulating combined Intersect and Minus queries by using sub-queries 

What is included
PCWorkshops Course Certificate on completion
SQL Course Notes
SQL Code Examples
Practical SQL Course exercises and Code Samples
After the course: 1-Hour personalised online revision session
  



Online Course Creation

Database Programming

IT Skills

Data Skills

SQL Queries Course, 1-Day. Basic SQL syntax.  This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. 
Private individuals are also very welcome. 

Learn SQL Basics, 1-day Course, Online Instructor-Led

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.</p>Overview<p>After completing this course, students will be able to:<br />Create a technical design<br />Configure Common Data Service<br />Create and configure Power Apps<br />Configure business process automation<br />Extend the user experience<br />Extend the platform<br />Develop Integrations</p><p>The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.</p></div><div id="course-pills-2"><h4>Create a model-driven application in Power Apps</h4><ul><li>This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.</li></ul><h4>Get started using Common Data Service</h4><ul><li>This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.</li></ul><h4>Create a canvas app in Power Apps</h4><ul><li>This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.</li></ul><h4>Automate a business process using Power Automate</h4><ul><li>This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.</li></ul><h4>Create a business process flow in Power Automate</h4><ul><li>This module introduces you to creating business process flows in Power Automate</li></ul><h4>Introduction to developing with Power Platform</h4><ul><li>This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform</li></ul><h4>Extending the Power Platform user experience Model Driven apps</h4><ul><li>This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.</li></ul><h4>Create components with Power Apps Component Framework</h4><ul><li>This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.</li></ul><h4>Extending the Power Platform Common Data Service</h4><ul><li>This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.</li></ul><h4>Integrate with Power Platform and Common Data Service</h4><ul><li>This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.</li></ul><h4>Extend Power Apps portals</h4><ul><li>This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.</li></ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans PL-400T00 Microsoft Power Platform Developer training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the PL-400T00 Microsoft Power Platform Developer 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.  <p></p>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.<p></p></div>

Duration
5 Days
30 CPD hours
This course is intended for
Candidates for this course design, develop, secure, and troubleshoot Power Platform solutions. Candidates implement components of a solution that include application enhancements, custom user experience, system integrations, data conversions, custom process automation, and custom visualizations. Candidates will gain applied knowledge of Power Platform services, including in-depth understanding of capabilities, boundaries, and constraints.
Overview
After completing this course, students will be able to:
Create a technical design
Configure Common Data Service
Create and configure Power Apps
Configure business process automation
Extend the user experience
Extend the platform
Develop Integrations
The Microsoft Power Platform helps organizations optimize their operations by simplifying, automating and transforming business tasks and processes. In this course, students will learn how to build Power Apps, Automate Flows and extend the platform to complete business requirements and solve complex business problems.
Create a model-driven application in Power Apps
This module introduces you to creating a model-driven app in Power Apps that uses Common Data Service.
Get started using Common Data Service
This module will explain the concepts behind and benefits of Common Data Service. Creating an environment, entities, fields and options sets are also discussed.
Create a canvas app in Power Apps
This module introduces you to Power Apps, helps you create and customize an app, and then manage and distribute it. It will also show you how to provide the best app navigation, and build the best UI using themes, icons, images, personalization, different form factors, and controls.
Automate a business process using Power Automate
This module introduces you to Power Automate, teaches you how to build workflows, and how to administer flows.
Create a business process flow in Power Automate
This module introduces you to creating business process flows in Power Automate
Introduction to developing with Power Platform
This module is the first step in learning about platform, tools, and the ecosystem of the Power Platform
Extending the Power Platform user experience Model Driven apps
This module describes how to create client scripting, perform common actions with client script, and automate business process flow with client scrip. Learn about what client script can do, rules, and maintaining scripts. Discover when to use client script as well as when not to use client script.
Create components with Power Apps Component Framework
This module describes how to get started with Power Apps Component Framework with an introductory module on the core concepts and components. Then it shows you how to build a component and work with advanced Power Apps Component Framework features.
Extending the Power Platform Common Data Service
This module looks at the tools and resources needed for extending the Power Platform. We'll start with looking at the SDKs, the extensibility model, and event framework. This learning path also covers when to use plug-ins. Configuration of plug-ins as well as registering and deploying plug-ins.
Integrate with Power Platform and Common Data Service
This module describes how to integrate with Common Data Service using code by learning about Common Data Service API. Get an in-depth overview of options available with Common Data Service to integrate data and events to Azure.
Extend Power Apps portals
This module describes how to transform a content portal into a full web app interacting with Common Data Service. We will also cover the options available to customizers and developers to extend the portal functionality and integrate with Office 365, Power Platform, and Azure components.
Additional course details:
Nexus Humans PL-400T00 Microsoft Power Platform Developer 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 PL-400T00 Microsoft Power Platform Developer 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.


Nexus Human

Microsoft PL-900

Microsoft Power Apps

Power Apps

Microsoft Power Platform

Microsoft AZ-303

Microsoft Power Automate

PL-400T00 Microsoft Power Platform Developer

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p></p><p>A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.</p><p></p><p></p><p>This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.</p><p></p>Prerequisites<p></p><p></p><ul> <li>Experience as an IT professional or student</li> <li>Working knowledge of Microsoft Power Platform and its key components</li> <li>Knowledge of Microsoft Dataverse (or general data modeling) and security concepts</li></ul><p></p><p></p></div><div id="course-pills-2"><h3>1 - Describe the business value of the Microsoft Power Platform</h3> <ul> <li>Explore Microsoft Power Platform</li> <li>Describe the business value of the Power Platform</li> <li>Explore connectors and Microsoft Dataverse</li> <li>Describe how Power Platform works with Microsoft 365 apps and services</li> <li>Explore how Power Platform works with Microsoft Teams</li> <li>Describe how Power Platform works  with Microsoft Dynamics 365 apps</li> <li>Describe how Power Platform solutions consume Microsoft Azure services </li> <li>Explore how Microsoft Power Platform apps work together </li> <li>Use Artificial Intelligence to increase productivity</li> </ul> <h3>2 - Core components of Power Pages</h3> <ul> <li>Get started with Power Pages</li> <li>Core tools and components of Power Pages</li> <li>Overview of Power Pages security</li> <li>Overview of Power Pages extensibility</li> </ul> <h3>3 - Explore Power Pages templates</h3> <ul> <li>Site design templates</li> <li>Scenario-based templates</li> <li>Dynamics 365 Power Pages site templates</li> </ul> <h3>4 - Explore Power Pages design studio</h3> <ul> <li>Work with pages</li> <li>Page components</li> <li>Site styling and templates</li> </ul> <h3>5 - Explore Power Pages design studio data and security features</h3> <ul> <li>Data workspace in Power Pages design studio</li> <li>Power Pages security features</li> </ul> <h3>6 - Introduction to Power Pages administration</h3> <ul> <li>Power Pages administrative tools</li> <li>Set up workspace in Power Pages design studio</li> </ul> <h3>7 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>8 - Get data with Power BI Desktop</h3> <ul> <li>Overview of Power BI Desktop</li> <li>Explore Power BI Desktop</li> <li>Connect to data sources</li> <li>Get data from Excel</li> <li>Transform data to include in a report</li> <li>Combine data from multiple sources</li> <li>Clean data to include in a report</li> </ul> <h3>9 - Model data in Power BI</h3> <ul> <li>How to manage your data relationships</li> <li>Create calculated columns</li> <li>Optimize data models</li> <li>Create measures</li> <li>Create calculated tables</li> <li>Explore time-based data</li> </ul> <h3>10 - Use visuals in Power BI</h3> <ul> <li>Create and customize simple visualizations</li> <li>Create slicers</li> <li>Map visualizations</li> <li>Matrices and tables</li> <li>Create scatter, waterfall, and funnel charts</li> <li>Modify colors in charts and visuals</li> <li>Page layout and formatting</li> </ul> <h3>11 - Explore data in Power BI</h3> <ul> <li>Quick insights in Power BI</li> <li>Create and configure a dashboard</li> <li>Ask questions of your data with natural language</li> <li>Create custom Q&amp;A suggestions</li> <li>Share dashboards with your organization</li> <li>Display visuals and tiles in full screen</li> <li>Edit tile details and add widgets</li> <li>Get more space on your dashboard</li> </ul> <h3>12 - Publish and share in Power BI</h3> <ul> <li>Publish Power BI Desktop reports</li> <li>Print and export dashboards and reports</li> <li>Introducing Power BI Mobile</li> <li>Create workspaces in Power BI</li> <li>Build apps</li> <li>Use apps</li> <li>Integrate OneDrive for Business with Power BI</li> <li>Publish to web</li> </ul> <h3>13 - Create and manage workspaces in Power BI</h3> <ul> <li>Distribute a report or dashboard</li> <li>Monitor usage and performance</li> <li>Recommend a development life cycle strategy</li> <li>Troubleshoot data by viewing its lineage</li> <li>Configure data protection</li> </ul> <h3>14 - Manage semantic models in Power BI</h3> <ul> <li>Use a Power BI gateway to connect to on-premises data sources</li> <li>Configure a semantic model scheduled refresh</li> <li>Configure incremental refresh settings</li> <li>Manage and promote semantic models</li> <li>Troubleshoot service connectivity</li> <li>Boost performance with query caching (Premium)</li> </ul> <h3>15 - Create dashboards in Power BI</h3> <ul> <li>Configure data alerts</li> <li>Explore data by asking questions</li> <li>Review Quick insights</li> <li>Add a dashboard theme</li> <li>Pin a live report page to a dashboard</li> <li>Configure a real-time dashboard</li> <li>Set mobile view</li> </ul> <h3>16 - Implement row-level security</h3> <ul> <li>Configure row-level security with the static method</li> <li>Configure row-level security with the dynamic method</li> </ul> <h3>17 - Create tables in Dataverse</h3> <ul> <li>Table characteristics</li> <li>Table relationships</li> <li>Dataverse logic and security</li> <li>Dataverse auditing</li> <li>Dual-write vs. virtual tables</li> </ul> <h3>18 - Manage tables in Dataverse</h3> <ul> <li>Identify tables and table types in Dataverse</li> <li>Create a custom table</li> <li>Enable attachments within a table</li> <li>Licensing requirements for each table type</li> </ul> <h3>19 - Create and manage columns within a table in Dataverse</h3> <ul> <li>Define columns in Microsoft Dataverse</li> <li>Column types in Microsoft Dataverse</li> <li>Add a column to a table</li> <li>Create a primary name column</li> <li>Restrictions that apply to columns in a table</li> <li>Create an auto numbering column</li> <li>Create an alternate key</li> </ul> <h3>20 - Create a relationship between tables in Dataverse</h3> <ul> <li>Relate one or more tables - Introduction</li> <li>Relationship types that are available in Microsoft Dataverse</li> <li>Create a one-to-many relationship between tables</li> <li>Create a many-to-many relationship between tables</li> <li>Edit or delete relationships</li> </ul> <h3>21 - Working with choices in Dataverse</h3> <ul> <li>Define choice column</li> <li>Standard choices column</li> </ul> <h3>22 - Get started with security roles in Dataverse</h3> <ul> <li>Understand environment roles</li> <li>Adding or disabling an environment user</li> <li>Understand security concepts in Dataverse</li> <li>Understand user security roles and security role defaults</li> <li>Check the roles that a user belongs to</li> <li>Configure Dataverse teams for security</li> <li>Configure Dataverse group teams for security</li> </ul> <h3>23 - Use administration options for Dataverse</h3> <ul> <li>Use Microsoft Power Platform Admin Center portal</li> <li>Tenant storage capacity</li> <li>Advanced Customization options in Power Apps Portal</li> <li>Enable and disable auditing</li> </ul> <h3>24 - Manage Dynamics 365 model-driven app settings and security</h3> <ul> <li>Configure role-based security</li> <li>Manage teams and business units</li> <li>Explore settings and customizations</li> </ul> <h3>25 - Introduction to Microsoft Power Platform security and governance</h3> <ul> <li>Identify Microsoft Power Platform environments</li> <li>Data Loss Prevention policies</li> <li>Microsoft Power Platform Center of Excellence Starter Kit</li> </ul> <h3>26 - Get started with model-driven apps in Power Apps</h3> <ul> <li>Introducing model-driven apps</li> <li>Components of model-driven apps</li> <li>Design model-driven apps</li> <li>Incorporate business process flows</li> </ul> <h3>27 - Configure forms, charts, and dashboards in model-driven apps</h3> <ul> <li>Forms overview</li> <li>Form elements</li> <li>Configure multiple forms</li> <li>Use specialized form components</li> <li>Configure views overview</li> <li>Configure grids</li> <li>Create and edit views</li> <li>Configure charts overview</li> <li>Dashboards overview</li> <li>Use interactive streams and tiles</li> </ul> <h3>28 - Get started with Power Apps canvas apps</h3> <ul> <li>Power Apps building blocks</li> <li>Ways to build Power Apps</li> <li>Power Apps related technologies</li> <li>Additional Power Apps related technologies</li> <li>Designing a Power Apps app</li> </ul> <h3>29 - Connect to other data in a Power Apps canvas app</h3> <ul> <li>Overview of the different data sources</li> <li>Work with action-based data sources</li> <li>Power Automate is a companion to Power Apps</li> </ul> <h3>30 - How to build the UI in a canvas app in Power Apps</h3> <ul> <li>Use themes to quickly change the appearance of your app</li> <li>Branding a control</li> <li>Icons</li> <li>Images</li> <li>Personalization</li> <li>Using the tablet or phone form factors</li> </ul> <h3>31 - Manage apps in Power Apps</h3> <ul> <li>Power Apps review</li> </ul> <h3>32 - Build your first app with Power Apps and Dataverse for Teams</h3> <ul> <li>Create your first app with the hero template</li> <li>Customize your app with Power Apps Studio</li> <li>Publish your app</li> <li>Install template apps</li> </ul> <h3>33 - Access Dataverse in Power Pages websites</h3> <ul> <li>Use lists to display multiple Dataverse records</li> <li>Use forms to interact with Dataverse data</li> </ul> <h3>34 - Authentication and user management in Power Pages</h3> <ul> <li>Power Pages authentication settings</li> <li>User registration in Power Pages</li> <li>Authentication management for Power Pages users</li> <li>Power Pages authentication providers</li> </ul> <h3>35 - Power Pages maintenance and troubleshooting</h3> <ul> <li>Power Pages website maintenance</li> <li>Power Pages website troubleshooting</li> </ul> <h3>36 - Define and create business rules in Dataverse</h3> <ul> <li>Define business rules - Introduction</li> <li>Define the components of a business rule</li> <li>Create a business rule</li> </ul> <h3>37 - Get started with Power Automate</h3> <ul> <li>Introducing Power Automate</li> <li>Troubleshoot flows</li> </ul> <h3>38 - Use the Admin center to manage environments and data policies in Power Automate</h3> <ul> <li>Administer flows</li> <li>Export and import flows</li> <li>Learn how to distribute button flows</li> </ul> <h3>39 - Use Dataverse triggers and actions in Power Automate</h3> <ul> <li>Dataverse triggers</li> <li>Query data</li> <li>Create, update, delete, and relate actions</li> </ul> <h3>40 - Extend Dataverse with Power Automate</h3> <ul> <li>Set up a flow and configure its trigger</li> <li>Email Dataverse record</li> <li>Add to-do items</li> <li>Test and run your flow</li> </ul> <h3>41 - Introduction to expressions in Power Automate</h3> <ul> <li>Get started with expressions</li> <li>Notes make things easier</li> <li>Types of functions</li> <li>Write complex expressions</li> </ul> <h3>42 - Build your first Power Automate for desktop flow</h3> <ul> <li>Set up the environment</li> <li>Explore Power Automate for desktop</li> <li>Create your first Power Automate for desktop flow</li> <li>Record Power Automate for desktop actions</li> <li>Edit and test recorded actions</li> </ul> <h3>43 - Run a Power Automate for desktop flow in unattended mode</h3> <ul> <li>Set up an unattended desktop flow</li> <li>Create a new cloud flow that calls an existing flow in unattended mode</li> <li>Perform a test run</li> <li>Best practices</li> </ul> <h3>44 - Optimize your business process with process advisor</h3> <ul> <li>Get familiar with process advisor</li> <li>Create your first recording</li> <li>Edit recordings and group actions</li> <li>Analyze recordings and interpret results</li> <li>Automation recommendations</li> </ul> <h3>45 - Get started with Microsoft Copilot Studio bots</h3> <ul> <li>Get started working with environments</li> <li>Create bots and work with the Microsoft Copilot Studio interface</li> <li>Create topics</li> <li>Test bots</li> <li>Publish bots and analyze performance</li> </ul> <h3>46 - Enhance Microsoft Copilot Studio bots</h3> <ul> <li>Use Power Automate to add actions</li> <li>Transfer conversations to agents by using Omnichannel for Customer Service</li> <li>Create topics for existing support content</li> <li>Analyze bot performance</li> </ul> <h3>47 - Manage topics in Microsoft Copilot Studio</h3> <ul> <li>Work with bot topics</li> <li>Branch a topic</li> <li>Create topics for existing support content</li> <li>Work with system fallback topics</li> <li>Manage topics</li> </ul> <h3>48 - Manage Power Virtual Agents</h3> <ul> <li>Environments in Microsoft Copilot Studio</li> <li>Bot topics permissions</li> <li>Bot entities and flow permissions</li> <li>Monitor and diagnose</li> <li>Administer and manage</li> <li>Export and import bots</li> <li>Authentication</li> </ul> <h3>49 - Get started building with Power BI</h3> <ul> <li>Use Power BI</li> <li>Building blocks of Power BI</li> <li>Tour and use the Power BI service</li> </ul> <h3>50 - Get data with Power BI Desktop</h3> <ul> <li>Overview of Power BI Desktop</li> <li>Explore Power BI Desktop</li> <li>Connect to data sources</li> <li>Get data from Excel</li> <li>Transform data to include in a report</li> <li>Combine data from multiple sources</li> <li>Clean data to include in a report</li> </ul> <h3>51 - Model data in Power BI</h3> <ul> <li>How to manage your data relationships</li> <li>Create calculated columns</li> <li>Optimize data models</li> <li>Create measures</li> <li>Create calculated tables</li> <li>Explore time-based data</li> </ul> <h3>52 - Use visuals in Power BI</h3> <ul> <li>Create and customize simple visualizations</li> <li>Create slicers</li> <li>Map visualizations</li> <li>Matrices and tables</li> <li>Create scatter, waterfall, and funnel charts</li> <li>Modify colors in charts and visuals</li> <li>Page layout and formatting</li> </ul> <h3>53 - Explore data in Power BI</h3> <ul> <li>Quick insights in Power BI</li> <li>Create and configure a dashboard</li> <li>Ask questions of your data with natural language</li> <li>Create custom Q&amp;A suggestions</li> <li>Share dashboards with your organization</li> <li>Display visuals and tiles in full screen</li> <li>Edit tile details and add widgets</li> <li>Get more space on your dashboard</li> </ul> <h3>54 - Publish and share in Power BI</h3> <ul> <li>Publish Power BI Desktop reports</li> <li>Print and export dashboards and reports</li> <li>Introducing Power BI Mobile</li> <li>Create workspaces in Power BI</li> <li>Build apps</li> <li>Use apps</li> <li>Integrate OneDrive for Business with Power BI</li> <li>Publish to web</li> </ul> <h3>55 - Manage solutions in Power Apps and Power Automate</h3> <ul> <li>Add and remove apps, flows, and entities in a solution</li> <li>Edit a solution-aware app, flow, and table</li> <li>Build and deploy a complex solution with flows, apps, and entities</li> <li>Automate solution management</li> </ul> <h3>56 - Load/export data and create data views in Dataverse</h3> <ul> <li>View data in a table</li> <li>Create or edit views of data in a table</li> <li>Load data into a table</li> <li>Export data from a table</li> <li>Add, update, or delete data in a table by using Excel</li> <li>Import data using Power Query</li> <li>Generate a new dataflow from an Excel Template</li> <li>Dataflow and Azure integration</li> </ul> <h3>57 - Get started with AI Builder</h3> <ul> <li>Choose an AI capability</li> <li>Create your first model</li> <li>Ways to use your models</li> </ul> <h3>58 - Manage models in AI Builder</h3> <ul> <li>Model lifecycle</li> <li>Manage model versions</li> <li>Share your models</li> </ul> <h3>59 - Use AI Builder in Power Automate</h3> <ul> <li>AI Builder in Power Automate saves time</li> <li>Advanced usage of AI Builder in Power Automate</li> </ul> <h3>60 - Functional Consultant skills</h3> <ul> <li>Create entity relationship diagrams</li> <li>Create and document mock-ups</li> <li>Document functional requirements and artifacts</li> <li>Complete fit-gap analysis</li> <li>Discuss stakeholder management responsibilities</li> <li>Understand industry accelerators</li> <li>Define Application Lifecycle Management</li> <li>Participate in testing</li> <li>Evaluate options</li> <li>Define connectors</li> <li>Understand Power Apps component framework</li> </ul> <h3>61 - Solution Architect series: Plan application lifecycle management for Power Platform</h3> <ul> <li>Key considerations for ALM</li> <li>Solutions</li> <li>Configuration and reference data</li> <li>Release process</li> <li>ALM with Azure DevOps</li> </ul></div>

Duration
5 Days
30 CPD hours
This course is intended for

A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations.


This course will teach you to use Microsoft Power Platform solutions to simplify, automate, and empower business processes for organizations in the role of a Functional Consultant. A Microsoft Power Platform Functional Consultant is responsible for creating and configuring apps, automations, and solutions. They act as the liaison between users and the implementation team. The functional consultant promotes utilization of solutions within an organization. The functional consultant may perform discovery, engage subject matter experts and stakeholders, capture requirements, and map requirements to features. They implement components of a solution including application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and simple visualizations. This course may contain a 1-day Applied Workshop. This workshop will allow you to practice your Functional Consultant skills by creating an end-to-end solution to solve a problem for a fictitious company. The solution will include a Microsoft Dataverse database, Power Apps canvas app, and Power Automate flows.

Prerequisites


Experience as an IT professional or student
Working knowledge of Microsoft Power Platform and its key components
Knowledge of Microsoft Dataverse (or general data modeling) and security concepts


1 - Describe the business value of the Microsoft Power Platform
Explore Microsoft Power Platform
Describe the business value of the Power Platform
Explore connectors and Microsoft Dataverse
Describe how Power Platform works with Microsoft 365 apps and services
Explore how Power Platform works with Microsoft Teams
Describe how Power Platform works with Microsoft Dynamics 365 apps
Describe how Power Platform solutions consume Microsoft Azure services
Explore how Microsoft Power Platform apps work together
Use Artificial Intelligence to increase productivity
2 - Core components of Power Pages
Get started with Power Pages
Core tools and components of Power Pages
Overview of Power Pages security
Overview of Power Pages extensibility
3 - Explore Power Pages templates
Site design templates
Scenario-based templates
Dynamics 365 Power Pages site templates
4 - Explore Power Pages design studio
Work with pages
Page components
Site styling and templates
5 - Explore Power Pages design studio data and security features
Data workspace in Power Pages design studio
Power Pages security features
6 - Introduction to Power Pages administration
Power Pages administrative tools
Set up workspace in Power Pages design studio
7 - Get started building with Power BI
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
8 - Get data with Power BI Desktop
Overview of Power BI Desktop
Explore Power BI Desktop
Connect to data sources
Get data from Excel
Transform data to include in a report
Combine data from multiple sources
Clean data to include in a report
9 - Model data in Power BI
How to manage your data relationships
Create calculated columns
Optimize data models
Create measures
Create calculated tables
Explore time-based data
10 - Use visuals in Power BI
Create and customize simple visualizations
Create slicers
Map visualizations
Matrices and tables
Create scatter, waterfall, and funnel charts
Modify colors in charts and visuals
Page layout and formatting
11 - Explore data in Power BI
Quick insights in Power BI
Create and configure a dashboard
Ask questions of your data with natural language
Create custom Q&A suggestions
Share dashboards with your organization
Display visuals and tiles in full screen
Edit tile details and add widgets
Get more space on your dashboard
12 - Publish and share in Power BI
Publish Power BI Desktop reports
Print and export dashboards and reports
Introducing Power BI Mobile
Create workspaces in Power BI
Build apps
Use apps
Integrate OneDrive for Business with Power BI
Publish to web
13 - Create and manage workspaces in Power BI
Distribute a report or dashboard
Monitor usage and performance
Recommend a development life cycle strategy
Troubleshoot data by viewing its lineage
Configure data protection
14 - Manage semantic models in Power BI
Use a Power BI gateway to connect to on-premises data sources
Configure a semantic model scheduled refresh
Configure incremental refresh settings
Manage and promote semantic models
Troubleshoot service connectivity
Boost performance with query caching (Premium)
15 - Create dashboards in Power BI
Configure data alerts
Explore data by asking questions
Review Quick insights
Add a dashboard theme
Pin a live report page to a dashboard
Configure a real-time dashboard
Set mobile view
16 - Implement row-level security
Configure row-level security with the static method
Configure row-level security with the dynamic method
17 - Create tables in Dataverse
Table characteristics
Table relationships
Dataverse logic and security
Dataverse auditing
Dual-write vs. virtual tables
18 - Manage tables in Dataverse
Identify tables and table types in Dataverse
Create a custom table
Enable attachments within a table
Licensing requirements for each table type
19 - Create and manage columns within a table in Dataverse
Define columns in Microsoft Dataverse
Column types in Microsoft Dataverse
Add a column to a table
Create a primary name column
Restrictions that apply to columns in a table
Create an auto numbering column
Create an alternate key
20 - Create a relationship between tables in Dataverse
Relate one or more tables - Introduction
Relationship types that are available in Microsoft Dataverse
Create a one-to-many relationship between tables
Create a many-to-many relationship between tables
Edit or delete relationships
21 - Working with choices in Dataverse
Define choice column
Standard choices column
22 - Get started with security roles in Dataverse
Understand environment roles
Adding or disabling an environment user
Understand security concepts in Dataverse
Understand user security roles and security role defaults
Check the roles that a user belongs to
Configure Dataverse teams for security
Configure Dataverse group teams for security
23 - Use administration options for Dataverse
Use Microsoft Power Platform Admin Center portal
Tenant storage capacity
Advanced Customization options in Power Apps Portal
Enable and disable auditing
24 - Manage Dynamics 365 model-driven app settings and security
Configure role-based security
Manage teams and business units
Explore settings and customizations
25 - Introduction to Microsoft Power Platform security and governance
Identify Microsoft Power Platform environments
Data Loss Prevention policies
Microsoft Power Platform Center of Excellence Starter Kit
26 - Get started with model-driven apps in Power Apps
Introducing model-driven apps
Components of model-driven apps
Design model-driven apps
Incorporate business process flows
27 - Configure forms, charts, and dashboards in model-driven apps
Forms overview
Form elements
Configure multiple forms
Use specialized form components
Configure views overview
Configure grids
Create and edit views
Configure charts overview
Dashboards overview
Use interactive streams and tiles
28 - Get started with Power Apps canvas apps
Power Apps building blocks
Ways to build Power Apps
Power Apps related technologies
Additional Power Apps related technologies
Designing a Power Apps app
29 - Connect to other data in a Power Apps canvas app
Overview of the different data sources
Work with action-based data sources
Power Automate is a companion to Power Apps
30 - How to build the UI in a canvas app in Power Apps
Use themes to quickly change the appearance of your app
Branding a control
Icons
Images
Personalization
Using the tablet or phone form factors
31 - Manage apps in Power Apps
Power Apps review
32 - Build your first app with Power Apps and Dataverse for Teams
Create your first app with the hero template
Customize your app with Power Apps Studio
Publish your app
Install template apps
33 - Access Dataverse in Power Pages websites
Use lists to display multiple Dataverse records
Use forms to interact with Dataverse data
34 - Authentication and user management in Power Pages
Power Pages authentication settings
User registration in Power Pages
Authentication management for Power Pages users
Power Pages authentication providers
35 - Power Pages maintenance and troubleshooting
Power Pages website maintenance
Power Pages website troubleshooting
36 - Define and create business rules in Dataverse
Define business rules - Introduction
Define the components of a business rule
Create a business rule
37 - Get started with Power Automate
Introducing Power Automate
Troubleshoot flows
38 - Use the Admin center to manage environments and data policies in Power Automate
Administer flows
Export and import flows
Learn how to distribute button flows
39 - Use Dataverse triggers and actions in Power Automate
Dataverse triggers
Query data
Create, update, delete, and relate actions
40 - Extend Dataverse with Power Automate
Set up a flow and configure its trigger
Email Dataverse record
Add to-do items
Test and run your flow
41 - Introduction to expressions in Power Automate
Get started with expressions
Notes make things easier
Types of functions
Write complex expressions
42 - Build your first Power Automate for desktop flow
Set up the environment
Explore Power Automate for desktop
Create your first Power Automate for desktop flow
Record Power Automate for desktop actions
Edit and test recorded actions
43 - Run a Power Automate for desktop flow in unattended mode
Set up an unattended desktop flow
Create a new cloud flow that calls an existing flow in unattended mode
Perform a test run
Best practices
44 - Optimize your business process with process advisor
Get familiar with process advisor
Create your first recording
Edit recordings and group actions
Analyze recordings and interpret results
Automation recommendations
45 - Get started with Microsoft Copilot Studio bots
Get started working with environments
Create bots and work with the Microsoft Copilot Studio interface
Create topics
Test bots
Publish bots and analyze performance
46 - Enhance Microsoft Copilot Studio bots
Use Power Automate to add actions
Transfer conversations to agents by using Omnichannel for Customer Service
Create topics for existing support content
Analyze bot performance
47 - Manage topics in Microsoft Copilot Studio
Work with bot topics
Branch a topic
Create topics for existing support content
Work with system fallback topics
Manage topics
48 - Manage Power Virtual Agents
Environments in Microsoft Copilot Studio
Bot topics permissions
Bot entities and flow permissions
Monitor and diagnose
Administer and manage
Export and import bots
Authentication
49 - Get started building with Power BI
Use Power BI
Building blocks of Power BI
Tour and use the Power BI service
50 - Get data with Power BI Desktop
Overview of Power BI Desktop
Explore Power BI Desktop
Connect to data sources
Get data from Excel
Transform data to include in a report
Combine data from multiple sources
Clean data to include in a report
51 - Model data in Power BI
How to manage your data relationships
Create calculated columns
Optimize data models
Create measures
Create calculated tables
Explore time-based data
52 - Use visuals in Power BI
Create and customize simple visualizations
Create slicers
Map visualizations
Matrices and tables
Create scatter, waterfall, and funnel charts
Modify colors in charts and visuals
Page layout and formatting
53 - Explore data in Power BI
Quick insights in Power BI
Create and configure a dashboard
Ask questions of your data with natural language
Create custom Q&A suggestions
Share dashboards with your organization
Display visuals and tiles in full screen
Edit tile details and add widgets
Get more space on your dashboard
54 - Publish and share in Power BI
Publish Power BI Desktop reports
Print and export dashboards and reports
Introducing Power BI Mobile
Create workspaces in Power BI
Build apps
Use apps
Integrate OneDrive for Business with Power BI
Publish to web
55 - Manage solutions in Power Apps and Power Automate
Add and remove apps, flows, and entities in a solution
Edit a solution-aware app, flow, and table
Build and deploy a complex solution with flows, apps, and entities
Automate solution management
56 - Load/export data and create data views in Dataverse
View data in a table
Create or edit views of data in a table
Load data into a table
Export data from a table
Add, update, or delete data in a table by using Excel
Import data using Power Query
Generate a new dataflow from an Excel Template
Dataflow and Azure integration
57 - Get started with AI Builder
Choose an AI capability
Create your first model
Ways to use your models
58 - Manage models in AI Builder
Model lifecycle
Manage model versions
Share your models
59 - Use AI Builder in Power Automate
AI Builder in Power Automate saves time
Advanced usage of AI Builder in Power Automate
60 - Functional Consultant skills
Create entity relationship diagrams
Create and document mock-ups
Document functional requirements and artifacts
Complete fit-gap analysis
Discuss stakeholder management responsibilities
Understand industry accelerators
Define Application Lifecycle Management
Participate in testing
Evaluate options
Define connectors
Understand Power Apps component framework
61 - Solution Architect series: Plan application lifecycle management for Power Platform
Key considerations for ALM
Solutions
Configuration and reference data
Release process
ALM with Azure DevOps

Microsoft AZ-104

PL-200T00 Microsoft Power Platform Functional Consultant

<div id="course-pills-1">Duration<p>5 Days</p><p>30 CPD hours</p>This course is intended for<p>This course is designed for IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors.   This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles.</p>Overview<p>In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution.   You will:  - Prepare to deploy cloud solutions  - Deploy a pilot project  - Test a pilot project deployment  - Design a secure network for cloud deployment  - Determine CPU and memory sizing for cloud deployments  - Determine storage requirements for cloud deployments  - Plan Identity and Access Management for cloud deployments  - Analyze workload characteristics to ensure successful migration to the cloud  - Secure systems to meet access requirements  - Maintain cloud systems  - Implement backup, restore, and business continuity measures  - Analyze cloud systems for required performance  - Analyze cloud systems for anomalies and growth forecasting  - Troubleshoot deployment, capacity, automation, and orchestration issues  - Troubleshoot connectivity issues  - Troubleshoot security issues</p><p>In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions.</p></div><div id="course-pills-2"><h3>1 - PREPARING TO DEPLOY CLOUD SOLUTIONS</h3> <ul> <li>Describe Interaction of Cloud Components and Services</li> <li>Describe Interaction of Non-cloud Components and Services</li> <li>Evaluate Existing Components and Services for Cloud Deployment</li> <li>Evaluate Automation and Orchestration Options</li> <li>Prepare for Cloud Deployment</li> </ul> <h3>2 - DEPLOYING A PILOT PROJECT</h3> <ul> <li>Manage Change in a Pilot Project</li> <li>Execute Cloud Deployment Workflow</li> <li>Complete Post-Deployment Configuration</li> </ul> <h3>3 - TESTING PILOT PROJECT DEPLOYMENTS</h3> <ul> <li>Identify Cloud Service Components for Testing</li> <li>Test for High Availability and Accessibility</li> <li>Perform Deployment Load Testing</li> <li>Analyze Test Results</li> </ul> <h3>4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE</h3> <ul> <li>Design Cloud Infrastructure for Security</li> <li>Determine Organizational Compliance Needs</li> </ul> <h3>5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT</h3> <ul> <li>Design Virtual Network for Cloud Deployment</li> <li>Determine Network Access Requirements</li> <li>Secure Networks for Cloud Interaction</li> <li>Manage Cloud Component Security</li> <li>Implement Security Technologies</li> </ul> <h3>6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Identity Management and Authentication Technologies</li> <li>Plan Account Management Policies for the Network and Systems</li> <li>Control Access to Cloud Objects</li> <li>Provision Accounts</li> </ul> <h3>7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine CPU Size for Cloud Deployment</li> <li>Determine Memory Size for Cloud Deployment</li> </ul> <h3>8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS</h3> <ul> <li>Determine Storage Technology Requirements</li> <li>Select Storage Options for Deployment</li> <li>Determine Storage Access and Provisioning Requirements</li> <li>Determine Storage Security Options</li> </ul> <h3>9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION</h3> <ul> <li>Determine the Type of Cloud Deployment to Perform</li> <li>Manage Virtual Machine and Container Migration</li> <li>Manage Network, Storage, and Data Migration</li> </ul> <h3>10 - MAINTAINING CLOUD SYSTEMS</h3> <ul> <li>Patch Cloud Systems</li> <li>Design and Implement Automation and Orchestration for Maintenance</li> </ul> <h3>11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES</h3> <ul> <li>Back Up and Restore Cloud Data</li> <li>Implement Disaster Recovery Plans</li> <li>Implement Business Continuity Plans</li> </ul> <h3>12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE</h3> <ul> <li>Monitor Cloud Systems to Measure Performance</li> <li>Optimize Cloud Systems to Meet Performance Criteria</li> </ul> <h3>13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING</h3> <ul> <li>Monitor for Anomalies and Resource Needs</li> <li>Plan for Capacity</li> <li>Create Reports on Cloud System Metrics</li> </ul> <h3>14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES</h3> <ul> <li>Troubleshoot Deployment Issues</li> <li>Troubleshoot Capacity Issues</li> <li>Troubleshoot Automation and Orchestration Issues</li> </ul> <h3>15 - TROUBLESHOOTING CONNECTIVITY ISSUES</h3> <ul> <li>Identify Connectivity Issues</li> <li>Troubleshoot Connectivity Issues</li> </ul> <h3>16 - TROUBLESHOOTING SECURITY ISSUES</h3> <ul> <li>Troubleshoot Identity and Access Issues</li> <li>Troubleshoot Attacks</li> <li>Troubleshoot Other Security Issues</li> </ul></div><div id="course-pills-3"><h4>Additional course details:</h4><br /><p>Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. </p><p></p> This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. <p></p>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.  <p></p>While we feel this is the best course for the CompTIA Cloud Plus Certification (Exam CV0-003) 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.  <p></p>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.<p></p></div>

Duration
5 Days
30 CPD hours
This course is intended for
This course is designed for IT professionals who wish to develop cloud computing skills to enable them to move IT workloads to the cloud and integrate products and services from different providers and industries. Their focus is to ensure that cloud deployments are secure, that automation and orchestration are used effectively to bring business value from the cloud, and that costs are controlled through effective management of cloud vendors. This course is also designed for students who are preparing to take the CompTIA Cloud+ certification exam CV0-003, or who plan to use Cloud+ as the foundation for more advanced cloud certifications or career roles.
Overview
In this course, you will deploy, test, secure, manage, optimize, and troubleshoot a cloud solution. You will: - Prepare to deploy cloud solutions - Deploy a pilot project - Test a pilot project deployment - Design a secure network for cloud deployment - Determine CPU and memory sizing for cloud deployments - Determine storage requirements for cloud deployments - Plan Identity and Access Management for cloud deployments - Analyze workload characteristics to ensure successful migration to the cloud - Secure systems to meet access requirements - Maintain cloud systems - Implement backup, restore, and business continuity measures - Analyze cloud systems for required performance - Analyze cloud systems for anomalies and growth forecasting - Troubleshoot deployment, capacity, automation, and orchestration issues - Troubleshoot connectivity issues - Troubleshoot security issues
In this course, you will learn how to implement, maintain, and deliver cloud technologies including network, storage, and virtualization technologies to create cloud solutions.
1 - PREPARING TO DEPLOY CLOUD SOLUTIONS
Describe Interaction of Cloud Components and Services
Describe Interaction of Non-cloud Components and Services
Evaluate Existing Components and Services for Cloud Deployment
Evaluate Automation and Orchestration Options
Prepare for Cloud Deployment
2 - DEPLOYING A PILOT PROJECT
Manage Change in a Pilot Project
Execute Cloud Deployment Workflow
Complete Post-Deployment Configuration
3 - TESTING PILOT PROJECT DEPLOYMENTS
Identify Cloud Service Components for Testing
Test for High Availability and Accessibility
Perform Deployment Load Testing
Analyze Test Results
4 - DESIGNING A SECURE AND COMPLIANT CLOUD INFRASTRUCTURE
Design Cloud Infrastructure for Security
Determine Organizational Compliance Needs
5 - DESIGNING AND IMPLEMENTING A SECURE CLOUD ENVIRONMENT
Design Virtual Network for Cloud Deployment
Determine Network Access Requirements
Secure Networks for Cloud Interaction
Manage Cloud Component Security
Implement Security Technologies
6 - PLANNING IDENTITY AND ACCESS MANAGEMENT FOR CLOUD DEPLOYMENTS
Determine Identity Management and Authentication Technologies
Plan Account Management Policies for the Network and Systems
Control Access to Cloud Objects
Provision Accounts
7 - DETERMINING CPU AND MEMORY SIZING FOR CLOUD DEPLOYMENTS
Determine CPU Size for Cloud Deployment
Determine Memory Size for Cloud Deployment
8 - DETERMINING STORAGE REQUIREMENTS FOR CLOUD DEPLOYMENTS
Determine Storage Technology Requirements
Select Storage Options for Deployment
Determine Storage Access and Provisioning Requirements
Determine Storage Security Options
9 - ANALYZING WORKLOAD CHARACTERISTICS TO ENSURE SUCCESSFUL MIGRATION
Determine the Type of Cloud Deployment to Perform
Manage Virtual Machine and Container Migration
Manage Network, Storage, and Data Migration
10 - MAINTAINING CLOUD SYSTEMS
Patch Cloud Systems
Design and Implement Automation and Orchestration for Maintenance
11 - IMPLEMENTING BACKUP, RESTORE, DISASTER RECOVERY, AND BUSINESS CONTINUITY MEASURES
Back Up and Restore Cloud Data
Implement Disaster Recovery Plans
Implement Business Continuity Plans
12 - ANALYZING CLOUD SYSTEMS FOR PERFORMANCE
Monitor Cloud Systems to Measure Performance
Optimize Cloud Systems to Meet Performance Criteria
13 - ANALYZING CLOUD SYSTEMS FOR ANOMALIES AND GROWTH FORECASTING
Monitor for Anomalies and Resource Needs
Plan for Capacity
Create Reports on Cloud System Metrics
14 - TROUBLESHOOTING DEPLOYMENT, CAPACITY, AUTOMATION, AND ORCHESTRATION ISSUES
Troubleshoot Deployment Issues
Troubleshoot Capacity Issues
Troubleshoot Automation and Orchestration Issues
15 - TROUBLESHOOTING CONNECTIVITY ISSUES
Identify Connectivity Issues
Troubleshoot Connectivity Issues
16 - TROUBLESHOOTING SECURITY ISSUES
Troubleshoot Identity and Access Issues
Troubleshoot Attacks
Troubleshoot Other Security Issues
Additional course details:
Nexus Humans CompTIA Cloud Plus Certification (Exam CV0-003) 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 CompTIA Cloud Plus Certification (Exam CV0-003) 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.


CompTIA Network+

Cloud Architecture

Certified Cloud Security Professional (CCSP)

AWS Certified Cloud Practitioner

CompTIA A+

CompTIA Security+

CompTIA Cloud+

<article id="cincluded">
					<div>
						<h5>SQL Course Summary.</h5>
					</div>
					<div></div>
					<p>
						
						<br />Practical SQL course, to leavy you full conversant with queries, DML and DDL statements.
						<br />Hands-on, Practical SQL course. 
						<br />PCWorkshops SQL Course Certificate.
						<br />Max 4 people per course, we keep it personalised. 
						
				  	</p>
	    		</article>

<div id="#">
							<div>
								<h5>Where is the SQL Course?</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>Online: </b>Instructor-led.</li>
									 <li><b>Classroom: </b>Request per email.</li> 
								</ul>
								</div>
							</article>
						</div>
						
					   	<div id="#">
							<div>
								<h5>SQL Course Materials</h5>
							</div>
							<article>
								<div>
								<ul>  
									 <li><b>SQL Coding Examples </b>   </li>
									 <li><b>SQL Course Manuals and Notes: </b>In-depth reference materials </li>
									 <li><b>Exercises:</b> Practical exercises  </li> 
								</ul>
								</div>
							</article>
						</div>
						 
						
						<div id="#">
							<div>
								<h5>Payment Options</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>→  £750, Follow the booking link </li>	 
									<li>Arrange for installments</li>
								</ul>
								</div>
							</article>
						</div>
						
						<div id="#">
							<div>
								<h5>Included with SQL Course:</h5>
							</div>
							<article>
								<div>
								<ul>
									<li>SQL Course Certificate on completion.
									</li><li>SQL Course Manual.
									</li><li>Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
									</li><li>After the course, 1 free session for questions.
									</li><li>Max group size, online and in classroom, on this SQL Course is 4.</li>
								</ul>
								</div>
							</article>
						</div>
						

			   	<div id="cdetails">
					<div>
						<h5>Course Details</h5>
					</div>
					<article>
						<div>
							<h5>SQL Intermediate Course summary</h5>
						</div>
						<div></div>
						<div>
					 	<ul>
					    	 <br /><br /><b><li>DAY 1:</li></b>
						    <li><b>Session 1: </b>Database Concepts
							 
							<br />What is a database? 
							<br />Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema

							</li>	<li><b>Session 2: </b>Using the SQL client
							SQL Getting started and Logging in, Selecting a database, 
							Client commands, Entering and executing SQL statements, 
							Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, 
							Command line execution of SQL Scripts

							</li><li><b>Session 3: </b>Basic SQL SELECT statement
							<br />The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions.  
							<br />Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators.
							<br />Column aliases.
							<br />Arithmetic expressions.
							<br />Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce').
							<br />The ORDER BY clause.
							
							
							</li><li><b>Session 4:</b> 
							<br />LIMIT / TOP  and Distinct Queries 
							<br />SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
							<br />Group By, 
							<br />Rollup with Group By, 
							<br />Having.
							</li>
							<li><b>Session 5:</b> Joins
							<br />SQL Cartesian products.
							<br />SQL Joins (Inner join, Left join, Right join, Full join).
							<br />Table aliases.
							<br />Natural joins, Multi-table joins.
							<br />Union, Union All queries.
							<br />Except/Minus, Simulating join with Intersect.
							</li>
							<br /><br /><b><li>DAY 2:</li></b>
							<li><b>Session 6:</b>
							<br />SQL Subqueries, Nested Subqueries, 
							<br />Correlated and uncorrelated subqueries. 
							<br />Global and Local Temp Tables.
							</li>
							<li><b>Session 7:</b>
							SQL Built-in Functions: <br />Numeric Functions (ABS, SIGN, MOD, etc.)
							<br />and String Functions (Locate, Left, Right, Concat, etc),
							<br />DATE and TIME functions.
							</li>
							<li><b>Session 8:</b>
							SQL Views (Create, alter and drop), 
							<br />Stored Procedures (Create, alter and drop, Input and Output parameters);
							<br /> Custom Functions (Create, alter and drop).
							</li>
							<br /><br /><b><li>DAY 3:</li></b>
							<li><b>
							Session 9: </b>Managing Data
							<br />Inserting rows, Replacing rows, Updating rows, Deleting rows,
<br />							The truncate statement, 
<br />The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
							</li>
							<li><b>
							Session 10:</b>
							SQL Indexes (Create, alter and drop).
							</li>
							<li><b>
							Session 11:</b>
							<br />Creating Databases and Tables (Create, alter and drop); <br />Constraints (Add, alter and drop).
							</li>
							<li><b>
							Session 12:</b>
							<br />Import data into SQL and Export from SQL.
							<br />Exporting using SQL, Importing using SQL.
														</li> 
							
							
						</ul>
						</div>
					</article>
				</div>

		<div> 
						 

						
				     
	                  <div></div>
 		</div>
	                
				     
				   <div id="booking">
	                  <div>
	                     <h5>Book the SQL Course</h5>
	                  </div>
							 
							 
<div id="eventbrite-widget-container-12009778571"></div>




					 
							 
							 
	               </div>
				   <div id="#">
	                  <div>
	                     <h5>About us</h5>
	                  </div>



	                  	<article>
					    <div>
					    	<div>
					    		<div>
					    			
					    			<h5>Our experienced trainers are award winners. </h5> 
					    			<ul>
										<li>
											More about us
										</li>
										<li>
											FAQ's
										</li>
										<li>
											Client Comments  
										</li>
										<li>
										<div id="LTF_ST_7KBtchhl8SMxqQ8TquAE3BxAGh2waJl4jxQdXEubLKJcmvn6ak"></div>
										</li>	
									 </ul>
					    		</div>
					    		<div>
					    			
					    				
					    			
					    		</div>
					    	</div>
	                     
					    </div>
					    </article>						
	               </div>

SQL Course Intermediate 
 
This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements.  Hands-on, Practical SQL course.  
You will get the PCWorkshops SQL Course Certificate. 
Max 4 people per course, to keep it personalised. 
Where is the SQL Course?
Online: Instructor-led.
Classroom: Request per email.
SQL Course Materials
SQL Coding Examples
SQL Course Manuals and Notes: In-depth reference materials
Exercises: Practical exercises
Included with SQL Intermediate Course:
SQL Course Certificate on completion.
SQL Course Manual.
Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.
After the course, 1 free session for questions.
Max group size, online and in classroom, on this SQL Course is 4.
SQL Intermediate Course summary
DAY 1:
Session 1: Database Concepts 
What is a database? 
Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema
Session 2: Using the SQL client SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts
Session 3: Basic SQL SELECT statement 
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions. 
Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators. 
Column aliases. 
Arithmetic expressions. 
Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce'). 
The ORDER BY clause.
Session 4: 
LIMIT / TOP and Distinct Queries 
SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count), 
Group By, 
Rollup with Group By, 
Having.
Session 5: Joins 
SQL Cartesian products. 
SQL Joins (Inner join, Left join, Right join, Full join). 
Table aliases. 
Natural joins, Multi-table joins. 
Union, Union All queries. 
Except/Minus, Simulating join with Intersect.
DAY 2:
Session 6: 
SQL Subqueries, Nested Subqueries, 
Correlated and uncorrelated subqueries. 
Global and Local Temp Tables.
Session 7: SQL Built-in Functions: 
Numeric Functions (ABS, SIGN, MOD, etc.) 
and String Functions (Locate, Left, Right, Concat, etc), 
DATE and TIME functions.
Session 8: SQL Views (Create, alter and drop), 
Stored Procedures (Create, alter and drop, Input and Output parameters); 
 Custom Functions (Create, alter and drop).
DAY 3:
Session 9: Managing Data 
Inserting rows, Replacing rows, Updating rows, Deleting rows,

 The truncate statement, 
The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.
Session 10: SQL Indexes (Create, alter and drop).
Session 11: 
Creating Databases and Tables (Create, alter and drop); 
Constraints (Add, alter and drop).
Session 12: 
Import data into SQL and Export from SQL. 
Exporting using SQL, Importing using SQL.
 
About us

Our SQL Intermediate trainers are experienced award winners.
13 years in business
We keep it practical and customised

Oracle SQL

Azure SQL Database

Microsoft SQL Server

Microsoft SQL

Computer Skills

SQL Server

MySQL

This Practical SQL course, is designed make you fully conversant with queries, DML and DDL statements.  Hands-on, Practical SQL course.  
You will get the PCWorkshops SQL Course Certificate. 
Max 4 people per course, to keep it personalised. 

SQL Intermediate Course, 3 Days

<h3 style="color: rgb(0, 0, 0); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">KNOW THE RULES! POOR GRAMMAR SHOWS A LACK OF ATTENTION TO DETAIL AND ULTIMATELY CAN SLOW DOWN COMMUNICATIONS AS WELL AS PRODUCTIVITY.</h3><div style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style=" color: rgb(33, 37, 41);"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><b fr-original-style="" style="box-sizing: border-box;">Business people who know grammar judge others based on their correct (or incorrect) usage.</b>&nbsp;Be the professional who is able to be clear and correct in writing.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><b fr-original-style="" style="box-sizing: border-box;">Business Grammar &amp; Usage: ENGLISH BOOT CAMP is the answer for today&rsquo;s business competitive environment.</b>&nbsp;Interactive instruction and collaboration with your fellow attendees means that you will master the skills and apply your new knowledge to the classroom exercises and activities. When you return to work, you&rsquo;ll have new confidence about what is right and wrong, when it comes to writing.</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><b fr-original-style="" style="box-sizing: border-box;">Attendees Will Be Able To:</b></p><ul fr-original-style="" style="box-sizing: border-box;"><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Know the Parts of Speech and their correct uses;</strong></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Understand Sentence Structure, including applying rules for Subject-Verb and Pronoun-Antecedent Agreement;</strong></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Be able to create Plurals and Possessives accurately and with certainty;</strong></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Review and use the rules of Spelling, Mechanics (Capitalization, Abbreviation, Number Use), and Punctuation;</strong></li><li style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Create original email / documents to employ newly-learned class material.</strong></li></ul><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">&nbsp;</p><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);"><i style="color: rgb(0, 0, 0); box-sizing: border-box;" fr-original-style=" color: rgb(0, 0, 0);">Online Format&mdash;<strong fr-original-style="" style="font-weight: 700; box-sizing: border-box;">Business Grammar and Usage</strong> is a 4-hour interactive virtual class for up to ten people.</i></p><h6 style="color: inherit; box-sizing: border-box;" fr-original-style=" color: inherit;">Register for this class and you will be sent ONLINE login instructions prior to the class date.</h6></div><hr fr-original-style="" style="border-color: var(--border-muted); border-style: solid; clear: both; break-after: page; user-select: none; box-sizing: border-box;"><p style="color: rgb(0, 0, 0); font-size: var(--font-size); box-sizing: border-box;" id="isPasted" fr-original-style=" color: rgb(0, 0, 0);">It was great to have the opportunity to learn some new techniques and to gain more awareness of how I present myself. The most immediately applicable uses have been in reducing my &ldquo;ums&rdquo; and &ldquo;ahs&rdquo; and in trying to come to my point in a more succinct way. I&rsquo;ve been cultivating this awareness in one-on-one settings; meetings and individual conversations.</p><span style="color: rgb(33, 37, 41); box-sizing: border-box;" fr-original-style="color: rgb(33, 37, 41);">Christina Vargas</span>

KNOW THE RULES! POOR GRAMMAR SHOWS A LACK OF ATTENTION TO DETAIL AND ULTIMATELY CAN SLOW DOWN COMMUNICATIONS AS WELL AS PRODUCTIVITY.
Business people who know grammar judge others based on their correct (or incorrect) usage. Be the professional who is able to be clear and correct in writing.
Business Grammar & Usage: ENGLISH BOOT CAMP is the answer for today’s business competitive environment. Interactive instruction and collaboration with your fellow attendees means that you will master the skills and apply your new knowledge to the classroom exercises and activities. When you return to work, you’ll have new confidence about what is right and wrong, when it comes to writing.
Attendees Will Be Able To:
Know the Parts of Speech and their correct uses;
Understand Sentence Structure, including applying rules for Subject-Verb and Pronoun-Antecedent Agreement;
Be able to create Plurals and Possessives accurately and with certainty;
Review and use the rules of Spelling, Mechanics (Capitalization, Abbreviation, Number Use), and Punctuation;
Create original email / documents to employ newly-learned class material.
 
Online Format—Business Grammar and Usage is a 4-hour interactive virtual class for up to ten people.
Register for this class and you will be sent ONLINE login instructions prior to the class date.



It was great to have the opportunity to learn some new techniques and to gain more awareness of how I present myself. The most immediately applicable uses have been in reducing my “ums” and “ahs” and in trying to come to my point in a more succinct way. I’ve been cultivating this awareness in one-on-one settings; meetings and individual conversations.
Christina Vargas

23269 Courses

The Ultimate Guide to Event Planning - 1 Day Workshop in Burton Upon Trent

By Mangates

Her Biz: Free Women's Start-up Programme (Kent & E.Sussex) - Jan/Feb 2025

By Let’s Do Business Group

Building Better Careers with Soft Skills: 1-Day Workshop in Bournemouth

By Mangates

Building Better Careers with Soft Skills: 1-Day Workshop in Cork

By Mangates

Building Better Careers with Soft Skills: 1-Day Workshop in Norwich

By Mangates

Building Better Careers with Soft Skills: 1-Day Workshop in Heathrow

By Mangates

Building Better Careers with Soft Skills: 1-Day Workshop in Stoke-on-Trent

By Mangates

Mastering Management Fundamentals

By DCo - The Development Company UK Ltd

Conflict Management 1 Day Training in Chorley

By Mangates

Conflict Management 1 Day Training in Brighton

By Mangates

Search By Location