1633 Courses delivered Online

Duration 3 Days 18 CPD hours This course is intended for This is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems 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. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. Introduction: Quick Tools Review Introduction to SQL and its development environments Using SQL*PLUS Using SQL Developer Using the SQL SELECT Statement Capabilities of the SELECT statement Arithmetic expressions and NULL values in the SELECT statement Column aliases Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword Use of the DESCRIBE command Restricting and Sorting Data Limiting the Rows Rules of precedence for operators in an expression Substitution Variables Using the DEFINE and VERIFY command Single-Row Functions Describe the differences between single row and multiple row functions Manipulate strings with character function in the SELECT and WHERE clauses Manipulate numbers with the ROUND, TRUNC and MOD functions Perform arithmetic with date data Manipulate dates with the date functions Conversion Functions and Expressions Describe implicit and explicit data type conversion Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions Nest multiple functions Apply the NVL, NULLIF, and COALESCE functions to data Decode/Case Statements Using the Group Functions and Aggregated Data Group Functions Creating Groups of Data Having Clause Cube/Rollup Clause SQL Joins and Join Types Introduction to JOINS Types of Joins Natural join Self-join Non equijoins OUTER join Using Subqueries Introduction to Subqueries Single Row Subqueries Multiple Row Subqueries Using the SET Operators Set Operators UNION and UNION ALL operator INTERSECT operator MINUS operator Matching the SELECT statements Using Data Manipulation Language (DML) statements Data Manipulation Language Database Transactions Insert Update Delete Merge Using Data Definition Language (DDL) Data Definition Language Create Alter Drop Data Dictionary Views Introduction to Data Dictionary Describe the Data Dictionary Structure Using the Data Dictionary views Querying the Data Dictionary Views Dynamic Performance Views Creating Sequences, Synonyms, Indexes Creating sequences Creating synonyms Creating indexes Index Types Creating Views Creating Views Altering Views Replacing Views Managing Schema Objects Managing constraints Creating and using temporary tables Creating and using external tables Retrieving Data Using Subqueries Retrieving Data by Using a Subquery as Source Working with Multiple-Column subqueries Correlated Subqueries Non-Correlated Subqueries Using Subqueries to Manipulate Data Using the Check Option Subqueries in Updates and Deletes In-line Views Data Control Language (DCL) System privileges Creating a role Object privileges Revoking object privileges Manipulating Data Overview of the Explicit Default Feature Using multitable INSERTs Using the MERGE statement Tracking Changes in Data

