• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

6074 Courses

Programming AutoCAD with SQL Server Database Using C#

4.7(160)

By Janets

Register on the Programming AutoCAD with SQL Server Database Using C# 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 Programming AutoCAD with SQL Server Database Using C# 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 Programming AutoCAD with SQL Server Database Using C# 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 Programming AutoCAD with SQL Server Database Using C# 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 Section 01: Introduction Course Topics 00:02:00 Introduction 00:02:00 Section 02: Tools and SQL Queries Section Overview 00:01:00 Downloading Visual Studio 2019 00:01:00 Downloading SQL Server Express 00:02:00 Downloading SQL Server Management Studio (SSMS) 00:01:00 SQL Queries - Overview 00:03:00 INSERT SQL Statement - Demo 00:13:00 SELECT SQL Statement - Demo 00:08:00 UPDATE SQL Statement - Demo 00:08:00 DELETE SQL Statement - Demo 00:11:00 Section 03: Create Database and Tables Section Overview 00:01:00 Creating the CADDB Database 00:03:00 Creating the Plines Table 00:04:00 Creating the MTexts Table 00:04:00 Creating the Plines Table 00:04:00 Creating the Blocks No Attribute Table 00:04:00 Creating the Blocks With Attributes Table 00:04:00 Section 04: Loading into SQL Server Database Section Overview 00:02:00 Loading Lines into SQL Server Database 00:01:00 Creating the CADDB Project 00:04:00 Creating the Settings File 00:04:00 Creating the Get Connection Method 00:03:00 Creating the LoadLines() Method 00:22:00 Creating the User Interface for the LoadLines() method 00:07:00 Running the LoadLines() Method 00:05:00 Loading MTexts into SQL Server Database - Overview 00:01:00 Creating the LoadMTexts() Method 00:10:00 Running the LoadMTexts() Method 00:06:00 Loading LWPolylines into SQL Server Database - Overview 00:01:00 Creating the LoadPolylines() Method 00:13:00 Running the LoadPlines() Method 00:03:00 Loading Blocks (No Attribute) into SQL Server Database - Overview 00:01:00 Creating the LoadBlocksNoAttribute() Method 00:11:00 Running the LoadBlocksNoAttribute() Method 00:03:00 Loading Blocks (with Attributes) into SQL Server Database - Overview 00:01:00 Creating the LoadBlocksWithAttributes() Method 00:07:00 Running the BlocksWithAttributes() Method 00:02:00 Section 05: Retrieving Data from Database Section Overview 00:02:00 Retrieving Lines from SQL Server Database - Overview 00:01:00 Creating the DBRetrieveUtil Class 00:03:00 Creating the RetrieveAndDrawLines() Method (Part 1) 00:17:00 Creating the GetColorIndex() Method 00:05:00 Creating the RetrieveAndDrawLines() Method (Part 2) 00:11:00 Running and Testing the RetrieveAndDrawLines() Method 00:09:00 Retrieving MTexts from SQL Server Database - Overview 00:01:00 Creating the RetrieveAndDrawMTexts() Method 00:11:00 Running and Testing the CreateAndDrawMTexts() Method 00:05:00 Retrieving LWPolylines from SQL Server Database - Overview 00:01:00 Creating the RetrieveAndDrawPlines() Method 00:12:00 Running and Testing the RetrieveAndDrawPlines() Method 00:05:00 Retrieving Blocks (No Attribute) from SQL Server Database - Overview 00:01:00 Creating the RetrieveAndDrawBlocksNoAttribute() Method 00:11:00 Running and Testing the RetrieveAndDrawBlocksNoAttribute() Method 00:05:00 Retrieving Blocks (with Attributes) from SQL Server Database - Overview 00:01:00 Creating the RetrieveAndDrawBlocksWithAttributes() Method 00:21:00 Running and Testing the RetrieveAndDrawBlocksWithAttributes() Method 00:10:00 Section 06: Updating Data in SQL Server Database - Overview Section Overview 00:01:00 Updating Lines in SQL Server Database - Overview 00:01:00 Creating the DBUpdateUtil Class 00:02:00 Creating the UpdateLines() Method 00:25:00 Creating the User Interface for UpdateLines() Method 00:02:00 Running and Testing the UpdateLines() Method 00:08:00 Updating MTexts in SQL Server Database - Overview 00:01:00 Creating the UpdateMTexts() Method 00:09:00 Creating the User Interface for UpdateMTexts() 00:01:00 Running and Testing the UpdateMTexts() Method 00:07:00 Updating the LWPolylines in SQL Server Database - Overview 00:01:00 Creating the UpdateLWPolylines() Method 00:09:00 Running and Testing the UpdateLWPolylines() Method 00:07:00 Updating Blocks (No Attributes) in SQL Server Database - Overview 00:01:00 Creating the UpdateBlocksNoAttributes() Method 00:10:00 Creating the User Interface for UpdateBlocksNoAttributes() Method 00:01:00 Running and Testing the UpdateBlocksNoAttributes() Method 00:04:00 Updating Blocks With Attributes in SQL Server Database - Overview 00:01:00 Creating the UpdateBlocksWithAttributes() Method 00:08:00 Creating the User Interface for UpdateBlocksNoAttributes() Method 00:01:00 Running and Testing the UpdateBlocksWithAttributes() Method 00:09:00 Section 07: Deleting Data in SQL Server Database from AutoCAD - Overview Section Overview 00:02:00 Deleting Lines in SQL Server from AutoCAD - Overview 00:01:00 Creating the DBDeleteUtil Class 00:01:00 Creating the DeleteLines() Method 00:13:00 Creating the User Interface for the DeleteLines() Method 00:02:00 Running and Testing the DeleteLines() Method 00:04:00 Deleting MTexts in SQL Server Database from AutoCAD - Overview 00:01:00 Creating the DeleteMTexts() Method 00:04:00 Creating the User Interface for DeleteMTexts() Method 00:01:00 Running and Testing the DeleteMTexts() Method 00:03:00 Deleting LWPolylines in SQL Server Database from AutoCAD - Overview 00:01:00 Creating the DeletePlines() Method 00:04:00 Creating the User Interface for the DeletePlines() Method 00:01:00 Running and Testing the DeletePlines() Method 00:02:00 Deleting Blocks (No Attribute) in SQL Server Database from AutoCAD - Overview 00:01:00 Creating the DeleteBlocksNoAttribute() Method 00:03:00 Creating the User Interface for DeleteBlocksNoAttribute() Method 00:01:00 Running and Testing DeleteBlocksNoAttribute() Method 00:02:00 Deleting Blocks (With Attributes) in SQL Server Database from AutoCAD - Overview 00:01:00 Creating the DeleteBlocksWithAttributes() Method 00:02:00 Creating the User Interface for DeleteBlocksWithAttributes() Method 00:01:00 Running and Testing the DeleteBlocksWithAttributes() Method 00:02: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.

