2176 Courses in Cardiff delivered Live Online

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

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.

Why Choose Complete Rhino 3D and V-Ray Training Program: Basic to Intermediate? Learn Rhino 3D and V-Ray for Rhino Basic to Intermediate Training Course. Suitable for beginners and experienced users alike, this program equips you with vital modeling and rendering skills. Opt for in-person or live online sessions. Click here for more info: Website Duration: 16 hours. Approach: 1-on-1 Sessions, Customized Content and Flexible Learning. Scheduling Flexibility: Tailor your sessions from Mon to Sat between 9 am and 7 pm. Course Title: Complete Rhino 3D and V-Ray Training Program: Basic to Intermediate - 16 Hours Session 1-2: Introduction to Rhino 3D Basics (2 hours) Understanding Rhino Interface: Navigating toolbars, command line, and properties panel. Basic Geometric Shapes: Creating lines, circles, and polygons with precision. Editing Tools: Mastering move, rotate, scale, and mirror commands. Session 3-4: Advanced Rhino 3D Modeling Techniques (2 hours) Curves and Surfaces: Delving into NURBS curves, creating complex surfaces, and blending techniques. Modeling Aids: Utilizing grids, snaps, and construction planes for accuracy. Organizing with Layers: Managing complex projects efficiently. Session 5-6: Introduction to V-Ray for Rhino (2 hours) V-Ray Interface: Understanding V-Ray toolbar and settings. Basic Lighting: Exploring different light types and their effects on scenes. Materials: Creating realistic materials, understanding diffuse, reflection, and transparency. Session 7-8: Intermediate V-Ray Concepts (2 hours) Advanced Lighting: Mastering HDRI lighting, creating natural outdoor lighting scenarios. Texture Mapping: Understanding UV mapping, applying textures seamlessly. Rendering Optimization: Reducing noise, optimizing settings for quicker, high-quality renders. Session 9-10: Rhino-V-Ray Integration (2 hours) Model Preparation: Optimizing Rhino models for V-Ray rendering. Advanced Material Manipulation: Creating complex materials, incorporating textures. Interactive Rendering: Real-time adjustments for immediate feedback. Session 11-12: Advanced Modeling Techniques in Rhino (2 hours) Advanced Surface Modeling: Creating organic shapes, advanced surfacing techniques. Precision Modeling: Advanced curve editing, filleting, and trimming. Working with 3D Text: Creating custom 3D text for design projects. Session 13-14: Scene Composition and Presentation (2 hours) Camera Settings: Understanding focal length, depth of field, and perspective. Scene Composition: Design principles, rule of thirds, focal points, and balance. Post-Processing: Enhancing renders in Photoshop, adding atmosphere and context. Session 15-16: Final Project and Portfolio Review (2 hours) Final Project Work: Participants apply learned skills to create a complex 3D scene. Instructor-led Critique: Feedback session for final projects. Portfolio Guidance: Tips for selecting the best works for a professional portfolio. By the end of this 16-hour course, participants will have a deep understanding of both Rhino 3D and V-Ray, allowing them to create intricate 3D models and produce high-quality, realistic renders for various applications. 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. Skills You'll Gain: Master Rhino 3D basics: Curves, surfaces, modeling aids, and precision techniques. Explore intermediate V-Ray concepts: Advanced lighting, material manipulation, and texture mapping. Understand Rhino-V-Ray integration for seamless 3D modeling and rendering workflows. Optimize render settings for high-quality output and reduced rendering times. Career Opportunities: Upon completing this program, you'll be prepared for various roles in the design and visualization industry, such as: 3D Modeler: Create detailed 3D models for diverse industries, including architecture and product design. Architectural Visualizer: Produce realistic architectural visualizations for presentations and marketing materials. Product Designer: Develop visually appealing product prototypes and visualizations for marketing and manufacturing. Visualization Specialist: Work in design studios, advertising agencies, or game development companies, creating immersive visual content. Freelance Designer: Offer your skills on platforms like Upwork or Fiverr, providing 3D modeling and rendering services to clients worldwide. Solidify Rhino 3D Expertise: Master foundational modeling skills, including intricate geometries and surface manipulation, establishing a robust foundation for your 3D design journey. Unlock V-Ray for Rhino: Explore the potential of V-Ray for Rhino, learning to create mesmerizing visualizations and achieve lifelike rendering results that bring vitality to your designs. Enhance Visual Appeal: Grasp advanced lighting techniques, material application, and texture methods to elevate the visual allure of your 3D creations, making them more immersive and authentic. Explore Advanced Concepts: Delve into optimizing rendering settings, post-production tactics, and efficient workflows, advancing your design proficiency to higher levels. Hands-On Experience: Engage in practical exercises and real-world projects, applying your skills in practical contexts to enrich your portfolio and showcase your capabilities effectively. Certification of Achievement: Receive a valuable Certificate of Completion, confirming your expertise in Rhino 3D and V-Ray for Rhino, enhancing your professional credibility as a skilled designer. Flexible Learning Paths: In-Person or Live Online: Opt for in-person sessions, fostering collaborative learning, or choose live online classes for convenience and accessibility, tailoring your learning experience to your preferences. Personalized Guidance: Regardless of your chosen format, benefit from tailored instruction and guidance, ensuring optimal learning outcomes and continuous support throughout the course.

