42954 Learning courses in Cardiff delivered Online

Course Overview This comprehensive First Aid at Work course is designed to equip learners with the knowledge needed to effectively manage health-related emergencies in professional settings. Covering a wide range of workplace incidents, it explores the role of appointed persons, emergency protocols, and how to respond to common injuries and illnesses. Learners will develop confidence in managing both physical and mental health-related situations at work, including remote support and procedures adapted for the COVID-19 era. Whether you are an employee, manager, or business owner, this course provides essential guidance that aligns with UK regulations and first aid expectations in modern work environments. By the end of the course, learners will be familiar with key emergency response procedures and legal requirements, contributing to a safer and more responsible workplace culture. Course Description The First Aid at Work course offers in-depth learning across a structured series of modules that cover everything from primary and secondary assessments to CPR, AED usage, and mental health support. It examines various types of injuries and illnesses such as fractures, dislocations, breathing problems, and minor workplace injuries. The course also discusses the legal framework for first aid at work, risk assessments, and the importance of mental health awareness. Additionally, it addresses recent considerations such as pandemic-specific protocols and remote psychological support. Learners will gain theoretical insight into emergency handling, including when and how to contact emergency services. With up-to-date content aligned with UK standards, this course is ideal for those looking to support a health-conscious and safety-oriented work environment. Course Modules: Module 01: Introduction to Workplace First Aid Module 02: Appointed Persons in the Workplace First Aid Module 03: Incident Management at Work Module 04: Classifications and Abbreviations Module 05: Emergency Management Module 06: Primary Survey Module 07: Secondary Survey Module 08: Basic First-Aid Techniques Module 09: AED Module 10: Minor Injuries at Workplace Module 11: Loss of Responsiveness and CPR Module 12: Breathing Problems Module 13: Secondary Illnesses and Injuries Module 14: Fractures and Dislocations Module 15: Call for an Emergency Module 16: Things to Keep in Mind for A First Aider Module 17: Legal Framework for Workplace First Aid Module 18: Mental Health First Aid in the Workplace Module 19: First Aid during Coronavirus Pandemic Module 20: First Aid Qualifications During the Pandemic, Risk at Work and PPE Regulations Module 21: Remote Psychological First Aid (See full curriculum) Who is this course for? Individuals seeking to understand workplace first aid responsibilities. Professionals aiming to support health and safety compliance in the workplace. Beginners with an interest in health and safety protocols. Managers, HR personnel, or safety officers seeking foundational knowledge in first aid. Career Path Workplace Health & Safety Officer HR and Compliance Manager Office Administrator with Safety Responsibilities Site or Facility Supervisor Community Support Worker Mental Health Support Facilitator Risk Management and Corporate Safety Advisor

Course Overview This comprehensive Microsoft Office course provides an in-depth understanding of the core Office applications—Word, Excel, PowerPoint, and Access. Designed to develop essential digital skills, it equips learners with the ability to navigate each program with confidence, improving document creation, data management, presentations, and database handling. Covering both foundational and advanced features, the course is ideal for those looking to boost their efficiency in a variety of business and administrative contexts. By the end of the course, learners will have the capability to produce professional documents, organise data in spreadsheets, create impactful presentations, and manage information through databases. This structured training ensures clarity in using Microsoft Office tools to support workplace productivity and enhance employability across multiple sectors. Course Description This course explores the full functionality of Microsoft Word, Excel, PowerPoint, and Access—focusing on both classic and new features of the 2019 versions. Learners will begin with the essentials, such as creating and formatting documents, performing calculations in spreadsheets, and developing effective slide presentations. As the modules progress, learners will delve into more detailed features, including managing lists, inserting graphics, handling data queries, and designing user-friendly reports. The training also includes familiarisation with the interface and workflow improvements in each application, offering structured, sequential guidance. Ideal for office professionals, jobseekers, and administrative staff, the course enhances digital fluency and enables learners to carry out a wide range of clerical and operational tasks using the Microsoft Office suite. Course Modules Module 01: Microsoft Excel 2019 New Features Module 02: Getting Started with Microsoft Excel Module 03: Performing Calculations Module 04: Modifying a Worksheet Module 05: Formatting a Worksheet Module 06: Printing Workbooks Module 07: Managing Workbooks Module 08: Microsoft Word 2019 Module 09: Microsoft Word 2019 New Features Module 10: Getting Started with Word Module 11: Formatting Text and Paragraphs Module 12: Working More Efficiently Module 13: Managing Lists Module 14: Adding Tables Module 15: Inserting Graphic Objects Module 16: Controlling Page Appearance Module 17: Preparing to Publish a Document Module 18: Workbooks - Microsoft Word 2016 (Beginner) Module 19: Microsoft PowerPoint 2019 Module 20: Microsoft PowerPoint 2019 New Features Module 21: PowerPoint Interface Module 22: Presentation Basics Module 23: Formatting Module 24: Inserting Options Module 25: Working with Objects Module 26: Table Module 27: Charts Module 28: Review and Presentation Module 29: Microsoft Access 2019 Module 30: Microsoft Access 2019 New Features Module 31: Introduction to Access Module 32: Modify Data Module 33: Working with Queries Module 34: Access Forms Module 35: Working with Reports (See full curriculum) Who is this course for? Individuals seeking to improve their office software knowledge for employment. Professionals aiming to upgrade their digital skills in a business setting. Beginners with an interest in learning Microsoft Office applications. Jobseekers and administrative workers looking to strengthen their CVs. Career Path Administrative Assistant Data Entry Officer Office Manager Project Coordinator Personal Assistant Executive Support Roles Customer Service Representative Database Administrator (Entry-Level)