Programming AutoCAD with SQL Server Database Using C#
Delivered Online On Demand7 hours 57 minutes
£25

Child Care, Nannying and Safeguarding Children

4.7(160)

By Janets

Follow your dreams by enrolling on the Child Care, Nannying and Safeguarding Children course today and develop the experience, skills and knowledge you need to enhance your professional development. Child Care, Nannying and Safeguarding Children will help you arm yourself with the qualities you need to work towards your dream job. Study the Child Care, Nannying and Safeguarding Children training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The Child Care, Nannying and Safeguarding Children course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This Child Care, Nannying and Safeguarding Children 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 Child Care, Nannying and Safeguarding Children course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the Child Care, Nannying and Safeguarding Children course, to ensure you are supported every step of the way. Get a digital certificate as proof of your Child Care, Nannying and Safeguarding Children 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 Child Care, Nannying and Safeguarding Children course. The Child Care, Nannying and Safeguarding Children course is designed by industry experts and is tailored to help you learn new skills with ease.  The Child Care, Nannying and Safeguarding Children is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the Child Care, Nannying and Safeguarding Children when it suits you. Access the Child Care, Nannying and Safeguarding Children course modules from any internet-enabled device, including computers, tablets, and smartphones. The Child Care, Nannying and Safeguarding Children course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the Child Care, Nannying and Safeguarding Children now and start learning instantly! What You Get Out Of Studying Child Care, Nannying and Safeguarding Children With Janets: Receive a digital Certificate upon successful completion of the Child Care, Nannying and Safeguarding Children 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 Child Care, Nannying and Safeguarding Children training course is delivered through Janets' online learning platform. Access the Child Care, Nannying and Safeguarding Children content from any internet-enabled device whenever or wherever you want to. The Child Care, Nannying and Safeguarding Children 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 Child Care, Nannying and Safeguarding Children 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 Child Care, Nannying and Safeguarding Children course. After successfully passing the Child Care, Nannying and Safeguarding Children course exam, you will be able to apply for a CPD-accredited certificate as proof of your Child Care, Nannying and Safeguarding Children qualification. Certification All students who successfully complete the Child Care, Nannying and Safeguarding Children course can instantly download their digital certificate. You can also purchase a hard copy of the Child Care, Nannying and Safeguarding Children course certificate, which will be delivered by post for £9.99. Who Is This Course For: The Child Care, Nannying and Safeguarding Children is ideal for those who already work in this sector or are an aspiring professional. This Child Care, Nannying and Safeguarding Children 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 Child Care, Nannying and Safeguarding Children is open to all students and has no formal entry requirements. To study the Child Care, Nannying and Safeguarding Children 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 Child Care, Nannying and Safeguarding Children 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 Child Care, Nannying and Safeguarding Children and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Child Care, Nannying and Safeguarding Children - Updated Version Childcare and Education Module 1: Caring for Children 00:28:00 Module 2: Healthy Food, Healthy living 00:27:00 Module 3: Keeping Children Healthy & Safe 00:34:00 Module 4: Child Protection 00:26:00 Module 5: Play, Imagination and Creativity 00:28:00 Module 6: Introduction to EYFS 00:15:00 Module 7: Importance of Early Years in Development 00:22:00 Module 8: EYFS Teaching Techniques 00:17:00 Module 9: Working as an EYFS Teacher 00:21:00 Module 10: Promoting Learning and Development 00:33:00 Module 11: Children Having Special Education Needs or Disabilities 00:19:00 Nanny Care Worker Introduction to Nanny Care Workers 00:24:00 Understanding Child Development 00:24:00 Care for Children 00:17:00 Healthy Food, Healthy living 00:24:00 Keeping Children Healthy & Safe 00:31:00 Early Years Provision 00:19:00 Establishing Relationship and Routines 00:16:00 Time Management for Nannies 00:18:00 Nanny's Job Profile 00:28:00 Establishing a Nanny's Career 00:19:00 Safeguarding Children Introduction to Safeguarding 00:27:00 Laws and Guidance 00:43:00 Child Abuse 00:48:00 Child Sexual Exploitation 00:36:00 Responding to Disclosure and Reporting 00:25:00 Risks and Risk Assessment 00:16:00 Things to Do after Referral 00:23:00 Record Keeping 00:18:00 Child Care, Nannying and Safeguarding Children - Old Version Nannying What is a Nanny? 00:30:00 Time Management for Nannies 00:15:00 A Day in the Life of Martha, the Nanny 00:30:00 Caregiver and Team Player 00:15:00 It Takes a Village to Raise a Child 00:15:00 The Nanny's Job Profile 00:15:00 Meet the Needs of the Child 01:00:00 Childcare Child Care Guidelines 00:30:00 Outdoor Safety 00:15:00 Plants That Poison 00:15:00 Guidelines for Food Preparation and Handling 00:30:00 Changing Diapers 00:30:00 Symptoms of Illness 00:30:00 Taking Care of Babies Baby Products For Bath 00:30:00 Tips To Manage Your Baby Sleeping Schedules 00:30:00 Baby Weaning Difficulties And Tips To Cope With It 00:30:00 Choosing The Right Baby Care 00:30:00 Choosing The Right Baby Formula 00:30:00 Coping With Colic 00:20:00 Diaper Rash Help 00:30:00 Feeding Schedules Tips to Get it Right 00:30:00 How To Get Rid Of A Pacifier 00:30:00 Premature Baby Help 00:30:00 Reading To Baby 00:30:00 Reducing Baby's Risk Of Choking 00:30:00 Safety Measures For Food Borne Illnesses 01:00:00 The Benefits of Breastfeeding 00:25:00 Why Do Babies Cry 00:30:00 Baby Car Seat Buying Tips 00:30:00 When You Spot Something Wrong 00:30:00 Baby Care and Breastfeeding 00:20:00 Baby Care And Television 00:15:00 Baby Hazards: Be Careful Or You May Not Know 00:30:00 Baby Pacifiers: Yes Or No 00:30:00 What's In The Nursery 00:30:00 Baby Bathing Is This Hard To Do 00:20:00 5 Things To Keep In Mind With Baby Care 00:30:00 Babies At Work Good Or Bad 00:15:00 Baby Care Bonding Time With My First Baby 00:30:00 Communicating With My First Baby 00:30:00 Fashion Tips For My First Baby 00:30:00 How To Change My First Baby's Diaper 00:30:00 My First Baby Essentials 00:30:00 My First Baby Feeding Guide 00:30:00 My First Baby Learning The Basics 00:30:00 My First Baby: Understanding The Crying Game 00:30:00 Nutritious Bites For My First Baby 00:30:00 The Joys And Angst Of Holding My First Baby 00:30:00 Mock Exam Mock Exam- Child Care, Nannying and Safeguarding Children 00:30:00 Final Exam Final Exam- Child Care, Nannying and Safeguarding Children 00:30: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.

