Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.
VoIP training course description Convergence of voice and data is now a common place mainstream technology. Our Voice Over IP course investigates the characteristics of voice transmission and then studies the impact on IP networks. Practical sessions with soft phones, hard phones and gateways allow the students to see all aspects of VoIP. Network analysers are used to study packets on the wire. What will you learn Describe the issues of voice and data convergence. Describe techniques, which can be used in IP to provide low uniform delay. Evaluate VoIP technologies. Design data networks, which will support voice. VoIP training course details Who will benefit: Anyone working in the field of networking or telecommunications. Prerequisites: TCP/IP foundation for engineers Intro to data communications & networking Duration 3 days VoIP training course contents What is VoIP Voice over IP, brief review of IP, brief review of telephones and voice. Configuring IP softphones What are softphones? Downloading, installing. Hands on Building the base IP network, a simple VoIP call with softphones, Internet telephony. Addressing E164, FQDN, IP addresses, URIs, DNS, SIP addressing, H.323 addressing. VoIP issues Bandwidth, Delay, Jitter, digitising voice, digitisation steps, coding, quality issues, MOS, voice compression, silence suppression, packetising voice, prioritising voice, jitter buffers. Hands on Simple packet analysis. Architectures Desktop, backbone, gateway, hard phones, PoE, integrating phones and PCs, carriers, Softswitches. Hands on Integrating Softphones, hard phones and analog phones. IP performance and QoS ITU delay recommendations, IP DSCP field, DiffServ, IP precedence, queuing strategies; FIFO, WFQ, custom, priority, RED, LLQ. VoIP protocol stack RTP, RTCP, mixers and translators, RSVP. Bandwidth, Erlang models, link layer overhead. Hands on Calculating VoIP bandwidth, analysing RTP packets. ITU Recommendation H.323 Architecture, protocols, terminals, Call setup, Gatekeepers, gateway discovery, H.323 registration with a gatekeeper. Hands on PC to PC using H.323. IETF - Session Initiation Protocol What is SIP? SIP protocol stack, SDP, Sip architecture, SIP messages, Initial SIP phone startup, SIP servers, proxy server, redirect server. Hands on PC to PC using SIP. Carrier networks Signalling systems, SS7, media gateways, Media gateway controllers, signalling gateways, MGCP, Megaco, SIGTRAN. Hands on PSTN interworking. Video over IP Video components, digital video, pictures and audio, video codecs, issues and solutions, video conferencing, multipoint video conferencing, video protocol stack. Appendix 1: Multicasting. Appendix 2: Voice/data integration without IP.
Become a financial crime prevention superhero with LGCA’s help! Pick up everything you need to know to join a company’s AML function and start fighting crime with your newfound knowledge and skills. The Certificate in AML provides participants with a thorough understanding of what constitutes Money Laundering (ML) and how financial institutions should respond to increasingly complex attempts by criminal individuals and entities to process proceedings from illegal activities in a manner that enables them to enjoy such illegal proceedings.
Learn the basics of Data Science, combining a supported #CISCO Skills for All online course with practical learning and a project to help consolidate the learning.
Course Description:This intensive two-day course on the Fundamentals of Dermatology for Primary Care is highly relevant for healthcare professionals in primary care, especially those lacking dermatology in their post-registration training. The course offers an opportunity to advance in practice, gain relevant competencies, and enhance clinical confidence for improved patient care.Introduction:Understanding dermatology care is vital in general practice, given that 10-15% of the primary care workload involves dermatology. Common skin conditions have a significant psychological impact on patients. The course emphasizes the importance of proper skin assessment, accurate diagnosis, and effective patient self-management for better treatment outcomes.Day One:- 09:15 AM: Coffee and registration- 09:30 AM: Introduction and course objectives- 09:40 AM: Anatomy and physiology of normal skin- 10:00 AM: Pathophysiology of acne, eczema, and psoriasis - understanding skin changes- 10:45 AM: Coffee break- 11:00 AM: The language of dermatology - effective description- 11:45 AM: Skin assessment and history-taking - recording observations- 13:00 PM: Lunch break- 13:45 PM: Recognizing skin changes: skin lesions and skin cancer - addressing concerns- 14:00 PM: Hyper and hypo pigmentation - understanding variations- 14:30 PM: Screening for skin cancer and promoting sun safety- 15:00 PM: Dermatology resources and guidelines - accessing information- 16:00 PM: Action plan, evaluation, and resources- 16:15 PM: CloseDay Two:- 09:15 AM: Welcome back and course work review- 09:30 AM: Managing acne in primary care - practical applications and treatments- 10:30 AM: Managing psoriasis in primary care - topical treatment and demonstrations- 10:45 AM: Coffee break- 11:00 AM: Managing eczema in primary care - practical challenges and solutions- 11:45 AM: Understanding patient self-management and psycho-social aspects- 12:30 PM: Lunch break- 13:30 PM: Practical emollient workshop - exploring patient preferences- 14:15 PM: Skin infections - recognition, diagnosis, and management- 14:45 PM: Genital skin conditions - Update on lichen sclerosis recognition and treatment- 15:30 PM: Practice reviews, competencies, and reflective discussion- 16:15 PM: CloseCourse Aim:To equip primary care healthcare professionals with evidence-based knowledge and practical confidence to elevate dermatology care, improve patient support for common skin conditions, and ensure appropriate secondary care referral.Learning Outcomes (Day 1):- Develop a Strong Foundation: Understand skin anatomy and physiology for a comprehensive grasp of normal skin characteristics.- Decipher Pathophysiology: Discern the intricacies of common dermatology conditions, such as acne, eczema, and psoriasis, understanding the underlying skin changes that drive these conditions.- Master the Language of Dermatology: Gain proficiency in describing dermatological observations accurately, facilitating effective communication and reporting.- Harness the Power of Assessment: Elevate skin assessment and history-taking skills, honing the ability to document observations and pertinent patient history with precision.- Recognise Skin Changes: Sharpen the skill of identifying skin lesions and potential indicators of skin cancer, equipped with the expertise to navigate the "when to worry" challenge.- Explore Pigmentation Variations: Delve into hyper and hypo pigmentation, understanding conditions like dermatosis papulosa nigra, sebaceous hyperplasia, solar lentigo, and freckles.- Promote Sun Safety and Dermatology Education: Grasp strategies for skin cancer screening and sun safety healthcare education, contributing to proactive patient care.- Navigate Dermatology Resources: Gain insight into valuable dermatology resources and guidelines, empowering continuous learning beyond the course.Learning Outcomes (Day 2):- Enhance Practical Skills: Gain hands-on experience in managing common skin conditions like acne, psoriasis, and eczema using both over-the-counter and topical treatments.- Empower Patient Support: Engage with patients to gain insights into their experiences of self-managing chronic skin conditions, focusing on psycho-social aspects and effective coping strategies.- Immerse in Practical Emollient Workshop: Participate in a tactile workshop to understand patient preferences and choices in emollient usage.- Refine Diagnostic Skills: Develop the ability to recognize, diagnose, and manage skin infections effectively, improving overall dermatological care.- Master Genital Skin Conditions: Gain updated knowledge on recognising and treating genital skin conditions like lichen sclerosis, enhancing expertise in a specialized area.- Reflect and Consolidate: Engage in reflective discussions, reviewing competencies gained during the course and integrating newfound insights.Course Conclusion:Conclude the two-day course with a profound sense of accomplishment, armed with enriched dermatological knowledge, practical skills, and patient-centered strategies that will positively influence your professional practice.
3 Day Intensive Forex Trader Training Programme.
UNIX fundamentals training course description An introduction to using the UNIX operating system focussing on the command line. Appropriate for all versions of UNIX. The starting point for all UNIX work, we concentrate on the technical aspects rather than issues such as using browsers. The course is heavily practical in nature. What will you learn Describe UNIX. Log in and use UNIX commands to perform a variety of tasks from manipulating and printing files to looking at and killing processes. Create and edit files with vi. Recognise the role of the administrator. Write simple shell scripts. Customise the user environment. UNIX fundamentals training course details Who will benefit: Anybody who needs to use a UNIX system. Prerequisites: None. Duration 3 days UNIX fundamentals training course contents What is UNIX? Operating systems, UNIX flavours, UNIX features. Getting started Logging in, changing passwords, logging out. UNIX basics Command structure. The UNIX manuals, basic commands (who, date, tty, uname, echo, banner...) Filesystem commands Home directories, manipulating files and directories, Filesystem layout, Pathnames, hard and symbolic links. The UNIX Editors ed, vi, shell escapes, .exrc Extracting data from files grep, find, cut, sort and paste Permissions Theory, chmod, chown, newgrp.. Processes ps, kill, background processes, at, exec, priorities. The Shell Metacharacters, piping and redirection. Basic shell scripting What are shell scripts? Simple scripts, control structures. Variables. Arguments. Customising your environment Environmental variables, stty, .profile and other startup files More shell features Bash and other shells, the history facility, command line editing, aliases, job control, miscellaneous features. Introduction to administration The root user, su and tar Archiving files Backups, tar, cpio, dd, gzip. Unix and hardware Main hardware components, Unix device drivers. Connecting to a network IP configuration, ifconfig, ping, netstat, traceroute, dig.
Endometriosis masterclass. Two day practical theory and hands on course on all aspects of endometriosis management. Expert faculty and live surgical cases.
The GDPR Foundation training enables delegates to understand how to define and implement a privacy compliance framework aligned to best practice. During this training course, you will be able to understand the fundamental privacy principles and become familiar with the role of the Data Protection team and the DPO. About This Course At Foundational level, candidates prove they have understood the fundamental methodologies, requirements, best practice and management approach of a Privacy Compliance Framework. Learning principles; Understand the General Data Protection Regulation requirements and the fundamental principles of privacy Understand the obligations, roles and responsibilities of the Data Protection Officer Understand the concepts, approaches, methods and techniques to effectively participate in the implementation process of a compliance framework with regard to the protection of personal data. Educational approach; Lecture sessions are illustrated with practical questions and examples Practical exercises include examples and discussions Practice tests are similar to the Certification Exam Course Agenda Day 1: Introduction to GDPR and Data Protection Principles Day 2: The General Data Protection Regulation requirements and Certification Exam Prerequisites There are no prerequisites for this course. What's Included? Refreshments & Lunch (Classroom courses only Course Slide Deck CPD Certificate Who Should Attend? Individuals involved in the processing of Personal Data and Information Security Individuals seeking to gain knowledge about the main privacy principles Individuals interested to pursue a career in Data Protection Provided by This course is Accredited by NACS and Administered by the IECB Assessment Delegates sit a combined exam, consisting of in-course quizzes and exercises, as well as a final 40 question, multiple choice exam on Day 2 of the course. The overall passing score is 70%, to be achieved within the 60 minute time allowance. Exam results are provided within 24 hours, with both a Certificate and a digital badge provided as proof of success.