45123 Courses

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.

Course Overview: Are you ready to embark on a rewarding journey into Health and Social Care Level 2? This comprehensive course is your gateway to understanding this vital field's fundamental principles, policies, and ethics. With modules designed to equip you with essential knowledge, this course is tailored to provide the academic foundation you need to excel in health and social care.In Module 1, participants will be introduced to health and social care, laying a solid foundation for the subsequent modules. Later on, Module 2 accentuates the importance of effective communication, while Modules 3 and 4 unravel the rights, responsibilities, and roles of those in health and social care. By the time learners progress to Modules 5 through 14, they will traverse a broad spectrum of topics, from the principles and policies governing this field to the strategic management of service delivery.Enrol now and take the first step toward a rewarding healthcare and social services career. Key Features of the Course: Obtain a CPD certificate upon successful completion, enhancing your professional credentials. Benefit from our 24/7 Learning Assistance, ensuring you receive support whenever needed throughout your learning journey. Who is This Course For? This Counselling Course at Health and Social Care Level 2 is designed for individuals who are passionate about making a difference in people's lives. Whether you are already working in the health and social care sector or aspiring to enter this rewarding field, this course provides a solid foundation in counselling skills. What You Will Learn: In our Counselling Course at Health and Social Care Level 2, you will gain a deep understanding of various crucial aspects of the field. The course covers 14 modules and explores communication, rights and responsibilities, caregiver roles, promoting equality and diversity, legal and ethical aspects, safeguarding vulnerable individuals, health and safety obligations, healthcare economics, strategic marketing, managing finance, and service delivery. Through this comprehensive curriculum, you will develop effective communication techniques, ensuring you can establish trust and rapport with individuals seeking support. You will also become well-versed in healthcare's legal and ethical frameworks, enabling you to navigate complex situations and uphold professional standards. Moreover, the course emphasises the importance of empathy, compassion, and maintaining professional boundaries in caregiving roles. You will learn strategies to promote equality and diversity, creating inclusive environments that respect individual differences. Additionally, the course equips you with the skills to safeguard vulnerable individuals, identify signs of abuse or neglect, and maintain secure healthcare settings. You will also gain insights into healthcare economics, knowledge of funding models, resource allocation, and cost-effectiveness. Why Enrol in This Course: Enrolling in this Counselling Course offers several compelling advantages. Firstly, it is a top-reviewed course, highly praised by learners who have benefited from its comprehensive content. Moreover, this course has been recently updated to incorporate industry trends and best practices, ensuring you receive the most relevant and up-to-date information. Requirements: No prior experience or qualifications are necessary to enrol in this Counselling Course. It is open to anyone interested in health and social care and wanting to help others.. Career Path: Upon completing this course, you will be well-prepared for various health and social care career paths. Some of the potential professions include: Counsellor - £30,000 per year Mental Health Support Worker - £24,000 per year Care Coordinator - £28,000 per year Social Worker - £32,000 per year Rehabilitation Worker - £26,000 per year Health Promotion Specialist - £35,000 per year Supportive Housing Manager - £30,000 per year Certification: Upon completing the Counselling Course at Health and Social Care Level 2, you will receive a CPD certificate, officially recognising your achievement and enhancing your professional credibility. Enrol in our Counselling Course today and embark on a fulfilling journey to positively impact the lives of needy individuals while expanding your career horizons in the health and social care sector. Course Curriculum 1 sections • 14 lectures • 07:15:00 total length •Module 1. Introduction to Health and Social Care: 00:16:00 •Module 2: Communication and its Relevance: 00:41:00 •Module 3: Rights and Responsibilities as a Health and Social Care Worker: 00:39:00 •Module 4: Role as A Caregiver and Healthcare Professional: 00:23:00 •Module 5: Working in Health and Social Care; Promoting Equality, Diversity and Rights: 00:46:00 •Module 6: Important Principles and Policies in Health and Social Care Work: 00:20:00 •Module 7: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1: 00:50:00 •Module 8: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2: 00:48:00 •Module 9: Safeguarding Vulnerable Individuals: 00:49:00 •Module 10: Health and Safety Responsibilities: 00:51:00 •Module 11 : The Economics of Healthcare: 00:11:00 •Module 12: Strategic Marketing for Health and Social Care: 00:09:00 •Module 13: Managing Finance in Health and Social Care: 00:21:00 •Module 14: Managing Service Delivery in Health and Social Care: 00:11:00

