29872 Management courses

Content Management System is now the most popular computer software that is used to create and modify digital contents. This course has been illustrated to educate you on how it functions. It discusses the fundamental aspects of CMS. Hit the course to enter into the digital world. Start learning Clinical Observation Basics that will give you enough knowledge and skills to build your dream career. About this course This Clinical Observation Basics helps to grow your skills faster through the power of relevant content and world-class tutors. In this industry-leading bite-sized course, you will learn up-to-date knowledge in the relevant field within a few hours and get certified immediately. The modules of this course are very easy to understand and all of the topics are split into different sections. You will easily grasp and use the knowledge gained from this course in your career and go one step ahead of your competitors. The course is designed to improve your employability and provide you with the tools you need to succeed. Enrol today and start learning your essential skills. 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 Get 24/7 help or advice from our email and live chat teams Get full tutor support on weekdays (Monday to Friday) Course Design The Clinical Observation Basics 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 Who Is This Course For:​ This Clinical Observation Basics is ideal for those who want to be skilled in this field or who wish to learn a new skill to build their dream career. If you want to gain extensive knowledge, potential experience, and be an expert in the related field then this is a great course for you to grow your career. Requirements This course is for anyone who would like to learn Clinical Observation Basics related skills to aid his/her career path. No formal entry prerequisites are required Certification 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. Course Content Module 01: An Overview of Clinical Observation and Clinical Carer Module 02: Professional Aspects of Ethical Practice and Legal Standards Module 03: Observation of the Patient's Condition Course Content Clinical Observation Basics Module 01: An Overview of Clinical Observation and Clinical Carer 00:08:00 Module 02: Professional Aspects of Ethical Practice and Legal Standards 00:12:00 Module 03: Observation of the Patient's Condition 00:14:00 Order your Certificates & Transcripts Order your Certificates & Transcripts 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Description: Kick-start a career in the travel industry with this industry recognised course and qualification. You will learn everything you need to work on resort, and deliver an exceptional service to holidaymakers. The Holiday Representative Diploma consists of in-depth modules which are completed using a combination of interactive courseware, quizzes and videos to help you to learn about working as a holiday rep. It will introduce you to the fundamental concepts and principles of working as a Holiday Rep that the tour operators are looking for in all Holiday Rep applicants. With this course you will learn about how the travel industry works, their place in the structure of a travel company, and how the duties they will be expected to perform. You will also be introduced to your legal responsibilities as a travel rep. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Holiday Representative Diploma is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Holiday Representative Diploma is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Holiday Representative Diploma Your Introduction to Becoming a Holiday Rep 00:15:00 Defining the Career of a Holiday Rep 00:30:00 Exploring the Various Types of Holiday Reps 00:30:00 Exploring the Origins and Growth of British Tourism 00:30:00 The Components of the Travel and Tourism Industry 00:15:00 Factors that Affect Your Career 00:30:00 Nailing the Teamwork Element Required to Surpass Expectations 01:00:00 The Standard Duties of Holiday Reps 00:15:00 The Legalities Holiday Reps Need to Know About 01:00:00 The Holiday Reps Role in Keeping their Guests Safe 00:30:00 Effective Handling of Customer Complaints 00:30:00 Administration Duties 00:15:00 Crushing it with Customer Services 00:30:00 Creating the Perfect Welcome Meeting 00:15:00 Guide to Selling Excursions 00:15:00 Preparing and Conducting Transfers Successfully 00:05:00 Tallying Floats and Converting Currencies 00:30:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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

