6127 Courses

Boost Your Career By Enrolling In This Team Leader Bundle To Overcome Your Challenges! Get a Free 1 QLS Endorsed Certificate Course with 10 Additional CPDQS Accredited Bundle Courses In A Single Payment. If you wish to gain a solid and compact knowledge of Team Leader and boost your career, then take a step in the right direction with this industry-standard, comprehensive Team Leader bundle of courses, which are well organised. This Leader bundle package includes 1 Premium, The Quality Licence Scheme-endorsed course, 10 additional CPDQS Accredited Certificate courses, with expert assistance, and a FREE courses assessment included. Learn a range of in-demand technical skills to help you progress in your career with 12 months of unlimited access to this bundle of courses. If you enrol in this package, you will not be charged any extra fees. This Team Leader Bundle Package includes: Course 01: Diploma in Team Leader Training at QLS Level 5 10 Additional CPD Accredited Premium Courses - Course 01: Leadership Skills Course Course 02: Diploma in Employee Management Course 03: Team Building & Management Diploma Course 04: Workplace Team Networking Diploma Course 05: Diploma in Meeting Management Course 06: Quality Assurance (QA) Manager Course 07: Level 3: Public Speaking Diploma Course Course 08: Maximising Personal Productivity Course Course 09: Self-Esteem & Confidence Building Course 10: Workplace Stress Management Diploma Success becomes a lot simpler with this Team Leader bundle package, which allows you to monetise your skills. This Team Leader bundle is appropriate for both part-time and full-time students, and it can be completed at your own pace. This premium Team Leader bundle of courses helps your professional development by receiving an endorsement from the Quality Licence Scheme and CPDQS Accredited Certificate. You'll be able to practice in your own time and speed. The course materials for Team Leader are designed by experts, and you can access them. easily from any of your smartphones, laptops, PCs, tablets, etc. Master the skills. You need to arm yourself with the necessary qualities and explore your career opportunities in relevant sectors. Why Prefer This Bundle? You will receive a completely free certificate from the Quality Licence Scheme. Option to receive 10 additional certificates accredited by CPDQS Get a free student ID card! (£10 postal charges will be applicable for international delivery) Engaging voiceover and visual elements for your convenience. Complete the bundle at your own pace. Free assessments and immediate results. 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum: *** Course 01: Diploma in Team Leader Training at QLS Level 5 Module 01: Defining Team Module 02: Understanding Management and Leadership Module 03: Building High Performing Teams Module 04: Motivating Team Members Module 05: Talent Management Module 06: Stress Management and Mental Health Module 07: Succession Planning Module 08: Communication Skills Module 09: Negotiation Techniques Module 10: Managing Change Module 11: Managing Time Module 12: Managing Conflict Module 13: Risk Management Process Module 14: Managing Virtual Teams Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the Team Leader course assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the Diploma in Team Leader Training at QLS Level 5 exams. To Additional the Quality Licence Scheme Endorsed Certificate, you have to pay the price based on the level of these courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 Certificate Accredited by CPDQS Upon finishing the bundle, you will need to order to receive a certificate accredited by CPDQS that is recognised all over the UK and also internationally. The pricing schemes are - Printed Hardcopy Certificate £29 inside the UK. £39 outside the UK (International Delivery). CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This bundle is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The bundle aims to help you get the job or even the long-awaited promotion of your dreams. Certificates Diploma in Team Leader Training at QLS Level 5 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the Diploma in Team Leader Training at QLS Level 5, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, completely free of charge in this package. For Additional the Quality Licence Scheme Endorsed Certificate you have to pay the price based on the Level of these Courses: Level 1 - £59 Level 2 - £79 Level 3 - £89 Level 4 - £99 Level 5 - £119 Level 6 - £129 Level 7 - £139 Certificate Accredited by CPD 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery) Certificate Accredited by CPD Digital certificate - £10

