43303 Courses

Martial arts can result in minor to major injuries. Therefore, it's crucial to provide first aid to prevent the condition from worsening. Learn how to administer first aid in a martial arts setting by taking this Diploma in Martial Arts First Aid course. This Diploma in Martial Arts First Aid course will teach you how to cater to common martial arts injuries. The course covers the methods to treat CPR. In addition, it introduces you to common and significant injuries. The training will provide excellent lectures on injury prevention to reduce injuries and promote recovery. On top of that, you'll discover what kind of emergencies require first aid and how to provide first aid treatment to people before the medical personnel arrives. Enrol now and prepare yourself for any eventuality. Learning Objectives Identify the importance of first aid in injury prevention Learn how to provide first aid solutions to martial arts injuries. Know about the correct equipment to provide first aid Learn how to perform CPR Familiarise yourself with the typical first aid injuries Learn the first aid procedures to deal with significant injuries Understand how to provide first aid before medical help arrives Who is this Course for? This Diploma in Martial Arts First Aid course is ideal for aspiring professionals who wish to gain the relevant skills and knowledge to fast track their careers. It is for those who have little or no knowledge of martial arts first aid or those who are new to the field and want to test their skills and knowledge. There are no entry requirements for this course. However, an eye for detail and a creative mind is essential. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy, and ICT are required to attend this course. CPD Certificate from Course Gate  At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career Path Upon successfully completing the Diploma in Martial Arts First Aid course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Community First Aider Martial Arts Instructor Fitness Instructor Sports Coach Martial Arts Practitioner Course Curriculum Module 01: Introduction to Martial Arts First Aid Introduction to Martial Arts First Aid 00:10:00 Module 02: Initial Assessment Initial Assessment 00:45:00 Module 03: CPR & Recovery Position CPR & Recovery Position 00:20:00 Module 04: Common Injuries Common Injuries 00:35:00 Module 05: Major Injuries Major Injuries 00:41:00 Module 06: Medical Emergencies Medical Emergencies 00:33:00 Module 07: Injury Prevention Injury Prevention 00:51:00 Module 08: Things to Keep in Mind Things to Keep in Mind 00:14:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Strategic Planning: Strategic Planning Course Online Strategic Planning: Strategic Planning Course is the ongoing planning, supervising, analysis, and evaluation of all requirements an organization requires to meet its goals and objectives. Strategic management is widely regarded as having both financial and nonfinancial advantages. A Strategic Planning: Strategic Planning Course process assists an organization and its leaders in considering and planning for its future existence. Strategic management means sequential steps to reach its goal. One needs to stay focused if he or she wants to be successful and that's the point to maintain strategy. In personal or professional life one should follow strategic management. An organization that faces another competitor or going through a loss or a person who wants to leave behind other’s needs to maintain strategy. Our Strategic Planning: Strategic Planning Course gives you the knowledge to become successful in professional or personal life. Our course module is created by experts to expand your skill. Enrol on our course to learn more. This Strategic Planning: Strategic Planning Course covers how to increase your communication, steps forward with your own. The purpose of this Strategic Planning: Strategic Planning Course is to teach how to achieve your goals and prepare your career. Main Course: Strategic Planning Course Free Courses included with Strategic Planning: Strategic Planning Course: Along with Strategic Planning Course you will get free Level 7 Diploma in Leadership & Management Along with Strategic Planning Course you will get free Logistics Management Special Offers of this Strategic Planning: Strategic Planning Course; This Strategic Planning: Strategic Planning Course includes a FREE PDF Certificate. Lifetime access to this Strategic Planning: Strategic Planning Course Instant access to this Strategic Planning: Strategic Planning Course 24/7 Support Available to this Strategic Planning: Strategic Planning Course Strategic Planning: Strategic Planning Course Online The Strategic Planning: Strategic Planning Course explains the middle point from where all the strategic management transformations happen or stuck. Also, the Strategic Planning: Strategic Planning Course describes how to develop a highly effective team and optimize better performance. Through the help of the Strategic Planning: Strategic Planning Course, you will also learn how to deal with unwanted circumstances with courage and persistence. Our Strategic Planning: Strategic Planning Course can lead to transformation rather than doing a transformation from the top. Who is this course for? Strategic Planning: Strategic Planning Course Online This Strategic Planning course is a great option to become your own leader. To maintain success at every step you have to know about strategy. Do not wait to enroll in our course now. Requirements Strategic Planning: Strategic Planning Course Online To enrol in this Strategic Planning: Strategic Planning Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Strategic Planning: Strategic Planning Course. Be energetic and self-motivated to complete our Strategic Planning: Strategic Planning Course. Basic computer Skill is required to complete our Strategic Planning: Strategic Planning Course. If you want to enrol in our Strategic Planning: Strategic Planning Course, you must be at least 15 years old. Career path Strategic Planning: Strategic Planning Course Online After completing this Strategic Planning course, you may be able to pursue a variety of promising career opportunities.