Have you ever wondered how human history has evolved? Do you want to know how historians and archaeologists find out the past? Or want to be an archaeologist yourself? Then this course is perfect for you. Learn the techniques of archaeology and how they work from the course Archaeology. This comprehensive archaeology course will give you a clear understanding of the functions of archaeology and their reasons. This comprehensive Archaeology course is developed by Industry experts with the utmost care and thorough research. All the topics are broken down into simply digestible bite-sized modules, allowing our students to understand each lesson quickly. You will receive an e-certificate immediately after completing the Archaeology course, which will help you find a job in the sector and will boost your CV. Enroll in this Archaeology course from Course Gate if you want to learn more about this skill and become competent in this area. After completing the Archaeology course , you will build up accurate knowledge and skills with proper confidence to enrich yourself. These skills will brighten up your career in the relevant job market. Please note: Our Archaeology course only gives you the theoretical knowledge to excel in this field. This course doesn't entitle you to practise as a professional in this specific field. Learning Objectives Familiarise with the basic principles of archaeology Understand various archaeological laws and rules Be able to understand the values of objects of different times Learn how to extract information from any historical or archaeological objects Understand the importance of archaeology Learn about the roles and responsibilities of an archaeologist Who is this Course for? This course is designed for any individual who is looking to learn more about Archaeology. It is also applicable for the ones who are looking to start their career in this field and want to acquire the required knowledge and skills. Apart from just principles and rules, this course has a lot of inter-related skills that will help you attain your goals. Entry Requirement Anyone interested in learning more about this subject should take this Archaeology course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path Upon successful completion of the Archaeology course, learners will have a good understanding of all the techniques and all the required skills to build a career in the Archaeology sector. Some of the relevant career pathways include: Archaeologists Anthropologists Researches Cultural Analysts Human Resource Professionals Course Curriculum Module 01: Introduction to Archaeology Introduction to Archaeology 00:16:00 Module 02: Different Types of Archaeology Different Types of Archaeology 00:16:00 Module 03: Archaeological Time Period Archaeological Time Periods 00:19:00 Module 04: Archaeological Site Surveying and Features Archaeological Site Surveying and Features 00:14:00 Module 05: Pre-Excavation Research: Dimensions of Excavation and Safety Measures Pre-Excavation Research: Dimensions of Excavation and Safety Measures 00:14:00 Module 06: Methods of Excavation Methods of Excavation 00:12:00 Module 07: The Process of Excavation and Documentation The Process of Excavation and Documentation 00:20:00 Module 08: Post-Excavation Analysis Post-Excavation Analysis 00:16:00 Module 09: Understanding Dating in Archaeology Understanding Dating in Archaeology 00:18:00 Module 10: Archaeological Interpretation Archaeological Interpretation 00:14:00 Module 11: Conservation: Protecting the World's Heritage Conservation Protecting the World's Heritage 00:13:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Embark on a transformative journey with our 'Post-Traumatic Stress Disorder (PTSD) Counselling' course, a beacon of hope and healing for those touched by trauma. This course opens a window into understanding PTSD, not just as a clinical term but as a deeply personal experience that impacts lives profoundly. Your journey begins with an introduction that lays the groundwork for comprehending the complexities of trauma and its aftermath. As you navigate through the curriculum, you will gain insights into the nuances of PTSD, equipping you with the knowledge to understand and empathise with those affected. Moving forward, the course delves into integrating therapeutic techniques such as Cognitive Behavioural Therapy (CBT), Dialectical Behaviour Therapy (DBT), and Acceptance and Commitment Therapy (ACT) into both personal and professional practices. This holistic approach empowers you to manage anxiety and PTSD symptoms effectively. The course guides you through overcoming avoidance behaviours and handling difficult trauma-related thoughts, providing strategies to cope with intrusive memories, flashbacks, and nightmares. As you reach the concluding sections, you'll learn not just to survive but to thrive post-trauma, looking ahead with newfound strength and resilience. This course is more than an educational experience; it's a journey towards empowerment and recovery. Learning Outcomes Understand the fundamental concepts of trauma and PTSD. Learn to integrate CBT, DBT, and ACT techniques for managing PTSD. Develop strategies to handle anxiety and avoidance behaviours. Gain skills in coping with trauma-related memories and thoughts. Acquire techniques to thrive post-trauma and look towards a positive future. Why choose this Post-Traumatic Stress Disorder (PTSD) Counselling course? 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. Who is this Post-Traumatic Stress Disorder (PTSD) Counselling course for? Mental health professionals seeking specialised knowledge in PTSD. Individuals personally affected by trauma and PTSD. Caregivers and support workers of those with PTSD. Emergency service personnel dealing with traumatic events. Anyone interested in understanding and supporting PTSD recovery. Career path PTSD Counsellor - £25,000 to £40,000 Clinical Psychologist - £31,000 to £51,000 Mental Health Nurse - £24,000 to £35,000 Psychotherapist - £26,000 to £48,000 Support Worker - £18,000 to £28,000 Crisis Intervention Specialist - £22,000 to £37,000 Prerequisites This Post-Traumatic Stress Disorder (PTSD) Counselling does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Post-Traumatic Stress Disorder (PTSD) Counselling 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Introduction 00:04:00 The approach of the course 00:03:00 Understanding Trauma & PTSD Section Overview 00:01:00 What Is Trauma? 00:09:00 What Is PTSD? Diagnosis of PTSD 00:10:00 How Are Traumatic Memories Processed? 00:09:00 Physical and Health Issues Associated with Trauma 00:08:00 Thinking about Coping with PTSD & Trauma 00:06:00 Integrating CBT, DBT, ACT Techniques into Your Life Integrating CBT, DBT, ACT Overview 00:01:00 What is Cognitive Behavioral Therapy (CBT)? 00:03:00 ABC Model - Thought, Emotions & Behavior 00:04:00 Understanding Feedback Loops 00:04:00 Behavioral Coping 00:02:00 Exposure Therapy for PTSD & Trauma 00:07:00 Stress Inoculation Training (SIT) for PTSD & Trauma 00:03:00 Cognitive Processing Therapy (CPT) PTSD & Trauma 00:03:00 What is Dialectical Behavior Therapy (DBT)? 00:08:00 What is Acceptance and Commitment Therapy (ACT)? 00:03:00 ACT in Action! 6 Core Processes 00:12:00 Common Elements of CBT, DBT & ACT 00:05:00 Managing Your Anxiety & PTSD Building a Strong Foundation: Breathing 00:06:00 Abdominal Breathing for Anxiety 00:05:00 PMR Progressive Muscle Relaxation a CBT Technique for Anxiety & PTSD 00:07:00 Relaxation without Tension a CBT Technique for Anxiety & PTSD 00:02:00 Cue Controlled Relaxation a CBT Technique for Anxiety & PTSD 00:02:00 Using Your Mind to Relax and Develop Awareness 00:03:00 Decreasing the Power of Negative Thoughts 00:06:00 Section Conclusion 00:03:00 Stop Avoiding and Start Living Again Section Introduction 00:02:00 Self-help: Effects of PTSD on Goals and Values 00:15:00 Self-help: Creating a Change 00:10:00 Self-help: Facing Feared Situation 00:10:00 Self-help: Everyday Mindfulness Exercise 00:05:00 Self-help: Connecting with Others 00:10:00 Self-help: Emotion Diary Cards 00:05:00 Self-help: Identifying Emotions 00:05:00 Decreasing PTSD Symptoms through Writing 00:05:00 Handling Difficult Thoughts of Trauma 8 Limited Thinking Patterns from CBT 00:01:00 Filtering 00:02:00 Polarized Thinking 00:02:00 Overgeneralization 00:02:00 Mind Reading 00:02:00 Catastrophizing 00:01:00 Magnifying 00:02:00 Personalization 00:01:00 Shoulds 00:02:00 Composing Balanced Alternative Thoughts 00:08:00 Coping with Memories, Flashbacks, Nightmares, and Intrusions Focusing on Your Thoughts 00:07:00 Invalidating Thoughts 00:06:00 Mindfulness and Grounding 00:05:00 Imagery Rehearsal for Nightmares 00:02:00 Developing Wise Mind 00:04:00 Surviving and Thriving as You Look Ahead Do You Need Professional Help? 00:04:00 Conclusion Do You Need Therapist? 00:04:00 Conclusion 00:02:00 Resources Resource - Treating Post Traumatic Stress Disorder 00:00:00 Assignment Assignment - Post-Traumatic Stress Disorder (PTSD) Counselling 00:00:00

