5519 Productivity courses delivered Online

Excel in Hybrid Team Management with our course tailored for today's workplace. Gain essential skills to lead hybrid teams effectively, from initiation to evaluation, ensuring high performance.

Diploma in Security Management will assist you in producing the best possible outcome by mastering the skills. Those who want to succeed must enrol in the course Diploma in Security Management. By completing this course, you will acquire the skills required to become an expert in a comparable field. The basics of our Diploma in Security Management course are covered first, and then we move on to more advanced material. The lessons in this Diploma in Security Management course are therefore clear and easy to understand. Courses you'll get: Course 01: Diploma in Security Management Course 02: Computer Networks Security from Scratch to Advanced Course 03: Cyber Security Course 04: Compliance Audit & Risk Management Course 05: GDPR Course 06: AML Awareness Training Diploma in Security Management Course Basic Learning Outcomes: After completing this highly appreciated Diploma in Security Management course, you'll be a competent expert, besides- You can give assistance related to the Diploma in Security Management with complete knowledge and confidence. You'll be competent and proficient enough to explore Diploma in Security Management related job fields on your own. Furthermore, you can train up others and grow an efficient peer community in your locality and serve people. It will enhance your portfolio, you can use the certificate as proof of your efficiency to the employer. It will boost up your productivity, you can use the skill and credentials, and become more competent in your vocation with increased earning! Key Highlights of Diploma in Security Management Course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced Course Modules Covers to Explore Multiple Job Positions Curriculum Breakdown of the Course:- Module 01: Introduction to Security Management Module 02: Organisational Security Management Module 03: Security Risk Analysis and Risk Reduction Module 04: Physical and Information Security Protection Module 05: Business Resilience and Crisis Management Module 06: Cyber Security and Fraud Prevention Module 07: Security Investigations and Threat Awareness Module 08: Laws and Regulations Certification: CPD Accredited (CPD QS) Certificate Digital (PDF) & Hardcopy certificates are available CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Diploma in Security Management course. This course particularly recommended for- Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Requirements Students seeking to enrol for Diploma in Security Management course should meet the following requirements; Basic knowledge of English Language Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platforms. Stable Internet or Data connection in your learning devices. Career path After completing this course, you can explore trendy and in-demand jobs related to Diploma in Security Management. Explore each of the roles available and how you can start your career in this platform. Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free. Certificate of completion Hard copy certificate - £9.99 After successfully completing this course, you can get CPD accredited hardcopy certificate for free. The delivery charge of the hardcopy certificate inside the UK is £3.99 and international students need to pay £9.99 to get their hardcopy certificate.