Child Care, Nannying and Safeguarding Children
Delivered Online On Demand35 hours
£25

Skincare Routine for Acne-Prone Skin 2021 Training Course

By Study Plex

Highlights of the Course Course Type: Online Learning Duration: 3 Hours 54 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about skincare for acne Understand the core competencies and principles of skincare for acne Explore the various areas of skincare for acne Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert aesthetician/cosmetician or makeup professional Skincare Routine for Acne-Prone Skin 2021 Training Course Master the skills you need to propel your career forward in skincare for acne. This course will equip you with the essential knowledge and skillset that will make you a confident aesthetician/cosmetician or makeup professional and take your career to the next level. This comprehensive skincare for acne prone skin course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this skincare for acne prone skin 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 skincare for acne practice and equip you with the essential skills, confidence and competence to assist you in the skincare for acne industry. You'll gain a solid understanding of the core competencies required to drive a successful career in skincare for acne. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for aesthetician/cosmetician or makeup professional or for people who are aspiring to specialise in skincare for acne. Enrol in this skincare for acne prone skin course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Essential Skincare for Acne Prone Skin Kits that you might require in order self-practice purpose: Makeup Removers Against Acne Acne-Friendly Face Washes /Cleansers Exfoliants and Scrubs Facial Masks Toners Moisturizers Serums Treatments and Masks Spot Treatment Facial Mist Sunscreen Pimple Patches Who is this Course for? This comprehensive skincare for acne prone skin course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this skincare for acne can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This skincare for acne prone skin course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This skincare for acne prone skin course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This skincare for acne prone skin course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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. Course Curriculum Introduction Acne Prone Skin : Acne Formation, Symptoms and Cause Acne Formation,Symptoms and Causes 00:01:00 The Different Acne Forms 00:07:00 The Symptoms of Acne 00:02:00 The Causes Of Acne 00:05:00 Acne Diagnosis & Therapy Acne Diagnosis 00:01:00 Acne Therapy & External Treatment 00:03:00 More Advices on How to Fight Acne 00:02:00 Acne Homeopathy 00:02:00 Acne Diet: "You Are What You Eat" Acne Diet Introduction 00:06:00 How to Uncover Incompatible Food Foods That Have Impact On Your Skin 00:01:00 Fluid Intake : How to Manage Your Daily Fluid Intake & Never Skip You Water 00:02:00 Acne Skincare Routine Skincare Introduction 00:02:00 The Basic Skincare Steps For an Acne-Prone Skin 00:05:00 The Correct Sunscreen Product And Spf For Your Skin 00:04:00 Exfoliation: Acne-Prone Skin's Bestfriend in Skincare 00:02:00 Face Masks: An Energy Boost For Your Skin 00:02:00 Serums: A High Dosage of Active Ingredients 00:02:00 Conclusion: Important Advices You Need to Take in Consideration 00:01:00 Men and Acne: How Men's Skin is Different and How They Should Take Care of it Anatomy of Men's Skin : The Differences Between a Man's And Woman's Skin 00:03:00 Hair Growth: Ingrown Hairs and How to Shave With an Acne-Prone Skin 00:03:00 Men's Skincare Routine: A Guide to Your Skincare Routine as a Man 00:07:00 Conclusion : Reminder to Always Reconsider 00:02:00 Homemade Masks & Scrubs : Natural Remedies On How You Can treat Your Skin The Great Effect of Natural Remedies 00:02:00 Facts About Homemade Masks & Scrubs You Need to Know 00:02:00 The Main Benefits of Homemade Masks Suitable For Acne-Prone Skin 00:01:00 Homemade Remedies : Recipe & Instructions 00:06:00 Cosmetic facial treatments for Acne-prone Skin Why Facial Treatments 00:01:00 Acid Peeling/Exfoliation 00:03:00 (Diamond) Microdermabrasion : The Most Effective Cosmetic Equipment 00:03:00 Microneedling: The wonder needles 00:03:00 Hydrafacial : Deep Care For Acne-Prone Skin 00:03:00 "Comedogenic": Why you Should Avoid Comedogenic Ingredients in Your Product All About Comedogenic Ingredients And Their Impact on Acne-Prone Skin 00:05:00 Laser Treatments: How The Wonder Light Can Fight Acne! Laser Treatment Introduction 00:01:00 Longwave Laser Treatment : What it is And How it Works 00:01:00 Gentle Laser Peeling : Erbium YAG Laser & The Fractioned CO² Laser 00:01:00 Combination of Laser and Medical Peeling 00:02:00 Acne Coverage The Makeup Theory On Acne-Prone Acne Coverage Introduction 00:01:00 Properties of Makeup Products 00:02:00 Prep and Prime : We Always Begin With The Skin 00:01:00 Concealer & Foundation : The Correct Application on Acne-Prone Skin 00:02:00 Everything About Camouflage and its Application 00:02:00 Powders For Acne-Prone Skin : Not all Powders are Designed For Your Skin Type 00:01:00 Men and Acne Coverage 00:01:00 Conclusion : Before Makeup is After Makeup 00:01:00 Acne Coverage: the Makeup Application Demonstration On acne-Prone Skin Makeup Demonstration Introduction 00:01:00 FAQ : Should I Use a Primer 00:03:00 1st Step : Skincare Application 00:01:00 2nd Step : Primer Application 00:01:00 3rd Step : Color corrector Application 00:01:00 4th Step: Concealer Application 00:01:00 5th Step: Foundation Application 00:01:00 6th Step: Powder Application 00:01:00 7th Step: Creating depth with Contour 00:01:00 8th Step: Blush and Highlighter Application 00:02:00 9th Step : Setting Spray Application And How to Stay Matte All Day 00:02:00 "Good" and "Bad" Alcohols How to Find Out Which Alcohol Ingredient is Good or Bad for Your Acne Skin 00:04:00 Acne Medication Therapy : Birth Control Pills Birth Controll Pills And Hormonal Acne Intro 00:01:00 Micro Or Mini Pills 00:01:00 How The Hormones Progestin and Estrogin Work 00:01:00 Side Effects of the pills: Worth it 00:01:00 Which Pills From Which Generation Are More Risky 00:01:00 Questions to Ask Your Gynecologist 00:02:00 Acne Medication : Isotretinoin Therapy for Severe Acne Isotretinoin Medication Intro 00:01:00 Side Effects of Isotretinoin 00:01:00 All About The Therapy And Care 00:02:00 Protective Face Mask and Acne+ Certificate Request The Pandemic And How it Has Worsened Your Acne + How to Prevent it 00:05:00 Supplementary Resources Supplementary Resources - Skincare Routine for Acne Prone Skin 2021 00:00:00 Final Assessment Assessment - Skincare Routine for Acne Prone Skin 2022 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

