2357 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) 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 Introduction to SQL Programming Basics (TTSQL002) 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.

Overview This course provides all the principles, knowledge, and skills that you will need to absorb, to carry out exemplary Social Care. The Care Certificate in Child Development, Psychology and Protection course has been written with the help of industry professionals and lays out all of the EU/UK standards for delivering care to the community. You will be taught how to safeguard the vulnerable, provide appropriate nutrition, respect privacy and dignity, support those with challenges and disabilities, and ensure hygiene and cleanliness. Understand your responsibilities in the Social Sector today. Take this course anywhere and at any time. Don't let your lifestyle limit your learning or your potential. ** Completing this course does not imply that you are qualified to work as a Practitioner Psychologist. If you are seeking a course that fits the HCPC's standards, please contact the HCPC or the RCSLT. ** Method of Assessment To enhance your knowledge regarding the course and to assess your learning, you need to complete the assignment questions provided at the end of the course, which you can complete either during or after the course.  After submitting the assignment, our expert tutor will assess your assignment and will give you feedback on your performance. Certification You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Care Certificate in Child Development, Psychology and Protection. It is available to all students, of all academic backgrounds. Requirements There are no specific prerequisites to enrol in this Care Certificate in Child Development, Psychology and Protection course . Anyone and everyone can take this course. The Care Certificate in Child Development, Psychology and Protection is fully accessible from any internet-enabled smart device. So, you can study from the comfort of your home! All you need is a passion for learning, literacy, and to be over the age of 16. Course Curriculum 3 sections • 32 lectures • 15:21:00 total length •Module 1: Introduction to Childcare and Nutrition: 00:25:00 •Module 2: Understanding Child Development: 00:26:00 •Module 3: Keeping Children Healthy & Safe: 00:33:00 •Module 4: Day-to-day Child Caring: 00:20:00 •Module 5: Macronutrients: 00:20:00 •Module 6: Micronutrients: 00:20:00 •Module 7: Child Nutrition Requirements: 01:03:00 •Module 8: Child Nutritional Problems & Physical Activity: 00:25:00 •Module 9: Children with Special Needs: 00:41:00 •Module 10: Child Abuse & Protection: 00:25:00 •Module 11: Early Years Provision: 00:21:00 •Module 01: Introduction to Child Psychology: 00:28:00 •Module 02: Attachment and Relationship Building in Childhood: 00:31:00 •Module 03: Impacts of Separation and Loss on Attachment: 00:27:00 •Module 04: Factors That Influence Development: 00:36:00 •Module 05: Cognitive Development: 00:25:00 •Module 06: Social and Emotional Development: 00:43:00 •Module 07: Personality and Intellectual Development of Children: 00:36:00 •Module 08: Stages of Language Development: 00:27:00 •Module 09: Understanding Moral Development: 00:18:00 •Module 10: Play, Imagination, and Creativity: 00:26:00 •Module 11: Problems of Infancy: 00:20:00 •Module 12: Problems of Childhood: 00:23:00 •Module 13: Problems of Adolescence: 00:28:00 •Module 01: Introduction to Safeguarding: 00:21:00 •Module 02: Laws and Guidance: 00:43:00 •Module 03: Child Abuse: 00:49:00 •Module 04: Child Sexual Exploitation: 00:38:00 •Module 05: Responding to Disclosure and Reporting: 00:25:00 •Module 06: Risks and Risk Assessment: 00:16:00 •Module 07: Things to Do after Referral: 00:24:00 •Module 08: Record Keeping: 00:18:00

Bring Your Data To Life | Designed by Industry Specialist | Level 7 | QLS Endorsed Diploma | Certificate Included