CPDQS Level 3 Diploma in Health and Social Care Course Overview: The CPDQS Level 3 Diploma in Health and Social Care is designed to provide learners with a comprehensive understanding of the essential principles and practices in the health and social care sector. This course covers the rights, responsibilities, and roles of health and social care workers, focusing on key areas such as communication, equality, diversity, safeguarding, and risk management. It provides learners with the knowledge to effectively support individuals in various care settings while ensuring high standards of legal and ethical practice. Upon completion, learners will be equipped with the skills to pursue a career in health and social care, fostering positive outcomes for service users and enhancing professional development. Course Description: This qualification delves into crucial topics, including the legal and professional standards of practice, safeguarding vulnerable individuals, and promoting equality, diversity, and rights within the health and social care sector. Learners will explore the roles and responsibilities of caregivers and healthcare professionals, as well as the ethical and legal frameworks that guide care provision. The course also addresses communication in care settings and the importance of health and safety. By engaging with these subjects, learners will gain valuable insights into the policies and practices that shape care environments, while developing the competencies needed to thrive in a variety of health and social care roles. The structured learning experience is designed to empower learners to make meaningful contributions to the welfare of those they support. CPDQS Level 3 Diploma in Health and Social Care Curriculum: Module 01: Introduction to Health and Social Care Module 02: Communication and its Relevance Module 03: Rights and Responsibilities as a Health and Social Care Worker Module 04: Role as A Caregiver and Healthcare Professional Module 05: Working in Health and Social Care; Promoting Equality, Diversity and Rights Module 06: Important Principles and Policies in Health and Social Care Work Module 07: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part – 1 Module 08: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part – 2 Module 09: Safeguarding Vulnerable Individuals Module 10: Health and Safety Responsibilities Module 11: Risk Management in Health and Social Care (See full curriculum) Who is this course for? Individuals seeking to pursue a career in health and social care. Professionals aiming to advance their knowledge and skills in the sector. Beginners with an interest in health and social care. Those wishing to work in supportive roles within healthcare settings. Career Path Health and Social Care Assistant Caregiver or Healthcare Support Worker Social Care Worker Safeguarding Officer Health and Safety Officer Risk Management Specialist Healthcare Compliance Officer

Air Cabin Crew Online Diploma Course Course Overview: The Air Cabin Crew Online Diploma Course provides a comprehensive introduction to the vital roles and responsibilities of cabin crew members. Covering key areas of aviation, including airline operations, regulatory standards, and emergency protocols, this course prepares learners for a dynamic career in the airline industry. With an emphasis on communication, safety, and customer service, students will develop essential skills needed for success in the fast-paced environment of air travel. Upon completion, learners will gain a thorough understanding of cabin crew duties and industry expectations, ensuring they are well-equipped for both the recruitment process and on-the-job requirements. Course Description: This course delves into the essential aspects of being an air cabin crew member, from understanding different airline structures to mastering the regulations that govern air travel. It covers the practicalities of a cabin crew career, such as recruitment preparation, interview techniques, and training procedures. Learners will also explore the layout of commercial aircraft, crew resource management, emergency protocols, medical first aid, and personal grooming expectations. The course offers a detailed exploration of communication skills necessary for passenger interaction, alongside the critical knowledge of aviation-related terminology, weather conditions, and safety procedures. By the end of the course, learners will have the knowledge and confidence to pursue a career in aviation. Air Cabin Crew Online Diploma Course Curriculum: Module 01: Introduction to Aircraft Cabin Crew Module 02: Understanding Different Types of Airlines Module 03: Role of Regulatory Bodies and Trade Associations Module 04: Things to Know about a Cabin Crew Life Module 05: Advantages and Disadvantages of a Cabin Crew Career Module 06: Recruitment Preparation for Pursuing a Cabin Crew Career Module 07: Cabin Crew Interview Formats Module 08: Training Procedures Module 09: Aviation Abbreviation and Airport Codes Module 10: The Layout of a Commercial Aircraft Module 11: Cabin Familiarisation for a Cabin Crew Module 12: Departments of Airlines and their Interconnection with Cabin Crew Module 13: Knowledge of Currencies, 24 Hour Clock and Phonetic Alphabet Module 14: Basic Knowledge of Weather Regarding Aviation Module 15: Duties of a Cabin Crew Module 16: Communication with the Passenger Module 17: Aircraft Galley Module 18: Emergency Evacuation System Module 19: Tackling the Event of a Fire Module 20: Medical First Aid Module 21: Personal Grooming of Cabin Crew Module 22: Cabin Crew Fatigue Management Module 23: Crew Resource Management (See full curriculum) Who is this course for? Individuals seeking to pursue a career as cabin crew. Professionals aiming to develop their career in the aviation industry. Beginners with an interest in aviation or airline operations. Those aspiring to work in customer service within the air travel sector. Career Path: Cabin Crew Member Flight Attendant In-Flight Supervisor Airline Customer Service Representative Aviation Safety Coordinator