Diploma in Anti Money Laundering (AML) will assist you in producing the best possible outcome by mastering the skills. Those who want to succeed must enrol in the course Diploma in Anti Money Laundering (AML). By completing this course, you will acquire the skills required to become an expert in a comparable field. The basics of our Diploma in Anti Money Laundering (AML) course are covered first, and then we move on to more advanced material. The lessons in this Diploma in Anti Money Laundering (AML) course are therefore clear and easy to understand. Courses you'll get: Course 01: Diploma in Anti Money Laundering (AML) Course 02: Financial Investigator/Fraud Investigator Course 03: Financial Analysis Course 04: Internal Compliance Auditor Course 05: Financial Reporting Course 06: Risk Management For Business Diploma in Anti Money Laundering (AML) Course Basic Learning Outcomes: After completing this highly appreciated Diploma in Anti Money Laundering (AML) course, you'll be a competent expert, besides- You can give assistance related to the Diploma in Anti Money Laundering (AML) with complete knowledge and confidence. You'll be competent and proficient enough to explore Diploma in Anti Money Laundering (AML) related job fields on your own. Furthermore, you can train up others and grow an efficient peer community in your locality and serve people. It will enhance your portfolio, you can use the certificate as proof of your efficiency to the employer. It will boost up your productivity, you can use the skill and credentials, and become more competent in your vocation with increased earning! Key Highlights of Diploma in Anti Money Laundering (AML) Course: CPD Accredited Course Unlimited Retake Exam & Tutor Support Easy Accessibility to the Course Materials 100% Learning Satisfaction Guarantee Lifetime Access & 24/7 Support Self-paced Course Modules Curriculum Breakdown of the Course: Module 01: Introduction to Money Laundering Module 02: Proceeds of Crime Act 2002 Module 03: Development of Anti-Money Laundering Regulation Module 04: Responsibility of the Money Laundering Reporting Officer Module 05: Risk-based Approach Module 06: Customer Due Diligence Module 07: Record Keeping Module 08: Suspicious Conduct and Transactions Module 09: Awareness and Training Certification: CPD Accredited (CPD QS) Certificate Digital (PDF) & Hardcopy certificates are available CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Diploma in Anti Money Laundering (AML) course. This course particularly recommended for- Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Requirements Students seeking to enrol for Diploma in Anti Money Laundering (AML) course should meet the following requirements; Basic knowledge of English Language Be age 16 years or above Basic Knowledge of Information & Communication Technologies for studying online or digital platform. Stable Internet or Data connection in your learning devices. Career path After completing this course, you can explore trendy and in-demand jobs related to Diploma in Anti Money Laundering (AML). Explore each of the roles available and how you can start your career in this platform. Certificates Certificate of completion Digital certificate - Included After successfully completing this course, you can get CPD accredited digital PDF certificate for free.Certificate of completion Hard copy certificate - £9.99 After successfully completing this course, you can get CPD accredited hardcopy certificate for free. The delivery charge of the hardcopy certificate inside the UK is £3.99 and international students need to pay £9.99 to get their hardcopy certificate.

Employees are more productive and motivated when they feel a good sense of involvement in establishing their organisation's

