3895 Courses in Cardiff delivered Live Online

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.

SNMP training course description A hands-on generic look at the technical operation of SNMP. The course starts with an overview of all the components, which make up SNMP. Hands on starts early with configuration of a managed network. The major versions of SNMP are then put into perspective followed by a look at the SNMP protocol. MIBs are then studied both from the perspective of reading MIBs and writing MIBs. The course finishes with a look at the security implications of SNMP. What will you learn Describe the SNMP architecture. Analyse SNMP packets. Recognise the MIB structure. Describe the SMI. Recognise the strengths and weaknesses of SNMPv2 and SNMPv3. SNMP training course details Who will benefit: Network administrators. Network operators. Programmers writing MIBs and agents. Prerequisites: TCP/IP Foundation for engineers Hands on experience of an SNMP management station would also be beneficial. Duration 3 days SNMP training course contents Network management What is network management? Benefits, issues. What is SNMP? SNMP architecture, SNMP MIBs, SMI, the SNMP protocol, polling security, alternatives to SNMP: CMIP, web based management. Configuring SNMP Auto discovery for management stations, NMS configuration, agent configuration, traps. Hands on Configuring agents and an NMS. SNMP background SNMP history, RFCs, standards, SNMP protocol versions, SNMPv1, SNMPv2, SNMPv3, SNMP SMI versions, which version should you use? Futures. SNMPv1 packets SNMP in the 7 layer model, port numbers, general packet format, BER, GET, GET-NEXT, tables, SET, TRAP, bandwidth issues, in band versus out of band management. Hands on Analysing SNMPv1 packets. SNMPv2 packets SNMPv2 improvements, error handling, GETBULK, v2traps, INFORM. Hands on Analysing SNMPv2 packets. SNMPv3 packets SNMPv3 packet format, use of SNMPv2 messages, REPORT PDU. MIB structure The internet MIB branch, standard mib-2, extra parts of mib-2, private enterprise MIBs, loading extra MIBs. Hands on MIB browsing. mib-2 The mib-2 groups, system group, interfaces group, IP group, ICMP group, TCP group, UDP group, transmission group, SNMP group, RMON. Hands on mib-2 browsing in detail. SMI The MIB layout, obtaining a private enterprise number, MIB definitions, IMPORT, Module identity, Textual conventions, object definitions, notifications, compliance statements, object groups, base SMI data types, application data types, scalars, instances, tables, table definition, writing agents, SMIng. SNMP security Community strings, SNMPv1 and SNMPv2c security practices, SNMPv3 security, SNMPv3 architecture, SNMP applications, the SNMP engine, the EngineID, security fields in SNMPv3 packets, USM, authentication, encryption, timeliness, VBAC, SNMPv3 configuration.

How can I use reflection to improve my practice

About this Virtual Instructor Led Training (VILT) This 3 half-day Virtual Instructor Led Training (VILT) course will help participants grasp the idea of real-world risk management and how this relates to the cyber world. The VILT course will cover topics surrounding identifying cyber risks and vulnerabilities, guidance on applying administrative actions, and comprehensive solutions to ensure your organization is adequately secure and protected. The VILT course will guide participants on how to conduct a security risk assessment for their organization, and equip them with the skills to develop a risk compliance assessment plan as well as methods to develop risk management strategies which can improve their organization's security posture. The VILT course has at least a 30% hands-on approach through the use of Table Top Exercises. The VILT course will cover the following modules: Introduction to Risk Assessments (RA) Threat Actors and Their Motivations Threat and Risk Assessment Critical Controls Identification Maturity Assessment Treated Cyber Risk Profile Target Cyber Risk Profile and Strategy Target Audience The VILT course is intended for professionals responsible for organizational information and security system and those involved in operating and maintenance of critical information and IT network & sotware systems. Professionals who are designated as the Single Point of Accountability (SPoA) as well as system auditors will find this course useful. Course Level Basic or Foundation Training Methods The VILT course will be delivered online in 3 half-day sessions comprising 4 hours per day, with 2 x 10 minutes break per day, including time for lectures, discussion, quizzes and short classroom exercises. Course Duration: 3 half-day sessions, 4 hours per session (12 hours in total). This VILT course is delivered in partnership with ENGIE Laborelec. Trainer Your expert course leader is a is specialized in cybersecurity risk management. Before joining ENGIE, she worked for The National Cybersecurity Agency of France (ANSSI) based in Paris (France) and for Deloitte Belgium located in Zaventem (Belgium). She has been involved in cybersecurity projects focusing on the principle of protecting critical infrastructures. Her different experiences in Cyber Security, Anti-Money Laundering and Global Trade Compliance (including Export Control and Customs) gave her the opportunity to use methodologies tackling strategic, operational and financial control issues at all levels of an organization: people, business processes, IT applications and infrastructure, legal and regulatory compliance. She was an EBIOS Risk Manager (RM) trainer while she worked for the French government; EBIOS RM is the French method for assessing and treating digital risks. She also had the opportunity to represent France towards European institutions and other relevant stakeholders for topics related to cybersecurity risk management. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information about post training coaching support and fees applicable for this. Accreditions And Affliations

