6139 Courses in Cardiff delivered Online

Duration 3 Days 18 CPD hours This course is intended for Experienced IT Asset Managers Overview By attending this course the attendee will be able to Understand and utilize the dependencies, relationships and benefits of the KPAs found within an effective IT Asset Management Program specify and define the duties and responsibilities necessary to be an effective IT Asset Manager be able to obtain and display an understanding of the resources and commitment necessary to implement a fully functional IT Asset Management Program. Attendees will learn about the entire ITAM Program and take with them the foundation plan for starting or improving their organization?s ITAM Program. The intense three-day course with certification is packed full of information and real-world experiences designed to make your ITAM Program more effective and efficient, and the CITAM Certification will lend notable credibility to both you and your ITAM Program.This course addresses each of the Key Process Areas (KPAs) identified within the IBPL that, when combined, empowers an organization and maximizes the value of their IT assets. The course will also review the core processes that encompass the ITAM Program and the projects that will help an organization build a productive and profitable business unit.The course includes exam for CITAM certification. Course Outline IAITAM and the Mission ITAM Code of Ethics Defining Primary Roles in an ITAM Program IAITAM?s 12 KPAs Relationships, Dependencies, and Benefits KPA Interdependencies Roles and Responsibilities Creating Dynamic Job Descriptions for ITAM Programs The Role of a Program Manager Project Management Relationship Triangle Sample Projects by KPA Prioritization and the ITAM Program Lifecycle Management Process Building Best Practices Gaining Executive Buy-in Business Case Template Maturity Assessment ITAM as a Core Business Function Additional course details: Nexus Humans Certified IT Asset Manager (CITAM) 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 Certified IT Asset Manager (CITAM) 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.

Description Microsoft Excel has hundreds, if not thousands, of functions and features. This course aims to cover some of the best – that is the ones I find most useful. In “Adventures in Excel”, I cover the simple-to-use but powerful functions that I use most often: Basic features including products and powers Key date functions including the calculation of due dates and days past due Generating random numbers and random dates The new IFS functions (new to Office365) Text functions The most useful logical functions and IS functions How to create a drop-down list The new XLOOKUP function Pivot tables   These functions are easy to use, and, unless your role is extremely specialised, they are probably the ones you’ll use 90% of the time. I hope you find the course helpful.   Learning Outcomes Participants in this course will learn: Basic Excel functions including SUM, AVERAGE, MIN, MAX, PRODUCT, POWER and SQRT Useful date functions including TODAY, EOMONTH, EDATE, and DAYS Generating random numbers using RAND and RANDBETWEEN; generating random dates; and randomly picking an item from a list or table The new RANDARRAY function in Office365 The new IFS functions in Office365 including AVERAGEIFS, MAXIFS, MINIFS, COUNTIFS, and SUMIFS Text functions including TRIM, LOWER, UPPER, PROPER, LEFT, MID, RIGHT, FIND, TEXTJOIN and CONCATENATE Logical functions AND, OR, and NOT and IS functions ISTEXT, ISNUMBER, ISBLANK and ISERROR How to create a drop-down list The new SORT and FILTER functions in Office365 VLOOKUP and the new XLOOKUP function How to create a Pivot table and analyse data with one     Course Requirements There are no pre-course requirements.   Additional Resources Course Spreadsheet with the examples covered.     About Ross Ross Maynard is a Fellow of the Chartered Institute of Management Accountants in the UK. He is director of Ideas2Action Process Excellence Ltd and has 30 years’ experience as a process improvement consultant and facilitator. Ross is also a professional author of online training courses for accountants. Ross lives in Scotland with his wife, daughter and Cocker Spaniel

