815 Courses in Cardiff delivered Online

Efficient ways to create professional-looking diagrams, images and screenshots Cherryleaf’s elearning course on creating screenshots and images for user guides gives you the foundations for creating professional images in an efficient way. The course includes exercises and model answers for the delegates to complete and review. Why attend this course? Creating screenshots, diagrams and images is something that every technical communicator needs to do, but very few have had any formal training in how to do it. Sometimes, the result is that the user guides and online Help contain images that are unclear, inconsistent, and frankly, unprofessional. They can make the product look like it's poor quality. Creating them can also tie up the Technical Writer's time, especially if they need to be changed frequently. Who is this course for? Anyone developing user guides and online Help who wants: A foundational understanding of how to use diagrams, screenshots and images, in an effective and efficient way. To see practical, real-world examples. It’s ideal for you if you’re: Creating screenshots, diagrams or images, but you’ve never had any proper training in how to do this well. Looking for more efficient ways to create or change screenshots, diagrams or images for end user or developer documentation. We’ll take you from first principles, so all you need is a basic understanding of what is a user guide. What you'll learn Cherryleaf's e-learning course on creating screenshots and images for user guides gives you the foundations for creating professional images in an efficient way. The goal of the course is to enable you to use diagrams, images and screenshots to communicate to your audience, with a focus on simplicity and ease of understanding. This is accomplished through a mix of design theory, best practices, software, and practical application. Please note, we don’t focus on highly detailed technical illustrations or 3D drawings that you might find in the aerospace or automotive industries. Also, the course does not cover Augmented Reality or Virtual Reality. You'll go through the key stages in developing screenshots, diagrams, and other images:in developing images. You’ll learn to understand the context, choose an effective visual display method, focus the user's attention, apply design best practices, and use the appropriate software tools to communicate your message. Introduction Understand the context Choose an appropriate visual display methodScreenshotsSimplified User InterfaceDiagramsAspect ratioIconsImage mapsWordless guides Focus attention where you want itGestalt theoryWhite space Think like a designerLayoutColourAccessibilityStyle guides SoftwareSoftware toolsSVGAutomating tasksStock imagesPresentation applications Animations Summary The course contains 22 exercises (and suggested answers) for you to practice your skills. Delivery format The course comprises eight modules in total, which you can complete at your own pace. The course will take delegates approximately 1 day to complete. You will have access to the modules from the moment you subscribe. You can download the course handouts. The courses are hosted and sold by via the Teachable platform. From a VAT perspective, they are the “Merchant of Record”, and receipts contain their VAT number. You have the option of taking the course on an iPhone or iPad, using the MyTeachable app in the Apple App Store. Prerequisites We'll take you from first principles, so all you need is a basic understanding of what is a user guide. You'll need access to PowerPoint, or a similar application, in order to complete some of the exercises. And it will help if you have a copy of Snagit. Our expertise As well as teaching technical communication, we also create end-user documentation, Help and UI text for clients. This means every course is based on practical experience of technical communication in today’s environment. Your Instructor Cherryleaf Cherryleaf is a technical writing services company formed in 2002 by people with a passion for technical communication and learning development. Cherryleaf is recognised as a leader within the technical communication profession. Our staff have written articles for the Society for Technical Communication's (STC) Intercom magazine, the Institute of Scientific and Technical Communicator's Communicator journal and tekom's TCWorld magazine. They've also written books on technical communication. We've presented webinars for Adobe, Madcap Software or the STC, and we've spoken at various conferences around the world. Today, organisations throughout Europe use Cherryleaf’s services so they can provide clear information that enables users and staff to complete tasks productively. Course Curriculum First Section Introduction (2:37) Understand the context (14:22) Choose an appropriate visual display method (55:15) Focus attention where you want it (10:39) Think like a designer (32:18) Software (70:12) Animations (21:09) Summary (1:59) Answers  Frequently Asked Questions When does the course start and finish? The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.How long do I have access to the course?How does lifetime access sound? After enrolling, you have unlimited access to this course for as long as you like - across any and all devices you own.What if I am unhappy with the course?We would never want you to be unhappy! If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a full refund.

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by: CPD UK & Quality License Scheme Tutor Support: Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime: With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want This course helps you to bring your mini tales to life with concise storytelling techniques, and the power to create memorable characters and captivate readers, empowering you to build a fulfilling career in fiction writing. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Learn how to find inspiration and find the time to write Know what it means to be a writer Understand the characters while writing Know plotting and story construction Understand theme, templates and outlining Learn punctuation, grammar and some basic writing rules Know scene structure, exposition, and story rules Understand chapter structure, vision and focus Learn editing, re-writing and polishing Understand finishing, submission, and publication Why Mini Fiction Writing Course right for you? This comprehensive Mini Fiction Writing course is the perfect way to kickstart your career in the field of fiction writing. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Mini Fiction Writing Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum Lesson 01: People Are The Key Lesson 01: People Are The Key Lesson 02: All Plot is Character Driven Lesson 02: All Plot is Character Driven Lesson 03: Tornado Plotting Lesson 03: Tornado Plotting Lesson 04: Use All Your Senses Lesson 04: Use All Your Senses Tornado Plotting - Graphic Representation Tornado Plotting - Graphic Representation Course Discussion Forum Course Discussion Forum Teach Yourself to Write Teach Yourself to Write The Easy Way to Write a Novel That Sells - Book Version Text The Easy Way to Write a Novel That Sells - Book Version Text Who should take this course? This comprehensive Mini Fiction Writing course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of fiction writing. Entry Requirements There are no academic entry requirements for this Mini Fiction Writing course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by: CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime: With 1 year access to the course materials Online Learning: Learn from anywhere, whenever you want Why Craft of Writing Course right for you? Whether you are self-taught and you want to fill in the gaps for better efficiency and productivity, this Craft of Writing course will set you up with a solid foundation to become a confident writer and develop more advanced skills. This comprehensive Craft of Writing course is the perfect way to kickstart your career in the field of writing. This course will give you a competitive advantage in your career, making you stand out from all other applicants and employees. As one of the leading course providers and most renowned e-learning specialists online, we're dedicated to giving you the best educational experience possible. This course is crafted by industry expert, to enable you to learn quickly and efficiently, and at your own pace and convenience. Craft of Writing Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Course Curriculum How to Write FAST How to Write FAST Write Anytime, Anywhere Write Anytime, Anywhere How to Cure Writer's Block Forever How to Cure Writer's Block Forever Rob's 7 Secrets of Success Rob's 7 Secrets of Success Creating Story Templates Creating Story Templates The Fantasy Fiction Formula The Fantasy Fiction Formula Find Your Unique Voice Find Your Unique Voice Find Your Unique Voice Find Your Unique Voice The Secret Ingredient to Writing The Secret Ingredient to Writing Baring Your Soul Baring Your Soul Writing Dialogue in Fiction Writing Dialogue in Fiction Description in Fiction Description in Fiction The Rob Parnell Author Interview The Rob Parnell Author Interview The Easy Way to Write Explained The Easy Way to Write Explained What is Bad Writing What is Bad Writing Why Does Fiction Matter Why Does Fiction Matter Location in Fiction Location in Fiction Objectivity in Fiction Objectivity in Fiction How to Create Intrigue in Fiction How to Create Intrigue in Fiction Writing a Blockbuster Novel - The Formula Writing a Blockbuster Novel - The Formula Who should take this course? This comprehensive Craft of Writing course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of writing. Entry Requirements There are no academic entry requirements for this Craft of Writing course, and it is open to students of all academic backgrounds. As long as you are aged seventeen or over and have a basic grasp of English, numeracy and ICT, you will be eligible to enrol. Assessment Method On successful completion of the course, you will be required to sit an online multiple-choice assessment. The assessment will be evaluated automatically and the results will be given to you immediately. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

