26724 Management courses in Exeter delivered Online

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  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 Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. 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 course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Virtual Team Building course will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Virtual Team Building course will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Virtual Team Building and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Virtual Team Building course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Virtual Team Building course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. 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 The Virtual Team Building will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction Introduction 00:04:00 Module 01: Qualities of a Successful Team Qualities of a Successful Team 00:04:00 Goals & Objectives for Working As a Team 00:05:00 5 Reasons Why Your Entire Team Should Contribute to Your Content Efforts 00:05:00 How Team Members can Support One Another's Well-Being 00:03:00 The Five Business Benefits of a Diverse Team 00:04:00 Effective Leadership: Why it's Important and How It's Achieved 00:05:00 Module 02: Communicating Effectively as a Team Communicating Effectively as a Team 00:05:00 7 Ways to Improve Team Communication 00:04:00 Advantages & Disadvantages of Group Cohesiveness & Productivity 00:04:00 3 Crucial Steps to Create Role Clarity within Your Team 00:05:00 Why Consistency Matters in Leadership 00:04:00 Importance of Courtesy in Business Communication 00:14:00 Module 03: Team Building Models Team Building Models 00:04:00 Traditional Team Building Model 00:03:00 Team Spirit Built from the Top 00:04:00 The Cutting Edge Team 00:05:00 What Are the Characteristics of a Task Force Group in Business? 00:03:00 Module 04: Team Building Process Team Building Process 00:05:00 The Forming Stage 00:04:00 The Storming Stage 00:04:00 The Norming Stage 00:04:00 The Performing Stage 00:04:00 The Adjourning Stage 00:05:00 Challenges of Managing a Virtual Team 00:05:00 The Cyber Team Model 00:03:00 Module 05: Challenges of Managing a Virtual Team How to Communicate With Remote Teams 00:03:00 How to Manage Remote Project Teams Effectively 00:04:00 10 Ways to Build Positive and Effective Work Relationships 00:04:00 7 Ways to Recover Your Team from Focus Loss 00:04:00 6 Ways Managers can Increase Team Accountability 00:04:00 Module 06: Team Building Exercises Team Building Exercises 00:03:00 Magic Cane (Helium Stick) 00:03:00 Barter Puzzle 00:03:00 Bridge Build 00:03:00 What's my name? 00:03:00 Grab Bag Skits 00:02:00 Conclusion Review 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Elevate your knowledge and skills in working at heights safely. Comply with regulations, implement risk assessments, and master the use of specialized equipment for fall protection. This course makes you adept at ensuring workplace safety in elevated environments.

No-one in business will succeed if they are not financially literate - and no business will succeed without financially-literate people. This is the ideal programme for managers and others who don't have a financial qualification or background but who nonetheless need a greater understanding of the financial management disciplines essential to your organisation. This course will give the participants a sound understanding of financial reports, measures and techniques to make them even more effective in their roles. It will enable participants to: Overcome the barrier of the accountants' strange language Deal confidently with financial colleagues Improve their understanding of your organisation's finance function Radically improve their planning and budgeting skills Be much more aware of the impact of their decisions on the profitability of your organisation Enhance their role in the organisation Boost their confidence and career development 1 Review of the principal financial statements What each statement containsOutlineDetail Not just what the statements contain but what they mean Balance sheets and P&L accounts (income statements) Cash flow statements Detailed terminology and interpretation Types of fixed asset - tangible, etc. Working capital, equity, gearing 2 The 'rules' - Accounting Standards, concepts and conventions Fundamental or 'bedrock' accounting concepts Detailed accounting concepts and conventions What depreciation means The importance of stock, inventory and work in progress values Accounting policies that most affect reporting and results The importance of accounting standards and IFRS 3 Where the figures come from Accounting records Assets / liabilities, Income / expenditure General / nominal ledgers Need for internal controls 'Sarbox' and related issues 4 Managing the budget process Have clear objectives, remit, responsibilities and time schedule The business plan Links with corporate strategy The budget cycle Links with company culture Budgeting methods'New' budgetingZero-based budgets Reviewing budgets Responding to the figures The need for appropriate accounting and reporting systems 5 What are costs? How to account for them Cost definitions Full / absorption costing Overheads - overhead allocation or absorption Activity based costing Marginal costing / break-even - use in planning 6 Who does what? A review of what different types of accountant do Financial accounting Management accounting Treasury function Activities and terms 7 How the statements can be interpreted What published accounts contain Analytical review (ratio analysis) Return on capital employed, margins and profitability Making assets work - asset turnover Fixed assets, debtor, stock turnover Responding to figures EBIT, EBITEDIA, eps and other analysts' measure 8 Other key issues Creative accounting Accounting for groups Intangible assets - brand names Company valuations Fixed assets / leased assets / off-balance sheet finance

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Discover the history and basic pharmacology of medical cannabis and learn about the full prescription process and current regulations surrounding CBPM in the UK. To recognise the origins of cannabis use and to recall key properties leading to its historical use. To demonstrate the process of prescribing medical cannabis and list what is required pre-, during-, and post- prescription. To summarise the regulatory landscape surrounding CBPM and successfully interpret the law regarding medical use.

