94 Courses delivered Live Online

LOOKING FOR: ADULT FICTION, NON-FICTION Imogen Pelham has been at Marjacq since 2015, and has worked as a literary agent for more than a decade. She represents literary fiction and some upmarket commercial fiction, as well as a wide range of non-fiction. Imogen's looking for fiction with a strong premise, a surprise twist, or sharp humour. Recent favourites include Leave The World Behind by Rumaan Alam, Early Morning Riser by Katherine Heiny, and Sorrow & Bliss by Meg Mason. Her non-fiction list includes history, memoir, medicine and psychology. She is particularly interested in identity, the arts and investigative journalism. Imogen would like you to submit a covering letter, 1 - 2 page synopsis and the first 10,000 words of your manuscript in a single word document. (In addition to the paid sessions, Imogen 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: Monday 22nd September 2025

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.

Functional skills English Certification Course Overview The Functional Skills English Certification course is designed to enhance learners' command of English by improving key language skills essential for everyday communication and professional environments. It covers the fundamentals of grammar, sentence structure, punctuation, spelling, and common language errors, providing a well-rounded foundation in English. Learners will gain confidence in their reading, writing, and verbal communication, equipping them for a variety of roles in the workplace or further education. This certification is ideal for those looking to improve their English proficiency and meet the language standards required in various professional and academic settings. Course Description This course offers an in-depth exploration of the core components of English, starting with grammar and sentence structure. Learners will develop a strong understanding of punctuation, capitalisation, and spelling to enhance their writing accuracy and clarity. The course also addresses common language mistakes and offers strategies for improvement. Throughout the course, learners will engage with interactive content, building their knowledge and applying it to real-world scenarios. By the end, students will have gained the necessary skills to communicate effectively in both written and spoken English, empowering them to succeed in academic, professional, and social settings. Functional skills English Certification Curriculum Module 01: Introduction to the Course Module 02: The Basics of Grammar Module 03: The Basics of Sentence Module 04: Structure of Sentence Module 05: Question Module 06: Punctuation & Capitalisation Module 07: Spelling Module 08: Common Mistakes & Ways to Improve (See full curriculum) Who is this course for? Individuals seeking to improve their English language proficiency Professionals aiming to enhance their communication skills Beginners with an interest in mastering the English language Those preparing for English exams or certifications Career Path Administrative Assistant Customer Service Representative Teacher or Tutor Content Writer Communication Specialist Copywriter Public Relations Officer

English: Spelling, Punctuation, and Grammar Course Overview: This "English: Spelling, Punctuation, and Grammar" course provides a comprehensive understanding of the essential components of written English. Learners will explore the fundamental aspects of spelling, punctuation, and grammar, which are crucial for effective written communication. This course is designed for individuals aiming to improve their writing skills for both personal and professional use. By the end, learners will be confident in their ability to produce clear, error-free text, enhancing both their academic and workplace communication. Course Description: This course covers the key elements of spelling, punctuation, and grammar that form the foundation of written English. Topics include an introduction to grammar, sentence structure, and common spelling errors. Learners will gain a clear understanding of how to use punctuation and capitalisation correctly and will learn how to avoid common mistakes in writing. Through engaging content, learners will develop their skills to produce precise and coherent text. Whether for professional writing, academic purposes, or personal development, this course ensures learners are equipped to communicate effectively in written form. English: Spelling, Punctuation, and Grammar Curriculum: Module 01: Introduction to the Course Module 02: The Basics of Grammar Module 03: The Basics of Sentence Module 04: Structure of Sentence Module 05: Question Module 06: Punctuation & Capitalisation Module 07: Spelling Module 08: Common Mistakes & Ways to Improve (See full curriculum) Who is this course for? Individuals seeking to improve their written communication skills. Professionals aiming to enhance their written presentation in the workplace. Beginners with an interest in mastering English writing. Those looking to refine their grammar and spelling for academic or personal purposes. Career Path Content Writer Proofreader Editor Administrative Assistant Teacher/Tutor Communications Specialist Copywriter

