5184 Writing courses in Exmouth delivered Online

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.

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Today, everyone is a publisher. Whether you're filling your company blog with compelling ideas, producing newsletters to engage your customers, packing your social media feeds with engagin content, or crafting insightful posts to push your personal professional profile – you need to use storytelling to engage your audience.  In this workshop we'll break down the key ingredients that make content engaging. We'll go through a proven framework for taking ideas from initial spark, through developing a unique angle, to idenitfying the ideal format for execution.  We'll discuss the purpose of the content you have in mind, and look at how your can plan a strategy to publish regularly and measure the results.  This is a fully interactive online workshop, so be prepared to join discussions and develop your own content ideas.  Takeaways Understanding the needs of your target audience. Identifying the Subject, Angle and Format. Cheap (or free!) tools to create professional content. Useful systmes for publishing regularly, and keeping the work manageable. Knowing where to publish on the web, social media and other platforms. Promoting your content, and getting feedback. Delivery  We deliver our courses over Zoom, to maximise flexibility. The training can be delivered in a single day, or across multiple sessions. All of our courses are live and interactive – every session includes a mix of formal tuition and hands-on exercises. To ensure this is possible, the number of attendees is capped at 16 people.  Tutor Alan Rutter is the founder of Fire Plus Algebra. He is a specialist in communicating complex subjects through data visualisation, writing and design. He teaches for General Assembly and runs in-house training for public sector clients including the Home Office, the Department of Transport, the Biotechnology and Biological Sciences Research Council, the Health Foundation, and numerous local government and emergency services teams. He previously worked with Guardian Masterclasses on curating and delivering new course strands, including developing and teaching their B2B data visualisation courses. He oversaw the iPad edition launches of Wired, GQ, Vanity Fair and Vogue in the UK, and has worked with Condé Nast International as product owner on a bespoke digital asset management system for their 11 global markets.
 Testimonial “The EMpower Network commissioned the content creation workshop to understand how to communicate effectively with a wide range of stakeholders. In light of covid-19, it’s more important than ever to communicate clearly especially as we’ve moved to remote meetings. The workshop was very insightful and Alan was a very engaging speaker making sure all attendees contributed and worked through real-life examples. Attendees praised the usefulness of the workshop and especially liked the content generation framework with one saying 'It has changed the way I think about communicating and given me a toolkit that I will use in both my work and personal projects'.” Shade Nathaniel-Ayodele | EMpower Network, Southwark Council 

Course Description Get instant knowledge from this bite-sized Journal Therapy: Part 1 course. This course is very short and you can complete it within a very short time. In this Journal Therapy: Part 1 course you will get fundamental ideas of journal therapy, the key understanding of journal therapy as a treatment method, the structure of journal writing and so on. Enrol in this course today and start your instant first step towards learning about journal therapy. Learn faster for instant implementation. Learning outcome  Familiarise with journal therapy Understand journal therapy as a treatment method Gain in-depth knowledge of the foundations of therapeutic writing Deepen your understanding of the structure of journal writing Requirement Our Journal Therapy: Part 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Journal Therapy: Part 1 Module 01: Introduction to Journal Therapy 00:10:00 Module 02: Writing to Heal 00:13:00 Module 03: Journal Therapy as a Treatment Method 00:22:00 Module 04: Foundations of Therapeutic Writing 00:13:00 Module 05: Structure of Journal Writing 00:21:00 Assignment Assignment - Journal Therapy: Part 1 00:00:00

Learn how to successfully publish your ebooks, print books and audiobooks on Amazon and other major retailers within 30 days!

