725 Practitioner courses in Cardiff delivered Live Online

Simply speaking, Life Coaching is about raising awareness of how we can move from A to B. Sometimes we don't know what place B is, and we can use Coaching to gain clarity on what B looks and feels like. Life Coaching is non-directive, which means as a Coach, I help you to unlock your potential rather than tell you what to do. The experience creates a space for accountability and motivation to take positive action. ​ My role as your Holistic Coach is to provide you with a safe space for you to ground, explore & embrace your emotions, claim your personal power to design & live your dream life.

This module aims to develop knowledge and understanding of the exporting process used in international trade from novice to practitioner. It includes documentation, incoterms, responsibilities of an exporter, commodity codes, origin and duties and taxes.

This course is intended for delegates who are now doing dermal fillers or whom are advanced injectors. The Brazilian Butt Lift training includes improving shape, volumizing and sculpting the area with dermal filler. We use Hyacorp MFL 2 or Genefill Products MASTERCLASS GROUP 8 CPD POINTS 1 DAY COURSE  ONLINE During the Online Training day you will learn the following: Anatomy and Physiology Consultation for patients Consent forms Treatment information After care Dezinfection & Safety Indications and Contra-indications Risks, side effects Dealing with complications Marketing tips Certificate upon completion CPD All under the supervision of our fully trained aesthetics practitioners, with Medical background . You will practice on real models and optional extra Mentoring date can be provided if required! BBL is the newest of the body augmentation treatments in the cosmetic/aesthetic industry Masterclass. ONLINE BBL TRAINING COURSE IN LONDON Practice in 1-day Course Group Training Non-Surgical Liquid Brazilian Butt Lift with Hyaluronic Acid ( difference Fillers )Hayacorp MFL 2 ,Genefill contour using cannulas. Brazilian Butt lift with Fillers also called Liquid BBL has become one of the most popular non-surgical cosmetic procedures. Client’s are more than ever looking for non-surgical alternatives to the most popular cosmetic procedures. Take advantage of this ever-growing market with our one-day intensive course, extend you level of injectable procedure. Our Buttock Augmentation training course you will learn how to safely administrate the HA and effectively carry out these procedures to help your clients achieve a firmer, rounder buttock whilst saving your clients thousands on undergoing invasive surgery.  The Brazilian Buttock Lift, training course consists in learning Master class injection techniques and application for the most frequently requested areas of the body under professional supervise with some of the best experts of Academy on central London. You can extend the training with Legs, Arms and Calves. With Harley Elite Academy you can learn to practice in cosmetic medicine what the most celebrities want! We will cover pertinent information including mechanism of action technique of safety, dealing with complications, dilution guidelines, and more., providing injectable protocol for the products. Contraindications Complications Management Post treatment advice You need to be medically qualified as a doctor, dentist, nurse, pharmacist or paramedic with full governing body registration and have completed a Foundation Filler Course and to have administered a number of cases.