***24 Hour Limited Time Flash Sale*** Proofreading & Copy Editing Diploma Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Proofreading & Copy Editing Diploma Bundle provides unique insights and tools that can help you achieve your goals. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Proofreading & Copy Editing Diploma bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Proofreading & Copy Editing Diploma Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Proofreading & Copy Editing Diploma Career Bundle: Course 01: Proofreading & Copyediting - CPD Accredited Course 02: Proofreading and Copy Editing Skills Training Course 03: Proofreading and Editing Masterclass Course 04: Proofreading Basics Course 05: Proofreading Hacks Course 06: Proposal Writing and Document Proofreading Course 07: Freelance Masterclass - Become An Expert Copywriter Course 08: B2B Copywriter Course 09: English Writing Perfection Course Course 10: Explore the Fundamentals of English Tenses Course 11: Introduction to English Spelling, Punctuation, and Grammar Training Course 12: 200 Common English Idioms and Phrases Course 13: Creative Writing Complete Course Course 14: Essay Writing in English Course 15: Poetry Writing Course 16: Novel Writing and Publishing Course 17: Crime Fiction Writing Certificate Level 2 Course 18: Playwriting and Screenwriting Course Course 19: Script Writing Course 20: Content Writing & Copy Writing For SEO and Sales Course 21: Researching & Report Writing Course 22: Bid Writing Course 23: Effective Email Writing Course 24: Report Writing Course 25: News Writing: Journalism 101 Course 26: Medical Writing Course 27: Diploma in Effective Writing Skills Course 28: Modern Copywriting Techniques Course 29: ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! Course 30: Smart Goal Setting With a Proofreading & Copy Editing Diploma, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Learning Outcomes of Proofreading & Copy Editing Demonstrate a deep understanding of English grammar, punctuation, and spelling rules. Write clearly, concisely, and persuasively in various writing styles. Identify and correct errors in grammar, spelling, and punctuation. Craft compelling and persuasive copy that effectively communicates a message. Optimize written content for search engines to improve visibility and reach. Don't let this opportunity pass you by. Enrol in the Proofreading & Copy Editing Diploma today and take the first step towards achieving your goals and dreams. Why buy this Proofreading & Copy Editing Diploma? Free CPD Accredited Certificate upon completion of Proofreading & Copy Editing Diploma Get a free student ID card with Proofreading & Copy Editing Diploma Lifetime access to the Proofreading & Copy Editing Diploma course materials Get instant access to this Proofreading & Copy Editing Diploma course Learn Proofreading & Copy Editing Diploma from anywhere in the world 24/7 tutor support with the Proofreading & Copy Editing Diploma course. Start your learning journey straightaway with our Proofreading & Copy Editing Diploma Training! The Proofreading & Copy Editing Diploma premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Proofreading & Copy Editing Diploma is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Proofreading & Copy Editing Diploma course. After passing the Proofreading & Copy Editing Diploma exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Proofreading & Copy Editing Diploma course is ideal for: Students seeking mastery in Proofreading & Copy Editing Professionals seeking to enhance Proofreading & Copy Editing skills Individuals looking for a Proofreading & Copy Editing-related career. Anyone passionate about Proofreading & Copy Editing Requirements This Proofreading & Copy Editing Diploma doesn't require prior experience and is suitable for diverse learners. Career path This Proofreading & Copy Editing Diploma bundle will allow you to kickstart or take your career in the related sector to the next stage. Freelance editor Technical writer Content creator Copywriter Proofreader Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Local SEO For The Small Business Owner will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Local SEO For The Small Business Owner will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Local SEO For The Small Business Owner and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Local SEO For The Small Business Owner is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this Local SEO For The Small Business Owner. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The Local SEO For The Small Business Owner will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Introduction To The Course What To Expect In This Course 00:01:00 Who Am I? Why I Created This Course 00:03:00 What is local SEO? 00:04:00 Pricing - This Course Vs. Using An SEO Agency 00:03:00 Setting Up a Simple Website for Business Do You Build Your Own Website Or Pay Someone Else To Build It? 00:02:00 Why Your Website Must Be Mobile Friendly in 2015 00:02:00 Learning WordPress - A Simple Content Management System 00:03:00 Squarespace - Simple For The 'Do It Yourself' Crowd 00:03:00 Setting Up Your Google+ Business Page Introduction To Google+ For Business 00:02:00 A Poor Google+ Business Page Vs. a Good Google+ Business Page 00:06:00 An Example Google+ Business Page Setup 00:05:00 Using Canva To Create a Header Image 00:02:00 Posting on Google+ For Business 00:02:00 Setting Up Your Yelp Business Page Setting Up a Yelp Business Page 00:02:00 Basic Social Media Setup Facebook Business Page Setup 00:03:00 Setting Up a LinkedIn Business Page 00:02:00 Setting Up a Twitter Profile 00:02:00 Run a Social Media Contest To Generate Buzz 00:02:00 Creating Business Listings for Local SEO Name, Address, and Phone Consistency For Your Business 00:03:00 Building Citations (aka Business Listings) 00:09:00 What are Data Aggregators? 00:03:00 Tools For Building Citations, Rank Tracking & More Check Citation Errors For Free With Moz Local 00:06:00 Using Brightlocal for Building Citations, Monitoring Reviews, Tracking & More 00:07:00 GeoRanker For Checking Your Rankings 00:01:00 UpCity Local SEO 00:12:00 Optimizing Your Website for Local SEO Adding Name, Address, and Phone (NAP) To Your Website 00:04:00 Using The 'WordPress Local SEO' Plugin For Your Site 00:02:00 Local SEO Articles Worth Reading 00:05:00 Content Writing Why Content Is So Important 00:05:00 Building Content Pages For Your Services 00:03:00 The Google Keyword Planner - Keyword Research 00:04:00 Adding Heading Tags 00:01:00 Adding an 'Alt' Tag To Your Images 00:04:00 Hiring a Writer for Only $5 00:06:00 Link To Other Relevant Content On Your Website 00:03:00 Social Syndication Setting Up JetPack To Post On Social Media Automatically 00:03:00 Asking for Reviews From Your Customers Why reviews are very important for your small business 00:04:00 The Review Generator Handout 00:02:00 Getting Links From Other Websites aka Backlinks What Are Backlinks? 00:04:00 Simple Ways To Get Backlinks for Small Businesses 00:02:00 Other Business Sites To Consider Signing Up On Thumbtack 00:02:00 Angie's List & HomeAdvisor 00:02:00 Where To Go From Here Your Overwhelmed - If Your Willing To Hire Someone 00:02:00 Conclusion Wrapping Up 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

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.