***Limited Time Exclusive Bundle*** Life Just Got Better This Summer! Get Hard Copy + PDF Certificates + Transcript + Student ID Card as a Gift - Enrol Now Tired of browsing and searching for the course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this 14-in-1 extensive bundle that has everything you need to succeed in Modern Manufacturing and Quality Management and other relevant fields! After surveying thousands of learners just like you and considering their valuable feedback, this all in one Modern Manufacturing and Quality Management bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Modern Manufacturing and Quality Management course that will enhance your skills and prepare you for the competitive job market. Also, our Modern Manufacturing and Quality Management experts are available for answering your queries and help you along your learning journey. Advanced audiovisual learning modules of these courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Modern Manufacturing and Quality Management, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Modern Manufacturing and Quality Management Bundle Consists of the following Premium courses: Course 01: Modern Manufacturing Course 02: Cost Control Process and Management Course 03: SAP Controlling (CO) - Product Costing S4HANA Course 04: Level 3- Project Management Course 05: People Management Skills Level 3 Course 06: Operations Management Course 07: Quality Management Course 08: SAP Controlling (CO) - Product Costing S4HANA Course 09: Diploma in Lean Process and Six Sigma Course 10: Compliance & Business Risk Management Course 11: Commercial Law 2021 Course 12: Electrical and Fire Safety Training - Level 2 Course 13: First Aid Training Course 14: Time Management Benefits you'll get choosing Apex Learning for this Modern Manufacturing and Quality Management: Pay once and get lifetime access to 14 CPD courses Certificates, student ID for the title course included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules designed by expert instructors Learn at your ease - anytime, from anywhere Study the course from your computer, tablet or mobile device CPD accredited course - improve the chance of gaining professional skills How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) Curriculum of Modern Manufacturing and Quality Management Bundle Course 01: Modern Manufacturing Introduction Electric Discharge Machining Electrochemical Machining Abrasive Jet Machining Ultrasonic Machining Laser Beam Machining Plasma Arc Machining Electron Beam Machining The Finish Line Course 02: Cost Control Process and Management Introduction & Fundamentals Cost Control process Production Control and Tests Test and Checks in Cost Control Monitoring via reports and Checklist Course 03: SAP Controlling (CO) - Product Costing S4HANA Section 1: Introduction Section 2: Material Master Data and Pricing Controls Section 3: BoM, Activities and Routing Section 4: Overheads in Costing Section 5: Costing Sheet Section 6: Costing Variant Section 7: Routing and Work Centres Section 8: Cost Component Structure Section 9: Execution of Standard Cost Estimation Course 04: Level 3- Project Management Key Concepts (I) Key Concepts (II) Initiation (I) Initiation (II) Planning (I) Planning (II) Planning Tools Executing the Project Maintaining and Controlling the Project Closing Out Course 05: People Management Skills Level 3 Introduction to Human Resources Employee Recruitment and Selection Procedure Employee Training and Development Process Performance Appraisal Management Employee Relations Motivation and Counselling Ensuring Health and Safety at the Workplace Employee Termination Employer Records and Statistics Essential UK Employment Law Course 06: Operations Management Introduction to Operations Management Project Management Business Development and Succession Planning Process Management Supply Chain Management Planning & Forecasting Operations Procurement & Purchasing Management Manufacturing & Delivery Operations Quality Management Managing Risk and Recovery Performance Management Talent Management Communication Skills Negotiation Techniques Conflict Management Stress Management Time Management Business Environment Business Writing Skills Course 07: Quality Management Introduction to Quality Management Total Quality Management Quality Measurement and Improvement Quality Control Understanding Customer Expectations and Needs Six Sigma Supply Chain Management Quality Audits Course 08: SAP Controlling (CO) - Product Costing S4HANA Introduction Material Master Data and Pricing Controls BoM, Activities and Routing Overheads in Costing Costing Sheet Costing Variant Routing and Work Centres Cost Component Structure Execution of Standard Cost Estimation Course 09: Diploma in Lean Process and Six Sigma Understanding Lean The Lean Culture The Five Principles of Lean Value and Waste Value Stream Mapping (VSM) The Principles of Flow and Pull Overview of Six Sigma The Define Phase The Measure Phase The Analyse Phase The Improve Phase The Control Phase Course 10: Compliance & Business Risk Management Introduction to Compliance Five basic elements of compliance Compliance Management System (CMS) Compliance Audit Compliance and Ethics Risk and Types of Risk Introduction to Risk Management Risk Management Process Course 11: Commercial Law 2021 Introduction of Commercial law Business Organisations International Trade: the Theory, the Institutions, and the Law Sales of Goods Law Consumer Law and Protection E-Commerce Law Competition Law Course 12: Electrical and Fire Safety Training - Level 2 Introduction and Basics Introduction to Fire Safety Voltage and Resistance Capacitance and Capacitors Safety Precautions Fire Safety Legislation Measures of Fire Safety Fire Emergency: Evacuation Procedures Course 13: First Aid Training Introduction to Workplace First Aid Legal Framework for Workplace First Aid Incident Management at Work Primary Survey Secondary Survey Basic First-Aid Techniques Dealing with Minor Injuries at the Workplace Secondary Illness Loss of Responsiveness and CPR Secondary Illness Breathing Problems Secondary Illnesses and Injuries Dealing With Fractures and Dislocations Call for an Emergency Course 14: Time Management Identifying Goals Effective Energy Distribution Working with Your Personal Style Building Your Toolbox Establishing Your Action Plan CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Modern Manufacturing and Quality Management bundle. Persons with similar professions can also refresh or strengthen their skills by enrolling in this course. Students can take this course to gather professional knowledge besides their study or for the future. Requirements Our Modern Manufacturing and Quality Management is fully compatible with PC's, Mac's, laptops, tablets and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so that you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course; it can be studied in your own time at your own pace. Career path Having this various expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Modern Manufacturing) absolutely Free! Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Modern Manufacturing) 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.

