9808 Office courses

Duration 2 Days 12 CPD hours This course is intended for This course is intended for SQL Server administrators who work in a Windows network environment. At least one year of experience administering SQL Servers and using PowerShell is recommended. Overview After completing this course, students will be able to: •Install and Configure SQL Server and all its components using PowerShell •Manage day-to-day SQL Server Administration with PowerShell •Maintain the SQL Server environment using PowerShell scripting and programming options This course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. Install and Configure SQL Server with PowerShell Install SQL Server Configure Database Settings Configure SQL Server Settings Configure SQL Server Policy-Based Management Lab 1: Configuring SQL Server with PowerShell Administering SQL Servers with PowerShell Managing Users and Roles Managing Database Performance Managing Database Availability Managing SQL Server Features Lab 1: Administering SQL Servers with PowerShell Maintaining SQL Server with PowerShell Managing Backups and Restores Maintaining Database Integrity and Performance Monitoring and Auditing Task Automation Generating Reports Lab 1: Maintaining SQL Servers with PowerShell

Duration 5 Days 30 CPD hours This course is intended for This course is intended for IT Professionals who are already experienced in general Windows Server and Windows Client administration, and who want to learn more about using Windows PowerShell for administration. No prior experience with any version of Windows PowerShell, or any scripting language, is assumed. This course is also suitable for IT Professionals already experienced in server administration, including Exchange Server, SharePoint Server, SQL Server, System Center, and others. Overview After completing this course, students will be able to:Describe the functionality of Windows PowerShell and use it to run and find basic commands.Identify and run cmdlets for server administration.Work with Windows PowerShell pipeline.Describe the techniques Windows PowerShell pipeline uses.Use PSProviders and PSDrives to work with other forms of storage.Query system information by using WMI and CIM.Work with variables, arrays, and hash tables.Write basic scripts in Windows PowerShell.Write advanced scripts in Windows PowerShell.Administer remote computers.Use background jobs and scheduled jobs.Use advanced Windows PowerShell techniques. This course provides students with the fundamental knowledge and skills to use Windows PowerShell for administering and automating administration of Windows based servers. Getting Started with Windows PowerShell Overview and Background Understanding command syntax Finding commands Lab : Configuring Windows PowerShell Lab : Finding and Running Basic Commands Cmdlets for administration Active Directory administration cmdlets Network configuration cmdlets Other server administration cmdlets Lab : Windows Administration Working with the Windows PowerShell pipeline Understanding the Pipeline Selecting, Sorting, and Measuring Objects Filtering Objects Out of the Pipeline Enumerating Objects in the Pipeline Sending pipeline data as output Lab : Using the Pipeline Lab : Filtering Objects Lab : Enumerating Objects Lab : Sending output to a file Understanding How the Pipeline Works Passing the pipeline data Advanced considerations for pipeline data Lab : Working with Pipeline Parameter Binding Using PSProviders and PSDrives Using PSProviders Using PSDrives Lab : Using PSProviders and PSDrives Querying Management Information by Using WMI and CIM Understanding WMI and CIM Querying Data with WMI and CIM Making changes with WMI/CIM Lab : Working with WMI and CIM Working with variables, arrays, and hash tables Using variables Manipulating variables Manipulating arrays and hash tables Lab : Working with variables Basic scripting Introduction to scripting Scripting constructs Importing data from files Lab : Basic scripting Advanced scripting Accepting user input Overview of script documentation Troubleshooting and error handling Functions and modules Lab : Accepting data from users Lab : Implementing functions and modules Administering Remote Computers Using basic Windows PowerShell remoting Using advanced Windows PowerShell remoting techniques Using PSSessions Lab : Using basic remoting Lab : Using PSSessions Using Background Jobs and Scheduled Jobs Using Background Jobs Using Scheduled Jobs Lab : Using Background Jobs and Scheduled Jobs Using advanced Windows PowerShell techniques Creating profile scripts Using advanced techniques Lab : Practicing advanced techniques Lab : Practicing script development (optional)

Struggling with time management? Learn practical strategies to maximise productivity and achieve balance in work, life, and everything in between.

