176 Abs courses in Nottingham delivered Live Online

LOOKING FOR: ADULT FICTION Marilia Savvides founded The Plot Agency in 2024. She began her career in publishing at Peters Fraser and Dunlop, where she spent eight years, first as International Rights Agent, and later as Literary Agent, building her own list of authors. In 2019, she joined 42MP, where she worked as Literary Agent for four years, helping to launch and set up the Book Division. She is particularly interested in fiction that is beautifully written and cleverly constructed, but still accessible to a wide readership. She is often drawn to darker tales that weave together excellent characters and an impossible-to-put-down story, from immersive book club novels with a splash of suspense, crime and thrillers, accessible horror, and speculative, genre-bending or dystopian stories. She also adores smart, witty contemporary rom-com in the style of Emily Henry. In the thriller, crime and mystery space she is interested in most areas, except military thrillers and organised crime/ mafia / mob stories. Big hooks and clever set ups are a big bonus! She adores Karin Slaughter (especially her standalone novels) and Gillian Flynn. In the book club / reading group space, she’s particularly drawn to fiction in the vein of Jodi Picoult, Liane Moriarty and Celeste Ng, and absolutely fell in love with Bright Young Women by Jessica Knoll, both for the incredible voice, and the exquisite use of structure and time. Complicated family dynamics, empathetic and smart approaches to controversial issues, stand out protagonists (like Elizabeth Zott in Lessons in Chemistry or Bernadette in Where D’You Go Bernadette), long buried secrets, complicity, the road to justice, and impossible decisions, are all themes she finds herself drawn to. In the horror space, she’s a sucker for amazing female-centric stories in the vein of Yellowjackets, and the kind of contemporary, accessible horror that Stephen King always nails. She wants to get lost in a world that feels within reach of ours. In the speculative and dystopian spaces, she’s interested in genius ideas that set up big questions or reflect the most broken (and sometimes hidden) parts of society. She loves Octavia Butler, Margaret Atwood, George Orwell, and also adored The Leftovers, Station Eleven, Wanderers, and The Power. The what-ifs of life and fiction fascinate her. In the grounded sci-fi space, she’d love to find a smart, immersive, and accessible story like The Martian. She doesn’t represent fantasy or romantasy. In regards to sci-fi, unless it’s very grounded and has crossover potential to a mainstream audience, it’s not for her. In the romance space, she’s particularly drawn to smart, complex and witty characters, where the chemistry is jumping off the page. She loves contemporary settings and all the tropes, though the voice and characters must come first to make the reading experience fully immersive. She wants to be cackling, and rooting for the characters with all her heart. She is very hands-on editorially, and loves working with her authors to shape their manuscripts, and brainstorm ideas. The best part of the job is discovering debut authors, and helping them find a home for their books. Marilia 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, Marilia is kindly offering one free session for low income/underrepresented 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: Wednesday 13th August 2025

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals 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 12c SQL Fundamentals 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.

The Central Heating Controls Wiring and Fault Finding course is a two day-day short course aimed at anyone involved in the construction, commissioning, inspection & testing or maintenance of central heating electrical control systems. The Central Heating Controls Wiring and Fault Finding course covers all the commonly used control systems in use today and is focused on the ‘practical’ construction and commissioning along with the relevant fault finding techniques. The Central Heating Controls Wiring and Fault Finding course requires an understanding of electrical principles and cable termination skills. A requirement of this course is the successful completion of their Essential Electrics examination prior to sitting the central heating controls wiring & fault finding examinations. Please ring if clarification is needed on this point. There are two 20 minute open book examinations and the associated practical assessments. A third examination and associated assessment will be required for candidates not holding the Essential Electrics unit. The Central Heating Controls Wiring and Fault Finding course comprises of: Short theory sessions introducing the conventional wiring systems, ‘Y’ Plan, ‘S’ Plan, ‘C’ Plan, Etc. Detailed practical workshop sessions, undertaking the construction, testing and commissioning of systems Fault finding and maintenance tasks performed on working systems Examination and practical assessment preparation ready for the assessments Evaluation of the system control function (why and how it works) Each student will work on their own system, and will have plenty of time to absorb and understand how each systemworks. Advise will be given on suitable ‘tooling’ and test equipment. These are nationally recognizable qualifications which are fast becoming an essential requirement for this type of work. The course costs include comprehensive course notes and examination entry fees.

