157 Courses delivered Online

Unleash your creativity and master the art of writing horror stories with our Creative Writing Course - Horror. Learn effective techniques, understand key elements of horror literature, and acquire skills in crafting compelling narratives that chill to the bone. Perfect for aspiring writers, horror enthusiasts, and creative individuals, this course offers expert guidance, unique materials, and flexible study options.

Master the skills needed to write captivating horror, thriller and murder stories that will leave readers on the edge of their seats! Unlock your creative potential and express yourself through the art of writing. With this course, you'll learn about the fundamentals of creative writing, the development of your writing skills, and how to write both fiction and non-fiction works. You'll learn how to create realistic characters, write believable dialogue, and build suspense in your stories. You'll also explore the techniques used to write poetry, business proposals and other writings. Learning Outcomes: Understand the fundamentals of creative writing Develop your writing skills and style Write fiction and non-fiction works Create compelling characters and dialogue Build suspense and tension in your stories Write poetry, business proposals and other writings Edit, evaluate and get published This course is divided into fourteen modules, each of which is designed to help you improve your writing skills and develop your creative potential. Module 01 provides an introduction to creative writing, covering the basics of writing style, grammar and structure. You will learn about the different genres of writing and how to write compelling stories that engage your readers. In Module 02, you will learn about the development of creative writing, including the history of the craft and the techniques used by successful writers. You will learn about the importance of reading and how to develop your own unique writing style. Module 03 covers the art of novel writing, including how to structure a story, create compelling characters and develop a plot that will keep your readers engaged. In Module 04, you will explore the world of non-fiction writing, learning how to write in a clear and concise manner. Module 05 focuses on the art of creating fictional characters, helping you develop characters that are relatable and interesting to your readers. You will learn about characterisation techniques and how to use them to bring your characters to life. In Module 06, you will learn how to write realistic dialogue, an essential skill for any writer. You will learn about the importance of dialogue in storytelling and how to write dialogue that is natural and engaging. Module 07, the central focus of the course, covers writing horror, thriller and murder stories. You will learn about the different types of stories in these genres and how to create suspense, tension and atmosphere in your writing. Module 08 covers writing for children, including the different types of children's literature and how to write in a way that engages young readers. In Module 09, you will explore the world of poetry, learning about the different types of poetry and how to write in a way that is expressive and engaging. You will learn about rhyme, metre and the use of imagery in poetry. Module 10 covers proposal writing, an essential skill for professionals in many industries. You will learn about the different types of proposals and how to write in a way that is persuasive and compelling. In Module 11, you will develop critical thinking skills, learning how to analyse and evaluate different types of writing. Module 12 covers business writing, an essential skill for professionals in many industries. You will learn about the different types of business writing, such as emails, reports and proposals, and how to write in a way that is clear, concise and professional. In Module 13, you will learn about other types of writing, such as screenwriting, playwriting and travel writing. Finally, Module 14 covers editing, evaluating and getting published. You will learn about the importance of editing and revising your work and how to identify areas for improvement. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring writers Creative individuals looking to improve their writing skills Anyone who wants to learn how to write captivating horror, thriller and murder stories Career path Creative writer: £20,000 - £60,000 per year Content writer: £18,000 - £40,000 per year Journalist: £18,000 - £45,000 per year Author: £10,000 - £200,000 per year