This ultimate course to kickstart your Python journey from scratch. This comprehensive course covers all the essential concepts of Python, providing explanations, examples, and practical implementations. Designed with beginners in mind, our goal is to help you learn and master Python by building a variety of projects.

Creative Writing Level 1: Freelance Travel Writing Embark on your Creative Writing journey with a Preface to Travel Writing. Prepare for the Art of Creative Writing in travel, and equip yourself with the Creative Writing Travel Writer's Toolkit. Master Techniques for Effective Creative Writing and discover your unique Creative Writing style. Learning Outcomes: Summarise Preface in Creative Writing. Prepare for Creative Writing in travel. Equip with Creative Writing toolkit. Master Effective Creative Writing techniques. Discover your Creative Writing style. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Creative Writing Level 1: Freelance Travel Writing Course Syllabus Introduce Creative Writing in Travel: Delve into the captivating realm of travel writing and its specific Creative Writing demands. Prepare for Creative Writing: Ready yourself for travel adventures and gather invaluable experiences that enrich your Creative Writing. Master the Creative Writing Toolkit: Acquire essential Creative Writing tools, such as research methods, interviewing skills, and photography. Hone Creative Writing Techniques: Master the art of crafting narratives and descriptions that not only inform but captivate through Creative Writing. Discover Your Creative Writing Style: Identify your unique Creative Writing voice, setting yourself apart in the travel writing landscape. Navigate Creative Writing Realities: Comprehend the practical facets of Creative Writing in freelance travel writing, from pitching to managing industry challenges.