Overview Internal auditing is an independent and objective activity to evaluate an organisation's internal operations. You'll learn how to initiate an audit, prepare and conduct audit activities, compile and distribute audit reports and complete follow-up activities. It is very important for the organisation to have a smooth flow of accounting as it plays a very important role in the development of the organisation. Financial Managers or any person who deals with Accounts need to see that the company accounts are very updated and are free from any risks that can become a problem during the time of Auditing.  Objectives   By the end of the course, participants will be able to: Efficiently dealing with senior leaders with confidence Effective Contribution and Strategically Analysing and Auditing towards business success Analysing and Evaluating as an effective internal audit leader How to manage key relationships with the audit committee Practical methods for managing the audit committee and senior management Describing the significance to help maximize the contribution to their organization

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! This Diploma in Online Financial Modelling at QLS Level 5 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 150 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Financial Modelling at QLS Level 5 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Financial Modelling at QLS Level 5 course. Due to Financial Modelling at QLS Level 5's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Financial Modelling at QLS Level 5 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Financial Modelling at QLS Level 5 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Financial Modelling at QLS Level 5 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this Financial Modelling at QLS Level 5 course. This Financial Modelling at QLS Level 5 training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Financial Modelling at QLS Level 5 Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Financial Modelling at QLS Level 5 course: Module 01: Basic Financial Calculations Module 02: Overview of Financial Markets, Financial Assets, and Market Participants Module 03: Financial Statement Modelling Module 04: Types of Financial Models Module 05: Sensitivity Analysis Module 06: Sales and Revenue Model Module 07: Cost of Goods Sold and Inventory Model Module 08: Valuation Methods Assessment Process You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Online Financial Modelling at QLS Level 5 exams. CPD 150 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Financial Modelling at QLS Level 5 course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The Financial Modelling at QLS Level 5 course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates CPDQS Accredited Certificate Digital certificate - Included CPDQS Accredited Certificate Hard copy certificate - Included International students are subject to a £10 delivery fee for their orders, based on their location. Diploma in Online Financial Modelling at QLS Level 5 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Diploma in Online Financial Modelling at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme and also you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost.

