• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

9790 Office courses

MySQL for developers

5.0(3)

By Systems & Network Training

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

MySQL for developers
Delivered in Internationally or OnlineFlexible Dates
£2,797

Oracle database administration

5.0(3)

By Systems & Network Training

Oracle Database 12c Admin training course description This Oracle Database 12c Administration course is designed to give the Oracle database administrator practical experience in administering, monitoring, tuning and troubleshooting an Oracle 12c database. Database administrators will gain an understanding of the architecture and processes of the Oracle database server. They will be able to ensure the integrity and availability of a company's data within the Oracle environment. They will be able to monitor the performance of the database, allocate resources with the Resource Manager and Schedule jobs. What will you learn Administer an Oracle database instance. Monitor an Oracle database. Configure the Oracle network environment. Create and manage database storage structures. Manage users, profiles, privileges and roles. Manage undo data and temporary segments. Monitor and resolve lock conflicts. Maintain database security. Implement database auditing. Monitor the performance of the Database. Load and unload data. Use the job scheduler. Configure a database for backup and recovery. Oracle Database 12c Admin training course details Who will benefit: This Oracle Database 12c Administration course is for anyone who needs to administer, monitor and support an Oracle 12c database. Prerequisites: An understanding of relational database concepts and good operating system knowledge. They should have attended the Oracle SQL course or have a good working knowledge of Oracle SQL. Knowledge of the usage of PL/SQL packages is highly recommended. Duration 5 days Oracle Database 12c Admin training course contents Introduction to Oracle database 12c Overview of the Oracle database 12c, Overview of the Oracle Cloud, Relational database concepts, database administration tasks. Oracle Database 12c Architecture Overview of the Oracle database architecture, The Oracle database instance, Oracle Database memory structures, Process architecture and structures, Server and client processes, The Oracle database storage architecture, Connect to the Oracle database instance. Administer a database instance Administrative tools available to a DBA, Use SQL*Plus in Oracle to manage a database instance, Use SQL Developer to manage a database instance, Administer the database using Enterprise Manager (EM), Overview of the Enterprise Manager framework, Access Enterprise Manager Database Express, The Enterprise Manager Database Express Home Page, Enterprise Manager Cloud Control, Initialization parameter files. Configure the Oracle network environment Overview of network configuration, Oracle Net Listener configuration and management, Oracle Net naming methods, Tools for configuring and managing the Oracle network, Using the Net Configuration Assistant, Configure client connections with Net Manager, View listener configuration, Start and stop the Oracle listener, Use TNSPING to test Oracle Net connectivity, Connect to the database, Configure Net Services with Enterprise Manager. Storage Structures Overview of data storage, The database block, Overview of tablespaces and datafiles, Use Enterprise Manager to view the storage structure of the database, Create and alter tablespace commands, Temporary tablespaces, Create and manage datafiles, Use OMF, Drop tablespaces and datafiles. Manage users Predefined database administration accounts, User accounts, Create a user account, User authentication, Change a user's password, Manage a user account, Drop a user account, Monitor user information, Terminate user sessions. Manage profiles and resources Overview of user profiles, Profile resource parameters, Create profile command, Manage passwords with profiles, Control resource usage with profiles, Maintain profiles. Manage privileges Database access, Oracle supplied roles, System and object level privileges, The grant and revoke commands, Create, modify and drop roles, Use predefined roles. Database auditing Overview of database security, Overview of database auditing, Security compliance, Standard auditing, Unified audit trail, Separation of audit responsibilities with the AUDIT_ADMIN and AUDIT_VIEWER roles, Configure the audit trail, Specify audit options. Data concurrency and lock conflicts Levels of locking in Oracle, Methods used to acquire locks, Data concurrency, Possible causes of contention, DML locks, Prevent locking problems, Detect lock contention, Resolve conflicts. Undo management Undo data overview, Monitor and administer undo, Configure undo retention, Switch undo tablespaces, Specify the retention period, Guarantee undo retention, Retention period for flashback queries, View undo space information, Use the undo advisor, Size the undo tablespace, Alter an undo tablespace to a fixed size. Proactive database management Database Maintenance, View the alert log, The Automatic Workload Repository, Statistic levels, The Automatic Database Diagnostic Monitoring, Monitor an Oracle database, Use the Advisors, Set up notification rules/ Performance management Tuning information sources, Performance monitoring, Tuning activities, Performance planning, Instance tuning, Performance tuning methodology, Performance tuning data, Monitoring performance, Managing memory. SQL tuning SQL tuning, The Oracle Optimizer, SQL Plan directives, Adaptive execution plans, SQL Advisors, Automatic SQL Tuning results, Implement automatic tuning recommendations , SQL Tuning Advisor. Moving data Create directory objects , Data Pump architecture, Data Pump data dictionary views, Data Pump interactive mode, Data Pump API, Use Data Pump to export and import data, Overview of SQL Loader, Command line parameters, Record filtering, Control file keywords, Datafiles, SQL Loader data paths, External Tables. Automate tasks with the scheduler Introduction to the Scheduler, Access Rights, Scheduler components and workflow, Create a Job, Job Classes, Use time based, event based schedules, Create an event based schedule. Managing resources with Resource Manager Overview of the Database Resource Manage, Use the Resource Manager, Create Resource Plans, The default maintenance resource manager plan, Create Resource Plan Directives, Allocate resources for Resource Plans. Manage space Overview of space management, Block space management within segments, Segment types, Allocate extents, Allocate space, Row chaining and migration, Create tables without segments. Backup and recovery configuration Oracle backup solutions, Oracle suggested backup strategy, Overview of database backup, restore and recover, Flashback technology, Types of failure ,Instance recovery, Tune instance recovery, The MTTR Advisor, Media failure, Configure a database for recoverability Oracle support The Enterprise Manager Support Workbench, Register for security updates, Work with Oracle Support, My Oracle Support integration, Log Service Requests, Manage patches, Apply a patch