This intensive one-day training programme has been developed to help those involved in producing specifications create high quality documents in an organised and effective way. The programme explains the primary purpose of specifications and the importance of understanding the context in which they are used. It focuses particularly on how to develop and structure content and write requirements that are clear and concise. The methods and techniques presented will provide a practical foundation course for those new to the topic whilst offering new insights to those with more experience. The objectives of the workshop are to: Review and discuss the role and purpose of specifications Present a structured approach for organising and producing specifications Explain each of the key steps involved in creating effective specifications Review some methods for assisting in defining requirements Explain how to define the scope and develop the structure for a specification Present methods to assist the writing and editing of specifications Review how specifications should be issued and controlled 1 Introduction Course objectives Review of participants' needs and objectives 2 Specifications in perspective The role and purpose of specifications The impact of specifications on commercial performance The qualities of an effective specification The five key steps of 'POWER' writing: prepare-organise-write-edit-release 3 Step 1: Preparing to write Defining the purpose the specification; integrating the specification and contract Deciding how to specify: when to specify in functional and technical terms Getting the right people involved at the right time; engaging stakeholders Applying procedures for writing, issuing and controlling specifications 4 Step 2: Organising the specification content Scoping the document: scope maps, check lists, structured brainstorming Clarifying requirements; separating needs and desires Dealing with requirements that are difficult to quantify Useful techniques: cost benefit analysis, Pareto analysis Deciding what goes where; typical contents and layout for a specification Creating and using model forms: typical sections and sub sections 5 Step 3: Writing the specification Identifying and understanding the readers needs Choosing and using the right words; dealing with jargon Important words; will, shall, must; building a glossary Using sentence structure and punctuation to best effect Understanding the impact of style, format and appearance Avoiding common causes of ambiguity; being concise and ensuring clarity 6 Step 4: Editing the specification Why editing is difficult; how to develop a personal editing strategy Key areas to review: structure, content, accuracy, clarity, style and grammar Editing tools and techniques 7 Step 5: Releasing and controlling the specification Key requirements for document issue and control Final formatting and publication issues; document approval Requirements management: managing revisions and changes 8 Course review and action planning What actions should be implemented to improve specifications? Conclusion

InDesign face to face training customised and bespoke.

Autocad face to face training customised and bespoke.

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course is as follows:Anyone interested in knowing about DNA Center and SD-AccessPersonnel involved in SD-Access Design and ImplementationNetwork Operations team with SD-Access solutionNetwork admin staff that deal with User AccessChannel Partner SEs and other sales supportNetwork Access Control administrationNetwork AdministratorsNetwork ArchitectsNetwork Engineers Overview Upon completing this course, the learner will be able to meet these overall objectives:Know and understand Cisco?s SD-Access concepts, features, benefits, terminology and the way this approach innovates common administrative tasks on today?s networks.Differentiate and explain each of the building blocks of SD-Access SolutionExplain the concept of ?Fabric? and the different node types that conform it (Fabric Edge Nodes, Control Plane Nodes, Border Nodes)Describe the role of LISP in Control Plane and VXLAN in Data Plane for SD-Access SolutionUnderstand the role of DNA Center as solution orchestrator and Intelligent GUIBe familiar with workflow approach in DNA Center and its 4 Steps: Design, Policy, Provision and Assurance DNA Center and SD-Access offer Cisco?s next-generation programmable digital network to help automate common network access security features and streamline the redundant, complex configuration required to allow different groups of users access to the network infrastructure. This network security training course allows network administrators to quickly allow differentiated access for end users on the network while allowing the network to react automatically to day zero and other types of attacks. Introduction to Cisco?s Software Defined Access (SD-Access) SD-Access Overview SD-Access Benefits SD-Access Key Concepts SD-Access Main Components SD-Access Campus Fabric The concept of Fabric Node types Fabric Edge Nodes Control Plane Nodes Border Nodes LISP as protocol for Control Plane VXLAN as protocol for Data Plane Concept of Virtual Network Fabric-enabled WLAN DNA Center and Workflow for SD-Access Introduction to DNA Center Workflow for SD-Access in DNA Center Integration with Cisco ISE for Policy Enforcement Integration with Cisco NDP for Analytics and Assurance Relationship with APIC-EM controller DNA Center Workflow First Step - Design Creating Enterprise and Sites Hierarchy Discuss and Demonstrate General Network Settings Loading maps into the GUI IP Address Administration Administering Software Images Network Device Profiles DNA Center Workflow Second Step - Policy 2-level Hierarchy Policy Types ISE Integration with DNA Center Cross Domain Policies DNA Center Workflow Third Step - Provision Devices Onboarding Fabric Domains Adding Nodes DNA Center Workflow Fourth Step ? Assurance Introduction to Analytics NDP Fundamentals Overview of DNA Assurance Components of DNA Assurance DNA Center Assurance Dashboard Implementing WLAN in SD-Access Solution WLAN Integration Strategies in SD-Access Fabric SD-Access Wireless Architecture Sample Design for SD-Access Wireless Campus Fabric External Connectivity for SD-Access Enterprise Sample Topology for SD-Access Role of Border Nodes Types of Border Nodes Single Border vs. Multiple Border Designs Collocated Border and Control Plane Nodes Distributed (separated) Border and Control Plane Nodes