Duration 5 Days 30 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Process Architects, Business Process Owners/Team Leads/Power Users, Program/Project Managers, and Users. Overview Participants learn about the fundamental elements of materials management.Participants understand usage of the procurement processes for stock material, consumable materials, and services, the basic functions from purchasing, inventory management, invoice verification, service entry, and materials planning.Topic-specific exercises in the SAP system give participants the opportunity to gain first-hand practical experience of the above processes. This course will give students the fundamental knowledge and a comprehensive overview of the processes in procurement in SAP. After attending this class, students will understand the major business processes and functions in materials management. Procurement Processes Defining Processes and Organizational Levels in Procurement Maintaining Purchase Orders Posting Goods Receipts Entering Invoices Master Data Maintaining Vendor Master Records Maintaining Material Master Records Using Entry Aids for Master Data Maintenance Performing Mass Maintenance Stock Material Procurement Applying Conditions in Purchasing Handling Requests for Quotations and Quotation Processes Creating Purchase Orders with Reference Maintaining Purchasing Info Records Analyzing Material Valuation Posting Goods Receipts for Purchase Orders Entering Invoices with Reference to Purchase Orders Consumable Material Procurement Purchasing Consumable Materials Creating Purchase Requisitions Creating Purchase Orders with Reference to Purchase Requisitions Entering Valuated and Non-Valuated Goods Receipts Creating Blanket Purchase Orders External Services Procurement Maintaining Master Data for External Services Ordering Services Creating Service Entries and Verifying Invoices Automated Procurement Maintaining Data for Material Requirements Planning (MRP) Maintaining Contracts and Source Lists Performing Procurement Processes Automatically Reporting and Analytics Using Standard Reports Performing Standard Analyses in the Logistics Information System Introduction to the SAP Buyer Role Assessing the Buyer Role Self-Service Procurement Examining the Functions of Self-Service Procurement

Limited Time Offer | 11-in-1 Bundle | CPD QS Certified | 145 CPD Points | Free Hardcopy + PDF Certificate + Exam | Customer Support | Lifetime Access | Enrol Today

Launch your journalism career with our comprehensive accredited online diploma program. Learn investigative techniques, storytelling, ethics, media law, and more from experienced industry experts. Gain real-world skills to work as a reporter, editor, producer, or communications professional.

All you wish to learn and know about project communication when you start your career as a project manager. Or just when you are involved in projects and want better interactions. A 6-module course with a workbook covering topics such as impactful presentations, negotiating, team collaboration and more. Also includes a one-hour session with me to set up your next step. Your best investment to deliver your projects more smoothly!