Agile is not what you do, Agile is what you become! An introduction to the essentials of Agile Scrum as a delivery method. The same learning objectives as used in central government & public sector digital delivery projects. Agile is not what you do, Agile is what you become! Since 2012, all government departments have been required to use the Agile approach to project management, to build and run new digital services. As you begin your Agile journey, one of your first challenges will be understanding the rules and roles that support Agile delivery, some of the most frequently asked questions are "Which Agile framework is applicable to our business operating model?" or, "Is the Project Manager role equivalent to that of theProduct Owner?" and, "What does a Scrum Master do?" A strong corporate culture not accustomed to the Agile mindset can also be a difficult environment in which to implement Agile methods. In some cases, the company’s culture and practices may reward non-Agile milestones while inadvertently discouraging Agile success. This intensive two-day training course combines PowerPoint presentations, informal discussions and practical exercises to introduce you to Agile Scrum as a Delivery Method, without the impending pressure of having to pass a formal certification examination. Previous experience of Agile delivery is not a pre-requisite to attending this course, although it is assumed delegates have previously attended the Primer course, or have some understanding of Agile Scrum terms and practices. This course, designed by Agile Scrum practitioners and coaches with specialist experience of working on GDS (Government Digital Service) Service Standards compliant government and public sector projects has been accredited by The CPD Certification Service and is now available outside its usual central government and public sector digital delivery setting. Who this course is for Service and Programme Managers If you are a Service Manager or Programm Manager who wants to explore the benefits of transitioning to Agile ways of working and want to understand how your existing business processes and resource landscape will fit into an Agile delivery model, then this course aims to provide you with enough information to enable you to make an informed decision. Career ambitions If you are new to Agile and your intention is to pursue a career either as an Agile Scrum Master or Agile Product Owner, you will hopefully be provided with enough knowledge to enable you to determine which role best suits your Agile career ambitions. Frequently Asked Questions How this course differs from other Agile courses Delegates will learn the 'How', not just the 'What'! This course has been designed by highly experienced Agile practitioners and coaches with specialist real-life experience of working on GDS (Government Digital Service) Service Design Standard projects. Delegates will find that the learning objectives are significantly more detailed than with other Agile courses which only focus on teaching the learning objectives of The Scrum Guide. Delegates must take the certification assessment. No! During enrolment, delegates can opt out of taking the C-ASDM certification assessment. The online Agile Scrum as a Delivery Method – Essentials course quiz is optional Absolutely! Delegates are provided access to the online Agile knowledge quiz which accompanies the Agile Scrum as a Delivery Method – Essentials course. The quiz helps delegates gauge their level of attainment but is entirely optional. Delegates can take the certification assessment without enrolling on the course. Yes! Delegates with existing Agile project delivery experience can choose to take the certification assessment without enrolling on the course. I will receive my certificate as soon as I have completed the course You will initially receive an Assessment Completion report after completing the assessment. The report details the certification status: 'Pass' or 'Fail', and includes information on which questions were answered incorrectly. Your certificate is issued by the CPD Certification Service approximately four-to six-weeks after successfully completing and passing the C-ASDM Certification Assessment. A CPD certification is recognised by employers Yes! CPD certification is recognised by private and public sector employers, and in central government departments as a valuable way to evaluate the skills of an individual, and the quality of the learning activities. Listing your CPD certification as well as the number of CPD Points you have achieved on your CV is essentially showcasing your achievements in continuing your professional development. One CPD Point is equivalent to an hour of training CPD points are units that quantify time, and the quality of learning and development activities. Delegates will earn 3 CPD Points upon successful completion of the C-ASDM Certification Assessment or 13 CPD Points after completing the two-day course. My CPD certificate will expire after three years Your certificate will not expire however, best practice suggests a renewal after three years. You can do this by enrolling on the C-ASDM course to ensure your knowledge of Agile as a Delivery Method is up to date. Service features Two-day Agile Scrum training course The course uses eCommerce and other Business Case examples for context Optional online CPD certification assessment Optional Agile knowledge quiz to help delegates gauge level of attainment Online Retrospective feedback to enable continuous course improvements. Service benefits Delegates will understand the concepts and benefits of Agile Scrum development Scrum team roles and role accountabilities INVEST-compliant User Stories and BDD formatted Acceptance Criteria Agile approach to incremental project delivery Agile artefacts and Agile reports (burn-down & burn-up charts) Agile Events & Scrum rules Comparison: Agile methodologies (Lean, XP, SAFe & Scrum) Use of Kanban for workflow management Government Digital Service (GDS) Service Standards and Service Assessment Be able to communicate the ideals of Agile to stakeholders Service Agenda General knowledge Agile Delivery 101 Scrum process and sprints Applicability of Scrum Agile Manifesto Scrum roles and accountabilities Overview of Scrum roles (Core & Ancillary) Scrum Master role and role responsibilities Scrum Product Owner role and role responsibilities Scrum team Scrum events Sprint Planning Daily Scrums Sprint Reviews Sprint Retrospectives Scrum artefacts Product Backlog Sprint Backlog Increments Scrum Reports Burn-down and Burn-up Charts Scaling Scrum Working with multiple Scrum teams Working with distributed Scrum teams GDS (Government Digital Service) Service Standards Service Assessments Risks and challenges Risks and challenges of transitioning to Agile delivery Frequently asked questions Discussion on frequently asked Agile questions Agile knowledge quiz Examples of the multiple-choice questions in the optional online quiz On-going support Email support No Telephone support No Webchat support No Online support No Community Support Yes! Delegates are offered access to our private online 'Community of Agile Scrum Practitioners'. Delegates who achieve the pass mark for CPD certification are additionally offered access to our private 'Certified Scrum Practitioners’ Guild', a private Slack community of like-minded Agile professionals.