Overview This comprehensive course on Forest Schooling will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Forest Schooling  comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enroll in this course today to fast-track your career ladder How will I get my certificate? 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 Forest Schooling. It is available to all students, of all academic backgrounds Requirements Our Forest Schooling is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smart phones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillet will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 10 lectures • 01:30:00 total length •Forest Schooling: 00:06:00 •Benefits of Forest Schooling: 00:10:00 •Forest School Programme: 00:14:00 •Learning Activities in Forest School: 00:10:00 •Playing Activities in Forest School: 00:10:00 •Survival Activities in Forest School: 00:12:00 •Child Development: 00:12:00 •Eco-Friendly Forest Schooling: 00:08:00 •Safety and Risk Management: 00:08:00 •Assignment - Forest Schooling: 00:00:00

Overview This comprehensive course on Floristry Academy Diploma will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Floristry Academy Diploma comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? 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 Floristry Academy Diploma. It is available to all students, of all academic backgrounds. Requirements Our Floristry Academy Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 15 lectures • 09:02:00 total length •Introduction to the Course: 00:02:00 •Introduction to Floristry: 00:46:00 •Services Provided by Florists: 00:21:00 •Flowers and Plants: 01:08:00 •Flower Care and Treatment: 00:36:00 •Choosing Popular Flowers and Fillers: 00:45:00 •Elements and Principles of Design: 00:54:00 •How to Make Floral Arrangements: 01:04:00 •Making Bouquet, Corsage, Fruit Basket & Basket Garden: 00:35:00 •Wedding Floristry: 00:10:00 •Making Funeral Flower Arrangements: 00:31:00 •Beautiful Floral Designs: 00:45:00 •Getting a Job in the Floristry Industry: 00:30:00 •Starting Your Own Floristry Business: 00:54:00 •Conclusion to the Course: 00:01:00

Overview This comprehensive course on Functional Skills Maths Level 2 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Functional Skills Maths Level 2 comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? 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 Functional Skills Maths Level 2. It is available to all students, of all academic backgrounds. Requirements Our Functional Skills Maths Level 2 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 15 lectures • 02:40:00 total length •Module 1: Numbers and Negative Numbers: 00:07:00 •Module 2: Multiples Factors: 00:06:00 •Module 3: Fractions and Power: 00:16:00 •Module 4: Percentages: 00:08:00 •Module 5: Expressions: 00:09:00 •Module 6: Decimals: 00:08:00 •Module 7: Ratio and Proportion: 00:10:00 •Module 8: Exponents and Radicals: 00:11:00 •Module 9: Graphs: 00:11:00 •Module 10: The Profit and Loss: 00:07:00 •Module 11: Perimeter and Area: 00:10:00 •Module 12: Averages: 00:09:00 •Module 13: Probability: 00:08:00 •Mock Exam - Functional Skills Maths Level 2: 00:20:00 •Final Exam - Functional Skills Maths Level 2: 00:20:00