Unleash the power of your imagination with our 'Fiction Writing Online Course,' where your journey begins with the whisper of an idea and flourishes into the pages of a novel. In this course, we guide you from the ephemeral moments of inspiration, helping you carve out time to cultivate your narrative. With Module 01 serving as your springboard, you'll dive into the craft, exploring the essence of becoming a writer in Module 02. As the chapters unfold, you'll delve into the creation of unforgettable characters and the intricacies of plot construction. Your literary odyssey will be enriched by learning the art of theme development and structured outlining, ensuring your tales are not just read but felt deeply by your audience. From the golden rule of 'show, don't tell' to the precision of punctuation, our comprehensive modules are the chisel to your marble slab of ideas. Module 07 polishes your syntax, while subsequent lessons empower you to construct scenes and chapters that captivate. Concluding this course is not merely about completion but transformation-a writer ready to face the publishing world with confidence. By the end, you'll not only have mastered the technicalities of writing but embraced the courage to write swiftly and freely, honing your work to its finest sheen, ready for the world's eyes. Learning Outcomes Ideate and evolve unique fiction concepts into detailed narratives. Develop compelling characters and masterful story arcs. Employ advanced writing techniques to enhance storytelling. Navigate the technical aspects of language with grammatical accuracy. Execute the editing and publication process with professional finesse. Why choose this Fiction Writing Online Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Fiction Writing Online Course Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Fiction Writing Online Course for? Budding authors eager to navigate the realm of fiction writing. Creative individuals yearning to structure their narrative ideas. Freelance writers aspiring to expand their portfolio into fiction. Literary enthusiasts seeking structured guidance in writing. Professionals aiming to transition into creative writing. Career path Fiction Writer - £15,000 - £55,000 Copywriter - £20,000 - £60,000 Editor - £23,000 - £45,000 Publishing Assistant - £18,000 - £30,000 Literary Agent - £20,000 - £65,000 Creative Writing Instructor - £25,000 - £40,000 Prerequisites This Fiction Writing Online Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Fiction Writing Online Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Fiction Writing Online Course Module 01: Getting Ideas and How to Develop Them (Part 01) 00:30:00 Module 01: Inspiration and Finding The Time (Part-02) 00:30:00 Module 02: What It Means To Be A Writer 00:30:00 Module 03: Characters 00:30:00 Module 04: Plotting and Story Construction 01:00:00 Module 05: Theme, Templates & Outlining 00:30:00 Module 06: Show Don't Tell 00:30:00 Module 07: Punctuation, Grammar and some Basic Writing Rules 00:30:00 Module 08: Scene Structure, Exposition and Story Rules 00:30:00 Module 09: Chapter Structure, Vision and Focus 00:30:00 Module 10 - Fast Writing Without Fear or Censure 00:30:00 Module 11: Editing, Re-writing & Polishing 00:30:00 Module 12: Finishing, Submission & Publication 00:30:00 Resources Resources - Fiction Writing Course 00:00:00 Assignment Assignment - Fiction Writing Online Course 00:00:00

Embark on a Coding Odyssey: Unleash Your Potential with Embedded C Programming Course Dive into the heart of programming as we unveil the mysteries of Embedded C in our comprehensive course designed for both novices and coding enthusiasts. 'Embedded C Programming Course' is your passport to a world of limitless possibilities. From mastering the basics of C to navigating conditional executions, loops, arrays, pointers, and functions, this course is your roadmap to fluency in the language of coding. Our interactive modules, led by seasoned instructors, ensure that each concept is not just understood but absorbed, making your coding journey both engaging and effective. Learning Outcomes Acquire a solid foundation in C programming, from installing it on your computer to understanding characters and integers. Navigate conditional executions and loops with confidence, mastering if conditions, switch cases, for loops, and while loops. Delve into the intricacies of arrays, including creation, manipulation, and working with character arrays. Unlock the power of pointers, comprehending their role and functionality in the coding realm. Master the art of using functions, including global variables, returning values via pointers, and efficiently passing arrays. Why choose this Embedded C Programming Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Embedded C Programming Course for? Aspiring programmers eager to delve into the world of embedded systems. Computer science students seeking a practical understanding of C programming. Tech enthusiasts looking to enhance their coding skills. Professionals aiming to pivot into embedded systems development. Individuals curious about the mechanics of conditional executions, loops, arrays, pointers, and functions in C programming. Career path Embedded Systems Developer: £30,000 - £60,000 C Programmer: £25,000 - £45,000 Software Engineer: £35,000 - £65,000 Firmware Developer: £40,000 - £70,000 Systems Architect: £45,000 - £75,000 Technical Consultant: £50,000 - £80,000 Prerequisites This Embedded C Programming Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Embedded C Programming Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Getting Started with C Install C on your computer 00:08:00 Addition of Numbers 00:10:00 Accepting Inputs with Scanf in C 00:05:00 Understanding Characters and Int in C 00:13:00 Division and MOD operators in C 00:06:00 Conditional Executions and Loops If Condition: Part 1 00:12:00 If Condition: Part 2 00:04:00 If Condition: Part 3 00:10:00 Switch Case 00:13:00 For Loop in C: Part 1 00:10:00 For Loop in C: Part 2 00:06:00 While Loop 00:08:00 Arrays in C Arrays: Part 1 00:12:00 Arrays: Part 2 00:09:00 Array Programs: Part 1 00:08:00 Array Programs: Part 2 00:12:00 Character Array in C 00:14:00 Character Array in C: Part 2 00:13:00 Character Array in C: Part 3 00:09:00 Convert int to String Array 00:11:00 Pointers and Functions Pointers: Part 1 00:17:00 Pointers: Part 2 00:09:00 Pointers: Part 3 00:08:00 Functions: Part 1 00:09:00 Functions: Part 2 00:09:00 Functions: Part 3 00:11:00 Functions: Part 4 00:10:00 Functions: Returning values via pointers 00:12:00 Functions: Global Variables and usage with functions 00:13:00 Passing Array to functions 00:06:00 Passing Char array (strings) to Functions 00:16:00 Downloadable Resources Resource - Embedded C Programming Course 00:00:00