Motorsport is as much a business as it is a sport. Our new master’s programme will provide students with a broad range of modules which examine the national and international aspects of the industry from a commercial perspective. From governance, structure and international sports law, through to the importance and interdependence of commercial rights holders, promoters, manufacturer, teams, sponsors and the role played by the media, this course is aimed at enhancing the professional and career prospects of those with an aspiration of working within this exciting and challenging global industry. Our programme will help you to develop as professionals with a strong grounding in ethics and a clear sense of how motorsport relates to various cultures, stakeholders and the sectors it interacts with.

Tackle Stress Before It Tackles You! Work-related stress affects 875,000 people every year, and its impacts go beyond the workplace—affecting your mind, body, and personal life. But it doesn’t have to be this way. Join our Stress Management Workshops to: ✔️ Understand the difference between stress and pressure ✔️ Learn the causes of stress in and out of the workplace ✔️ Discover practical coping strategies and build mental resilience These workshops are packed with insights, tools, and strategies to help you take control of your stress levels and improve your well-being—personally and professionally. There are two different ones to choose from - a 2 hour workshop and a 4 hour workshop! Course Contents of 2 hour course: What is Stress Stress versus Pressure Statistics Absenteeism, Presenteeism and Leaveism Workplace Causes of Stress Personal Causes of Stress Short-Term and Long-Term Effects of Stress Coping Strategies Mental Resilience Benefits of this Workshop: In 2022/23. 875,000 people suffered from work-related stress, depression or anxiety The affects of stress are far reaching, affecting one's mind, body, social and personal life Become more aware of what stresses you, what is does to you and find ways to reduce those stress levels

The Postgraduate Certificate (PG Cert.) consists of the first four modules from the MA Business of Motorsport Master’s Degree. You can then achieve a Postgraduate Diploma (PG Dip.) Business of Motorsport by studying the PG Dip. Top-Up, a further three modules from the MA.

For the Postgraduate Diploma (PG Dip.) you will study the four modules (60 credits) from the Postgraduate Certificate (PG Cert.) plus an additional three modules (60 credits) from the MA Business of Motorsport Master’s Degree. N.B. The Postgraduate Diploma (PG Dip.) does not include the Executive Project (Dissertation) the final module of the MA.

TOLES Foundation Certificate in Legal English Skills Why Attend Legal English is a different language from general English. Just as lawyers in any particular country write in a different language from other people in that country, so do English lawyers. Sentences are often structured differently in legal English. The words lawyers use are often centuries old and no longer commonly used in general English. New prepositions must be learned and practiced. When reading a commercial contract or a letter, there is new technical vocabulary to understand on every page. This course is designed to look at authentic rather than artificial legal context. For this reason, there is a strong focus upon practical and authentic tasks, and upon candidates having a good grasp of terminology from the outset. The course takes account of significant language reforms in the English legal system and the legal profession's continued movement towards clearer use of English as recommended on Legal Practice courses at all major UK universities and legal training centers. The Test of English Legal English Skills (TOLES) governing body is a member of the International Division of the Law Society of England and Wales. Multi-national companies such as Allen & Overy LLP, Baker and McKenzie, PWC, KPMG, Sony Ericsson, European Court of Justice, European Central Bank and many more use TOLES training and exams to prepare their law professionals whose first language is not English for the international legal challenges. On the final day of the course, participants will take their TOLES Exam to earn the TOLES Foundation Certificate in Legal English Skills. Course Methodology The course consists of group discussions as well as individual and team tasks. There will be writing exercises and practice exams at the end of each day, culminating in sitting the TOLES Foundation Exam on the final day of the course. Course Objectives By the end of the course, participants will be able to: Apply correct legal vocabulary when communicating with clients/law professionals and will be familiar with modern legal writing style Recognize common mistakes in English and will be able to identify accurate prepositions and collocations within a legal context, particularly within the context of written contracts Differentiate between the English legal system and the American legal system Recognize improvements in their reading and comprehension skills of legal documents and demonstrate accurate written solutions within a legal context Target Audience This course is useful for law and legal professionals, translators, contract assistants and managers who already possess good general English and are now acquiring legal vocabulary, as well as those who are required to obtain a TOLES certification by their organization. Target Competencies Legal vocabulary and grammar Legal communication Legal comprehension skills Formal written contracts Note The Test of English Legal English Skills (TOLES) governing body is a member of the International Division of the Law Society of England and Wales. Multi-national companies such as Allen & Overy LLP, Baker and McKenzie, PWC, KPMG, Sony Ericsson, European Court of Justice, European Central Bank and many more use TOLES training and exams to prepare their law professionals whose first language is not English for the international legal challenges. The TOLES Foundation level exam tests Legal reading and writing. The focus of the exam is on testing the absolute linguistic accuracy required of lawyers in a modern international office. This means accuracy in two main areas: technical legal vocabulary, and grammar. Vocabulary from commercial deals, company documents, commercial contracts, intellectual property agreements, financial documents and forms of business are tested, as well as legal terminology from other areas. Upon passing the exam, participants will receive the TOLES Foundation Certificate. The Legal Profession Working in law Making a claim in civil court Areas of law Vocabulary check TOLES Foundation Exam practice The Language of Banking A new bank account Working in a bank Loans Vocabulary check TOLES Foundation Exam practice The Language of Contract Law A contract case More about precedent The elements of a contract The end of an offer What is consideration Contract and statute Going to court Vocabulary check TOLES Foundation Exam practice The Language of Employment Law Being an employer An employment contract How can an employment contract end? Acting for an employee Acting for an employer An employment case Vocabulary check TOLES Foundation Exam practice The Language of Tort Law What is the Law of Tort? Types of Tort The duty of care More about negligence A famous case in English law Vocabulary check TOLES Foundation Exam practice Understanding Contracts - Part 1 The style of written contract Understanding formal expressions Understanding technical words Understanding archaic terms Understanding some common words The structure of a contract Vocabulary check TOLES Foundation Exam practice The Language of Business Law Sole traders Partnerships A partnership agreement Limited liability partnerships Companies Public and private limited companies Incorporating a company Vocabulary check TOLES Foundation Exam practice Modern Letter Writing The layout of a letter Dates Complimentary close References Subject lines The body of a letter Putting a letter together The register of letter writing The content of a letter Typical sentences in legal letters Letter writing clinic Correcting common mistakes in letter writing TOLES Foundation Exam practice The Language of Company Law Who runs a company Areas of company law Directors Company meetings Company finance - a case study Closing a company Insolvent companies Vocabulary check TOLES Foundation Exam practice Understanding Contracts - Part 2 Some typical contract clauses Some important commercial vocabulary Termination clauses Intellectual property clauses Warranty, indemnity and force majeure clauses Vocabulary check TOLES Foundation Exam