The goal of this Level 3 Diploma in Caregiving course is to enhance your current level of caring abilities. It's an opportunity to further your career as a caregiver and put your abilities to good use. The practical, ethical, and legal aspects of providing care are covered in this online course. This includes helping family members and clients with meal preparation, personal hygiene, transportation, and other emotional and physical needs. Participants will gain knowledge on how to care for those in their care, manage dementia, and lessen the effects of aging, illnesses, and injuries. Key Features: CPD Certified Free Certificate Free CPD Certified PDF Certificate Developed by Specialist Lifetime Access Leering Outcomes: Use the core ideas and techniques of caregiving to provide competent assistance to patients or family members. Understand the moral and legal ramifications of providing care. Communicate with people with disabilities and their families in an effective manner. Talk to your clients about the effects of age, illness, and injury. Provide comfort and assistance to customers along with their families. The first part of the course introduces you to the duties and responsibilities of caretakers. You'll learn about the complex legal and ethical issues of caregiving, as well as how to communicate with people who have disabilities and develop your body mechanics, stress management, and organisational skills. You will also understand the necessity of keeping track of, reporting, and recording the health of individuals in your care, as well as the role that cultural competency and awareness play in promoting a respectful work environment. Caregiving Diploma Level 3 Course Curriculum Module 01: Introduction to Health and Social Care Module 02: Introduction to Food Safety and the Law Module 03: Food Poisoning and Control Measures Module 04: Working in Health and Social Care; Promoting Equality, Diversity and Rights Module 05: Rights and Responsibilities as a Health and Social Care Worker Module 06: Role as A Caregiver and Healthcare Professional Module 07: Safeguarding Vulnerable Individuals Module 08: An Introduction to Safeguarding of Vulnerable Adults Module 09: Safeguarding Vulnerable Adults Policy, Roles and Responsibilities Module 10: Understanding the Importance of Communication in Care Module 11: Consenting for Someone Else Module 12: Best Interest Decision Making Module 13: Managing Service Delivery in Health and Social Care Module 14: Important Principles and Policies in Health and Social Care Work Module 15: Medical Jargon and Terminology Module 16: Information Technology in Health Care Why Should you take this Level 3 Caregiving Diploma? Understand fundamentals of health and social care principles and practices. Learn food safety laws and food poisoning control measures. Promote equality, diversity, and rights in health and social care. Identify safeguarding roles, responsibilities, and policies for vulnerable individuals. Master effective communication and decision-making in care settings. Familiarise with medical terminology and IT applications in healthcare. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring health and social care workers. Individuals new to caregiving roles. Those interested in safeguarding vulnerable adults. Care assistants seeking knowledge in food safety. Healthcare workers focusing on effective communication. Requirements no formal qualifications are required Career path Care Assistant Support Worker Home Care Worker Health and Social Care Worker Caregiver Healthcare Assistant Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Pastoral Safeguarding Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now As a pastoral worker, your responsibility is to protect the welfare of those in your care. Our Pastoral Safeguarding Course bundle is designed to equip you with the knowledge and tools to safeguard children, young people, and vulnerable adults. With 14 CPD-certified courses, this bundle covers a wide range of topics from child neglect and domestic violence to mental health and counselling. Our Pastoral Safeguarding bundle is designed to provide you with a comprehensive understanding of neuropsychology and educational psychology to better understand the development of children. You'll learn about safeguarding children and vulnerable adults, domestic violence and abuse awareness, anti-social behaviour, and child neglect. Additionally, we offer courses in mental health, learning disability awareness, and counselling to help you support those in your care. Our Pastoral Safeguarding bundle also cover topics such as parenting skills, foster care training, and play therapy to provide you with a well-rounded education. To recognise your achievements, we provide a Hardcopy + PDF Certificate + SID - Worth £160, that you can showcase to potential employers and peers. With our Pastoral Safeguarding Course bundle, you can enhance your skills and knowledge to create a safer and more inclusive environment for those in your care. So enrol today and take the first step in protecting the welfare of your community. This Pastoral Safeguarding Bundle Consists of the following Premium courses: Course 01: Pastoral Safeguarding Course 02: Neuropsychology and Development of Children Course 03: Educational Psychology and Development Course 04: Domestic Violence and Abuse Awareness - Level 2 Course 05: Level 3 Mental Health and Adolescent Course Course 06: Anti Social Behaviour Course 07: Child Neglect Awareness Certificate Course Course 08: Parenting Skills Training Course 09: Learning Disability Awareness Course 10: Counselling Children & Supporting Their Wellbeing Course 11: Cognitive behavioural therapy Course 12: Juices, Smoothies, Healthy Eating, Vegan, Nutrition with Certificate Course 13: Foster Care Training Course Course 14: Play Therapy Learning Outcomes of Pastoral Safeguarding: Understand the development of children and young people from a neuropsychology and educational psychology perspective Develop skills and knowledge to safeguard children, young people, and vulnerable adults Gain awareness and understanding of domestic violence and abuse Enhance knowledge of mental health and counselling to support those in your care Understand anti-social behaviour and how to address it Develop skills to provide effective parenting and foster care Gain awareness of learning disabilities and how to support those with them Understand the principles and techniques of play therapy So enrol now in this Pastoral Safeguarding course to Pastoral Safeguarding Curriculum of the Pastoral Safeguarding Bundle Course 01: Pastoral Safeguarding Module 01: Introduction to Safeguarding Module 02: Laws and Guidance Module 03: Child Abuse Module 04: Child Sexual Exploitation and Abuses Module 05: Risks and Risk Assessment Module 06: Responding to Disclosure and Reporting@ Module 07: Things to Do after Referral Module 08: Record Keeping Module 09: School Administration Module 10: Types of Schools in the UK Module 11: Workplace Development Module 12: Safeguarding Students Module 13: Child Development Module 14: Managing School Premises Module 15: Managing for Health and Safety Module 16: Risk Assessment and Common Risks Module 17: Accidents and Ill Health at Work Module 18: Electrical, Fire and Gas Safety =========>>>>> And 13 More Courses <<<<<========= Key features of this Pastoral Safeguarding bundle: This Pastoral Safeguarding bundle is CPD QS Accredited Learn from anywhere in the world Lifetime access Our Pastoral Safeguarding is entirely online 24/7 Learner support So, Enrol in this Pastoral Safeguarding bundle course now to advance your career! CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Pastoral Safeguarding bundle is ideal for: Pastoral workers who want to enhance their knowledge and skills in safeguarding and supporting those in their care Individuals who are interested in a career in pastoral care, social work, counselling, or education Anyone who wants to develop their understanding of child development, mental health, and learning disabilities Individuals who want to make a positive difference in the lives of children, young people, and vulnerable adults Requirements Our Pastoral Safeguarding Bundle is your path that might lead to a rewarding career. You will gain in-demand mastery in this program. Career path Upon successful completion of this Pastoral Safeguarding bundle, you may explore the following career pathways: Social Worker (£25k-£40k) School Counsellor (£25k-£40k) Youth Worker (£18k-£28k) Family Support Worker (£18k-£28k) Foster Carer (£10k-£30k) Educational Psychologist (£35k-£50k) Certificates CPDQS Accredited e-Certificate Digital certificate - Included CPDQS Accredited Hard-Copy Certificate Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Pastoral Safeguarding) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