Getting Started Enhance your career and earn the highest qualification available in business and management. The Doctor of Business Administration taught and awarded by the University of Central Lancashire is designed for senior managers and consultants who wish to learn and earn an advanced administration level while working full-time. DBA is a demanding research-based programme suitable for candidates pursuing higher-level business administration qualifications after an MBA. This programme provides a solid foundation in various aspects of business, including management, marketing, finance, and operations. Students can expect to gain practical insights into real-world business scenarios, enabling them to make informed decisions and solve complex problems effectively. You're learning journey will include: Lectures and guided reading. Active group work. Case studies. Videos. Reviews of current events and student presentations. You'll develop applied research skills as you evaluate industry-related problems critically. Throughout the programme, students receive support from experienced academics and industry professionals who provide guidance and feedback on their research projects. The programme is delivered through online webinars and independent study, allowing students to balance their studies with work and personal commitments. Doctor of Business Administration is awarded and delivered by the University of Central Lancashire. School of Business and Technology London partners with Chestnut Education Group to promote this Doctor of Business Administration programme.  About Awarding Body Founded in 1828, the University of Central Lancashire is a public university based in Preston, Lancashire, England. Today, UCLAN is one of the largest in the United Kingdom, with a student and staff community of nearly 38,000. At present, the University has academic partners in all regions of the globe, and it is on a world stage that the first-class quality of its education was first recognised. In 2010, UCLAN became the first UK modern Higher Education institution to appear in the QS World University Rankings. In 2018, the Centre for World University Rankings estimated Central Lancashire to be in the top 3.7 per cent of all global universities, highlighting the growth the University has made in offering students real-world learning experiences and reflecting the University's extensive pool of academic talent. Ranked in the top 7% of universities worldwide. Student Communities from more than 100 countries WES Recognised Qualifi is a UK Government (Ofqual.gov.uk) regulated awarding organisation and has developed a reputation for supporting relevant skills in a range of job roles and industries, including Leadership, Enterprise and Management, Hospitality and catering, Health and Social Care, Business Process Outsourcing and Public Services. Qualifi is also a signatory to BIS international commitments of quality. The following are the key facts about Qualifi. Regulated by Ofqual.gov.uk World Education Services (WES) Recognised Assessment Assignments and Project No examination Entry Requirements Applicants should normally have a Master's degree or equivalent and work in or have recently worked with in business administration. If English is not your first language, you will be expected to demonstrate a certificated level of proficiency of at least IELTS 6.5 (Academic level) or equivalent English Language qualification. Progression Upon completing the doctorate programme, learners will possess the necessary skills and knowledge to pursue various career opportunities in administration, management research, etc. One can choose from various positions upon successfully completing a DBA. Some of the most notable career paths are Professor and Postdoctoral Researcher, Market Research Analyst, Economic Analyst, etc. Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. Structure Phase 1: Qualifi Level 8 Diploma in Strategic Management and Leadership Programme Structure The course is structured around eight mandatory units, encompassing various topics aligned with learning outcomes. Each unit holds a value of 20 credits. Learners can participate in lectures and workshops to familiarize themselves with the subject. Attaining a total of 160 credits by completing all units is a prerequisite for the issuance of the Diploma. Unit 800: Leadership Qualities and Practice Unit code: A/506/9126 This unit delves into the connections between leadership and management within strategic operations. It scrutinizes various leadership styles, their underlying principles, and associated concepts. The unit also investigates methods to assess and enhance team performance to achieve strategic business and operational goals. Additionally, it encompasses the interplay between strategic management and leadership, containing crucial leadership principles, theories, and their alignment with organizational strategy. Unit 701: Research Methods Unit code: Y/506/9134 The objective of this unit is to enhance the learner's knowledge and comprehension of academic practices and research methodologies. It employs a problem-based learning approach to cultivate practical proficiency in areas relevant to educational practice and research in business and management. Unit 801: Personal Leadership Development as a Strategic Manager Unit code: F/506/9127 This unit focuses on the strategic leadership skills essential for directors and senior managers to effectively guide international organizational strategic initiatives, collaborating with partners, buyers, suppliers, customers, and competitors. Unit 802: Strategy Development in Cross Border and Global Organisations Unit code: F/506/9130 This unit tackles formulating strategies for cross-border or global organizations, which encounter complexities stemming from political, religious, cultural, and social differences, as well as the management of organizations operating within specific country boundaries. Unit 803: Strategic Planning for Cross Border and Global Organisations Unit code: L/506/9132 This unit scrutinises the diverse influences and effects on cross-border or global organisations and how they contribute to the development of successful strategies and the mitigation of risks. Unit 804: Strategic Direction in Cross Border and Global Organisations Unit code: R/506/9133 This unit provides senior strategic managers with the opportunity to delve into the influences and effects of cross-border and global policy and strategy. It aims to facilitate enhancements in establishing direction, shaping the approach, and forecasting the success of cross-border or worldwide policy and procedure. Unit 805: Strategic Communication Unit code: L/506/9129 The unit aims to develop the ability to critically assess and appreciate the impact of media on international organisations. It considers stakeholders, political and pressure groups, as well as the part played by media owners. Unit 806: Culture and its Impact on Strategy Unit code: J/506/9128 This unit strives to foster a profound comprehension of the intricacies faced by internationally operating organizations and how this impacts the strategy development process. It employs well-reasoned and thoroughly researched perspectives to cultivate alternative viewpoints.   Phase 2 - Doctor of Business Administration Programme Structure Stage 1 - Taught component The Reflexive Practitioner Management, Rhetoric, Policy and Practice Research Methodologies and Design Qualitative Research Methods Quantitative Research Methods Accordion Title Stage 2 - Research component The Reflexive Practitioner     Delivery Methods The Doctor of Business Administration is awarded and delivered by the University of Central Lancashire. This doctorate from the University of Central Lancashire is offered as a block teaching and research programme. The DBA will run at the Preston Campus of the University. You'll have full access to the Library and information resources of the University throughout the DBA and may use all social, cultural and sports facilities of the University. Stage 1 - Taught component The DBA Taught Programme consists of six taught modules, each being completed through a four-day intensive workshop plus a period of private study both before and after the workshop. During Stage 1 you will develop critical and reflective skills at doctoral level, through the requirement to think conceptually, apply critical thinking, and reasoning skills and to challenge orthodoxy relating to the body of knowledge and research relating to Management and Organisation. Action learning is incorporated within the study sessions and is an important and distinctive feature of our DBA. You will work in sets or small development groups with fellow participants throughout the programme and also develop your skills as a critical and reflective learner. Stage 2 - Research component The DBA Research Programme - as part of the development process of your DBA project, you will have worked with the DBA staff to agree a suitable supervisory team, including a Director of Studies. This team will work with you throughout Stage 2 helping you to design and implement your own particular DBA project. This will normally take two years working on a part-time basis although you may choose to work at a pace that requires more time and you may therefore take up to five years. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