Feeling stuck in your career? Struggling to keep up with the ever-changing demands of the industry? You're not alone. But there's good news: Certificate in Metaphysics Fundamentals at QLS Level 3 career bundle is here to equip you with the essential skills and knowledge you need to break free and achieve your goals. With this Certificate in Metaphysics Fundamentals at QLS Level 3 course you will get 20 CPD Accredited PDF Certificates, Hard Copy Certificate in Metaphysics Fundamentals at QLS Level 3 and our exclusive student ID card absolutely free. Courses Are Included In This Certificate in Metaphysics Fundamentals at QLS Level 3 Bundle: Course 01: Certificate in Metaphysics Fundamentals at QLS Level 3 Course 02: Particle Physics Course 03: Particle Physics and Nuclear Physics Course 04: Physics Fundamentals Course 05: Engineering Calculus Course 06: Trigonometry for Electrical Engineering Course 07: Engineering Mechanics Course 08: MATLAB Simulink for Electrical Power Engineering Course 09: Astronomy Fundamentals Course 10: Augmented Reality Course 11: Meteorology Course 12: Geology and Natural Resources Course 13: Archaeology Course 14: Carbon Literacy Knowledge Course Course 15: Radiography Course 16: Advanced Diploma in Renewable Energy Course 17: Sustainable Energy Management Course 18: Environmental Engineering Course 19: Energy Saving in Electric Motors Course 20: Organic Chemistry Embarking on Certificate in Metaphysics Fundamentals at QLS Level 3 is more than just taking an online course; it's an investment in your future. By completing this Certificate in Metaphysics Fundamentals at QLS Level 3 bundle, you'll not only gain invaluable skills but also open doors to new career opportunities and advancements, boosting your earning potential. Don't miss this chance to elevate your career and skillset. Enrol in Certificate in Metaphysics Fundamentals at QLS Level 3 today and take the first step towards achieving your goals and dreams. Why buy this Certificate in Metaphysics Fundamentals at QLS Level 3? Free CPD Accredited Certificate upon completion of Certificate in Metaphysics Fundamentals at QLS Level 3 Get a free student ID card with Certificate in Metaphysics Fundamentals at QLS Level 3 Lifetime access to the Certificate in Metaphysics Fundamentals at QLS Level 3 course materials Get instant access to this Certificate in Metaphysics Fundamentals at QLS Level 3 course Learn Certificate in Metaphysics Fundamentals at QLS Level 3 from anywhere in the world 24/7 tutor support with the Certificate in Metaphysics Fundamentals at QLS Level 3 course. Certificate in Metaphysics Fundamentals at QLS Level 3 is an entirely online, interactive lesson with voice-over audio. Start your learning journey straightaway with our Certificate in Metaphysics Fundamentals at QLS Level 3 Training! Certificate in Metaphysics Fundamentals at QLS Level 3 premium bundle consists of 20 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Certificate in Metaphysics Fundamentals at QLS Level 3 is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Certificate in Metaphysics Fundamentals at QLS Level 3 course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the Certificate in Metaphysics Fundamentals at QLS Level 3 exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 320 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Certificate in Metaphysics Fundamentals at QLS Level 3 course is ideal for: Students seeking mastery in Certificate in Metaphysics Fundamentals at QLS Level 3 Professionals seeking to enhance Certificate in Metaphysics Fundamentals at QLS Level 3 skills Individuals looking for a Certificate in Metaphysics Fundamentals at QLS Level 3-related career. Anyone passionate about Certificate in Metaphysics Fundamentals at QLS Level 3 Requirements This Certificate in Metaphysics Fundamentals at QLS Level 3 doesn't require prior experience and is suitable for diverse learners. Career path This Certificate in Metaphysics Fundamentals at QLS Level 3 bundle will allow you to kickstart or take your career in the related sector to the next stage. Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included

At Smack the Markets we offer a different way for serious traders who want a bespoke and personal approach to learning to trade. We work with a small number of new traders on a one-to-one basis at a time. This enables us to develop a program completely around you, whether you’re brand new to this business and need to start from scratch, or you have some experience but need to unlearn what’s not working and relearn new skills that do work.   Because your requirements may be unique, our bespoke programs are flexible too. We aim to work with new traders over the long term (typically as long as a year) to ensure you’ve mastered the skills and techniques we’ve taught, and also to ensure you can apply them effectively in different market conditions.   Our typical one-to-one programs will consist of weekly live online workshops covering the trading skills and techniques you need, moving gradually to monthly coaching and mentoring sessions as you become more proficient in trading on your own.   Our style of trading incorporates a combination of fundamental and technical analysis to read the markets, using one of four technical trading strategies to execute trade positions. Our strategies are suitable for all liquid markets including Indices, Forex, Commodities and Stocks.   All our bespoke programs include some access to our online trading room, so you can observe how we are using the same techniques to trade the markets ourselves. Once you have gained suitable experience in our trading methods and have a good understanding of risk management, you will be offered full membership, which will give you permanent access to the trading room and other membership services should you wish.   As a guild our bespoke one-to-one programs can range from 5 to 15+ individual sessions with prices ranging in the region of £1,500.00 to £3,000.00 depending on your requirements and current trading experience.   If you would like to discuss our bespoke one-to-one programs further, please get in touch to arrange a no obligation consultation with our head trader.