The Diploma in Web Design, is one of our most selling courses and provides a unique way to intensify the skills you need for designing excellent, expert web pages. You do not require any prior experience or knowledge to enrol in this online course, which makes it ideal to start out on your web designing career. Once you have completed the course, you will be an expert in web design. HTML 5, and CSS 3 are the primary building sections of the websites. In this course, you will learn the advanced techniques of HTML 5, CSS 3, and Bootstrap to confidently design modern looking responsive web pages. Discovering Bootstrap can assist you to compose and develop mobile-ready websites. Additionally, learn to create a wire-frame for a website before beginning the development, and explore how to turn a wire-frame to the website. 8 well-structured modules are covered in this course, including understanding HTML, CSS, Bootstrap, the Grid System, Landing Page, adding images, creating business sites, and many more. Why choose this course Earn a digital 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 Assignment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Who is this course for? Diploma in Web Design - Video Training is suitable for anyone who wants to gain extensive knowledge, potential experience and top-notch skills in the related field. This course is designed by industry experts so you don't have to worry about the quality. Most importantly, this course does not require any experience or prior knowledge to get enrolled. You will learn everything that is required from this course directly. This is a great opportunity for all students from any academic backgrounds to learn more on this subject.

Become a decoder ring for the unspoken language.  This Level 5 Speech and Language Therapy Diploma, endorsed by QLS and accredited by CPD UK, equips you with the foundational knowledge and skills to make a real difference in the lives of individuals with speech and language difficulties. It delves into the fascinating world of human communication, from the intricate dance of vocal cords to the complex pathways of language processing in the brain. Learn to identify the challenges individuals face – from the frustration of stuttering to the silence of developmental delays.  Are you ready to become a bridge, a voice amplifier, a communication cheerleader? Enrol today and embark on your journey towards a world where everyone can be heard! Learning Outcomes Gain a comprehensive understanding of the speech and language mechanisms. Explore various speech and language disorders, including articulation difficulties, fluency problems, developmental delays, and aphasia. Learn to effectively assess communication skills in individuals across different age groups and identify areas requiring support. Develop practical skills in implementing evidence-based therapy techniques. Understand the ethical considerations in speech and language therapy. Learn to collaborate effectively with other healthcare professionals and caregivers. Why choose this course Affordable, Accessible, informative and well-structured study materials Earn a globally recognised accredited qualification Study in your own time, at your own pace, through any device Benefit from feedback through mock exams and multiple-choice assessments Excellent career advancement/career switch opportunities Get 24/7 help or advice from our email and live chat teams Who is this course for Aspiring Speech and Language Therapists Healthcare Professionals Educators & Teaching Assistants Parents & Carers Entry requirements While formal qualifications might not be mandatory, a genuine interest in communication and some experience working with children or adults with disabilities can be beneficial to good written and verbal communication skills. Certification Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of Achievement. This certificate will be delivered to your doorstep through the post for £99. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After completing 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. Method of Assessment At the end of the course, there will be an online MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, you will get the results immediately and can apply for your QLS-endorsed certificate. Career Path This Level 5 qualification opens doors to various career paths in the field of speech and language therapy. Depending on your goals and further education, possibilities include: Speech and Language Therapy Assistant Communication Specialist Early Intervention Practitioner Community Outreach Worker By embarking on this journey, you’ll gain the knowledge and skills to empower individuals with speech and language difficulties to find their voice and communicate effectively. This course is your first step towards a rewarding career in communication and a chance to make a positive impact on the lives of others. Course Content Module 01: An Overview of Speech Therapy Module 02: The Science of Speech Module 03: The Anatomy of Speech Module 04: Characteristics of Speech: Linguistic Disciplines Module 05: Literacy & Language Development Module 06: Child Speech & Language Disorders Module 07: Adult Speech & Language Disorders Module 08: How to Help a Child with SL Difficulties

