488 Row courses

Master the skills you need to propel your career forward in personal trainer or fitness trainer. Equip yourself with the essential knowledge and skillset that make you a confident personal trainer or fitness trainer and take your career to the next level. This comprehensive course is designed to help you reach your professional goals. The skills and knowledge that you will gain through studying this personal trainer course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective personal trainer or fitness trainer practice and equip you with the essential skills, confidence and competence to assist you in the personal trainer or fitness trainer industry. You'll gain a solid understanding of the core competencies required to drive a successful career in personal trainer or fitness trainer. Learn from expert tutors with industry experience, teaching you the latest expertise and best practice. This extensive course is designed for personal trainer or fitness trainer professionals who are aspiring to specialise in personal trainer or fitness trainer. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV. Enrol today and take the next step towards your personal and professional goals. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction 00:03:00 Roles & Responsibilities Of A Strength Coach 00:02:00 The Major Muscle Groups Explained Most Important Muscle Groups Overview 00:03:00 The Diffent Types of Muscle Fibers 00:03:00 Muscle Agonists & Antagonists 00:01:00 Quadriceps Explained 00:01:00 Hamstrings Explained 00:01:00 Calf Muscles Explained 00:01:00 Chest Muscles Explained 00:01:00 Back Muscles Explained 00:02:00 Shoulder Muscles Explained 00:01:00 Biceps Explained 00:01:00 Triceps Explained 00:01:00 Abdominal Muscles Explained 00:01:00 Muscle Growth Fundamentals Common Muscle Growth Myths Debunked 00:04:00 Muscle Hypertrophy Explained 00:03:00 Progressive Overload 00:02:00 How Much Muscle Can You Gain in A Week/Month/Year 00:03:00 Client Assessment Client Interview 00:02:00 Estimating 1 Rep Maximum Strength 00:04:00 Workout Design Workout Design Overview 00:01:00 Adherence 00:03:00 The 4 Most Important Exercises For Beginners 00:02:00 How Many Isolation Exercises Should You Do? 00:02:00 Exercise Order 00:01:00 Volume: How Many Sets & Reps? 00:02:00 Intensity: How Heavy Should You Train? 00:01:00 How Often Should You Train? 00:02:00 The Ideal Rest Periods 00:02:00 Time Under Tension Explained 00:02:00 Sample Workouts Sample Workouts Intro 00:01:00 How To Design A Beginner Workout Plan 00:08:00 How To Correctly Warm Up Before Lifting Weights 00:03:00 3 Day Beginner Routine 00:06:00 4 Day Routine 00:04:00 5 Day Routine 00:02:00 Exercise Videos: Compound Exercises Exercise Videos Overview 00:01:00 5 Most Important Aspects Of Correct Lifting Form 00:03:00 Bench Press 00:01:00 Chest Press Machine 00:01:00 Squats 00:01:00 Deadlift 00:01:00 Overhead Press 00:01:00 Dumbbell Overhead Press 00:01:00 Lat Pulldown 00:01:00 Dips 00:01:00 Barbell Row 00:01:00 Barbell Row (Different Grip) 00:01:00 Cable Row 00:01:00 Iso Row Machine 00:01:00 Exercise Videos: Isolation Exercises Hammer Curls 00:01:00 Triceps Rope Pushdown 00:01:00 Calf Raise 00:01:00 Shoulder Front Raise 00:01:00 Shoulder Side Raise 00:01:00 Butterfly / Pec Deck 00:01:00 Dumbbell Flyes 00:01:00 Setting Up A Bodybuilding Diet Nutrition Overview 00:01:00 Calories Explained 00:03:00 How to determine your calorie maintenance level (TDEE) 00:03:00 How to track calories 00:05:00 Ideal Protein Intake 00:01:00 Ideal Carb Intake 00:01:00 Ideal Fat Intake 00:01:00 What about the remaining calories 00:02:00 Determining Meal Structure 00:03:00 Quality Protein Foods 00:01:00 Quality Carb Foods 00:01:00 Quality Fat Foods 00:01:00 Adjusting Your Diet For Muscle Gains 00:04:00 Adjusting Your Diet For Weight Loss 00:05:00 The Perfect Pre Workout Meal 00:03:00 The Perfect Post Workout Meal 00:01:00 Supplements Supplements Overview 00:01:00 Top 3 Beginner Supplements 00:04:00 How To Use Protein Powder 00:05:00 How To Use Creatine 00:04:00 Beta Alanin 00:01:00 BCAAs 00:04:00 Rest & Recovery Recovery Overview 00:01:00 Post Workout Recovery Routine 00:03:00 How To Break Through A Strength Plateau 00:06:00 How To Deload Correctly 00:04:00 The importance of sleep 00:04:00 6 Tips To Fall Asleep Faster 00:03:00 FAQ & Misceallenaous Should Men & Women Train Differently? 00:02:00 What Should You Eat Before Bed To Build Muscle? 00:03:00 Does Electric Muscle Stimulation (EMS) Work? 00:01:00 What Should You Train On Your First Day At The Gym? 00:07:00 Assessment Assessment - Personal Trainer Diploma 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview Unlock the secrets to a fitter, healthier you with the Science-Based Workout: Build Muscle, Lose Fat & Get Fit course! This course is your ultimate guide to transforming your body through scientifically-backed workout regimes and dietary plans.  The course starts from the basics with an 'Introduction' and 'Course Overview', to 'Simple Muscle Course Overview' and 'In-Depth Introduction'. Grasp the typical mistakes beginners make and learn the perfect Step By Step Fat Loss Formula and Muscle Building Formula. Understand the critical rules of successful dieting and nutrition and how to tailor your bulking and cutting diets.  Also, you'll discover the mysteries behind pre and post-workout meals and supplements and develop a solid workout plan. Plus, master the five essential aspects of lifting form, learn about abs and the simplest way to a six-pack, and more. The course also includes insights on crucial exercises like bench presses, squats, deadlifts, military presses, barbell rows, pull-ups, lat pulldowns, hammer curls, and tricep extensions. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Science-Based Workout: Build Muscle, Lose Fat & Get Fit. It is available to all students, of all academic backgrounds. Requirements Our Science-Based Workout: Build Muscle, Lose Fat & Get Fit is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 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 4 sections • 33 lectures • 01:33:00 total length •Introduction 00:01:00 •Course Overview: 00:02:00 •Simple Muscle Course Overview: 00:02:00 •In Depth Introdcution: 00:03:00 •Most Common Beginner Mistakes: 00:04:00 •Step By Step Fat Loss Formula: 00:06:00 •Muscle Building Formula: 00:07:00 •The 2 Rules Of Successful Dieting And Nutrition: 00:10:00 •How To Create A Bulking Diet: 00:04:00 •How To Create A Cutting Diet: 00:04:00 •Pre-workout meal copy: 00:04:00 •Post workout meal copy: 00:02:00 •Supplements: 00:05:00 •Workout Plan: 00:06:00 •Cardio: 00:04:00 •5 Most Important Aspects Of Lifting Form: 00:03:00 •What About Abs - The Simplest Way To Getting A Six Pack: 00:03:00 •Warm Up: 00:03:00 •Progressive Overload: 00:03:00 •Bench Press: 00:01:00 •Squats: 00:01:00 •Deadlift: 00:01:00 •Military Press: 00:01:00 •Barbell Row (Overhand): 00:01:00 •Barbell Row (Underhand): 00:01:00 •Pull-Up: 00:01:00 •Lat Pulldown: 00:01:00 •Hammer Curls: 00:01:00 •Hammer Rope Curls: 00:01:00 •Tricep Rope Pushdown: 00:01:00 •Triceps Extensions: 00:01:00 •SMART Goals setting: 00:04:00 •More Tips To Stay Motivated: 00:01:00