Dynamic Arrays in Microsoft Excel Training Course Overview Are you looking to begin your Microsoft Office Excel career or want to develop more advanced skills in Microsoft Office Excel? Then this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and help you to develop your expertise in Microsoft Office Excel. This dynamic arrays in Microsoft Excel training course is accredited by the CPD UK & IPHM. CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. Gain the essential skills and knowledge you need to propel your career forward as an office admin. The dynamic arrays in Microsoft Excel training course will set you up with the appropriate skills and experience needed for the job and is ideal for both beginners and those currently working as an office admin. This comprehensive dynamic arrays in Microsoft Excel training course is the perfect way to kickstart your career in the field of Microsoft Office Excel. This dynamic arrays in Microsoft Excel training course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. If you're interested in working as an office admin or want to learn more skills on Microsoft Office Excel but unsure of where to start, then this dynamic arrays in Microsoft Excel training course will set you up with a solid foundation to become a confident office admin and develop more advanced skills. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This dynamic arrays in Microsoft Excel training course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Who should take this course? This comprehensive dynamic arrays in Microsoft Excel training course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of Microsoft Office Excel. Entry Requirement There are no academic entry requirements for this dynamic arrays in Microsoft Excel training course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Method of Assessment On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately.. Career path This dynamic arrays in Microsoft Excel training course opens a brand new door for you to enter the relevant job market and also provides you with the chance to accumulate in-depth knowledge at the side of needed skills to become flourishing in no time. You will also be able to add your new skills to your CV, enhance your career and become more competitive in your chosen industry. Recognised Accreditation CPD Certification Service This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Ignite your email marketing prowess with our compact yet comprehensive "Professional Email Writing & Email Marketing Masterclass" course bundle. Master email writing, learn advanced email marketing strategies, build efficient email lists, create stunning HTML email templates, write compelling copy, and boost your typing speed with touch typing. This isn't just theory; it's about equipping you with competitive skills to excel in the evolving digital marketing landscape. Enrol now - your journey to becoming an email marketing superstar starts here. Act fast, limited spots available! This Professional Email Writing & Email Marketing Masterclass Bundle Comprises the Following CPD Accredited Courses: Course 01: Email Writing: Styles and Templates Course 02: Email Marketing Masterclass Course 03: Essential Strategies to Create an Email List Course 04: Create a Responsive HTML Email Template Course 05: Affiliate Marketing Course 06: Copywriting Course Course 07: Copyediting & Proofreading Course 08: Touch Typing Essentials What will Make You Stand Out? On completion of this Professional Email Writing & Email Marketing Masterclass bundle, you will gain the following: CPD QS Accredited courses After successfully completing the Email Writing Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. Enrolling in the Email Writing Course has no additional cost. 24x7 Tutor Support You can study and complete the Email Writing course at your own pace. For the price of ONE, we're giving you SIX comprehensive CPD Accredited courses that will transform your emailing from a daunting task to an exciting journey of connection, engagement and business growth! 1. Email Writing: Styles and Templates: Learn the secret language of impactful email communications, unlock the power of compelling content, and get your hands on ready-to-use, bespoke templates that are sure to impress your recipients! 2. Email Marketing Masterclass: Whether you're a novice or a seasoned email marketer, this masterclass will teach you the art of creating captivating email campaigns that will drive traffic, boost conversions, and rocket your ROI! 3. Essential Strategies to Create an Email List: Every great campaign starts with a strong email list. Master the most effective list-building strategies to attract quality subscribers and foster lasting relationships. 4. Create a Responsive HTML Email Template: In the era of mobile users, responsiveness is the key. This course will guide you through creating stunning, mobile-friendly HTML emails that look fantastic on any device! 5. Copywriting Course: Words are your most powerful weapon. Learn how to wield them effectively with the tricks and techniques of the world's most successful copywriters! 6. Touch Typing Essentials: Boost your productivity with the power of touch typing. Increase your typing speed and accuracy, giving you more time to focus on what matters most! Show off your new skills with a certificate of completion. After successfully completing the Professional Email Writing & Email Marketing Masterclass course bundle, you can order your CPD Accredited PDF Certificates for Free as proof of your achievement. You can order Hardcopy CPD Accredited Certificates for £4.99. Please Note: The delivery charge inside the U.K. is absolutely free, and international students have to pay £8.99. CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Professional Email Writing & Email Marketing Masterclass Bundle is open to everybody including: Professionals are seeking to enhance their email writing & email marketing skills. Digital Marketing personnel's seeking to boost their sales. Job seekers aim to create compelling emails. Copywriters and marketers are refining persuasive writing. Individuals are improving their proofreading and editing abilities. Those interested in enhancing typing speed for efficient emailing. Requirements Without any formal requirements, you can delightfully enrol in this Professional Email Writing & Email Marketing Masterclass bundle. Just get a device with internet connectivity, and you are ready to start your learning journey. Thus, complete this course at your own pace. Career path Our Email Writing & Email Marketing Masterclass bundle will prepare you for a range of careers, including: Business Manager/ Executive Email Marketing Specialist Email Marketing Manager Digital Marketing Manager Marketing Automation Specialist CRM Manager Content Writer/Copywriter Marketing Assistant Communications Manager PR Specialist