This Diploma in Hairdressing Course Online aims to teach you the skills and knowledge required to work as a professional hairdresser or stylist, or even successfully run a salon as a manager. Acting as a complete guide, this online Diploma in Hairdressing course will teach you different techniques to work safely and effectively in saloons and learn about the tricks of the trade for cutting & styling both men and women's hair. Completing this hairdressing training will open up a raft of opportunities for you in the cosmetology industry. If you want to give your clients an unforgettable hairdressing experience, this course is all you need!  Why choose this course Earn a free e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Online study materials Mock exams Multiple-choice assessment Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Method of Assessment To successfully complete the Diploma in Hairdressing 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 a CPD-accredited certificate as proof of your subject-knowledge. 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.

A course by Sekhar Metla IT Industry Expert RequirementsNo programming experience needed. You will learn everything you need to knowNo software is required in advance of the course (all software used in the course is free)No pre-knowledge is required - you will learn from basic Audience Beginner PHP coding, MySQL and JavaScript developers curious about web development Anyone who wants to generate new income streams Anyone who wants to build websites Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer Audience Beginner PHP coding, MySQL and JavaScript developers curious about web development Anyone who wants to generate new income streams Anyone who wants to build websites Anyone who wants to become financially independent Anyone who wants to start their own business or become freelance Anyone who wants to become a Full stack web developer

About Course Ethical behaviour brings significant benefits to businesses such as attracting employees, customers and investors. But failure to manage it properly can create huge challenges. Suppose every employee knows the difference between correct or incorrect choices and how to handle various ethical dilemmas. This knowledge is likely to produce a work environment where moral transgressors are held accountable for their actions, ultimately building a healthier workplace for all involved. The course explores topics such as Ethical Decision-Making, Ethical culture in organizations, and Corporate Social Responsibilities .These provide practical information to help employees understand business issues and equip them with practical skills for success. Ethics will be formally defined, and the presenter will discuss the sources of ethical dilemmas and the stakeholder's importance when addressing a problem. Enrol now and strengthen yourself against Unethical practices in Business. What Will You Learn? Define 'Ethics' Ethical models and philosophical frameworks for clear decision making. The correct use and protection of Big Data within your company . The ethical issues of Digital Marketing in business and how you can integrate it safely and morally. How to implement ethical principles during crisis events. Course Content Introduction to Business Ethics Introduction to Business Ethics Ethical Decision-Making Ethical Decision-Making Ethical Culture in Organizations Ethical Culture in Organizations Business Ethics in the Digital Age Business Ethics in the Digital Age Corporate Social Responsibility Corporate Social Responsibility Conclusion Conclusion A course by Xpert Learning RequirementsNo specific requirements. Audience Business Professionals Audience Business Professionals

