448 Character courses in Cardiff delivered Live Online

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

Relationships play a pivotal role in our life satisfaction. By uncovering the root cause of our dissatisfaction in relation to others, we can become more fulfilled and enjoy a fuller life.

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

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

LOOKING FOR: MG, YA AND ADULT SCI-FI / FANTASY, CHILDREN'S NON-FICTION After graduating from St Andrews University with a degree in English Literature and Art History, Maddy followed her love of literature to an internship at non-fiction literary agency Graham Maw Christie. At GMC, Maddy worked her way up to Agent and built a list of authors who wrote for both for adults and children, spanning history, tarot, and nature writing. An avid reader of anything magical, Maddy joined Madeleine Milburn in 2022 to build a list specialising in SFF. Maddy would like to see SFF across all genres for all ages, including: grim dark, thriller, historical, romance, cosy fantasy, sci-fi, epic, YA fantasy, dark academia, contemporary fantasy, fantasy middle-grade, mythology, fairy tale and queer fantasy. Inspiring children’s non-fiction. She loves worlds to get lost in, adventures that transform what it means to be a hero, and unique magic that offers as many problems as solutions. She likes books that make her cry and books that change her mind. Above all, when she finishes a story about another world, she wants it to have taught her a lesson which helps her live in this one. She loves all fantasy, but favours richly imagined, complex worlds with a history to discover and a future to protect. Worldbuilding is one of her favourite aspects of this genre and she is always looking for a new, dense world with series potential. Think Brandon Sanderson’s Cosmere or the Marvel Cinematic Universe – the bigger the better! Maddy also likes character-driven fantasy with a diverse cast to root for (or root against) and she wants to see a range of different relationships depicted authentically. She particularly like epics that dip into big, universal themes such as grief, climate change, or war and which ask impossible questions in the vein of R.F. Kuang or N.K. Jemisin. She is also excited by authors that play with form and language in a fantasy setting. In YA, she is looking for much the same as in an adult fantasy, but with younger protagonists and a closer focus on relationships. She wants to see the tropes she knows and loves in new and exciting forms and her favourite YA books often centre around belonging and becoming. She likes a dash of romance in everything, because she is sentimental that way, but it’s particularly important in the YA space. Sci-fi is a big passion of hers, especially when it comes with a strong hook. She is a huge fan of Becky Chamber’s The Long Way to a Small Angry Planet and Michaiah Johnson’s The Space Between Worlds. She likes space as a metaphor, and would love something that explores different alien species. Please send her your space operas and sci-fi romances which combine space, magic and mayhem! In fantasy middle grade, she favours whimsy and animal companions; she would love to follow a group of kids through magic school. She tends to look for plenty of humour with a strong friendship at the centre, and she wants middle grade stories which engage with the concerns of children growing up as well as offering an all-important escape (preferably on a dragon/unicorn’s back). She is also looking for children’s non-fiction for all ages. In this space, she wants something as creative as it is informative, and thinks diverse voices are increasingly important. Maddy would like you to submit a covering letter, one page synopsis and the first three chapters (Max 5000 words) of your completed manuscript in a single word document. (In addition to the paid sessions, Maddy is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Friday 11th July 2025

Why Learn Adobe InDesign Advanced Training Course? Master Adobe InDesign for efficient page layouts with our advanced course. Learn document setup, text formatting, and special effects. Suitable for beginners and advanced users. London Design Training Course provides top InDesign course with Adobe Certified Instructors. Course Link 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 Flexible Learning Options: Choose between in-class training at our London center or participate online. Both options provide hands-on, practical learning with step-by-step demonstrations and ample opportunities for questions. Introduction to InDesign: Exploring InDesign Basics Customizing Preferences and Workspace Navigating Panels and Windows Setting Up Toolbar and Properties Panel Document Management: New Document, Pages, and Order Quick Navigation Techniques with Shortcuts Smart Layout: Organizing Layouts with Guides and Grids Understanding Bleed, Slug, and Margins Utilizing Smart Guides for Precision Typography: Mastering the Type Tool Adding Text to Pages and Using Placeholder Text Text Formatting with Character and Paragraph Controls Editing Text Frames and Justifying Text Multi-column Setup and Styling with Character/Paragraph Styles Working with Bullet Points and Numbering Working with Images: Creating Frames and Placing Images Content Fitting Options: Proportional Fit, Content-Aware Fit, Auto-Fit Manipulating Frame Properties: Fill, Stroke, Effects Utilizing Object Styles for Consistent Frames Advanced Techniques: Image Frame Grids, Merging Frames, Text Wrap Options Understanding Image Formats and Resolution Tabs and Alignment: Mastering Tab Palette and Alignment Options Adding Leaders for Enhanced Formatting Color Theory and Editing: Basics of Color Theory and Color Modes Creating Color Themes with the Color Theme Tool Swatches, Color Libraries, and Gradients Editing Gradient Fills and Colors Advanced Interactive Actions: Adding Animation Effects with Animation Panel Fine-tuning Animations with Timing Panel Creating Complex Object States and Action Buttons Adding and Testing Hyperlinks, Page Transitions Parent Page Basics: Understanding Parent Pages Page Numbering, Order, Headers, and Footers Inserting Text Variables for Dynamic Content Advanced Object Styles and Effects: Opacity Control and Blending Modes Black and White Conversion, Color Blending Modes Adding Dimension with Bevel and Emboss Effects Advanced Text Frame Options: Auto-sizing Text Frames and Balancing Column Height Inset Spacing and Fill Colors for Text Boxes Hot Corner Resizing Shortcuts and Anchor Objects Footnotes: Purpose and Usage of Footnotes Adding, Editing Footnotes with Footnote Options By the end of this Adobe InDesign training, participants will: Understand InDesign basics and its interface. Create effective page layouts with text formatting and image placement. Work with layers, apply special effects, and manage tables. Ensure error-free and print-ready documents through preflighting. Receive a practical training guide and an e-certificate upon completion.

