1983 Advisor courses

The HR Administrator Course is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with an acknowledged certificate. This HR Administrator Course consists of several modules that take around 5 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Why Choose this Course? Earn a digital Certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full tutor support on weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the 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 course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Course Content Module 01: Introduction to Human Resource Introduction to Human Resources 00:20:00 Module 02:Employee Recruitment and Selection Procedure Employee Recruitment and Selection Procedure 00:35:00 Module 03: Employee Training and Development Process Employee Training and Development Process 00:24:00 Module 04: Performance Appraisal Management Performance Appraisal Management 00:22:00 Module 05: Skills of an Effective Administrator Skills of an Effective Administrator 00:16:00 Module 06: Business Etiquette Business Etiquette 00:20:00 Module 07: Business Telephone Skills Business Telephone Skills 00:20:00 Module 08: Organising Meeting and Conferences Organising Meeting and Conferences 00:26:00 Module 09: Time Management Time Management 00:36:00 Module 10: Business Writing Skills Business Writing Skills 00:12:00 Module 11:Organisational Skills Organisational Skills 00:26:00 Module 12: Communication Skills Communication Skills 00:26:00 Mock Exam Mock Exam - HR Administrator 00:20:00 Final Exam Final Exam - HR Administrator 00:20:00 Assignment Assignment - HR Administrator 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00: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.

