Feeling Stuck in Your Career? The Business Administrations, Business Development & Project Management with Entrepreneurship Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Business Administration, Business Development & Project Management bundle provides an engaging learning experience, helping you learn skills across various disciplines. With Business Administrations, Business Development & Project Management with Entrepreneurship Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Business Administration, Business Development & Project Management bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Business Administrations, Business Development & Project Management with Entrepreneurship bundle on your job life and career growth! This Business Administrations, Business Development & Project Management with Entrepreneurship Bundle Comprises the Following CPD Accredited Courses: Course 01: Strategic Business Management - Online Diploma Course Course 02: Business Plan Course 03: Fundamentals of Business Analysis Course 04: Business Development Fundementals: Lean Strategies for Business Course 05: Business Law 2021 Course 06: Project Management Course 07: Operations Management Course 08: Organisation & People Management Course 09: Change Managemen Course 10: Performance Management Level 3 Course 11: Entrepreneurship: Startup your New Venture Course 12: Corporate Risk And Crisis Management - Online Course Course 13: Learn to Identify and Solve Business Problems Course 14: Product Management Course 15: Retail Associate Certificate Course 16: Retail Management Course 17: Strategic Planning and Analysis for Marketing Course 18: Marketing Strategies for Business Course 19: Marketing & Advertising Complete Course Course 20: Sales & Negotiation Skills Course 21: Making Budget & Forecast Course 22: Investment Course 23: Corporate Finance: Profitability in a Financial Downturn Course 24: Financial Ratio Analysis for Business Decisions Course 25: Managerial Accounting Masterclass Course 26: Learn to Make a Fresh Start in Your Life Course 27: Motivation - Motivating Yourself & Others Course 28: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 29: Decision-Making and Critical Thinking Course 30: Time Management Training - Online Course What will make you stand out? Upon completion of this online Business Administrations, Business Development & Project Management with Entrepreneurship Bundle, you will gain the following: CPD QS Accredited Proficiency with this Business Administrations, Business Development & Project Management Bundle After successfully completing the Business Administrations, Business Development & Project Management bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Business Administrations, Business Development & Project Management Bundle The online test with immediate results You can study and complete the Business Administrations, Business Development & Project Management bundle at your own pace. Study for the Business Administrations, Business Development & Project Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Business Administrations, Business Development & Project Management with Entrepreneurship bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Business Administrations, Business Development & Project Management bundle, a comprehensive, complete collection of 30 courses. Each course in the Business Administrations, Business Development & Project Management bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Business Administration, Business Development & Project Management bundle offers the flexibility and convenience to learn at your own pace. Make the Business Administration, Business Development & Project Management package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Business Administrations, Business Development & Project Management with Entrepreneurship is perfect for: Expand your knowledge and skillset for a fulfilling career with the Business Administrations, Business Development & Project Management bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Business Administrations, Business Development & Project Management bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Business Administration, Business Development & Project Management bundle. Learn on your schedule, in the comfort of your home - the Business Administration, Business Development & Project Management bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Business Administrations, Business Development & Project Management bundle. Certificates CPD Certificates Digital certificate - Included
Duration 5 Days 30 CPD hours This course is intended for This course is geared toward Windows system administrators, network administrators, and other system administrators who are interested in supplementing current skills or backstopping other team members, in addition to Linux system administrators who are responsible for these tasks: Configuring, installing, upgrading, and maintaining Linux systems using established standards and procedures, Providing operational support, Managing systems for monitoring system performance and availability, Writing and deploying scripts for task automation and system administration. Overview #NAME? Red Hat System Administration I (RH124) equips you with Linux© administration "survival skills" by focusing on foundational Linux concepts and core tasks. You will learn how to apply command-line concepts and enterprise-level tools, starting you on your journey toward becoming a full-time Linux system administrator. This path continues with the follow-on course, Red Hat System Administration II (RH134). 1 - Getting Started with the GNOME Graphical Desktop Get started with GNOME and edit text files with gedit 2 - Manage Files Graphically with Nautilus Manage files graphically and access remote systems with Nautilus 3 - Get Help in a Graphical Environment Access documentation, both locally and online 4 - Configure Local Services Configure the date and time and configure a printer 5 - Manage Physical Storage Understand basic disk concepts and manage system disks 6 - Manage Logical Volumes Understand logical volume concepts and manage logical volumes 7 - Monitor System Resources Manage memory and CPU utilization 8 - Manage System Software Manage system software locally and using Red Hat Network (RHN) 9 - Get Started with Bash Understand basic shell concepts, execute simple commands, and use basic job control techniques 10 - Get Help in a Textual Environment Use man and info pages and find documentation in /usr/share/doc 11 - Establish Network Connectivity Understand basic network concepts; configure, manage, and test network settings 12 - Administer Users and Groups Manage users and groups 13 - Manage Files from the Command Line Understand Linux filesystem hierarchy; manage files from the command line 14 - Secure Linux File Access Understand Linux file access mechanisms; manage file access from the GUI and the command line 15 - Administer Remote Systems Share and connect to a desktop; use SSH and rsync 16 - Configure General Services Manage services; configure SSH and remote desktops 17 - Manage Physical Storage II Manage filesystem attributes and swap space 18 - Install Linux Graphically Install Red Hat Enterprise Linux and configure the system with firstboot 19 - Manage Virtual Machines Understand basic virtualization concepts; install and manage virtual machines 20 - Control the Boot Process Understand runlevels and manage GRUB 21 - Deploy File Sharing Services Deploy an FTP server and a web server 22 - Secure Network Services Manage a firewall; understand SELinux concepts and manage SELinux 23 - Comprehensive Review Get a hands-on review of the concepts covered throughout the course
Get ready for an exceptional online learning experience with the IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle! This carefully curated collection of 20 premium courses is designed to cater to a variety of interests and disciplines. Dive into a sea of knowledge and skills, tailoring your learning journey to suit your unique aspirations. The IT Administration, Networking, Cyber Security Awareness Training & GDPR is a dynamic package, blending the expertise of industry professionals with the flexibility of digital learning. It offers the perfect balance of foundational understanding and advanced insights. Whether you're looking to break into a new field or deepen your existing knowledge, the IT Administration package has something for everyone. As part of the IT Administration, Networking, Cyber Security Awareness Training & GDPR package, you will receive complimentary PDF certificates for all courses in this bundle at no extra cost. Equip yourself with the IT Administration bundle to confidently navigate your career path or personal development journey. This Bundle Comprises the Following CPD Accredited Courses: IT Administration and Networking Encryption Advance Windows 10 Troubleshooting for IT HelpDesk Building Your Own Computer Cyber Security Awareness Training Secure Programming of Web Applications Cloud Computing / CompTIA Cloud+ (CV0-002) CompTIA A+ (220-1001) Data Center Training Essentials: General Introduction Information Management Bash Scripting, Linux and Shell Programming Learn Ethical Hacking From A-Z: Beginner To Expert Computer Networks Security from Scratch to Advanced GDPR UK Training Cisco ASA Firewall Training Course Career Development Plan Fundamentals CV Writing and Job Searching Learn to Level Up Your Leadership Networking Skills for Personal Success Ace Your Presentations: Public Speaking Masterclass Learning Outcome: By completing the IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle , you will be able to: Gain comprehensive insights into multiple fields. Foster critical thinking and problem-solving skills across various disciplines. Understand industry trends and best practices through the IT Administration Bundle. Develop practical skills applicable to real-world situations. Enhance personal and professional growth with the IT Administration. Build a strong knowledge base in your chosen course via IT Administration. Benefit from the flexibility and convenience of online learning. With the IT Administration package, validate your learning with a CPD certificate. Embrace the future of learning with the IT Administration, Networking, Cyber Security Awareness Training & GDPR, a rich anthology of 15 diverse courses. Each course in the IT Administration, bundle is handpicked by our experts to ensure a wide spectrum of learning opportunities. This IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle will take you on a unique and enriching educational journey. The bundle encapsulates our mission to provide quality, accessible education for all. Whether you are just starting your career, looking to switch industries, or hoping to enhance your professional skill set, the IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle offers you the flexibility and convenience to learn at your own pace. Make the IT Administration, package your trusted companion in your lifelong learning journey. Enrol IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle today and start your career growth! CPD 205 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle is perfect for: Lifelong learners looking to expand their knowledge and skills. Professionals seeking to enhance their career with CPD certification. Individuals wanting to explore new fields and disciplines. Anyone who values flexible, self-paced learning from the comfort of home. Requirements Without any formal requirements, you can delightfully enrol in this IT Administration, Networking, Cyber Security Awareness Training & GDPR course. Career path Unleash your potential with the IT Administration, Networking, Cyber Security Awareness Training & GDPR bundle. Acquire versatile skills across multiple fields, foster problem-solving abilities, and stay ahead of industry trends. Ideal for those seeking career advancement, a new professional path in IT. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.
Get to grips with the installation and configuration of a domain controller, Active Directory, DNS, and Web Server (IIS)
Duration 2 Days 12 CPD hours This course is intended for This course is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL or EDB Postgres Advanced Server. It teaches the essential skills required by Postgres DBAs to be successful. Overview This certification exam assesses and certifies a database professional to demonstrate the fundamental skills necessary to maintain and manage a PostgreSQL server and applications in a production environment. This course presents the PostgreSQL database architecture and core administrative tasks including configuration, maintenance, monitoring, backups, recovery, and moving data. It also introduces learners to enterprise class tools for Postgres administration and prepares them to handle real time, production environments. Upon course completion, the learners will be prepared to manage large, highly available Postgres databases with confidence. Introduction and Architectural OverviewSystem ArchitecturePostgreSQL InstallationEDB Postgres Advanced Server InstallationDatabase ClustersConfigurationCreating and Managing DatabasesCommand Line User ToolsGUI ToolsSecurity BasicsSQL PrimerBackup, Recovery, and PITRRoutine MaintenanceData DictionaryMoving Data Additional course details: Nexus Humans Foundations of Postgres Administration 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 Foundations of Postgres Administration 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.
The Administration and Control of Medicines course is crucial in today's world, emphasizing the importance of risk management in medicine management. With modules covering the fundamentals, effective prescribing, and pharmacological management, this course equips individuals with the skills needed to navigate the complexities of modern healthcare. Understanding risk management is essential for ensuring patient safety and optimizing medication use, which is particularly vital in residential aged care facilities. The course also delves into palliative care, law, and legislation, underscoring the critical role of risk management in adhering to legal standards and improving patient outcomes. Graduates of this course are well-positioned for job opportunities in the UK, where the demand for healthcare professionals with expertise in medicine management and risk management is high. The average salary for such roles can range from £25,000 to £40,000 annually, depending on experience and specific job functions. The sector is experiencing significant growth, with an expected increase of 6-8% in job opportunities over the next decade. This course not only enhances employability but also ensures that healthcare professionals are adept at implementing effective risk management strategies, thereby improving overall healthcare delivery and patient care. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Course Curriculum: Module 01: Medicine Management Fundamentals Module 02: Importance Of Medicine Management Module 03: Prescribing Medication Effectively Module 04: Common Problems - Pharmacological Management Module 05: Common Medicines To Use Module 06: Palliative Care Module 07: The Four Principles Of Medicine Optimisation Module 08: Managing Medication In Residential Aged Care Facilities Module 09: Law And Legislation Learning Outcomes: Identify fundamentals of managing medicines for effective administration control. Analyze the importance of proper medicine management techniques. Implement effective prescribing methods to ensure patient safety and wellness. Recognize common pharmacological issues and apply appropriate management strategies. Utilize common medicines efficiently according to prescribed guidelines. Apply principles of medicine optimization in various healthcare settings. CPD 10 CPD hours / points Accredited by CPD Quality Standards Administration and Control of Medicines 2:56:01 1: Module 01: Medicine Management Fundamentals Preview 21:43 2: Module 02: Importance Of Medicine Management 15:12 3: Module 03: Prescribing Medication Effectively 17:31 4: Module 04: Common Problems - Pharmacological Management 42:27 5: Module 05: Common Medicines To Use 12:18 6: Module 06: Palliative Care 14:37 7: Module 07: The Four Principles Of Medicine Optimisation 15:11 8: Module 08: Managing Medication In Residential Aged Care Facilities 24:36 9: Module 09: Law And Legislation 11:26 10: CPD Certificate - Free 01:00 Who is this course for? This Administration and Control of Medicines course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Administration and Control of Medicines. Moreover, this course is ideal for: Healthcare professionals seeking advanced medicine management knowledge. Nurses aiming to enhance medication administration skills for patient care. Pharmacists interested in improving medication prescribing and management practices. Caregivers in residential aged care facilities requiring comprehensive medication management training. Healthcare administrators and policymakers involved in developing medicine-related protocols. Requirements There are no requirements needed to enrol into this Administration and Control of Medicines course. We welcome individuals from all backgrounds and levels of experience to enrol into this Administration and Control of Medicines course. Career path After finishing this Administration and Control of Medicines course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Administration and Control of Medicines are: Mental Health Nurse - £24K to 40K/year Pharmacist - £31K to 53K/year Care Home Manager - £28K to 45K/year Clinical Nurse Specialist - £35K to 55K/year Palliative Care Nurse - £25K to 40K/year Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Enhance your expertise in Microsoft Office Skills with Admin, Secretarial & PA (Administration)and acquire in-demand data management skills to easily complete your everyday Microsoft Office tasks! Whether you are a business professional, student, teacher, freelancer, or solopreneur, this interactive Microsoft Office Skills with Admin, Secretarial & PA (Administration) training assists you in taking your skills to the next level. With a single payment, you will gain access to this Microsoft Office Skills with Admin, Secretarial & PA (Administration) course, including an original hardcopy certificate, a transcript and a student ID card. Courses are included in this Microsoft Office Skills with Admin, Secretarial & PA (Administration) Bundle : Course 01: MS Word Diploma Course 02: Microsoft PowerPoint Diploma Course 03: Microsoft Excel Level 3 Course 04: Complete Microsoft Access Course Course 05: Functional Skills IT Course 06: Data Analysis in Microsoft Excel Complete Training Course 07: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 08: Excel Pivot Tables Course 09: Microsoft Teams Course 10: Microsoft Excel: Master Power Query in 120 Minutes! Course 11: Office Skills and Administration Management Diploma So enrol now in this Microsoft Office Skills with Admin, Secretarial & PA (Administration) Bundle! This Microsoft Office Skills with Admin, Secretarial & PA (Administration) is a bundle course that holds 11 different courses covering various topics to give you a rich learning experience to master the skills of Microsoft Office Skills with Admin, Secretarial & PA (Administration)fruitfully. The Curriculum of Microsoft Office Skills with Admin, Secretarial & PA (Administration) Bundle Course 01: MS Word Diploma Getting Started with Word Formatting Text and Paragraphs Working More Efficiently Managing Lists Adding Tables Inserting Graphic Objects Controlling Page Appearance Preparing to Publish a Document =========>>>>> And 10 More Courses <<<<<========= The detailed curriculum of the Microsoft Office Skills with Admin, Secretarial & PA (Administration) is given in the resources section. How will I get my Microsoft Office Skills with Admin, Secretarial & PA (Administration) Certificate? After successfully completing the Microsoft Office Skills with Admin, Secretarial & PA (Administration) bundle you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals who are new to Microsoft Office Skills with Admin, Secretarial & PA (Administration) and want to learn the basics of the program Professionals who want to improve their skills and knowledge of Microsoft Office Skills with Admin, Secretarial & PA (Administration) Students who want to improve their productivity and efficiency by learning to use Microsoft Office more effectively Requirements This Microsoft Office Skills with Admin, Secretarial & PA (Administration) is open to anyone. All you need is an interest in learning! Career path Upon completion of this Microsoft Office Skills with Admin, Secretarial & PA (Administration) course, numerous exciting career opportunities await you. Explore a variety of roles in Microsoft Office Skills with Admin, Secretarial & PA (Administration), like: Office Administrator Microsoft Office specialist. Office skills Manager Office Assistant Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Microsoft Office Excel Level 3) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included
Overview Explore the intricacies of clinical research and understand the administration process with our Clinical Research Administration Training course. This course will help you deepen your knowledge and acquire the ability to seek career prospects in the relevant sectors. The course is packed with high;y valuable information on clinical research. From the informative modules, you will learn the core concepts of clinic trial designing and planning. The course will help you develop the skills for data management and analysis. You will be able to build your expertise in monitoring and auditing. Moreover, you will acquire the skills required for quality control and site management as well. After the course, you will receive a CPDQS-accredated certificate of achievement. This certificate will enhance your employability and help you reach your career goals. Enrol now! Course Preview Learning Outcomes Understand the significance of clinical research in healthcare Learn about the process of clinical trail design and planning Deepen your knowledge of ethics and regulatory compliance Develop the ability for data management and record-keeping Know how to monitor and audit the trials Grasp the process of study site management and quality control Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Trail planning Data management and analysis Monitoring and auditing Site management Quality control Compliance management Who Should Take This Clinical Research Administration Training? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Clinical Research Administration Training course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Pathâ This exclusive Clinical Research Administration Training course will equip you with effective skills and abilities and help you explore career paths such as Clinical Research Administrator Clinical Research Associate Clinical Research Coordinator Clinical Data Manager Module 01: Introduction to Clinical Research Administration Introduction to Clinical Research Administration 00:15:00 Module 02: Clinical Trial Design and Planning Clinical Trial Design and Planning 00:11:00 Module 03: Ethics and Regulatory Compliance Ethics and Regulatory Compliance 00:13:00 Module 04: Institutional Review Boards (IRBs) and Ethics Committees Institutional Review Boards (IRBs) and Ethics Committees 00:10:00 Module 05: Data Management and Recordkeeping Data Management and Recordkeeping 00:12:00 Module 06: Safety Reporting and Adverse Events Safety Reporting and Adverse Events 00:10:00 Module 07: Clinical Trial Monitoring and Auditing Clinical Trial Monitoring and Auditing 00:09:00 Module 08: Study Site Management and Quality Control Study Site Management and Quality Control 00:17:00 Module 09: Data Analysis and Reporting Data Analysis and Reporting 00:09:00 Module 10: The Future of Clinical Research The Future of Clinical Research 00:10:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course is people who are moving into a database role, or whose role has expanded to include database technologies. Developers that deliver content from SQL Server databases will also benefit from this material. Overview After completing this course, you will be able to: Describe key database concepts in the context of SQL Server Describe database languages used in SQL Server Describe data modelling techniques Describe normalization and denormalization techniques Describe relationship types and effects in database design Describe the effects of database design on performance Describe commonly used database objects This course is provided as an introductory class for anyone getting started with databases. It will be useful to programmers and other IT professionals whose job roles are expanding into database management. Students will learn fundamental database concepts through demonstrations and hands-on labs on a SQL Server instance. This material updates and replaces course Microsoft course 10985 which was previously published under the same title. Module 1: Introduction to databases Introduction to Relational Databases Other Databases and Storage Data Analysis SQL Server Database Languages Module 2: Data Modeling Data Modelling Designing a Database Relationship Modeling Module 3: Normalization Fundamentals of Normalization Normal Form Denormalization Module 4: Relationships Introduction to Relationships Planning Referential Integrity Module 5: Performance Indexing Query Performance Concurrency Module 6: Database Objects Tables Views Stored Procedures, Triggers and Functions