SAFe® for Architects: Virtual In-House Training Enable continuous value flow by aligning technical strategy with business goals, communicating that strategy to development teams, and applying Agile architecture practices. Attendees can improve collaboration and alignment in a SAFe® Lean-Agile enterprise when they become a SAFe® 5 Architect. The SAFe® for Architects course prepares System, Solution, and Enterprise Architects to engage across the organization as effective leaders and change agents who collaboratively deliver architectural solutions. During this course, attendees will explore the roles, responsibilities, and mindset of Agile Architects, and appreciate how to align architecture with business value and drive continuous flow to large systems of systems while supporting SAFe® program execution. What you will Learn To perform the role of a SAFe® Architect, you should be able to: Architect using SAFe® principles Align architecture with business value Develop and communicate architecture vision and intent Plan architectural runway to enable delivery success Architect for continuous delivery and Release on Demand Lead and coach architects and team members during Program Increment (PI) Planning and execution Provide leadership during a Lean-Agile transformation Exemplifying Lean-Agile architecture Architecting for DevOps and Release on Demand Aligning architecture with business value Developing Solution Vision, Solution Intent, and Roadmaps Preparing architecture for Program Increment (PI) Planning Coordinating architecture throughout PI Planning Supporting Continuous Delivery during PI execution Supporting new Strategic Themes and Value Streams Leading as an architect during a Lean-Agile transformation

