9925 Concept courses delivered Online

Arabic Legal Writing and Drafting Skills Why Attend This course focuses on clear legal writing in Arabic. Effective communication with lawyers is about more than simply words. It entails understanding the unique way lawyers think and approach the legal, political, and business world. During this Arabic course, a number of legal documents are discussed, including drafting contracts, letters, policies and company bylaws. Participants also look at a wide variety of commercial agreements during practical drafting sessions. This course helps participants to draft confidently and effectively in Arabic regardless of the governing law. Course Methodology The course consists of group discussions as well as individual and team tasks. There will be writing practice throughout the exercises. Course Objectives By the end of the course, participants will be able to: Apply a plain Arabic style of writing to all legal documents Recognize the need for legal clarity in different types of legal documents: legal letters, emails, memorandum and opinions Apply good legal writing practice Use best practice techniques to write contracts, letters, policies and company bylaws Correct common mistakes in legal writing Address and deal with challenges and issues relating to the use of legal jargon Proofread effectively Target Audience The course is suitable for Arabic speakers looking for a better understanding of how to write Arabic legal documents. This course is for lawyers, legal secretaries, commercial managers, contract managers, HR executives and managers, purchasing managers, tender executives and anyone who must draft, amend or update contracts, legal letters and company policies and bylaws.  Target Competencies Drafting letters, policies, company bylaws and contracts Proofreading Writing in plain Arabic Understanding legal terms Legal writing practice Note The Dubai Government Legal Affairs Department has introduced a Continuing Legal Professional Development (CLPD) programme to legal consultants authorised to practice through a licensed firm in the Emirate of Dubai. We are proud to announce that the Dubai Government Legal Affairs Department has accredited EMG Associates as a CLPD provider. In addition, all our legal programmes have been approved. Basic legal writing concepts and contract drafting The various types of legal documents Tips in writing bilingual legal documents Signs of a well drafted contract; the simple rules! The language of drafting Identifying the legal formalities for a binding contract Structure and formation of a commercial contract: following the formula The importance of Boilerplate clauses Plain Arabic in legal correspondence and writing a legal letter Good legal writing practice Pitfalls and issues relating to the use of legal jargon in legal writing Writing different types of emails Layout of a letter Body of a letter Putting a letter together Typical sentences in legal letters The letter writing clinic: looking at the ten most common problems Writing a legal policy or company bylaw and legal writing troubleshooting Layout of a policy or bylaw Body of a policy or bylaw How to write the best policy or bylaw Understanding the principles of legal interpretation The four defects that affect legal writing Use of consistent terminology Easily confused words How courts react to legal writing and what to expect