Feeling Stuck in Your Career? The HR Management Bundle for HR Managers! Bundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the HR Management bundle provides an engaging learning experience, helping you learn skills across various disciplines. With the HR Management Bundle for HR Managers! Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The HR Management bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the HR Management bundle on your job life and career growth! This HR Management Bundle for HR Managers! Bundle Comprises the Following CPD Accredited Courses: Course 01: HR Management Course Course 02: Recruitment Consultant Diploma Course 03: Safer Recruitment Training Course 04: UK Employment Law Course 05: Certificate in HR Audit Course 06: Operations Management: Enterprise Resource Planning Course 07: Operations Management: Resource & Workout Layout Course 08: HR Technology Implementation: Preparing Your Team for Success Course 09: Key Performance Indicators Professional Course 10: Employee Hiring and Termination Training Course 11: Virtual Interviewing for HR Course 12: Leadership and Management Course Course 13: Office Administration Course 14: Delegation Skills Course 15: Team Management Course 16: Organisation & People Management Course 17: Change Management Course 18: Performance Management Level 3 Course 19: Workplace Productivity Training Course 20: Motivation - Motivating Yourself & Others Course 21: Conflict Resolution Course 22: Corporate Risk And Crisis Management - Online Course Course 23: Workplace Stress Management Course 24: Crisis Communication for HR Course 25: Equality, Diversity and Discrimination Course 26: Cross-Cultural Awareness Training Course 27: Build HR Dashboard using Excel Course 28: Learn Advanced Fundamentals of HR Dashboard Course 29: Networking Skills for Personal Success Course 30: Decision-Making and Critical Thinking What will make you stand out? Upon completion of this online HR Management Bundle for HR Managers! Bundle, you will gain the following: CPD QS Accredited Proficiency with this HR Management bundle After successfully completing the HR Management bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this HR Management bundle The online test with immediate results You can study and complete the HR Management bundle at your own pace. Study for the HR Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. The HR Management Bundle for HR Managers! bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience, designed to enrich both your personal and professional development. Advance the future of learning with the HR Management bundle, a comprehensive complete collection of 30 courses. Each course in the HR Management bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the HR Management bundle offers the flexibility and convenience to learn at your own pace. Make the HR Management package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The HR Management Bundle for HR Managers! is perfect for: Expand your knowledge and skillset for a fulfilling career with the HR Management bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the HR Management bundle. Discover your passion or explore new career options with the diverse learning opportunities in the HR Management bundle. Learn on your schedule, in the comfort of your home - the HR Management bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the HR Management Bundle for HR Managers! bundle. Certificates CPD Certificates Digital certificate - Included

Feeling Stuck in Your Career? The Leadership & Management - 30 CPD Courses Bundle! is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Leadership & Management bundle provides an engaging learning experience, helping you learn skills across various disciplines. With the Leadership & Management - 30 CPD Courses Bundle!Bundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Leadership & Management bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Leadership & Management bundle on your job life and career growth! This Leadership & Management - 30 CPD Courses Bundle!Bundle Comprises the Following CPD Accredited Courses: Course 01: Leadership and Management Course Course 02: Building a Foundation for Leadership Success Course 03: Inspirational Leadership Skills: Practical Motivational Leadership Course 04: Creating an Innovation Culture Course 05: Day-to-Day Leadership Course 06: The Principles of Ethical Leadership Course 07: Leadership Skills For Organisational Development Course 08: Foundations of Leadership and Negotiation Skills Development Course 09: Supervisor Training Course 10: UK Employment Law Course 11: Delegation Skills Course 12: Personal Development Masterclass Course 13: Emotional Intelligence and Human Behaviour Course 14: Team Management Level 5 Course 15: Talent Management Level 3 Course 16: Diary Management Course 17: Business Management Course 18: Administrative Management Course 19: Project Management Course 20: Courageous Communication Strategies for Lead Course 21: Body Language Masterclass Communication Through Movement Course 22: Public Speaking: Presentations like a Boss Course 23: Equality, Diversity and Discrimination Course 24: Workplace Productivity Training Course 25: Legal Secretary and Office Skills Diploma Course 26: Conflict Resolution Course 27: Workplace Stress Management Course 28: Diploma in Risk Management Level 7 Course 29: Dealing With Difficult People In Life & Work Course 30: Decision-Making in High-Stress Situations What will make you stand out? Upon completion of this online Leadership & Management - 30 CPD Courses Bundle!Bundle, you will gain the following: CPD QS Accredited Proficiency with this Leadership & Management bundle After successfully completing the Leadership & Management bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Leadership & Management bundle The online test with immediate results You can study and complete the Leadership & Management bundle at your own pace. Study for the Leadership & Management bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Leadership & Management - 30 CPD Courses Bundle!bundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience, designed to enrich both your personal and professional development. Advance the future of learning with the Leadership & Management bundle, a comprehensive, complete collection of 30 courses. Each course in the Leadership & Management bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Leadership & Management bundle offers the flexibility and convenience to learn at your own pace. Make the Leadership & Management package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Leadership & Management - 30 CPD Courses Bundle! is perfect for: Expand your knowledge and skillset for a fulfilling career with the Leadership & Management bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Leadership & Management bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Leadership & Management bundle. Learn on your schedule, in the comfort of your home - the Leadership & Management bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Leadership & Management - 30 CPD Courses Bundle! Certificates CPD Certificate Digital certificate - Included