English: Spelling, Punctuation, and Grammar Course Overview: This "English: Spelling, Punctuation, and Grammar" course provides a comprehensive understanding of the essential components of written English. Learners will explore the fundamental aspects of spelling, punctuation, and grammar, which are crucial for effective written communication. This course is designed for individuals aiming to improve their writing skills for both personal and professional use. By the end, learners will be confident in their ability to produce clear, error-free text, enhancing both their academic and workplace communication. Course Description: This course covers the key elements of spelling, punctuation, and grammar that form the foundation of written English. Topics include an introduction to grammar, sentence structure, and common spelling errors. Learners will gain a clear understanding of how to use punctuation and capitalisation correctly and will learn how to avoid common mistakes in writing. Through engaging content, learners will develop their skills to produce precise and coherent text. Whether for professional writing, academic purposes, or personal development, this course ensures learners are equipped to communicate effectively in written form. English: Spelling, Punctuation, and Grammar Curriculum: Module 01: Introduction to the Course Module 02: The Basics of Grammar Module 03: The Basics of Sentence Module 04: Structure of Sentence Module 05: Question Module 06: Punctuation & Capitalisation Module 07: Spelling Module 08: Common Mistakes & Ways to Improve (See full curriculum) Who is this course for? Individuals seeking to improve their written communication skills. Professionals aiming to enhance their written presentation in the workplace. Beginners with an interest in mastering English writing. Those looking to refine their grammar and spelling for academic or personal purposes. Career Path Content Writer Proofreader Editor Administrative Assistant Teacher/Tutor Communications Specialist Copywriter

Functional skills English Certification Course Overview The Functional Skills English Certification course is designed to enhance learners' command of English by improving key language skills essential for everyday communication and professional environments. It covers the fundamentals of grammar, sentence structure, punctuation, spelling, and common language errors, providing a well-rounded foundation in English. Learners will gain confidence in their reading, writing, and verbal communication, equipping them for a variety of roles in the workplace or further education. This certification is ideal for those looking to improve their English proficiency and meet the language standards required in various professional and academic settings. Course Description This course offers an in-depth exploration of the core components of English, starting with grammar and sentence structure. Learners will develop a strong understanding of punctuation, capitalisation, and spelling to enhance their writing accuracy and clarity. The course also addresses common language mistakes and offers strategies for improvement. Throughout the course, learners will engage with interactive content, building their knowledge and applying it to real-world scenarios. By the end, students will have gained the necessary skills to communicate effectively in both written and spoken English, empowering them to succeed in academic, professional, and social settings. Functional skills English Certification Curriculum Module 01: Introduction to the Course Module 02: The Basics of Grammar Module 03: The Basics of Sentence Module 04: Structure of Sentence Module 05: Question Module 06: Punctuation & Capitalisation Module 07: Spelling Module 08: Common Mistakes & Ways to Improve (See full curriculum) Who is this course for? Individuals seeking to improve their English language proficiency Professionals aiming to enhance their communication skills Beginners with an interest in mastering the English language Those preparing for English exams or certifications Career Path Administrative Assistant Customer Service Representative Teacher or Tutor Content Writer Communication Specialist Copywriter Public Relations Officer