Teaching courses in London

As a qualified homeopath of 5yrs, I've put together a brilliant offer for newly-qualified homeopaths who know all about remedies but almost nothing about running a successful, busy homeopathy practice. Very limited spaces, and the last time it will be this cheap before prices go up. You'll get a mix of group learning and direct access to me (learning from my mistakes so you don't have to waste time and money on making the same!).

LOOKING FOR: PICTURE BOOKS, MG, YA Clare Wallace joined the Darley Anderson Agency in January 2011 and is building both the Darley Anderson Children’s Agency and the Darley Anderson Illustration Agency lists. As chief talent-spotter, Clare loves to discover memorable new characters, bold and unique voices, strong concepts and gripping storytelling. She represents picture books, middle-grade, teenage and YA. Clare is particularly looking for funny chapter books for younger readers at the moment, as well as contemporary MG, YA fantasy, romance, and rom coms, especially with underrepresented protagonists. Whatever the age range, Clare loves a big hook, a lot of heart, and a standout voice. For picture books she has the widest taste, from daft to lyrical, rhyming to prose. If your submission doesn’t fit a description here, it doesn’t mean Clare doesn’t want to receive it. She often doesn’t know what she’s looking for until she finds it (although she is not the person for steampunk or space opera). Her list gives a good indication of her taste. The clients Clare represents include Perdita & Honor Cargill, Caroline Crowe, Tom Ellen, Martyn Ford, Stewart Foster, Olivia Hope, A M Howell, Polly Ho-Yen, Rachel Ip, Beth Reekles, J.P. Rose, Lindsay Galvin, Dave Rudden, Deirdre Sullivan and Efua Traoré. Clare would like you to send a covering letter, a one page synopsis and the first three chapters (Max 5000 words) of your manuscript. For picture books, please submit a covering letter and up to three completed texts. Please send EITHER picture books OR another genre, not both in one submission. (In addition to the paid sessions, Clare 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

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.

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

Learners will be introduced to the design, installation, commissioning, and maintenance of Access Control systems.

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

An exciting 10-week course to build your Spanish skills from scratch. Practical applications for travel & conversation. Enlarge your vocabulary, improve your grammar in a pain-free, step-by-step way, working with a tutor with 10+ years' experience & a small group of learners.

LOOKING FOR: ADULT FICTION Sarah Williams is a Director of the Sophie Hicks Agency which she joined in 2014 and she has worked as a literary agent for over 10 years. Sarah represents a wide range of adult fiction and non-fiction and as she runs the film and television side of the agency, she is particularly interested in books that have screen potential. She is looking for literary fiction, reading group fiction, memoir and lifestyle/personal development - basically any book that can surprise, change and challenge a reader. Recent favourites are Tides by Sara Freeman, The Paper Palace by Miranda Cowley Heller, Early Morning Riser by Katherine Heiney and In The Dream House by Carmen Maria Machado. Sarah would like you to submit a covering letter, 1 page synopsis and the first 20 - 30 pages of your manuscript in a single word document. (In addition to the paid sessions, Sarah 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 19 November 2024

I am a Reiki Teacher in Manchester and one of the few traditionally trained Reiki Masters in the UK who have been trained by international best-selling Reiki author Penelope Quest. My teaching methods use traditional Reiki techniques perfected over many years and you can be assured of my support during and after your course. I teach all three levels of Reiki courses, level 1 reiki. level 2 reiki and reiki master level 3

LOOKING FOR: PB, CHAPTER BOOKS, MG, GRAPHIC NOVELS, CHILDREN'S NON-FICTION Millie van Grutten joined Caroline Sheldon Literary Agency in 2021 and as of early 2024 Caroline Sheldon Literary Agency was acquired by Rogers Coleridge & White. Millie is thrilled to be building the children’s illustrated division at RCW and is actively looking for authors and illustrators of picture books, chapter books, young fiction, graphic novels and is particularly interested in children’s non-fiction presented in any guise. Millie loves working collaboratively with authors and illustrators whether it’s brainstorming a title, building a portfolio, trying out new genres and age groups or simply chatting ideas through. She relishes the opportunity to champion the work of illustrators and authors alike and is open to anything from 0-9 whether texts, illustrations or both. She loves anything with strong and engaging characters at its heart, quirky stories, and books that make you laugh and/or books that can make you laugh while you learn… Apart from the ever enduring and absolute classics like Quentin Blake’s Mrs Armitage, Millie has recently enjoyed Mariajo Ilustrajo’s Lost, Ed Vere’s The Artist, The Secret Beast Club (Robin Birch and Jobe Anderson), Dave Pigeon (Swapna Haddow and Sheena Dempsey), How to Be A Genius Kid (Jim Smith) and anything by Lauren Child. Among many other talents, Millie represents Swapna Haddow, Zehra Hicks, Sandra Dieckmann, Jobe Anderson, Marilyn Esther Chi, Emma Clarke, Jim Smith, Gabriella Szendrey, Helen and Thomas Docherty. Millie would like you to submit a covering letter, 1 page synopsis and the opening three chapters (max 5,000 words) of your novel. For picture books please send up to three texts split into 12 spreads each and a covering letter. For non-fiction please supply a cover letter and proposal with up to 5,000 words of your sample text. Please send EITHER picture books OR another genre, not both in one submission. (In addition to the paid sessions, Millie 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).  Submission Deadline: Wednesday 20 November 2024