HR & Recruitment Consultant Diploma Course Description: Are you interested in a career in human resources? The job market can be tough for both recruiters and job seekers. On the one hand, recruiters often have to go through hundreds of applications in order to find the perfect match for their open position, while job seekers need to stand out from the many other applicants. If you're thinking of becoming a recruitment consultant, this HR & Recruitment Consultant Diploma will help you step into the shoes of an expert HR manager. This HR and recruitment course is divided into three sections, starting with HR management today, recruiting, interviews, retention and health & safety. You will familiarise with the selection, hiring and recruitment processes, goal setting, interview questions, background checks and more. In the final section of the course, you will gain the practical communication skills you need to lure in great candidates, and will learn how to shortlist applications, select the best candidates and onboard new recruits. So, if you want to land that recruitment consultant job, further your professional development and kickstart your career in the recruitment industry, enrol in this recruitment training course today and start your new career path with brand new skills. Who is the course for? Businesses who want to learn how to hire the right kind of people for their jobs Job seekers wanting to understand the recruitment process in order to stand out Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: HR & Recruitment Consultant Diploma is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: HR Managers Recruitment specialists Career counsellor Job agents Managers Human Resource Management Module One - Getting Started 00:30:00 Module Two - Human Resources Today 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 Recruitment Basics Introduction to Recruitment 00:15:00 Recruitment 01:00:00 Shortlisting 00:15:00 Selection 01:00:00 Definitions of Training and Development 00:15:00 Considerations in the Design of Training Programmes 00:15:00 Implementing Training 00:15:00 Learning Methods 00:30:00 Recruitment Module One - Getting Started 00:15:00 Module Two - Introduction to Recruitment 00:30:00 Module Three - The Selection Process 00:30:00 Module Four - Goal Setting 00:30:00 Module Five - The Interview 00:30:00 Module Six - Types of Interview Questions 00:30:00 Module Seven - Avoiding Bias in Your Selection 00:30:00 Module Eight - The Background Check 00:30:00 Module Nine - Making Your Offer 00:30:00 Module Ten - Orientation and Retention 00:30:00 Module Eleven - Measuring the Results 00:30:00 Module Twelve - Wrapping Up 00:15:00 Managing Recruitment Module One - Getting Started 00:30:00 Module Two - Defining and Knowing the Position 01:00:00 Module Three - Hiring Strategy 01:00:00 Module Four - Lure in Great Candidates 01:30:00 Module Five - Filtering Applicants to Interview 01:00:00 Module Six - The Interview (I) 01:00:00 Module Seven - The Interview (II) 01:00:00 Module Eight - Selection Process (I) 01:00:00 Module Nine - Selection Process (II) 01:00:00 Module Ten - Making an Offer 01:00:00 Module Eleven - Onboarding 01:00:00 Module Twelve - Wrapping Up 00:30:00 Recruitment - Interview Process History of the Interviewing Process 00:30:00 The Recruitment and Selection Process 00:15:00 Factors in the Hiring Process 00:15:00 Cost Analysis 00:15:00 Job Analysis and Position Profiles 00:30:00 Determining the Skills You Need 00:15:00 Finding Candidates 00:30:00 Advertising Guidelines 00:00:00 Screening Resumes 00:30:00 Performance Assessments 00:30:00 Problems Recruiters Face 00:15:00 Interviewing Barriers 00:15:00 Non-Verbal Communication 00:15:00 Types of Questions 00:30:00 Case Study 00:15:00 Traditional vs. Behavioral Interviews 00:30:00 Other Types of Questions 00:15:00 The Critical Incident Technique 00:15:00 Listening for Answers 00:30:00 Difficult Applicants 01:00:00 Interview Preparation and Format 00:00:00 Other Interview Techniques 00:30:00 Scoring Responses 00:15:00 Checking References 00:30:00 Human Rights 00:15:00 Recommended Reading Recommended Reading: HR & Recruitment Consultant Diploma 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- HR & Recruitment Consultant Diploma 00:30:00 Final Exam Final Exam- HR & Recruitment Consultant Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Description: If you are part or will be part of Human Resource Management you just don't need to know the functions of your department. You need to learn also about the functions of other departments since you'll be the one who will help in finding people perfect for it. In this course, you will learn the necessary skills, knowledge, and information about Human Resource Management and the implications of a different aspect of Human Resources with the daily responsibilities of people in this department. Who is the course for? Human Resources Management officers who want to learn more about their department People who have an interest in knowing about human resources management. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Human Resource Management course is a useful qualification to possess, and would be beneficial for the following careers: Businessmen Consultant Human Resource Officer Labour Relations Officer Recruitment and Hiring Manager Relations Manager. Human Resource Management Module One - Getting Started 00:30:00 Module Two - Human Resources Today 01:00:00 Module Three - Recruiting and Interviewing 01:00:00 Module Four - Retention and Orientation 01:00:00 Module Five - Following Up With New Employees 01:00:00 Module Six - Workplace Health & Safety 01:00:00 Module Seven - Workplace Bullying, Harassment, and Violence 01:00:00 Module Eight - Workplace Wellness 01:00:00 Module Nine - Providing Feedback to Employees 01:00:00 Module Ten - Disciplining Employees 01:00:00 Module Eleven - Terminating Employees 01:00:00 Module Twelve - Wrapping Up 00:30:00 HR Training Defining Human Resources 00:15:00 Performing a Skills Inventory 00:15:00 Forecasting Techniques 00:15:00 Job Analysis 00:00:00 Identifying Job Competencies 00:30:00 Position Profiles and Job Descriptions 00:30:00 Do You Really Need to Hire? 00:30:00 Finding Candidates HR 00:00:00 Advertising Guidelines HR 00:30:00 Screening Resumes HR 00:30:00 Preparing for the Interview 00:15:00 Conducting the Interview 01:00:00 After the Interview 00:15:00 Employee Orientation and Onboarding 00:30:00 Follow the Leader 00:15:00 Planning Training 00:15:00 Working With External Providers 00:15:00 Performance Reviews 01:00:00 Attendance Management 00:30:00 Managing a Diverse Workforce 00:30:00 Privacy Issues 00:15:00 Compensation and Benefits 01:00:00 Managing Disciplinary Issues 00:30:00 Terminating Employees 00:15:00 Exit Interviews 00:15:00 Activities Activities - Advanced Diploma in Human Resource Management 00:00:00 Mock Exam Mock Exam - Diploma in Human Resource Management 00:20:00 Final Exam Final Exam - Diploma in Human Resource Management 00:20:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00