Gain insights and strategies to effectively manage challenging behavior in young people with our specialized course. Learn evidence-based approaches to understand, prevent, and address difficult behaviors. Equip yourself with practical skills to support the development and well-being of youth. Enroll now to make a positive impact in challenging situations.

The Role of Project Managers in an Agile Business Organizations of all types are adopting agile methods to help manage complex work and improve project delivery. If you're a Project Manager, you may be wondering: Is an agile approach right for my organization? Do I have a role on an agile team, and if so, what is it? How do I make agile methods work in my context? 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.

Do you know what business ethics are? Want to learn how to have a good business reputation? Want to learn the details about business ethics? Want to find out how to apply them in your business? If yes, then this is the ideal course for you, enroll now and get the required knowledge of this course. Description: Every companies reputation is determined by its ethics. For a long term success maintaining good values is essential. Developing good ethics might be time-consuming, but by doing so you will help your business to improve in a unexpectable manner, and it will also change lives. Ethical obligations should be applied to employees, shareholders and investors and a list of other individuals related to the company. In this course you will learn about how can you deal equally with working in the enterprise at different posts, how can you provide their basic rights and how to handle conflict social responsibilities. Running an ethical organization or business has many rewards. Through this course, you will learn about the benefits of managing ethics within your business in details and reasons behind them. Implementing ethics at workplace might be difficult at first but and the end of the day, your business will be the one benefiting from it. In this course, you will learn about the different methods that will make it easier for you to implement ethics within the workplace. Organizations are legally bound to give a protected workplace to the majority of their employees as the primary concern of any employer is to have a safe working place, where there is no gender, religion, age and nationality discrimination and much more. In this course, you will also learn about how to keep your workplace safe for all the employees by issuing anti-harassment policies and also how to provide harassment training. You will learn much more through this course with our expert and well-experienced tutors. Who is the course for? Employees. Business owners. Individuals who have an interest in learning about business ethics. Individuals who desire to get acquainted with the ethical aspects of running a business. Managers. Corporate Trainers. Organizational Leaders. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Business Ethics is a useful qualification to possess, and would be beneficial for the following professionals: Business manager. Business consultant. Director, Ethics, and Compliance. Business operation and analyst. Strategy analyst, business strategy. Business Ethics Course Module One- Getting Started 00:30:00 Module Two - What is Ethics 01:00:00 Module Three - Implementing Ethics in the Workplace 00:30:00 Module Four- Employer/Employee Rights 00:30:00 Module Five- Business & Social Responsibilities 00:15:00 Module Six- Ethical Decisions 00:30:00 Module Seven Whistle Blowing 00:30:00 Module Eight Managerial Ethics 00:30:00 Module Nine Unethical Behavior 00:30:00 Module Ten - Ethics in Business (I) 01:00:00 Module Eleven Ethics in Business (II) 00:30:00 Module Twelve - Wrapping Up 00:30:00 Mock Exam Mock Exam- Business Ethics Course 00:20:00 Final Exam Final Exam- Business Ethics Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Duration 4 Days 24 CPD hours This course is intended for Administrators, architects, and business leaders who manage Nutanix clusters in the datacenter Managers and technical staff seeking information to drive purchase decisions Anyone who is seeking the Nutanix Certified Professional - Multicloud Infrastructure (NCP-MCI) certification Overview During this program, attendees will: Develop a working knowledge of the Nutanix product family. Understand the requirements and considerations involved in setting up a Nutanix cluster. Familiarize themselves with cluster management and monitoring via the Prism web console. Learn how to create, manage, and migrate VMs, set up data protection services, and plan for business continuity. Understand how to plan and handle upgrades, assess future requirements, and create what-if scenarios to adress scaling for business needs. The Nutanix Enterprise Cloud Administration (ECA) course enables administrators (system, network, and storage) to successfully configure and manage Nutanix in the datacenter. The course covers many of the tasks Nutanix administrators perform through the use of graphical user interfaces (GUIs) and command line interfaces (CLIs). It also provides insight into a Nutanix cluster?s failover and self-healing capabilities, offers tips for solving common problems, and provides guidelines for collecting information when interacting with Nutanix Support Introduction The section describes the Nutanix HCI solution, walks you through the components of the Nutanix Enterprise Cloud, and explains the relationship between physical and logical cluster components. Managing the Nutanix Cluster In this section, you will use the Prism console to monitor a cluster, configure a cluster using various interfaces, use the REST API Explorer to manage the cluster, and learn how to deploy Nutanix-specific PowerShell cmdlets. Securing the Nutanix Cluster This section shows how to secure a Nutanix cluster through user authentication, SSL certificate installation, and cluster access control. Acropolils Networking This section explains how to configure managed and unmanaged Acropolis networks and describes the use of Open vSwitch (OVS) in Acropolis. You will learn how to display and manage network details, differentiate between supported OVS bond modes, and gain insight into default network configuration. VM Management This section shows you how to upload images, and how to create and manage virtual machines. Health Monitoring and Alerts In this section, you will use the Health Dashboard to monitor a cluster?s health and performance. You will also use Analysis Dashboard to create charts that you can export with detailed information on a variety of components and metrics. Distributed Storage Fabric This section discusses creating and configuring storage containers, including the storage optimization features: deduplication, compression, and erasure coding. AHV Workload Migration Using Nutanix Move, this section shows how to migrate workloads to a cluster running AHV. This is followed by a lab where a VM running on a Nutanix cluster configured with ESXi is migrated to a Nutanix cluster running AHV. File and Volumes This section gives you detailed information on Nutanix Volumes, which provides highly available, high-performance block storage through a few easy configuration steps. It also discusses Nutanix Files. Understanding Infrastructure Resiliency This section shows how Nutanix provides comprehensive data protection at all levels of the virtual datacenter: logical and physical. Data Protection Data can be replicated between Nutanix clusters, synchronously and asynchronously. This section shows how to configure a Protection Domain (PD) and Remote Sites, recover a VM from a PD, and perform a planned failover of a PD. Prism Central Having discussed and used Prism Element earlier, this section looks at the capabilities of Prism Central. With the added functionality provided by a Pro license, the focus is on features related to monitoring and managing multiple activities across a set of clusters. Monitoring the Nutanix Cluster This section shows you where to locate and how to interpret cluster-related log files. In addition, you will take a closer look at the Nutanix Support Portal and online help. Cluster Management and Expansion This section outlines essential life-cycle operations, including starting/stopping a Nutanix cluster, as well as starting/shutting down a node. You will also learn how to expand a cluster, manage licenses, and upgrade the cluster?s software and firmware. Remote Office Branch Office (ROBO) Deployments In this section, you will understand various configurations and requirements specific to a ROBO site. This includes hardware/software, Witness VM, networking, failure and recovery scenarios for two-node clusters, and the seeding process. Additional course details: Nexus Humans NECA: Nutanix Enterprise Cloud 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 NECA: Nutanix Enterprise Cloud 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.