Have you ever wondered how the healthcare sector ensures precise communication and knowledge dissemination across various roles? With modern healthcare's increasing complexity and demands, Nurse Prescribing has become a key component in patient care. Dive into our meticulously curated Nurse Prescribing / Non-Medical Prescribing (Nursing) course bundle, uniquely designed to encompass eight significant modules. From the foundational Nurse Prescribing Diploma and Nursing Assistant Diploma to comprehensive insights into Medical Writing, Medical Transcription, and Medical Terminology Training, this bundle ensures a holistic educational journey. Additionally, gain a deeper understanding of Phlebotomist Training, Pharmacy Assistant and Technician Foundation Training, and the pivotal role of Health and Social Care Management. Nurse Prescribing, as a pivotal term within the bundle, serves as a cornerstone to link the relevance of each course together. Key Courses Included Course 01: Nurse Prescribing Diploma Course 02: Nursing Assistant Diploma Course 03: Phlebotomist Training Course 04: Pharmacy Assistant and Technician Foundation Training Course 05: Medical Writing Course 06: Medical Transcription Course 07: Medical Terminology Training Course 08: Health and Social Care Management Learning Outcomes Understand the principles and nuances behind Nurse Prescribing in modern healthcare. Familiarise oneself with standard nursing assistance procedures and responsibilities. Acquire knowledge of the practices and techniques within phlebotomy. Delve deep into the intricacies of pharmacy assistant roles and foundational knowledge. Master the art of medical writing, transcription, and terminology to bolster healthcare communication. Grasp the significance and management aspects of health and social care. In the modern healthcare landscape, the role of Nurse Prescribing has grown in prominence, ensuring a more collaborative and patient-centred approach to care. This course bundle commences with the Nurse Prescribing Diploma, laying down the theoretical groundwork for aspirants. The journey continues with the Nursing Assistant Diploma, delving into the responsibilities and knowledge required for this role. Phlebotomist Training then offers insights into blood collection techniques, followed by the Pharmacy Assistant and Technician Foundation Training that elucidates the foundation of pharmaceutical practices. To ensure seamless communication in healthcare, the modules on Medical Writing, Medical Transcription, and Medical Terminology Training are vital. Concluding the bundle, the Health and Social Care Management course focuses on managing and understanding the broader healthcare spectrum, making Nurse Prescribing a pivotal focus throughout. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is suitable for: Aspiring nurses keen on understanding the essence of Nurse Prescribing. Individuals looking to expand their horizons in healthcare communication roles. Those wanting to familiarise themselves with phlebotomy and pharmacy foundational practices. Professionals in the healthcare sector seeking a more holistic grasp of their field. Students aiming to delve deeper into health and social care management. Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Nurse Prescriber: £35K to £45K/year. Nursing Assistant: £18K to £25K/year. Phlebotomist: £21K to £29K/year. Pharmacy Assistant: £19K to £26K/year. Medical Writer: £28K to £50K/year. Medical Transcriptionist: £20K to £30K/year. Health and Social Care Manager: £30K to £55K/year. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

About this course This practical course will help primary teachers to understand the purpose of assessment in history and consider current best practice. We will explore ways of continuing to improve the quality of teaching and learning in history through effective assessment strategies. We will go through practical ideas and resources to enliven teaching and learning in history and provide opportunities for assessment. This course will provide guidance and support to help develop the accuracy of teacher judgements. During the course, we will look at examples of writing and outcomes from different schools and consider how these outcomes demonstrate progress and attainment in history. Outcomes • understand the purpose of assessment in history • consider current best practice • explore ways of continuing to improve the quality of teaching and learning in history through effective assessment strategies • explore practical ideas and resources to enliven teaching and learning in history and provide opportunities for assessment • provide guidance and support to help develop the accuracy of teacher judgements Course leader The course is led by Steven Kenyon. Steven is a member of the Historical Association’s primary committee, having worked as a primary school teacher and then Deputy Head Teacher between 2004 and 2018. He joined Lancashire Professional Development Service in April 2018 as a Teaching and Learning Consultant for Primary History and English. He works closely with Lancashire Archives to promote and develop local history work in primary schools. This year he is a judge for the Historical Association's Young Quills Awards.

