455 Character courses delivered Live Online

To understand psychopathology, one must learn a foreign language, lend an ear as it were to a language that is complex and symbolic. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Character- between Prof. Ernesto Spinelli and Prof. Robert Romanyshyn “I begin with the term psychopathology to emphasize that the word is about the logos—the thinking/speaking—about the sufferings of the psyche. To understand psychopathology, one must learn a foreign language, lend an ear as it were to a language that is complex, symptomatic, symbolic, and embodied. As complex, psychopathology reveals and conceals the sufferings of psyche. As symptomatic, psychopathology reminds one of things too important to forget but which are forgotten because they are too painful to remember. As symbolic, psychopathology is neither about facts nor ideas but about images, alchemical vessels that not only hold and contain psyche’s sufferings, but also cooks them. As embodied, psyche’s sufferings are inscribed in the flesh, etched as lines of character. To practice psychotherapy as an existential therapist situates therapist and patient in a dialogical field that is complex, symptomatic, symbolic, and embodied as a gestural field between them.” Prof. Robert Romanyshyn. Prof. Robert D. Romanyshyn, an Affiliate Member of The Inter-Regional Society of Jungian Analysts, a Fellow of the Dallas Institute of Humanities and Culture, and a Professor Emeritus of Clinical Psychology at Pacifica Graduate Institute, was recently awarded the Distinguished Lifetime Contributions to Humanistic Psychology Award from the Society for Humanistic Psychology APA Division 32. He has published eight books and numerous articles in psychology, philosophy, education, and literary journals. He is also a published poet and has written a one-act play about Frankenstein. In 2009 he created a multi-media DVD entitled Antarctica: Inner journeys in the Outer World, which offers a psychological reflection on the melting polar ice. In addition to online seminars and interviews, he has given lectures and workshops at universities and professional societies in the U.S., Europe, Australia, South Africa, Canada, and New Zealand. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 3 May from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:

Game design training face to face training customised and bespoke.

Join Us for a Lunchtime Talk: Let’s Discuss Movies, Books, and More! We're excited to invite you to our Book and Movie Club – the perfect way to take a break, grab a coffee, and connect with colleagues on shared interests! ☕️📚🎬 We hope to have stimulating conversations through this club, whether we’re breaking down the latest blockbuster or analysing our favourite book characters, while providing opportunities for catching up with colleagues! What to Expect: Open to All Whether you're a bookworm, a casual reader, a movie buff, or just looking for an excuse to get great movie/book recommendations, you're welcome to join our casual chat sessions! Casual Format: This is a relaxed event where we’ll chat about anything you’ve been watching or reading lately. No pressure — just come with your coffee or lunch and be ready to share and discover new favourites. Whether you’ve finished a whole book or just seen the first episode of a series, all are welcome to participate! No Pressure: There’s no need to have prepared anything — feel free to jump in with whatever you’ve been into lately. You don’t have to read an entire book or watch a whole movie to join the conversation. It’s all about enjoying media together in a laid-back environment! Next meet-up Details Date: May 30, 2025 Time: 12:00 p.m. – 12:30 p.m.Where: Join us virtually in a Teams call!Feel free to bring your lunch, coffee, or snacks and get ready for some fun, low-pressure discussions about the movies, shows, and books you’ve been enjoying! Register now and get ready for amazing conversations!

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

LOOKING FOR: PICTURE BOOKS, CHAPTER BOOKS, MG, YA Lil is a Senior Editor at Hachette Children's. She has well over 15 years experience in the publishing industry, working for major publishers and literary agents too.  For twelve years, Lil was a Senior Commissioning Editor at Working Partners Ltd – the creatives behind massive commercial hits such as Beast Quest, Warriors and the Daisy Meadows series. There she created globally successful concepts for every age group and developed storylines so the books were unputdownable. Lil is also an author in her own right: she has written 6 books under her own name, and ghost written many others under various pseudonyms.  In every age level, Lil would like to see originality - particularly in voice. A strong character with depth, venturing on a quest that's never been undertaken before will get her excited. The 'quest' doesn't have to be epic in scale, it could be as small as petting the next-door neighbour's dog, or getting the good looking new kid to notice you, it just has to be something a reader will want to invest in. She also loves humour and is happy to see anything quirky (perhaps even downright silly!).  For picture books, Lil would like you to submit a covering letter, and 1 complete manuscript, double-spaced, with spreads marked out, in a single word or PDF doc. For chapter books, MG and YA, please send a covering letter, the first three chapters and a synopsis, double spaced, in a single Word or PDF doc. Please send EITHER picture books OR another genre, not both in one submission. By booking this session you agree to email your material to reach I Am In Print by the stated submission deadline to agent121@iaminprint.co.uk. Please note that I Am In Print take no responsibility for the advice given in your Agent121. The submission deadline is: Monday 8th September 2025

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Course Description: The 18th edition course is a 3 day short course aimed at anyone involved in the design, construction and inspection and testing of electrical systems, also a nationally recognised ‘must have’ qualification for companies seeking to recruit electricians. It is intended to introduce the candidate to a working knowledge of the Wiring Regulations along with a brief overview of the Electricity at Work Regulations covering their statutory duties. Previous knowledge of the regulations is not assumed, however, a fundamental knowledge of electrical principles is assumed. Please be aware that the Wiring Regulations course is not designed to teach you every regulation in the book but it will teach you the best practices on how the reference the latest regulations as you would on the job. As such key topics currently covered on the 17th Edition will still be included. We have been delivering Wiring Regulations courses for many years and although it is mainly theory based you cannot beat real training in a real classroom. By training with other people in your class you will benefit from being able to ask relevant questions as well as finding the answers to many questions from your fellow students that you may not have even thought of. The examination is a 2 hour multiple choice, open book PC based examination with instant results. The course cost includes examination entry fees. Focus: You will study the latest standard of the IET wiring regulations, including essential subjects such as safety, selection and erection of electrical equipment. There are 8 key modules and current amendments: Section 1 – Scope, Object and FundamentalsSection 2 – DefinitionsSection 3 – Assessment of general characteristicsSection 4 – Protection for SafetySection 5 – Selection and Erection of equipmentSection 6 – Inspection & TestingSection 7 – Special Installations or locationsSection 8 – Functional Requirements This course does include the latest amendments such as: Electromagnetic Disturbance Surge Protection Medical locations Operating and Maintenance Gangways Arc Fault Detection Devices (AFDDs) Changes to fire safety requirements in chapter 422, covering the design of electrical installations in industrial, commercial and multiple-occupancy homes, as well as new information for ‘protected escape routes’ Protection against over voltages Changes across Part 7: Special Locations This classroom based course will show, teach and perfect you on how to reference and use the book for situations that you will encounter while working in the field.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

