30958 Courses in Liverpool delivered Online

ESI’s High-Performance micro-credential explores the individual salesperson and enables them to develop the mindset and attitude to succeed – all the time. This course guides learners through an examination of their professional selves, their behaviours and how to constantly learn & improve. All leading to higher personal and business performance.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

LOOKING FOR: MG, YA, GRAPHIC NOVELS Katie Blagden is a Literary Agent at The Ampersand Agency, representing authors and author-illustrators across various genres and age ranges. She previously worked with Arabella Stein at the Bright Agency, where she helped launch their Literary list. Her notable projects include the Arcana duology by Sam Prentice-Jones (Macmillan US / Hot Key Books) and The River Thief by Hannah Peck (Piccadilly Press). In all areas Katie seeks commercial, plot-driven ideas with a great hook. In adult fiction, Katie specialises in, and is drawn to, Science Fiction, Fantasy, Speculative Fiction, Magical Realism and Horror. She is particularly looking for works that cross genre lines or subvert reader expectations. She loves Babel by R. F. Kuang; Someone You Can Build a Nest In by John Wiswell; Spinning Silver by Naomi Novik; Chain-Gang All-Stars by Nana Kwame Adjei-Brenyah; Rivers of London by Ben Aaronovich; The Long Way to a Small Angry Planet by Becky Chambers; The City We Became by N. K. Jemisin; Legends & Lattes by Travis Baldree; The Rage of Dragons by Evan Winters; Jonathan Strange & Mr Norrel by Susanna Clarke; The Girl With All The Gifts by M. R. Carey; One Last Stop by Casey Mcquiston; Iron Widow by Xiran Jay Zhao; The Lies of Locke Lamora by Scott Lynch; The Night Circus by Erin Morgenstern; The Familiar by Leigh Bardugo; Kindred by Octavia E. Butler; Earthsea by Ursula K. Le Guin; all and anything by Terry Pratchett! Graphic Novels favoured by Katie are across all ages and include the likes of Homebody by Theo Parish; Lore Olympus by Rachel Smythe; Lumber Janes by N. D. Stevens et al; On A Sunbeam by Tillie Walden; Through The Woods by Emma Carrol; The Magic Fish by Trung Le Nguyen; Heartstopper by Alice Oseman; El Deafo by Cece Bell; Roller Girls by Victoria Jamieson; Skyward by Joe Henderson and Lee Garbett; Faith by Jody Houser. For Graphic Novels, Katie is currently only considering Author-Illustrators (or Author/Illustrator pairings). In children’s, Katie specialises in Middle Grade, YA and Crossover Fiction, She is looking for fast, funny and action-packed Middle Grade. In YA, she is drawn to grounded or contemporary SFF, queer stories and fairytale or folktale inspired works. Examples of books in this area Katie loves are All That's Left in the World by Erik J Brown; The Knife of Never Letting Go by Patrick Ness; Cemetery Boys by Aiden Thomas; Children of Blood and Bone by Tomi Adeyemi; The Deathless Girls by Kiran Millwood Hargrave; Holes by Louis Sachar; Six of Crows by Leigh Bardugo; Gone by Michael Grant; His Dark Materials by Philip Pullman; Impossible Creatures by Katherine Rundell; The Dark Lady by Akala; Percy Jackson by Rick Riordan; The Dark Is Rising by Susan Cooper; Artemis Fowl by Eoin Colfer. Katie is an advocate for centring traditionally underrepresented voices, and actively works to discover and develop authors and author-illustrators from diverse backgrounds. Katie’s previous experience includes marketing, bookselling and advertising. She also appeared as a contributor on the Graham Norton Book Club for Audible for all six seasons. When she’s not reading, you can find Katie playing Dungeons & Dragons, trying a new crafty hobby (before abandoning it for something new), or spoiling her dog Poe. Katie would like you to submit a covering letter, one page synopsis and the first three chapters (Max 5000 words) of your completed manuscript in a single word document. (In addition to the paid sessions, Katie 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: Wednesday 3rd September 2025