Skincare Routine for Acne-Prone Skin 2021 Training Course
Delivered Online On Demand
£19

CSS Fundamentals Course

5.0(1)

By Course Gate

CSS is a popular and efficient scripting language for designing web pages. Every professional in the web development sector must have adequate CSS skills to establish their presence in the industry. If you are also aspiring to become a successful web developer or web designer, the CSS Fundamentals Course can help you build your competence in CSS. In the CSS Fundamentals Course, you will learn about the fundamentals of CSS. The course will show you what you can and can't do in CSS. Through the highly informative modules, you will pick up the skills to style, size and colour HTML elements with CSS. This comprehensive course will also provide detailed lessons on advanced positioning and positioning HTML elements with Float. By the end of the CSS Fundamentals Course, you will be able to build a solid foundation in CSS and receive a certificate of achievement. This certificate will enrich your resume and help you stand out from the competition. Enrol now! Learning Objectives Learn about the primary use of CSS Know the features of CSS Understand how to add CSS to a website Develop the skills to style, size and colour HTML elements with CSS Grasp the techniques of advanced positioning with CSS Know the steps of positioning HTML elements with Float Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited CSS Fundamentals Course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this CSS Fundamentals Course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successfully completing the CSS Fundamentals Course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Web Engineers Web Developers Web Designers IT professionals Course Curriculum Module 01: CSS in Context What Was CSS Originally Intended To Do? 00:07:00 DEMO: The Most Basic CSS Usage 00:07:00 Responsive Design 00:02:00 Chapter Summary 00:02:00 Module 02: Overview of CSS What is CSS? 00:04:00 Where Can You Find CSS? 00:03:00 What CSS Can and Can't Do 00:02:00 Optional Demo - Serving an HTML Application 00:05:00 How Do we Add CSS to a Website? 00:04:00 Demo - Adding CSS to a Website 00:06:00 CSS Selectors 00:03:00 Using CSS Selectors 00:05:00 Module Summary 00:01:00 Module 03: Styling HTML Elements with CSS Why do We Style CSS Elements? 00:03:00 CSS and Fonts 00:03:00 DEMO: Styling Text with CSS 00:07:00 Sizing HTML Elements with CSS 00:06:00 DEMO: Sizing HTML Elements with CSS 00:08:00 Colorizing HTML Elements with CSS 00:05:00 DEMO: Colorizing HTML Elements with CSS 00:07:00 Summary of this Chapter 00:01:00 Module 04: Arranging Elements with CSS Introduction 00:01:00 Adding Margin with CSS 00:01:00 Advanced Positioning with CSS 00:04:00 DEMO: Positioning Elements Absolutely and Relatively 00:07:00 Positioning HTML Elements with Float 00:02:00 DEMO: Positioning HTML Elements with Float 00:07:00 Summary of this Course 00:04:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

