23563 Courses

Overview Gain an in-depth understanding of money laundering and terrorist financing risks, and protect your business and customers against fraudulent activity. The Anti Money Laundering (AML) is designed to provide learners with an in-depth understanding of money laundering and how to detect fraudulent activity. You will learn how to detect if a transaction is suspicious and protect your customers and business, with step-by-step professional guidance. We've taken this comprehensive professional diploma and broken it down into several modules which will assist you to easily grasp each concept - from the fundamentals to the most advanced aspects of the course. It is the perfect stepping stone for anyone looking to become a qualified AML Analyst. Why buy this Anti Money Laundering (AML)? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Anti Money Laundering (AML) you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Anti Money Laundering (AML) does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Anti Money Laundering (AML) was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Anti Money Laundering (AML) is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Module 1: Introduction to the Course Module 1: Introduction to the Course 00:30:00 Module 2: Definition of Money Laundering Module 2: Definition of Money Laundering 00:30:00 Module 3: Responsibility & Oversight Module 3: Responsibility & Oversight 00:45:00 Module 4: Risk Based Approach Module 4: Risk Based Approach 00:30:00 Module 5: Customer Due Diligence (CDD) Module 5: Customer Due Diligence (CDD) 01:00:00 Module 6: Suspicious Activity Reporting Module 6: Suspicious Activity Reporting 01:00:00 Module 7: Record Keeping Module 7: Record Keeping 00:15:00 Module 8: Training and Awareness Module 8: Training and Awareness 00:20:00 Module 9: GLOSSARY Module 9: GLOSSARY 00:30:00 Module 10: Legislative Summaries - Proceeds of Crime Act 2002 Module 10: Legislative Summaries - Proceeds of Crime Act 2002 00:15:00 Module 11: Outsourcing, Subcontracting and Secondments Module 11: Outsourcing, Subcontracting and Secondments 00:20:00 Module 12: Client Verification Module 12: Client Verification 00:15:00 Module 13: Decisions and Risk Factors Module 13: Decisions and Risk Factors 00:30:00 Mock Exam Mock Exam- Anti Money Laundering (AML) 00:20:00 Final Exam Final Exam- Anti Money Laundering (AML) 00:20:00