Freelancer Masterclass Course Overview The "Freelancer Masterclass" offers a comprehensive introduction to building a successful freelance career, focusing on key skills needed for freelancing in the copywriting field. This course equips learners with the tools to confidently start their freelance journey, from understanding the foundational principles of freelance work to mastering the skills required for copywriting. Learners will gain valuable knowledge in handling clients, improving conversion rates, and navigating the nuances of closing deals. By the end of this course, participants will be well-prepared to enter the freelancing world with the essential skills to thrive in a competitive industry. Course Description This course delves deeper into the specific skills and strategies required to succeed as a freelance copywriter. From learning how to get started, understanding the skills required, to effectively communicating with prospects, the course covers a broad spectrum of essential topics. Learners will explore various niches that use copywriters, learn how to make and close deals, and understand how to build a freelance career that stands out. Throughout the course, students will be guided on how to refine their approach to increasing conversion rates and establishing a solid client base, ensuring they are well-equipped to succeed in a dynamic freelance market. Freelancer Masterclass Curriculum Module 01: Getting Started as a Copywriter Module 02: Skills Needed by a Copywriter Module 03: Communicating With Your Prospect to Improve Conversion Rate Module 04: Making and Closing a Deal Module 05: Niches That Use Copywriters Module 06: Becoming a Freelance Copywriter Module 07: Conclusion (See full curriculum) Who is this course for? Individuals seeking to start a freelance career. Professionals aiming to enhance their copywriting skills. Beginners with an interest in copywriting or freelancing. Aspiring freelance copywriters or content creators. Career Path Freelance Copywriter Content Marketing Specialist Digital Marketing Copywriter Brand Strategist Freelance Content Writer

Copywriting Level 4 Course Overview The Copywriting Level 4 course offers a comprehensive exploration of the art and science of writing persuasive, impactful copy. Designed for individuals eager to enhance their writing skills for various media, this course covers a wide range of topics, including headline creation, online and print copywriting, and crafting effective advertisements. Learners will gain valuable insights into the techniques used by professional copywriters, mastering the ability to produce compelling content across different platforms. By the end of the course, students will be equipped to create copy that captures attention, promotes engagement, and drives results. Course Description This course delves into the essentials of copywriting, focusing on both the creative and strategic aspects of the craft. Learners will explore topics such as writing eye-catching headlines, creating advertisements that resonate, and mastering the nuances of online, press, and print media copy. Through engaging modules, learners will develop critical copywriting skills, including understanding tone, style, and audience engagement, as well as learning to write for diverse media. By the end of the course, students will have the expertise needed to write clear, persuasive copy that enhances brand messaging and promotes consumer action. Copywriting Level 4 Curriculum Module 1: Introduction to Copywriting Module 2: Basics of Copywriting Module 3: Eye-Catching Headlines Module 4: Attention-Grabbing Advertisements Module 5: Essential Copywriting Skills Module 6: Online Copywriting Module 7: Press Related Copywriting Module 8: Print Media Copywriting Module 9: Copywriting for Mainstream Media Module 10: Copywriting for Other Media Module 11: How to Write Better Copy Module 12: Final Tips (See full curriculum) Who is this course for? Individuals seeking to enhance their writing skills for career growth. Professionals aiming to improve their copywriting proficiency. Beginners with an interest in marketing and advertising. Anyone aspiring to work in the field of content creation and media. Career Path Copywriter Content Writer Marketing Specialist Advertising Executive Media Consultant SEO Content Creator

Data has become the most important resource for every organisation – but the insights gained from data analysis will only ever be truly valuable if they can be clearly expressed to other people.  This course is for anybody who works with data, and needs to communicate the meaning that's in the numbers to colleagues, customers, bosses or external stakeholders.  It will give you or your team the confidence and skills to translate raw data into compelling visual stories for your key audiences. The principles and skills covered apply to the simplest PowerPoint chart, to more complex interactive visualisations.  We’ll work with you before the course to ensure that we understand your organisation and what you’re hoping to achieve.  Sample learning content Session 1: What makes a great data-driven story The key elements of a successful infographic or presentation. Industry best practice, and discussion of good (and bad) examples. A simple framework for identifying the Audience, Story and Action. Session 2: Data in context How to balance function and aesthetic appeal. Identifying the right graph, chart, infographic or other visual. Framing the data and providing contextual information. Session 3: Designing for the human brain Using colours to add emphasis and meaning. Design and layout principles, and creating hierarchies of information. The principle of ‘self-sufficiency’, and removing clutter. Session 4: Navigation and narrative Tailoring visualisations for different types of communications. Structuring presentations and longer reports. Thinking in layers to create interactive dashboards. Delivery We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets.
 Testimonial “I was familiar with Alan’s work as a Guardian Masterclass instructor on data visualisation and digital journalism, which made it easy for me to recommend him for onsite training at the Liverpool School of Tropical Medicine. We had a large group of people interested in honing their abilities to depict their research and stories in engaging ways. Alan’s course provided great insight about common communication pitfalls and how to avoid them, how to become better communicators by understanding the audience diversity, and it showcased some great online tools for creating infographics. This should be mandatory training for all students, academics, report writers and those involved with conveying research to the media as it will help increase the clarity and accessibility of our own research stories.”
 Dr Lee Haines | Liverpool School of Tropical Medicine