About this Virtual Instructor Led Training (VILT) This 5 half-day VILT course will comprehensively cover the technical aspects of gas processing. The scope will be from the wellhead through the typical gas processing plant and discuss gas gathering (pipeline hydraulics), natural gas treating (H2S, CO2 removal), acid gas injection and sulfur recovery. One unique aspect of this training course is the operations and troubleshooting discussions in each module. This VILT course is suited to technical personnel or technical management. Training Objectives After the completion of this VILT course, participants will be able to: Grasp the key specifications of natural gas and liquid products Understand the physical and transport properties of gases and liquids and liquid-vapor phase behavior Explore the various technologies for processing natural gas and to make the specifications Examine the design of the technologies Learn how to diagnose operating problems to keep facilities running reliably Target Audience This VILT course is intended for all surface technical personnel such as process engineers & technologists, facility engineers and production engineers & technologists. This VILT course will greatly benefit but not limited to: Process, petroleum and production engineers Field operators and technicians Personnel involved in gas treatment and processing Managers and Supervisors involved with gas processing operations Course Level Basic or Foundation Intermediate Training Methods The VILT course will be delivered online in 5 half-day sessions comprising 4 hours per day, with 2 breaks of 10 minutes per day. Course Duration: 5 half-day sessions, 4 hours per session (20 hours in total). The maximum number of participants for this course is 20 persons. Case studies and Exercises: This VILT course will use actual case references throughout its duration in various forms. This will allow the application of the participants' newly-acquired knowledge. Case studies also stimulate independent thinking and discussion among the participants Trainer Your expert course leader has written several papers that have been published in both academic and industry journals. He has over 30 years of industry experience, specializing in gas processing (pipeline hydraulics, separation, dehydration, treating, sulphur recovery and refrigeration processes) and also has experience with crude oil dehydration, stabilization and micro-refining topping plants. He has experience with developing new technology and is recently involved in lithium, waste biomass and used motor oil pyrolysis and geothermal projects. He has recognized expertise in thermodynamics and physical and transport properties of fluids. He has consulted for several EPC and operating companies through his company Chem-Pet Process Tech., and currently holds the role of Director of Technology in an integrated engineering and solutions provider to the energy industry. He is currently involved with a small power-based carbon capture project as well as helping clients determine the best options for utilities decisions. He has been involved with CO2 dehydration and CO2 flood gas treating as well as acid gas injection projects for several years. Highlighted Achievements: Developed ORC geothermal model to determine the available power from wells in Alberta Acting on the Technical Advisory Board for E3 Metals, extracting lithium from formation water. Acted as a Subject Matter Expert for assessing the performance of the Plains Midstream Canada, Empress 1 Deep Cut Straddle Plant in a potential litigation. Acted as an Expert Witness for JL Transportation patent defence of a dense phase technology. Process engineer lead on the addition of the new Orloff gas plant for Deltastream. Also troubleshooted the oil battery shipping pump, plate exchanger and FWKO and treater. Evaluated gas processing and sulphur recovery options for new feeds to the Zhaikmunai Zelenovsky Gas Plant, Kazakhstan (with PM Lucas, Serbia). Completed capacity analysis for hydrocarbon dew point versus liquid recovery of three trains at Birchcliff Pouce Coupe facility including amine unit, refrigerated gas plant and acid gas injection. Completed process design for CO2 flue gas dehydration for Husky Energy Inc (with Status Engineering) Provided simulations of EnCana Foster Creek and Christina Lake and Husky McMullen SAGD facilities (with Vista Projects). Performed process engineering for Cenovus Pelican Lake SAGD pilot (with GRB Engineering) Bear Lake heavy oil polymer injection pilot (with GRB Engineering). Lead process engineer on the design of IEC Kerrobert crude oil micro-refinery (topping plant). Provided engineering support and troubleshooting for Enerchem Slave Lake Crude tower and product blending (with Status Engineering). POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Duration 1 Days 6 CPD hours For the better part of every day, we are communicating to and with others. Whether it?s the speech you deliver in the boardroom, the level of attention you give your spouse when they are talking to you, or the look you give the cat, it all means something. This workshop will help participants understand the different methods of communication and how to make the most of each of them. 1 - Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives 2 - The Big Picture What is Communication? How Do We Communicate? Other Factors in Communication 3 - Understanding Communication Barriers An Overview of Common Barriers Language Barriers Cultural Barriers Differences in Time and Place 4 - Paraverbal Communication Skills The Power of Pitch The Truth about Tone The Strength of Speed 5 - Non-Verbal Communication Understanding the Mehrabian Study All About Body Language Interpreting Gestures 6 - Speaking Like a STAR S = Situation T = Task A = Action R = Result Summary 7 - Listening Skills Seven Ways to Listen Better Today Understanding Active Listening Sending Good Signals to Others 8 - Asking Good Questions Open Questions Closed Questions Probing Questions 9 - Appreciative Inquiry The Purpose of AI The Four Stages Examples and Case Studies 10 - Mastering the Art of Conversation Level One: Discussing General Topics Level Two: Sharing Ideas and Perspectives Level Three: Sharing Personal Experiences Our Top Networking Tips 11 - Advanced Communication Skills Understanding Precipitating Factors Establishing Common Ground Using ?I? Messages 12 - Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations Additional course details: Nexus Humans Communication Strategies 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 Communication Strategies 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.