About Course Unleash the Power of TikTok Marketing: Master the Art of Engaging Audiences and Driving Business Growth Harness the captivating potential of TikTok, the world's fastest-growing social media platform, to elevate your marketing strategies and achieve remarkable results. Learning Outcomes/Course Objectives: Understand the TikTok ecosystem: Delve into the intricacies of the TikTok platform, including its unique features, audience demographics, and user engagement patterns. Craft compelling TikTok content: Master the art of creating captivating videos that resonate with your target audience, utilizing TikTok's trending trends, challenges, and creative tools. Build a thriving TikTok community: Learn effective strategies to attract, engage, and grow your TikTok following, transforming casual viewers into loyal brand advocates. Leverage TikTok analytics: Gain insights into your TikTok performance using data-driven analytics, enabling you to optimize your content strategy and maximize campaign effectiveness. Integrate TikTok into your marketing mix: Seamlessly integrate TikTok into your overall marketing strategy, amplifying your brand's presence and driving measurable business outcomes. Target Audience: Business owners: Entrepreneurs and established business leaders seeking to expand their reach and connect with a wider audience on TikTok. Marketing professionals: Marketers eager to tap into TikTok's immense potential to enhance their brand awareness, generate leads, and drive sales. Content creators: Aspiring and experienced content creators seeking to master TikTok's unique format and create viral content that resonates with viewers. Anyone interested in social media marketing: Individuals passionate about exploring the latest social media trends and leveraging TikTok for personal or professional endeavors. Requirements: A TikTok account: Create a TikTok account to actively participate in the platform and apply the course learnings. Basic knowledge of social media marketing: Familiarity with social media marketing principles and best practices will enhance your understanding of TikTok marketing strategies. Enthusiasm and willingness to learn: An open mind and a willingness to experiment with TikTok's creative tools will fuel your success in this dynamic platform. Enroll today and embark on a journey to TikTok marketing mastery! What Will You Learn? Understand the TikTok ecosystem: Delve into the intricacies of the TikTok platform, including its unique features, audience demographics, and user engagement patterns. Craft compelling TikTok content: Master the art of creating captivating videos that resonate with your target audience, utilizing TikTok's trending trends, challenges, and creative tools. Build a thriving TikTok community: Learn effective strategies to attract, engage, and grow your TikTok following, transforming casual viewers into loyal brand advocates. Leverage TikTok analytics: Gain insights into your TikTok performance using data-driven analytics, enabling you to optimize your content strategy and maximize campaign effectiveness. Integrate TikTok into your marketing mix: Seamlessly integrate TikTok into your overall marketing strategy, amplifying your brand's presence and driving measurable business outcomes. Course Content Tiktok Marketing Introduction Chapter 1 Chapter 2 Chapter 3 Chapter 4 Chapter 5 Chapter 6 Chapter 7 Chapter 8 Chapter 9 Conclusion A course by eTrain Course Provider RequirementsA TikTok account: Create a TikTok account to actively participate in the platform and apply the course learnings.Basic knowledge of social media marketing: Familiarity with social media marketing principles and best practices will enhance your understanding of TikTok marketing strategies.Enthusiasm and willingness to learn: An open mind and a willingness to experiment with TikTok's creative tools will fuel your success in this dynamic platform. Audience Business owners Marketing professionals Content creators Anyone interested in social media marketing Audience Business owners Marketing professionals Content creators Anyone interested in social media marketing

About Course Learn the Fundamental Principles of Copywriting and Start Writing Effective Promotional Pieces In this practical course, you will learn the fundamental principles of copywriting, including: Features versus benefits: How to turn product features into benefits that resonate with your target audience Headlines and leads: How to write strong headlines and leads that capture attention and make people want to read more Dramatization of differences: How to use language to emphasize the unique selling points of your product or service Credibility builders: How to establish your expertise and credibility as a writer Social proof: How to use testimonials and other forms of social proof to persuade people to buy Offers and tone: How to craft irresistible offers and write in a tone that appeals to your target audience You will also get the opportunity to complete three real-life writing assignments and compare your work to that of others. This will give you valuable feedback and help you improve your copywriting skills. By the end of this course, you will be able to: Write effective promotional pieces that generate leads and sales Communicate the unique selling points of your product or service Persuade people to take action Write in a tone that What Will You Learn? Through hands-on practice, know how to turn words into money Analyze any persuasion challenge so as to identify the factors that will move readers to action Include all the necessary elements in either the simplest, shortest marketing piece and more complicated ones Differentiate an offering from the competition Capture a reader's attention, explain what's on offer and clinch the deal Gain confidence from a start-to-finish overview of effective copywriting Course Content Introduction Introduction The What and The So What The Importance of 'What' 6 Ways to Clarify the 'What' Benefits - the 'So What' Capture Attention The Top 8 Types of Headlines 8 Leads That Set the Hook Differentiate and Dramatize Differentiate from the Competition 10 Ways to Dramatize Differences Now You Try #1 Credibility and Proof Credibility Builders The Top 5 Types of Social Proof Credibility Killers Offers What Is an Offer? Elements of Offers Now You Try #2 Putting it All Together Tone Formatting Copy Now You Try #3 Conclusion Conclusion A course by Marcia Yudkin Marketing Coach, Introvert Advocate RequirementsSuitable for absolute beginnersGood review and practice for those with some experience Audience Anyone seeking a practical (and potentially lucrative) new writing skill Employees told to write a website, sales letter or ad who aren't sure how Aspiring freelancers wanting a solid foundation for success Managers or business owners who need to know how to assess the work of copywriters they hire Audience Anyone seeking a practical (and potentially lucrative) new writing skill Employees told to write a website, sales letter or ad who aren't sure how Aspiring freelancers wanting a solid foundation for success Managers or business owners who need to know how to assess the work of copywriters they hire

