32322 Design courses delivered On Demand

Though it appears easy at first glance but cake frosting is both science and arts. It requires great deal of expertise and creativity to design the perfect cake for an occasion. No matter if you are an amateur enthusiast or a professional baker- this course will help you to know about the ingredients you need for cake frosting and educate you about the entire process. Like said before, it is not just aesthetic skills or culinary arts, you need to have the blend of both. Last but not the least, learn the proper ways of maintaining hygiene and authenticity of your cake frosting- without which- you won't get full satisfaction! Course Highlights Certified Diploma in Cake Frosting is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Certified Diploma in Cake Frosting into 16 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 6 hours, 25 minutes and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Certified Diploma in Cake Frosting Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Certified Diploma in Cake Frosting is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Certified Diploma in Cake Frosting is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Frosting Perfection: Insider's Guide 00:15:00 Frosting For Beginners 00:15:00 ICING THE CAKE 00:15:00 My Personal Favorites 00:15:00 Layer Cake Decoration 00:30:00 Frosting Recipe Collection 00:30:00 Cake Decoration: Writing 00:15:00 Advanced Frosting Techniques 00:30:00 Frosting Recipes: Advanced Collection 00:30:00 Cutting And Wrapping The Board 00:15:00 Working With Marzipan 00:15:00 Working With Ganache 00:30:00 Gum Paste 101 00:30:00 Figure Piping 00:15:00 Private Swipe File Of Classic Recipes 00:30:00 Conclusion: Final Words 00:15:00 Mock Exam Mock Exam-Certified Diploma in Cake Frosting 00:20:00 Final Exam Final Exam-Certified Diploma in Cake Frosting 00:20:00