Overview The Detective: Private Investigator Diploma course offers comprehensive training in private investigation, criminology, and forensic psychology. It covers essential modules on the introduction to private investigation, the skills of a successful investigator, criminal psychology, the investigation process, interviews and interrogation techniques, required equipment, records research, surveillance, marital investigation, and establishing a private investigation business. Learning Outcomes: Gain a thorough understanding of the principles and practices of private investigation. Develop essential skills for conducting successful investigations, including interviews, interrogation, and statement taking. Understand criminal psychology and its relevance to investigative work. Learn about the process of private investigation and the various stages involved. Acquire knowledge of the necessary equipment and tools used in private investigation. Master techniques for conducting research and accessing public records to gather relevant information. Learn the art of surveillance and counter-surveillance to gather evidence discreetly. Develop specialized skills for conducting marital investigations and handling sensitive cases. Explore miscellaneous investigation areas and their unique challenges. Gain insights into establishing and managing a private investigation business effectively. Why buy this Detective: Private Investigator Diploma? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Detective: Private Investigator Diploma there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Aspiring private investigators seeking foundational and advanced knowledge in various investigation techniques. Law enforcement personnel aiming to enhance their investigative skills beyond standard police training. Legal professionals desiring a deeper understanding of investigation processes to aid their legal practice. Journalists and researchers interested in developing investigative skills for in-depth reporting and information gathering. Individuals passionate about understanding criminal psychology and applying this knowledge in real-world scenarios. Prerequisites This Detective: Private Investigator Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Detective: Private Investigator Diploma was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Private Investigator: £25,000 - £50,000 Per Annum Forensic Psychologist (applying criminal psychology): £31,000 - £60,000 Per Annum Legal Investigator (for law firms): £28,000 - £55,000 Per Annum Corporate Investigator (for businesses): £30,000 - £70,000 Per Annum Fraud Investigator (financial sector): £32,000 - £60,000 Per Annum Criminal Intelligence Analyst: £27,000 - £45,000 Per Annum Course Curriculum Detective: Private Investigator Diploma Introduction to Private Investigation 00:15:00 Skills of a Successful Investigator 00:10:00 Understanding Criminal Psychology 00:10:00 Private Investigation Process 00:15:00 Interviews, Interrogation and Taking Statements 00:15:00 Required Equipment for Private Investigation 00:10:00 Records Research and Public Records Search 00:10:00 Surveillance and Counter-Surveillance 00:10:00 Marital Investigation 00:10:00 Miscellaneous Investigations 00:15:00 Miscellaneous Investigations 00:10:00 Assignment Assignment - Detective: Private Investigator Diploma 00:00:00