Overview of MySql Masterclass The digital world has changed how businesses work in the UK, and database management is now a key part of every successful company. MySQL is one of the most popular tools for this job, used by over 40% of websites around the world. In the UK, big names like BBC, Sky, and many tech startups in London’s Silicon Roundabout rely on MySQL. The MySql Masterclass is designed to help people learn the skills needed to build a strong career in this growing field. Database experts in the UK earn an average salary of £45,000 each year, making it a smart career choice. The MySql Masterclass has 41 helpful modules that start with the basics and move up to more advanced topics. Students will learn how to create databases, write MySQL commands, use joins, and manage stored procedures. The course also teaches how to make systems run faster and safer with performance and security tools. Other important topics include handling JSON data, using full-text search, and working with replication. These are all things that modern companies look for in a database specialist. This MySql Masterclass is made for beginners and gives them the knowledge they need to handle real business databases. It helps students build strong skills in design, optimisation, and administration. The UK’s tech industry is worth £150 billion a year, and the MySql Masterclass helps learners get ready for job opportunities in many areas like retail, health, and finance. Learning Outcomes By the end of the MySql Masterclass, learners will be able to: Build and manage MySQL databases from the ground up Use SELECT, INSERT, UPDATE, and DELETE commands with confidence Work with advanced joins, unions, and stored procedures Design and use indexes, views, and full-text search for better performance Set up MySQL replication, backups, and basic system administration Handle JSON data and manage time zone settings within databases Who is this course for? Aspiring Database Administrators who want full MySQL training to manage databases, user access, and backups in organisations needing strong data systems. Software Developers who want to improve their backend development by learning MySQL queries, stored procedures, and database performance skills. Data Analysts who need advanced SQL to pull useful data from complex tables using joins, group functions, and reporting tools. IT Professionals looking to build database knowledge, including how to configure, tune, and fix issues in MySQL systems. Career Changers with little or no tech background who want to start in database roles, learning from the basics to advanced MySQL tasks. Process of Evaluation After studying the MySql Masterclass Course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the MySql Masterclass Course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. (Each) Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Requirements You don’t need any educational qualification or experience to enrol in the MySql Masterclass course. Career Path Completing this MySql Masterclass course could lead to rewarding jobs like: Database Administrator – £35K to £65K per year MySQL Developer – £30K to £55K per year Data Analyst – £25K to £45K per year Backend Developer – £35K to £60K per year Database Consultant – £40K to £70K per year Course Curriculum: MySql Masterclass Module 1: Introduction on MySQL 01:00:00 Module 2: Data Types 00:51:00 Module 3: SELECT Statements 00:59:00 Module 4: Backticks 00:15:00 Module 5: NULL 00:18:00 Module 6: Limit and Offset 00:13:00 Module 7: Creating databases 00:18:00 Module 8: Using Variables 00:25:00 Module 9: Comment MySQL 00:14:00 Module 10: INSERT Statements 00:29:00 Module 11: DELETE Statements 00:21:00 Module 12: UPDATE Statements 00:20:00 Module 13: ORDER BY Clause 00:08:00 Module 14: Group By 00:18:00 Module 15: Errors in MySQL 00:10:00 Module 16: Joins 00:37:00 Module 17: Joins continued 00:11:00 Module 18: UNION 00:18:00 Module 19: Arithmetic 00:20:00 Module 20: String operations 00:33:00 Module 21: Date and Time Operations 00:08:00 Module 22: Handling Time Zones 00:07:00 Module 23: Regular Expressions 00:19:00 Module 24: VIEWS 00:20:00 Module 25: Table Creation 00:23:00 Module 26: ALTER TABLE 00:23:00 Module 27: Drop Table 00:05:00 Module 28: MySQL LOCK TABLE 00:10:00 Module 29: Error codes 00:08:00 Module 30: Stored routines (procedures and functions) 00:29:00 Module 31: Indexes and Keys 00:24:00 Module 32: Full-Text search 00:18:00 Module 33: PREPARE Statements 00:09:00 Module 34: JSON 00:11:00 Module 35: Extract values from JSON type 00:05:00 Module 36: MySQL Admin 00:08:00 Module 37: TRIGGERS 00:12:00 Module 38: Configuration and tuning 00:07:00 Module 39: Events 00:08:00 Module 40: ENUM 00:09:00 Module 41: Collations, Transactions, Log files, Replication, Backup 00:41:00

