12475 Teaching & Training courses delivered Online

Clinical coach standardisation events

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL 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 DP-080T00 Querying Data with Microsoft Transact-SQL 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.

LOOKING FOR: MG, ADULT FICTION Jo Williamson has been in publishing for over 25 years. Having worked in Children’s books PR for Dorling Kindersley, HarperCollins and Orion, she started as an agent with Antony Harwood in 2008. She feels very privileged being with authors at the very start of their publishing journey and enjoys close working relationships with all her clients. From editorial help, general advice on the publishing world, guiding careers long-term and general cheerleading, she feels she has the perfect job. Although nothing is off limits and she loves being surprised by submissions, In middle grade children's fiction, Jo is particularly looking for books with heart, epic adventures with voice-led characters, and younger funny fiction with series potential.  In adult fiction, page-turning Commercial Women’s and Book Club fiction are right up Jo's street, including psychological suspense, thriller, cosy crime and books that don’t quite fit the mould. Above all, she wants stories that linger long after the final page has been read. Jo is not the right fit for police procedurals. Jo would like you to submit a covering letter, 1 page synopsis and the first 5,000 words of your manuscript in a single word document. (In addition to the paid sessions, Jo 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: Sunday 10 November 2024

LOOKING FOR: ADULT FICTION, NON-FICTION Liza represents a range of fiction and non-fiction. On the fiction side, she is looking for historical fiction that is well researched, immerses readers in the era, and looks at overlooked characters from the past, or perhaps gives a new spin on someone we think we know. On the literary and upmarket side, she is looking for novels infused with emotions that capture the human experience and make readers think. If your literary novel is something at A24 productions might turn into a movie, this is Liza’s taste. When it comes to fantasy, she loves urban and grounded fantasy (no sci-fi please!), and is always happy to look at anything with a vampire, werewolf, witches, warlocks, fairies, and perhaps a sinister selkie or two. She is also very much looking for romantasy and is the best person at the agency to submit that too. For thrillers, send her anything set in an exotic location, high-concept, or things with a speculative twist. She loves when characters are put in situations she would never want to be in, and then they have to get out of it. Her recent favourite fiction includes: Notes on an Execution, Lady Macbethad, Hamnet, A Discovery of Witches, House of Earth and Blood, The Starless Sea, Piranesi, Our Wives Under the Sea, The Pisces, Such A Fun Age. When it comes to non fiction, she is looking for books that teach her something new or reframe a topic from an alternative point of view. This can include cookery, pop science, and social history. Liza’s recent favourite non-fiction include: The Five, A History of Art Without Men, Messalina, The Authority Gap, Finding The Mother Tree, Cook This Book, Dessert Person. Liza would like you to submit a covering letter, 1 - 2 page synopsis and the first 5000 words of your manuscript in a single word document.  (In addition to the paid sessions, Liza 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 6 November 2024

This qualification is aimed at learners who wish to work in an unsupervised capacity; planning, instructing and evaluating a safe and effective Pilates session.

LOOKING FOR: YA, NA, ADULT FICTION Helen Lane is an editor and a Junior Agent at The Booker Albert Literary Agency. She is passionate about books and has spent the last decade supporting authors. She will happily offer her editing advice on manuscripts through I Am In Print but in accordance with her membership of the Association of American Literary Agents (AALA), guidelines state that any work submitted to her for feedback cannot be considered for agent representation. What Helen will do during your session is assess your sample and provide detailed feedback on any identifiable issues, the manuscript's commercial potential and what steps she would advise before you begin querying. She does not require personalisation in the letter, comparison titles or a synopsis, but if you have them already, please include them. As an idea of the genres Helen represents, she would love to see and offer advice on Adult Fantasy, Sci Fi, Horror, Paranormal Romance, LGBTQ+ Romance, Action & Adventure & Thrillers and will also look at YA Fantasy. Books Helen is slightly obsessed with include monster stories (especially if they have giant sharks or squids) and stories set in extreme environments such as the arctic, jungle, caves, ocean, and mountains. She DOES NOT want to read about affairs or abuse in any genre. (Her husband likes her to add here that this is nothing to do with him; she just doesn't like sad stories). Her favourite authors are Mira Grant, Greig Beck, James Rollins, Matthew Reilly, Jennifer L. Armentrout, Darcy Coates, Patricia Briggs & Kelley Armstrong. Helen holds a BSc in Environmental Science from the University of East Anglia and a postgrad qualification in Acoustics. She lives in London with her family and the world’s naughtiest cocker spaniel. Follow Helen on social media: @HFLane_writing Helen would like you to submit a covering letter, 1 page synopsis and first three chapters (Max 5,000 words) of your manuscript in a single word document. (In addition to the paid sessions, Helen 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 8th November 2024

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

LOOKING FOR: ADULT FICTION, NON-FICTION Sian Ellis-Martin joined Blake Friedmann in 2018 and is building a list of fiction and non-fiction at the agency.  With regards to fiction, Sian is looking for commercial, upmarket and accessible literary novels. She always wants to be completely absorbed by the world of the novel, to jump into the character’s life and be swept into the narrative as if she’s been there all along. She’s drawn in by compelling characters and relationships, and loves stories with a mystery or question at the heart of them. She’s open to these ideas being explored in a variety of ways, but at the moment, she’d particularly like to find an epic love story, a fun, queer rom-com with an unusual setting or pitch, and/or a sweeping family saga. She leans more towards contemporary settings but does enjoy a historical backdrop too. In non-fiction, she’s looking for narrative non-fiction, history from different perspectives and books that make complicated ideas around things like politics and literature more accessible. Her favourite type of non-fiction book is the one that makes you interested in something or someone you’d never thought you would be. She’d also love to find cookery and food books too, particularly cuisines that are less visible in the book world, or budget cooking. She’s not currently taking on YA, children’s, fantasy or science fiction projects. Sian would like you to submit a covering letter, 1 - 2 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, Sian 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 20and note that I Am In Print take no responsibility for the advice received during your agent meeting. Submission Deadline: Monday 11 November 2024

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: Monday 11 November 2024