Duration 3 Days 18 CPD hours This course is intended for This course is intended for beginner to intermediate business and requirements analysts who are looking to improve their elicitation and requirements writing and documentation skills. This course is also a great fit for technical writers, product and software testers, project managers, product owners who work closely with business analysts or who perform some for of business analysis themselves. Overview Understand the role of the business analyst and core competencies for performing successfully Discuss the criticality of business analysis and requirements for successful project outcomes Understand the main professional associations and standards supporting business analysts in the industry Discuss the common problems with requirements and explore approaches to address these issues Obtain a clear understanding of the various requirements types and the significance for eliciting each type Demonstrate your ability to identify stakeholders Explore various methods for understanding and analyzing stakeholders Discuss and apply good planning practices to requirements elicitation efforts Obtain knowledge and understanding of over 15 current and commonly applied elicitation techniques Understand how to progress from elicitation to analysis to documentation Write well-formed and validated requirements Gain understanding of the best practices for writing quality requirements Learn the technical writing techniques that apply directly to writing requirements documents Discuss writing pitfalls, risks that impact requirements, and how to address them Learn best practices for communicating and collaborating with stakeholders, sharing the results of elicitation and the resulting documentation Learn approaches for validating requirements Understand the difference between validating requirements and validating the solution With elicitation serving as a major component of the requirements process, it is imperative that business analysts maintain high competency levels in elicitation practices and technique use to help organizations overcome the requirements related challenges faced on projects. Regardless whether you are a practitioner just starting off your career in business analysis or whether you have been performing the role for some years, this course will provide insight into the latest thoughts on elicitation and writing effective requirements and present a number of current techniques that are being applied on projects across industries today. Review of Foundational Concepts Definition of a business analysis Definition of business analyst BA role vs. PM role Business analysis competencies Benefits of business analysis Purpose for having a BA standard IIBA?s BABOK© Guide and PMI?s Practice Guide in Business Analysis Business analysis core concepts Discussion: Project challenges Understanding Requirements Common problems with requirements Understand the problem first Define the business need Situation statements and moving to requirements Understanding requirement types Business requirements Stakeholder/User Requirements Solution Requirements Functional Requirements Non-Functional Requirements Assumptions and Constraints Discussions: Requirement problems, business needs, and identifying non-functional requirements Discovering Stakeholders Definition of a stakeholder Stakeholder types Identifying stakeholders Performing stakeholder analysis Stakeholders and requirements Tips for identifying stakeholders Grouping stakeholders Creating a RACI model Tips for analyzing stakeholders Documenting results of stakeholder analysis Workshop: Discovering stakeholders Preparing for Requirements Elicitation Planning for elicitation Benefits of elicitation planning What do you plan? The elicitation plan Setting objectives for elicitation Determining the scope for elicitation Establishing pre-work Determining the outputs for the session The iterative nature of elicitation Elicitation roles Elicitation planning techniques Discussions: Who to involve in elicitation, planning impacts, and unplanned elicitation Workshop: Planning for elicitation Conduct Requirements Elicitation Elicitation skillset Types of elicitation techniques Using active listening in elicitation Techniques for performing elicitation Benchmarking/Market Analysis Brainstorming Business Rules Analysis Collaborative Games Concept Modeling Data Mining Data Modeling Document Analysis Focus Groups Interface Analysis Interviews Observation Process Modeling Prototyping Survey or Questionnaire Workshops Write Effective Requirements Elicitation and Analysis Requirements related issues Implications of bad requirements Elicitation and documentation Writing skillset Documenting requirements Modeling requirements Defining the project life cycle Impact of project life cycle on documentation Requirements specifications Characteristics of good requirements Guidelines for writing textual requirements Structuring a requirement Writing pitfalls Traceability Requirements attributes Risks associated to requirements Discussions: Project Life Cycle and Correcting Poorly Written Requirements Workshops: Documenting Requirements and Identify Characteristics of Good Requirements Confirm and Communicate Elicitation Requirements Business analysis communication Requirements communication Communication skills The 7 Cs Timing of communication Planning communication Importance of Collaboration Planning collaboration Documenting communication/collaboration needs Confirming elicitation results Verify requirements Characteristics of good requirements (revisited) Requirements checklist Requirements validation Signing off on requirements Discussions: Responsibility for Communication, Eliciting Communication Needs, Validation Signoff Workshops: Communicating Requirements and Obtaining Signoff Evaluate the Solution Business analyst role in solution evaluation Why solutions under perform What we are looking for in solution evaluation When does solution evaluation occur Performing solution evaluation Planning solution evaluation Metrics that might exist Evaluating long term performance Qualitative vs. quantitative measures Tools & techniques used in solution evaluation Comparing expected to actuals When solution evaluation discovers a variance Tools/techniques for analyzing variances Proposing a recommendation Communicating results of solution evaluation Discussion: Addressing Variance Wrap up and Next Steps Useful books and links on writing effective requirements BABOK© Guide Business Analysis for Practitioners: A Practice Guide Additional course details: Nexus Humans BA04 - Eliciting and Writing Effective Requirements 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 BA04 - Eliciting and Writing Effective Requirements 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.

Description The strong growth in the email marketing industry demonstrates what important role emails are playing in promoting a business.

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! If you want to discover how to write genuinely great copy -- quickly and efficiently then sign up for this course today and accelerate your career and showcase your expertise in the field of Copywriting (Copy). Are you ready to amplify your career with compelling, persuasive words? Immerse yourself in the world of copywriting and learn how to use the power of language to drive engagement, conversion, and revenue. Copywriting (Copy) is an in-demand skill with the potential to offer a rewarding career; in the UK alone, there has been a steady rise in job opportunities for competent copywriters, with a potential salary range that extends well into the £40,000 - £60,000 p.a. Domain. This Copywriting (Copy) training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Learning Outcomes of This Copywriting (Copy) Course? Get the basic techniques and styles of Copywriting (Copy) Learn how to generate creative and Eye-Catching headlines Be ready to formulate 'attention-grabbing' marketing advertisements Acquire the skills to implement online and physical examples of copy Explore how to work with mainstream media and other productive sources Get step-by-step direction on blog writing, email marketing, web writing and offline writing Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card with Copywriting (Copy) Innovative and engaging content. Get instant access to this Copywriting (Copy) course. Learn Copywriting (Copy) from anywhere in the world Copywriting (Copy) is affordable and simple to understand Copywriting (Copy) is entirely online, interactive lesson with voiceover audio Lifetime access to the Copywriting (Copy) course materials Copywriting (Copy) comes with 24/7 tutor support Copywriting (Copy) Start your learning journey straightaway with Copywriting (Copy)! This Copywriting (Copy) curriculum has been designed by Copywriting (Copy) experts with years of experience behind them. The Copywriting (Copy) course is extremely dynamic and well-paced to help you understand Copywriting (Copy) with ease. You'll discover how to master the Copywriting (Copy) skill while exploring relevant and essential topics. Assessment Process of Copywriting (Copy) Your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Copywriting (Copy) course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Copywriting (Copy) Anyone interested in learning more about the topic is advised to take this Copywriting (Copy) course. This course is open to everybody. Requirements Copywriting (Copy) You will not need any prior background or expertise to enrol in this Copywriting (Copy) course. Career path Copywriting (Copy) Our Copywriting (Copy) Course Level 4 will assist you in taking your career in the relevant sector to the next level. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.