51156 Courses

This mega life skills training course will equip you with all the essential skills you need to successfully navigate everyday life. Through life skills training, you'll learn everything from problem-solving techniques and communication techniques to time management tips and financial literacy skills. Drawing on the personal experiences of successful people, this course will teach you how to communicate effectively and meaningfully with others, so you can be confident when faced with difficult conversations or challenging situations. You'll discover easy-to-follow strategies for overcoming mental obstacles and conquering procrastination, and develop the resilience you need to weather any storm life throws your way. Life skills course is designed to give you knowledge that you can apply immediately to enrich your life, reduce stress levels, and whatever comes your way! Course includes: Course 01: Life Coaching and Career Counselling Course 02: Spiritual Life Coaching Course Course 03: Behaviour Management & Emotional Intelligence Course 04: Anger Management & Conflict Resolution Course 05: Dealing With Difficult People In Life & Work Course 06: Psychology, Meditation & Parapsychology Course 07: Motivation Skills Course 08: Personal Development Skills Course 09: Team Management Course 10: Setting & Achieving Goals Course 11: Time Management Skills Course 12: Office Skills The comprehensive learning resources for Life skills course are available anytime, anywhere, so you can study at your own pace in the convenience of your own home. Industry experts break down the curriculum into tiny, manageable units. And our professionals will respond to any of your questions. Reality Check: Many students claim that even though it is shorter than other courses they have taken, it has taught them considerably more. This course is just as good as many other offline courses that were 5 to 10 times more expensive. As a result, taking this outstanding course is highly recommended by everyone. Course Significant Points: 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 online course Modules Covers to Explore Multiple Job Positions Method of Assessment MCQ Based Passing Marks 60% Unlimited Retake Exam Instant Assessment and Feedback CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in Life skills course. However, This course particularly effective for- Students Recent graduates Job Seekers in related field Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill We take pleasure in offering the most adaptable, relatively inexpensive, and enjoyable online courses possible to eager aspirants all around the world. Requirements Learners seeking to enrol for Life skills course should meet the following requirements; Basic knowledge of the English language, which you have already Basic Knowledge of Information & Communication Technologies for studying online or digital platform Stable Internet or Data connection in your learning devices Career path This is a whole course package. You'll be capable of covering every job/employment sector after finishing this Life skills bundle. The major goal of this package is to make you intelligent and proficient in all areas, so you can communicate and perform effectively at work. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - £9.99

Clinical skills, HCAs, Nurses, Chronic disease

Improved Sales means better profit, so learn the necessary Skills What are buyers looking for in a seller? How do you place yourself ahead of the competition? If you have ever wondered these questions, then take this course to learn whole new way to improve your sales skills and get better result instantly. There are many skills and tricks that can be used to improve your selling skills, such as your communication skills. If you're a salesperson, this skill might seem self-evident, but too many sales reps don't take the time to develop their communication skills, choosing instead to rely on a script to get them through conversation. A professional seller must have good persuasive skills. Customers are bombarded with advertisements and pitches on a regular basis; you need to know how to convince them that your product or service is worthy of investment. With everything said and done, Sales Skills Professional Course will make you competent to be a professional salesperson. It will vastly improve your skills and you will be able to sell more products easily. Course Highlights Sales Skills Professional Course 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 Sales Skills Professional Course into 19 modules 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. You can become accredited in just 16 hours, 30 minutes hours and 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 Sales Skills Professional Course 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? Sales Skills Professional Course 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 Sales Skills Professional Course 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. Salesmanship Introduction To Salesmanship FREE 01:00:00 How the Low Pressure Salesman Uses His Product Knowledge to Build Dynamic Demonstrations FREE 00:30:00 How to Use Enthusiasm in Low Pressure Selling 02:00:00 Building Customer Confidence Through Low Pressure 00:30:00 Timing the Low Pressure Sale 02:00:00 Developing the Low Pressure Sales Personality 00:30:00 How to Organize Yourself for Low Pressure Selling 02:00:00 Objection Handling Techniques 01:00:00 Highlight Closers in Low Pressure Selling 00:30:00 How You Can 'Tell It Faster-Sell It Faster' Through Low Pressure 00:30:00 Sales Communication Communication Basics FREE 00:30:00 The Importance Of Self Esteem FREE 00:30:00 Oral Communication Skills Certificate 00:30:00 Written Communication Techniques 00:30:00 The Importance Of Body Language 00:30:00 Public Speaking Tips 00:30:00 How Bad Communication Damages Your Business 00:30:00 Sales Technique Fundamental Sales Techniques 01:00:00 Extensive Sales Techniques 01:30:00 Mock Exam Final Exam