Duration 1 Days 6 CPD hours This course is intended for This course benefits cloud consumers and administrators of public cloud, private cloud, and hybrid cloud infrastructures: Security architects Cloud architects Network engineers and administrators System engineers and adminstrators Cloud security consumers Cloud application administrators IT managers Line of business managers Cisco integrators and partners Overview After taking this course, you should be able to: Describe public, private, and hybrid cloud models, concepts, and design Explain the concepts and components for securing cloud environments Describe Cisco security offerings for Amazon Web Services (AWS) Define methods to secure SaaS application usage The Introducing Cisco Cloud Consumer Security (SECICC) v1.0 course gives you a technical overview of basic concepts and components of the cloud, and the Cisco© solutions used to provide comprehensive security of your cloud-based environment. In this primarily lecture-based course, you?ll learn the basics from a cloud consumer perspective including securing cloud and Software as a Service (SaaS) application environments. This introductory course provides insights on using Cisco Stealthwatch? Cloud, Cisco CloudLock, Cisco Umbrella? and more to protect the user when using cloud-based applications. Introducing the Cloud Describe the Evolution of Cloud Computing Explain Cloud Service Models Explore Cloud Deployment Models Introducing Securing the Cloud Describe the Cisco Threat-Centric Approach to Network Security Describe Cloud Physical Environment Security Describe Cloud Network Infrastructure Security Explain Application Security Explore Cloud Management and API Security Describe Cisco Cloud-Based Security Solutions Describe Network Functions Virtualization (NFV), Virtual Network Function (VNF), and Secure Agile Exchange (SAE) Describe Cisco CloudCenter for MultiCloud Management Describe Cisco Stealthwatch Describing Cloud Security Solutions Using AWS Identify AWS Security Offerings Identify Cisco Security Solutions in AWS Introducing Security in an SaaS Environment Describe SaaS Applications Describe SaaS Security Challenges Explain Cloud Access Security Broker Describe Cisco CloudLock Describe OAuth and OAuth Attacks Describe Cisco Advanced Malware Protection for Endpoints Describe Cisco Cloud Email Security Describe Cisco Umbrella Lab outline Explore Cisco Stealthwatch Cloud Explore Stealthwatch Cloud Alerts Settings, Watchlists, and Sensors Explore Cisco Security Solutions in AWS Marketplace Explore the Cisco CloudLock Dashboard and User Security Explore Cisco CloudLock Application and Data Security Explore Cisco Advanced Malware Protection (AMP) Endpoints Explore the Cisco Umbrella Roaming Client Additional course details: Nexus Humans Cisco Introducing Cisco Cloud Consumer Security v1.0 (SECICC) 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 Cisco Introducing Cisco Cloud Consumer Security v1.0 (SECICC) 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.

Elevate your knowledge and skills in working at heights safely. Comply with regulations, implement risk assessments, and master the use of specialized equipment for fall protection. This course makes you adept at ensuring workplace safety in elevated environments.

