1490 Courses in Liverpool delivered Live Online

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals 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 Oracle 12c SQL Fundamentals 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.

Duration 0.5 Days 3 CPD hours This course is intended for This course is designed for students who have experience using the Windows 10 operating system and need to start using the Windows 11 operating system. Overview In this course, you will use the new and updated features of Windows 11. You will: Navigate the Windows environment. Use apps available in Windows 11. Manage available apps. Configure Windows 11 settings. As an experienced Windows© 10 user, when you are ready to move to Windows 11, you might like some guidance in using the new and updated features. This course will help you identify and use those features efficiently and effectively. Navigating the Windows 11 Environment Topic A: Log in to Windows 11 Topic B: Use the Start Menu Topic C: Use the Taskbar Using Apps Topic A: Use Built-In Apps Topic B: Use the Updated File Explorer Managing Apps Topic A: Use Virtual Desktops Topic B: Obtain Apps from the Microsoft Store Configuring Windows 11 Settings Topic A: Use the Configuration Apps Topic B: Configure Accessibility Features

The Positive Psychology course to explore core values, shape a profound vision and create an actionable plan for your best life.

Are you interested in enrolling on an Online (Distance) Learning Degree at Arts University Plymouth, but curious about how virtually attending an Arts University works? If so, join us online for our Free 3-Session Online Learning Taster Course. An introduction to our January-start degrees. This course has been designed to give you a taste of what it is like to study with us virtually, as well as giving you tailored support for your university application. You will get a virtual art university experience, and a chance to meet some of the lecturers for the subjects you are interested in studying.

Tuition centres play a crucial role in adapting their teaching methods to cater to individual learning styles. By understanding each student’s unique needs and preferences.

Overview This 2-day programme covers the latest techniques used for fixed income attribution. This hands-on course enables participants to get a practical working experience of fixed income attribution, from planning to implementation and analysis. After completing the course you will have developed the skills to: Understand how attribution works and the value it adds to the investment process Interpret attribution reports from commercial systems Assess the strengths and weaknesses of commercially available attribution software Make informed decisions about the build vs. buy decision Present results in terms accessible to all parts of the business Who the course is for Performance analysts Fund and portfolio managers Investment officers Fixed Income professionals (marketing/sales) Auditors and compliance Quants and IT developers Course Content To learn more about the day by day course content please click here To learn more about schedule, pricing & delivery options, book a meeting with a course specialist now

This one-day workshop is designed to give participants an understanding of the fundamentals of Microsoft Word and its commands, with quick ways to enter text, control formatting and edit paragraphs. This course will help participants: Create, manage and save documents, files and folders Create paragraph lists, bulleted and numbered paragraphs Edit, modify and format paragraphs Create and format tables Use shortcuts to navigate documents Format the layout of documents Manage page headers and footers Insert and managing pictures and diagrams within a document Learn time saving tips and tricks to obtain a professional finish to documents Use printing options 1 Creating documents Getting help Creating and saving documents Accessing recently used documents Managing files and folders 2 Entering and editing text Inserting and editing paragraph text Cutting, copying and pasting text Using tool tips to manage content Applying and removing text formatting Correcting spelling and grammar 3 Creating paragraph lists Creating bulleted paragraphs Creating numbered paragraphs Managing bulleted and numbered lists 4 Modifying paragraphs Changing paragraph alignment Indenting a paragraph Adding borders and shading to paragraphs Formatting paragraphs using styles 5 Navigating documents Using shortcuts for navigating documents Using 'Go To' to navigate documents Finding and replacing text Changing to read view 6 Document layout Inserting page breaks Changing page orientation Adjusting page margins Adding borders to pages 7 Page headers and footers Inserting page headers and footers Using header and footer commands Inserting page numbers Using different first page 8 Inserting pictures and diagrams Inserting pictures from your computer Inserting online pictures Flowing text around a picture Changing a picture Inserting SmartArt diagrams Entering text into SmartArt 9 Inserting tables Using tabs to create tables Resizing and repositioning tables Inserting and deleting rows and columns Using a table's commands Changing a tables text direction Formatting tables 10 Printing documents Previewing and printing documents Using the printing tools Printing parts of a document

This course will explore ways to support and enhance the quality of care provided to the individual approaching end of life, their families and their carers.