Overview This comprehensive course on Creative Writing Course - Horror will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Creative Writing Course - Horror 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 Creative Writing Course - Horror. It is available to all students, of all academic backgrounds. Requirements Our Creative Writing Course - Horror 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 2 sections • 6 lectures • 06:00:00 total length •Lesson One: The History of Horror: 01:00:00 •Lesson Two: Characters and Concepts: 01:00:00 •Lesson Three: Location and Backdrop: 01:00:00 •Lesson Four: Story and Plotting: 01:00:00 •Lesson Five: Writing Issues: 01:00:00 •Lesson Six: Horror Markets: 01:00:00

Overview Gain in-depth knowledge of the seven-step story generator and build a loyal base of readers with your excellent book marketing strategy, by enrolling in our Writing Short Story Training course.This information-packed course educates you on the established practices and techniques to write beautiful scenes and draw more people into your book funnel.Most readers love short, quick reads. The course focuses on the short story writing basics, from creating characters and protagonists to fast writing and polishing, dealing with rejection, and much more. After your successful completion, you will be far more capable of writing engaging short stories with attractive key themes and storylines to attract the crowd. Enrol today to let your creative juices flow. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is this course for? There is no experience or previous qualifications required for enrolment on this Writing Short Story Training. It is available to all students, of all academic backgrounds. Requirements Our Writing Short Story Training is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 9 sections • 33 lectures • 02:03:00 total length •Introduction to Short Story Writing: 00:06:00 •Who Am I to Run This Course?: 00:06:00 •It's All About Mindset: 00:07:00 •What Tools Do You Need To Succeed?: 00:05:00 •Mental Preparation: 00:06:00 •Time Management: 00:06:00 •Self Belief: 00:02:00 •Goal Setting: 00:01:00 •Subject Matter: 00:04:00 •Genre: 00:07:00 •Scope: 00:02:00 •Getting Ideas: 00:02:00 •The 7-Step Story Generator: 00:02:00 •Characters & Character Creation: 00:03:00 •Creating Protagonists: 00:07:00 •Character Motivation & Interactions: 00:03:00 •Story & Setting: 00:03:00 •The 5-Point Story Structure: 00:02:00 •Style & Tone: 00:02:00 •Point of View & Tense: 00:03:00 •Plotting & The Twist: 00:05:00 •Building a Short Story Template: 00:03:00 •Building a Short Story Template: 00:03:00 •All Hail Scrivener!: 00:04:00 •The Opening Paragraph: 00:03:00 •Fast Writing: 00:05:00 •The Second Draft: 00:04:00 •Polishing: 00:04:00 •It's All About Presentation: 00:04:00 •Dealing With Rejection: 00:02:00 •Rights and Payment: 00:01:00 •Kindle Publishing: 00:04:00 •Conclusion Short Stories: 00:02:00

Unlock the secrets of storytelling with our 'Novel & Story Writing Masterclass: Craft Compelling Narratives.' Immerse yourself in the art of creative writing, from understanding story elements to polishing your manuscript for publication. Explore genres, build memorable characters, and gain insights into the publishing industry. Whether you dream of becoming a novelist or refining your narrative skills, this masterclass is your pathway to crafting stories that captivate and resonate. Join us on this enriching journey and bring your stories to life with confidence.