Oracle database administration
Delivered in Internationally or OnlineFlexible Dates
£2,797

Cleaning: Disinfection, Waste Management Diploma and Chemical Safety Level 3

4.5(3)

By Studyhub UK

Overview The Cleaning: Disinfection, Waste Management Diploma, and Chemical Safety Level 3 course provide comprehensive training for individuals in the cleaning industry. Participants will learn about various aspects of professional cleaning, including cleaning techniques, equipment, waste management, chemical safety, and starting and running a successful cleaning business. The course also covers customer satisfaction, staff management, marketing, and business expansion. Learning Outcomes: Develop a comprehensive understanding of the cleaning job, its diversity, and the specific equipment, products, and clothing required for different cleaning tasks. Acquire practical skills in house cleaning, kitchen cleaning (both food and commercial), bathroom and toilet cleaning, office cleaning, and cleaning external surfaces and areas. Learn effective waste management techniques and protocols for dealing with non-routine waste. Understand the importance of chemical safety, keyholding, and alarm codes for cleaners in maintaining a safe working environment. Gain knowledge and strategies for starting a cleaning business, including business planning, running the business with quality service, and ensuring customer satisfaction. Acquire essential skills in staff management, including recruitment, training, and effective management techniques. Learn effective marketing, advertising, and sales techniques to promote the cleaning business and expand its reach. Understand the importance of business insurance, tax compliance, and additional equipment considerations for business operations. Why buy this Cleaning: Disinfection, Waste Management Diploma and Chemical Safety Level 3? 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 Cleaning: Disinfection, Waste Management Diploma and Chemical Safety Level 3 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 Cleaning: Disinfection, Waste Management Diploma and Chemical Safety Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Cleaning: Disinfection, Waste Management Diploma and Chemical Safety Level 3 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Cleaning: Disinfection, Waste Management Diploma and Chemical Safety Level 3 is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 1: An Introduction to the Cleaning Job An Introduction to the Cleaning Job 00:19:00 Module 2: The Diversity of Cleaning Jobs The Diversity of Cleaning Jobs 00:26:00 Module 3: Cleaning Equipment, Products and Clothing Cleaning Equipment, Products and Clothing 00:24:00 Module 4: House Cleaning House Cleaning 00:22:00 Module 5: Food Kitchen and Commercial Kitchen Cleaning Food Kitchen and Commercial Kitchen Cleaning 00:23:00 Module 6: Bathrooms and Toilets Bathrooms and Toilets 00:22:00 Module 7: Office Cleaning Office Cleaning 00:19:00 Module 8: Cleaning External Surfaces and Areas Cleaning External Surfaces and Areas 00:18:00 Module 9: Dealing with Non-Routine Waste Dealing with Non-Routine Waste 00:21:00 Module 10: Chemical Safety, Keyholding and Alarm Codes for Cleaners Chemical Safety, Keyholding and Alarm Codes for Cleaners 00:21:00 Module 11: Starting a Cleaning Business and Planning for it Starting a Cleaning Business and Planning for it 00:14:00 Module 12: Running the Business with Quality Service Running the Business with Quality Service 00:22:00 Module 13: Customer Satisfaction Customer Satisfaction 00:23:00 Module 14: Management of Staff Management of Staff 00:22:00 Module 15: Marketing, Advertising and Sales Marketing, Advertising and Sales 00:24:00 Module 16: Expansion Management Expansion Management 00:17:00 Module 17: Business Insurance, Tax and Additional Equipment Business Insurance, Tax and Additional Equipment 00:24:00