Overview Acquire great customer problems solving skills to develop long term relationships with your customers by enrolling in our Customer Service Management course. This course is a step-by-step training process to educate you in all the essential knowledge and skills to deliver contextual-based support to your customers and maintain high ethical business standards. The training has a huge impact on higher customer retention, acquisition of new customers, increased productivity and more. After your successful completion, you will be more than capable of identifying customer service elements and knowing the effects of poor service on a business; you will also be able to come up with some great techniques to deal with difficult customers. Enrol today to handle customer feedback and complaints efficiently. Key Features of the Course: FREE Customer Service CPD-accredited certificate Get a free student ID card with Customer Service training (£10 applicable for international delivery) Lifetime access to the Customer Service course materials The Customer Service program comes with 24/7 tutor support Get instant access to this Customer Service course Learn Customer Service training from anywhere in the world The Customer Service training is affordable and simple to understand The Customer Service training is an entirely online How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Customer Service Management. It is available to all students, of all academic backgrounds. Requirements Our Customer Service Management is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on WIFI, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 9 lectures • 01:51:00 hours total •Module One - Customer Service : Who We Are and What We Do •Module Two - Customer Service : Establishing Your Attitude •Module Three - Customer Service : Identifying and Addressing Customer Needs •Module Four - Customer Service : Generating Return Business •Module Five: In-Person Customer Service •Module Six - Customer Service : Giving Customer Service over the Phone •Module Seven - Customer Service : Providing Electronic Customer Service •Module Eight - Customer Service : Recovering Difficult Customers •Module Nine - Customer Service : Understanding When to Escalate

Do you want to acquire the knowledge that will Help you Understand & Cope with Effective Remote Working Training? Elevate your remote work game with 'Effective Remote Working Training'. Dive into strategies that transform challenges into opportunities. Achieve unparalleled efficiency and harmony in your digital workspace. Embrace a work-from-home revolution like never before! Course Highlights Effective Remote Working Training is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Effective Remote Working Training for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. It is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Effective Remote Working Training Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Effective Remote Working Training is CPD certified and IAO accredited. 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 backgrounds. Requirements Our Effective Remote Working Training 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 You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Effective Remote Working Training Introduction to Remote Working (1) 00:12:00 Setting Up Remote Office 00:13:00 Strategies for Boosting Productivity 00:11:00 Effective Communication Techniques 00:20:00 Etiquette for Video and Audio Calls 00:15:00 Staying Motivated and Competitive 00:18:00 Virtual Collaboration and Working on Teams 00:15:00 Ensuring Growth As a Remote Employee 00:16:00

Is your lifestyle too sedentary? Do you feel sluggish by the end of the day? Wrecked by the end of the week? You need to vary your regime at work. You need to work with, rather than against, your physicality in order to boost your energy levels in a sustainable way - without recourse to coffee, sugar or other stimulants. Take away: Four quick and easy ways to make you feel good and re-energised. You will have the opportunity to: Explore how even just small amounts of physical activity can impact your mental and general health and wellbeing, creativity and productivity. Learn what to do about a sedentary lifestyle Get some tips on what to do about your posture Deskercise - try out some easy stretches and exercises you can do at your desk