It is usually an intrigue and enthusiasm for plants and gardening that is present today. In this course, you will learn the necessary skills, knowledge, and information of garden care. Figure out how to build up a rich soil bed to make more beneficial plants, greater harvests and how to keep up profitable products of the soil plot without burrowing. This course covers an extensive variety of subjects from the remedies for gardening care to picking plants for your garden. This course will give you both the information and certainty required to complete your own particular garden configuration and to learn new skills or upgrade your existing skills.  Who is the course for? Flower and Vegetable Garden owners who want to learn more about gardening. Anyone who has an interest in taking care of flowers and plants Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be ages 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Lawn & Garden Care Course would be beneficial for people who love flowers and other plants that want to grow and take care of it.   Lawn & Garden Care Course How to Take Care of your Garden 00:15:00 Beginning Garden Care for the New Homeowner 00:30:00 At Home Remedies for Garden Care 00:30:00 Common Garden Problems And Easy Garden Care Solutions 00:15:00 Dogs Beware: Garden Care for the Dog Friendly Home 00:30:00 Garden Care for all Flower and Vegetable Life 00:30:00 Garden Care for the New Neighbor 00:15:00 Garden Care in All Seasons 00:30:00 What to Look for in Plant Selection 00:15:00 Herb Garden Care: Types, Tricks and Tips for Success 00:30:00 How Not to Care for your Garden: Common Garden Care Mistakes to Avoid 00:15:00 How to Choose and Maintain Annuals 00:30:00 How to Make your Seedlings Grow 00:30:00 How to Make Garden Care a Fun Filled Family Activity 00:15:00 Winter Garden Care 00:30:00 Garden Care for All Corners of Your Yard 00:15:00 Must Have Garden Tools for the Proper Garden Care Year Round 01:00:00 Preparing for a Garden 00:30:00 Proper Care to Garden 00:15:00 So, You Want to Start a Garden? Garden Care 00:30:00 The Best Conditions and Home Remedy Secrets to Rose Garden Care 00:30:00 The Different Kinds of Plant Gardens and How to Care for Each Type 00:15:00 What Type of Garden are you Destined to Have? 00:30:00 Top Nine Garden Care Tips from the Experts 00:15:00 Mock Exam Mock Exam-Lawn & Garden Care Course 00:20:00 Final Exam Final Exam-Lawn & Garden Care Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Unlock your potential in the vibrant realm of fashion and lifestyle with our Fashion and Lifestyle Expert Certificate Course Online. Dive into a transformative journey where creativity meets strategy, and old-fashioned norms give way to the rebellious spirit of contemporary trends. Delve into the mesmerising tapestry of 80s fashion and 90s fashion while mastering the art of expression through innovative blogging and brand collaboration. Embrace this lifestyle revolution and let your voice resonate across the digital landscape. In this dynamic course, you'll explore the fashion world, from its historical roots to its ever-evolving present. Discover the power of storytelling through blogging, honing your writing skills to captivate audiences with compelling narratives. Uncover the secrets of curating captivating content and crafting visually stunning imagery that speaks volumes in the digital sphere. Harness the potential of social media as a platform for influence and connection, forging valuable relationships with brands and fellow influencers alike. Through our comprehensive curriculum, you'll receive invaluable insights into the intricacies of building a personal brand and monetising your passion. Whether you're an aspiring fashionista or a seasoned blogger seeking to elevate your craft, our course offers lifestyle gift cards to a world of opportunities. Embrace the lifestyle vouchers of knowledge and expertise and join the ranks of the fashion and lifestyle elite. Experience the lifestyle expressed towards becoming a true connoisseur in this exhilarating industry. Learning Outcomes: Develop proficiency in blogging techniques and content creation strategies. Understand the dynamics of audience targeting and engagement in the fashion and lifestyle niche. Master the art of photography and imagery to enhance storytelling and brand representation. Gain insights into effective networking and collaboration with brands and influencers. Acquire the skills to monetise your blog and build a successful personal brand in the fashion and lifestyle domain. Why buy this Fashion and Lifestyle Expert Certificate Course Online? 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. Certification After studying the course materials of the Fashion and Lifestyle Expert Certificate Course Online there will be a written assignment test which you can take either during or at the end of the course. 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 Fashion and Lifestyle Expert Certificate Course Online for? Fashion enthusiasts eager to delve into the blogging sphere. Aspiring influencers seeking to establish themselves in the fashion and lifestyle niche. Marketing professionals interested in expanding their expertise to include fashion and lifestyle branding. Students with a passion for creative expression through writing and imagery. Individuals looking to turn their passion for fashion into a lucrative career opportunity. Prerequisites This Fashion and Lifestyle Expert Certificate Course Online does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Fashion and Lifestyle Expert Certificate Course Online 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 Fashion Blogger: £20,000 - £40,000 Annually Social Media Influencer: £18,000 - £50,000 Annually Brand Collaborator: £25,000 - £45,000 Annually Fashion Photographer: £20,000 - £35,000 Annually Content Creator: £22,000 - £40,000 Annually Brand Ambassador: £20,000 - £45,000 Annually Course Curriculum Module 01: An Introduction to Blogging An Introduction to Blogging 00:26:00 Module 02: Target Audience Target Audience 00:24:00 Module 03: Getting Started Getting Started 00:27:00 Module 04: Writing for Bloggers Writing for Bloggers 00:16:00 Module 05: Content Development Content Development 00:28:00 Module 06: Photography and Imagery Photography and Imagery 00:34:00 Module 07: Staying Social Staying Social 00:28:00 Module 08: Working with Brands Working with Brands 00:21:00 Module 09: Networking Networking 00:26:00 Module 10: Monetising Your Blog Monetising Your Blog 00:28:00 Module 11: Building a Brand Building a Brand 00:32:00 Module 12: Growing as a Blogger Growing as a Blogger 00:24:00 Assignment Assignment - Fashion and Lifestyle Expert Certificate Course Online 00:00:00