CSS Fundamentals Course
Delivered Online On Demand1 hour 57 minutes
£11.99

Complete Online Pilates Mat Course

5.0(1)

By Course Gate

Wave goodbye to stress and say hello to a healthy body, mind and soul with the Complete Online Pilates Mat Course. This pilates training course is the ultimate instructor-led program for mastering the practice of pilates online. In this course, you will be taught a wide range of pilates mat exercises, with instruction on how to position your body to achieve the correct form and improve your flexibility. This course is for learners of all levels and includes practical video tutorials to guide you every step of the way.  Whether you're a beginner with no experience, want to improve your technique, or wish to become a certified Pilates instructor, our comprehensive course is your stepping stone to a healthier, stronger you. Your Learning Goals: Improve your posture, flexibility and balance with our step-by-step training guide Strengthen your core and tone up in no time with effective pilate workout techniques Learn a wide range of beginner to advanced pilates exercises for learners of all levels Get step-by-step guidance on how to perform pilates poses correctly for maximum effect Elevate your mind body and soul through calming breathing exercises Take steps to become a fully certified Pilates instructor Understand the mental and physical health benefits of Pilates exercises Modify each pose to tailor each routine to your physical capabilities Improve your overall wellbeing and start your fitness journey today! Who is this Course for? Complete Online Pilates Mat Course is 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. 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. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Introduction Introduction 00:03:00 The history of Pilates 00:04:00 The principles of Pilates 00:04:00 Before Starting to your course Safety Guidelines 00:02:00 Body Positions in Pilates 00:08:00 Pelvic Stability Exercises 00:12:00 Neutral Position 00:02:00 Alignment 00:03:00 Breathing 00:03:00 Pre-Pilates exercises 00:19:00 Beginner Level Course Beginner Lesson 1 - Hundred, Roll up, Rolling like a ball 00:19:00 Beginner Lesson 2 - Spine stretch forward, Spine stretch side, Saw 00:12:00 Beginner Lesson 3 - Spine stretch forward, Spine stretch side, Saw 00:11:00 Beginner Lesson 4 - Swan, Single leg kick, Side leg lift, Side leg circle 00:12:00 Beginner Lesson 5 - Push ups 00:08:00 Release work and stretching 00:09:00 Beginner Level - complete workout 00:40:00 Intermediate Level Course Intermediate Lesson 1 - Double leg stretch, Single/Double straight leg stretch 00:25:00 Intermediate Lesson 2 - Criss cross, Open leg rocker, Spine twist 00:13:00 Intermediate Lesson 3 - Swimming, Double leg kick 00:11:00 Intermediate Lesson 4 - Side leg kick, Banana, Teaser(preparation) 00:11:00 Intermediate Lesson 5 - Corkscrew(modified), Leg pull down, Shoulder bridge 00:10:00 Intermediate level - complete workout 00:42:00 Advanced Level Course Advanced Level Lesson 1 - Teaser1, Teaser2, Teaser3 00:13:00 Advanced Level Lesson 2 - Hip circles, Roll over, Corkscrew 00:16:00 Advanced Level Lesson 3 - Leg pull up, Jackknife, Kneeling side kicks 00:15:00 Advanced Level Lesson 4 - Seated twist, Side bend twist, Side bend mermaid 00:12:00 Advanced Level Lesson 5 - Scissors, Bicycle, Boomerang 00:14:00 Advanced Level - complete workout 00:39:00 How to create your own work out? Self practice guide 00:02:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Complete Online Pilates Mat Course
Delivered Online On Demand6 hours 34 minutes
£11.99