Counselling: PTSD, Trauma and Children Care Course Overview This comprehensive course on Counselling: PTSD, Trauma and Children Care provides learners with a deep understanding of trauma's impact on children and adolescents, including post-traumatic stress disorder (PTSD). It explores counselling theories, ethical considerations, and therapeutic approaches tailored to young clients. Designed to equip learners with essential knowledge and communication skills, the course emphasises recognising symptoms, assessing needs, and offering supportive interventions. Learners will gain valuable insight into working with vulnerable populations, including those affected by substance abuse, anxiety, depression, and self-harm. The course prepares participants to engage confidently in various counselling environments, fostering empathy and professional competence to support children and families through crisis and recovery. Course Description This course offers an in-depth exploration of counselling approaches specific to trauma, PTSD, and child and adolescent care. Covering key theoretical models and contemporary psychotherapeutic methods, it addresses legal, cultural, and ethical frameworks integral to counselling practice. Learners will study diverse mental health disorders affecting young people, such as mood, personality, eating, and sleeping disorders, and how these intersect with trauma. The curriculum also includes techniques for crisis intervention, low intensity cognitive behavioural therapy (CBT), and the role of medication in treatment. Emphasis is placed on developing communication skills, empathy, and client engagement strategies essential for effective therapeutic relationships. With a focus on school and family settings, this course prepares learners to confidently support children and adolescents navigating complex emotional and psychological challenges. Counselling: PTSD, Trauma and Children Care Curriculum Module 01: Counselling and Counsellors Module 02: Theories and Models of Counselling (Part 1) Module 03: Theories and Models of Counselling (Part 2) Module 04: Legal, Cultural and Ethical Issues in Professional Counselling Module 05: Forms of Psychotherapy Module 06: Childhood and Adolescent Psychiatric Disorders Module 07: Counselling Children and Adolescents in Schools Module 08: Counselling Trauma and Substance Abuse Module 09: Counselling Stress and Anxiety Disorders Module 10: Counselling Personality Disorders Module 11: Counselling Mood Disorders and Depression Module 12: Counselling Eating & Sleeping Disorders Module 13: Life Coaching and Career Counselling Module 14: Couple and Family Counselling Module 15: Counselling Self-Harm and Suicide Module 16: Engaging and Assessing the Patients Module 17: Helping the Client in Crisis Module 18: Crisis Intervention Module 19: Low Intensity CBT Treatment Module 20: Medication and Therapy in the Treatment of Mental Illness Module 21: Communication Skills and Empathy in Counselling (See full curriculum) Who is this course for? Individuals seeking to support children and adolescents affected by trauma. Professionals aiming to enhance counselling skills in mental health and youth care. Beginners with an interest in psychological support and therapeutic practices. Care workers, educators, and health practitioners working with young people. Career Path Counsellor specialising in trauma and child mental health Youth Support Worker or Youth Mental Health Practitioner School Counsellor or Educational Psychologist Assistant Mental Health Advisor or Crisis Intervention Specialist Family Support Worker or Social Care Practitioner