Right before Christmas, NYE and holidays will make some of us more lazy, I am happy to invite you to practice with me the first of the last two Yin Practice for this 2022. What is Yin Yoga? Yin Yoga is a Yoga style based on keeping positions (or "asanas") for an extended period of time, allowing us to reach and deepen the union between our body and our mind. This Sunday class will start at 12:15 and will last around 60 minutes. (Tara Studio: 25-31 Ironmonger Row, London EC1V 3QW) Hope to see you there! Namaste

Description If you are passionate about building muscle and losing fat at the same time with a proven workout and diet program, then this Science-Based Workout: Build Muscle, Lose Fat & Get Fit course is an ideal choice for you. This Science-Based Workout: Build Muscle, Lose Fat & Get Fit course will reveal the secrets of building muscle and losing fat with a science-based workout plan. In this course, you will discover the most popular, effective exercises and workout tips and will gain an understanding of the science behind building muscle and healthy dieting.  You will also explore a guide to creating the perfect beginner and advanced workout plan, to set clear and defined fitness goals that will motivate you and keep you on track. This course goes into detail on how to perform common exercises, including workout tips and the things to avoid that prevent beginners from gaining muscle and losing fat. What you'll learn Discover the science behind exercising and healthy eating to build muscle. Build muscle and lose unwanted fat through simple yet effective bodyweight exercises. Discover a complete bodyweight workout program best suited to beginners, including the nutritional supplements that work best. Explore our expert guidelines for creating a fitness routine and get trained on how to spend the right amount of time on the proper bodyweight exercises. Learn what it takes to build a fabulous physique and how to follow a diet successfully. Discover techniques that reduce the chance of injury during workouts and the secret to long term muscle growth. Learn some interesting facts about nutrition and dieting that boost your fitness. Discover plenty of tips and tricks to stay motivated and establish a lifetime passion for exercising. Requirements You Should Have A Gym Membership Or Access To Strength Training Equipment Who this course is for This Course Is Meant For Beginners Looking For A Well Designed, Science-Based Workout That Will Help Them Build Muscle And Lose Fat Introduction Introduction FREE 00:01:00 Course Overview 00:02:00 Simple Muscle Course Overview 00:02:00 In Depth Introdcution 00:03:00 The Science Behind Building Muscle & Losing Fat Most Common Beginner Mistakes 00:04:00 Step By Step Fat Loss Formula 00:06:00 Muscle Building Formula 00:07:00 The 2 Rules Of Successful Dieting And Nutrition 00:10:00 How To Create A Bulking Diet 00:04:00 How To Create A Cutting Diet 00:04:00 Pre-workout meal copy 00:04:00 Post workout meal copy 00:02:00 Supplements 00:05:00 Beginner Workout Program Workout Plan 00:06:00 Cardio 00:04:00 5 Most Important Aspects Of Lifting Form 00:03:00 What About Abs - The Simplest Way To Getting A Six Pack 00:03:00 Warm Up 00:03:00 Progressive Overload 00:02:00 Bench Press 00:01:00 Squats 00:01:00 Deadlift 00:01:00 Military Press 00:01:00 Barbell Row (Overhand) 00:01:00 Barbell Row (Underhand) 00:01:00 Pull-Up 00:01:00 Lat Pulldown 00:01:00 Hammer Curls 00:01:00 Hammer Rope Curls 00:01:00 Tricep Rope Pushdown 00:01:00 Triceps Extensions 00:01:00 Motivation & Goal Setting SMART Goals setting 00:04:00 More Tips To Stay Motivated 00:01:00

