1096 Courses in Cardiff delivered Live Online

An extended group Zoom session covering the science of wire wheels & some very useful practical applications What you will learn: Part 1: How a wire wheel works Wheel patterns - Radial & tangential, Tramlines & crosses, Exotic patterns Spoke count identification: Easily distinguish between 32 spoke, 36 spoke and 40 spoke wheels instantly, without counting. Part 2: The unique Colwood Wheel Works wheel configuration chart (this will be sent to you by email): How to use it & how to work it all out without the chart. (Hint: it's easier with the chart) Practical use of wheel configurations to work out spoke lengths. Part 3: Weight and how it effects performance. Wheel weight v frame weight. Sprung weight v unsprung weight. There will be a short Q & A time between each part and another Q & A at the end of the course.. The content of this course is relevant to all wire wheels: motorcycles, bicycles, wheelchairs, sulkies, and pretty much every other place where you will find a tensioned wire wheel.

Duration 2 Days 12 CPD hours This course is intended for This course is intended for experienced Oracle Database Administrators, System Administrators, and Developers. Overview Upon completion of this course, the student should be able to: Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area, security area, availability area, performance area, big data and data warehousing area and enhancements in diagnosability area and in sharding area. The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability.

Duration 4 Days 24 CPD hours This course is intended for This in an intermediate level Java development course geared for students experienced with Java 8 or later programming essentials who wish to quickly get up and running with advanced Java skills. This course does not cover Java programming fundamentals. Overview Students will leave this course armed with the required skills to improve their Java applications using sound coding techniques and best practices. This 'skills-centric' course is about 50% hands-on lab and 50% lecture, designed to train attendees in advanced development skills, coupling the most current, effective techniques with the soundest industry practices. Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Develop modular applications in Java Utilize the tooling that is provided in Java 9 to migrate, monitor and optimize applications Use the new JShell tool to quickly test java constructs Understand how the implementation of the String class has been updated to decrease the memory footprint Use the enhancements made to the Concurrency API, working with Completable Future instance of Thread pools Specific Java 9 features that are covered in the course include: The Java Module System (project Jigsaw) JShell Updated try-with-resources Performance enhancements in Java 9 Multi-Release Jar files This fast-track course is designed for experienced developers who have prior working knowledge of basic Java 8 or Java 9 and want to take advantage of the newest features of Java 9 that can help improve performance and functionality of Java 9 applications. You will gain invaluable insight into how to leverage Modules, scale applications into multi-core environments, improve performance, and become a more effective Java 9 developer. Java 9 Updates Review of What is New in Java 9 Milling Project Coin The Java Module system (Jigsaw) Why JigSaw? Introduction to the Module System The Module Descriptor Working with Modules JShell JShell More Java 9 Other New Java 9 Features Performance Optimizations Memory Management (Optional) Multithreading and Concurrency Multithreading Concurrent Java Java 8 Concurrency Updates Reflection and References Introspection and Reflection Reference Objects Effective Java Objects, Declarations, and Initializations Exceptions Writing High-Performance Applications Profiling and Benchmarking Profiling Tools Code Optimization Techniques Code Optimization Myths Design Optimization Techniques

Why Choose Unity 3D Game Design Training Course? Course Link Unity transforms ideas into reality, offering limitless possibilities for 2D and 3D games, VR, AR, and AI experiences. From films to architecture, training videos, and interactive tutorials, Unity revolutionizes industries with its interactive engagement, making it the top choice for solutions. Duration: 10 hrs Method: 1-on-1, Personalized attention Schedule: Tailor your own hours of your choice, available from Mon to Sat between 9 am and 7 pm Is Unity Good for Beginners? Definitely! Unity is an ideal starting point for beginners in game development. It offers an accessible platform to learn state logic and C# programming, making it popular among new programmers. Whether you choose self-guided or structured learning, Unity provides a strong foundation for 3D game development. Coding in Unity? Coding is optional in Unity, thanks to the visual scripting tool, Bolt. Users can implement ideas without coding using flow graphs and state graphs for low-level and high-level logic. Paid tools like PlayMaker and Adventure Creator offer more advanced gameplay and AI behaviors. How Does Unity's Game Engine Work? Unity operates as a versatile scene player, initializing settings for graphics, audio, and input devices at game start. It loads scenes with assets and game objects, executing a cycle that renders scenes, runs physics simulations, and handles events, providing a seamless and dynamic game experience. Is Unity Good for Beginners? Definitely! Unity is an ideal starting point for beginners in game development. It offers an accessible platform to learn state logic and C# programming, making it popular among new programmers. Whether you choose self-guided or structured learning, Unity provides a strong foundation for 3D game development. 10-hour Unity 3D Game Design Training Course: Module 1: Introduction to Unity 3D (2 hours) - What is Unity 3D and why use it for game design? - Understanding the Unity 3D interface - Creating and managing projects in Unity 3D - Importing and managing assets in Unity 3D - Understanding game objects and components in Unity 3D Module 2: Game Mechanics (2 hours) - Basic game mechanics and concepts - Player movement and camera control - Creating and controlling game objects - Working with physics and collision detection - Creating interactive environments Module 3: Scripting with C# (2 hours) - Introduction to C# scripting language - Understanding variables and data types in C# - Creating and using functions in C# - Controlling game objects with C# - Understanding game loops and events Module 4: User Interfaces and Audio (2 hours) - Designing user interfaces in Unity 3D - Creating and using buttons, sliders, and input fields - Audio import and editing in Unity 3D - Creating and controlling game sound effects and background music Module 5: Optimization and Deployment (2 hours) - Understanding game optimization in Unity 3D - Optimizing game performance with scripting - Building and testing games for desktop and mobile platforms - Publishing games on the web or app stores Introduction to Unity: - Introduction to gaming and the game development process - Unity Basics - Interface - Inspector - Project and Hierarchy Starting Making a Game: - Working with Projects - Creating Projects - Importing Geometry - Importing Textures - Using the terrain generator to make the terrain - Creating basic primitives in Unity Materials: - Working with materials 1 - Working with materials 2 - Finishing materials on all objects Lighting: - Creating lights - Adjusting Lights - Creating Sunlight Animation: - Animating objects - Animating lights - Adjusting Animations Audio: - Adding Sound - Interacting with sound - Modifying sound Programming Tools: - JavaScript - Editor for JavaScript - Variables and functions - Simple programming Testing: - Testing the game - Fixing bugs - Making changes in games Building the Game: - Game authoring Settings - Building the game for windows - Playing the game Utilize Unity Pro, the ultimate real-time development platform, to craft 3D, 2D, VR, and AR experiences across diverse industries. From games to auto, AEC, and film, Unity Pro empowers you to create immersive content with multi-platform support. Visit https://www.unity.com/ to kickstart your journey today, enabling faster iterations and business growth through unparalleled development capabilities.

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.

This is a very popular, comprehensive, practical and experiential programme, covering: Assessing risks: Defines and demystifies risk and risk assessment. Risk assessments and a simple scoring system are introduced, and participants carry out assessments. Controlling risks: Cutting risks down, concentrating on the best techniques to control key risks and how to choose the right methods. Understanding your responsibilities: The legal framework; health & safety management systems. Identifying hazards: The main issues any organisation has to deal with: entrances and exits, work traffic, fire, chemicals, electricity, physical and verbal abuse, bullying, stress, noise, housekeeping and the working environment, slips, trips and falls, working at height, computers and manual handling. Investigating accidents and incidents: Why accidents should be investigated, why things go wrong and how to carry out an investigation when they do. Measuring performance: How checking performance can help to improve health & safety. How to develop basic performance indicators. Auditing and proactive and reactive measuring. Protecting the environment: Introduction to waste and pollution. How organisations and individual managers can get involved in cutting down their environmental impacts. The programme enables participants to: Assess and control risks and hazards Understand their own responsibilities for safety and health Investigate incidents Measure their own performance Reflect on good practice and plan how to ensure the safety of the staff for whom they are responsible

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse Administrator Database Administrators Database Designers Support Engineer Technical Administrator Overview Back up, restore, and patch DBCS database deployments Describe the DBaaS and on-premises Oracle Database architectures Manage database instances Manage UNDO data Move data between databases Implement basic backup and recovery procedures Monitor and tune database performance Tune SQL to improve performance Manage resources with Oracle Database Resource Manager Create pluggable databases (PDBs) Configure the Oracle network environment Administer user security and implement auditing Create and manage tablespaces Manage storage space Create and manage Database as a Cloud Service (DBCS) database deployments Register databases and manage performance with Enterprise Manager Cloud Control The Oracle Database 12c R2: Administration Workshop Ed 3 course is designed to provide students with a firm foundation in administration of an Oracle Database. In this course students will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle Database in an effective and efficient manner. Exploring Oracle Database Architecture Introducing Oracle Database Relation Database Models Oracle SQL and PL/SQL Oracle Database Server Architecture Connecting to Oracle Databases Oracle Database Tools Oracle-Supplied User Accounts Querying the Oracle Data Dictionary Managing Database Instances Initialization Parameter Files Starting Up Oracle Databases Shutting Down Oracle Databases Opening and Closing PDBs Working with the Automatic Diagnostic Repository (ADR) Querying Dynamic Performance Views Creating PDBs Methods and Tools to Create PDBs Creating PDBs from Seed with SQL*Plus Cloning PDBs with SQL*Plus Unplugging and Pluggin In PDBs with SQL*Plus Dropping PDBs with SQL*Plus Configuring the Oracle Network Environment Oracle Net Services How Listeners Work Configuring Listeners for Dynamic Service Registration Configuring Listeners for Static Service Registration Configuring Local Naming for Connections Testing Oracle Net Connectivity with tnsping Configuring Communication Between Databases Dedicated Versus Shared Server Configurations Administering User Security Creating Users Granting Privileges Creating and Granting Roles Revoking Privileges and Roles Creating and Assigning Profiles Authenticating Users Assigning Quotas to Users Applying the Principal of Least Privilege Creating and Managing Tablespaces How Table Data is Stored Creating Tablespaces in SQL*Plus Altering and Dropping Tablespaces in SQL*Plus Viewing Tablespace Information in SQL*Plus Implementing Oracle Managed Files Moving and Renaming Online Data Files in SQL*Plus Managing Storage Space Oracle Database Space Management Features Block Space Management Row Chaining and Migration Free Space Management Within Segments Types of Segments Allocating Extents Understanding Deferred Segment Creation Space-Saving Features Managing UNDO Data Undo Data: Overview Transactions and Undo Data Storing Undo Information Comparing Undo Data and Redo Data Managing Undo Local Undo Mode Versus Shared Undo Mode Configuring Undo Retention Categories of Undo Moving Data Moving Data: General Architecture Oracle Data Pump: Overview Oracle Data Pump: Benefits Data Pump Export and Import Clients Data Pump Utility: Interfaces and Modes Data Pump Import: Transformations SQL*Loader Overview Loading Methods Backup and Recovery Concepts DBA Responsibilities Categories of Failure Understanding Instance Recovery Understanding Types of Backups Comparing Complete and Incomplete Recovery Oracle Data Protection Solutions Flashback Technology Monitoring and Tuning Database Performance Managing Performance Activities Performance Planning Considerations Database Maintenance Automatic Workload Repository (AWR) Automatic Database Diagnostic Monitor Performance Monitoring Performance Tuning Methodology Database Server Statistics and Metrics SQL Tuning SQL Tuning Process Oracle Optimizer Optimizer Statistics SQL Plan Directives Adaptive Execution Plans SQL Tuning Advisor SQL Access Advisor SQL Performance Analyzer Oracle Database Resource Manager Oracle Database Resource Manager: Overview Resource Manager Elements Using Resource Manager to Allocate Resources Creating a Simple Resource Plan Creating a Complex Resource Plan Using the Active Session Pool Feature Limiting CPU Utilization at the Database Level Limiting CPU Utilization at the Server Level Enterprise Manager Cloud Control Controlling the Enterprise Manager Cloud Control Framework Starting the Enterprise Manager Cloud Control Framework Stopping the Enterprise Manager Cloud Control Framework Introduction to Oracle Database Cloud Service Oracle Cloud: Overview Database Cloud Service Offerings DBCS Architecture Features and Tooling Additional Database Configuration Options Creating DBCS Database Deployments Automated Database Provisioning Creating a Database Deployment How SSH Key Pairs are Used Creating an SSH Key Pair Storage Used for Database Files Managing DBCS Database Deployments Cloud Tooling Accessing Tools and Features from the DBCS Console Managing the Compute Node Associated With a Database Deployment Managing Network Access to DBCS Enabling Access to a Compute Node Port Scaling a Database Deployment Backing Up and Restoring DBCS Database Deployments Backing Up and Recovering Databases on DBCS Backup Destination Choices Backup Configuration Creating an On-Demand Backup Customizing the Backup Configuration Performing Recovery by Using the Console Performing Recovery by Using the dbaascli Utility Patching DBCS Database Deployments Patching DBCS Using the DBCS Console to Manage Patches Using the dbaascli Utility to Manage Patches Creating Master Encryption Keys for PDBs CDB and PDB Master Encryption Keys Determining Whether You Need to Create and Activate and Encryption Key for a PDB Creating and Activating an Encryption Key Tablespace Encryption by Default Tablespace Encryption by Default in DBCS Transparent Data Encryption (TDE) Overview Components of TDE Using TDE Defining the Keystore Location Controlling Tablespace Encryption by Default Managing the Software Keystore and Master Encryption Key Managing the Keystore in CDBs and PDBs Additional course details: Nexus Humans Oracle Database 12c R2 - Administration Workshop Ed 3 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 Oracle Database 12c R2 - Administration Workshop Ed 3 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.

Duration 3 Days 18 CPD hours This course is intended for The intended audience for this course is experienced web developers who are new to User Experience (UX) and Responsive Design principles. These professionals typically have a solid understanding of front-end development technologies such as HTML, CSS, and JavaScript but seek to expand their skillset to create more user-centric, adaptable, and accessible web experiences. Roles that would benefit from this course include: Front-end Web Developers Full-stack Developers Web Designers Team Leads and Project Managers Freelance Web Developers Overview Working in a hands-on learning environment led by our expert UX coach, you'll learn to: Understand and apply UX principles and user-centered design processes: Participants will learn to identify the needs and preferences of users, create user personas, and apply UX best practices to develop intuitive, user-friendly web experiences. Design and implement responsive web layouts: Participants will gain the skills to create fluid grid layouts, use flexible images, and apply media queries to design web pages that adapt seamlessly across various devices and screen sizes. Optimize web performance for responsive designs: Participants will learn techniques to improve website performance, including image optimization, responsive images, and minification and concatenation of assets, ensuring a fast and smooth user experience across devices. Implement accessible web designs: Participants will understand the importance of accessibility in web design and learn to apply WCAG principles and accessible design patterns to create websites that are usable by a wide range of users, including those with disabilities. Collaborate effectively with designers, developers, and stakeholders: Participants will gain insights into design collaboration and handoff processes, enhancing their ability to communicate design decisions, provide and receive feedback, and work efficiently with team members and clients. In today's fast-paced digital world, user-centric and adaptable websites are no longer a luxury ? they're a necessity. By embracing UX and responsive design, you'll unlock the potential to elevate your websites, boosting user satisfaction and engagement. This, in turn, leads to higher conversion rates and a stronger online presence for your clients or organization, as well as better collaboration within your team, bridging the gap between designers, developers, and stakeholders.UX Design & Responsive Design for Experienced Web Developers is a three day, engaging hands-on workshop designed to equip you with the latest skills and best practices in User Experience (UX) and Responsive Web Design required to create seamless, user-friendly websites that adapt effortlessly across devices. This course will immerse you in the latest skills, best practices, and hands-on activities, empowering you to create exceptional, accessible websites that excel across devices and captivate users. Throughout the program you?ll explore the fundamentals of UX and responsive design, including user-centered design processes, mobile-first and desktop-first approaches, and design techniques for various devices and screen sizes. You'll gain practical experience creating responsive layouts, optimizing performance, and implementing accessible web designs, all while leveraging popular frameworks and design tools. You'll also gain valuable insights into performance optimization, accessibility, and collaboration strategies, ensuring you have the complete toolkit to excel in your field.By the end of this workshop, you?ll have gained a solid understanding of UX and responsive design principles, as well as hands-on experience in applying these concepts to real-world projects. You?ll be able to create more user-friendly, responsive, and accessible websites, and collaborate more effectively with your design and development teams. Introduction to UX and Responsive Design: Understanding User Experience What is UX? Importance of UX in web development UX principles and best practices User-centered design process Responsive Web Design Basics What is Responsive Web Design? Importance of Responsive Design in modern web development Fluid grid layout, flexible images, and media queries Hands-on Activity: Creating a Responsive Layout Designing a simple responsive layout using HTML, CSS, and media queries Breakdown and explanation of the code Testing responsiveness across different devices Mobile-first vs. Desktop-first Approaches Pros and cons of each approach Deciding which approach to use Designing for Different Devices and Screen Sizes Common breakpoints and device considerations Accessibility and usability across devices Typography, color, and other design elements in responsive design Hands-on Activity: Designing for Different Devices Modifying the previously created responsive layout to optimize for various devices Discussion and feedback on designs Advanced UX and Responsive Design Techniques: UX Research and Testing Importance of UX research Usability testing and user feedback A/B testing and heatmaps Navigation and Information Architecture Designing effective and user-friendly navigation Organizing content and information Common navigation patterns in responsive design Hands-on Activity: Designing Navigation for Responsive Websites Adding navigation elements to the previously created responsive layout Testing navigation on different devices and screen sizes Discussion and feedback on navigation designs Responsive Web Design Frameworks and Tools Overview of popular frameworks (Bootstrap, Foundation, etc.) Pros and cons of using frameworks Introduction to design tools (Sketch, Figma, Adobe XD) Hands-on Activity: Exploring Frameworks and Tools Experimenting with a chosen framework or design tool Redesigning the responsive layout using the selected framework/tool Sharing experiences and discussing the benefits and drawbacks UX and Responsive Design Best Practices: Design Patterns and UI Components Common design patterns in responsive web design Designing reusable UI components Consistency and usability in UI components Performance Optimization Importance of performance in responsive design Image optimization and responsive images Minification and concatenation of assets Hands-on Activity: Optimizing Performance (1.5 hours) Applying performance optimization techniques to the responsive layout Testing the improvements in performance Sharing results and discussing best practices Accessibility in UX and Responsive Design Importance of accessibility in web design Accessibility principles (WCAG) Accessible design patterns and techniques Hands-on Activity: Evaluating and Improving Accessibility Assessing the accessibility of the responsive layout Implementing accessibility improvements Testing and discussing the results Design Collaboration and Handoff Collaborating with designers, developers, and stakeholders Effective communication and documentation Design handoff tools and techniques Hands-on Activity: Simulating Design Handoff Participants will work in pairs to simulate a design handoff Reviewing, discussing, and providing feedback on each other's responsive layouts Sharing experiences and lessons learned

Duration 3 Days 18 CPD hours This course is intended for The ideal audience for this course includes database enthusiasts, IT professionals, and developers who are eager to expand their knowledge and skill set in database management and optimization. Roles that would greatly benefit from attending this course include: Database Developers: Those who design, implement, and maintain databases as part of their primary responsibilities and want to improve their expertise in schema design, query optimization, and advanced database features. Backend Developers: Professionals who work on server-side application logic and require a strong understanding of database management to integrate data storage and retrieval processes into their applications. Overview Upon completing this course, database developers will be able to: Design and implement efficient database schemas by employing normalization techniques, appropriate indexing strategies, and partitioning methods to optimize data storage and retrieval processes. Develop advanced SQL queries, including joining multiple tables, utilizing subqueries, and aggregating data, to extract valuable insights and facilitate decision-making processes. Implement stored procedures, functions, and triggers to automate common database tasks, enforce data integrity, and improve overall application performance. Apply database performance tuning techniques, such as query optimization, index management, and transaction control, to ensure optimal resource usage and enhanced system responsiveness. Integrate databases with various programming languages and platforms, enabling seamless data access and manipulation for web, mobile, and desktop applications. PostgreSQL is a powerful, open-source object-relational database management system that emphasizes extensibility, data integrity, and high performance. Its versatility and robust feature set make it an ideal choice for developers working on projects of all sizes, from small-scale applications to enterprise-level systems. By learning PostgreSQL, developers can tap into its advanced capabilities, such as full-text search, spatial data support, and customizable data types, allowing them to create efficient and scalable solutions tailored to their unique needs. PostgreSQL for Database Developers is a three-day hands-on course that explores the fundamentals of database management, covering everything from installation and management to advanced SQL functions. Designed for beginners and enthusiasts alike, this course will equip you with the knowledge and skills required to effectively harness the power of PostgreSQL in today's data-driven landscape. Throughout the course you?ll be immersed in a variety of essential topics, such as understanding data types, creating and managing indexes, working with array values, and optimizing queries for improved performance. You?ll gain valuable hands-on experience with real-world exercises, including the use of the psql client, writing triggers and stored procedures with PL/pgSQL, and exploring advanced SQL functions like Common Table Expressions (CTE), Window Functions, and Recursive Queries. You?ll exit this course with a solid foundation in PostgreSQL, enabling you to confidently navigate and manage your databases with ease and efficiency. Installing & Managing PostgreSQL PostgreSQL installation process Optimal configuration settings User and role management Database backup and restoration Overview of PostgreSQL Database PostgreSQL architecture overview Understanding database objects Efficient data storage Transaction management basics Using the psql client Introduction to psql Essential psql commands Executing queries effectively Managing databases with psql Understanding PostgreSQL data types Numeric data types explored Character and binary types Date, time, and boolean values Array and other types Understanding sequences Sequence creation and usage Customizing sequence behavior Implementing auto-increment columns Sequence manipulation and control Creating & managing indexes PostgreSQL index fundamentals Designing partial indexes Utilizing expression-based indexes Index management techniques Using COPY to load data COPY command overview Importing and exporting data Handling CSV and binary formats Performance considerations Working with Array Values Array value basics Array manipulation functions Querying arrays efficiently Multidimensional array handling Advanced SQL Functions Mastering Common Table Expressions Utilizing Window Functions Regular Expressions in SQL Crafting Recursive Queries Writing triggers & stored procedures with PL/pgSQL PL/pgSQL variables usage Implementing loop operations PERFORM and EXECUTE statements Developing PostgreSQL triggers Using the PostgreSQL query optimizer Query analysis and optimization EXPLAIN command insights PostgreSQL query operators Identifying performance bottlenecks Improving query performance Query performance tuning Index optimization strategies Efficient database partitioning Connection and resource management Wrap Up & Additional Resources Further learning opportunities Staying up-to-date with PostgreSQL Community engagement and support Additional course details: Nexus Humans PostgreSQL for Database Developers (TTDB7024) 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 PostgreSQL for Database Developers (TTDB7024) 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.

Duration 5 Days 30 CPD hours This course is intended for This intermediate and beyond level course is geared for experienced technical professionals in various roles, such as developers, data analysts, data engineers, software engineers, and machine learning engineers who want to leverage Scala and Spark to tackle complex data challenges and develop scalable, high-performance applications across diverse domains. Practical programming experience is required to participate in the hands-on labs. Overview Working in a hands-on learning environment led by our expert instructor you'll: Develop a basic understanding of Scala and Apache Spark fundamentals, enabling you to confidently create scalable and high-performance applications. Learn how to process large datasets efficiently, helping you handle complex data challenges and make data-driven decisions. Gain hands-on experience with real-time data streaming, allowing you to manage and analyze data as it flows into your applications. Acquire practical knowledge of machine learning algorithms using Spark MLlib, empowering you to create intelligent applications and uncover hidden insights. Master graph processing with GraphX, enabling you to analyze and visualize complex relationships in your data. Discover generative AI technologies using GPT with Spark and Scala, opening up new possibilities for automating content generation and enhancing data analysis. Embark on a journey to master the world of big data with our immersive course on Scala and Spark! Mastering Scala with Apache Spark for the Modern Data Enterprise is a five day hands on course designed to provide you with the essential skills and tools to tackle complex data projects using Scala programming language and Apache Spark, a high-performance data processing engine. Mastering these technologies will enable you to perform a wide range of tasks, from data wrangling and analytics to machine learning and artificial intelligence, across various industries and applications.Guided by our expert instructor, you?ll explore the fundamentals of Scala programming and Apache Spark while gaining valuable hands-on experience with Spark programming, RDDs, DataFrames, Spark SQL, and data sources. You?ll also explore Spark Streaming, performance optimization techniques, and the integration of popular external libraries, tools, and cloud platforms like AWS, Azure, and GCP. Machine learning enthusiasts will delve into Spark MLlib, covering basics of machine learning algorithms, data preparation, feature extraction, and various techniques such as regression, classification, clustering, and recommendation systems. Introduction to Scala Brief history and motivation Differences between Scala and Java Basic Scala syntax and constructs Scala's functional programming features Introduction to Apache Spark Overview and history Spark components and architecture Spark ecosystem Comparing Spark with other big data frameworks Basics of Spark Programming SparkContext and SparkSession Resilient Distributed Datasets (RDDs) Transformations and Actions Working with DataFrames Spark SQL and Data Sources Spark SQL library and its advantages Structured and semi-structured data sources Reading and writing data in various formats (CSV, JSON, Parquet, Avro, etc.) Data manipulation using SQL queries Basic RDD Operations Creating and manipulating RDDs Common transformations and actions on RDDs Working with key-value data Basic DataFrame and Dataset Operations Creating and manipulating DataFrames and Datasets Column operations and functions Filtering, sorting, and aggregating data Introduction to Spark Streaming Overview of Spark Streaming Discretized Stream (DStream) operations Windowed operations and stateful processing Performance Optimization Basics Best practices for efficient Spark code Broadcast variables and accumulators Monitoring Spark applications Integrating External Libraries and Tools, Spark Streaming Using popular external libraries, such as Hadoop and HBase Integrating with cloud platforms: AWS, Azure, GCP Connecting to data storage systems: HDFS, S3, Cassandra, etc. Introduction to Machine Learning Basics Overview of machine learning Supervised and unsupervised learning Common algorithms and use cases Introduction to Spark MLlib Overview of Spark MLlib MLlib's algorithms and utilities Data preparation and feature extraction Linear Regression and Classification Linear regression algorithm Logistic regression for classification Model evaluation and performance metrics Clustering Algorithms Overview of clustering algorithms K-means clustering Model evaluation and performance metrics Collaborative Filtering and Recommendation Systems Overview of recommendation systems Collaborative filtering techniques Implementing recommendations with Spark MLlib Introduction to Graph Processing Overview of graph processing Use cases and applications of graph processing Graph representations and operations Introduction to Spark GraphX Overview of GraphX Creating and transforming graphs Graph algorithms in GraphX Big Data Innovation! Using GPT and Generative AI Technologies with Spark and Scala Overview of generative AI technologies Integrating GPT with Spark and Scala Practical applications and use cases Bonus Topics / Time Permitting Introduction to Spark NLP Overview of Spark NLP Preprocessing text data Text classification and sentiment analysis Putting It All Together Work on a capstone project that integrates multiple aspects of the course, including data processing, machine learning, graph processing, and generative AI technologies.