Counselling helps couples and families understand one another, take time out of their hectic lives and focus on themselves. Learn how to create a better functioning home environment with your excellent counselling skills gained from this Couple and Family Counselling Training course.  The Couple and Family Counselling Training course will provide you with a clear concept of couples and family counselling. In addition, It will enhance your ability to strengthen family relationships. Our in-depth training will teach you how to treat mental disorders and relationship issues. You'll learn to counsel trauma and substance abuse, personality disorders, and stress and anxiety disorders. On top of that, the training will enrich your knowledge of promoting empathy within a family and helping couples regain trust. Enrol today! Learning Objectives Gain deep insights into couple and family counselling Be able to improve and strengthen relationships Learn how to treat various mental health disorders Discover the ethical issues in counselling Know how to prevent self-harm and suicide Take measures to avoid family conflicts Who is this Course for? This Couple and Family Counselling Training course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of couple and family counselling or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy, and ICT are required to attend this course. 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 Upon successfully completing the Couple and Family Counselling Training course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Counsellor Family Counselor Marriage and Family Therapist Mental Health Counselor Depression Counselor Course Curriculum Module 01 : Counselling and Counsellors Counselling and Counsellors 00:13:00 Module 02 : Theories and Models of Counselling (Part 1) Theories and Models of Counselling (Part 1) 00:16:00 Module 03 : Theories and Models of Counselling (Part 2) Theories and Models of Counselling (Part 2) 00:18:00 Module 04 : Legal, Cultural and Ethical Issues in Professional Counselling Legal, Cultural and Ethical Issues in Professional Counselling 00:16:00 Module 05 : Forms of Psychotherapy Forms of Psychotherapy 00:21:00 Module 06 : Couple and Family Counselling Couple and Family Counselling 00:28:00 Module 07 : Counselling Trauma and Substance Abuse Counselling Trauma and Substance Abuse 00:16:00 Module 08 : Counselling Stress and Anxiety Disorders Counselling Stress and Anxiety Disorders 00:30:00 Module 09 : Counselling Personality Disorders Counselling Personality Disorders 00:50:00 Module 10 : Counselling Mood Disorders and Depression Counselling Mood Disorders and Depression 00:22:00 Module 11 : Counselling Eating & Sleeping Disorders Counselling Eating & Sleeping Disorders 00:45:00 Module 12 : Counselling Self-Harm and Suicide Counselling Self-Harm and Suicide 00:17:00 Module 13 : Communication Skills and Empathy in Counselling Communication Skills and Empathy in Counselling 00:19:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The event management and planning industry is growing and reshaping swiftly every day. If you find your passion attached to this field, then the Event Planner course can help you bring a spectacular opportunity to you. Learn the ins and outs and the different crucial aspects of event management from our on-demand-course Event Planner and take the first step to be an event planner. Our Event Planner course lessons are prepared by industry-leading experts with feature interactive activities. You'll learn how you can use various devices effectively from industry experts. This Event Planner course has been divided into understandable and manageable sections that we feel will help you grasp each concept- from the basic to advanced course components. Learn from industry experts today and enhance your skills and knowledge so that you can lead tomorrow. This Event Planner course will increase your possibility to get your desired job and boost your personal growth. Enjoy a pleasant and professional 100% online learning experience and enrol in our Event Planner course today and take control of your career! Learning Objectives Learn the principles of event management Understand how to choose the perfect place for your event Get to know about interior and outdoor designing Be able to use lighting to create beautiful designs Understand how to deal with difficult clients Acquire the skills to plan food menus and entertainments based on that type of event Be able to manage after-event residue Understand the importance of recycling and cleaning Who is this Course for? The Event Planner course is ideal for highly aspiring individuals who wish to enhance their professional skills and train for the job they want! Also, this course is highly beneficial for people who want to have some in-depth knowledge on this topic and keep up to date with the latest information. So, you can enrol in this course if you are: Organisers Event Planners Event Managers Personal Assistants Designers Study the Event Planner course today and enhance your professional skillset from the comfort of your home! Entry Requirements There are no formal entry requirements for the Event Planner course; with enrollment, this course is open to anyone! Anyone with a passion for learning about event management can enrol in this course without any hesitation. Although, the learner needs to have a good understanding of the English language to attend this course and understand what this course is about. 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 This Event Planner course will help you gain all the necessary theoretical knowledge to excel in the relevant field. Enrol on our event management course now and get started on the journey of taking your career to the next level. Course Curriculum Module 1: Introduction to Event Management Introduction to Event Management 00:24:00 Module 2: Role of an Event Planner Role of an Event Planner 00:31:00 Module 3: Event Classification Event Classification 00:28:00 Module 4: Events and Clients Events and Clients 00:18:00 Module 5: Steps to Plan an Event Steps to Plan an Event 00:27:00 Module 6: Invitation to the Event Invitation to the Event 00:25:00 Module 7: Event Marketing Event Marketing 00:31:00 Module 8: Catering at Events Catering at Events 00:22:00 Module 9: Event Decorations Event Decorations 00:25:00 Module 10: Cleaning and Waste Disposal Cleaning and Waste Disposal 00:20:00 Module 11: Event Security Event Security 00:16:00 Module 12: Developing an Event Planning Business Developing an Event Planning Business 00:23:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Compassionate and patient, nursery assistants care for preschool age children attending to their daily needs and preparing them for kindergarten.  Do you love to work with children and wish to see them grow up properly? Then Nursery Assistant Certificate can help you materialise your dream letting you be a perfect nursery assistant. Learn the skills and knowledge you need to build your career as a nursery assistant from the comprehensive and interactive Nursery Assistant Certificate course today. This course is designed for those who want to understand children better and take care of them. The course is divided into easily understandable and bite-sized modules that will help you get the knowledge, understand and memorize them easily. You will be able to get the attention and help you need to complete the course. This course will allow you to learn whenever And however you want. Our Nursery Assistant Certificate course lessons are prepared by experts and feature interactive activities. You'll learn how you can use various devices effectively from industry experts. This Nursery Assistant Certificate course has been divided into understandable and manageable sections that we feel will help you grasp each concept- from the basic to advanced course components. Learn from industry experts today and enhance your skills and knowledge in no time. This Nursery Assistant Certificate course will increase your possibility to get your desired job and boost your personal growth. 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? The Nursery Assistant Certificate course is ideal for highly aspiring individuals who wish to enhance their professional skills and train for the job they want! Also, this course is highly beneficial for people who want to have some in-depth knowledge on this topic and keep up to date with the latest information. So, you can enrol in this course if you are: Primary Teacher Nursery Assistant Child Carer SEN Teacher Teaching Assistant Early Years Foundation Stage (EYFS) Teacher Study the Nursery Assistant Certificate course today and enhance your professional skillset from the comfort of your home! Entry Requirement Anyone interested in learning more about this subject should take this Nursery Assistant Certificate 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 This Nursery Assistant Certificate course will help you gain all the necessary theoretical knowledge to excel in the relevant field. Enrol on our Nursery Assistant Certificate course now and get started on the journey of taking your career to the next level. Course Curriculum Module 01: Introduction to Nursery Assistance Introduction to Nursery Assistance 00:11:00 Module 02: Understanding Child Development Understanding Child Development 00:24:00 Module 03: Importance of Early Years Development Importance of Early Years Development 00:19:00 Module 04: Care for Children Care for Children 00:17:00 Module 05: Keeping Children Healthy and Safe Keeping Children Healthy and Safe 00:27:00 Module 06: Child Protection Child Protection 00:23:00 Module 07: Play, Imagination and Creativity Play, Imagination and Creativity 00:26:00 Module 08: Children with Special Needs Children with Special Needs 00:34:00 Mock Exam Mock Exam - Nursery Assistant Certificate 00:20:00 Final Exam Final Exam - Nursery Assistant Certificate 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