Safer Recruitment: Safer Recruitment Training Course Online Unlock the Power of Safer Recruitment: Safer Recruitment Training Course: Enrol Now! All settings where children and young adults are present require Safer Recruitment: Safer Recruitment Training Course practices. For example, when hiring and supervising new employees, it is important to understand how to make sure they are safe to work with children. This begins with a thorough Safer Recruitment: Safer Recruitment process that ensures that the people you hire have the same child protection attitudes and values as you do. Throughout this Safer Recruitment: Safer Recruitment Training Course, you will learn about best practices in the recruitment process. You will learn how to check suitability throughout the hiring process, from selection to a recruit starting in a role. The Safer Recruitment: Safer Recruitment Training Course covers the various checks that must be performed when hiring someone new to work with children, such as DBS checks, overseas checks, and eligibility to work in the UK. Main Course: Safer Recruitment Training Course Free Courses included with Safer Recruitment: Safer Recruitment Training Course Course 01: Level 2 Safeguarding Children Training Course 02: Level 4 Logistics Management Course 03: Level 3 Dyslexia Awareness Course 04: HR and Payroll Management [Note: Free PDF certificate as soon as completing the Safer Recruitment: Safer Recruitment Training Course] Safer Recruitment: Safer Recruitment Training - Course Online This Safer Recruitment: Safer Recruitment Training - Course consists of 12 modules. Course Curriculum of the Safer Recruitment: Safer Recruitment Training - Course Module 01: Introduction to Safer Recruitment Module 02: Step 1: Create the Job Description and Application Pack Module 03: Step 2: Shortlist Candidates, Contact Referees and Review Disclosures Module 04: Step 3: Interview Shortlisted Candidates Module 05: Step 4: Pre-Appointment and DBS Checks Module 06: Step 5: The Induction Process and Maintaining a Safe Workplace Assessment Method of Safer Recruitment: Safer Recruitment Training - Course After completing Safer Recruitment: Safer Recruitment Training - Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Certification of Safer Recruitment: Safer Recruitment Training - Course After completing the Safer Recruitment: Safer Recruitment Training - Course, you can instantly download your certificate for FREE. Who is this course for? Safer Recruitment: Safer Recruitment Training - Course Online This Safer Recruitment: Safer Recruitment Training - Course is ideal for anyone in charge of hiring and/or supervising new staff members who work with children and young people. This applies whether you are hiring full-time, part-time, or volunteer employees. Requirements Safer Recruitment: Safer Recruitment Training - Course Online To enrol in this Safer Recruitment: Safer Recruitment Training - Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Safer Recruitment: Safer Recruitment Training - Course. Be energetic and self-motivated to complete our Safer Recruitment: Safer Recruitment Training - Course. Basic computer Skill is required to complete our Safer Recruitment: Safer Recruitment Training - Course. If you want to enrol in our Safer Recruitment: Safer Recruitment Training - Course, you must be at least 15 years old.

Description: Human Resource refers to describe both the people who work for a company or organisation and the department responsible for managing resources related to employees. The proper HR knowledge will help the company to solve any problems associated with employees and foster the growth of the business. The Human Resource Administration - Complete Video Training course will help you to know the HR concepts and techniques and support you to be a good HR manager. The job of HR is to recruit mange and provide guidelines or direction to the fellow employees so that they can do their work correctly. The course is divided into two sections - one part deals with the HR concept focusing the procedures of retaining employees, the system of training and development, contemporary motivation theory, and the legal environment of HRM. The second section of the video bundled course deals with the administrative role of an HR manager. The course explains the procedures of job redesign, job enrichment, handling conflict, and the proper ways of appraising, communicating and rewarding. Here, you will also know about the proper methods of leadership. The Human Resource Administration - Complete Video Training course explains the key HR concepts and administration procedures so that you can manage the HR department of your company smoothly and efficiently. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Human Resource Administration - Complete Video Training is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Human Resource Administration - Complete Video 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 After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Human Resources Assistant Introduction Human Resources Assistant FREE 00:10:00 Potential Careers 00:05:00 Attracting and Retaining Employees HRM Overview 00:13:00 Forecasting Demand 00:10:00 Cultural Diversity 00:11:00 Diversity Survey 00:09:00 Recruiting, Selection, and Orientation Job Analysis 00:10:00 Application 00:20:00 Bad Resume 00:05:00 Good Resume 00:12:00 Cover Letter 00:10:00 Selection 00:11:00 Form I-9 00:17:00 Form W-9 00:07:00 Form W-4 00:10:00 Form 1095-B 00:07:00 Compensation and Benefits 00:17:00 Training and Development Personal and Professional Development 00:14:00 Training Evaluation Form 00:12:00 Performance Appraisal Performance Appraisal 00:19:00 Appraisal 00:14:00 Legal Environment of HRM National Labor Relations Act 00:12:00 Labor-Management Relations Act 00:14:00 Occupational Safety and Health Act 00:13:00 Motivating Employees Motivation 00:17:00 Physiological Needs 00:16:00 Motivation-Hygiene Theory 00:12:00 Firm Characteristics 00:22:00 Contemporary Motivation Theory Weakness of Maslow and Herzberg's Theories 00:18:00 Expectancy Theory 00:13:00 Motivation Techniques Management by Objectives 00:17:00 Behavior Modification 00:19:00 Telecommuting 00:20:00 Teams and Teamwork What is a Team? 00:09:00 Stages of Development 00:06:00 Team Cohesiveness 00:09:00 Effective Human Resource Administration Effective HR Administration FREE 00:28:00 Fundamentals of Motivation Motivation - What is it 00:20:00 The Need Hierarchy 00:27:00 The Two-Factor Theory 00:29:00 The Practical Side of Rewards 00:34:00 Individual Behavior Opinions Really Count 00:08:00 The Individual 00:36:00 Interpersonal Behavior 00:24:00 Group Behavior Definition of a Group 00:13:00 Stages of Group Development 00:11:00 Intragroup Behavior 00:19:00 Intergroup Behavior 00:09:00 Team Building 00:42:00 The Informal Organization Nature of Informal Organization 00:34:00 Benefits of Informal Organization 00:09:00 Technology and People at Work The Evolution 00:21:00 Workplace Violence 00:26:00 Stressed Employees 00:14:00 Productivity and Quality Improvement Quality Challenges 00:13:00 Management 00:30:00 Participative Approaches 00:17:00 Job Redesign and Job Enrichment Work in America 00:09:00 Challenges in Job Design 00:09:00 Fundamentals of Leadership Nature of Leadership 00:21:00 Common Behaviors 00:16:00 Contingency Leadership 00:22:00 The Next Decade 00:35:00 Internal Leaders 00:25:00 Developing, Appraising, and Rewarding Employees Integrating the Dimensions 00:20:00 Employee Development 00:27:00 Performance Appraisal 00:53:00 Communicating for Effectiveness Appraisal Problems 00:29:00 Technology's Impact 00:35:00 The Process 00:16:00 Managing Conflict and Change Effective Communications 00:33:00 Nature of Conflict 00:20:00 Nature of Change 00:25:00 Human Relations in Global Business Participation and Communication 00:13:00 Multinational Enterprise 00:22:00 Positioning Yourself as a Professional Attitude in the Workplace FREE 00:10:00 Professionalism 00:03:00 Making Changes through Personal Accountability 00:07:00 Enhancing Your Professional Image Your Image as a Whole 00:05:00 Becoming More Marketable 00:03:00 Communicating and Image 00:08:00 Expanding Your Skills Time Management 00:14:00 Project Management Techniques 00:03:00 Making Decisions 00:06:00 Communicating for Results Keys to Effective Communication 00:26:00 Presentations 00:09:00 Meetings 00:07:00 Building Relationships and Networks Work and Your Personality 00:05:00 Networking 00:07:00 Roles in the Office MRP 00:18:00 Mock Exam Mock Exam- Human Resource Administration - Complete Video Training 00:20:00 Final Exam Final Exam- Human Resource Administration - Complete Video Training 00:20:00