Artificial Intelligence (AI) is the most disruptive technology since the internet came onto the scene. AI is transforming every aspect of how we manage projects from developing a business case, to planning the work, managing risk, and tracking performance. Because the technology and market are moving so fast, it can be difficult to know how to start using AI on projects. Generative AI for Project Management will engage you with diverse Generative AI tools to start, plan, and manage either your own project or a generic case study. We will embrace a tool agnostic approach to adopting, integrating, and scaling Generative AI without compromising data or trust. You will have hands-on practice utilizing AI tools to optimize your time and your outcomes. You will be accessing a variety of AI tools requiring you to register for a free account. A computer is required for all traditional classroom deliveries. None At the end of this program, you will be able to: Define essential terms and concepts related to artificial intelligence (AI) Illustrate how prompts facilitate interaction with Generative AI Recognize the capabilities of Large Language Models Craft prompts to develop project origination documents Create prompts to assist in planning a project Develop user stories with Generative AI Analyze project performance using Generative AI Identify the limitations of Generative AI Identify the risks associated with using Generative AI Articulate the need for governance and ethics when establishing an AI program in an organization Course Overview Getting Started Foundation Concepts Understanding essential terms and concepts related to AI Exploring various Generative AI Models Understanding Prompts Creating Prompts for Project Startup Prompts for starting a project Prompts for planning a project Best Practices for prompt engineering Creating Prompts for Managing Projects Creating agile user stories Measuring project performance Analyzing a schedule Using Generative AI Responsibly Limitations of AI Models Establishing an AI governance framework Future trends and next steps Summary and Next Steps