MASTERCLASS ONE-2-ONE 8 CPD POINTS 1 DAY INTENSIVE COURSE  ONLINE or IN-CLINIC NOTE! After booking we will contact you for scheduling the exact course date! Courses dates are subject to change due to mentors availability. We will inform you via email if a date becomes available! PDO Threads course Our one-day Harley Elite Academy PDO cog thread lift ( Elite Mini Face Lift )training course is providing for Doctors ,Nurses , Dentist looking to further to present non-surgical facelift. It s the newest trend made popular by some of celebrities recently and it is an amazing and effective latest technique to mehanical lift and tighten skin. We provide second option using mono and screw it has the potential to redefine facial contours and induces collagen production. This type threads support structure for the tissue of the face by encouraging natural collagen synthesis with 30 % immediately results that peak at 6 months and more. During the training learn how to safely achieve mid and lower face lift and tight , we aim to help you master class techniquesre-volumisation and lifting using one of the highest quality products on the market PCL Threads.   Thread Lift Masterclass Course You will perform this procedure on live models under the supervision You will practice using This master training will teach you how to introduce threads in Body areas including: Inner Thigh | Inner Arm | Knee | Tummy | Buttock Using threads: screw, mono and cogs. During Dermal Filler Masterclass, you will learn the full Anatomy of the face and gain practice.Anatomy, Vascular Supply of the face, Nerves Contraindications Complications Management Post treatment advice Additional information ATTENDANCE ONLINE (theory), IN-CLINIC (Practice) PDO THREADS LIFT AREA BEGINNER Face and Neck Threads Lift, ADVANCED Body Threads Lift, MASTERCLASS Face, Neck, Body Threads Lift, MASTERCLASS Foxy Eyes | Cat Eyes

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.

Join the Scrum.org accredited Live Virtual Class - Professional Scrum Master I™ (PSM I) to master the fundamentals of Scrum. Learn the framework, mechanics, and roles to ensure successful implementation by your team. Course Description Our Scrum.org certified online professional scrum master courses set industry standards with a remarkable 98% first-time pass rate. Say goodbye to PowerPoint and embrace 100% interactivity. Gain hands-on practical skills, learning how to implement immediately and achieve tangible results. Learn to empower Scrum Teams for organisational value delivery. Gain insight into Scrum theory, empiricism, and its framework-to-principal connection. Understand how to apply Agile principles to real-world contexts. Grasp uncertainty and complexity in product delivery, Scrum values' significance, and the essence of "Done" for transparency. Master agile planning with the Product Backlog. Acquire self-management, interpersonal skills, and the crucial role of a Scrum Master as a leader. Develop the necessary skills, traits, and behaviour for effective Scrum Mastery. Why Train With Us? Explore Agile and Scrum principles with our immersive two-day online course where we prioritise your growth and success. Led by experienced industry professionals and supportive Professional Scrum Trainers, we go beyond PowerPoint to offer engaging, hands-on learning experiences. Gain a profound understanding of Scrum theory and discover practical applications relevant to your workplace challenges enabling immediate and impactful change. From debunking myths to empowering your Scrum Teams with the right practices, we'll be with you every step of the way - from learning to passing the test and implementing it seamlessly into your job context. Who Should Attend This Course? Suitable for all industries tackling complex problems, the Professional Scrum Master training course is designed for: Those aspiring to become Scrum Masters Practitioners and consultants seeking to enhance their Scrum expertise Anyone involved in product delivery through Scrum methodologies Agile managers aiming to understand the Scrum Master's role Your Professional Scrum Trainer Meet Jay, founder of Fractal Systems and a dedicated Professional Scrum Trainer. With over 20 years of experience in team and leadership roles, Jay is well-versed in delivering continuous value. His unique teaching approach involves zero PowerPoint and instead relies on engaging, experience-based sessions using techniques from Liberating Structures and Neuro Linguistic Programming. Jay's expertise lies in business transformations, offering training, mentoring, coaching, and consulting to foster success through collaborative efforts. Rapid learning and practical application are the hallmarks of his approach. Jay & the entire Fractal team are invested in your learning journey and are here to support you from start to end, including offering additional valuable support: Free PSM1 practice assessment for certification success Free PSM1 resource bundle to master Scrum Free PSM1 exam revision sheets Free exam coaching sessions for first-time success in your PSM1 exam Free 1:1 coaching to excel at work as a Professional Scrum Master Our Clients Our Testimonials