Dive deep into the nuances of workplace dynamics with our course titled 'Addressing Absenteeism and Tardiness in the Workplace'. This comprehensive curriculum enlightens you on the intricacies of attendance challenges, their root causes, and their implications on business performance. Delve into the myriad strategies to manage, measure, and evaluate these issues whilst being mindful of legal and ethical considerations. Further, equip yourself with cutting-edge technology and tools to simplify your approach. By the culmination, you'll be adept at fostering a culture that prioritises accountability and well-being, ensuring a harmonious and productive workspace for all. Learning Outcomes Understand the fundamentals of absenteeism and tardiness in a professional setting. Analyse the primary reasons leading to these challenges and their subsequent impact on business. Formulate and apply measures to effectively manage and assess attendance issues. Familiarise with legal guidelines and ethical standpoints related to employee attendance. Incorporate technology to streamline processes, reinforcing a culture of responsibility and holistic well-being. Why buy this Addressing Absenteeism and Tardiness in the Workplace? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Addressing Absenteeism and Tardiness in the Workplace there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Addressing Absenteeism and Tardiness in the Workplace course for? Human Resources managers aiming to enhance workplace productivity. Team leaders or supervisors focusing on team harmony and accountability. Business owners desiring a proactive approach to staff attendance. Consultants or advisers specialising in workplace culture and behaviour. Professionals keen on understanding the role of technology in attendance management. Prerequisites This Addressing Absenteeism and Tardiness in the Workplace does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Addressing Absenteeism and Tardiness in the Workplace was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path HR Manager: £40,000 - £60,000 Annually Team Supervisor: £30,000 - £45,000 Annually Business Owner: Salaries vary depending on business scale and success. Workplace Culture Consultant: £45,000 - £65,000 Annually Attendance Systems Analyst: £35,000 - £50,000 Annually Organisational Behaviour Specialist: £40,000 - £55,000 Annually Course Curriculum Module 01: Introduction to Absenteeism and Tardiness Introduction to Absenteeism and Tardiness 00:11:00 Module 02: Causes of Absenteeism and Tardiness Causes of Absenteeism and Tardiness 00:11:00 Module 03: Effects of Absenteeism and Tardiness on the Workplace Effects of Absenteeism and Tardiness on the Workplace 00:12:00 Module 04: Strategies for Managing Absenteeism and Tardiness Strategies for Managing Absenteeism and Tardiness 00:15:00 Module 05: Measurement and Evaluation of Absenteeism and Tardiness Measurement and Evaluation of Absenteeism and Tardiness 00:12:00 Module 06: Legal and Ethical Considerations Legal and Ethical Considerations 00:15:00 Module 07: Proactive Strategies for Prevention Proactive Strategies for Prevention 00:19:00 Module 08: Technology and Tools Technology and Tools 00:21:00 Module 09: Building a Culture of Accountability and Well-being Building a Culture of Accountability and Well-being 00:14:00

Learn the art of effective email communication and how to write emails that grab attention, convey your message clearly, and get the desired response. With modules covering the fundamentals of writing effective emails, managing your inbox, writing styles and tone, and more, you'll gain the skills you need to succeed in today's fast-paced business world. The world of business is constantly evolving, and with it comes a growing demand for effective communication. In today's digital age, email is the go-to form of communication in the business world, with over 306 billion emails sent and received every day. As a result, there are numerous opportunities available in the field of email writing. Learning Outcomes: Understand the principles of effective email communication Learn to write clear, concise, and compelling emails Develop strategies for managing your inbox and staying organised Discover different writing styles and how to adapt your tone to different situations Learn tips and tricks for writing effective emails Understand the importance of exercising caution when sending emails In today's digital age, email is the go-to form of communication in the business world. However, with so many emails flooding our inboxes, it can be challenging to stand out from the crowd. That's where our Email Writing course comes in. Our course covers all the essential aspects of effective email writing, from understanding the fundamentals of email communication to developing strategies for managing your inbox and staying organised. Through a series of modules, you'll learn the art of crafting clear, concise, and compelling emails that get results. You'll explore different writing styles and tone, discover tips and tricks for writing effective emails, and understand the importance of exercising caution when sending emails. Whether you're a business professional looking to improve your communication skills or someone looking to enter the recruitment field, our Email Writing course is for you. So, enrol today and take the first step towards mastering the art of effective email communication. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Business professionals looking to improve their email writing skills Individuals looking to enter the recruitment field Anyone who wants to improve their communication skills Students who want to enhance their writing skills Career path Recruitment Consultant: £22,000 - £45,000 HR Manager: £25,000 - £75,000 Marketing Manager: £25,000 - £70,000 Sales Executive: £18,000 - £40,000 Customer Service Representative: £16,000 - £28,000 Executive Assistant: £20,000 - £45,000