Master the AutoCAD to perfection by learning from the best Learning AutoCAD has never been easier Do you want to master AutoCAD to exceed in your profession? Now you can do it by joining an interactive AutoCAD course created by an expert designer. Forget about multi-volume AutoCAD manuals and random tutorials found on the web. Learn how to create projects like a master designer. Learn from the best, receive step-by-step guidance, exercise in practice and design your own project to solidify your new skills. You will learn how to create professional designs according to the latest standards and how to work with AutoCAD quickly and flawlessly. Previous experience with AutoCAD is not obligatory. This AutoCAD course is perfect for people with a little experience as well as for complete newbies. The course consists of interactive modules, tests, and practical exercises to help you gain proficiency faster than ever before. At the end, you’ll receive a certificate of completion that’ll serve as proof of your newly acquired abilities. Are you ready to join the ranks of professional designers? Get the course today and start learning. Join the AutoCAD course today and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Daniel Stern AutoCAD expert Daniel Stern is a designer and trainer with over 15 years of experience. He’s been creating commercial AutoCAD projects since 2002 and you can feel his passion for design from the very start of the course. With over 2800 hours of training experience, he is also a great couch who can explain even the most challenging concepts clearly and easily.  No matter if you are in architecture, installations or mechanics, he will guide you step-by-step through the most important features of AutoCAD. Thanks to his guidance, you will be able to create designs in an efficient and organized manner. Detailed Video Presentations: Knowledge of design and CAD CAD software basics, applications and capabilities AutoCAD versions and modules File and print formats CAD software alternatives AutoCad interface Workspace Controls Menus Toolbars Coordinates Command line Training Videos Foundations of AutoCAD operation Views and layers Drawing shapes and objects Tools and features Editing and manipulating objects Printing and exporting Twelve Practical Exercises in: Navigating interface Using views and coordinates Creating and editing objects Precise drawing Advanced tools Finishing the project Tests and Repetitions: Tests and repetitions of acquired knowledge CAD knowledge test Navigation Drafting and modification of elements, tools and properties of elements in AutoCAD, layers, text, blocks and print Final Examination Comprehensive repetition of the material Final exam Summary of the completed project Bonus Reference Materials: Additional materials for use in daily work Compendium of AutoCAD shortcuts and tools AutoCAD best practices Essential AutoCAD commands AutoCAD productivity boost manual Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor: I’m pleased to invite you to this one-of-a kind course. Step by step you will learn everything about the program. In a few days you will use advanced tools and techniques that even professionals have trouble with. Choosing the right scale, setting units, drawing complex elements and their transformation, hatching, dimensioning, counting areas, working with objects and blocks – these are only a few of the topics that will be discussed during this training.After completing this AutoCAD course, you will be able to work on an equal level with professionals and jump-start your career in design.You will receive an exceptionally comprehensive package of knowledge and skills with access, practical exercises, concrete examples, repetitions, tests, support materials and, on top of everything, a valuable certificate.Believe in yourself and make the most of your opportunities. See you at the course!Daniel Stern,Designer and AutoCAD expert

Absenteeism and tardiness aren’t just minor hiccups—they’re the silent killers of productivity. One late arrival here, one missed day there, and suddenly deadlines are slipping and team morale’s taking a nosedive. This Absenteeism and Tardiness Course is designed to help individuals and organisations understand the real impact of poor attendance and late arrivals, and how to manage them with clarity, fairness, and structure. It’s about addressing patterns before they spiral, and learning how to respond with confidence, not confusion. Whether you're a manager trying to steady the ship or an employee aiming to stay ahead, this course offers straight-talking strategies that actually stick. No fluff, no waffle—just clear, actionable insights on expectations, communication, and accountability. Learn how to create a positive culture where people want to show up (on time), and where small changes lead to big improvements. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Absenteeism and Tardiness Module 02: Causes of Absenteeism and Tardiness Module 03: Effects of Absenteeism and Tardiness on the Workplace Module 04: Strategies for Managing Absenteeism and Tardiness Module 05: Measurement and Evaluation of Absenteeism and Tardiness Module 06: Legal and Ethical Considerations Module 07: Proactive Strategies for Prevention Module 08: Technology and Tools Module 09: Building a Culture of Accountability and Well-being Learning Outcomes: Understand the root causes of attendance issues. Assess the workplace impact of absenteeism and tardiness. Develop effective strategies to manage attendance concerns. Apply measurement and evaluation techniques for progress. Navigate legal and ethical considerations with confidence. Implement proactive prevention measures and utilise relevant technology. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? HR professionals seeking to address absenteeism and tardiness issues. Managers and supervisors looking to create a more productive workplace. Business owners aiming to reduce absenteeism's financial burden. Legal professionals interested in workplace compliance and ethics. Anyone involved in employee well-being initiatives. Individuals aiming to enhance their HR skill set. Career path Human Resources Manager Absence Management Specialist Workplace Well-being Coordinator Employment Law Consultant Employee Relations Advisor HR Technology Solutions Analyst Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

