19225 Basic courses

Duration 1 Days 6 CPD hours This course is intended for Individuals with basic computer skills, familiar with concepts related to database structure and terminology, and who want to use SQL to query databases. Overview Upon successful completion of this course, students will be able to: - connect to the SQL Server database and execute a simple query. - include a search condition in a simple query. - use various functions to perform calculations on data. - organize data obtained from a query before it is displayed on-screen. - retrieve data from tables. - format an output, save a result, and generate a report. In this course, students will compose SQL queries to retrieve desired information from a database. 1 - Executing a Simple Query Connect to the SQL Database Query a Database Save a Query Modify a Query Execute a Saved Query 2 - Performing a Conditional Search Search Using a Simple Condition Compare Column Values Search Using Multiple Conditions Search for a Range of Values and Null Values Retrieve Data Based on Patterns 3 - Working with Functions Perform Date Calculations Calculate Data Using Aggregate Functions Manipulate String Values 4 - Organizing Data Sort Data Rank Data Group Data Filter Grouped Data Summarize Grouped Data Use PIVOT and UNPIVOT Operators 5 - Retrieving Data from Tables Combine Results of Two Queries Compare the Results of Two Queries Retrieve Data by Joining Tables Check for Unmatched Records Retrieve Information from a Single Table Using Joins 6 - Presenting Query Results Save the Query Result Generate an XML Report

Duration 1 Days 6 CPD hours This course is intended for Students should have basic computer skills, SQL skills, and be familiar with concepts related to database structure and terminology. Overview Upon successful completion of this course, students will be able to: - Use subqueries to generate query output. - Manipulate table data by inserting, updating, and deleting records in a table. - Manipulate the table structure. - Create views, manipulate data through views, modify the view structure, and drop views. - Create indices on table columns and drop inefficient indices. - Mark the beginning of a transaction, create a savepoint within a transaction, rollback a transaction, and commit a transaction. In this course, students will work with advanced queries to manipulate and index tables. Students will also create transactions so that you can choose to save or cancel data entry process. Prerequisites SQL Querying Fundamentals - Part 1 1 - Using Subqueries to Perform Advanced Querying Search Based on Unknown Values Compare a Value with Unknown Values Search Based on the Existence of Records Generate Output Using Correlated Subqueries Filter Grouped Data Within Subqueries Perform Multiple-Level Subqueries 2 - Manipulating Table Data Insert Data Modify and Delete Data 3 - Manipulating the Table Structure Create a Simple Table Create a Table with Constraints Add or Drop Table Columns Add or Drop Constraints Modify the Column Definition Back Up Tables Delete Tables 4 - Working with Views Create a View Manipulate Data in Views Create Aliases Modify and Drop Views 5 - Indexing Data Create Indices Drop Indices 6 - Managing Transactions Create Transactions Commit Transactions

A48 Piling Rig - Bored above 20 Tonnes

A47 Piling Rig - Bored below 20 Tonnes

CPCS A46 Piling Rig - Driven above 20 Tonnes