Asbestos surveyors, or managers of surveyors and surveying teams. Asbestos re-inspectors or anyone that undertakes asbestos re-inspections. Those who require a detailed understanding of asbestos surveying principles (e.g. asbestos report writers, architects, building surveyors etc.) Prior Knowledge and Understanding Candidates for this course are expected to be aware of the contents of HSG 264 Asbestos, the survey guide and have a minimum of six months prior experience of assisting on asbestos surveys. In addition, candidates are expected to have had training to cover the core competencies outlined within the foundation material detailed within Table A9.1 of HSG248 Asbestos: The Analysts' Guide (July 2021). This may be achieved by In -house learning or through the P400 foundation module.

News Writing, Production and Reporting Course Overview This course on News Writing, Production and Reporting offers a comprehensive introduction to the core elements of newspaper journalism. Learners will explore essential techniques in news writing, interviewing, reporting, and production, equipping them with the skills needed to craft clear, accurate, and engaging news stories. The programme emphasises the ethical and legal responsibilities of journalists, alongside developing strong writing and reporting skills tailored to contemporary media environments. By the end of the course, participants will understand the principles of newspaper journalism and gain confidence in producing professional news content suitable for a variety of platforms, ensuring readiness for roles in the fast-paced journalism sector. Course Description Delving deeper into the craft of newspaper journalism, this course covers the historical context, development, and evolving nature of the industry. Learners will study interview techniques, news writing formats, production workflows, and specialised reporting areas such as court reporting and niche journalism. Legal frameworks and journalistic ethics form a critical part of the curriculum, ensuring an informed and responsible approach to reporting. Additional topics include feature story writing and health and safety considerations for journalists. Through a structured learning experience, students will develop analytical, communication, and editorial skills vital for effective storytelling in print and digital media, preparing them for a dynamic and rewarding career in journalism. News Writing, Production and Reporting Curriculum Module 01: Introduction and Principles of Newspaper Journalism Module 02: History and Development of Newspaper Journalism Module 03: Interviewing for Newspaper Journalism Module 04: News Writing Module 05: News Production Module 06: News Reporting Module 07: Writing Skills for Newspaper Journalists Module 08: Newspaper Journalism Law Module 09: Court Reporting Module 10: Journalism Ethics Module 11: Niche Journalism Module 12: Tips on Writing a Good Feature Story Module 13: Health and Safety for Journalists (See full curriculum) Who is this course for? Individuals seeking to build foundational skills in newspaper journalism. Professionals aiming to advance their career in media and communications. Beginners with an interest in news writing, reporting, and media production. Anyone wishing to understand the legal and ethical aspects of journalism. Career Path Newspaper Reporter News Editor Broadcast Journalist Feature Writer Court Reporter Media Communications Specialist Digital Content Producer

Certificate in SEO Content Writing Course Overview This Certificate in SEO Content Writing equips learners with the essential knowledge and skills to create compelling, search-engine-optimised content that drives online visibility and engagement. The course covers key principles of content writing, SEO fundamentals, keyword research, and effective writing techniques to attract and retain readers. Learners will develop an understanding of how to craft content that meets both audience needs and search engine criteria, enhancing website rankings and digital marketing success. Upon completion, participants will be confident in producing high-quality, SEO-friendly content tailored to diverse platforms and industries, enabling them to advance in digital marketing or content creation roles. Course Description This comprehensive course explores the full spectrum of SEO content writing, starting with foundational concepts of content creation and progressing through advanced SEO strategies. Topics include writing saleable content, mastering keyword research, optimising meta tags, and understanding off-page SEO factors. Learners will gain insight into engaging readers effectively and making any piece of writing SEO-friendly without compromising quality. The learning experience balances theory with structured guidance on writing processes, text objectives, and article rewriting techniques. By the end, learners will possess a robust skill set applicable to roles in digital marketing, copywriting, and content management, equipped to produce content that enhances online presence and supports business goals. Certificate in SEO Content Writing Curriculum Module 01: What Is Content Writing? Module 02: How To Write Saleable Content Module 03: The Importance of SEO Based Content Writing Module 04: Basics of SEO Module 05: Essential SEO Skills for Content Writers Module 06: How to Engage the Reader? Module 07: Search Engine Optimization Process Module 08: Off Page SEO Module 09: Meta Tags Optimization Module 10: The Importance of Keyword Research Module 11: Keyword Strategy Module 12: How to Make Any Content SEO-Friendly Module 13: The Process of Good Writing Module 14: Text Objectives Module 15: How to Rewrite an Article (See full curriculum) Who is this course for? Individuals seeking to develop skills in SEO content writing. Professionals aiming to enhance their digital marketing career. Beginners interested in digital content creation and optimisation. Freelancers wanting to expand their writing service offerings. Career Path SEO Content Writer Digital Marketing Executive Copywriter Content Strategist Social Media Content Creator Website Content Manager