***24 Hour Limited Time Flash Sale*** HR Audit, Crisis, Payroll and People Management Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Did you know 53% of employees feel disengaged at work in the UK, costing businesses billions of pounds annually? Effective HR practices are crucial for employee satisfaction, productivity, and ultimately, your bottom line. But are you equipped to handle the complexities of the modern HR landscape? This HR Audit, Crisis, Payroll and People Management bundle equips you with the knowledge and skills to excel in HR management, crisis communication, and people development. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our HR Audit, Crisis, Payroll and People Management bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in HR Audit, Crisis, Payroll and People Management Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this HR Audit, Crisis, Payroll and People Management Career Bundle: Course 01: Advanced Diploma in HR (Human Resources) at QLS Level 7 Course 02: Employment Law Course 03: Human Resources (HR) Audit Course 04: Payroll Management Course Course 05: Office Administration Course 06: HR - Crisis Communication Course 07: Virtual Interviewing for HR Course 08: Recruitment Officer Diploma Course 09: HR Advisor and Recruitment Training Diploma Course 10: Motivation Skills Course 11: Virtual Training Masterclass Course 12: Dialectical Behaviour Therapy Course 13: HR Practice Essentials Level 4 Course 14: Delegation Skills Course 15: Dealing With Difficult People Training Course Course 16: Performance-Centered Asset Management Course 17: Interpersonal Skills in Management Course 18: Positive Psychology Masterclass Course 19: Personal and Networking Skills Course 20: Motivational Interviewing Course 21: People Management Skills Level 3 Course 22: HR and Recruitment Consultant Training Course 23: Contract Management Course Course 24: Office Skills and Administration Management Diploma Course 25: Workplace Stress Management Course 26: Effective Listening Skills for Leaders Course 27: HR Assistant Skills Certification Course 28: Team Management Course 29: HR and Marketing Level 4 Course 30: Payroll Management and Systems Diploma With HR Audit, Crisis, Payroll and People Management, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. Learning Outcomes of HR Audit, Crisis, Payroll and People Management Comprehend UK employment law and its implications for HR practices. Conduct comprehensive HR audits to identify and address weaknesses. Master payroll management, ensuring accuracy and compliance. Develop effective virtual interviewing skills to attract top talent. Become an expert in crisis communication, mitigating risks and building trust. Sharpen your motivational skills to inspire and engage employees. Enrol in HR Audit, Crisis, Payroll and People Management today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of HR Audit, Crisis, Payroll and People Management Get a free student ID card with HR Audit, Crisis, Payroll and People Management Lifetime access to the HR Audit, Crisis, Payroll and People Management course materials Get instant access to this HR Audit, Crisis, Payroll and People Management course Learn HR Audit, Crisis, Payroll and People Management from anywhere in the world 24/7 tutor support with the HR Audit, Crisis, Payroll and People Management course. Start your learning journey straightaway with our HR Audit, Crisis, Payroll and People Management Training! HR Audit, Crisis, Payroll and People Management premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of HR Audit, Crisis, Payroll and People Management is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the HR Audit, Crisis, Payroll and People Management course. After passing the HR Audit, Crisis, Payroll and People Management exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This HR Audit, Crisis, Payroll and People Management course is ideal for: Students seeking mastery in HR Audit, Crisis, Payroll and People Management Professionals seeking to enhance HR Audit, Crisis, Payroll and People Management skills Individuals looking for a HR Audit, Crisis, Payroll and People Management-related career. Anyone passionate about HR Audit, Crisis, Payroll and People Management Requirements This HR Audit, Crisis, Payroll and People Management doesn't require prior experience and is suitable for diverse learners. Career path This HR Audit, Crisis, Payroll and People Management bundle will allow you to kickstart or take your career in the related sector to the next stage. HR Specialist HR Manager Recruitment Consultant People Development Manager HR Business Partner HR Director Certificates Advanced Diploma in HR (Human Resources) at QLS Level 7 Hard copy certificate - Included CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

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

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 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