Duration 5 Days 30 CPD hours This course is intended for Operators, administrators, and architects for VMware Horizon should enroll in this course. These individuals are responsible for the creation, maintenance, and or delivery of remote and virtual desktop services. Additional duties can include the implementation, support, and administration of an organization's end-user computing infrastructure. Overview By the end of the course, you should be able to meet the following objectives: Assess the business and application requirements of an environment Analyze design choices and design an EUC infrastructure architecture that addresses the needs of the environment Design an EUC architecture that addresses the needs of the organization and follows VMware best practices Document a design that can be implemented Design a comprehensive VMware EUC solution This five-day course presents a methodology for designing a VMware end-user computing (EUC) solution. The design methodology includes recommendations for the types of information and data that must be gathered and analyzed to make sound design decisions for the client systems, the desktop options, the VMware vSphere© infrastructure, VMware Horizon©, VMware Horizon© Cloud ServiceTM, VMware Workspace ONE© UEM, VMware Workspace ONE© AccessTM, VMware NSX-TTM, and VMware Unified Access GatewayTM. VMware best practices are presented for each phase of the design process. In this course, you apply your new knowledge by working with other participants to design a VMware EUC solution for a real-world project. Course Introduction Introductions and course logistics Course objectives VMWare EUC Design Methodology Recognize the characteristics of a good design. Identify the phases of VMware EUC Design Methodology Presenting Solutions to Executive Management Identify behaviors that can affect team performance negatively List common mistakes when working in a team Describe how to tailor a presentation to the company?s values, and stakeholders? backgrounds and roles List questions you should ask to identify how to address a problem a client is trying to solve Infrastructure Assessment and Services Definition Define customer business objective Define a use case for your virtual desktop and application infrastructure Convert customer requirements to use-case attributes Horizon Architecture and Components Determine the components required for a Horizon on-premises or Horizon Cloud deployment Implement the design considerations and recommendations for various Horizon components Analyze the use-case scenarios for various the Horizon deployment options Component Design: Horizon Pods Design a single-site Horizon desktop block and pod configuration for a given use case Design Cloud Pod Architecture for multisite pool access Design Control Plane Services Architecture for multisite pool access Component Design: App Volumes and Dynamic Environment Manager Identify the functionalities of the components in App Volumes Logical Architecture Implement the recommended practices when designing an application delivery mechanism using App Volumes Component Design: Workspace ONE Map the Horizon desktop building block and the Horizon management building block to VMware vSphere. Identify factors and design decisions that determine the sizing for ESXi hosts Workspace ONE & Horizon Infrastructure Design Design the environment resources required to support a Workspace ONE and Horizon deployment Identify factors and design decisions that determine the sizing for ESXi host Discuss the factors that determine the sizing for shared storage Identify the design decisions related to bandwidth utilization Discuss the implications of using load balancing and traffic management Identify factors and design decisions that determine the sizing of the Azure pods Design Integration and Delivery List the platform components that needs to be integrated along with their dependent services. Integrate Workspace ONE and Horizon platform components. Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware End User Computing: Design training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the VMware End User Computing: Design 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.