The City & Guilds 2365 Level 3 Course is the natural progression for anyone who has completed the Level 2 Diploma 2365 course or related level 2 courses. On completion of this course you will then be able to undertake the Level 3 NVQ thus becoming recognised as a fully qualified electrical engineer within the industry with the ability to apply for JIB (Gold Card) membership upon successful completion of the AM2 Assessment. Further information on the Level 3 can be found here: C&G 2365 Level 3 Diploma in Electrical Installations — Optima Electrical Training (optima-ect.com)

If you want to start installing independently or with an electrical contractor look no further as this course will give you the skills and knowledge required. This package which will allow you to become a fully qualified domestic installer and enable you to join a Competent Person Self-Certification Scheme and certify your own domestic work.

Level 7 QLS Endorsed Diploma | 180 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

If you have at least 5 years working experience and you would like to attain Gold Card status via the Experienced Worker route by joining the City & Guilds 2346 NVQ Level 3, you will also need to hold the below two pre-requisite qualifications: City & Guilds 2391-52 Inspection and Testing Course C&G 2382-22 BS7671 18th Edition

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse AdministratorDatabase Administrators Overview Use the Oracle Database tuning methodology appropriate to the available toolsUtilize database advisors to proactively tune an Oracle Database InstanceUse the tools based on the Automatic Workload Repository to tune the databaseDiagnose and tune common SQL related performance problemsDiagnose and tune common Instance related performance problemsUse Enterprise Manager performance-related pages to monitor an Oracle DatabaseGain an understanding of the Oracle Database Cloud Service In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service. Introduction Course Objectives Course Organization Course Agenda Topics Not Included in the Course Who Tunes? What Does the DBA Tune? How to Tune Tuning Methodology Basic Tuning Diagnostics Performance Tuning Diagnostics Performance Tuning Tools Tuning Objectives Top Timed Events DB Time CPU and Wait Time Tuning Dimensions Time Model Dynamic Performance Views Using Automatic Workload Repository Automatic Workload Repository Overview Automatic Workload Repository Data Enterprise Manager Cloud Control and AWR Snapshots Reports Compare Periods Defining the Scope of Performance Issues Defining the Problem Limiting the Scope Setting the Priority Top SQL Reports Common Tuning Problems Tuning During the Life Cycle ADDM Tuning Session Performance Versus Business Requirements Using Metrics and Alerts Metrics and Alerts Overview Limitation of Base Statistics Benefits of Metrics Viewing Metric History Information Viewing Histograms Server-Generated Alerts Setting Thresholds Metrics and Alerts Views Using Baselines Comparative Performance Analysis with AWR Baselines Automatic Workload Repository Baselines Moving Window Baseline Baselines in Performance Page Settings Baseline Templates AWR Baseslines Creating AWR Baselines Managing Baselines with PL/SQL Using AWR-Based Tools Automatic Maintenance Tasks ADDM Performance Monitoring Using Compare Periods ADDM Active Session History New or Enhanced Automatic Workload Repository Views Emergency Monitoring Real-time ADDM Real-Time Database Operation Monitoring Overview Use Cases Defining a Database Operation Scope of a Composite Database Operation Database Operation Concepts Identifying a Database Operation Enabling Monitoring of Database Operations Identifying, Starting, and Completing a Database Operation Monitoring Applications What is a Service? Service Attributes Service Types Creating Services Managing Services in a Single-Instance Environment Where are Services Used? Using Services with Client Applications Services and Pluggable Databases Identifying Problem SQL Statements SQL Statement Processing Phases Role of the Oracle Optimizer Identifying Bad SQL Top SQL Reports SQL Monitoring What is an Execution Plan? Methods for Viewing Execution Plans Uses of Execution Plans Influencing the Optimizer Functions of the Query Optimizer Selectivity Cardinality and Cost Changing Optimizer Behavior Optimizer Statistics Extended Statistics Controlling the Behavior of the Optimizer with Parameters Enabling Query Optimizer Features Reducing the Cost of SQL Operations Reducing the Cost Index Maintenance SQL Access Advisor Table Maintenance for Performance Table Reorganization Methods Space Management Extent Management Data Storage Using SQL Performance Analyzer Real Application Testing: Overview Real Application Testing: Use Cases SQL Performance Analyzer: Process Capturing the SQL Workload Creating a SQL Performance Analyzer Task SQL Performance Analyzer: Tasks Parameter Change SQL Performance Analyzer Task Page SQL Performance Management Maintaining SQL Performance Maintaining Optimizer Statistics Automated Maintenance Tasks Statistic Gathering Options Setting Statistic Preferences Restore Statistics Deferred Statistics Publishing Automatic SQL Tuning Using Database Replay Using Database Replay The Big Picture System Architecture Capture Considerations Replay Considerations: Preparation Replay Considerations Replay Options Replay Analysis Tuning the Shared Pool Shared Pool Architecture Shared Pool Operation The Library Cache Latch and Mutex Diagnostic Tools for Tuning the Shared Pool Avoiding Hard Parses Reducing the Cost of Soft Parses Sizing the Shared Pool Tuning the Buffer Cache Oracle Database Architecture: Buffer Cache Buffer Cache: Highlights Database Buffers Buffer Hash Table for Lookups Working Sets Buffer Cache Tuning Goals and Techniques Buffer Cache Performance Symptoms Buffer Cache Performance Solutions Tuning PGA and Temporary Space SQL Memory Usage Performance Impact Automatic PGA Memory SQL Memory Manager Configuring Automatic PGA Memory Setting PGA_AGGREGATE_TARGET Initially Limiting the size of the Program Global Area (PGA) SQL Memory Usage Automatic Memory Oracle Database Architecture Dynamic SGA Granule Memory Advisories Manually Adding Granules to Components Increasing the Size of an SGA Component Automatic Shared Memory Management: Overview SGA Sizing Parameters: Overview Performance Tuning Summary with Waits Commonly Observed Wait Events Additional Statistics Top 10 Mistakes Found in Customer Systems Symptoms Oracle Database Cloud Service: Overview Database as a Service Architecture, Features and Tooling Software Editions: Included Database Options and Management Packs Accessing the Oracle Database Cloud Service Console Automated Database Provisioning Managing the Compute Node Associated With a Database Deployment Managing Network Access to Database as a Service Scaling a Database Deployment Performance Management in the Database Cloud Environment Performance Monitoring and Tuning What Can be Tuned in a DBCS Environment?