Overview This comprehensive course on Cryptocurrency and Bitcoin Margin Trading on Binance Guide will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Cryptocurrency and Bitcoin Margin Trading on Binance Guide comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? 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 Cryptocurrency and Bitcoin Margin Trading on Binance Guide. It is available to all students, of all academic backgrounds. Requirements Our Cryptocurrency and Bitcoin Margin Trading on Binance Guide is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 9 lectures • 01:48:00 total length •Follow This Steps For Effective Learning!: 00:32:00 •How Pro`S Use Margin versus How Losers (Losing Traders) Use It in Trading: 00:13:00 •Advantages of Margin Trading On Binance Platform: 00:06:00 •Margin Trading Fees on Binance: 00:04:00 •Types of Orders on Binance Trading Platform: 00:16:00 •How to Open Short and Long Margin Positions: 00:19:00 •Real Live Trade: 00:03:00 •Risk Management System: 00:15:00 •Assignment - Cryptocurrency and Bitcoin Margin Trading on Binance Guide: 00:00:00

Overview This comprehensive course on Epilepsy Awareness will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Epilepsy Awareness comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? 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 Epilepsy Awareness. It is available to all students, of all academic backgrounds. Requirements Our Epilepsy Awareness is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 10 lectures • 03:25:00 total length •Introduction to Epilepsy: 00:22:00 •Causes of Epilepsy: 00:25:00 •What Is Seizure?: 00:21:00 •Treatment of Seizures: 00:24:00 •Diagnosis of Epilepsy: 00:26:00 •Management of Epilepsy: 00:23:00 •Pharmacological Managementof Epilepsy: 00:19:00 •How Behavioural Changes Affect Epilepsy?: 00:21:00 •Risk Management and Support Needs: 00:24:00 •Assignment - Epilepsy Awareness: 00:00:00

Overview This comprehensive course on Intermediate Economics Level 3 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Intermediate Economics Level 3 comes with accredited certification which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? 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 Intermediate Economics Level 3. It is available to all students, of all academic backgrounds. Requirements Our Intermediate Economics Level 3 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 16 sections • 16 lectures • 06:00:00 total length •An Introduction to Economics: 00:26:00 •The Market System and the Circular Flow Model: 00:20:00 •Supply, Demand and Prices: 00:32:00 •Prices: 00:17:00 •Elasticity: 00:34:00 •Market Failures: 00:24:00 •Production and Costs: 00:25:00 •Market Structure Perfect Competition vs Monopoly: 00:25:00 •Money, Banking and the Financial System: 00:28:00 •Measuring GDP and Economic Growth: 00:27:00 •Unemployment: 00:17:00 •Inflation: 00:20:00 •Income Distribution and Poverty: 00:14:00 •International Finance: 00:15:00 •Fiscal Policy: 00:36:00 •Assignment - Intermediate Economics Level 3: 00:00:00

Overview Enrol in our Food Hygiene and Safety Level 3 and 4 today and build the necessary skills, knowledge and experience to transform your career. The Food Hygiene and Safety Level 3 and 4 could enhance your continuing professional development thus propelling you more towards your dream job. This Food Hygiene and Safety Level 3 and 4 could be your key, if you are interested in a long term career in the field of Food Hygiene and Safety Level 3 and 4. This Food Hygiene and Safety Level 3 and 4 course consists of a number of easy to digest, in-depth modules which are designed to provide you with detailed knowledge on Food Hygiene and Safety Level 3 and 4. This Food Hygiene and Safety Level 3 and 4 aims to accompany you through your journey to help you become a master of Food Hygiene and Safety Level 3 and 4. Learn through a mixture of interactive lessons and online study materials. How will I get my certificate? 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 Food Hygiene and Safety Level 3 and 4. It is available to all students, of all academic backgrounds. Requirements Our Food Hygiene and Safety Level 3 and 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 11 lectures • 11:11:00 total length •Module 1: Food Safety Legislation: 01:24:00 •Module 2: Microbiological Hazards: 02:15:00 •Module 3: Physical, Chemical, and Allergenic Hazards: 01:00:00 •Module 4: Food Storage: 01:21:00 •Module 5: Food Preparation: 00:57:00 •Module 6: Personal Hygiene: 01:00:00 •Module 7: Food Premises Design and Cleaning Schedules: 02:00:00 •Module 8: Further Information: 00:18:00 •Module 9: Reopening and Adapting Your Food Business During COVID-19: 00:16:00 •Mock Exam - Food Hygiene and Safety Level 3 and 4: 00:20:00 •Final Exam - Food Hygiene and Safety Level 3 and 4: 00:20:00

Overview Learn how to recognise and treat Mental Health disorders and conditions in clients of all ages and types. This comprehensive course will train you in Child Psychotherapy, Counselling, and much more, allowing you to progress your career in Healthcare and Social Work. The Child Psychology course presents an extensive range of online learning modules which will teach you how to ensure the Mental wellbeing of an individual is supported and diagnose the causes for challenging behaviour or uncharacteristic mood swings. You will become familiar with the effects of issues such as Depression and Anxiety, and bring much-needed support to those that need it. ** 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. ** How will I get my certificate? 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 in Child Psychology diploma. It is available to all students, of all academic backgrounds. Requirements Our Child Psychology Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 14 lectures • 06:08:00 total length •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 •Assignment - Psychology Advanced Diploma: 00:00:00