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.
When it comes to booking a resin course, either for a career in resin flooring, or for your own resin pouring projects, you are in absolutely the best place. Our courses not only provide you with the knowledge and skill you’ll need to work with resin surfaces, but the enthusiasm too. You will leave us full of ideas and a desire to get started pouring the flooring, immediately! Our resin installers are not just resin trainers, we work in the industry, completing regular resin installations for both residential and commercial clients and we pass all of our knowledge through experience onto you, our clients. Our courses will give you both practical and theoretical knowledge in order to understand all aspects of a resin business. Depending on the course you undertake, you will learn about: Health and Safety aspects to working with resin. The benefits of Epoxy Resin Flooring. How to calculate quantities of resin products according to the size of your project. How to prime your surfaces for resin pouring, and which surfaces are suitable. How to apply long lasting top coats. How to deal with potential issues and troubleshooting with resin products. How to use resin to create other stunning surfaces - not just floors! How to effectively cost your epoxy resin projects, whether it's for flooring or any other resin surface. Unique sales and marketing advice for your resin business. We have an expert team of graphic designers, copy writers and website designers, all experienced in the resin industry. Our experts are highly trained and experienced when it comes to resin pouring. We have completed a huge number of installations and trained many people to do the same. Our passion and enthusiasm is infectious and we do not leave you behind once you have finished your resin floor training course. We offer ongoing advice and support, discount on resin products and resin specific industry business advice. We are also on hand to help you with your own resin installations should you need an extra hand. A brilliant asset to have whilst establishing your own resin pouring company. Our resin training courses leave you INSPIRED, EDUCATED and RARING TO GET STARTED. We cannot wait to meet you! 1 Day Taster Course – £295 Everything you need to know to start working with resin and create stunning resin floors. You will leave this one day taster session knowing how to successfully install a range of resin products, the maintenance and aftercare. Lunch included. 3 Day Intensive Course – £995 The training programme spans over three days of immersive learning, with both theory and hands-on workshops. The resin course will be held in our training unit where you will have your own individual training bay, enabling you to get a true sense of installing on a real floor. You will work with our industry experts, learning all steps to working with resin products to create visually stunning, long lasting floors. Full resin floor installation process from preparation through to the finish. Detailed run through of all products used in the creation of resin flooring. Our course teaches you how to create special flooring effects using our resin products. Learn the secrets to creating similar floor designs as seen on our social media pages. Create your own sample board to take home. Lunch provided. Training manuals provided. Advice on costing installation. Full technical support and exclusivity to a range of our resin floor products. 5 Day 1-1 training – £3500 The most advanced course we offer. This 1 to 1 training is in-depth and is a complete journey into the world of resin. Learning 1 to 1 with industry professionals. Completing a full installation process, from preparation through to the finish. In-depth presentation and theory. Learn how to create special flooring effects using our products. Learn the secrets to creating similar floor designs as seen on our social media pages. Create your own sample board to take home. Lunch provided. Training manuals provided. Advice on costing installation. Marketing advice on how to create a successful business. Full technical support and exclusivity to a range of our products. On Site Masterclass – £POA Every so often we bring you the most unique experience by joining us for an on-site masterclass. If you’re keen to learn more, please let us know and we’ll add you to the list! What support do I get after a course? Rest assured we remain on hand to give you any advice you may need. From product choices to technical questions, we remain contactable. We also offer ongoing business support with a range of bespoke packages to get you set up. We have helped many people start their resin flooring businesses and know what works! We have ongoing support for marketing / graphic design / websites with bespoke packages. Please let us know and we’ll talk you through.
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
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
In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Creative Writing and Publishing - Novel 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 Creative Writing and Publishing - Novel 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 Creative Writing and Publishing - Novel 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 Creative Writing and Publishing - Novel 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 Creative Writing and Publishing - Novel. 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 Creative Writing and Publishing - Novel 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 Module 01: Getting Started with Novel Writing Getting Started with Novel Writing 00:27:00 Module 02: Finding Ideas and Selecting Your Audience Finding Ideas and Selecting Your Audience 00:31:00 Module 03: Selecting Your Genre Selecting Your Genre 00:35:00 Module 04: Planning and Plotting: Using Stories, Narrative and Setting Planning and Plotting Using Stories, Narrative and Setting 00:30:00 Module 05: Bringing Your Characters to Life Bringing Your Characters to Life 00:36:00 Module 06: Making That First Draft Making That First Draft 00:25:00 Module 07: Editing Effectively Editing Effectively 00:24:00 Module 08: Overcoming the Dreaded Writer's Block Overcoming the Dreaded Writer's Block 00:30:00 Module 09: Getting Your Work Published Getting Your Work Published 00:26:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Embark on a poetic journey with our Poetry course. From the basics of poetry writing to crafting epics, learn the art of imagery, metaphor, and versification. Perfect for aspiring poets seeking to refine their craft and embrace the world of poetry.
Freelancer Masterclass Course Overview The "Freelancer Masterclass" offers a comprehensive introduction to building a successful freelance career, focusing on key skills needed for freelancing in the copywriting field. This course equips learners with the tools to confidently start their freelance journey, from understanding the foundational principles of freelance work to mastering the skills required for copywriting. Learners will gain valuable knowledge in handling clients, improving conversion rates, and navigating the nuances of closing deals. By the end of this course, participants will be well-prepared to enter the freelancing world with the essential skills to thrive in a competitive industry. Course Description This course delves deeper into the specific skills and strategies required to succeed as a freelance copywriter. From learning how to get started, understanding the skills required, to effectively communicating with prospects, the course covers a broad spectrum of essential topics. Learners will explore various niches that use copywriters, learn how to make and close deals, and understand how to build a freelance career that stands out. Throughout the course, students will be guided on how to refine their approach to increasing conversion rates and establishing a solid client base, ensuring they are well-equipped to succeed in a dynamic freelance market. Freelancer Masterclass Curriculum Module 01: Getting Started as a Copywriter Module 02: Skills Needed by a Copywriter Module 03: Communicating With Your Prospect to Improve Conversion Rate Module 04: Making and Closing a Deal Module 05: Niches That Use Copywriters Module 06: Becoming a Freelance Copywriter Module 07: Conclusion (See full curriculum) Who is this course for? Individuals seeking to start a freelance career. Professionals aiming to enhance their copywriting skills. Beginners with an interest in copywriting or freelancing. Aspiring freelance copywriters or content creators. Career Path Freelance Copywriter Content Marketing Specialist Digital Marketing Copywriter Brand Strategist Freelance Content Writer
Copywriting Level 4 Course Overview The Copywriting Level 4 course offers a comprehensive exploration of the art and science of writing persuasive, impactful copy. Designed for individuals eager to enhance their writing skills for various media, this course covers a wide range of topics, including headline creation, online and print copywriting, and crafting effective advertisements. Learners will gain valuable insights into the techniques used by professional copywriters, mastering the ability to produce compelling content across different platforms. By the end of the course, students will be equipped to create copy that captures attention, promotes engagement, and drives results. Course Description This course delves into the essentials of copywriting, focusing on both the creative and strategic aspects of the craft. Learners will explore topics such as writing eye-catching headlines, creating advertisements that resonate, and mastering the nuances of online, press, and print media copy. Through engaging modules, learners will develop critical copywriting skills, including understanding tone, style, and audience engagement, as well as learning to write for diverse media. By the end of the course, students will have the expertise needed to write clear, persuasive copy that enhances brand messaging and promotes consumer action. Copywriting Level 4 Curriculum Module 1: Introduction to Copywriting Module 2: Basics of Copywriting Module 3: Eye-Catching Headlines Module 4: Attention-Grabbing Advertisements Module 5: Essential Copywriting Skills Module 6: Online Copywriting Module 7: Press Related Copywriting Module 8: Print Media Copywriting Module 9: Copywriting for Mainstream Media Module 10: Copywriting for Other Media Module 11: How to Write Better Copy Module 12: Final Tips (See full curriculum) Who is this course for? Individuals seeking to enhance their writing skills for career growth. Professionals aiming to improve their copywriting proficiency. Beginners with an interest in marketing and advertising. Anyone aspiring to work in the field of content creation and media. Career Path Copywriter Content Writer Marketing Specialist Advertising Executive Media Consultant SEO Content Creator