Overview Learn about How to be a Creative Writer from industry experts and boost your professional skill. This How to be a Creative Writer course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of How to be a Creative Writer. You'll also gain the skills of How to be a Creative Writer to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of How to be a Creative Writer professionals and gain first-hand experience of How to be a Creative Writer problem-solving. The How to be a Creative Writer  is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the How to be a Creative Writer, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This How to be a Creative Writer will provide you with the latest information and updates of How to be a Creative Writer. It will keep you one step ahead of others and increase your chances of growth. Why buy this How to be a Creative Writer? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the How to be a Creative Writer you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This How to be a Creative Writer does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This How to be a Creative Writer was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This How to be a Creative Writer is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum 01. Creative Writing Course: Writing Storybooks For Children Introduction Introduction to Children's Writing 00:02:00 Crucial Information 00:02:00 Keys to Success 00:02:00 A.I.M 00:04:00 Coming Up With Ideas Getting Ideas 00:02:00 Character Creation 00:02:00 Characters and Plotting 00:04:00 The Mechanics of Writing Planning Your Story 00:03:00 Storytelling 00:03:00 Important Technical Issues Point of View 00:04:00 Technical Writing Issues 00:04:00 Types of Children's Books Story Structure 00:02:00 Picture Books 1 00:03:00 Picture Books 2 00:03:00 Picture Books 3 00:02:00 Easy Readers 00:03:00 Transition Books 00:01:00 Chapter Books 00:02:00 Junior Novels 00:02:00 Young Adult Fiction 00:04:00 Advanced Fiction Techniques Dialogue 00:05:00 Show don't Tell 00:05:00 Conclusion Conclusion 00:02:00 02. Creative Writing Course - Short Stories Introduction Introduction to Short Story Writing 00:06:00 Foreword Who Am I to Run This Course? 00:06:00 It's All About Mindset 00:07:00 What Tools Do You Need To Succeed? 00:05:00 Part One: Mindset Mental Preparation 00:06:00 Time Management 00:06:00 Self Belief 00:02:00 Goal Setting 00:01:00 Part Two: The Basics Subject Matter 00:04:00 Genre 00:07:00 Scope 00:02:00 Getting Ideas 00:02:00 Part Three: Construction Time The 7-Step Story Generator 00:02:00 Characters & Character Creation 00:03:00 Creating Protagonists 00:07:00 Character Motivation & Interactions 00:03:00 Story & Setting 00:03:00 The 5-Point Story Structure 00:02:00 Style & Tone 00:02:00 Point of View & Tense 00:03:00 Plotting & The Twist 00:05:00 Building a Short Story Template 00:03:00 Building a Short Story Template 00:03:00 Introduction to Scrivener All Hail Scrivener! 00:04:00 Part Four: Writing Your Story The Opening Paragraph 00:03:00 Fast Writing 00:05:00 The Second Draft 00:04:00 Polishing 00:04:00 Part Five: Submitting Your Work 6 Lectures It's All About Presentation 00:04:00 Dealing With Rejection 00:02:00 Rights and Payment 00:01:00 Kindle Publishing 00:04:00 Conclusion Short Stories 00:02:00 03. Creative Writing Course - Fiction Module 1 Part 1 - Getting Ideas and How to Develop Them 00:30:00 Module 1 Part 2 - Inspiration and Finding The Time 00:30:00 Module 2 - What It Means To Be A Writer 00:30:00 Module 3 - Characters 00:30:00 Module 4 - Plotting and Story Construction 00:30:00 Module 5 - Theme, Templates & Outlining 00:30:00 Module 6 - Show Don't Tell 00:30:00 Module 7 - Punctuation, Grammar and some Basic Writing Rules 00:30:00 Module 8 - Scene Structure, Exposition and Story Rules 00:30:00 Module 9 - Chapter Structure, Vision and Focus 00:30:00 Module 10 - Fast Writing Without Fear or Censure 00:30:00 Module 11 - Editing, Re-writing & Polishing 00:30:00 Module 12 - Finishing, Submission & Publication 00:30:00 04. Creative Writing Course - Horror Lesson One: The History of Horror 01:00:00 Lesson Two: Characters and Concepts 01:00:00 Lesson Three: Location and Backdrop 01:00:00 Lesson Four: Story and Plotting 01:00:00 Lesson Five: Writing Issues 01:00:00 Lesson Six: Horror Markets 01:00:00 05. Creative Writing Course - Novel Introduction to Writing Fantasy 01:00:00 Writing Fantasy - Lesson One - Imagining Fantasy 01:00:00 Writing Fantasy - Lesson Two - World Building, Maps and Visualization 01:00:00 Writing Fantasy - Lesson Three - Characters, Races and Societies 01:00:00 Writing Fantasy - Lesson Four - Plotting, Questing and Traveling 01:00:00 Writing Fantasy - Lesson Five - Point of View, Artifacts and Magic 01:00:00 Writing Fantasy - Lesson Six - Resolutions and Sequels 01:00:00 Amusing Article About Fantasy Writing (because it's true!) 01:00:00 Fantasy: Recommended Author & Book List 01:00:00 Fantasy Societies Listing 01:00:00 Mythological Creature Listing 01:00:00 06. Creative Writing Course - Thriller Introduction to Writing the Thriller 00:30:00 The Thriller: Form and Function 00:30:00 Writing the Thriller: Lesson One 00:30:00 Writing the Thriller: Lesson Two 00:30:00 Exercise 1 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Three 00:30:00 Exercise 2 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Four 00:30:00 Exercise 3 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Five 00:30:00 Exercise 4 - Building Your Thriller 00:30:00 Writing the Thriller: Lesson Six 00:30:00 07. Diploma in Drama and Comedy Writing Welcome to the Writer's Greatest Untapped Income Source 00:15:00 Introduction to Writing for TV, Cable and Satellite Networks 01:00:00 Your Ideas and How to Present Them 01:00:00 What's Different About TV Writing? 01:00:00 Scripting, Editing and the Story Bible 00:30:00 A Special Masterclass On Comedy Writing 00:30:00 The Money and How You Get Paid 00:30:00

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

A masterclass in what a publisher looks for when signing an author and publishing a novel