The English Spelling, Punctuation, and Grammar is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with a Certificate of Achievement.  This English Spelling, Punctuation, and Grammar course consists of several modules. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Learning Outcomes Learn about the basics of English grammar Get familiar with the structure of sentence with examples Learn about punctuation and capitalisation You'll also learn about spelling and question Know the common mistakes and the ways to improve them Why Choose this Course? Earn a digital 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 This English Spelling, Punctuation, and Grammar course is delivered through our online learning platform, accessible through any internet-connected device. No formal deadlines or teaching schedules are included, that aids a flexible study plan.   We broke down the course into several manageable modules which we believe will assist you to grasp each concept more efficiently - from the fundamentals to the most advanced aspects of the course. The experts will teach you through a combination of: Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Why study this course You will learn everything that is needed regarding English Spelling, Punctuation, and Grammar. This is an excellent opportunity for anyone from any academic backgrounds to learn more and advance their learning, launch a new career or reinvigorate an existing one. Who is this course for This is one of the best English spelling courses online and suitable for anyone who wants to gain extensive knowledge, potential experience, and expert skills in the related field. Industry experts designed this course, so you don't have to worry about the quality. Requirements This course is open to all, with no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16. Career Path Training offered by the education management course could potentially benefit a range of roles, but would particularly enhance careers in- English Teacher Proofreader Content writer Editor Other related expert roles

Every organisation needs leaders who can think and act strategically. This program will help you clarify: Why you exist (strategic purpose) Where you are now (strategic assessment) Where you want to go (strategic development) How to get there (strategic execution)

MPLS training course description A hands-on introduction to MPLS covering the basics of what MPLS is and how to configure it, through to more advanced concepts such as MPLS VPNs and traffic engineering with MPLS. What will you learn Describe MPLS Explain how MPLS works Describe the interaction between OSPF/IS-IS/BGP and MPLS Describe MPLS traffic engineering MPLS training course details Who will benefit: Anyone working with MPLS. Prerequisites: IP Routing BGP Duration 3 days MPLS training course contents What is MPLS? What does MPLS stand for? What is MPLS? Core MPLS, MPLS and the 7 layer model, MPLS is a protocol, MPLS is a standard, MPLS runs on routers, MPLS history, Why MPLS? For service providers, For enterprises. MPLS Architecture Label Switch Routers, two types of LSR, PE and P router roles, FEC, swapping labels, MPLS packet format, Loops, TTL control. Hands on: Building the base network. Enabling MPLS. Simple testing and troubleshooting of MPLS. Label distribution Label review, label switch path, label distribution methods, piggybacking, Label distribution Protocols, LDP, LDP operation, LDP packets, discovery messages, session messages, advertisement messages, notification message, Label Information Base, routing tables, the LFIB, MPLS forwarding, penultimate hop popping, handling labels, LSP control modes, when to distribute labels, how long to keep labels, aggregation, label merging. Hands on: LDP traffic analysis. MPLS TE and QoS What is MPLS TE? Why TE? TE versus shorted path, how MPLS TE works, CR-LDP, OSPF-TE, IS-IS-TE, TE with BGP, RSVP-TE, MPLS Fast reroute, MPLS QoS. Hands on: Enabling MPLS-TE. BFD BFD, hello the BFD protocol. MPLS VPN What is a VPN? MPLS VPN types, MPLS VPN comparison, MPLS L3 VPN, VRFs, MBGP, MPLS VPN architecture, VRF RD, VRF RT, the label stack, L2 VPNs, VPWS, AToM, VPLS. Hands on: MPLS L3 VPN setup, troubleshooting.