Elevate your career in adult care with our Level 3 Diploma. Gain comprehensive knowledge and practical skills to provide exceptional care to adults. Accredited program for aspiring caregivers, ensuring excellence in support and assistance. Enroll now for a rewarding journey in the field of adult care.

This Advanced Diploma in Coaching and Mentoring is designed to equip you with the knowledge and skills of coaching and mentoring. You will learn the skills, techniques and in depth insights of mentoring. In the role of mentor, you will contract and develop with your client a highly personal yet professional relationship that is creative, dynamic and intentional resulting in a positive outcome. Why choose this course Earn a digital 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 Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion PDF Certificate at £9.99. Print copy by post is also available at an additional cost of £15.99 and the same for PDF and printed transcripts. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment To successfully complete the course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the course. After successfully passing the exam, you will be able to apply for Quality Licence Scheme endorsed certificate of achievement. To verify your enhanced skills in the subject, we recommend that you also complete the assignment questions. These can be completed at any time which is convenient for yourself and will be assessed by our in-house specialised tutors. Full feedback will then be given on your current performance, along with any further advice or support. Who is this course for? The Advanced Diploma in Coaching and Mentoring is aimed at anyone wishing to start working in such roles, or existing professionals wishing to boost their skills and employability. Our courses are open to learners of all levels with no formal experience or qualifications required to enrol. However, learners should be aged 16 or over and have a good understanding of English language, numeracy and IT. Career path Studying this course would benefit a range of careers, but would specifically boost employability in roles such as Coach Development Instructor Facilitator Life Coach Life Consultant Mentor Talent Coach Course Contents Introduction to Coaching and Mentoring Coaching and Mentoring Objectives and Processes Ethical Aspects of Coaching and Mentoring Coaching and Mentoring Models Effective Communication Skills Personal Skills Management Skills Functional Skills