Microsoft Excel® in Depth: Virtual In-House Training The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. This practical course provides a solid background of the features of Excel and a deeper understanding of its features, benefits and uses. This is not a beginner's course in Excel. You will learn some advanced features such as Pivot Tables, Charting, Tables, Sorting, Filtering and Functions. The goal of this course is to provide a deeper understanding of Excel and its intricacies and a new ability to use it efficiently producing the best solutions for your projects. What you Will Learn You'll learn how to: Use functions like IF, AVERAGE, SUMIF, SUMIFS, SUMPRODUCT, INDEX, MATCH, CHOOSE, DATE, and many more Create meaningful charts Use pivot tables Use Conditional Formatting, Data Validation Take advantage of using Named ranges, do sorting, filtering, tables Getting Started The building blocks of Excel, built-in functions, will be examined The basics of formatting your data will be examined Shortcuts and data manipulation will be explored Built-in features like those mentioned in the 'What you will learn' section above will be explored in detail Excel Functions - VLOOKUP, IF, INDEX, MATCH, CHOOSE, SUMIF, SUMIFS, SUMPRODUCT, DATE, so many more Using Named ranges, Data Validation, Sorting, and Filtering Learn the Name manager; Learn the difference between local and global names; Ensure correct access to linked workbooks; Ensure data accuracy; Learn how to use cascading data validation (for example, once a user chooses 'cars', another cell allows only Ford, Toyota, etc.); Sorting by more than 3 fields; Filtering by font, pattern, or value; See your data based on things like dates in the 3rd quarter, or fields where quantity x price is greater than some fixed value Conditional formatting and data formatting Make relevant data stand out Isolate highs and lows Make error cells invisible Learn about Data bars, Icon sets, and Color scales Highlight differences between worksheets Learn all the codes in the Format/Number list Using cell Styles Learn all about alignment, protection, borders, colors and more Pivot Tables Learn how to summarize large amounts of data with a few clicks Learn various ways of presenting the data Learn the various pivot table tools Learn how to customize and format a pivot table to suit your needs Learn how to group data Learn how to use the various options to present your data Charts Learn how to create a chart with one keystroke! Learn the 11 types of built-in charts Learn how to create a chart with one keystroke! Learn how to customize the charts to make the information tell the right story Learn how to use the design, layout, and formatting available to charts in Excel 2007 Learn embedded charts versus chart sheets Learn how to use modify all the pieces of a chart Array formulas Learn how to use the most powerful formulas in Excel Learn how to combine many formulas into one compact array-formula Learn the real power of these formulas and why regular formulas can't do the job Learn how to use built-in array formulas, like TREND or TRANSPOSE

Enhance your knowledge of natural gas and LNG sales agreements with EnergyEdge course. Enroll now to gain valuable industry knowledge and skills.