Ideal for beginners, the Complete Java Developer Course: From Beginner to Master is designed to get you coding in Java as quickly and confidently as possible. You will learn all the theory behind the code, while also building some exciting portfolio projects such as Mad Libs clone, tic-tac-toe, and more.

'Prevent Duty' Approved Online Training

Dignity and Privacy Approved Online Training

Duty of Care Approved Online Training

Welcome to this course on SwiftUI animations iOS 16. This is a fun-to-code course with multiple hands-on projects geared toward various skill levels. Each project is marked 'Easy', 'Intermediate', or 'Advanced', allowing you to start coding projects according to your skill level and gradually move on to the higher levels when ready.

Duration 2.5 Days 15 CPD hours This course is intended for This course is intended for those with a basic understanding of Tableau who want to pursue mastery of the advanced features. Overview The goal of this course is to present essential Tableau concepts and its advanced functionalities to help better prepare and analyze data. This course will use Tableau Hyper, Tableau Prep and more. Getting Up to Speed ? a Review of the Basics Connecting Tableau to your data Connecting to Tableau Server Connecting to saved data sources Measure Names and Measure Values Three essential Tableau concepts Exporting data to other devices Summary All About Data ? Getting Your Data Ready Data mining and knowledge discovery process models CRISP?DM All About Data ? Joins, Blends, and Data Structures All About Data - Joins, Blends, and Data Structures Introduction to joins Introduction to complex joins Exercise: observing join culling Introduction to join calculations Introduction to spatial joins Introduction to unions Understanding data blending Order of operations No dimensions from a secondary source Introduction to scaffolding Introduction to data structures Exercise: adjusting the data structure for different questions Summary Table Calculations Table Calculations A definition and two questions Introduction to functions Directional and non-directional table calculations Application of functions Summary Level of Detail Calculations Level of Detail Calculations Building playgrounds Playground I: FIXED and EXCLUDE Playground II: INCLUDE Practical application Exercise: practical FIXED Exercise: practical INCLUDE Exercise: practical EXCLUDE Summary Beyond the Basic Chart Types Beyond the Basic Chart Types Improving popular visualizations Custom background images Tableau extensions Summary Mapping Mapping Extending Tableau's mapping capabilities without leaving Tableau Extending Tableau mapping with other technology Exercise: connecting to a WMS server Exploring the TMS file Exploring Mapbox Accessing different maps with a dashboard Creating custom polygons Converting shape files for Tableau Exercise: polygons for Texas Heatmaps Summary Tableau for Presentations Tableau for Presentations Getting the best images out of Tableau From Tableau to PowerPoint Embedding Tableau in PowerPoint Animating Tableau Story points and dashboards for Presentations Summary Visualization Best Practices and Dashboard Design Visualization Best Practices and Dashboard Design Visualization design theory Formatting rules Color rules Visualization type rules Compromises Keeping visualizations simple Dashboard design Dashboard layout Sheet selection Summary Advanced Analytics Advanced Analytics Self-service Analytics Use case ? Self-service Analytics Use case ? Geo-spatial Analytics Summary Improving Performance Improving Performance Understanding the performance-recording dashboard Exercise: exploring performance recording in Tableau desktop Performance-recording dashboard events Behind the scenes of the performance- recording dashboard Hardware and on-the-fly techniques Hardware considerations On-the-fly-techniques Single Data Source > Joining > Blending Three ways Tableau connects to data Using referential integrity when joining Advantages of blending Efficiently working with data sources Tuning data sources Working efficiently with large data sources Intelligent extracts Understanding the Tableau data extract Constructing an extract for optimal performance Exercise: summary aggregates for improved performance Optimizing extracts Exercise: materialized calculations Using filters wisely Extract filter performance Data source filter performance Context filters Dimension and measure filters Table-calculation filters Efficient calculations Boolean/Numbers > Date > String Additional performance considerations Avoid overcrowding a dashboard Fixing dashboard sizing Setting expectations Summary Additional course details: Nexus Humans Advanced Tableau 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 Advanced Tableau 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.