SEN Teaching Assistant Diploma with Autism, ADHD, Dyslexia & Dysphagia Awareness Empower your teaching career with our comprehensive SEN Teaching Assistant Diploma. Specialize in supporting students with Autism, ADHD, Dyslexia, and Dysphagia. Become an expert SEN Teaching Assistant and champion inclusive education. Learning Outcomes: Comprehend the intricacies of SEND as an SEN Teaching Assistant. Apply the SEND Code of Practice as an SEN Teaching Assistant. Utilise effective classroom strategies as an SEN Teaching Assistant. Implement educational psychology in teaching as an SEN Teaching Assistant. Understand Autism Spectrum Disorder (ASD) to support as an SEN Teaching Assistant. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Key Modules from SEN Teaching Assistant Diploma: Understanding SEND: Delve into the foundations of special educational needs and disabilities crucial for an SEN Teaching Assistant. SEND Code of Practice - 0 to 25 Years: Explore the legal and practical frameworks guiding SEN Teaching Assistants. An Overview of Teaching Assistant: Review the general role and responsibilities expected of a Teaching Assistant with a focus on SEN. Working in The Classroom: Gain practical strategies for effective classroom management as an SEN Teaching Assistant. Educational Psychology: Apply principles of educational psychology to support diverse learning needs as an SEN Teaching Assistant. Phonics Teaching: Develop phonics teaching skills to enhance reading development, particularly useful for SEN Teaching Assistants. Learn about Autism Spectrum Disorder (ASD): Acquire foundational knowledge about ASD for a nuanced approach to support as an SEN Teaching Assistant. Types of Autism: Identify the various manifestations of autism to tailor support as an SEN Teaching Assistant. Symptoms of Autism: Recognise symptoms of autism to provide timely interventions as an SEN Teaching Assistant. Autism Awareness: Promote understanding and best practices in autism support as an SEN Teaching Assistant. Fundamentals of ADHD: Understand the core concepts of ADHD and its impact on learning for an SEN Teaching Assistant. ADHD Management Strategies: Implement effective management strategies for ADHD in the classroom as an SEN Teaching Assistant. Identification of Dyslexia: Learn how to identify signs of dyslexia for targeted teaching support as an SEN Teaching Assistant. Treatment of Dyslexia: Explore treatment and support strategies for dyslexic students as an SEN Teaching Assistant. Teaching Dyslexics: Adapt teaching methods to meet the needs of dyslexic learners as an SEN Teaching Assistant. Speech & Language Therapist: Understand the role of speech and language therapy in supporting communication as an SEN Teaching Assistant. Speech Language Pathologist: Learn about the interventions used by speech-language pathologists that an SEN Teaching Assistant can apply in educational settings.

We will help you become an ethical hacker in this course.

Overview This International Business Principles course will unlock your full potential and will show you how to excel in a career in International Business Principles. So upskill now and reach your full potential. Everything you need to get started in International Business Principles is available in this course. Learning and progressing are the hallmarks of personal development. This International Business Principles will quickly teach you the must-have skills needed to start in the relevant industry. In This International Business Principles Course, You Will: Learn strategies to boost your workplace efficiency. Hone your International Business Principles skills to help you advance your career. Acquire a comprehensive understanding of various International Business Principles topics and tips from industry experts. Learn in-demand International Business Principles skills that are in high demand among UK employers, which will help you to kickstart your career. This International Business Principles course covers everything you must know to stand against the tough competition in the International Business Principles field.  The future is truly yours to seize with this International Business Principles. Enrol today and complete the course to achieve a International Business Principles certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the International Business Principles course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the International Business Principles course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the International Business Principles course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This International Business Principles is suitable for anyone aspiring to start a career in International Business Principles; even if you are new to this and have no prior knowledge on International Business Principles, this course is going to be very easy for you to understand.  And if you are already working in the International Business Principles field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this International Business Principles course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This International Business Principles course has no prerequisite.  You don't need any educational qualification or experience to enrol in the International Business Principles 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 International Business Principles course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Section 01: International Economics and Trade Theory International Business General Concepts 00:03:00 The Importance of International Business 00:04:00 Globalisation of Commerce 00:03:00 International Economics and Trade Theory 00:07:00 Comparative Advantage of Nations 00:03:00 Comparative Advantage versus Absolute Advantage 00:04:00 Strategies for Entering and Developing International Markets 00:04:00 Foreign Direct Investment (FDI) 00:07:00 Foreign Exchange Markets and International Monetary System 00:04:00 Exchange Rate Policies 00:04:00 Purchasing Power Parity (PPP) 00:02:00 Section 02: Global Capital Markets and Regional Trade Zones Global Capital Markets and Regional Trade Zones 00:04:00 The World Bank 00:01:00 Adapting to the Times and the WTO 00:03:00 The Organisation for Economic Cooperation and Development (OECD) 00:01:00 Emerging Markets and Regional Trade Zones 00:02:00 Asian-Pacific Economic Cooperation (APEC) 00:02:00 Section 03: International Business Strategies International Business Strategies 00:02:00 Free Trade Zones 00:02:00 Multinational Enterprise Structures 00:06:00 The Organizational Structure of a Multinational Company 00:03:00 International Marketing 00:02:00 Phases of International Marketing Involvement 00:02:00 Global Marketing 00:01:00 Demographic Factors Affecting International Trade 00:04:00 Ageing and Comparative Advantage 00:04:00 Changes in Labour Force Composition 00:01:00 Section 04: Demographic Factors / International Accounting / Cross Border HR MGMT International Accounting and Transfer Pricing 00:03:00 Basic Issue Underlying Transfer Pricing 00:04:00 Global Transfer Pricing Regimes 00:02:00 How to Implement a Cross-Border Human Resources Policy 00:08:00 Section 05: International Business Instruments and Agreements International Business Instruments 00:02:00 Trade Terms 00:05:00 International Shipping and Freight Forwarders 00:01:00 Freight Forwarder Fundamental Role 00:02:00 Cross Border Agreements 00:02:00 Taxable Presence 00:04:00 Accounting Issues 00:04:00 VAT/GST through Centralized Teams 00:02:00 Value for Customs 00:03:00

