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.
Duration 5 Days 30 CPD hours This course is intended for This course is intended for administrators in a Microsoft-centric environment who want to build reusable units of automation, automate business processes, and enable less-technical colleagues to accomplish administrative tasks. Overview Describe the correct patterns for building modularized tools in Windows PowerShell Build highly modularized functions that comply with native PowerShell patterns Build controller scripts that expose user interfaces and automate business processes Manage data in a variety of formats Write automated tests for tools Debug tools This course covers advanced Windows PowerShell topics, with an emphasis on building reusable tools. Students are introduced to workflow, engage in best practices, and learn a variety of script development and toolmaking techniques. Tool Design Tools do one thing Tools are flexible Tools look native Start with a Command Why start with a command? Discovery and experimentation Build a Basic Function and Module Start with a basic function Create a script module Check prerequisites Run the new command Adding CmdletBinding and Parameterizing About CmdletBinding and common parameters Accepting pipeline input Mandatory-ness Parameter validation Parmeter aliases Emitting Objects as Output Assembling information Constructing and emitting output Quick tests An Interlude: Changing Your Approach Examining a script Critiquing a script Revising the script Using Verbose, Warning, and Informational Output Knowing the six channels Adding verbose and warning output Doing more with verbose output Informational output Comment-Based Help Where to put your help Getting started Going further with comment-based help Broken help Handling Errors Understanding errors and exceptions Bad handling Two reasons for exception handling Handling exceptions in our tool Capturing the actual exception Handling exceptions for non-commands Going further with exception handling Deprecated exception handling Basic Debugging Two kinds of bugs The ultimate goal of debugging Developing assumptions Write-Debug Set-PSBreakpoint The PowerShell ISE Going Deeper with Parameters Parameter positions Validation Multiple parameter sets Value from remaining arguments Help messages Aliases More CmdletBinding Writing Full Help External help Using PlatyPs Supporting online help ?About? topics Making your help updatable Unit Testing Your Code Sketching out the test Making something to test Expanding the test Going further with Pester Extending Output Types Understanding types The Extensible Type System Extending an object Using Update-TypeData Analyzing Your Script Performing a basic analysis Analyzing the analysis Publishing Your Tools Begin with a manifest Publishing to PowerShell Gallery Publishing to private repositories Basic Controllers: Automation Scripts and Menus Building a menu Using UIChoice Writing a process controller Proxy Functions A proxy example Creating the proxy base Modifying the proxy Adding or removing parameters Working with XML Data Simple: CliXML Importing native XML ConvertTo-XML Creating native XML from scratch Working with JSON Data Converting to JSON Converting from JSON Working with SQL Server Data SQL Server terminology and facts Connecting to the server and database Writing a query Running a query Invoke-SqlCmd Thinking about tool design patterns Design tools that use SQL Server for data storage Final Exam Lab problem Break down the problem Do the design Test the commands Code the tool
Gain essential healthcare skills with this CPD-accredited Care Certificate course. Master 15 key standards & boost your career in health & social care.
To understand psychopathology, one must learn a foreign language, lend an ear as it were to a language that is complex and symbolic. We aim to explore the lived experiences on irregular perceptions of reality with an open mind. Each Saturday includes: a live dialogue between Prof. Ernesto Spinelli and an International Existential Therapist; a moment to share your thoughts and feelings with the teachers; and a final integration facilitated by Bárbara Godoy. This series of ten dialogues set out to explore the multifaceted dimentions and complexities associated with Existential Therapies. It attempts to engage with various interpretations of insanity through the lens of patients often painful, confounding, and deeply unsettling life experiences. Character- between Prof. Ernesto Spinelli and Prof. Robert Romanyshyn “I begin with the term psychopathology to emphasize that the word is about the logos—the thinking/speaking—about the sufferings of the psyche. To understand psychopathology, one must learn a foreign language, lend an ear as it were to a language that is complex, symptomatic, symbolic, and embodied. As complex, psychopathology reveals and conceals the sufferings of psyche. As symptomatic, psychopathology reminds one of things too important to forget but which are forgotten because they are too painful to remember. As symbolic, psychopathology is neither about facts nor ideas but about images, alchemical vessels that not only hold and contain psyche’s sufferings, but also cooks them. As embodied, psyche’s sufferings are inscribed in the flesh, etched as lines of character. To practice psychotherapy as an existential therapist situates therapist and patient in a dialogical field that is complex, symptomatic, symbolic, and embodied as a gestural field between them.” Prof. Robert Romanyshyn. Prof. Robert D. Romanyshyn, an Affiliate Member of The Inter-Regional Society of Jungian Analysts, a Fellow of the Dallas Institute of Humanities and Culture, and a Professor Emeritus of Clinical Psychology at Pacifica Graduate Institute, was recently awarded the Distinguished Lifetime Contributions to Humanistic Psychology Award from the Society for Humanistic Psychology APA Division 32. He has published eight books and numerous articles in psychology, philosophy, education, and literary journals. He is also a published poet and has written a one-act play about Frankenstein. In 2009 he created a multi-media DVD entitled Antarctica: Inner journeys in the Outer World, which offers a psychological reflection on the melting polar ice. In addition to online seminars and interviews, he has given lectures and workshops at universities and professional societies in the U.S., Europe, Australia, South Africa, Canada, and New Zealand. Prof. Ernesto Spinelli was Chair of the Society for Existential Analysis between 1993 and 1999 and is a Life Member of the Society. His writings, lectures and seminars focus on the application of existential phenomenology to the arenas of therapy, supervision, psychology, and executive coaching. He is a Fellow of the British Psychological Society (BPS) as well as an APECS accredited executive coach and coaching supervisor. In 2000, he was the Recipient of BPS Division of Counselling Psychology Award for Outstanding Contribution to the Profession. And in 2019, Ernesto received the BPS Award for Distinguished Contribution to Practice. His most recent book, Practising Existential Therapy: The Relational World 2nd edition (Sage, 2015) has been widely praised as a major contribution to the advancement of existential theory and practice. Living up to the existential dictum that life is absurd, Ernesto is also the author of an on-going series of Private Eye novels. Date and Time: Saturday 3 May from 2 pm to 3 pm – (UK time) Individual Dialogue Fee: £70 Venue: Online Zoom FULL PROGRAMME 2025: 25 January “Knots” with Prof. Ernesto Spinelli and Bárbara Godoy 22 February “Healing” with Dr. Michael Guy Thompson and Prof. Ernesto Spinelli 22 March “Difference” with Prof. Tod DuBose and Prof. Ernesto Spinelli 12 April “Polarisation” with Prof. Kirk Schneider and Prof. Ernesto Spinelli 3 May “Character” with Prof. Robert Romanyshyn and Prof. Ernesto Spinelli 21 June “Opening” with Dr. Yaqui Martinez and Prof. Ernesto Spinelli 19 July “Meaning” with Dr. Jan Resnick and Prof. Ernesto Spinelli 25 October “Invention” with Dr. Betty Cannon and Prof. Ernesto Spinelli 15 November “Hallucination” with Prof. Simon du Plock and Prof. Ernesto Spinelli 13 December “Hysteria” with Bárbara Godoy and Prof. Ernesto Spinelli Read the full programme here > Course Organised by:
LOOKING FOR: ADULT FICTION Nicky Lovick has worked as an editor for over twenty years, working for top five publishers. She is now an agent at WGM Talent, building the books list. She is looking for commercial fiction, from upmarket women’s fiction, bookclub, romance, domestic noir and psychological thrillers, to crime series. She loves hooky stories such as Freida McFadden’s The Housemaid and Turn of the Key by Ruth Ware set in confined settings, such as hotels. She’s always on the lookout for romcoms with a fresh, contemporary feel to them such as Emily Henry’s Book Lovers. Also historical fiction with a twist and sweeping family sagas. Nicky wants you to make her laugh, make her cry or keep her hooked. Nicky would like you to submit a covering letter, 1-2 page synopsis and the opening three chapters of your manuscript in a single word document. (In addition to the paid sessions, Nicky 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 21st April 2025
AET Level 3 Award in Education and Training Are you bored of searching the internet for a AET Level 3 Award in Education and Training (Formerly PTLLS) course? Can't manage to discover a proper course that meets all of your requirements? Don't worry, you've just discovered the solution. Take a moment to browse through this comprehensive PTLLS course that includes everything you need to succeed. The AET Level 3 Award in Education and Training (Formerly PTLLS) programme is intended for individuals who want to work in education, most likely as early age instructors and trainers in a variety of contexts. This is the first step in becoming an entry-level teacher in the United Kingdom. Furthermore, the AET Level 3 Award in Education and Training (Formerly PTLLS) is accredited by TQUK, one of the leading awarding organisations in the UK! AET Level 3 Award in Education and Training (Formerly PTLLS) is the mandatory minimum qualification if you want to be a FE teacher or trainer in your chosen field in the UK. If you are thinking about getting into teaching, this AET Level 3 Award in Education and Training, previously known as the PTLLS course, is a great way to start. As a teacher, you can play a significant role in society and positively impact your students' lives. Currently, there is a huge demand for teaching jobs across the globe, and you know how satisfying it could be! So, if you aspire to be a changemaker, this is the ultimate course we can offer you. This PTLLS course is designed so that both freshers and those working in an educational setting can get the benefit. Further, through this PTLLS course, the current teachers can achieve formal recognition of their skills. Awarding Body The AET Level 3 Award in Education and Training (Formerly PTLLS) is accredited by TQUK. A certificate from this renowned awarding body will bring you out as a highly marketable candidate within the desired industry. There is Something More for You with this AET Level 3 Award in Education and Training (Formerly PTLLS) Course. Although we understand, many of you only come to search for PTLLS or AET courses but still here is a small gift for learners. As a course provider, we highly value our learners’ needs. That is why we are giving you some relevant courses with AET Level 3 Award in Education and Training (Formerly PTLLS) Course. Because these extra teaching and training courses will benefit you. With these courses, you can further enrich your knowledge and employability skills. Here are those - Learning Outcomes of the AET/PTLLS - Level 3 Award in Education and Training - AET Course By the end of this course, you will be able to: AET/PTLLS: Identify and perform the roles of a teacher. AET/PTLLS: Explain and apply the teaching and learning approaches. AET/PTLLS: Plan a training session for your learners of different backgrounds. AET/PTLLS: Describe the teachers' attributes and expectations. AET/PTLLS: Prepare inclusive lessons and training sessions for your students. AET/PTLLS: Analyse the role, responsibilities and relationships in education and training. AET/PTLLS: Prepare and administer necessary assessments for your students. This AET Level 3 Award in Education and Training (Formerly PTLLS) programme will be the perfect choice for any individual to kickstart a new career. Anyone who wants to pursue a career in education will find it gratifying and enjoyable. It is a good occupation since you will not only satisfy your own growth. Also it will assist many learners in achieving theirs. It is also a high-demand business, with many schools and universities looking for qualified instructors. It is a job in which you will not only teach but also learn. The PTLLS Training is a nationally recognised award for anybody who is presently teaching or training. Moreover, This PTLLS Training will help those who desire to enter the field and get the necessary qualifications to work as a teacher or trainer. Description AET: AET Level 3 Award in Education and Training (Formerly PTLLS) The AET Level 3 Award in Education and Training fulfils - Industry requirements and will help you get a full grasp of a teacher and trainer's duties and responsibilities, The boundaries imposed with regard to teaching, and how to present motivating class sessions to encourage students. By learning this AET Level 3 Award in Education and Training (Formerly PTLLS) You will learn about the role, responsibilities, and duties of a teacher. Besides, you will be able to identify the significance of your existence in your students' lives. Also, You will know how you can bring effective change to them with your influence through this PTLLS Training. Further, inclusive teaching and learning is a very important concept in an educational setting. That is why we have included this AET Level 3 Award in Education and Training (Formerly PTLLS) in our course so that you can learn. Besides, you will get an in-depth idea about how to perform an assessment. AET Level 3 Award in Education and Training (Formerly PTLLS) Course Curriculum Module 01: Understanding Roles, Responsibilities and Relationships in Education and Training Module 02: Understanding and Using Inclusive Teaching and Learning Approaches in Education and Training Module 03: Understanding Assessment of PTLLS AET Level 3 Award in Education and Training (Formerly PTLLS) Qualification at a Glance Total Qualification Time (TQT - 120 Hours Guided Learning Hours (GLH) - 48 Hours Credit Value - 12 Minimum Age - 19 AET Level 3 Award in Education and Training (Formerly PTLLS) Assessment Method PTLLS To be eligible for the certification, you need to complete the following assessments. Three written assignments One microteaching session - 60 Minutes (Which can be submitted as a recorded video) Please note that you will be given precise instruction in the course material about writing the assignments and performing the micro-teach session. Moreover, if you face any difficulty, your tutor will be there to support you. You must submit all assignments via the online portal with full tutor support. Who is this course for? AET: AET Level 3 Award in Education and Training (Formerly PTLLS) Wherever you work, this AET Level 3 Award in Education and Training (Formerly PTLLS) is a must for you if you want to become a trainer. Besides, this PTLLS course is also appropriate for the following. Teacher & Trainer Consultant Job Hunters & School Leavers College or University Students & Graduates Tutors & Instructors Headmasters Education Consultants Education Providers Office Clerk & Administration Assistant Educational Psychologist Lecturer or Classroom Assistant Career path AET: AET Level 3 Award in Education and Training (Formerly PTLLS) You can choose from a variety of professions either in teaching or training upon completion of the AET Level 3 Award in Education and Training (Formerly PTLLS). These include Primary School Teacher Secondary School Teacher Further Education Teacher Private Tutor Freelance Trainer Trainer at Your Workplace
LOOKING FOR: MG, YA, ADULT FICTION, ADULT NON-FICTION, NON-FICTION FOR 7+ Megan Carroll is looking for writers in a variety of areas, and from a wide range of backgrounds – she is particularly keen to hear from Black, Asian, and LGBTQIA+ writers. Her main areas of focus this year are adult fiction and non-fiction, as well as non-fiction for 7+, and MG and YA fiction. In Fiction, Megan is keen to see high-concept love stories (think The Flat Share or The Lock In) for both commercial and reading group readers. She’d love to see those familiar romance tropes – enemies to lovers, friends to lovers, love triangles, forbidden love etc. – with underrepresented characters at the centre. She is also looking for historical fiction and gothic horror (think Laura Purcell, Stacey Halls and Silvia Moreno-Garcia) – anything that has a creepy, uneasy undertone is likely for Megan’s list. Megan is also actively looking for upmarket fiction and would love to see layered family drama, contemporary stories about life today and darkly comic novels that explore a specific time, place or experience. In Non-Fiction, Megan is keen to hear from experts in their field talking about topics relating to film, music, true crime, popular culture, history and issues from largely unrepresented perspectives. She is keen to see memoir, narrative non-fiction and essay collections. In Children’s and YA, she is keen to see contemporary YA with humour, and romance at the heart – fun and emotional stories that appeal to the interests and issues of the teenage readers. She’d also love to see thrillers and horror stories for this age group too. It’s unlikely that high fantasy novels for YA readers will be right for her, but she is keen to see stories with fantasy elements in a real world setting. On the younger end, Megan is looking for funny, contemporary middle grade – think Louise Rennison and Karen McCombie – and anything creepy and spooky for 8-12 year old readers too. She’d love to find something like Lemony Snicket’s A Series of Unfortunate Events and is keen to find original adventure stories in both fantasy and realistic settings. Megan would like you to submit a covering letter, 1 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, Megan 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: Thursday 24th April 2025
Duration 2 Days 12 CPD hours This course is intended for This introductory-level course is intended for Business Analysts and Data Analysts (or anyone else in the data science realm) who are already comfortable working with numerical data in Excel or other spreadsheet environments. No prior programming experience is required, and a browser is the only tool necessary for the course. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Throughout the hands-on course students, will learn to leverage Python scripting for data science (to a basic level) using the most current and efficient skills and techniques. Working in a hands-on learning environment, guided by our expert team, attendees will learn about and explore (to a basic level): How to work with Python interactively in web notebooks The essentials of Python scripting Key concepts necessary to enter the world of Data Science via Python This course introduces data analysts and business analysts (as well as anyone interested in Data Science) to the Python programming language, as it?s often used in Data Science in web notebooks. This goal of this course is to provide students with a baseline understanding of core concepts that can serve as a platform of knowledge to follow up with more in-depth training and real-world practice. An Overview of Python Why Python? Python in the Shell Python in Web Notebooks (iPython, Jupyter, Zeppelin) Demo: Python, Notebooks, and Data Science Getting Started Using variables Builtin functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control White space Conditional expressions Relational and Boolean operators While loops Alternate loop exits Sequences, Arrays, Dictionaries and Sets About sequences Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions Generator Expressions Nested sequences Working with Dictionaries Working with Sets Working with files File overview Opening a text file Reading a text file Writing to a text file Reading and writing raw (binary) data Functions Defining functions Parameters Global and local scope Nested functions Returning values Essential Demos Sorting Exceptions Importing Modules Classes Regular Expressions The standard library Math functions The string module Dates and times Working with dates and times Translating timestamps Parsing dates from text Formatting dates Calendar data Python and Data Science Data Science Essentials Pandas Overview NumPy Overview SciKit Overview MatPlotLib Overview Working with Python in Data Science Additional course details: Nexus Humans Python for Data Science: Hands-on Technical Overview (TTPS4873) 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 Python for Data Science: Hands-on Technical Overview (TTPS4873) 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.