CCAS Check Point Certified Automation Specialist

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is recommended for technical professionals who automate, orchestrate, and troubleshoot Check Point secured environments. Overview Explain how automation and orchestration work together Understand the key drivers for incorporating automation and orchestration into security management Execute a shell script that demonstrates how to build a comprehensive Security Policy. Recognize how the Check Point API framework integrates with R80 Security Management to support automation and orchestration of daily tasks Describe Check Point API tools and demonstrate how they are used to manage Check Point Security Management solutions Demonstrate how to define new objects and modify existing ones by using the Check Point API The goal of this course is to provide an understanding of the advanced concepts and skills necessary to automate and orchestrate tasks relating to managing Check Point Security Policies Course Ouline Explain how automation and orchestration work together Understand the key drivers for incorporating automation and orchestration into security management Execute a shell script that demonstrates how to build a comprehensive Security Policy. Recognize how the Check Point API framework integrates with R80 Security Management to support automation and orchestration of daily tasks Describe Check Point API tools and demonstrate how they are used to manage Check Point Security Management solutions Demonstrate how to define new objects and modify existing ones by using the Check Point API Demonstrate how to create API commands to efficiently maintain the Check Point Security Management Server database Demonstrate how to use different methods to update the database with API commands Become familiar with client-side and server-side scripting and scripting languages Understand how to use the Bash shell to develop APIs Recognize and describe many of the open source tools that are available to assist with API development Demonstrate how to use a custom REST application to update the database of a Security Management Server Demonstrate how to use Postman to manage the Security Policy database through the Check Point API Understand what steps to take to troubleshoot and debug API scripts Demonstrate basic troubleshooting techniques by reviewing debugging messages in various forms Understand how to use self-service portal capabilities to provide general IT services Recognize how automation tools work with Check Point APIs to automate security management tasks and orchestrate workflow behind service portals Demonstrate common tasks that are automated in a Web portal to manage the Security Policy LAB Exercises Demonstrate Check Point automation and orchestration Manage objects using the Check Point API Create a management API shell script Use a variety of methods to execute API commands Use a custom REST tool for API calls Use Postman for API calls Debug the Check Point management API Automate tasks using a Check Point API enabled Web portal Additional course details: Nexus Humans CCAS Check Point Certified Automation Specialist training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CCAS Check Point Certified Automation Specialist course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

CCAS Check Point Certified Automation Specialist
Delivered OnlineFlexible Dates
Price on Enquiry

VMware Cloud on Dell: Deploy and Manage 2022

By Nexus Human

Duration 4 Days 24 CPD hours This course is intended for Experienced system administrators, system engineers, and system integrators Overview By the end of the course, you should be able to meet the following objectives: Describe the business challenges that VMware Cloud on Dell EMC addresses Configure access to the vCenter Server instance Recognize the network configurations necessary to set up the VMware Cloud on Dell EMC Describe the NSX-T Data Center architecture in VMware Cloud on Dell EMC Recognize the storage options for VMware Cloud on Dell EMC Link a VMware Cloud on Dell EMC vCenter Server instance with an on-premises vCenter Single Sign-On domain Migrate workloads between your on-premises data center and VMware Cloud on Dell EMC Differentiate who is responsible for which maintenance tasks that correspond either to administrators or to VMware Recognize how VMware add-on solutions support VMware Cloud on Dell SDDC This course, equivalent to 4 days of training, provides you with the knowledge, skills, and tools for deploying and managing a VMware Cloud? on Dell EMC infrastructure. You explore the common use cases of the VMware Cloud on Dell EMC infrastructure that allows you to modernize, protect, and scale applications based on VMware vSphere© as well as workloads with compliance and residency requirements. In this course, you are introduced to various rapid and easy migration options for workloads based on vSphere to VMware Cloud on Dell EMC. In addition, you are presented with an overview of VMware HCX an application mobility platform that allows you to migrate your workloads between on-premises VMware vSphere and VMware Cloud on Dell EMC SDDC. Course Introduction Course Introduction Introduction to VMware Cloud on Dell EMC Choosing VMware Cloud on Dell EMC Management and operational structure Ordering and Site preparation Getting started with VMware Cloud on Dell EMC Ordering VMware Cloud on Dell EMC SDDC vSphere permissions on VMware Cloud on Dell EMC Billing and pricing on VMware Cloud services SDDC management Accessing vCenter Server SDDC Host management SDDC cluster management Creating Virtual Machines in SDDC Networking and Security SDDC Networks Networking and Security Options Storage Storage in VMware Cloud on Dell EMC Working with On-Premises vSphere Hybrid linked mode Migration Solutions for VMware Cloud on Dell EMC VM Migration with VMware HCX Maintaining and Troubleshooting Maintenance, Support, and Common Troubleshooting Steps Working with other VMware Products VMware vRealize Log Insight Cloud VMware Horizon with VMware Cloud on Dell EMC VMware vRealize Automation Using VMware vRealize Operations with VMware Cloud on Dell EMC Using VMware vRealize Network Insight? with VMware Cloud on Dell EMC Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware Cloud on Dell: Deploy and Manage 2022 training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware Cloud on Dell: Deploy and Manage 2022 course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

