6284 Power courses delivered On Demand

They say that if you know how to read and respond to body language and other expressions on an advanced level, you can predict almost anything. So if you're interested in this, then it's time for you to learn how to decipher the secrets of body language. Description: What amount do the signs our bodies emanate educate us regarding what individuals are considering and feeling? The Body Language Mastery course is a selective course that will demonstrate to you generally accepted methods to perceive individuals' feelings and sentiments before they even say a word, and to fabricate your enthusiastic insight. You'll additionally figure out how to judge your own particular body language: find what your appearance and stance, enlighten individuals regarding you, and figure out how to enhance your body language to extend a sure, intriguing you. For a long time, body language has been the subject of many books and much logical research. This course will be able to unite this examination to offer you a solitary course that will empower you to utilize its discoveries to your ordinary conduct and enhance your social remaining much of the time. Who is the course for? Professionals who work in the communications industry or part of the communications and human resources department. People who are interested in learning more about communication through body language to decipher people who have a hard time in communication and expressing. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 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 Body Language Mastery course is a useful qualification to possess, and would be beneficial for the following careers: Body Language Trainer Counsellors Teachers Psychologists Psychotherapists And Other Kinds of Therapists and Communication Specialists. Body Language Basics Introduction To Body Language 00:15:00 Understand The Positive And Negative Positions 00:15:00 Observe How People React To Certain Body Language 00:15:00 Set A Goal For The Image You Wish To Project 00:15:00 Practice Scenarios In The Mirror 00:15:00 Train Your Body To React Positively 00:30:00 Learn How To Take Down Someone's Wall with Positive Body Positions 00:30:00 Understand The Importance Of Symmetry 00:15:00 Understand The Importance Of Matching The Other Person 00:15:00 What You Can Get Into With The Incorrect Body Language 00:15:00 Body Language Secrets Aggressive Body Language 00:15:00 Attentive Body Language 00:15:00 Closed Body Language 00:30:00 Deceptive Body Language 00:30:00 Defensive Body Language 00:15:00 Dominant Body Language 00:15:00 Emotional Body Language 00:30:00 Evaluating Body Language 00:15:00 Greeting Body Language 00:30:00 Open Body Language 00:15:00 Relaxed Body Language 00:15:00 Power Body Language 00:15:00 Ready Body Language 00:15:00 Romantic Body Language 00:15:00 Submissive Body Language 00:15:00 Introduction 00:15:00 Conclusion 00:15:00 Communicating Effectively Module One - Getting Started 00:30:00 Module Two - Communicating with Body Language 01:00:00 Module Three - Reading Body Language 01:00:00 Module Four - Body Language Mistakes 00:30:00 Module Five - Gender Differences 00:30:00 Module Six - Nonverbal Communication 01:00:00 Module Seven - Facial Expressions 02:00:00 Module Eight Body Language in Business 02:00:00 Module Nine Lying and Body Language 02:00:00 Module Ten Improve Your Body Language 02:00:00 Module Eleven Matching Your Words to Your Movement 02:00:00 Module Twelve - Wrapping Up 00:30:00 Effective Communication: Body Language- Activities 00:00:00 Mock Exam Mock Exam- Body Language Mastery 00:20:00 Final Exam Final Exam- Body Language Mastery 00:20:00

Are you a hypnotherapist looking to enhance your skills and better serve your clients who are neurodiverse? Take my masterclass on tailoring trance inductions for neeurodiverse individuals and discover the art of crafting personalised hypnotic inductions that resonate with the unique needs of each client.

Elevate your teaching skills with our Psychology Masterclass designed specifically for educators. Gain insights into human behavior, learning techniques, and classroom dynamics. Enhance your teaching approach and create a supportive learning environment. Enroll now to become a more effective and empathetic teacher.