Cleaning: Disinfection, Waste Management Diploma and Chemical Safety Level 3
Delivered Online On Demand6 hours 1 minutes
£10.99

Complete Workplace Administration

4.3(43)

By John Academy

Administrative management focuses on needs of administrative procedures and using the right tools and techniques in the workplace. [course_titile] is originated for you to carry out administrative tasks to a professional standard. The course begins with by explaining the code of conduct as well as setting the tone in the workplace. Operating an office requires exceptional effort and management skills. Initially, this course is intended to prepare you to handle bullying in the workplace, conflict management and different types of conflict that often occur, necessary steps to avoid and overcome conflict, getting along in the workplace effectively as well. You will be able to create a positive work environment through communication and negotiation. In the course, you will get a clear understanding of closing the generation gap, ergonomics injury prevention, and eliminate workplace violence. Following that, you will learn about workplace harassment and things to do if you become a victim of it. Enroll now and get the most out of this course. Learning Outcomes: Identify what a code of conduct is and why a business should have one Identify what goes into a code of conduct Discuss how to implement a code of conduct in the workplace Create a code of conduct for a business Allot a definition about bullying of what it is and what not Realise the cost of bullying either to organisations nor to people Recognise behaviours associated with bullying as well as the factors behind them Learn some means to shut bullying and realise the roles you can play Acquire the knowledge of some routes to handle yourself from bullying Learn what you should do when encountered with bullying Figure out proper solutions to a bullying event (either within or outside the organisation) Be able to assist in creating an anti-bullying policy Become able to help generate an anti-bullying policy Identify how a positive workplace appears Get information and realise the major components suited to produce and sustain a positive work atmosphere Realise the role of an employee to generate your individual activities to manage a positive work environment Understand as a leader the responsibility you have to create and maintain a positive work environment Figure out Discover what type of team player you are and how that relates to your functioning in the team Know the importance of effective workplace relationships in creating and maintaining a positive work environment Know and understand the importance of working as a team and guidelines to good teamwork Discover your personal strengths and weaknesses in working cooperatively Discover your preference for dealing with workplace conflict Allot a definition to ergonomics and the terms it include Recognise from where you can get ergonomics information for your area Locate the ways ergonomics could be incorporated for your workplace Evaluate the environment for ergonomic risks, learn to open ways so as to solve the issues, as well as planning for their application. Recheck along with assessing your ergonomic endeavor Apply the change management technique proficiently Relate the fundamental principles linked to ergonomics Get to know outlining ergonomic practices to sit, stand, lift, carry, push, as well as to pull Make designs for an ergonomic workstation Recognise the crucial ergonomic features of tools as well as machines Interpret the role of the environmental factors for example, (sound, air quality, as well as light) play in ergonomics Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Complete Workplace Administration is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Complete Workplace Administration is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 1 What is it, and why? 00:15:00 What to leave in, what to leave out 00:15:00 What's it all about? 00:15:00 A Random Sample 00:30:00 What to Do When You Make a Mistake 00:15:00 Auditing 00:30:00 Putting it Together 00:15:00 Module : 2 Defining Bullying 00:15:00 Why Bullies Do What They Do 00:15:00 Building a Shield Against Bullies 00:15:00 What to Do If It Happens to You 00:30:00 What to Do If You Witness Bullying 00:15:00 Creating an Anti-Bullying Workplace 00:15:00 The Law on Bullying 00:15:00 Module : 3 Defining Conflict 00:15:00 Types of Conflict 00:15:00 Open Conflict vs. Hidden Conflict 00:15:00 Spontaneous and Reflective Behavior 00:15:00 The Johari Window 00:15:00 Stages of Conflict 01:00:00 Conflict Resolution Style Questionnaire 00:15:00 The Role of Communication in Conflict Resolution 00:30:00 Active Listening Skills 00:15:00 Paraphrasing Skills 00:15:00 Powerful Questions 00:15:00 Body Language 00:15:00 The Conflict/Opportunity Test 00:15:00 Conflict and Its Resolution 00:30:00 Helping Others Through Conflict 00:45:00 Module : 4 What Does a Positive Environment Look Like? 00:30:00 What Can I Do? 00:30:00 Team Player 00:15:00 Effective Workplace Relationships (I) 00:45:00 Effective Workplace Relationships (II) 00:30:00 Module : 5 The Case for Wellness 00:15:00 Building the Foundation 00:30:00 Gathering Support 00:15:00 Gathering Data 00:30:00 Performing a Needs Analysis 00:15:00 Implementing Your Workplace Wellness Program 00:15:00 Reviewing the Plan 00:15:00 Evaluating and Reporting Results 00:15:00 Module : 6 Getting Started 00:30:00 The Role of Ergonomics in Your Workplace 00:15:00 The Ergonomic Assessment Cycle 00:05:00 Identifying and Assessing Ergonomic Hazards 00:30:00 Developing a Plan to Address Ergonomic Issues 00:15:00 Identifying and Implementing Solutions 00:15:00 Obtaining Employee Buy-In 00:15:00 Tips for Successful Implementation 00:15:00 Reviewing Your Ergonomics Program 00:15:00 Basic Ergonomic Principles 00:15:00 Optimal Sitting and Standing 00:15:00 Safe Lifting and Transporting 00:15:00 Ergonomic Workstations 00:15:00 Safe Tool Selection and Use 00:15:00 Creating an Ergonomic Environment 00:30:00 Module : 7 What is Workplace Violence? 00:15:00 Understanding the Behavior Wheel 00:15:00 The Anger Management Process 00:30:00 Communicating Better 00:15:00 Basic Problem Solving Tools 01:00:00 Other Ways of Managing Anger 00:15:00 A Systems Approach 00:15:00 Developing a Policy and Program 00:15:00 Risk Assessment 00:30:00 Hiring Practices 00:15:00 Workplace Practices and Procedures 00:15:00 Security Systems and Personnel 00:15:00 Training Programs 00:15:00 Developing Emergency Response Plans 00:15:00 Program Review 00:15:00 The Immediate Response 00:15:00 Consulting with the Experts 00:15:00 Gathering Additional Information 00:15:00 Re-Evaluating Information 00:15:00 Communicating Incidents and Threats 00:15:00 Interviewing Employees 00:15:00 Risk Level Analysis 00:15:00 Reviewing the Options 00:15:00 Analyzing the Impact 00:15:00 Process Application 00:15:00 Module : 8 Defining Harassment 00:15:00 Defining Sexual Harassment 00:30:00 The Purpose of Training 00:15:00 Creating a Harassment Policy 00:30:00 Nipping it in the Bud 00:15:00 Protecting Yourself 00:15:00 What If It Happens to Me? 00:30:00 What If It's Happening to Someone Else? 00:15:00 Someone Has Filed a Complaint Against Me! 00:30:00 Addressing a Complaint 00:15:00 Handling False Complaints 00:15:00 Mediation 00:45:00 Investigating a Complaint 00:45:00 Making the Decision 00:15:00 Creating Solutions 00:15:00 After It's Over 00:15:00 Skill Application 00:15:00