First Aid for Mental Health | RQF Level 2 First Aid for Mental Health qualification is designed to provide individuals with the knowledge and skills to support individuals experiencing mental health issues. This course aims to increase awareness of mental health, reduce stigma, and promote early intervention and support. The course covers various aspects of mental health, including common mental health conditions, signs and symptoms, and the impact of mental health issues on individuals and society. Participants will learn about different approaches to mental health, including self-help, accessing support, and signposting to appropriate services. The content of the RQF Level 2 First Aid for Mental Health course typically includes: Understanding Mental Health: An overview of mental health, including common mental health conditions such as depression, anxiety disorders, and stress. Participants will learn about the prevalence of mental health issues and their impact on individuals and society. Recognizing Mental Health Conditions: Understanding the signs, symptoms, and potential triggers of various mental health conditions. Participants will learn to identify early warning signs and risk factors for mental health issues. Promoting Positive Mental Health: Strategies and techniques for promoting positive mental health and well-being. This may include stress management techniques, self-care practices, and maintaining good mental health hygiene. Providing Mental Health First Aid: Techniques for providing initial support to individuals experiencing mental health crises or deteriorating mental health. Participants will learn how to offer non-judgmental listening, empathy, and reassurance to individuals in distress. Signposting and Referral: Understanding the importance of signposting individuals to appropriate professional help and support services. Participants will learn about local resources, helplines, and mental health organizations that can provide ongoing assistance. Self-Help and Resilience: Exploring self-help strategies and resilience-building techniques that individuals can use to manage their mental health and well-being. This may include relaxation techniques, mindfulness exercises, and developing healthy coping mechanisms. The course may be delivered through a combination of classroom-based instruction, group discussions, case studies, and practical activities. All our trainers are qualified and experienced in mental health education and support. Upon successful completion of the RQF Level 2 First Aid for Mental Health course, participants will receive a qualification that demonstrates their understanding of mental health issues and their ability to provide initial support to individuals experiencing mental health challenges. It's important to note that this course is not intended to replace professional mental health services or provide participants with the qualifications to diagnose or treat mental health conditions. It aims to equip individuals with the knowledge and skills to provide initial support and signposting to appropriate services. Suitability - Who should attend? First Aid for Mental Health course is suitable for a wide range of individuals who are interested in gaining knowledge and skills to provide initial support to individuals experiencing mental health challenges. Here are some examples of who the course may be suitable for: General Public: The course is open to anyone who wants to increase their understanding of mental health and learn how to support others effectively. It is suitable for individuals who want to develop their knowledge and skills in mental health first aid for personal reasons or to support friends, family members, or colleagues. Workplace Settings: The course is particularly relevant for individuals working in various professional settings, including but not limited to workplaces, schools, colleges, universities, community organizations, and voluntary sectors. It can benefit employees, supervisors, managers, and HR professionals who want to create a mentally healthy and supportive work environment. Healthcare Professionals: Healthcare professionals, such as nurses, doctors, paramedics, and allied health professionals, can benefit from the course to complement their existing medical knowledge and skills. The course equips them with additional tools and strategies to effectively respond to the mental health needs of their patients. Customer Service and Support Roles: Individuals working in customer service, hospitality, retail, or other client-facing roles can benefit from the course to enhance their ability to provide empathetic and supportive interactions with customers or clients who may be experiencing mental health challenges. Community Leaders and Volunteers: Community leaders, volunteers, and individuals involved in community organizations, charities, or support groups can gain valuable knowledge and skills from the course. It enables them to offer informed support and signposting to individuals within their communities who may be in need. It's important to note that the course does not require any previous qualifications or specific professional background in mental health. Participants should have a willingness to learn, an open mind, and a compassionate attitude toward individuals experiencing mental health challenges. However, it's also important to recognize that the course does not provide participants with the qualifications to diagnose or treat mental health conditions. Instead, it focuses on providing initial support, promoting awareness, and signposting individuals to appropriate professional help and services. Before enrolling in the course, individuals should consider their personal interest, commitment to learning about mental health, and their motivation to support others in this area. It is also recommended to check any specific requirements or prerequisites set by the training provider to ensure suitability for participation. Overall, the RQF Level 2 First Aid for Mental Health course is suitable for individuals from various backgrounds who want to develop their understanding of mental health and gain practical skills to provide initial support and signposting to individuals in need. Outcome / Qualification etc. Upon successful completion of the First Aid for Mental Health course, participants can expect to achieve the following outcomes: Increased Awareness and Understanding: Participants will develop a greater awareness and understanding of mental health, including common mental health conditions, their signs and symptoms, and the impact they can have on individuals and society. They will gain knowledge about the prevalence of mental health issues and the importance of promoting positive mental health. Enhanced Ability to Recognize Mental Health Conditions: Participants will acquire the skills to recognize signs and symptoms of various mental health conditions. They will be better equipped to identify early warning signs and risk factors, enabling them to provide timely support and intervention. Improved Mental Health First Aid Skills: Participants will learn techniques and strategies for providing initial support to individuals experiencing mental health crises or deteriorating mental health. They will develop skills in active listening, non-judgmental communication, and empathy, allowing them to offer appropriate assistance and reassurance to individuals in distress. Knowledge of Signposting and Referral: Participants will gain an understanding of the importance of signposting individuals to appropriate professional help and support services. They will learn about local resources, helplines, and mental health organizations, enabling them to provide accurate information and guide individuals to the appropriate sources of assistance. Enhanced Self-Help and Resilience Strategies: Participants will learn self-help strategies and resilience-building techniques that individuals can use to manage their own mental health and well-being. They will acquire practical tools for stress management, relaxation, and developing healthy coping mechanisms. Confidence in Supporting Others: The course aims to enhance participants' confidence in providing support to individuals experiencing mental health challenges. Through knowledge, skills, and practical exercises, participants will feel more prepared to respond appropriately and effectively in a compassionate and understanding manner. Qualification: Upon successful completion of the course, participants will receive an RQF Level 2 qualification in First Aid for Mental Health. This qualification demonstrates their understanding of mental health issues and their ability to provide initial support to individuals in need. It's important to note that the RQF Level 2 First Aid for Mental Health qualification is not intended to replace professional mental health services or provide participants with the qualifications to diagnose or treat mental health conditions. Instead, it aims to equip individuals with the necessary knowledge and skills to offer initial support and signposting, fostering a supportive and empathetic environment for individuals experiencing mental health challenges. Training Course Content Module 1 Introduction Module 2 What is first aid for mental health? Module 3 Identifying mental health conditions Module 4 Providing advice and starting a conversation Module 5 Stress Module 6 Mental health conditions Module 7 Drugs and alcohol Module 8 First aid action plan for mental health - including practical assessment Module 9 Mental health in the workplace Module 10 Assessment and course closure Course delivery details Classroom-Based or Virtual Instruction: The course may be delivered through traditional classroom-based instruction, where participants attend in-person training sessions led by a qualified instructor. The instructor will cover the course content, facilitate discussions, and provide guidance on practical activities. Blended Learning: Some training providers offer a blended learning approach, combining both online and face-to-face components. Participants may complete certain modules or topics online through interactive e-learning platforms or virtual classrooms. This allows for self-paced learning and flexibility before attending practical sessions or assessments in person. Interactive Discussions: The course often includes interactive discussions where participants can share their experiences, ask questions, and engage in conversations related to mental health. This encourages active participation, promotes peer learning, and provides opportunities for clarification and deeper understanding of the course content. Case Studies and Scenario-Based Activities: To enhance practical application, trainers may present case studies or scenarios related to mental health issues. Participants can work in groups or individually to analyse the situations, identify appropriate responses, and discuss possible strategies for providing support. Practical Skills Demonstrations: Trainers may demonstrate practical skills and techniques for providing mental health first aid, such as active listening, empathetic communication, and crisis intervention. Participants will have the opportunity to observe and learn from these demonstrations before practicing the skills themselves. Role-Playing and Simulations: Role-playing exercises and simulations may be used to simulate real-life scenarios and provide participants with hands-on practice in responding to mental health crises. This allows them to develop their skills in a safe and controlled environment and receive feedback from the trainer and peers. Assessment and Certification: Participants will undergo assessments to demonstrate their understanding of the course content and their ability to apply their knowledge and skills in practical scenarios. Successful completion of the assessments leads to the awarding of the RQF Level 2 First Aid for Mental Health qualification. It's important to note that the specific delivery methods and approaches may vary depending on the training provider, course duration, and the resources available. Participants should check with the training provider for detailed information on the course delivery format and any specific requirements or prerequisites for participation. Overall, the aim of the course delivery is to create an engaging and interactive learning environment that allows participants to gain the necessary knowledge, skills, and confidence to provide effective support to individuals experiencing mental health challenges. Why choose Madeleys First Aid Plus Founded in 2021 after Louise left 30 years in the NHS as an Advanced practitioner in A&E/ITU, had spent 1.5 years in Covid ITU Won FSB Best start-up business in the West Midlands in May 2023 Now trained 100's of delegates in Physical and Mental Health First Aid