Communication Skills Bundle Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Communication Skills Bundle Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 6 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: It is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Have a passion for learning A good understanding of the English language Be motivated and hard-working over the age of 16. Assessment The assessment is straightforward, you need to complete the assignment questions that will be provided to you at the end of the course, you can complete the assignment anytime you want. After you complete and submit your assignment, our tutors will assess your assignment and give you feedback if needed.  After your assignment has been assessed and you have passed, you will be qualified and will be able to apply for a course completion certificate. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. **Professional Workplace Communication Skills Diploma** Business Communication Identifying Basic Communication Techniques 00:09:00 Formal and Informal Communication 00:02:00 Verbal and Non-verbal Communication Describing Verbal and Non-verbal Communication 00:04:00 Understanding Body Language 00:05:00 Making Effective Presentations 00:10:00 Fundamentals of Productive Meetings 00:08:00 Written Communication Written Communication 00:13:00 Electronic Communication Electronic Communication 00:19:00 Communicating with Graphics Creating Graphics for Business Communication 00:04:00 Communicating Static Information 00:03:00 Communicating Dynamic Information 00:03:00 Effectively Working for Your Boss Representing Your Boss 00:06:00 Communicating Your Boss's Decisions 00:03:00 Supporting Your Boss and Colleagues 00:04:00 Building a Partnership with Your Boss 00:13:00 **Negotiation Skills Training** Prepare The Train Driver - Self Development For The Sales Consultant The Mind Of A Consultant 00:03:00 Mastering Sales Is Mastering Life Skills 00:03:00 The Continuous Journey 00:02:00 Universal Laws Of Success 00:01:00 The Three Pillars Of Success 00:03:00 Personal Honesty 00:01:00 Diligence 00:02:00 Deferred Gratification 00:04:00 Suppression Of Principle 00:03:00 Emotional Intelligence 00:02:00 Core Principles Of Emotional Intelligence 00:04:00 The Problem Is Internal 00:02:00 The Two Motivational Forces 00:05:00 Product Confidence 00:03:00 Sales Consultant Activities To Complete 00:01:00 Negotiation Station - How To Negotiate Successfully The Negotiation Station 00:02:00 Core Principles Of Negotiation 00:01:00 Focusing On Them 00:02:00 Everyone Has To Win 00:04:00 Matching Values 00:03:00 The Path Of Least Resistance 00:02:00 Shifting The Weight 00:06:00 The Persuasion Secret 00:01:00 How To Persuade Someone 00:01:00 The Electric Car 00:02:00 The Fashionable Trainers 00:02:00 Competency Levels 00:03:00 Assessing Competency Levels 00:04:00 Features Benefits And Values 00:02:00 The Christmas Tree Negotiation 00:04:00 B2B Value Propositions 00:03:00 Deepening The Value 00:02:00 Over Decorating The Tree 00:03:00 The Big 12 00:01:00 Authority 00:04:00 Social Proof 00:03:00 Group Identity 00:02:00 Deflecting Fault 00:02:00 Ask For Advice 00:02:00 Compliment Their Negotiations 00:02:00 Reciprocity 00:02:00 Scarcity 00:02:00 Off Set Values 00:02:00 Stepped Commitments 00:02:00 Fear And Hope 00:02:00 Ranked Priorities 00:07:00 Negotiating A Price 00:01:00 The Market Price 00:02:00 The Anchor Price 00:02:00 The Walk Away Price 00:02:00 The First Offer 00:03:00 The Counter Offer 00:04:00 Activities To Complete Negotiation Skills 00:01:00 **Conflict Management Techniques Diploma** Module One: Getting Started Conflict Resolution 00:01:00 Getting Started 00:01:00 Module Two: An Introduction to Conflict Resolution An Introduction 00:04:00 Introduction Case Study 00:01:00 Module Three: The Thomas-Kilmann Instrument C R Styles with TKI 00:04:00 C R Styles with TKI Case Study 00:01:00 Module Four: Creating an Effective Atmosphere Creating an Effective Atmosphere 00:04:00 Creating an Effective Atmosphere Case Study 00:01:00 Module Five: Creating Mutual Understanding Creating a Mutual Understanding 00:03:00 Creating a Mutual Understanding Case Study 00:01:00 Module Six: Focusing on Individual Needs Focusing on Individual & Shared Needs Case Study 00:01:00 Focusing on Individual & Shared Needs Case Study 00:01:00 Module Seven: Getting to the Root Cause Getting to the Root Cause 00:05:00 Getting to the Root Cause Case Study 00:01:00 Module Eight: Generating Options Generating Options 00:03:00 Generating Options Case Study 00:01:00 Module Nine: Building a Solution Building a Solution 00:04:00 Building a Solution Case Study 00:01:00 Module Ten: the Short Version of the Process The Short Version of the Process 00:04:00 The Short Version of the Process Case Study 00:01:00 Module Eleven: Additional Tools Additional Tools 00:03:00 Additional Tools Case Study 00:01:00 Closing 00:01:00 **Managing Difficult Conversation Diploma** Introduction Introduction - Welcome from Alan Stevens 00:02:00 Difficult Conversations Why Are Some Conversations Difficult? 00:02:00 Preparation 00:02:00 Set-Up and Room Layout 00:03:00 How to Start the Conversation 00:02:00 Active Listening and Responding 00:02:00 Ask Open and Supportive Questions 00:02:00 Focus on Facts, Not Personalities 00:01:00 Use of Tone and Body Language 00:02:00 Exploring Alternative Solutions 00:01:00 Handling Challenge 00:03:00 Conclusions Summary - What We've Covered 00:01:00 Thank You and Next Steps 00:01:00