LOOKING FOR: MG, YA, ADULT FICTION, ADULT NON-FICTION, NON-FICTION FOR 7+ Megan Carroll is looking for writers in a variety of areas, and from a wide range of backgrounds – she is particularly keen to hear from Black, Asian, and LGBTQIA+ writers. Her main areas of focus this year are adult fiction and non-fiction, as well as non-fiction for 7+, and MG and YA fiction. In Fiction, Megan is keen to see high-concept love stories (think The Flat Share or The Lock In) for both commercial and reading group readers. She’d love to see those familiar romance tropes – enemies to lovers, friends to lovers, love triangles, forbidden love etc. – with underrepresented characters at the centre. She is also looking for historical fiction and gothic horror (think Laura Purcell, Stacey Halls and Silvia Moreno-Garcia) – anything that has a creepy, uneasy undertone is likely for Megan’s list. Megan is also actively looking for upmarket fiction and would love to see layered family drama, contemporary stories about life today and darkly comic novels that explore a specific time, place or experience. In Non-Fiction, Megan is keen to hear from experts in their field talking about topics relating to film, music, true crime, popular culture, history and issues from largely unrepresented perspectives. She is keen to see memoir, narrative non-fiction and essay collections. In Children’s and YA, she is keen to see contemporary YA with humour, and romance at the heart – fun and emotional stories that appeal to the interests and issues of the teenage readers. She’d also love to see thrillers and horror stories for this age group too. It’s unlikely that high fantasy novels for YA readers will be right for her, but she is keen to see stories with fantasy elements in a real world setting. On the younger end, Megan is looking for funny, contemporary middle grade – think Louise Rennison and Karen McCombie – and anything creepy and spooky for 8-12 year old readers too. She’d love to find something like Lemony Snicket’s A Series of Unfortunate Events and is keen to find original adventure stories in both fantasy and realistic settings. Megan would like you to submit a covering letter, 1 page synopsis and the first three chapters or 5,000 words of your manuscript in a single word document. (In addition to the paid sessions, Megan 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: Tuesday 26th August 2025 at 9am UK BST

LOOKING FOR: ADULT FICTION, NON-FICTION Emily MacDonald joined 42 management and production company in 2019, working with Eugenie Furniss across her clients. She is now an agent in the Books Department, and is building her own list. Send Emily a story with characters that just won't leave her and a narrative that pulls her in, keeping her immersed in the world well after she has finished reading. She reads across a wide-range and has a particular interest in: book club, high-concept crime/thriller, upmarket and literary fiction. In fiction, Emily would love to find a crime/thriller set within a subcult: a modern retelling of British folklore (think Kamila Shamsie’s Home Fire); an unconventional love story; and a character led journey of self-discovery (especially one set within a diasporic community). Emily is also looking for narrative non-fiction which immerses the reader into an untold true story (personal or historical), exploring a new point of view, and providing a compelling social commentary, with an investigative twist. Think the obsessive vein of Kirk W. Johnson or personal/political dispatches of Aidan Hartley. Emily wants her horizons to expand while she reads. In both fiction and non-fiction, Emily loves stories woven into their surroundings, where the setting is as central a character as those who drive the narrative. In both spheres, she is keen to hear from Scottish and regional voices with stories to tell. Please note, Emily is not currently accepting submissions for Children's lit/YA and SFF. Emily would like you to submit a covering letter, 1 - 2 page synopsis and the first 5,000 words of your manuscript in a single word document. (In addition to the paid sessions, Emily 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: Thursday 4th September 2025