12637 Courses

LOOKING FOR: MG, YA, ADULT FICTION / NON-FICTION Kesia Lupo joined Donald Maass Literary Agency in 2024 after 11 years working across the publishing industry. She started out as an editorial assistant at Pan Macmillan London in 2013, transitioning to children’s fiction in 2015 when she moved to Chicken House (a UK imprint of Scholastic), where she worked her way up from junior to senior editor. Here she acquired and edited bestselling, internationally successful and prize-winning fiction for middle grade (MG) and YA readers. In 2023 she transitioned over to the US and agenting, working with the Bindery Agency before finding a home with DMLA. At DMLA, Kesia is building a list leaning 60/40 towards MG and YA fiction, with the rest consisting of adult fiction and a smattering of adult non-fiction. She is especially, but not exclusively, interested in underrepresented voices, whether BIPOC, LGBTQ+, neurodivergent, disabled writers or other identities not listed here. Across all age-groups, she’s seeking: Fantasy/Science Fiction: High fantasy, low fantasy, cosy fantasy. Particularly interested in fantasy and SF inspired by underrepresented cultures with unique world-building. Romantasy is fine but the fantasy elements MUST be strong! Horror: Psychological and paranormal horror in particular but will consider slashers. Kesia loves gothic horror and is not generally fazed by gory content. Thrillers: Upmarket thrillers with a unique spin. Loves plot twists! Historical: Open to everything with a strong hook and informed by excellent research. Would love to find non-Eurocentric historical fiction. For adult fiction only, she’s seeking: Bookclub/women’s fiction: Voice-driven, high-concept novels across these categories. Romance: Upmarket romance with a great one-line pitch. Happy with spice. For adult non-fiction, she’s interested in accessible political, cultural or historical topics with broad appeal. Please don’t self-reject – if you are unsure about whether your story might be a good fit, Kesia would rather see it. In one single word document, Kesia 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, whichever is shorter. (In addition to the paid sessions, Kesia 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: Monday 27th January 2025

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

This qualification is for tutors, trainers, or assessors, who are new into their role and looking for development of teaching, training and assessment skills. The qualification is made up of a range of units which can be adapted to any learning and development role, so, whether you are working with groups or individuals; delivering training in classrooms, in the workplace or online; planning training sessions or developing resources, units can be combined to suit your role and career objectives. This qualification is an expansion of the Level 3 Award in Education and Training qualification; it also contains the Assessor units for anyone looking to become a qualified assessor. Please see this link for the full qualification breakdown. This qualification is delivered though monthly workshops and mentoring visits from our Learning Advisor, who will support and advise you to develop your knowledge and skills in learning and development. You will also carry out self study and develop training sessions and materials. The course takes between 9-15 months to complete. You will be able to: Plan and deliver engaging and inclusive teaching and training sessions Adapt training and assessment to meet learners’ individual needs Facilitate learning one to one or in groups Have the option to complete the Assessor qualification as part of the course Use reflective practice to improve on your training and assessment skills Access funding for this qualification as part of an Apprenticeship programme *eligibility criteria apply Further Information To access the apprenticeship funding you must: Be new into role within the last 12 months (and be able to provide a contract with your start date in the role) Complete Essential Skills in Communication, Application of Number and Digital Literacy (or provide GCSE Certificates to be exempt). Workshops are provided. Live or work in Wales Be employed / self employed for a minimum of 16 hours per week Workshops include: • Course induction and Reflective Practice • The purpose and context of Learning and Development • Inclusive Practice: Universal Design for Learning • Session Planning • Teaching Methods and approaches • Micro-teach • The Principles and Practices of Assessment (optional) Partnerships This qualification is delivered in partnership with ALS training who provide funding from the Welsh Government Benefits Gain confidence in your teaching and training skills Gain an industry recognised qualification Learn from our experienced Learning Advisor and have bespoke support and guidance Discover practical tools and techniques you can apply in your training and assessment Develop your own professional network When? The next course start date is June 2024 Where? The workshops are held online. The mentoring visits can either be online or in person depending on location and preference Who? This course is for tutors, trainers or assessors who are new into role within the last 12 months Cost For anyone living or working win Wales, this can be fully funded as part of an Apprenticeship Programme. Please enquire at our office on 029 21679037 for eligibility criteria. 

Spring flowers in watercolour and gouache using strong colours to capture the vibrancy of springtime.

Self Manicure Course

The course is designed for absolute beginners and takes you on a journey with Docker! The course includes animations and labs to enhance your learning experience. A carefully designed course aimed at helping beginners understand Docker concepts vividly.

Change Management Practitioner A successful Practitioner candidate should, with suitable direction, be able to start applying the Change Management™ approaches and techniques to a real change initiative; however, s/he may not be sufficiently skilled to do this appropriately for all situations. His/her individual Change Management expertise, complexity of the change initiative, and the support provided for the use of Change Management approaches in their work environment will all be factors that impact what the Practitioner can achieve. This course will further develop some of the knowledge of Change Management learned during the Foundation certification. You will consider what learning is required and how best to design and deliver it. Then the course will provide an understanding of how Change Management fits into the project management environment. A major challenge with change is making it stick. The course will show how to sustain change by understanding the levers for change, models of adoption, and reinforcing systems. This course also prepares you for the APMG Change Management Practitioner exam. Given that a primary course goal is to achieve the Practitioner Certification, daily homework assignments and practice exams will be provided. The Practitioner-level exam is taken at the end of the second day of the Traditional Classroom course. What You Will Learn You'll learn how to: Understand the key principles in defining what is to be learned by all involved in a change initiative Describe the project environment in which change is governed and delivered Understand the organizational 'levers', adoption approaches, and reinforcing systems typically used to sustain change Improve your ability to pass the APMG Change Management Practitioner Certification exam Getting Started Introductions Course structure Course goals and objectives Learning and Change Defining and managing the required learning to enable change The Project Management Environment Understanding the project environment Identifying key roles Developing a change delivery plan Sustaining Change How levers enable the adoption of change Types of levers (Environmental levers, Leadership levers, and Organizational Development levers) Models of adoption and reinforcing systems APMG Change Management Practitioner Exam Preparation Review of and practice with APMG sample questions and test papers APMG Change Management Practitioner Exam Traditional Classroom: The exam is taken and submitted to APMG for marking. Virtual Classroom: The exam is scheduled by the Participant and taken subsequent to the course.

Learning Outcomes Learn the basics of Python and the simple Python syntax Acquire in-depth knowledge of different data types Know more about various number types Enhance your understanding of functions objects and variadic functions Increase your skills in lambda, generators, classes and many more Equip yourself with the necessary skills in Python and launch your career as a programmer Description Python is one of the most popular programming languages all over the globe, including in the UK. So, whether you want to be a web developer or a software engineer, without having excellent expertise in Python you can not thrive in your respective field. Are you worried to start from the beginning? Then don't worry, the Python 3 for Beginners course will educate you on basic-level Python programming. This course will provide you with a detailed understanding of Python language. In this comprehensive training, you will learn about different data types and simple Python syntax. The course will also educate you on functions objects and variadic functions. Furthermore, you will grasp a clear understanding of object initialization, lambda and much more. Therefore, sign up for our most user-friendly, easy-to-digest and flexible course and complete it to get the CPD- certificate of achievement. This certificate will help you grab the attention of employers. Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post. Method of Assessment When you are done with your learning, you will get some assessment questions that need to pass with a score of 60%. After submitting the assessment, you will immediately receive feedback from our experts.  Career path After completing this course, you will get the chance to explore jobs in the following fields: Web Developer Software Engineer Data Scientist Machine Learning Engineer Data Analyst Course Content Module :01 A Installing Python 00:17:00 Documentation 00:30:00 Command Line 00:17:00 Variables 00:29:00 Simple Python Syntax 00:15:00 Keywords 00:18:00 Import Module 00:17:00 Additional Topics 00:23:00 Module :02 If Elif Else 00:31:00 Iterable 00:10:00 For 00:11:00 Loops 00:20:00 Execute 00:05:00 Exceptions 00:18:00 Data Types 00:24:00 Module :03 Number Types 00:28:00 More Number Types 00:13:00 Strings 00:20:00 More Strings 00:11:00 Files 00:08:00 Lists 00:15:00 Dictionaries 00:04:00 Tuples 00:07:00 Sets 00:09:00 Module :04 Comprehensions 00:10:00 Definitions 00:02:00 Functions 00:06:00 Default Arguments 00:06:00 Doc Strings 00:06:00 Variadic Functions 00:07:00 Factorial 00:07:00 Function Objects 00:07:00 Module :05 Lambda 00:11:00 Generators 00:06:00 Closures 00:10:00 Classes 00:09:00 Object Initialization 00:05:00 Class Static Members 00:07:00 Classic Inheritance 00:10:00 Data Hiding 00:07:00 Mock Exam Mock Exam- Python 3 for Beginners 00:20:00 Final Exam Final Exam- Python 3 for Beginners 00:20:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Overview This comprehensive course on 100 Ways to Make Money Online will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 100 Ways to Make Money Online comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this 100 Ways to Make Money Online. It is available to all students, of all academic backgrounds. Requirements Our 100 Ways to Make Money Online is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 4 sections - 25 lectures - 07:13:00 total length •You Will Love This Class!: 00:04:00 •Executive Summary Part 1: 00:15:00 •Executive Summary Part 2: 00:14:00 •Introduction: 00:02:00 •What Has Worked the Best for Me!: 00:16:00 •From 1 to 25: 00:19:00 •From 26 to 47: 00:20:00 •From 48 to 64: 00:21:00 •From 65 to 83: 00:21:00 •From 84 to 100: 00:19:00 •The No. 1 Method to Work Online: 00:19:00 •How to Successfully Sell Products?: 00:19:00 •Video Courses Are the Best Way to Go: 00:20:00 •Acquiring Customers: 00:17:00 •The Second Method Is Serving Clients: 00:17:00 •Do A Great Job for One Client: 00:20:00 •Patience Is a Virtue: 00:19:00 •Affiliate Marketing: 00:15:00 •An Inside Advantage for Affiliate Marketing: 00:17:00 •A Lot of Affiliate Programs Fail!: 00:17:00 •Advertising Revenue: 00:20:00 •The Best Ad Revenue Opportunities: 00:21:00 •Invest!: 00:21:00 •Investing for the Long Run: 00:22:00 •What now?: 00:18:00

This excellent Power BI covers the Query Editor and Dax Calculations in detail Online Instructor-led Classroom sessions available on request Practical, Hands-on, Interactive