Complete Workplace Administration
Delivered Online On Demand32 hours
£21

Construction Project Administration

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Construction Project Administration bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Construction Project Administration related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Construction Project Administration bundle will help you build a solid foundation to become a proficient worker in the sector. This Construction Project Administration Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Construction Industry Scheme (CIS) Course 2: Property Development Diploma Course 3: Property Management Training Course 4: Real Estate Investor Level 3 Course 5: Public Housing Management Course 6: Construction Management - Level 5 Diploma Course 7: Customer Service Course 8: Document Control and Management Course 9: Fundraising Course 10: Environmental Law & Impact Assessment Course 11: Working at Height Course 12: Effective Communication Skills for Technical People Course 13: Leadership & Management Course 14: Leadership Styles Course 15: Building Surveyor Course 16: Property Law Course 17: Contracts Law UK Course 18: Decision Making in High Stress Course 19: Contract Management Training UK Course 20: Property Business Training - Level 5 Course 21: Residential Property Sales Course 22: Land Surveyor Course 23: Cost Estimation for Multiplex Building with Xactimate Course 24: UK Land Management Complete Training Course 25: Public Speaking Skills - CPD Accredited 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made Construction Project Administration bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Construction Project Administration Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Construction Project Administration bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Construction Project Administration Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Construction Project Administration
Delivered Online On Demand7 days
£259