Why Learn Vray for Maya Training Course? Course info. Become a V-Ray for Maya expert with our training course. Led by certified tutors, you'll master lighting, shading, and rendering techniques to create stunning visual effects and animations. In-person or live online sessions, access recorded lessons, and receive lifetime email support. Duration: 10 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. Maya - Advanced Rendering with V-Ray Course Description: VRay Course for Maya to learn advanced rendering techniques and create stunning photo-realistic renderings. Gain access to all project and source files, allowing you to practice and perfect your skills. Key Details: Advanced Rendering Techniques: Learn advanced rendering methods using V-Ray in Maya. Photo-Realistic Renderings: Create stunning, lifelike renderings that closely resemble real-world images. VRay Course: Access a detailed step-by-step instruction to master VRay rendering in Maya. Project and Source Files: Get hands-on practice with all the necessary files provided. Skill Level: Designed for intermediate to advanced Maya users seeking to enhance their rendering capabilities. Instructor-led: Benefit from expert guidance and insights from experienced instructors. Flexible Learning: Study at your own pace and convenience. Realistic Visuals: Take your rendering skills to the next level and achieve professional-grade results. Course Modules: Module 1: Introduction to Vray for Maya (2 hours) Understand Vray's significance and benefits in Maya Install and set up Vray for Maya Familiarize with the Vray interface and workflow Learn about Vray materials and their usage in Maya Module 2: Lighting with Vray (2 hours) Explore various lighting techniques with Vray in Maya Work with different types of Vray lights and their settings Create outdoor scenes with Vray sun and sky Utilize Vray dome lighting for interior scenes Introduction to IES lights and their usage in Vray for Maya Module 3: Vray Camera (2 hours) Master Vray camera settings and their impact on the render Control exposure and use Vray depth of field Create camera animations with Vray for dynamic shots Utilize Vray frame buffer for post-processing Module 4: Vray Materials (2 hours) Understand Vray material properties and settings Create realistic materials using Vray Save and organize custom Vray material libraries Utilize Vray material overrides for efficient changes Module 5: Vray Rendering and Post Production (2 hours) Optimize Vray rendering settings for high-quality output Render still images and animations using Vray Enhance Vray renders in Photoshop with post-production techniques Utilize Vray frame buffer for fine-tuning the render Composit Vray render elements in Photoshop for added control Reduce noise in renders with Vray denoiser V-Ray for Maya Trial - Free Download Chaos Group https://www.chaos.com â€º vray › maya › free-trial V-Ray for Maya. Add realism to your VFX and animation projects. Try free for 30 days. Download trial. Master Vray for Maya to create high-quality renders. Apply various lighting techniques for realistic and visually appealing scenes. Control Vray camera settings and create dynamic shots. Create and customize realistic Vray materials for 3D scenes. Optimize rendering settings for high-quality output. Enhance renders with post-production techniques in Photoshop. Establish an efficient workflow with Vray in Maya. Gain hands-on experience and access valuable resources for further practice.

Face to face training customised and bespoke. Online or Face to Face

P901 - Management and control of building hot and cold water services is there to provide background and an overview of the risk of Legionella infection and how it can be controlled in domestic type hot and cold water systems. (This course is also a pre-requirement before undertaking course P903 - Management and Control of Evaporative Cooling Systems and other High Risk Industrial Systems or P904 - Management and Control in Leisure, Display, Therapy and other Non-Industrial Systems.)