Why Learn Rhino 3d and V-ray for Rhino Basic to Intermediate Training Course? Course Link Learn Rhino 3D and V-Ray for Rhino Basic to Intermediate Training Course. Designed for beginners and experienced users, this course empowers you with essential modeling and rendering techniques. Choose between in-person or live online sessions. Duration: 16 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking hours of your choice, available from Mon to Sat between 9 am and 7 pm. London Design Training Course Certified tutors for Rhino 3D and Vray Training - Online, On-Site, or In-Class one to one. Choose from a diverse range of Rhino courses conducted by expert trainers with extensive production experience. Rhino 3D and V-Ray Comprehensive Training Course Duration: 16 hours Course Overview: Learn Rhino 3D and V-Ray with our Basic to Intermediate Training Course. Perfect for beginners, this course equips you with the skills to navigate Rhino's interface, create captivating 3D models, apply textures, and utilize V-Ray for stunning renders. Course Outline: I. Introduction to Rhino 3D and V-Ray (1 hour) Get familiar with Rhino 3D and V-Ray interfaces and essential tools Master viewport navigation with expert controls Understand units and tolerance for precise designs Customize your workspace for seamless workflow II. Creating Basic 3D Objects (3 hours) Craft captivating 3D shapes and objects Edit objects and work with curves for refined designs Explore surfaces and solids for advanced modeling Utilize transformations and copying techniques for enhancements III. Materials and Textures (2 hours) Unleash the power of materials and textures on your designs Apply stunning materials to bring your creations to life Enhance your designs with custom materials for an aesthetic boost IV. Basic Lighting Techniques in V-Ray (2 hours) Discover the magic of lighting with V-Ray for impactful renders Utilize V-Ray lights and HDRI maps for striking lighting effects Adjust lighting settings for impeccable results V. Enhancing Renders with V-Ray Settings (3 hours) Optimize V-Ray render settings for the best output Adjust global illumination and reflection settings for desired looks Elevate renders with dynamic effects like depth of field and motion blur VI. Advanced Modeling Techniques (2 hours) Master advanced modeling tools for intricate shapes Refine curve and surface creation and editing skills Handle solids with Boolean operations and trimming techniques VII. Advanced Lighting Techniques in V-Ray (2 hours) Create and adjust artificial lights for perfect illumination Utilize V-Ray's Sun and Sky system for realism Craft custom HDR images for enhanced lighting VIII. Exporting and Importing (1 hour) Learn file formats for seamless sharing and collaboration Prepare models for 3D printing with best practices Integrate models from other software for a unified workflow IX. Conclusion and Next Steps (30 minutes) Recap course knowledge and highlights Access valuable tips and resources for continuous learning Engage in interactive Q&A for feedback and support Resources: Explore V-Ray with a free trial at: https://www.chaosgroup.com/vray/sketchup/free-trial Access material library at: https://www.vray-materials.de/ Discover textures at: https://textures.com/ Downloads: Download Rhino 7 for Windows for a full 90-day evaluation at: https://www.rhino3d.com Experience Rhino 7 for Mac Evaluation with a user-friendly interface and seamless performance for 90 days. Upon completing the Rhino 3D and V-Ray Basic to Intermediate Training Course, participants can expect to achieve the following learning outcomes: Proficiency in Rhino 3D and V-Ray: Develop a comprehensive understanding of Rhino 3D and V-Ray interfaces, tools, and functionalities, enabling participants to navigate and utilize the software effectively. 3D Modeling Skills: Master the art of creating captivating 3D objects and shapes using Rhino 3D, including editing, transforming, and refining designs for diverse applications. Material Application: Acquire the ability to apply and customize materials and textures to enhance the visual appeal and realism of 3D models, elevating the quality of designs. Lighting Techniques: Gain expertise in utilizing V-Ray lighting tools, such as V-Ray lights and HDRI maps, to achieve striking lighting effects in rendered scenes. Rendering Excellence: Learn to optimize V-Ray render settings, control global illumination, and apply dynamic effects like depth of field and motion blur for high-quality and impressive renders. Advanced Modeling: Develop skills in advanced modeling techniques, including handling curves, surfaces, and solids, enabling participants to tackle complex design challenges. Lighting Mastery: Acquire the knowledge and expertise to create and adjust artificial lights, utilize the Sun and Sky system, and craft custom HDR images for realistic lighting setups. Seamless File Management: Understand various file formats for exporting and importing 3D models, facilitating efficient collaboration and preparation for 3D printing. Creative Problem-Solving: Enhance creative thinking and problem-solving abilities through hands-on practice and exploration of diverse design scenarios. Professional Presentation: Learn post-production techniques in Photoshop to enhance renders and create visually appealing design presentations for effective communication. Continuous Learning: Access valuable resources and tips to encourage continuous learning and professional growth in Rhino 3D and V-Ray.