An interactive workshop with Karen Hale. Learn how to gain the confidence, skills and techniques to speak up so you can be heard. "There are two types of speakers: Those who get nervous and those who are liars." - Mark Twain Is this you? Promotions not applied for, jobs roles not tried for, networking events not attended? Parties avoided, family ceremonies not spoken at, too much left unsaid? Do you have excellent ideas that get lost in time because you are fearful of voicing them. Have you missed opportunities because it involves showing up? Do you stay silent in meetings? Do you have a brilliant business idea that isn’t being pursued because you know it will involve some kind of networking or public speaking? If the answer to any/most of these is YES, then read on... This workshop is strange by its nature. Why would someone who disliked public speaking, go to a place where they would speak in public? This is why.... Because Karen has analysed what makes a good communicator when speaking informally to people; she has taken those aspects and developed a group of exercises that allows you to use these exact techniques when speaking at networking events and in public. Added to that, Karen provides a smorgasbord of methods on how to control nerves to ensure you communicate at your authentic best. Please note: everybody in the room will be there for the same reason as you! You will be supported and encouraged and will learn how to turn fear into empowerment! About Karen: An empowerment and public speaking coach with over 30 years experience in coaching and advising individuals and business leaders from a diverse range of sectors on effective communication skills. It takes a second to form a first impression about a person. Your body language, clothes, speech and personal presence convey messages about your background, skills and expertise. Karen works with her clients to ensure they make that first impression powerful and authentic so they get remembered for the right reasons. By creating a confident and authentic presence you increase your visibility and your credibility. “Karen is a truly special individual. She made me feel totally at ease and was able to help me stand and speak confidently for the first time and she did that all with huge warmth and a lot of humour.” She fulfils her greatest passion on a daily basis, helping people present themselves to the outside world in the very best way. She has enabled hundreds of people to move on in their life and careers and build their growth, confidence and image. Karen works across a huge spectrum - from CEOs in FTSE 100 companies to Foundation Class university students at UAL coaching presentation skills. She coaches senior individuals and consults to leading global banks, private banks and family offices, advising business leaders and their teams. She is Central School of Speech and Drama trained. Kind words about Karen... I have had the absolute pleasure of working with Karen numerous times over the past 16 years to assist me in my various corporate roles. Karen has always been the person I have turned to first and foremost when I have needed help with my personal brand, presence and communication, helping me develop confidence in public speaking and showing up in front of the camera. A HUGE thank you for Monday – you were wonderful. The feedback we have had has been unbelievable – I can honestly say in all my years in this industry I have never heard such positive comments on every aspect. Karen has an incredible gift of making you feel completely at ease and is able to bring the best out of a person with ease. She is friendly, approachable and warm and I now refer Karen to everybody I know who needs assistance with any type of public speaking, communication and confidence requirement. The results speak for themselves. Highly recommend! You can contact Karen at: https://www.linkedin.com/in/karen-hale-8925862b/ / 07956626740 For any questions regarding this event, please contact the organiser lara@themotivationclinic.co.uk / 07817247727 - thank you!