Our Christmas crochet workshops live online will get you in the festive mood! Create your very own crochet tree decorations and garlands.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Introduction & What You will Learn 00:02:00 TRX Explained: Why It Can Be Better Than Normal Exercise 00:01:00 TRX Fundamentals Who Is TRX For? 00:03:00 What Are The Benefits Of TRX? 00:03:00 Most Common TRX Mistakes 00:03:00 How to set up your TRX trainer system 00:03:00 Your TRX Workout The TRX Workout Plan 00:04:00 How To Progress With Your TRX Workout 00:04:00 The Right Warm Up 00:01:00 Dynamic Stretching Routine 00:02:00 Exercise Videos Compound Vs Isolation Exercises 00:01:00 TRX Bicep Curl 00:01:00 TRX Body Row 00:01:00 TRX Chest Flyes 00:01:00 TRX Chest Press 00:01:00 TRX Hamstring Curl 00:01:00 TRX Lunge and Row 00:01:00 TRX Lunges 00:01:00 TRX Pike Press 00:01:00 TRX Plank 00:01:00 TRX Push Up 00:01:00 TRX Side Plank 00:01:00 TRX Single Leg Squats 00:01:00 TRX Squats 00:01:00 TRX Triceps Extensions 00:01:00 TRX Y Flyes 00:01:00 TAX and Cardio How To Combine TRX And Cardio 00:03:00 TRX Cardio Routine 00:03:00 Boosting Your Results Boosting Your Results Overview 00:01:00 Step By Step Muscle Building Formula 00:08:00 Should You Train Fasted? 00:06:00 Best Beginner Supplements 00:04:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Register on the Personal Trainer / Fitness Instructor Training Course today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a certificate as proof of your course completion. The Personal Trainer / Fitness Instructor Training Course course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Personal Trainer / Fitness Instructor Training Course course Receive a digital certificate upon successful completion of the 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) 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 Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are aspiring professionals. This 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 online training is open to all students and has no formal entry requirements. To study the Personal Trainer / Fitness Instructor Training Course course, all you need is a passion for learning, A good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction Introduction 00:01:00 Roles & Responsibilities Of A Strength Coach 00:02:00 The Major Muscle Groups Explained Most Important Muscle Groups Overview 00:04:00 The Different Types Of Muscle Fibers 00:03:00 Muscle Agonists & Antagonists 00:02:00 Quadriceps Explained 00:01:00 Hamstrings explained 00:01:00 Calf Muscles Explained 00:01:00 Chest Muscles Explained 00:01:00 Back Muscles Explained 00:02:00 Shoulder Muscles Explained 00:01:00 Biceps Explained 00:01:00 Triceps Explained 00:01:00 Abdominal Muscles Explained 00:01:00 Muscle Growth Fundamentals Common Muscle Growth Myths Debunked 00:04:00 Muscle Hypertrophy Explained 00:04:00 Progressive Overload 00:03:00 How Much Muscle Can You Gain in A Week/Month/Year 00:03:00 Client Assessment Client Interview 00:02:00 Estimating 1 Rep Maximum Strength 00:04:00 Workout Design Workout Design Overview 00:01:00 Adherence 00:04:00 The 4 Most Important Exercises For Beginners 00:03:00 How Many Isolation Exercises Should You Do? 00:02:00 Exercise Order 00:01:00 Volume: How Many Sets & Reps? 00:02:00 Intensity: How Heavy Should You Train? 00:02:00 How Often Should You Train? 00:02:00 The Ideal Rest Periods 00:03:00 Time Under Tension Explained 00:02:00 Sample Workouts Sample Workouts Intro 00:01:00 How to Design a Beginner Workout 00:09:00 How To Warm Up Before Lifting Weights 00:03:00 3 Day Beginner Routine 00:06:00 4 Day Routine 00:04:00 5 Day Routine 00:02:00 Exercise Videos Exercise Videos Overview 00:01:00 5 Most Important Aspects Of Correct Lifting Form 00:03:00 Bench Press 00:01:00 Chest Press Machine 00:01:00 Squats 00:01:00 Deadlift 00:01:00 Overhead Press 00:01:00 Dumbbell Overhead Press 00:01:00 Lat Pulldown 00:01:00 Dips 00:01:00 Barbell Row 00:01:00 Barbell Row (Different Grip) 00:01:00 Cable Row 00:01:00 Iso Row Machine 00:01:00 Exercise Videos: Isolation Exercises Hammer Curls 00:01:00 Triceps Rope Pushdown 00:01:00 Calf Raise 00:01:00 Shoulder Front Raise 00:01:00 Shoulder Side Raise 00:01:00 Butterfly / Pec Deck 00:01:00 Dumbbell Flyes 00:01:00 Military Press 00:01:00 Pull-Up 00:01:00 Hammer Rope Curls 00:01:00 Triceps Extensions 00:01:00 Setting Up A Bodybuilding Diet Nutrition Overview 00:01:00 Calories Explained 00:04:00 How to determine your calorie maintenance level (TDEE) 00:03:00 Ideal Protein Intake 00:01:00 Ideal Carb Intake 00:02:00 Ideal Fat Intake 00:01:00 What about the remaining calories 00:02:00 Determining Meal Structure 00:03:00 Quality Protein Foods 00:01:00 Quality Carb Foods 00:01:00 Quality Fat Foods 00:01:00 Adjusting Your Diet For Muscle Gains 00:04:00 Adjusting Your Diet For Weight Loss 00:05:00 The Perfect Pre Workout Meal 00:04:00 The Perfect Post Workout Meal 00:01:00 Supplements Supplements Overview 00:01:00 Top 3 Beginner Supplements 00:04:00 How To Use Protein Powder 00:06:00 How To Use Creatine 00:04:00 Beta Alanine 00:02:00 BCAAs 00:04:00 Rest & Recovery Recovery Overview 00:02:00 Post Workout Recovery Routine 00:04:00 How To Break Through A Strength Plateau 00:06:00 How To Deload Correctly 00:04:00 The importance of sleep 00:04:00 6 Tips To Fall Asleep Faster 00:03:00 FAQ & Misceallenaous Should Men & Women Train Differently? 00:03:00 What Should You Eat Before Bed To Build Muscle? 00:03:00 Does Electric Muscle Stimulation (EMS) Work? 00:02:00 What Should You Train On Your First Day At The Gym? 00:07:00 Exercise Files Exercise Files 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.

Start from the ground up and learn tips, tricks, shortcuts and build confidence in using Excel.

Throughout the summer we're offering members access to St Elmo's rehearsal space free of charge. You can book this just for yourself, but ideally you'll find some fellow students to jam with. Slots are for an hour but you can book 2 slots in a row where there is availability. There is only space for one person to book, so only 1 person from the party needs to reserve it.  Each members can book up to 3 hours per week 

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