CPCS A45 Piling Rig - Driven Below 20 Tonnes

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before The UK healthcare system relies heavily on skilled laboratory technicians. Did you know that the UK employs over 230,000 laboratory technicians across various scientific fields? If you're looking for a stimulating career in science, this Level 5 Diploma in Microbiology Lab Technician bundle equips you with the foundational knowledge and specialised skills to excel in this rewarding field. This extensive Lab Technician bundle provides a strong foundation in various scientific disciplines. You'll gain a thorough understanding of microbiology, the study of microorganisms, and its applications in labs. Learn key analytical techniques, delve into the fascinating world of genetics and biotechnology, and explore the building blocks of life through basic biology and human anatomy & physiology. With a single payment, you will gain access to Microbiology Lab Technician course, including 10 premium courses, a QLS Endorsed Hardcopy certificate (for the title course) and 11 PDF certificates for Absolutely free. This Microbiology Lab Technician Bundle Package includes: Main Course: Diploma in Microbiology Lab Technician at QLS Level 5 10 Additional CPDQS Accredited Premium Courses - Course 01: Lab Analyst Training Course 02: Biotechnology Course 03: Genetics Course 04: Basic Biology Course 05: Biomedical Science Course 06: Diploma in Basic Chemistry Level 3 Course 07: Diploma in Water Chemistry Course Course 08: Zoology Course 09: Anatomy and Physiology of the Human Body Course 10: Phlebotomy Technician Training Whether you aspire to work in a hospital lab, research facility, or environmental testing firm, this bundle provides the skills and qualifications employers seek. Enrol today and take the first step towards a rewarding career in laboratory science! Learning Outcomes Of Lab Technician Apply foundational knowledge of biology and chemistry to laboratory procedures. Utilise specialised equipment and perform a variety of laboratory tests. Analyse and interpret data generated from laboratory experiments. Adhere to strict safety protocols and maintain a sterile laboratory environment. Prepare and maintain detailed laboratory records. Communicate effectively with scientists and other healthcare professionals. Why Choose Us? Get a Free QLS Endorsed Certificate upon completion of Lab Technician Get a free student ID card with Lab Technician Training program (£10 postal charge will be applicable for international delivery) The Lab Technician is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the Lab Technician course materials The Lab Technician comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Main Course: Diploma in Microbiology Lab Technician at QLS Level 5 Module 01: Introduction To Microbiology Module 02: Bacteriology Module 03: Viruses Module 04: DNA Viruses Module 05: Positive-Strand RNA Viruses Module 06: Negative-Strand RNA Viruses Module 07: Parasites Module 08: Fungi Module 09: Antifungal Medicines Module 10: Immunology Module 11: Antibiotics Module 12: Sexually Transmitted Diseases Course 01: Lab Analyst Training Module 01: Introduction to the Course Module 02: Medical Laboratory Services Module 03: Laboratory Equipments (Part-01) Module 04: Laboratory Equipments (Part-02) Module 05: Microscope and How to Use It Module 06: Solutions Used in Clinical/Medical Laboratory Module 07: Sterilisation, Disinfection and Decontamination Module 08: Basic Haematology Module 09: Basic Haemostasis (Coagulation) Module 10: Basic Immunology and Immunohematology Module 11: Urinalysis Module 12: Basic Clinical Chemistry Module 13: Basic Clinical Microbiology Module 14: Basic Parasitology Module 15: Laboratory Accidents and Safety Module 16: Quality Assurance Course 02: Biotechnology Module 1 - Introduction To Biotechnology Module 2- Biotechnology In The Realm Of History Module 3- Molecular And Cellular Biology Module 4 - Biotechnology Versus Molecular Biology Module 5- Genetic Engineering Module 6- Biotechnology In Health Sector Module 7- Industrial Biotechnology Module 8- Biotechnology In A Business Perspective =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The Title Course: Previously it was £119) CPD 285 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Science enthusiasts Career changers Lab assistants Medical school hopefuls Requirements You will not need any prior background or expertise to enrol in this Microbiology Lab Technician bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Lab technician Research assistant Medical technologist Quality control specialist Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Diploma in Microbiology Lab Technician at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Project Management for Non-Project Managers (Virtual) Individuals who are involved in projects (commissioning, supporting, sponsoring, etc.) may often be unfamiliar with project management. A basic understanding of project management is essential for non-project managers, who are critical stakeholders contributing to project success. This awareness course usesA Guide to the Project Management Body of Knowledge (PMBOK® Guide) and other sources to introduce you to project management vocabulary, concepts, and techniques. It also provides insights into the realities of being a project manager, and opportunities to explore how you can positively impact projects in your own role. Getting Started Introductions Course structure Course goals and objectives Foundation Concepts Project management overview Strategic value of project management Defining project success Project life-cycle models and governance Project roles and responsibilities Project Initiating and Planning Initiating the project Defining project requirements and scope Developing the project schedule and budget Project Risk Management, Executing, Monitoring, and Closing Understanding, evaluating, and adjusting for risk Honoring the baseline and executing the project Monitoring and controlling the project Closing the project Project Interpersonal Processes Project communication Project team development Conflict management

10 QLS Endorsed Courses for Dog Trainer | 10 QLS Endorsed Certificates Included | Lifetime Access

***24 Hour Limited Time Flash Sale*** Pregnancy Care, Diet and Nutrition with Child Development and Care Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Welcome to the empowering world of the "Pregnancy Care, Diet and Nutrition with Child Development and Care" bundle. It's a curated selection of eight exclusive courses designed to equip you with the knowledge to navigate the beautiful journey of parenthood and provide outstanding child care. Our bundle includes three esteemed QLS-endorsed courses, namely, Pregnancy Care, Diet and Nutrition, and Child Development and Care. These courses offer rich content that will help you understand the nuances of pregnancy, the importance of diet and nutrition during this phase, and the critical aspects of child development and care. The hardcopy certificates accompanying these courses serve as credible testimonials of your acquired knowledge. In addition, we present five relevant CPD QS accredited courses, each providing valuable insights into various aspects of childcare and health. From Maternity Care Assistant Course to Basic Life Support, these courses expand your understanding of the diverse aspects of pregnancy care, public health, and child development. Experience the richness of theoretical knowledge brought to you by our carefully constructed courses. Dabble in the complexity of Diet and Nutrition, delve deep into the intricacies of Pregnancy Care, or unravel the marvels of Child Development and Care, as you transform your understanding into an asset. Key Features of the Pregnancy Care, Diet and Nutrition with Child Development and Care Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our [Course_Title] bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Pregnancy Care QLS Course 02: Diet and Nutrition QLS Course 03: Child Development and Care 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Maternity Care Assistant Course Course 02: Initial Training of Community Health Agents Course 03: Nanny Care Worker Course 04: Public Health Course 05: Basic Life Support In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our [Course_Title] courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Understand the nuances of pregnancy care and the role of diet and nutrition. Gain a comprehensive overview of child development and care. Acquire knowledge about the duties of a maternity care assistant. Learn about the responsibilities of community health agents and nanny care workers. Familiarise yourself with the essential concepts of public health. Learn the basics of life support systems. Develop a solid foundation for a career in maternity and child care. Embark on a journey through the complexities and wonders of pregnancy, diet, nutrition, and child care with our "Pregnancy Care, Diet and Nutrition with Child Development and Care" bundle. Comprising of eight distinctive courses, this bundle empowers you with extensive theoretical knowledge, preparing you for a fulfilling career in the field of maternity and child care. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals planning to embark on parenthood. Professionals in the health sector who want to enhance their knowledge. Students pursuing a career in child care or public health. Anyone interested in understanding the key aspects of pregnancy, diet, nutrition, and child development. Career path Maternity Care Assistant: £15,000 - £20,000 Community Health Agent: £18,000 - £23,000 Nanny Care Worker: £19,000 - £25,000 Public Health Worker: £25,000 - £30,000 Child Development Specialist: £22,000 - £27,000 Basic Life Support Technician: £17,000 - £22,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included