SEN Teaching Assistant Essentials

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified SEN Teaching Assistant Essentials bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The SEN Teaching Assistant Essentials related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive SEN Teaching Assistant Essentials bundle will help you build a solid foundation to become a proficient worker in the sector. This SEN Teaching Assistant Essentials Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: SEND Teaching Assistant Course 2: Teaching Assistant Diploma Course 3: EYFS Teaching Assistant Course 4: Phonics Teaching Certificate Course 5: Remote Teaching Course 6: Lesson Planning for Teaching Course 7: Learning Disability Nursing Course 8: Nursery Nurse Course 9: Mental Health Teaching Assistant Course 10: ADHD Awareness Course 11: Child Language Disorder (CLD) Course 12: Child Playwork Course 13: Child Neglect Awareness & Protection Course 14: Communication Skills Course 15: Team Management Course 16: The Complete Guide To Getting A Teaching Job Course 17: Leadership in Teaching Course 18: Positive Handling in Schools Course 19: Learning to Learn - Super Learning Course 20: Educational Psychology Course 21: Education Management Course 22: Education and Pedagogy Course 23: Blended Learning Course for Teachers Course 24: Understanding Autism Level 3 Course 25: Health and Safety Training for School Administrators 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1:Career Development Plan Fundamentals Course 2:CV Writing and Job Searching Course 3:Interview Skills: Ace the Interview Course 4:Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Learning Outcome This tailor-made SEN Teaching Assistant Essentials bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This SEN Teaching Assistant Essentials Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the SEN Teaching Assistant Essentials bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in SEN Teaching Assistant Essentials Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

SEN Teaching Assistant Essentials
Delivered Online On Demand7 days
£259

Accountancy Training

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Accountancy Training bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Accountancy Training related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Accountancy Training bundle will help you build a solid foundation to become a proficient worker in the sector. This Accountancy Training Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Xero Accounting and Bookkeeping Online Course 2: Professional Bookkeeping Course 3: Sage 50 Accounting & Payroll Course 4: Introduction to Accounting Course 5: Finance and Accounting Level 1 & 2 Course 6: Business Accounting Training Course 7: Tax Accounting Diploma Course 8: Applied Accounting Course 9: Charity Accounting Course 10: Managerial Accounting Masterclass Course 11: The Theory of Constraints and Throughput Accounting Course 12: Corporate Finance Course 13: Corporate Finance: Profitability in a Financial Downturn Course 14: Financial Statement Analysis Masterclass Course 15: Financial Management Course 16: Financial Reporting Course 17: Investment Banking Course 18: Investment Analyst Course 19: Economics Course 20: Purchase Ledger Course 21: Create Website for Accounting Business Course 22: Changes in Accounting: Latest Trends Encountered by CFOs in 2022 Course 23: Fundamental Accounting for Small Hotel Business Course 24: Anti-Money Laundering (AML) and Financial Crime Course 25: Diploma in Business Analysis 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1:Career Development Plan Fundamentals Course 2:CV Writing and Job Searching Course 3:Interview Skills: Ace the Interview Course 4:Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Learning Outcome This tailor-made Accountancy Training bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Accountancy Training Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Accountancy Training bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Accountancy Training Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Accountancy Training
Delivered Online On Demand7 days
£259