Google Ads is one of the world's leading and most powerful advertising platforms. It can help you with many things, including reaching your target audience with relevant ads, driving traffic to your website and increasing sales. So if you work or want to work in marketing, having knowledge of Google Ads is crucial. That's where our Google Ads Training course comes in.    This comprehensive course will teach you everything you need to know to create and manage successful Google Ads campaigns. From setting up your first campaign to tracking your results, we'll walk you through every step of the process. We'll also teach you how to avoid common Google Ads mistakes and optimise your campaigns for maximum results. Our in-depth curriculum includes everything from getting started with Google Ads to mastering the nuances of Adwords bidding strategies. Learn how to craft successful campaigns, improve your Adwords quality score, and employ the latest features offered by Google. You'll be equipped with the knowledge to audit and optimise your campaigns, avoid common Adwords mistakes, and significantly reduce extra spending. Plus, our exclusive content on remarketing strategies and display advertising will help you improve your Adwords performance for amazing results.   This Google Ads Training course is more than just a theoretical course; it's a practical guide filled with real-world examples, actionable advice and inside strategies to give you a competitive edge. By the end of this course, you'll have the confidence and the knowledge to make Google Adwords work for you, boost your online presence, and generate significant results for your business. Embark on this learning journey today, and turn your Google Ads campaigns into revenue-generating machines. Enrol in the Google Ads Training course today! Learning Outcome: Upon completion of the Google Ads Training course, you should be able to:   Understand the basics and importance of Google Ads for businesses. Master the art of creating effective and engaging Google Ads. Gain insights into building successful Adwords campaigns. Learn to avoid common pitfalls and errors in Google Adwords. Develop skills for auditing and optimising your Adwords campaigns. Discover strategies to improve your Adwords quality score. Explore advanced Adwords bidding and remarketing strategies. Familiarise yourself with tracking Google Ads analytics for improved decision-making. Who is this course for: This Google Ads Training course is ideal for:   Marketing professionals looking to enhance their digital advertising skills. Small business owners seeking to expand their online presence. Digital marketing novices aiming to start a career in this field. Freelancers who wish to add Google Ads proficiency to their skillset. Anyone interested in learning about Google Ads and its marketing power. Career path This Google Ads Training course will be helpful for anyone looking to pursue a career as:   Digital Marketing Specialist: £30,000-£40,000 Per year Google Ads Specialist: £35,000-£45,000 Per year SEO & SEM Specialist: £40,000-£50,000 Per year Content Strategist: £35,000-£45,000 Per year Digital Marketing Manager: £45,000-£60,000 Per year Marketing Analyst: £40,000-£55,000 Per year Freelance Digital Marketer: £30,000-£70,000 Per year Certification After studying the course materials of the Google Ads Training course, there will be a written assignment test that you can take either during or at the end of the course. After passing the test, you will have a range of certification options. A CPD Accredited PDF Certificate costs £4.99, while a CPD Accredited Hardcopy Certificate is £8.00. Also, a PDF Transcript costs £4.99, and a Hardcopy Transcript is £9.99. Select according to your needs, and we assure timely delivery of your chosen certificate. Requirements This professionally designed Google Ads Training course does not require you to have any prior qualifications or experience. It is open to everyone, and you can access the course from anywhere at any time. Just enrol and start learning! Course Curriculum Google Ads Training Course Promo 00:03:00 Lesson 01: Getting started with Google Ads 00:04:00 Lesson 02: Create your Google Ads 00:04:00 Lesson 03: Ingredients to build a successful Adwords camping 00:04:00 Lesson 04: Google Adwords mistakes to be avoided 00:04:00 Lesson 05: Google Adwords audit - Optimisation guide 00:06:00 Lesson 06: Improving quality score in Google Adwords 00:04:00 Lesson 07: Adwords display advertising 00:05:00 Lesson 08: Turbocharge Adwords for breakthrough performance 00:03:00 Lesson 09: Content remarketing strategies with Google display network 00:04:00 Lesson 10: Adwords bidding strategies your competitors don't know 00:07:00 Lesson 11: Using Google Adwords for small business 00:03:00 Lesson 12: How to reduce wasted Adwords spend 00:02:00 Lesson 13: Google Adwords features updated 00:04:00 Lesson 14: Tracking Google Ads analytics 00:04:00

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