Overview This SQL course will unlock your full potential and will show you how to excel in a career in SQL. So upskill now and reach your full potential. Everything you need to get started in SQL is available in this course. Learning and progressing are the hallmarks of personal development. This SQL will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your SQL skills to help you advance your career. Acquire a comprehensive understanding of various SQL topics and tips from industry experts. Learn in-demand SQL skills that are in high demand among UK employers, which will help you to kickstart your career. This SQL course covers everything you must know to stand against the tough competition in the SQL field.  The future is truly yours to seize with this SQL. Enrol today and complete the course to achieve a SQL certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the SQL course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the SQL course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the SQL course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This SQL is suitable for anyone aspiring to start a career in SQL; even if you are new to this and have no prior knowledge on SQL, this course is going to be very easy for you to understand.  And if you are already working in the SQL field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this SQL course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This SQL course has no prerequisite.  You don't need any educational qualification or experience to enrol in the SQL 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 SQL course. Course Curriculum Unit 01: Course and Instructor Introduction Course and Instructor Introduction 00:05:00 Unit 02: Laying out the foundation - Overview & Installation Pre-requisites & Different Editions of SQL Server 00:06:00 Downloading Express Edition & sample database 00:03:00 Installing the downloads & Configuration 00:19:00 The sa Login 00:04:00 Wrap up - what we went over! 00:01:00 Unit 03: Core concepts - Taming the RDBMS beast! What is RDBMS? 00:12:00 Where does SQL Server fit in? 00:02:00 Basic database objects 00:16:00 Different Files that got installed - MDF & LDF 00:03:00 Wrap up - what we went over! 00:01:00 Unit 04: Tool of the trade - SQL Server Management Studio Getting started with SSMS 00:07:00 Getting around Object Explorer 00:05:00 Query Window 00:06:00 Pre-built DB - system database 00:04:00 Wrap up - what we went over! 00:01:00 Unit 05: Simple SELECT Bare Minimum: SELECTING a literal 00:05:00 Retrieving / querying data from a table - using FROM clause 00:06:00 Playing with Column Names 00:03:00 Rearranging columns to your liking 00:01:00 Wrap up - what we went over! 00:01:00 Unit 06: Filtering out unwanted data Narrowing down and ordering result set - WHERE and ORDER clause 00:17:00 Narrowing down result set - BETWEEN / NOT BETWEEN 00:09:00 Narrowing down result set - IN and NOT IN operator 00:05:00 Narrowing down result set - Pattern Matching: LIKE and Wildcards 00:11:00 Wrap up - what we went over! 00:01:00 Unit 07: Expressions and Functions Dealing with nothing: NULL 00:06:00 Working with strings: Concatenation and other string functions 00:15:00 Working with dates: Date Functions 00:07:00 Some System Functions 00:05:00 Wrap up - what we went over! 00:02:00 Unit 08: Getting data out of multiple tables Joining multiple tables - INNER JOIN 00:09:00 Join types - OUTER JOIN - LEFT / RIGHT / FULL 00:08:00 Join types - CROSS JOIN 00:02:00 Holy UNION! 00:03:00 Subqueries 00:04:00 Wrap up - what we went over! 00:02:00 Unit 09: Summarizing and Grouping data DISTINCT and ALL Predicates 00:02:00 Aggregate Functions 00:03:00 GROUP BY clause / HAVING clause 00:04:00 WHERE and ORDER BY in aggregate queries 00:04:00 Wrap up - what we went over! 00:01:00 Unit 10: Bonus Bonus_Section 00:01:00