Duration 5 Days 30 CPD hours This course is intended for This course is designed for technical professionals who require the skills to administer IBM MQ. Overview After completing this course, you should be able to: Describe the IBM MQ deployment options Create and manage queue managers, queues, and channels Use the IBM MQ sample programs and utilities to test the IBM MQ network Configure distributed queuing Configure MQ client connections to a queue manager Define and administer a queue manager cluster Administer Java Message Service (JMS) in MQ Implement basic queue manager restart and recovery procedures Use IBM MQ troubleshooting tools to identify the cause of a problem in the IBM MQ network Manage IBM MQ security Monitor the activities and performance of an IBM MQ system This course is also available as self-paced virtual (e-learning) course IBM MQ V9.1 System Administration (ZM156G). This option does not require any travel.This course teaches you how to customize, operate, administer, and monitor IBM MQ on-premises on distributed operating systems. The course covers configuration, day-to-day administration, problem recovery, security management, and performance monitoring. In addition to the instructor-led lectures, the hands-on exercises provide practical experience with distributed queuing, working with MQ clients, and implementing clusters, publish/subscribe messaging. You also learn how to implement authorization, authentication, and encryption, and you learn how to monitor performance. Introducing IBM MQ Exercise Getting started with IBM MQ Working with IBM MQ administration tools Exercise Working with IBM MQ administration tools Configuring distributed queuing Exercise Implementing distributed queuing Managing clients and client connections Exercise Connecting an IBM MQ client Advanced IBM MQ client features Working with queue manager clusters Exercise Implementing a basic cluster Publish/subscribe messaging Exercise Configuring publish/subscribe message queuing Implementing basic security in IBM MQ Exercise Controlling access to IBM MQ Securing IBM MQ channels with TLS Exercise Securing channels with TLS Authenticating channels and connections Exercise Implementing connection authentication Supporting JMS with IBM MQ Diagnosing problems Running an IBM MQ trace Backing up and restoring IBM MQ messages and object definitions Using a media image to restore a queue Backing up and restoring IBM MQ object definitions High availability Monitoring and configuring IBM MQ for performance Monitoring IBM MQ for performance Monitoring resources with the IBM MQ Console Additional course details: Nexus Humans WM156G IBM MQ V9.1 System Administration (using Windows for labs) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the WM156G IBM MQ V9.1 System Administration (using Windows for labs) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

The Mastering Organizational Chaos course provides essential insights and strategies to manage chaos within an organization effectively. Participants will learn priority-planning techniques, effective decision-making processes, and the role of communication and critical thinking in navigating and resolving organizational chaos. Learning Outcomes: Understand the nature and causes of organizational chaos. Develop priority-planning skills to manage chaos and set clear objectives. Enhance decision-making abilities to prevent and address chaotic situations. Improve communication strategies to foster cooperation and unity. Apply critical thinking to identify solutions and resolve chaos effectively. Develop resilience and adaptability to handle unexpected challenges. Implement conflict resolution techniques to manage internal conflicts. Foster a positive organizational culture to mitigate chaos and promote productivity. Why buy this Mastering Organizational Chaos? 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 Mastering Organizational Chaos there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Managers and leaders in organizations seeking to improve their crisis management skills. Entrepreneurs and business owners dealing with organizational challenges. Project managers aiming to enhance their decision-making abilities in chaotic situations. Anyone interested in understanding and managing chaos within an organizational context. Prerequisites This Mastering Organizational Chaos does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Mastering Organizational Chaos 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 Crisis Management Specialist: Work with organizations to manage and navigate crises. Organizational Consultant: Provide guidance and strategies for chaos management. Project Manager: Utilize chaos management skills to lead successful projects. Business Analyst: Analyze organizational processes and recommend improvements. Course Curriculum Mastering Organizational Chaos Module 01: Introduction to Organisational Chaos 00:18:00 Module 02: Priority-Planning for Managing Organisational Chaos 00:16:00 Module 03: Effective Decision Making to Prevent Chaos 00:34:00 Module 04: Communication in Organisational Chaos 00:23:00 Module 05: Master Chaos With Critical Thinking 00:18:00 Assignment Assignment - Mastering Organizational Chaos 00:00:00

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  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 Learn MySQL from Scratch for Data Science and Analytics 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 Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00