Advanced Java training course description A tour of the more advanced features of Java following on from the Introduction to Java course. JDBC and JavaBeans are covered in separate courses. What will you learn Use Java to implement OOA/D. Use within Java programs - Internationalisation - Object serialisation - Reflection - RMI - Swing - JAR files Write Servlets and Java Server Pages Advanced Java training course details Who will benefit: Those wishing to program in Java. Prerequisites: Introduction to Java programming Duration 5 days Advanced Java training course contents What you should already know OO features in Java Static initialisers, object destruction, finalisation, constructor chaining, shadowing, Abstract classes and interfaces, inner classes, nested classes, member classes, local classes, anonymous classes. Internationalisation Locales, Unicode, local customs, localising messages. Object Serialisation Simple and custom serialisation, class versioning. Reflection Obtaining class and member information. RMI Restrictions, RMI architecture, Stubs, skeletons, rmic, the registry server, The RMI API. Swing An overview, examples, comparison vs. AWT, data transfer cut & paste. Servlets Servlet API, Java Web server, The servlet life cycle, chaining servlets, Hybrid servlets. JAR files and signed applet JAR files and signed applet

Java training course description A comprehensive introduction of the Java language and environment. It is important to note that the course will assume that the delegates are already familiar with the C language as this enables more advanced features of the Java language to be covered in the course. The course will also give an overview of areas related to programming in Java. What will you learn Describe the Java architecture. Write Java applets and applications. Debug Java programs. Examine existing code and determine its function. Use multimedia extensions, the awt, multithreading, exceptions within Java Java training course details Who will benefit: Those wishing to program in Java. Prerequisites: Complete C programming Duration 5 days Java training course contents Review of UNIX fundamentals What is Java? What Java is, history of Java, reasons for success. The Java Virtual Machine, Bytecodes, getting up and running with Java, Java resources. Simple Java applications. C features in Java Java data structures, Java flow control, differences from C, arrays, strings and packages. OO features in Java Java classes and objects, inheritance, overloading, packages. Differences from C++. Java applets Applications vs. applets, HTML, the applet tag, applet methods, life cycle, testing and debugging. Multimedia applets Images, sounds, fonts, colours and animation. Java products The JDK in detail, other development environments. Javabeans and JDBC overviews. Abstract Window Toolkit JFC and Swing versus AWT. Event handling (JDK 1.1), GUIs, panels, buttons, lists, scrollbars, text areas, frames… Exception handling and multithreading Handling exceptions. Starting, pausing, stopping threads, producers, consumers, monitoring. More standard classes Java file I/O, Streams, The system class. The networking model, java.net classes. Security and Java Types of attack, the security manager, craplets, securing the network. Integrating legacy code with Java