Teaching & Training courses delivered Online

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.

The purpose of these qualifications is to enable learners to coach clients – one to one and in small groups – towards their health and fitness goals. Learners will develop the knowledge, skills and behaviours to plan and deliver creative and personalised exercise programmes, provide nutritional advice and support clients with their overall lifestyle management.

Build Strength & Confidence: Improve core strength, leg alignment, balance to elevate your dance skills! Join now to Pirita Tuisku´s Dance technic class and keep on dancing!

Clinical coach standardisation events

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.

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.

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.