🎤 Presentation Skills Training Course Overview: Master the Art of Impactful Communication Are you ready to captivate your audience, leave a lasting impression, and confidently deliver powerful presentations? Welcome to our 'Presentation Skills Training' course, a transformative journey designed to enhance your communication prowess and elevate your public speaking abilities. Unleash your potential and become a dynamic presenter with our comprehensive training. 📊 Module 1: Fundamentals of Effective Presentation Skills Build a strong foundation in presentation skills with an exploration of key principles. Understand the psychology of effective communication, non-verbal cues, and the importance of connecting with your audience to create a memorable and impactful presentation. 📝 Module 2: Planning and Preparing Your Presentation Unlock the secrets to crafting compelling presentations. Learn effective strategies for structuring your content, creating engaging narratives, and tailoring your message to resonate with your audience. Master the art of planning and preparation to ensure a seamless and well-organized presentation. 🖼️ Module 3: Using Visual Aids to Enhance Your Presentation Enhance your presentations with visually engaging elements. Explore the effective use of slides, graphics, and multimedia to reinforce your message. Learn to strike the right balance between visual aids and verbal delivery for an impactful and memorable presentation. 🗣️ Module 4: Delivering Your Presentation with Confidence and Clarity Boost your confidence and develop a commanding presence as a speaker. Explore techniques for managing nervousness, perfecting your vocal delivery, and utilizing body language to convey confidence and clarity. Master the art of engaging your audience and maintaining their attention throughout your presentation. ❓ Module 5: Handling Questions and Feedback Effectively Navigate the Q&A session with finesse. Learn strategies for handling questions confidently and providing thoughtful responses. Discover techniques for incorporating feedback into your presentations, fostering continuous improvement and refinement of your communication skills. 🌟 Why Choose Our Presentation Skills Training Course? Practical Application: Hands-on exercises and simulated presentations for real-world experience. Expert Coaching: Learn from seasoned communication professionals with a wealth of experience. Interactive Learning: Engage in activities designed to enhance your presentation skills dynamically. Career Advancement: Open doors to diverse opportunities where effective communication is paramount. 🎓 Enroll Now and Transform Your Presentation Skills! Don't miss the opportunity to become a charismatic and impactful presenter. Our Presentation Skills Training course is your gateway to mastering the art of effective communication. Enroll now and unlock the keys to confidently delivering presentations that leave a lasting mark! Course Curriculum Module 1_ Fundamentals of Effective Presentation Skills. Fundamentals of Effective Presentation Skills. 00:00 Module 2_ Planning and Preparing Your Presentation. Planning and Preparing Your Presentation. 00:00 Module 3_ Using Visual Aids to Enhance Your Presentation. Using Visual Aids to Enhance Your Presentation. 00:00 Module 4_ Delivering Your Presentation with Confidence and Clarity. Delivering Your Presentation with Confidence and Clarity. 00:00 Module 5_ Handling Questions and Feedback Effectively. Handling Questions and Feedback Effectively. 00:00