VMware Cloud on Dell: Deploy and Manage 2022
Delivered OnlineFlexible Dates
Price on Enquiry

CCSA PlusCCSE Check Point Certified Security Administrator and Expert Bundle

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is recommended for technical professionals who support, install, deploy or administer Check Point products. This course is recommended for technical professionals who perform advanced deployment configurations of Check Point products. Overview CCSA Know how to perform periodic administrator tasks. Describe the basic functions of the Gaia operating system. Recognize SmartConsole features, functions, and tools. Understand how SmartConsole is used by administrators to give user access. Learn how Check Point security solutions and products work and how they protect networks. Understand licensing and contract requirements for Check Point security products. Describe the essential elements of a Security Policy. Understand the Check Point policy layer concept. Understand how to enable the Application Control and URL Filtering software. Blades to block access to various applications. Describe how to configure manual and automatic NAT. Identify tools designed to monitor data, determine threats and recognize opportunities for performance improvements. Describe different Check Point Threat Prevention solutions for network attacks. Articulate how the Intrusion Prevention System is configured, maintained and tuned. Understand the Infinity Threat Prevention system. Knowledge about Check Point's IoT Protect. CCSE Provide an overview of the upgrade service and options available. Explain how to perform management upgrade and migration. Articulate the process using CPUSE features. Articulate the purpose and function of Management High Availability. Explain Primary vs Secondary, Active vs Standby and Synchronization. Explain disaster recovery steps in case the primary management server becomes unavailable. Provide overview of Central Deployment in SmartConsole. Articulate an understanding of Security Gateway cluster upgrade methods. Explain about Multi Version Cluster (MVC) upgrades. Discuss Gaia Commands and how they are used. Explain the main processes on s and s. Describe how to work with scripts and SmartTasks to configure automatic actions. Explain the Management Data Plane Separation (MDPS) Explain kernel operations and traffic flow Articulate Dynamic and Updatable Objects in Security Gateways Explain the policy installation flow and files used. Describe the use of policy installation history. Explain concurrent and accelerated install policy. Describe an overview of APIs and ways to use and authenticate. Explain how to make changes in GAIA and management configuration. Explain how to install policy using API. Explain how the SecureXL acceleration technology enhances and optimizes Security Gateway performance. Learn basic concepts and develop skills necessary to administer IT security fundamental tasks. CCSA Outline Configure the Security Management Server. Use the WebUI to run the First Time Wizard. Install the Smart Console. Install the Alpha Gateway using the network detailed in the course topology. Demonstrate how the Security Management Server and Gateway communicate. Test SIC Status. Create multiple administrators and apply different roles and permissions for simultaneous administration. Validate existing licenses for products installed on the network. Create and configure host, network and group objects. Create a simplified Security Policy. Demonstrate how to use Security Zones in policy. Demonstrate how to share a layer between Security Polices. Configure Network Address Translation for server and network objects. Enable Identity Awareness. Deploy user access roles for more granular control of the security Policy. Generate network Traffic and use traffic visibility tools to monitor the data. Use SmartConsole and SmartView Monitor to view status, alerts, and block suspicious traffic. CCSE Outline Prepare for a Security Management Server Upgrade Upgrade the Security Management Server Deploy a Secondary Security Management Server Configure a Distributed Log Server Upgrade a Security Gateway from SmartConsole Work with the Command Line Use Scripts and SmartTasks Configure Dynamic Objects Monitor Traffic Verify Policy Installation and Status Work with Gaia and Management APIs Work with Acceleration Features Configure a Locally Managed Site to Site VPN Configure a Site to Site VPN with an Interoperable Device Configure Remote Access VPN Configure Mobile Access VPN Configure a High Availability Cluster Work with ClusterXL Configure Policy Compliance Deploy SmartEvent

CCSA PlusCCSE Check Point Certified Security Administrator and Expert Bundle
Delivered OnlineFlexible Dates
Price on Enquiry