Integrating UNIX and Microsoft course description This course is designed for the enterprise-level UNIX professional and represents the highest level of professional, distribution-neutral UNIX certification within the industry. It covers administering UNIX enterprise-wide with an emphasis on mixed environments. What will you learn Configure and troubleshoot OpenLDAP. Use OpenLDAP as an authentication backend. Manage software packages. Use Samba - Share configuration - User and group management - Domain integration - Name services - with Linux and Windows clients Integrating UNIX and Microsoft course details Who will benefit: Enterprise-level UNIX professionals. Prerequisites: UNIX network administration. Duration 5 days Integrating UNIX and Microsoft course contents OPENLDAP CONFIGURATION OpenLDAP replication Replication concepts, OpenLDAP replication, replication log files, replica hubs, LDAP referrals, LDAP sync replication. Securing the Directory Securing the directory with SSL and TLS, Firewall considerations, Unauthenticated access methods, User/password authentication methods, Maintanence of SASL user DB, certificates. OpenLDAP Server Performance Tuning Measure OpenLDAP performance, Tune software configuration to increase performance, indexes. OPENLDAP AS AN AUTHENTICATION BACKEND LDAP Integration with PAM and NSS Configure PAM to use LDAP for authentication, NSS to retrieve information from LDAP and PAM modules in UNIX. Integrating LDAP with Active Directory and Kerberos Kerberos integration with LDAP, Cross platform authentication, Single sign-on concepts, Integration and compatibility limitations between OpenLDAP and Active Directory. SAMBA BASICS Samba Concepts and Architecture Samba daemons and components, key issues regarding heterogeneous network, Identify key TCP/UDP ports used with SMB/CIFS, Knowledge of Samba3 and Samba4 differences. Configure Samba Samba server configuration file structure, variables and configuration parameters, Troubleshoot and debug configuration problems. Regular Samba Maintenance Monitor and interact with running Samba daemons, Perform regular backups of Samba configuration and state data. Troubleshooting Samba Samba logging, Backup TDB files, Restore TDB files, Identify TDB file corruption, Edit / list TDB file content. Internationalization Internationalization character codes and code pages, differences in the name space between Windows and Linux/Unix with respect to share, names, user/group/computer naming in a non-English environment. SAMBA SHARE CONFIGURATION Linux File System and Share/Service Permissions File / directory permission control, Samba interaction with Linux file system permissions and ACLs, Use Samba VFS to store Windows ACLs. Print Services Printer sharing, integration between Samba and CUPS, Manage Windows print drivers and configure downloading of print drivers, security concerns with printer sharing. SAMBA USER AND GROUP MANAGEMENT Managing User Accounts and Groups User and group accounts, mappings, user account management tools, smbpasswd, file/directory ownership of objects. Authentication, Authorization and Winbind Local password database, password synchronization, passdb backends, Convert between passdb backends, Integrate Samba with LDAP, Winbind service, PAM and NSS. SAMBA DOMAIN INTEGRATION Samba as a PDC and BDC Domain membership and trust relationships, Create and maintain a PDC and BDC with Samba3/4, Add computers to an existing domain, logon scripts, roaming profiles, system policies. Samba4 as an AD compatible Domain Samba 4 as an AD DC, smbclient, how Samba integrates with AD services: DNS, Kerberos, NTP, LDAP. Configure Samba as a Domain Member Server Joining Samba to NT4 and AD domains, obtain a TGT from a KDC. SAMBA NAME SERVICES NetBIOS and WINS WINS concepts, NetBIOS concepts, local master browser, domain master browser, Samba as a WINS server, name resolution, WINS replication, NetBIOS browsing and browser elections, NETBIOS name types. Active Directory Name Resolution DNS for Samba4 as an AD Domain Controller, DNS forwarding with the internal DNS server of Samba4. WORKING WITH LINUX AND WINDOWS CLIENTS CIFS Integration SMB/CIFS concepts, remote CIFS shares from a Linux client, securely storing CIFS credentials, features and benefits of CIFS, permissions and file ownership of remote CIFS shares. Working with Windows Clients browse lists and SMB clients from Windows, Share file/print resources from Windows, the smbclient program, the Windows net utility.