Do you wish you could know what someone is thinking about? Or may be you want to improve your non-verbal communication? Body language is a good way to know how others think and feels, as well increase your everyday communication with others. Our body language course is based on scientifically-backed research and is intended to guide you on how to read people's nonverbal behaviour and improve your own. Regardless of Whether you are a business owner, parent, spouse, employee, teacher or student, this course will change the way you communicate with those around you. If you have ever associated with another person, this course will be beneficial to you because our everyday communications are filled with secret nonverbal signs just waiting to be uncovered. By the end of this course, you will know all about the power of body language, and how to get what you've always wanted, without even saying a single word! Course Highlights Communication Skills Course: Body Language 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 Communication Skills Course: Body Language into 17 modules 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. You can become accredited in just 5 hours, 15 minutes and 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 Communication Skills Course: Body Language 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? Communication Skills Course: Body Language 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 Communication Skills Course: Body Language 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. Introduction 00:15:00 Aggressive Body Language 00:15:00 Attentive Body Language 00:15:00 Closed Body Language 00:30:00 Deceptive Body Language 00:30:00 Defensive Body Language 00:15:00 Dominant Body Language 00:15:00 Emotional Body Language 00:30:00 Evaluating Body Language 00:15:00 Greeting Body Language 00:30:00 Open Body Language 00:15:00 Relaxed Body Language 00:15:00 Power Body Language 00:15:00 Ready Body Language 00:15:00 Romantic Body Language 00:15:00 Submissive Body Language 00:15:00 Conclusion 00:15:00 Mock Exam Final Exam

The S.C.I.E.N.C.E.S VIP Program is a 3-month powerful personal development training tool, based around Neuroplastic Mental Acceleration (NMA): encompassing the eight steps to ascension, spread over 60 x 30 minute training sessions: Accept, Aware, Assess, Adapt, Aspire, Accelerate, Actualise, Ascend. The program is designed to provide mental well-being & acceleration by promoting fluid intelligence (the brain’s ability to learn new skills) though activating neuroplasticity - synaptogenisis & neurogenisis.

Follow your dreams by enrolling on the Accounting Skills and Cycles course today and develop the experience, skills and knowledge you need to enhance your professional development. Accounting Skills and Cycles will help you arm yourself with the qualities you need to work towards your dream job. Study the Accounting Skills and Cycles training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Accounting Skills and Cycles course will allow you to enhance your CV, impress potential employers, and stand out from the crowd. This Accounting Skills and Cycles course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the Accounting Skills and Cycles course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Accounting Skills and Cycles course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Accounting Skills and Cycles course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the Accounting Skills and Cycles course. The Accounting Skills and Cycles course is designed by industry experts and is tailored to help you learn new skills with ease.  The Accounting Skills and Cycles is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Accounting Skills and Cycles when it suits you. Access the Accounting Skills and Cycles course modules from any internet-enabled device, including computers, tablets, and smartphones. The Accounting Skills and Cycles course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Accounting Skills and Cycles now and start learning instantly! What You Get Out Of Studying Accounting Skills and Cycles With Janets: Receive a digital Certificate upon successful completion of the Accounting Skills and Cycles course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The Accounting Skills and Cycles training course is delivered through Janets' online learning platform. Access the Accounting Skills and Cycles content from any internet-enabled device whenever or wherever you want to. The Accounting Skills and Cycles course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the Accounting Skills and Cycles course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the Accounting Skills and Cycles course. After successfully passing the Accounting Skills and Cycles course exam, you will be able to apply for a CPD-accredited certificate as proof of your Accounting Skills and Cycles qualification. Certification All students who successfully complete the Accounting Skills and Cycles course can instantly download their digital certificate. You can also purchase a hard copy of the Accounting Skills and Cycles course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Accounting Skills and Cycles is ideal for those who already work in this sector or are an aspiring professional. This Accounting Skills and Cycles course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The Accounting Skills and Cycles is open to all students and has no formal entry requirements. To study the Accounting Skills and Cycles course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The Accounting Skills and Cycles is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the Accounting Skills and Cycles and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Accounting Skills and Cycles Accounting Skills - Financial Reports Course Overview 00:05:00 Getting the Facts Straight 00:30:00 The Accounting Cycle 00:30:00 The Key Reports 00:30:00 A Review of Financial Terms 00:30:00 Understanding Debits and Credits 00:15:00 Your Financial Analysis Toolbox 00:30:00 Identifying High and Low Risk Companies 00:30:00 The Basics of Budgeting 00:15:00 Working Smarter 00:10:00 Mock Exam Mock Exam - Accounting Skills and Cycles 00:20:00 Final Exam Final Exam - Accounting Skills and Cycles 00:20:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

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