Description: The 70-647 - Windows Server Enterprise Administration course explains how to maintain the Windows Server 2008 R2 environment and prepare you for the Exam 70-647 - Windows Server Enterprise Administration Throughout the course, you will learn the system of planning for active directory, network infrastructure, active directory issues, and active directory administration. You will also learn the ways of deploying Windows 2008 to the small and medium-sized offices, using remote desktop services and application setup. The course will also teach you how to secure the network, how to support PKI (Public Key Infrastructure) and the CA hierarchy. Finally, the course explains various virtualisation solutions by using virtualisation and planning virtualisation for applications, windows updates and how to protect the environment by making data security that still available to the user. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? 70-647 - Windows Server Enterprise Administration is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our 70-647 - Windows Server Enterprise Administration is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Planning for Active Directory Logical Design 01:14:00 Physical Topology 00:50:00 Network Infrastructure DNS 01:01:00 Planning IP Distribution 00:49:00 Advanced Active Directory Issues Migration Strategies 00:13:00 Working with Other Forests 00:18:00 Active Directory Administration Active Directory Administration 01:07:00 Using Group Policies 00:38:00 Deploying Windows 2008 to the Small/Medium Office Small/Medium Office 00:44:00 Small/Medium Server Security 00:43:00 Using Remote Desktop Services and Application Setup Planning for Remote Desktop Services 00:19:00 License Server 00:10:00 Deploying Applications 00:34:00 Securing the Network Designing a Secure Perimeter 01:03:00 Introducing NAP 00:26:00 Domain and Server Isolation 00:04:00 Supporting PKI What is PKI? 00:30:00 The CA Hierarchy 00:28:00 Managing Certificates 00:26:00 Virtualization Solutions Using Virtualization 00:41:00 Planning Virtualization for Applications 00:08:00 Windows Updates WSUS 00:39:00 Software Update Compliance 00:22:00 Making Data Secure and Available Sharing and Collaborating Your Data 00:32:00 Protecting Data at Rest 00:27:00 System Recoverability and Availablity 00:34:00 Mock Exam Mock Exam- 70-647 - Windows Server Enterprise Administration 00:20:00 Final Exam Final Exam- 70-647 - Windows Server Enterprise Administration 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

This comprehensive course will guide you to use the power of Python to evaluate recommender system datasets based on user ratings, user choices, music genres, categories of movies, and their years of release with a practical approach to build content-based and collaborative filtering techniques for recommender systems with hands-on experience.