Thinking of dipping your toes into the stock market but not quite ready to give up your day job? The Swing Trading Beginners Guide: Part Time Stock Trading Course is tailor-made for those who want to trade smartly, not endlessly. With a sharp focus on timing, strategy, and pattern recognition, this course walks you through how swing trading fits into a part-time schedule without feeling like a second job. Expect clear-cut lessons, strategic breakdowns, and market-tested approaches to help you spot opportunities and understand market movements with logic, not guesswork. Whether you're a curious beginner or someone who's had enough of scrolling through charts without a clue, this guide strips away the jargon and shows you how to trade with confidence—even if your only free time is after dinner. By the end of this course, you will be able to: Understand the difference between day trading and swing trading. Identify trends in the stock market and use them to your advantage. Analyze stocks and determine which ones are suitable for swing trading. Enter and exit stock positions using effective strategies. Set up your trading platform and start swing trading. This Swing Trading Beginners Guide is designed to provide a comprehensive introduction to swing trading. The course starts with an overview of day trading versus swing trading and how swing trading works. It then delves into trading the trend of a stock, finding the best stocks to swing trade, and analyzing stocks using technical and fundamental analysis. The course also covers entering and exiting stock positions, including the use of stop-loss orders and other risk management strategies. Live examples and analysis are provided to help you understand how to apply swing trading principles in real-world scenarios. Finally, the course concludes with a lesson on setting up your trading platform to start swing trading. How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is ideal for highly motivated individuals or teams who want to enhance their professional skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path This course can be beneficial for individuals who want to start trading stocks on a part-time basis. Here are some potential career paths and expected salaries for swing traders: Swing Trader: $50,000 - $100,000 per year Stockbroker: $50,000 - $100,000 per year Financial Analyst: $60,000 - $100,000 per year Investment Manager: $80,000 - $150,000 per year Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

Duration 1 Days 6 CPD hours This course is intended for In this course, students will learn how to establish routines, set goals, create an efficient environment, and use time-honored planning and organizational tools to use their time more effectively. Overview Upon successful completion of this course, students will take ownership of their time management in order to achieve their goals and lead a more productive life. In this course, students will learn how to establish routines, set goals, create an efficient environment, and use time-honored planning and organizational tools to use their time more effectively. Getting Started Icebreaker Housekeeping Items The Parking Lot Workshop Objectives Setting SMART Goals The Three P's The SMART Way Prioritizing Your Goals Evaluating and Adapting The Power of Routines What is a Routine? Personal Routines Professional Routines Six Easy Ways to Simplify Your Life Scheduling Yourself The Simple Secret of Successful Time Management Developing a Tracking System Scheduling Appointments Scheduling Tasks Keeping Yourself on Top of Tasks The One-Minute Rule The Five-Minute Rule What To Do When You Feel Like You're Sinking Tackling New Tasks and Projects Why We Procrastinate Nine Ways to Overcome Procrastination Eat That Frog! Using Project Management Techniques The Triple Constraint Creating the Schedule Using a RACI Chart Creating a Workspace Setting Up the Physical Layout Ergonomics 101 Using Your Computer Efficiently Organizing Files and Folders Organizing Paper Files Organizing Electronic Files Scheduling Archive and Clean-Up Managing E-Mail Using E-mail Time Wisely Taking Action! Making the Most of Your E-mail Program Taking Time Back from Handheld Devices Tackling Procrastination Why We Procrastinate Nine Ways to Overcome Procrastination Eat That Frog Wrapping Up Words from the Wise Review of Parking Lot Lessons Learned Completion of Action Plans and Evaluations

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + CPD Accreditation | Assessment & Tutor Support Included

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + QLS Endorsement | Assessment & Tutor Support Included

Premium Bundle of all Time | Ofqual Regulation + ATHE Awards + QLS Endorsement | Assessment & Tutor Support Included