EYFS Comprehensive Teaching Guide

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified EYFS Comprehensive Teaching Guide bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The EYFS Comprehensive Teaching Guide related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive EYFS Comprehensive Teaching Guide bundle will help you build a solid foundation to become a proficient worker in the sector. This EYFS Comprehensive Teaching Guide Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Teaching Assistant Diploma Course 2: SEND Teaching Assistant Course 3: EYFS Teaching Assistant Course 4: Phonics Teaching Certificate Course 5: Remote Teaching Course 6: Lesson Planning for Teaching Course 7: Learning Disability Nursing Course 8: Nursery Nurse Course 9: Mental Health Teaching Assistant Course 10: ADHD Awareness Course 11: Child Language Disorder (CLD) Course 12: Child Playwork Course 13: Child Neglect Awareness & Protection Course 14: Communication Skills Course 15: Team Management Course 16: The Complete Guide To Getting A Teaching Job Course 17: Leadership in Teaching Course 18: Positive Handling in Schools Course 19: Learning to Learn - Super Learning Course 20: Educational Psychology Course 21: Education Management Course 22: Education and Pedagogy Course 23: Blended Learning Course for Teachers Course 24: Understanding Autism Level 3 Course 25: Health and Safety Training for School Administrators 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1:Career Development Plan Fundamentals Course 2:CV Writing and Job Searching Course 3:Interview Skills: Ace the Interview Course 4:Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Learning Outcome This tailor-made EYFS Comprehensive Teaching Guide bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This EYFS Comprehensive Teaching Guide Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the EYFS Comprehensive Teaching Guide bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in EYFS Comprehensive Teaching Guide Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

EYFS Comprehensive Teaching Guide
Delivered Online On Demand7 days
£259

Construction and Safety Management

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Construction and Safety Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Construction and Safety Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Construction and Safety Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Construction and Safety Management Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Construction Management - Level 5 Diploma Course 2: Construction Site Planning and Managment Course 3: Construction Cost Estimation Diploma Course 4: Construction Safety Diploma Course 5: Construction Industry Scheme (CIS) Course 6: Quantity Surveyor Training Course 7: Positive Workplace Environment Course 8: Effective Communication Skills for Technical People Course 9: Leadership Styles Course 10: Workplace First Aid Level 3 Course 11: Workplace Management Training Course 12: COSHH Training for Assessors Course 13: Building Surveyor Course 14: Land Surveying Course 15: Property Management Training Course 16: Property Development Diploma Course 17: Property Law Course 18: Property Business Training - Level 5 Course 19: Residential Property Sales Course 20: Public Housing Management Course 21: WELL Building Standard Course 22: Building Design And Construction With LEED V4.1 Course 23: AutoCAD VBA Programming for Beginners Course 24: AutoCAD Programming using C# with Windows Forms Course 25: Cost Control and Management Training 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made Construction and Safety Management bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Construction and Safety Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Construction and Safety Management bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Construction and Safety Management Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Construction and Safety Management
Delivered Online On Demand7 days
£259

Audit Manager - CPD Accredited

4.5(3)

By Studyhub UK

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Audit Manager bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 30 course mega bundle that will exceed your expectations within your budget. The Audit Manager related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Audit Manager bundle will help you build a solid foundation to become a proficient worker in the sector. This Audit Manager Bundle consists of the following 25 CPD Accredited Premium courses - Course 1: Develop Your Career in Finance: Blue Ocean Strategy Course 2: Finance Principles Course 3: Financial Management Course 4: Improve your Financial Intelligence Course 5: Dealing With Uncertainity: Make Budgets and Forecasts Course 6: Introduction to Corporate Finance Course 7: Raising Money & Valuations Course 8: Cost Control Process and Management Course 9: Debt Management - Online Course Course 10: Anti Money Laundering (AML) Level 3 Training Course 11: Sage 50 Accounts Course 12: Commercial Law Course 13: Tax Accounting Course 14: Introduction to VAT Course 15: Corporate Finance: Working Capital Management Course 16: Financial Ratio Analysis for Business Decisions Course 17: Financial Modeling Using Excel Course 18: Fundamentals of Zero Based Budgeting Course 19: Financial Analysis : Finance Reports Course 20: Financial Reporting Course 21: Presenting Financial Information Course 22: Financial Wellness: Managing Personal Cash Flow Course 23: Understanding Financial Statements and Analysis Course 24: Banking and Finance Accounting Statements Financial Analysis Course 25: Financial Statements Fraud Detection Training 5 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5: Create a Professional LinkedIn Profile Learning Outcome This tailor-made Audit Manager bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Audit Manager Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Audit Manager bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Audit Manager Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Audit Manager - CPD Accredited
Delivered Online On Demand7 days
£259