Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. Relational Database Basics Brief History of SQL Relational Databases Popular Databases SQL Statements Simple SELECTs Introduction to the Northwind Database Some Basics SELECTing All Columns in All Rows Exploring the Tables SELECTing Specific Columns Sorting Records The WHERE Clause and Operator Symbols Using the WHERE clause to check for equality or inequality Using the WHERE clause to check for greater or less than Checking for NULL Using WHERE and ORDER BY Together The WHERE Clause and Operator Words More SELECTs with WHERE Checking Multiple Conditions Writing SELECTs with Multiple Conditions Advanced SELECTs Calculated Fields Calculating Fields Aggregate Functions and Grouping Working with Aggregate Functions Built-in Data Manipulation Functions Data Manipulation Functions Subqueries, Joins and Unions Subqueries Joins Using Joins Outer Joins Unions Working with Unions If time allows, one or more of the following may be covered: Conditional Processing with CASE INSERT, UPDATE, DELETE Student Challenges - Design your own reports
LOOKING FOR: ADULT FICTION, NON-FICTION Siân Ellis-Martin joined Blake Friedmann in 2018 and is building a list of fiction and non-fiction at the agency. With regards to fiction, Siân 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. Siân 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. Siân would 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. Siân would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (or 5,000 words, whichever is shorter) of your manuscript in a single word document. (In addition to the paid sessions, Siân 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. Submission Deadline: Wednesday 13th August 2025
Duration 1 Days 6 CPD hours This course is intended for This course is designed as an introduction to HTML and CSS for those who want to learn to develop standards-compliant web content, with a focus on current HTML5 and CSS3 standards. This course can be taught on Microsoft© Windows©, Apple© Mac OS© X, or Linux©, and supports developers who work in any of those environments. HTML5 is one of the most integral and evolving web technologies that enables a user to structure content and present it on the web.This course lays the foundation for mastering this popular web publishing technology. Authoring Content in HTML Web Development Standards Create an HTML Page Apply HTML Attributes Embedding and Linking Content Embed Content within an HTML Page Link HTML Pages Create Image Maps Formatting Content with CSS Apply Style Sheets to HTML Use CSS to Create Multiple Column Layouts Authoring Complex Content Structures Author Table Content Construct and Format Forms Testing and Publishing HTML Content Identify and Correct Structural and Compatibility Problems Make HTML Content Accessible Publish and Deploy Web Content Additional course details: Nexus Humans HTML5 - Content Authoring 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 HTML5 - Content Authoring 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.
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
Getting to grips with GCSE History At GLA Tutors, we are dedicated to helping students excel in their GCSE History examinations. Our experienced tutors are passionate about history and committed to providing comprehensive support aligned with the AQA examination board's specification. Let's explore the breakdown of the AQA GCSE History specification: Paper 1: Understanding the Modern World This paper focuses on key historical events and developments from the 20th century. Our tutors will guide students through topics such as the origins of World War I, the Treaty of Versailles, the rise of Hitler and the Nazis, the Cold War, and the civil rights movement. We provide in-depth analysis, engaging discussions, and access to a wide range of historical sources to help students develop a deep understanding of these crucial events. Paper 2: Shaping the Nation In this paper, students will explore the history of Britain from medieval times to the present day. Our tutors will delve into topics such as the Norman Conquest, the Tudors, the Industrial Revolution, the British Empire, and the impact of immigration. We provide comprehensive guidance on key historical figures, significant events, and the social, political, and economic changes that shaped the nation. Through interactive lessons and engaging activities, we help students develop a strong grasp of British history. Historical Investigation This component allows students to conduct an in-depth investigation on a topic of their choice. Our tutors will provide guidance on selecting a suitable topic, conducting research, analysing sources, and presenting findings. We help students develop critical thinking skills, research methodology, and the ability to construct coherent and well-supported arguments. This component allows students to develop their historical research skills while exploring a topic of personal interest. At GLA Tutors, we foster a supportive and inclusive learning environment, where students can explore and deepen their understanding of history. Our tutors provide personalised one-on-one sessions, group discussions, and access to a range of learning resources to cater to each student's unique needs. Beyond the specification, we encourage critical thinking, historical empathy, and the ability to analyse and interpret historical sources. We also focus on developing strong exam techniques, essay writing skills, and effective revision strategies to maximise exam success. Join us at GLA Tutors and embark on a transformative journey in GCSE History. Our tutors are here to guide you towards academic excellence, a deeper appreciation for the past, and the ability to critically analyse historical events and their impact on the world today. Feel free to explore our website for more information or reach out to us with any questions you may have. We can provide assistance for everything you need to prepare students for exams, including: past papers, mark schemes and examiners’ reports specimen papers and mark schemes for new courses exemplar student answers with examiner commentaries high quality revision guides
LOOKING FOR: ADULT FICTION, NON-FICTION Diana joined the prestigious DHH Literary Agency in June 2024. She started agenting with Rupert Heath Literary Agency in 2011 before moving to UTA and Marjacq in 2017. Before that she was senior commissioning editor at Transworld. Diana was chosen as one of The Bookseller’s Rising Stars of 2012, was a nominee for RNA Agent of the Year 2019, and was shortlisted for Literary Agent of the Year 2022 at the British Book Awards. Her list includes a wide range of bestselling and prize-winning authors in the UK and internationally. Diana represents adult fiction and non-fiction. For fiction, she is looking for upmarket women's commercial, with depth and heart, including reading group, historical, saga, uplit and contemporary stories that are irreverent and make her laugh; accessible literary fiction, high-concept crime fiction and thrillers. She has a thing for spy novels and would love to find a great vampire story. On the non-fiction side: memoir, smart, funny feminists, lifestyle, cookery and social justice, and open to anything with a strong, original voice. She also encourages submissions from writers who have been traditionally under-represented. Diana would like you to submit a covering letter, 1 - 2 page synopsis and the first three chapters (a maximum of 5,000 words) of your manuscript in a single word document. (In addition to the paid sessions, Diana 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
Interior design tutor one to one open 7 days 9 am to 9 pm
Duration 4.375 Days 26.25 CPD hours This course is intended for The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are: Application designers and database developers Database administrators Web server administrators Overview This eTextbook begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications.
The main topics to be covered in this course are about everyday activities, family, friends, life events, remembering and forgetting, characteristics of people, holidays and more; Students practise their speaking, writing, listening and reading skills in and out of class with their teachers and classmates using their books and applications; The course is based on Ελληνικά Α and Κλικ στα Ελληνικά. In addition, there is a wide range of language material designed by the Greek LOL Teachers. All lessons are supported by educational applications to help students enrich their vocabulary and practise their Greek with fun and interactive exercises, videos and games.
Duration 2 Days 12 CPD hours This course is intended for This in an introductory-level course geared for QA, Test team members and others who want to use the Python testing framework PyTest to implement code testing strategies. Attendees should have prior basic Python scripting experience. Students should have some familiarity with tools to be used in this course: PyCharm, Jupyter Notebook and basic GIT. Overview Working within in a hands-on learning environment students will learn to: Become proficient with pytest from day one by solving real-world testing problems Use pytest to write tests more efficiently Scale from simple to complex and functional testing Write and run simple and complex tests Organize tests in fles and directories Find out how to be more productive on the command line Markers and how to skip, xfail and parametrize tests Explore fxtures and techniques to use them effectively, such as tmpdir, pytestconfg, and monkeypatch Convert unittest suites to pytest using little-known techniques The pytest framework is simple to use but powerful enough to cover complex testing integration scenarios. PyTest is considered by many to be the true Pythonic approach to testing in Python. Geared for QA, Test team members and others who want to use the Python testing framework PyTest to implement code testing strategies, Test Automation with Python is a hands-on, two day Python testing course that provides students with the skills required to get started with PyTest right away. Participnats will learn how to get the most out of it in their daily workflow, exploring powerful mechanisms and plugins to facilitate many common testing tasks. Students will also learn how to use pytest in existing unittestbased test suites and will learn some tricks to make the jump to a pytest-style test suite quickly and easily. Python Refresher Python Overview Python Basics Python Lab Introducing PyTest Why Spend time writing test UnitTest Module Why PyTest? Introductory Lab Writing and Running Test Installing PyTest Writing and Running Tests Organizing files and packages Command Line options Configure pytest.ini Install and Config Lab Markers and Parameters Mark Basics Built-in marks Parameterization Markers and Parameters Lab Fixtures Introduction to Fixtures Sharing fixtures with conftest.py files Scopes Autouse Parameterizing fixtures Using marks from fixtures Built-in fixtures Best Practices Fixtures Lab Fixtures Lab 2 Plugins Finding and installing plugins Overview of plugins Plugin Lab From UnitTest to PyTest Use PyTest as a Test Runner Convert asserts with unitest2pytest Handling setup/teardown Managing test hierarchies Refactoring test utilities Migration strategies Additional course details: Nexus Humans Test Automation with Python (TTPS4832) 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 Test Automation with Python (TTPS4832) 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.