Description Learn the fundamental features of Adobe Illustrator and start your journey to create wonderful vector images with the Adobe Illustrator CC Beginner course. At first, you will learn the things you can do with Illustrator and the importance of using Illustrator. The course familiarizes you with the Illustrator interface and shows you some of the basic features of Illustrator. The techniques of measuring and transforming objects, the use of shape tools, and the procedures of using the keyboards to control the tools fast will be discussed in the course. After that, the course shows you the techniques of applying fills and strokes so that you can fill your objects with colors, and able to put a stroke outside. Then the course explains the setting type and shows you some of the text tools. Next, the course discusses the various types of brushes and how to paint with the brushes. A detailed discussion will be presented on the strategies of applying effects such as shadow, transparency, etc. Finally, you will learn how to export your files from Illustrator so that you can share your works with others. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Adobe Illustrator CC Beginner is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Adobe Illustrator CC Beginner is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:01:00 Introduction to Illustrator Why Adobe Illustrator? 00:03:00 Using Selection Tools 00:02:00 Creating New Documents 00:08:00 Saving Adobe Illustrator Files 00:06:00 Navigating the Interface 00:08:00 Managing Workspaces 00:05:00 Drawing Basics Creating Shapes 00:13:00 Using the Drawing Tools 00:10:00 Mastering the Pen Tool 00:09:00 Editing Shapes 00:08:00 Grouping and Aligning Shapes 00:06:00 Understanding Layers 00:06:00 Putting it all Together 00:07:00 Measuring and Transforming Objects Working with Rules and Guides 00:05:00 Discovering the Transform Panel 00:08:00 Using Transform and Distort 00:04:00 Applying Fills and Strokes Editing Fills with the Color Panel 00:08:00 Editing Fills with the Swatches Panel 00:09:00 Modifying Strokes 00:09:00 Creating Gradients 00:09:00 Using the Freeform Gradient 00:06:00 Setting Type Using Type Tools 00:10:00 Discovering Type Panels 00:08:00 Working with Adobe Fonts 00:04:00 Painting with Brushes Discovering the Brush Panel 00:06:00 Creating Custom Brushes 00:06:00 Using the Blob Brush 00:08:00 Applying Effects Using the Appearance Panel 00:04:00 Understanding the Effects Menu 00:07:00 Exporting from Illustrator Creating PDF's 00:07:00 Exporting to Other Formats 00:08:00 Importing Adobe PDF´s 00:03:00 Understanding Metadata 00:04:00 Printing your Document 00:07:00 Conclusion Course recap 00:01:00 Resources Resources - Adobe Illustrator CC Beginner 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Level 3 Diploma in Landscape Photography is one of our best selling and most popular course. This course is suitable for anyone aspiring to or already working in Photography and looks at skills needed to improve Photography. By taking this course you will gain the necessary skills to perform effectively in this field. The Level 3 Diploma in Landscape Photography is organised into 5 modules and includes everything you need to become successful in this profession. To make this course more accessible for you, we have designed it for both part-time and full-time students. You can study at your own pace or become an expert in just 3 hours! If you require support, our experienced tutors are always available to help you throughout the comprehensive syllabus of this course and answer all your queries through email. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post.   Course Content Module: 01 Promo Video 00:02:00 Introduction 00:01:00 Gear for Landscape Photography 00:04:00 Module: 02 Planning Your Trip with Will 00:02:00 Our Gear - What's in Our Bag 00:05:00 Shooting at Sunrise 00:09:00 Landscape Basics & Composition 00:06:00 Camera Setting Refresher with Phil 00:08:00 Phil & Sam Go Over the Basics 00:09:00 Module: 03 How to shoot Panoramas 00:05:00 Wide vs. Telephoto Photographs 00:04:00 Using a Polarizer Filter 00:03:00 Sunset Photography 00:05:00 Module: 04 Intro to Editing 00:02:00 Adobe Lightroom Crash Course 00:14:00 Our Basic Landscape Editing Process 00:11:00 Quickly Straighten Horizons 00:01:00 Remove Unwanted Objects in Lightroom 00:02:00 Module: 05 Phil Edits a Landscape Photo 00:17:00 Sam's Editing Workflow 00:11:00 WiIII's Editing Process 00:19:00 All Three Edit the Same Photo 00:23:00 Sam Edits a Sunrise Photo 00:09:00 How to Create an HDR Photo in Lightroom 00:02:00 Stitch Together a Panorama in Lightroom 00:06:00 Stitch Together a Panorama in Photoshop 00:03:00 Exporting a Photo for Web or Print 00:10:00 Conclusion 00:01:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. 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. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. 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. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Course Overview! 00:04:00 Installation And Getting Started The Final Milestone! 00:01:00 Installing and setting up PostgreSQL 00:09:00 Case Study : Demo Case Study Part 1 00:04:00 Case Study Part 2 00:06:00 Fundamental SQL statements CREATE 00:11:00 Exercise 1: Create DB and Table 00:01:00 INSERT 00:09:00 Import data from File 00:05:00 Exercise 2: Inserting and Importing 00:01:00 SELECT statement 00:03:00 SELECT DISTINCT 00:06:00 WHERE 00:04:00 Logical Operators 00:06:00 Exercise 3: SELECT & WHERE 00:01:00 UPDATE 00:05:00 DELETE 00:04:00 ALTER 00:17:00 Exercise 4: Updating Table 00:01:00 Restore And Back-Up Restore and Back-up 00:07:00 Exercise 5: Restore and Back-up 00:01:00 Selection Commands: Filtering IN 00:04:00 BETWEEN 00:05:00 LIKE 00:08:00 Exercise 6: In, Like & Between 00:01:00 Selection Commands: Ordering Side Lecture: Commenting in SQL 00:01:00 ORDER BY 00:07:00 LIMIT 00:03:00 Exercise 7: Sorting 00:01:00 Alias AS 00:03:00 Aggregate Commands COUNT 00:05:00 SUM 00:03:00 AVERAGE 00:03:00 MIN & MAX 00:04:00 Exercise 8: Aggregate functions 00:01:00 Group By Commands GROUP BY 00:12:00 HAVING 00:05:00 Exercise 9: Group By 00:01:00 Conditional Statement CASE WHEN 00:05:00 Joins Introduction to Joins 00:02:00 Inner Join 00:08:00 Left Join 00:07:00 Right Join 00:06:00 Full Outer Join 00:05:00 Cross Join 00:04:00 Except 00:03:00 Union 00:03:00 Exercise 10: Joins 00:01:00 Subqueries Subqueries 00:14:00 Exercise 11: Subqueries 00:01:00 Views And Indexes VIEWS 00:07:00 INDEX 00:06:00 Exercise 12: Views 00:01:00 String Functions LENGTH 00:03:00 Upper Lower 00:02:00 REPLACE 00:04:00 TRIM, LTRIM, RTRIM 00:07:00 CONCATENATION 00:03:00 SUBSTRING 00:06:00 LIST AGGREGATION 00:05:00 Exercise 13: String Functions 00:02:00 Mathematical Functions CEIL & FLOOR 00:03:00 RANDOM 00:05:00 SETSEED 00:04:00 ROUND 00:02:00 POWER 00:02:00 Exercise 14: Mathematical Functions 00:01:00 Date-Time Functions CURRENT DATE & TIME 00:04:00 AGE 00:03:00 EXTRACT 00:08:00 Exercise 15: Date-time functions 00:01:00 Pattern (String) Matching PATTERN MATCHING BASICS 00:07:00 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 00:15:00 Exercise 16: Pattern Matching 00:01:00 Data Type Conversion Functions Converting Numbers/ Date to String 00:11:00 Converting String to Numbers/ Date 00:06:00 User Access Control Functions User Access Control 00:13:00 Bonus Section: Nail That Interview! Tablespace 00:05:00 PRIMARY KEY & FOREIGN KEY 00:05:00 ACID compliance 00:06:00 Truncate 00:04:00 Performance Tuning Tips TIP 1 (EXPLAIN) 00:04:00 TIP 2 00:01:00 TIP 3 00:02:00 TIP 4 (VACCUM) 00:01:00 TIP 5 00:02:00 TIP 6 (STRING FUNCTIONS) 00:02:00 TIP 7 (JOINS) 00:02:00 TIP 8 (SCHEMAS) 00:04:00 Bonus Section : Database Basics What is SQL 00:02:00 Tables and DBMS 00:03:00 Types of SQL commands 00:04:00 PostgreSQL 00:02:00 The Final Milestone! 00:01:00 Supplementary Resources Supplementary Resources - SQL Masterclass 00:00:00 Assessment Assessment - SQL Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Uncover the captivating world of gems and jewels with our comprehensive "Introduction to Gemology" course. Whether you're an aspiring gemologist, jeweler, or simply fascinated by the allure of gemstones, this course is your gateway to understanding their beauty and scientific significance. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In "Introduction to Gemology," learners explore the fascinating world of gemstones. They begin by understanding the basics of gemology, including how gems are formed and their physical properties like weight, color, and measurement. Participants delve into the intricate process of gem testing, learning how professionals identify and evaluate gemstones for authenticity and quality. The course also covers the significance of color in gemstones, how it affects their value and allure. By the end, learners gain a comprehensive understanding of precious gemstones, including their rarity, cultural importance, and the art of distinguishing between different types. This curriculum equips students with practical knowledge essential for anyone interested in gems, whether for personal interest or professional development in jewelry making, appraisal, or gem trading. Course Curriculum Module 01: Introduction to Gemology Module 02: Weight and Measurement Module 03: Color Module 04: Formation of Gems Module 05: Gem Testing Module 06: Precious Gemstones Module 07: Fashioning Learning Outcomes Understand the fundamentals of gem identification and classification principles. Apply standard methods for measuring gem weight and dimensions accurately. Identify the influence of colour on gemstone value and aesthetics. Explain the geological processes involved in gem formation and crystallization. Perform basic tests to assess the authenticity and quality of gemstones. Recognize the characteristics and value factors of major precious gemstones. CPD 10 CPD hours / points Accredited by CPD Quality Standards Introduction to Gemology 51:52 1: Module 01: Introduction to Gemology 07:41 2: Module 02: Weight and Measurement 06:17 3: Module 03: Color 06:45 4: Module 04: Formation of Gems 08:52 5: Module 05: Gem Testing 07:00 6: Module 06: Precious Gemstones 07:56 7: Module 07: Fashioning 06:21 8: CPD Certificate - Free 01:00 Who is this course for? Jewellery enthusiasts seeking foundational knowledge in gem identification. Gemstone collectors interested in understanding gem quality and value. Students of geology or earth sciences exploring gem formation processes. Retail professionals aiming to enhance gemstone product knowledge. Beginners in gem trading or appraisal seeking fundamental expertise. Career path Gemologist Jewellery Designer Gemstone Buyer Gem Appraiser Retail Jeweller Gemstone Laboratory Technician Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Uncover the captivating world of gems and jewels with our comprehensive "Introduction to Gemology" course. Whether you're an aspiring gemologist, jeweler, or simply fascinated by the allure of gemstones, this course is your gateway to understanding their beauty and scientific significance. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In "Introduction to Gemology," learners explore the fascinating world of gemstones. They begin by understanding the basics of gemology, including how gems are formed and their physical properties like weight, color, and measurement. Participants delve into the intricate process of gem testing, learning how professionals identify and evaluate gemstones for authenticity and quality. The course also covers the significance of color in gemstones, how it affects their value and allure. By the end, learners gain a comprehensive understanding of precious gemstones, including their rarity, cultural importance, and the art of distinguishing between different types. This curriculum equips students with practical knowledge essential for anyone interested in gems, whether for personal interest or professional development in jewelry making, appraisal, or gem trading. Course Curriculum Module 01: Introduction to Gemology Module 02: Weight and Measurement Module 03: Color Module 04: Formation of Gems Module 05: Gem Testing Module 06: Precious Gemstones Module 07: Fashioning Learning Outcomes Understand the fundamentals of gem identification and classification principles. Apply standard methods for measuring gem weight and dimensions accurately. Identify the influence of colour on gemstone value and aesthetics. Explain the geological processes involved in gem formation and crystallization. Perform basic tests to assess the authenticity and quality of gemstones. Recognize the characteristics and value factors of major precious gemstones. CPD 10 CPD hours / points Accredited by CPD Quality Standards Introduction to Gemology 51:52 1: Module 01: Introduction to Gemology 07:41 2: Module 02: Weight and Measurement 06:17 3: Module 03: Color 06:45 4: Module 04: Formation of Gems 08:52 5: Module 05: Gem Testing 07:00 6: Module 06: Precious Gemstones 07:56 7: Module 07: Fashioning 06:21 8: CPD Certificate - Free 01:00 Who is this course for? Jewellery enthusiasts seeking foundational knowledge in gem identification. Gemstone collectors interested in understanding gem quality and value. Students of geology or earth sciences exploring gem formation processes. Retail professionals aiming to enhance gemstone product knowledge. Beginners in gem trading or appraisal seeking fundamental expertise. Career path Gemologist Jewellery Designer Gemstone Buyer Gem Appraiser Retail Jeweller Gemstone Laboratory Technician Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.