Integrating Linux and Microsoft course description This course is designed for the enterprise-level Linux professional and represents the highest level of professional, distribution-neutral Linux certification within the industry. LPIC-3 300 covers administering Linux enterprise-wide with an emphasis on mixed environments. What will you learn Configure and troubleshoot OpenLDAP. Use OpenLDAP as an authentication backend. Manage software packages. Use Samba - Share configuration - User and group management - Domain integration - Name services - with Linux and Windows clients Integrating Linux and Microsoft course details Who will benefit: Enterprise-level Linux professionals. Prerequisites: Delegates must have an active LPIC-2 certification to receive LPIC-3 certification, but the LPIC-2 and LPIC-3 exams may be taken in any order. Duration 5 days Integrating UNIX and Microsoft course contents OPENLDAP CONFIGURATION OpenLDAP replication Replication concepts, OpenLDAP replication, replication log files, replica hubs, LDAP referrals, LDAP sync replication. Securing the Directory Securing the directory with SSL and TLS, Firewall considerations, Unauthenticated access methods, User/password authentication methods, Maintanence of SASL user DB, certificates. OpenLDAP Server Performance Tuning Measure OpenLDAP performance, Tune software configuration to increase performance, indexes. OPENLDAP AS AN AUTHENTICATION BACKEND LDAP Integration with PAM and NSS Configure PAM to use LDAP for authentication, NSS to retrieve information from LDAP and PAM modules in UNIX. Integrating LDAP with Active Directory and Kerberos Kerberos integration with LDAP, Cross platform authentication, Single sign-on concepts, Integration and compatibility limitations between OpenLDAP and Active Directory. SAMBA BASICS Samba Concepts and Architecture Samba daemons and components, key issues regarding heterogeneous network, Identify key TCP/UDP ports used with SMB/CIFS, Knowledge of Samba3 and Samba4 differences. Configure Samba Samba server configuration file structure, variables and configuration parameters, Troubleshoot and debug configuration problems. Regular Samba Maintenance Monitor and interact with running Samba daemons, Perform regular backups of Samba configuration and state data. Troubleshooting Samba Samba logging, Backup TDB files, Restore TDB files, Identify TDB file corruption, Edit / list TDB file content. Internationalization Internationalization character codes and code pages, differences in the name space between Windows and Linux/Unix with respect to share, names, user/group/computer naming in a non-English environment. SAMBA SHARE CONFIGURATION Linux File System and Share/Service Permissions File / directory permission control, Samba interaction with Linux file system permissions and ACLs, Use Samba VFS to store Windows ACLs. Print Services Printer sharing, integration between Samba and CUPS, Manage Windows print drivers and configure downloading of print drivers, security concerns with printer sharing. SAMBA USER AND GROUP MANAGEMENT Managing User Accounts and Groups User and group accounts, mappings, user account management tools, smbpasswd, file/directory ownership of objects. Authentication, Authorization and Winbind Local password database, password synchronization, passdb backends, Convert between passdb backends, Integrate Samba with LDAP, Winbind service, PAM and NSS. SAMBA DOMAIN INTEGRATION Samba as a PDC and BDC Domain membership and trust relationships, Create and maintain a PDC and BDC with Samba3/4, Add computers to an existing domain, logon scripts, roaming profiles, system policies. Samba4 as an AD compatible Domain Samba 4 as an AD DC, smbclient, how Samba integrates with AD services: DNS, Kerberos, NTP, LDAP. Configure Samba as a Domain Member Server Joining Samba to NT4 and AD domains, obtain a TGT from a KDC. SAMBA NAME SERVICES NetBIOS and WINS WINS concepts, NetBIOS concepts, local master browser, domain master browser, Samba as a WINS server, name resolution, WINS replication, NetBIOS browsing and browser elections, NETBIOS name types. Active Directory Name Resolution DNS for Samba4 as an AD Domain Controller, DNS forwarding with the internal DNS server of Samba4. WORKING WITH LINUX AND WINDOWS CLIENTS CIFS Integration SMB/CIFS concepts, remote CIFS shares from a Linux client, securely storing CIFS credentials, features and benefits of CIFS, permissions and file ownership of remote CIFS shares. Working with Windows Clients browse lists and SMB clients from Windows, Share file/print resources from Windows, the smbclient program, the Windows net utility.