Overview: Ensure you are fully trained and competent in Food Hygiene to handle food and deliver meals that are entirely free from contaminants. This course has been designed to train food handlers and catering staff in Food Hygiene, effectively storing and preparing food while keeping it fresh for customers. The Food Hygiene and Safety Level 2 course, sometimes known as 'Food Safety Level 2', delivers a masterclass on the essential aspects of Food Hygiene, which are crucial for hospitality or catering staff. This Food Hygiene course forms the basis of UK food legislation and ensures that customers are entitled to consume food free from any type of hazard or risk. Mastering Food Hygiene is essential for anyone involved in the preparation, handling, or serving of food. The knowledge and skills gained in this Food Hygiene course will empower you to maintain the highest standards of cleanliness and safety. With a focus on practical applications, this Food Hygiene training ensures that you are not just learning theory but are also capable of applying Food Hygiene principles in important scenarios. Enrol today to elevate your Food Hygiene capabilities and make a lasting impression in the food industry, ensuring that every meal you serve meets the highest Food Hygiene standards. By completing this Food Hygiene course, you will be well-equipped to protect public health and uphold the integrity of your establishment. Key Features of the Food Hygiene Course: FREE Food Hygiene CPD-accredited certificate Get a free student ID card with Food Hygiene training (£10 applicable for international delivery) Lifetime access to the Food Hygiene course materials The Food Hygiene program comes with 24/7 tutor support Get instant access to this Food Hygiene course Learn Food Hygiene training from anywhere in the world The Food Hygiene training is affordable and simple to understand The Food Hygiene training is entirely online Enrol in Food Hygiene today and start your journey to become successful! How will I get my Food Hygiene certificate? You may have to take a quiz or a written test online during or after the Food Hygiene course. After successfully completing the Food Hygiene course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Food Hygiene and Safety Level 2. It is available to all students, of all academic backgrounds. Requirements Our Food Hygiene and Safety Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this Food Hygiene course, it can be studied in your own time at your own pace. Career path Completing the Food Hygiene Level 2 course can lead to a variety of career opportunities in the food industry, including roles such as: Food Safety Officer Quality Assurance Inspector Food Production Manager Catering Manager Restaurant Manager Environmental Health Officer Food Safety Consultant Course Curriculum 1 sections • 10 lectures • 04:14:00 total length •Introduction to Food Safety and the Law: 00:29:00 •Bacteria and Microbiological Hazards: 00:27:00 •Physical, Chemical and Allergenic Hazards: 00:25:00 •Food Poisoning and Control Measures: 00:23:00 •Food Spoilage and Food Storage: 00:25:00 •Personal Hygiene: 00:24:00 •HACCP and Food Premises Part 01: 00:38:00 •HACCP and Food Premises Part-02: 00:28:00 •Cleaning: 00:20:00 •Reopening and Adapting Your Food Business during COVID-19: 00:15:00