MySQL server admins training course description This MySQL Server administration course is designed for MySQL Server administrators who have a basic understanding of a MySQL database and a good working knowledge of SQL commands. The course provides an understanding of MySQL Architecture and practical experience in setting up, configuring and maintaining a MySQL server, backing up and recovering data and optimising query performance. This MySQL Server administration course also covers MySQL replication and its role in high availability and scalability. What will you learn Use MySQL Workbench. Install and configure a MySQL Server . Administer and tune a MySQL server. Configure log files and interpret error messages.. Secure the Server. Administer a replication topology. MySQL server admin training course details Who will benefit: Database administrators, Database developers and Technical consultants. Prerequisites: Introduction to MySQL Duration 5 days MySQL server admin training course contents Introduction to Oracle Application Express APEX concepts APEX main components Workspaces, database applications and websheet applications Creating a workspace The Workspace Administrator Upgrading APEX Logging into APEX Running an application SWL Workshop Use APEX to browse, create and modify objects Process ad hoc SQL statements Manage scripts in APEX Create, run and save SQL queries Build a database application Application components Create an application Create an application from a spreadsheet Create reports Create reports using wizards Edit report attributes Add links to reports Create a link to a printer-friendly version of a report Save and print reports in different formats Using files Uploading images Creating cascading stylesheet files Uploading static files Adding an Image as an application logo Adding a reference to a Javascript file Pages and regions Web form behaviour in APEX Create a form based on a table Create a form based on a procedure Create a form with a report Create a tabular form Format a form Locking in APEX forms Creating lists of values Overview of application express shared Components Dynamic and static lists of values Create a dynamic list of values Create a static list of values Use a list of values to control data in a report Create a cascading list of values Items and buttons Understand the different Types of items Create items Understand and edit item attributes Use Javascript with item Manipulate items in tabular forms Add dynamic items to a report Create and edit buttons Page Processing Page rendering and page processing Create computations Validate input data Process Data Understand application branching Create conditional branches Shared components Overview of application express navigation components Manage parent and standard tabs Create navigation bar entries Create and use lists and list items Manage breadcrumbs Create shortcuts Shared component subscription User interface defaults Display dynamic content Filter reports with dynamic queries Create charts with a wizard Format charts Create calendars Add links to calendars Create hierarchical trees State and debugging Understand session state Set a session state value Clear the session state Review the session state Review the messages in debug mode Enabling feedback Managing feedback and team development Themes and templates Switch to a different theme View existing templates Understand and manage templates Create a new template Add references to cascading stylesheet and Javascript files Dynamic actions and plug-in components Identify plug-in components and their types Plug In a component Create dynamic actions Use a plug-in in a dynamic action Building website applications Websheet applications and their components Create a websheet application Enable SQL and PL/SQL in a websheet application Add sections and pages to a websheet application Add links on a websheet page Add a data grid to a websheet application Create SQL reports ion websheet applications Add annotations to a websheet application Implementing security Authentication and authorization Provide an authentication scheme Create an authorization scheme using access control Enable and configure session state protection Deploy an appliction Define supporting objects Package an application Export an application Import an application Install supporting objects Administer Apex workspaces Manage workspaces and users Request a schema or storage Purge session state Monitor developer activity log Monitor workspace activity View activity reports Import a workspace Utility programs Import and export data Generate DDL statements View objects reports

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