Mastering 3ds Max and Photoshop Training Course. earn 3D design, modeling, and rendering with 3ds Max, and seamlessly integrate Photoshop skills. Expert instructors guide you in enhancing images and creating stunning renderings. Our 3ds Max course is designed to help you learn basic and advanced architectural visualisation. Click here for more info: Website Duration: 20 hours Approach: 1-on-1, Customized and Flexible pacing. Session Flexibility: Design your own timetable at your convenient hour between 9 am and 7 pm, Mon to Sat. 20-Hour Comprehensive Training in 3ds Max and Photoshop. Course Breakdown: Module 1: Introduction to 3ds Max (6 hours) Familiarization with 3ds Max's interface and workspace Navigation and basic modeling tools usage Creation and manipulation of primitive objects Object modification with modifiers for specific effects Materials, textures, and basic lighting techniques Introduction to rendering 3D scenes Module 2: Intermediate 3ds Max Techniques (6 hours) Advanced modeling with splines and polygons Camera creation and animation for realistic perspectives Character rigging and animation using bones Particle systems for visual effects and dynamic simulations Designing landscapes and outdoor scenes Exploration of advanced lighting and rendering methods Module 3: Introduction to Photoshop for 3D Artists (4 hours) Understanding Photoshop interface and essential editing tools Seamless integration of 3D models and textures between 3ds Max and Photoshop Creation and editing of textures and materials for realistic surfaces Post-production and compositing techniques to enhance 3D renders Module 4: Advanced Photoshop Techniques for 3D Artists (4 hours) Custom brush and texture creation for artistic elements Non-destructive editing using layer masks and adjustment layers Advanced compositing for seamless 3D element integration Crafting photorealistic textures and materials for impressive visuals Module 5: Project-Based Learning (4 hours) Application of learned techniques to a real-world project 3D modeling, texturing in Photoshop, and final image rendering Instructor feedback for project refinement Presentation of completed projects, showcasing acquired skills. Attendees will learn to craft intricate 3D models using Autodesk 3ds Max, mastering primitive objects, splines, and polygons for complex designs. Advanced Rendering Techniques: Participants will acquire skills in texturing, material application, lighting strategies, and rendering tools, crafting visually striking and lifelike 3D environments. Animation Prowess: Students will delve into object and character animation, simulation of perspectives with cameras, and the dynamic use of particle systems for visual effects and simulations. Essential Photoshop Proficiency: Attendees will gain vital Photoshop skills for post-processing, compositing 3D renders, and creating realistic textures, enhancing the quality of their 3D projects. Hands-On Project Engagement: Through practical projects, participants will receive expert feedback, honing their skills and demonstrating their expertise in real-world applications. Creative Problem-Solving Abilities: Attendees will cultivate creative thinking and problem-solving skills, enabling them to manifest their unique artistic visions in their 3D projects. Skills Acquired: Participants in the Mastering 3ds Max and Photoshop Training Course will gain advanced proficiency in 3D modeling, texturing, lighting, and rendering using 3ds Max. Additionally, they will master digital image manipulation, graphic design, and photo editing techniques using Photoshop. Key skills include: Advanced 3D Modeling and Rendering in 3ds Max Expert Texturing and Lighting Techniques Digital Image Manipulation and Retouching in Photoshop Graphic Design and Visual Communication Skills Job Opportunities: Upon completion, individuals can pursue a range of exciting career opportunities, including: Senior 3D Artist Game Developer Architectural Visualization Specialist Graphic Designer Visual Effects Artist This course equips participants with the expertise needed for roles in animation studios, game development companies, architectural firms, advertising agencies, and more, providing a pathway to thriving careers in the creative industry. Advantages of joining this program: Thorough education: Excel in 3ds Max and Photoshop for high-quality visual effects and motion graphics at a professional level. Certified mentors and industry specialists: Receive instruction from seasoned professionals for expert direction. Interactive online sessions: Engage from any location; no need for travel. Lesson recordings: Access recorded sessions for revision and reinforcement. Long-term email assistance: Receive ongoing support even after the course completion. Complimentary career guidance: Gain valuable industry insights to boost your career prospects. Download Adobe Photoshop Download Autodesk 3dsmax

1-2-1 audition preparation for drama school entry or self-tapes.