Getting Started with Programming, OO and Basic Java for Non-Developers (TT2000)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This basic course is intended for anyone who is new to software development and wants, or needs, to gain an understanding of the fundamentals of coding and basics of Java and object-oriented programming concepts. Attendees might include: Technically-minded attendees who want or who want to begin the process of becoming an OO application developer Technical team members from non-development roles, re-skilling to move into software and application development roles within an organization Recent college graduates looking to apply their college experience to programming skills in a professional environment, or perhaps needing to learn the best practices and standards for programming within their new organization Technical managers tasked with overseeing programming teams, or development projects, where basic coding knowledge and exposure will be useful in project oversight or communications needs Overview This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in basic coding with Java, coupling the most current, effective techniques with the soundest industry practices. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will learn: The steps involved in the creation and deployment of a computer program What OO programming is and what the advantages of OO are in today's world To work with objects, classes, and OO implementations The basic concepts of OO such as encapsulation, inheritance, polymorphism, and abstraction The basic constructs that all programming languages share The basic Java constructs supporting processing as well as the OO orientation How to use Java exception handling About and how to use classes, inheritance and polymorphism About use collections, generics, autoboxing, and enumerations How to take advantage of the Java tooling that is available with the programming environment being used in the class Getting Started with Programming, OO and Java Basics for Non-Developers is a skills-focused, hands-on coding course that teaches students the fundamentals of programming object oriented (OO) applications with Java to a basic level, using sound coding skills and best practices for OO development. This course is presented in a way that enables interested students to embrace the fundamentals of coding as well as an introduction to Java, in a gentle paced environment that focuses on coding basics.Students are introduced to the application development cycle, structure of programs, and specific language syntax. The course introduces important algorithmic constructs, string and character manipulation, dynamic memory allocation, standard I/O, and fundamental object-oriented programming concepts. The course explains the use of inheritance and polymorphism early on so the students can practice extensively in the hands-on labs. Structured programming techniques and error handling are emphasized. The course includes the processing of command line arguments and environment variables, so students will be able to write flexible, user-friendly programs. Students will leave this course armed with the required skills to begin their journey as a Java programmer using modern coding skills and technologies. Introduction to Computer Programming Introduction to Programming Programming Tools Programming Fundamentals Thinking About Objects Program Basics Programming Constructs Java: A First Look The Java Platform Using the JDK The Eclipse Paradigm Writing a Simple Class OO Concepts Object-Oriented Programming Inheritance, Abstraction, and Polymorphism Getting Started with Java Adding Methods to the Class Language Statements Using Strings Specializing in a Subclass Essential Java Programming Fields and Variables Using Arrays Java Packages and Visibility Advanced Java Programming Inheritance and Polymorphism Interfaces and Abstract Classes Exceptions Java Developer's Toolbox Utility Classes Enumerations and Static Imports Formatting Strings Collections and Generics Introduction to Generics Collections

Getting Started with Programming, OO and Basic Java for Non-Developers (TT2000)
Delivered OnlineFlexible Dates
Price on Enquiry

CV722 IBM DB2 11 for z/OS Application Programming Workshop

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for application programmers who need to write embedded SQL COBOL or PL/I programs in either a DB2 9 or DB2 10 for z/OS environment. Overview Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution. CV720G;CF82G;DB2 Concepts Identify DB2 family products Explain DB2 workstation component functions Identify DB2 objects Identify the key differences between static SQL and other application alternatives for accessing DB2 data Program Structure I Embed INSERT, UPDATE, DELETE and single-row SELECT statements in application programs Effectively communicate with DB2 when processing NULL values and determining success of statement execution Demonstrate use of DB2 coding aids Code CONNECT statements within an application program Identify connection types and impacts on a unit of work Program for the Call Attach Facility (CAF) Program Preparation Identify the additional steps necessary to prepare a program that contains embedded SQL for execution Describe the functions of the DB2 PRECOMPILE and BIND processes Describe factors relevant to the BIND process, including RUNSTATS positioning, package status, parameters, and authorization requirements Program Structure II Use DECLARE, OPEN, FETCH, and CLOSE CURSOR statements to handle select criteria that may return multiple rows in application programs Issue positioned UPDATE and DELETE statements Identify how scrollable cursors can be used Recovery and Locking Concepts Define a unit of recovery Identify the basic locking strategies used by DB2 Dynamic SQL Introduction Describe the difference between static and dynamic SQL List the types of dynamic statements Code dynamic SQL in a program Managing Test Data Identify methods to insert data into a table Use the LOAD or IMPORT utility Identify the purpose of the RUNSTATS utility Identify the purpose of the REORG utility Performance Considerations Use programming techniques that enhance DB2 application performance by following general guidelines, using indexable predicates, and avoiding unnecessary sorts Identify the access paths available to DB2 List common causes of deadlocks and avoid such causes when possible Use the EXPLAIN tools as aids to develop applications that emphasize performance Additional course details: Nexus Humans CV722 IBM DB2 11 for z/OS Application Programming Workshop training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CV722 IBM DB2 11 for z/OS Application Programming Workshop course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

CV722 IBM DB2 11 for z/OS Application Programming Workshop
Delivered OnlineFlexible Dates
Price on Enquiry