Property administrators are responsible for managing the administrative side of running a property. The job includes property maintenance, showing prospective tenants around a property, collecting rent and paying contractors. This Property Administrator Training course explores the skills and knowledge required for this role, with an introduction to the real estate industry. Throughout this course, you will learn about the day in the life of a property administrator, with step-by-step training on how to perform viewings, negotiate property prices and carry out a valuation. You will also develop the skills to build excellent relationships with tenants, including handling their complaints in a professional manner. Your Learning Goals: Learn about the role of a property administrator and the key responsibilities Understand the laws and regulations surrounding property management Develop crucial multi-tasking, negotiating, problem-solving & customer service skills Be able to deal with all types of tenants in a professional and neutral manner Familiarise with the different types of lettings agents and estate agents Build solid relationships with project managers and contractors Explore the sales progression process from start to completion Discover marketing strategies for promoting your company's services Who is This Course for? This course is suitable for those who are considering a career in the administrative sector of the real estate industry. This Property Administrator Training course is a beginners training course, ideal for those who are not yet in a property administrator role. Method of Assessment: Upon completion of the course, you will be required to sit for an online multiple-choice quiz based assessment, which will determine whether you have passed the course (60% pass mark). The test will be marked immediately and results will be published instantly. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99 Career Path On successful completion, learners will be equipped with the skills and knowledge to kickstart a career in real estate. Related roles in this field include: Property Administrator Property/Lettings Negotiator Assistant Lettings Manager Estate Agent Course Curriculum Property Administrator Training - Updated Version Module 1 - Estate Agent: An Introduction 00:21:00 Module 2 - Different Types of Estate Agents 00:16:00 Module 3 - Getting Started on the Job 00:16:00 Module 4 - Listing Property: Finding the Sellers 00:24:00 Module 5 - Valuation Process 00:21:00 Module 6 - Negotiating As an Estate Agent 00:13:00 Module 7 - Selling Property: Finding the Buyers 00:23:00 Module 8 - Letting Property 00:31:00 Module 9 - Technology for Estate Agents 00:22:00 Module 10 - Regulation of Estate Agents 00:14:00 Mock Exam Mock Exam- Property Administrator Training 00:20:00 Final Exam Final Exam- Property Administrator Training 00:20:00 Property Administrator Training - Old Version Estate Agent Module 1: What is Estate Agent 00:15:00 Module 2: Requirements for the Job 00:20:00 Module 3: History of the Estate Agent 00:20:00 Module 4: The Real Estate Industry 00:15:00 Module 5: Different Types of Estate Agents 00:15:00 Module 6: Online Estate Agents 00:20:00 Module 7: Estate agent Fees and Contracts 00:30:00 Module 8: Pros and Cons of Hiring an Estate Agent 00:20:00 Module 9: Getting to Know Your Clients 00:20:00 Module 10: A Day in the Life of an Estate Agent 00:15:00 Module 11: Selling Property with an Estate Agent 00:15:00 Module 12: Property Marketing 00:15:00 Module 13: The Regulations for Estate Agent Boards and Why It is Important 00:15:00 Module 14: Valuation 00:20:00 Module 15: Performing Viewings 00:15:00 Module 16: Negotiating 00:30:00 Module 17: Buying with an Estate Agent 00:20:00 Module 18: Sales Progression 00:30:00 Module 19: Technology 00:25:00 Module 20: Investment Property 00:40:00 Module 21: About Letting Agents 00:25:00 Module 22: Property Management 00:15:00 Module 23: Laws and Regulations 00:30:00 Module 24: How to Set Up an Estate Agency 00:15:00 Property Manager Module 25: Property Development and the Process 00:45:00 Module 26: Main Actors and Economic Context 01:00:00 Module 27: Land for Development 01:00:00 Module 28: Making Decisions 00:45:00 Module 29: Sorting Out Your Finances 00:30:00 Module 30: Establishing Your Business 00:30:00 Module 31: Market Research 01:00:00 Module 32: Promotion and Selling 01:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Payroll Management

The Four Pillars of PMIAA - Improving "Deliver-ology" for the public sector Harnessing PM Fundamentals to Transform Public Sector Delivery. The Program Management Improvement & Accountability Act (PMIAA) leverages project management fundamentals to transform the public sector's ability to deliver value to its customers. This session will cover the core areas of PMIAA that the US government has codified across standards, executive sponsorship, knowledge transfer, and career paths that has now become benchmark for governments globally. This effort is driving the US federal government's ability to deliver on key aspects of its management strategy, and it is also a first step towards transforming its capability to drive a focus on customer satisfaction, no different than industry, via reliable project and program delivery. As a catalyst for professionalizing and formalizing PM talent and overall capacity, this session will also include examples from around the globe of how the public sector is rising to meet these challenges. This session will cover the core areas of PMIAA that the US government has codified across standards, executive sponsorship, knowledge transfer, and career paths that has now become benchmark for governments globally. This and other IIL Learning in Minutes presentations qualify for PDUs. Some titles, such as Agile-related topics may qualify for other continuing education credits such as SEUs, or CEUs. Each professional development activity yields one PDU for one hour spent engaged in the activity. Some limitations apply and can be found in the Ways to Earn PDUs section that discusses PDU activities and associated policies. Fractions of PDUs may also be reported. The smallest increment of a PDU that can be reported is 0.25. This means that if you spent 15 minutes participating in a qualifying PDU activity, you may report 0.25 PDU. If you spend 30 minutes in a qualifying PDU activity, you may report 0.50 PDU.