Overview This course is designed to equip individuals with the necessary skills to excel as a Personal Assistant (PA) while developing essential professional skills. Participants will explore various aspects of PA responsibilities, including business telephone etiquette, representing the company, travel arrangements, and organizing meetings. The course covers time management, record-keeping, and effective communication skills. Additionally, it provides insights into customer service, planning, and scheduling, enhancing participants' organizational abilities. Learning Outcomes: Gain a comprehensive understanding of the role and responsibilities of a Personal Assistant. Develop effective business telephone communication skills. Learn how to represent your employer and company professionally. Master the art of arranging travel and coordinating meetings and conferences. Acquire time management techniques to enhance productivity. Develop organizational skills for efficient record-keeping and filing. Enhance written communication through business writing skills. Cultivate excellent planning and scheduling abilities. Why buy this PA - Personal Assistant? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the PA - Personal Assistant you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This PA - Personal Assistant course is ideal for Aspiring Personal Assistants looking to enhance their skills. Administrative professionals aiming to specialize in PA roles. Individuals transitioning to a PA career from related fields. Office managers or coordinators seeking to broaden their skillset Prerequisites This PA - Personal Assistant 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 Personal Assistant (Entry Level) - Average Salary: £20,000 - £30,000 per year. Executive Personal Assistant - Average Salary: £25,000 - £35,000 per year. Senior Personal Assistant - Average Salary: £30,000 - £40,000 per year. Office Manager - Average Salary: £25,000 - £35,000 per year. Project Coordinator - Average Salary: £25,000 - £35,000 per year. Course Curriculum PA - Personal Assistant and Professional Skills Development Module 1: Introduction to Personal Assistant 00:20:00 Module 2: Business Telephone Skills 00:21:00 Module 3: Representing Your Boss and Company 00:37:00 Module 4: Mail Services and Shipping 00:28:00 Module 5: Travel Arrangements 00:27:00 Module 6: Organising Meeting and Conferences 00:28:00 Module 7: Time Management 00:38:00 Module 8: Record Keeping and Filing Systems 00:31:00 Module 9: Business Writing Skills 00:43:00 Module 10 :Organisational Skills 00:28:00 Module 11: Communication Skills 00:28:00 Module 12: Customer Service 00:19:00 Module 13: Effective Planning and Scheduling 00:49:00 Module 14: Invoicing/Petty Cash 00:30:00 Mock Exam Mock Exam - Level 1 Help Desk Training 00:20:00 Final Exam Final Exam - Level 1 Help Desk Training 00:20:00

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Unlock the healing power of creativity with our Play Therapy & Art Therapy course! Discover innovative techniques to help individuals express themselves and find solace through art and play. Enroll today to know more about Play Therapy & Art Therapy and make a meaningful impact on the lives of those in need. Play therapy is a type of therapy that uses play and other creative forms of expression to communicate with children and help them open up about their feelings and think more clearly. Key Topics Covered in the Course: Understanding Play Therapy Fundamentals Exploring the Benefits and Outcomes of Play Therapy Delving into Models and Approaches in Play Therapy Creating the Ideal Play Setting for Therapists and Abused Children Addressing Common Issues in Play Therapy Why Prefer This Course? Play Therapy & Art Therapy FREE PDF certificate accredited by CPDQS Get instant access to this Play Therapy & Art Therapy Training course. Learn Play Therapy & Art Therapy from anywhere in the world Play Therapy & Art Therapy Training is affordable and simple to understand Lifetime access to the Play Therapy & Art Therapy Training course materials Play Therapy & Art Therapy Training comes with 24/7 tutor support Free assessments available with Play Therapy & Art Therapy Training Get a free student ID card! with Play Therapy & Art Therapy Training *** Course Curriculum of Play Therapy & Art Therapy*** Diploma in Play Therapy Module 01: What is Play Therapy Module 02: Advantages and Outcomes of Play Therapy Module 03: Models and Approaches of Play Therapy Module 04: The Play Settings: Therapist, Abused Child, and Materials Module 05: Typical Issues in Play Therapy Module 06: Play Therapy for Sexually and Emotionally Abused Children Module 07: Play Therapy for Children Who Are Homeless Module 08: Play Interventions for Disaster Mental Health Module 09: Case Studies and Recent Trends in Play Therapy CPD 170 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about Play Therapy & Art Therapy is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this Play Therapy & Art Therapy course. Career path After completing this Play Therapy & Art Therapy course, you are to start your career or begin the next phase of your career.

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Limited Time Offer is Active! Offer Ends Soon, Hurry Up!! Welcome to the Cleaning Assistant course! This course will teach you the skills and techniques needed to become a proficient cleaning assistant. Throughout the Cleaning Assistant course, you will learn about a variety of cleaning topics, including: Basic cleaning techniques, such as dusting, vacuuming, and mopping Proper use and maintenance of cleaning equipment, including vacuum cleaners, mops, and buckets Techniques for cleaning specific surfaces and materials, such as carpet, wood, and glass Health and safety considerations for cleaning, including the use of personal protective equipment (PPE) and the handling of hazardous chemicals Tips for organising and prioritising your cleaning tasks Techniques for effectively communicating with clients and colleagues In addition to learning about these topics through lectures and demonstrations, you will also have the opportunity to practice your cleaning skills through hands-on exercises and real-world simulations. By the end of this Cleaning Assistant course, you should have the knowledge and confidence to take on any cleaning challenge that comes your way. Why Prefer this Cleaning Assistant Course? Opportunity to earn a certificate that is accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery). Innovative and engaging content. Free assessments. ****Course Curriculum of Cleaning Assistant Training**** Module 01: An Introduction to the Cleaning Job Module 02: The Diversity of Cleaning Jobs Module 03: Cleaning Equipment, Products, and Clothing Module 04: House Cleaning Module 05: Food Kitchen and Commercial Kitchen Cleaning Module 06: Office Cleaning Module 07: Bathroom Cleaning Module 08: Cleaning and Organising a Kid's Room Module 09: Cleaning Walls Module 10: Cleaning External Surfaces and Areas Module 11: Dealing with Non-Routine Waste Module 12: Customer Satisfaction Module 13: Organisational Skills Module 14: Communication Skills CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course is designed for anyone interested in starting a career in cleaning and for individuals who want to improve their cleaning skills for personal use. This could include people looking to work as professional cleaning assistants in various settings, such as residential homes, commercial offices, or public facilities. Requirements The program does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed and grow a quality skillset. Career path Cleaner Cleaning Assistant Office Cleaner Home Cleaning Service Worker Bathroom Cleaner Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Our Aim Is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Microsoft Excel course might help you get there! Expand your expertise with high-quality training - study the Microsoft Excel course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Microsoft Excel online training course. The Microsoft Excel course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Microsoft Excel course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This Microsoft Excel training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer Us? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card!(£10 postal charge will be applicable for international delivery) Innovative and Engaging Content. Free Assessments 24/7 Tutor Support. Take a step toward a brighter future! *** Course Curriculum *** Here are the topics you will cover in the Course: >> Microsoft Excel - Beginner, Intermediate & Advanced << Unit 01: Excel from A-Z Course Introduction Unit 02: Getting Started With Excel Unit 03: Values, Referencing and Formulas Unit 04: Intro to Excel Functions Unit 05: Adjusting Excel Worksheets Unit 06: Visually Pleasing Cell Formatting Unit 07: How to Insert Images and Shapes! Unit 08: Visualize Data with Charts Unit 09: Excel's Printing Options Unit 10: Benefits of Using Excel Templates Unit 11: Working with Excel Datasets Unit 12: Excel Database Functions Unit 13: Excel Data Validation Unit 14: Excel PivotTables Unit 15: Excel's PowerPivot Add-In Unit 16: Excel's Conditional Functions Unit 17: Excel's Lookup Function Unit 18: Text Based Functions in Excel Unit 19: Auditing Formulas and Views in Excel Unit 20: Excel's 'what If?' Tools Unit 21: Welcome to Excel VBA Unit 22: The VBA Language Unit 23: Writing VBA Code Unit 24: Important VBA Tools and Logic Unit 25: Excel VBA Lopps Unit 26: Triggering Macros Unit 27: Excel User Forms Unit 28: Starting a Career in Excel Tutor Support Once you enrol in our Microsoft Excel Course with the Academy for Health & Fitness, you are allocated your tutor. The tutor's guidance and assistance will be available throughout your studies with the college. He/ she will evaluate your work and will provide you with regular feedback on your progress. CPD 15 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this Microsoft Excel course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Gain the skills to support young children with special education needs in your work with our Early Years SEN course. Learn about the EYFS framework, SEN teaching methodologies, and how to support children with a range of needs. Understand the importance of the early years in child development and create a positive and inclusive learning environment. Our Early Years SEN course is designed for educators and professionals working with young children, particularly those with special education needs (SEN). The course covers a range of topics, including an overview of the Early Years Foundation Stage (EYFS) framework and an introduction to SEN. You'll learn about high-quality teaching techniques and SEN teaching methodologies, as well as how to support children with communication and interaction, cognition and learning, social, emotional and mental health difficulties, and sensory or physical needs. The course also covers the importance of the early years in child development and how to provide a positive and inclusive learning environment for all children. By the end of the course, you'll have the skills and knowledge you need to effectively support young children with SEN in your work. Upon completion of the Early Years SEN course, you will be able to: Understand the principles and practices of the Early Years Foundation Stage (EYFS) framework. Have a working knowledge of special education needs (SEN) and the different types of needs that young children may have. Implement high-quality teaching techniques to support children with SEN. Understand and use a range of SEN teaching methodologies in Early Years Support children with communication and interaction difficulties in Early Years Help children with cognition and learning difficulties to make progress Early Years Identify and support children with social, emotional and mental health difficulties. Why Prefer Us? Opportunity to earn a certificate accredited by CPD. Get a free student ID card! (£10 postal charges will be applicable for international delivery) Innovative and engaging content. Free assessments on Early Years 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Here is the curriculum breakdown of the Early Years SEN course: Module 1. Introduction to EYFS Module 2: Special Education Needs: An Overview Module 3: High-Quality Teaching for Pupils Module 4: SEN Teaching Methodologies Module 5: Communication and Interaction Module 6: Cognition and Learning Module 7: Social, Emotional and Mental Health Difficulties Module 8: Sensory or Physical Needs Module 9. Importance of Early Years in Development CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is suitable for: Educators and professionals working with young children, particularly those with special education needs (SEN). Early years practitioners, such as teachers, teaching assistants, and nursery nurses. Parents and caregivers of young children with SEN. Students studying early childhood education or special education. Anyone interested in learning more about the Early Years Foundation Stage (EYFS) framework and how to support young children with SEN. Requirements You will not need any prior background or expertise to enrol in this course. Career path Early years teacher (Salary: £25,714 to £36,961) Special educational needs (SEN) teacher (Salary: £30,384 to £48,388) Nursery nurse (Salary: £33,706 to £40,588) Speech and language therapist (Salary: £25,655 to £53,219) Occupational therapist (Salary: £25,654 to £45,838) Children's social worker (Salary: £27,000 to £42,000) Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! Did you know that there is no legal obligation for barbers to possess any particular degree or to carry a general license? It indicates that just a particular skill set is required to work in this field. If you have no prior experience with Barbering and Hairdressing, we've got you covered. We provide a thorough Barbering and Hairdressing course that covers practically all the information you want. In this Barbering and Hairdressing course, you will explore different tools required for barbering. You will learn the social aspect of the business, how to interact with clients, deal with financial issues, and technical skills. Additionally, we will also provide modules emphasising clipper work, scissor work, beard work, and many more. Suppose you are prepared to put in the time and effort. In that case, this Barbering and Hairdressing course, which is a compilation of experience and research, will teach you the best methods for giving a thorough haircut, and you will be looking forward to launching your business in no time. This is an excellent place to start if you are interested in a career in Barbering and Hairdressing, whether full- or part-time. It's worth a go, even if you just want to do something artistic in your own time. Don't miss out. Enrol Now! Upon successful completion of the Barbering and Hairdressing course, you will be able to, Explore the tools required for barbering. Learn the social aspect of the barbering business. Discover different financial aspects of this business. Improve your understanding of interacting with clients. Determine the fundamental technical skills required for Barbering and Hairdressing. Gain a thorough grasp of a clipper, scissors, and beard work. Barbering is a kind of service given to men for haircutting and styling requirements. Barbers work to help shave, cut, and grow the hair of the head and neck area. A barber not only cut hair but also often provide facial hair removal services for men. Take a step toward a brighter future! Why Prefer this Barbering and Hairdressing Training Course? Opportunity to earn a certificate accredited by CPDQS. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. *** Course Curriculum *** Here is the curriculum breakdown of the Barbering and Hairdressing course: Module 1: Introduction Introduction Tools The social aspect of the business part one The social aspect of the business part two How to interact with the clients Negotiating and dealing with the financial aspect of the business Dealing with your coworkers the problem that you might face Module 2:Technical skills Consultation After the consultation Clipper work 1 Clipper work 2 Clipper work 3 Clipper work 4 Scissor work Scissor work 2 Beard's work 1 Beard's work 2 Conclusion and end of the course CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Barbering and Hairdressing course is ideal for: Anyone who wants to become a barber. Individuals are interested in barbering. Professionals who want to discover a fresh creative side business. Anyone looking for a hobby? Requirements You will not need any prior background or expertise to enrol in this Barbering course. Career path This Barbering and Hairdressing course is uniquely designed to benefit the following career options. Barber Hairdresser Hair Stylist In the United Kingdom, the average salary of these professions ranges from £20,000 to £30,000 per annum. Certificates CPDQS Accredited Certificate Digital certificate - £10 CPDQS Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Deal Price is Active! Save Now- £403! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Screenwriting & Scriptwriting Course might help you get there! Expand your expertise with high-quality training - study the Screenwriting & Scriptwriting and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the online training course. This Screenwriting & Scriptwriting online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this training course in around 07 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The Screenwriting & Scriptwriting course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. This training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join the course today - gear up with the essential skills to set yourself up for excellence! Experts created the Screenwriting & Scriptwriting course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Screenwriting & Scriptwriting Course Module 1: Introduction Module 2: Motivation & Ideas Module 3: Research & Development Module 4: Genre Module 5: Story & Plot Module 6: Character & Dialogue Module 7: Structure & Format Module 8: Synopses, Outlines & Treatments Module 9: Drafts Module 10: Marketing Module 11: Troubleshooting Module 12: Glossary Module 13: Screenwriting and the British Film Industry Module 14: Agreements Module 15: How Much Do UK Screenwriters Earn? Module 16: Greatest British Screenwriters of All Time Aassessment Process Once you have completed all the modules in the course, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career. Certificates CPD Accredited Certificate Digital certificate - £10 CPD Accredited Certificate Hard copy certificate - £29 If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10