Register on the Psychology Advanced Training today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Psychology Advanced Training is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Psychology Advanced Training Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Psychology Advanced Training, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Psychology Advanced Training Intro By Prof. Paul - WHY This Course is SO Important To Your Life! 00:02:00 Goals & Fundamentals 00:17:00 Understanding HOW Feelings Work & How You Can USE This! 00:12:00 'The Imprint Period' - How You Were Created - How You Were Programmed 00:17:00 The Amazing Truth About Values & Beliefs 00:18:00 Do You Know The Difference Between Reality & Lies? Are You Sure? 00:25:00 Personal Illusions That Are Holding You Back - Break Free! 00:20:00 EGO - The Great Deceiver 00:35:00 The Inner-Critic How To WIN The INNER Battle 00:08:00 Understanding Self-Image & Your Multiple Minds 00:21:00 How To Defeat The PAST & The FUTURE 00:18:00 Emotional Reasoning & Logic Systems - How To WIN! 00:08:00 Understanding & Meeting Your Needs - The Hidden Secrets 00:11:00 Understanding Motivation - The Ultimate Driving Force 00:17:00 Defeat This Major Block . And Free Your Mind! 00:08:00 Discover 'The Source & Solution To All Your Problems' 00:15:00 Agenda & Lies - How They impact Your Life 00:11:00 Gambits - Games People Play 00:12:00 Break Free From The Problems of 'Attachment' & 'The Sheep Mentality' 00:14:00 'The Dirty Secret Of Psychology' & How To Free Yourself! 00:25:00 Tap Into The Power Of The Unconscious Mind 00:21:00 How To Control Your Own Mind - And WHY Almost Nobody Does! 00:05:00 Why FEAR Dominates Our Lives & How To Beat it! 00:05:00 Final Thoughts, Tips & Suggestions To Radically Improve Your Life 00:17: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.

'Leadership Skills for The Future': Ignite Your Potential in a Changing World! Imagine steering a diverse team through uncharted waters of innovation, fostering inclusion, and driving success in a dynamic landscape. This dynamic reality is the domain of future leaders, and the Leadership Skills for The Future course empowers you to claim your place within it. The UK's leadership landscape is bustling, with industries worth £31 billion and 5.5 million professionals navigating its exciting currents. From tech giants shaping the future to ethical AI development and the rise of remote working, the need for adept leaders who can inspire, adapt, and thrive has never been higher. This comprehensive Leadership Skills for The Future course equips you with the essential skills to seize these opportunities. You'll delve into the core principles of leadership, honing your abilities to communicate effectively, negotiate productively, and cultivate an inclusive, engaging environment. We'll explore your creativity, organisational prowess, and emotional intelligence, empowering you to evolve as a leader and navigate the ever-changing terrain of modern management. Ready to step into your leadership power? Equip yourself with the skills to navigate the dynamic UK landscape and carve your path to success. Join the Leadership Skills for The Future course and unlock your potential to lead, inspire, and make a lasting impact. You will Learn The Following Things: Understand the principles of effective leadership and management. Develop key leadership skills such as communication, creativity, and emotional intelligence. Learn how to motivate and inspire teams and cultivate inclusion. Gain insights into leadership styles and competencies for career development. Explore best practices in leadership for organisations in the UK. Apply leadership techniques to drive innovation, change and growth. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Leadership Skills for The Future. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Leadership Skills for The Future course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? Aspiring leaders looking to advance their management careers. Experienced professionals wanting to improve their leadership abilities. Individuals seeking to learn skills like creativity, communication and inclusion. Anyone interested in understanding leadership foundations and emotional intelligence. Those looking to gain knowledge on leadership and management, specifically in the UK. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Leadership Skills for The Future course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path Business Manager - £25k to £60k. Team Leader - £20k to £40k. Project Manager - £30k to £70k. Operations Manager - £35k to £60k. Recruitment Manager - £30k to £50k. Course Curriculum Leadership Skills for The Future Module 01: Introduction to Leadership 00:23:00 Module 02: Qualities of a Good Leader and Leadership 00:13:00 Module 03: Creativity in Leadership 00:19:00 Module 04: Organisational Skills 00:26:00 Module 05: Leadership Skills and Competencies 00:30:00 Module 06: Communication Skills 00:27:00 Module 07: Negotiation Techniques 00:15:00 Module 08: Cultivating Inclusion, Belonging, and Engagement 00:25:00 Module 09: Leadership Foundations 00:24:00 Module 10: Emotional Intelligence 00:19:00 Module 11: Evolve as a Leader 00:14:00 Module 12: Leadership & Management in the UK 00:17:00 Assignment Assignment - Leadership Skills for The Future 00:00:00