Duration 1 Days 6 CPD hours This course is intended for This course is intended for those persons who will implement, manage and direct mobile asset Initiatives for their organizations. Overview The CMAM course prepares students to implement a foundation of best practice policies and processes whereby mobile assets are controlled. This should lead to savings opportunities, risk mitigation surrounding BYOD and financial responsibility. Students will be able to incorporate mobile asset management and BYOD into their environment, policies and procedures to mitigate risk, increase productivity of employees, and bring value from the mobile asset management program. The IAITAM Certified Mobile Asset Manager (CMAM) course prepares individuals and organizations responsible for the management of mobile devices. Proliferation of mobile devices within the enterprise, whether corporate-owned or BYOD-based, has brought a complexity to ITAM never before seen in IT environments. The course will prepare individuals with the knowledge to manage personnel, policies and processes, the key elements in organizational IT management. This course encompasses both organizational owned assets as well as BYOD (employee-owned). The CMAM course has the IAITAM Best Practice Library as its foundation and encompasses financial viability, risk mitigation, policy enforcement and lifecycle management of mobile assets. Course Outline Mobile Asset Management and ITAM People & Mobile Assets Bring Your Own Device (BYOD) Tools Repository Management Assessment The 12 KPAs and Mobile Asset Management Program Management & Mobility Policy Management & Mobility Communication & Education Management & Mobility Education & Mobility Acquisition Management & Mobility Asset Identification Management & Mobility Legislation & Compliance Management & Mobility Software & Application Licensing Disposal Management & Mobility Documentation Management & Mobility Financial Management & Mobility Vendor Management & Mobility Data Protection

Assistant lettings managers support lettings/property managers by organising viewings, ensuring properties are well-maintained, rent is paid on time, and much more. If you're considering a career in this field, then an assistant lettings manager is a great place to start. This Assistant Lettings Manager course explores lettings management practices in detail, with an introduction to lettings management laws. You will learn how to carry out property evaluations, negotiate property prices, build strong relationships with clients and will gain an understanding of your legal responsibilities in this field. This training certification will explore the property agreement guidelines in detail, and the different types of agent, as well as career opportunities. You will learn through case studies and practical exercises, and will develop essential client-facing skills to kickstart your career. Learning Outcomes of The Assistant Lettings Manager: Understand the key differences between a lettings agent and an estate agent Familiarise with the different types of agents and their responsibilities Get a full introduction to lettings management laws & lettings agency agreement guidelines Be able to define your clientele and develop the communication skills to build strong relationships with clients Learn how to carry out a property valuation and calculate the cost of a property Discover techniques for negotiating a house price and explore the role of a lettings negotiator Gain a solid understanding of the UK legal system and lettings management Boost your professional development by enhancing your spoken and written communication skills Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who is This Course for? This course is suitable for those who are new to property or lettings management and wish to develop the necessary skills and knowledge to fast track their career. This course is ideal for lettings negotiators who want to reach the next level in their career. Career Path On successful completion of this course, learners will have the skills, knowledge and information to boost their professional development and explore the following roles: Assistant Lettings Manager Lettings Negotiator Lettings Co-ordinator Sales and Lettings Administrator Lettings Officer