Duration 5 Days 30 CPD hours This course is intended for This course is designed for people who are seeking to launch a career in cybersecurity. Overview Assess the security posture of an enterprise environment and recommend and implement appropriate security solutions; Monitor and secure hybrid environments, including cloud, mobile, and IoT; Operate with an awareness of applicable laws and policies, including principles of governance, risk, and compliance; Identify, analyze, and respond to security events and incidents. CompTIA Security+ is a global certification that validates the baseline skills necessary to perform core security functions and is the first security certification a candidate should earn. CompTIA Security+ establishes the core knowledge required of any cybersecurity role and provides a springboard to intermediate-level cybersecurity jobs. Lesson 1: Summarize Fundamental Security Concepts Security Concepts Security Controls Lesson 2: Compare Threat Types Threat Actors Attack Surfaces Social Engineering Lesson 3: Explain Cryptographic Solutions Cryptographic Algorithms Public Key Infrastructure Cryptographic Solutions Lesson 4: Implement Identity and Access Management Authentication Authorization Identity Management Lesson 5: Secure Enterprise Network Architecture Enterprise Network Architecture Network Security Appliances Secure Communications Lesson 6: Secure Cloud Network Architecture Cloud Infrastructure Embedded Systems and Zero Trust Architecture Lesson 7: Explain Resiliency and Site Security Concepts Asset Management Redundancy Strategies Physical Security Lesson 8: Explain Vulnerability Management Device and OS Vulnerabilities Application and Cloud Vulnerabilities Vulnerability Identification Methods Vulnerability Analysis and Remediation Lesson 9: Evaluate Network Security Capabilities Network Security Baselines Network Security Capability Enhancement Lesson 10: Assess Endpoint Security Capabilities Implement Endpoint Security Mobile Device Hardening Lesson 11: Enhance Application Security Capabilities Application Protocol Security Baselines Cloud and Web Application Security Concepts Lesson 12: Explain Incident Response and Monitoring Concepts Incident Response Digital Forensics Data Sources Alerting and Monitoring Tools Lesson 13: Analyze Indicators of Malicious Activity Malware Attack Indicators Physical and Network Attack Indicators Application Attack Indicators Lesson 14: Summarize Security Governance Concepts Policies, Standards, and Procedures Change Management Automation and Orchestration Lesson 15: Explain Risk Management Processes Risk Management Processes and Concepts Vendor Management Concepts Audits and Assessments Lesson 16: Summarize Data Protection and Compliance Concepts Data Classification and Compliance Personnel Policies Additional course details: Nexus Humans CompTIA Security Plus Certification (Exam SY0-601) 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 CompTIA Security Plus Certification (Exam SY0-601) 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.

Software development training course description This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-361, and build an understanding of these topics: Core programming, Object-Oriented programming, general software development, web applications, desktop applications, and databases. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam. What will you learn Describe core programming. Explain Object Oriented programming. Describe general software development. Describe Web applications. Describe desktop applications. Explain how databases work. Software development training course details Who will benefit: Anyone looking to learn the fundamentals of software. Prerequisites: None. Duration 3 days Software development training course contents Core programming Computer storage and data types How a computer stores programs and the instructions in computer memory, memory stacks and heaps, memory size requirements for the various data storage types, numeric data and textual data. Computer decision structures Various decision structures used in all computer programming languages; If decision structures; multiple decision structures, such as If…Else and switch/Select Case; reading flowcharts; decision tables; evaluating expressions. Handling repetition For loops, While loops, Do...While loops and recursion. Understand error handling Structured exception handling. Object-oriented programming Classes Properties, methods, events and constructors; how to create a class; how to use classes in code. Inheritance Inheriting the functionality of a base class into a derived class. Polymorphism Extending the functionality in a class after inheriting from a base class, overriding methods in the derived class. Encapsulation Creating classes that hide their implementation details while still allowing access to the required functionality through the interface, access modifiers. General software development Application life cycle management Phases of application life cycle management, software testing. Interpret application specifications Application specifications, translating them into prototypes, code, select appropriate application type and components. Algorithms and data structures Arrays, stacks, queues, linked lists and sorting algorithms; performance implications of various data structures; choosing the right data structure. Web applications Web page development HTML, CSS, JavaScript. ASP.NET web application development Page life cycle, event model, state management, client-side versus server-side programming. Web hosting Creating virtual directories and websites, deploying web applications, understanding the role of Internet Information Services. Web services Web services that will be consumed by client applications, accessing web services from a client application, SOAP, WSDL. Desktop applications Windows apps UI design guideline categories, characteristics and capabilities of Store Apps, identify gestures. Console-based applications Characteristics and capabilities of console- based applications. Windows Services Characteristics and capabilities of Windows Services. Databases Relational database management systems Characteristics and capabilities of database products, database design, ERDs, normalisation concepts. Database query methods SQL, creating and accessing stored procedures, updating and selecting data. Database connection methods Connecting to various types of data stores, such as flat file; XML file; in-memory object; resource optimisation.

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.