Overview Mechanical engineering stands as a pillar of innovation and development. As the world becomes more technologically advanced, the demand for these professionals is evident globally, making 'Crack Your Mechanical Engineer Interview' an essential step toward success. From the essentials of basic mechanical engineering to the complexities of thermodynamics, each module is designed to enhance the candidate's interview preparedness. Topics such as the significance of tolerance in engineering, the intricacies of fits, and the principles underlying manufacturing and material science are intricately explored.  The curriculum further delves into the strength of materials, the theory of machines, nuances of automobile engineering, and the pivotal principles of fluid mechanics and thermodynamics. It is a comprehensive compass for aspiring professionals eager to navigate the rigorous terrains of mechanical engineering interviews. 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 Crack Your Mechanical Engineer Interview. It is available to all students, of all academic backgrounds. Requirements Our Crack Your Mechanical Engineer Interview 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 10 sections • 52 lectures • 02:22:00 total length •Scope of the course: 00:03:00 •Introduction to Basic Mechanical Engineering: 00:02:00 •Explain the term torque: 00:03:00 •State Archimedes Principle: 00:02:00 •What is the importance of tolerance in engineering?: 00:04:00 •Explain different types of fits: 00:03:00 •Introduction to Manufacturing & Material Science: 00:01:00 •Define pitting: 00:03:00 •Distinguish Between A Jig And Fixture: 00:03:00 •Explain knurling: 00:03:00 •Why is heat treatment of steel metal crucial?: 00:03:00 •What is extruded aluminium?: 00:02:00 •What do you mean by annealing?: 00:04:00 •How is martensite structure formed in steel?: 00:04:00 •Introduction to Strength Of Material: 00:01:00 •Define a uniformly distributed load: 00:04:00 •Define Buckling Factor: 00:02:00 •Is it the stress that produces strain or vice-versa: 00:04:00 •What is the value of modulus of elasticity of steel?: 00:03:00 •What is Stress Concentration?: 00:03:00 •Introduction to Theory Of Machine: 00:01:00 •What is gear ratio?: 00:01:00 •What do you mean by cotter joint: 00:04:00 •What are the advantages of Gear drive?: 00:04:00 •What are the benefits of cycloidal gears?: 00:03:00 •Introduction to automobile engineering: 00:01:00 •What are the various types of brakes?: 00:03:00 •Differentiate between scavenging and supercharging: 00:03:00 •In IC engine, which part is known as column?: 00:03:00 •What causes white smoke in two-stroke locomotive engines?: 00:03:00 •What is the difference between turbochargers and superchargers?: 00:02:00 •Introduction to Fluid Mechanics: 00:01:00 •Explain The Difference Between Rotational And Irrotational Flow?: 00:03:00 •Navier Stokes Equation Represents The Conservation Of Which Quantity?: 00:03:00 •What are major and minor head losses in a fluid flow system?: 00:03:00 •What is a Newtonian fluid?: 00:05:00 •What are the differences between elbows and bends? Which has greater head losses?: 00:05:00 •What is the ratio of the thickness of TBL to the thickness of HBL?: 00:03:00 •Introduction to Thermodynamics: 00:01:00 •What is the second law of thermodynamics?: 00:04:00 •What is the difference between the heat engine & heat pump?: 00:05:00 •Introduction to RAC & HMT: 00:01:00 •What is Refrigeration? What is the unit of refrigeration?: 00:03:00 •Which Cycle is used in Air Refrigeration System?: 00:02:00 •What do you mean by emissive power?: 00:02:00 •What is Under-cooling or Sub-cooling of refrigeration system?: 00:03:00 •Explain mechanical refrigeration: 00:02:00 •What is heat transfer co-efficient?: 00:01:00 •What is the advantage of using pneumatic?: 00:03:00 •Define least count and how to calculate for vernier callipers?: 00:02:00 •Why do you need a biological shield in nuclear plants?: 00:03:00 •What Is The Value Of Coefficient Of Friction For Ball Bearing?: 00:02:00

Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

In this course, we will learn about the Google Apps Script to create custom functions within G Suite that will help you increase your productivity. This course contains 100+ coding examples. For this course, you need JavaScript and basic HTML and CSS knowledge, a Google account, and a basic web development understanding.