5-in-1 Exclusive Microsoft Excel Bundle Course!!! Come and join in, on this exceptionally designed Microsoft Excel bundle course to transform yourself into an Excel wizard, regardless of your current skill level. With over 80% of jobs now requiring Excel skills in the UK, the ability to navigate and master this tool is more than just a resume booster-it's a necessity. From basics to advanced formulas, and even automated dashboards, this bundle is your golden ticket to unlocking the full potential of Excel, making data analysis and presentation not just easier, but a true delight. This comprehensive bundle starts by guiding you through Beginner, Intermediate, and Advanced levels of Excel. You'll then explore the Newest Functions and dive deep into 25 Must-know Formulas and Functions that are game-changers. But we don't stop there; you'll learn to create Automated Dashboards using Advanced Formulas, VBA, and Power Query, and even get a mastery tour of the entire Microsoft Office Suite, including Word, PowerPoint, and 365. It's a well-rounded education designed to make you proficient and efficient in handling any task Excel throws your way. The Microsoft Excel Course includes these 5 Premium Courses: Course 01: Microsoft Excel - Beginner, Intermediate & Advanced Course 02: New Functions in Microsoft Excel Course 03: Microsoft Excel - 25 Must-Know Formulas and Functions Course 04: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 05: Mastering Microsoft Office: Word, Excel, PowerPoint, and 365 Streamline your business processes, or just attempt to upskill for personal satisfaction, our Microsoft Excel Bundle Course is the leap forward you've been waiting for. In today's data-driven world, being Excel-savvy isn't just an asset; it's a must-have skill. Join us on this journey to becoming an Excel expert and open doors to endless career opportunities. Enrol now! Learning Outcomes of Microsoft Excel Course: Navigate Excel from basic operations to advanced functionalities confidently. Master new functions and 25 essential formulas in Excel. Design and implement automated dashboards with VBA and Power Query. Utilise the full suite of Microsoft Office for professional use. Analyse and present data effectively using Excel. Increase workplace productivity with advanced Excel skills. Why Choose Our Microsoft Excel Course? Get a Free CPD Accredited Certificate upon completion of Microsoft Excel course. Get a free student ID card with Microsoft Excel Training. Get instant access to this Microsoft Excel course. Learn Microsoft Excel from anywhere in the world. This Microsoft Excel course is affordable and simple to understand. The Microsoft Excel course is an entirely online, interactive lesson with voiceover audio. Lifetime access to the Microsoft Excel course materials. The Microsoft Excel course comes with 24/7 tutor support. Start your learning journey straight away! Course 01: Microsoft Excel - Beginner, Intermediate & Advanced Module 01: Excel From A-Z Course Introduction Module 02: Getting Started With Excel Module 03: Values, Referencing And Formulas Module 04: Intro To Excel Functions Module 05: Adjusting Excel Worksheets Module 06: Visually Pleasing Cell Formatting Module 07: How To Insert Images And Shapes! Module 08: Visualize Data With Charts Module 09: Excel's Printing Options Module 10: Benefits Of Using Excel Templates Module 11: Working With Excel Datasets Module 12: Excel Database Functions Module 13: Excel Data Validation Module 14: Excel PivotT ables Module 15: Excel's Power Pivot Add-In Module 16: Excel's Conditional Functions Module 17: Excel's Lookup Function Module 18: Text Based Functions In Excel Module 19: Auditing Formulas And Views In Excel Module 20: Excel's 'What If?' Tools Module 21: Welcome To Excel VBA Module 22: The VBA Language Module 23: Writing VBA Code Module 24: Important VBA Tools And Logic Module 25: Excel VBA Lopps Module 26: Triggering Macros Module 27: Excel User Forms Module 28: Starting A Career In Excel Course 02: New Functions in Microsoft Excel Module 01: Introduction and Agenda Module 02: RANDARRAY Module 03: UNIQUE Module 04: SEQUENCE Module 05: SORT and SORTBY Module 06: SORT A Practical Example Module 07: FILTER Module 08: FILTER A Practical Example Module 09: Other Useful New Functions Module 10: Using the New Functions in Reports Course 03: Microsoft Excel - 25 Must-Know Formulas and Functions Module 01: 25 Must-Know Formulas and Functions =========>>>>> And 2 More Courses <<<<<========= This course's curriculum has been designed by Microsoft Excel experts with years of Microsoft Excel experience behind them. The Microsoft Excel course is extremely dynamic and well-paced to help you understand Microsoft Excel with ease. You'll discover how to master the Microsoft Excel skill while exploring relevant and essential topics. How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*5 = £65) CPD 50 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 bundle. This bundle is ideal for: Job seekers Office professionals Data analysts Business owners Students Career improvers Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Data Analyst - £30,000 to £50,000 Financial Analyst - £35,000 to £60,000 Administrative Assistant - £20,000 to £30,000 Project Manager - £40,000 to £70,000 Business Analyst - £35,000 to £65,000 Accountant - £25,000 to £50,000 Certificates CPD Accredited Certificate Digital certificate - Included Upon passing the Bundle, you need to order to receive a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD. CPD Accredited Certificate Hard copy certificate - £29 Upon passing the Bundle, you need to order to receive a Hard copy Certificate for each of the courses inside this bundle. If you are an international student, then you have to pay an additional 10 GBP as an international delivery charge.

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

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