29875 Management courses

This course is about proactively working together with others in ways that will help you to communicate more efficiently as you engage with each other to bring value to your company and your customers. In addition, the skills, processes and tools taught in this course can bring value to other aspects of your life.

This course is a standalone course for anyone interested in understanding how work to more effectively with others as a leader. It compliments other courses that explore emotional intelligence in more depth. You'll receive all the information that you need and will be coached using loads of practical hints that you can use straight away.

The Sage 50 Payroll Complete Course is the perfect lesson if you have set your sights on a career within the accounting and finance industry but lack the knowledge and skills in the payroll department. Sage is a prevalent software system that is used around the globe, in businesses large and small. To keep up with modern technology and be employable to most companies, you need to know Sage 50 Payroll. This course will make you a valuable asset to any company. The course will cover areas such as processing SSP, editing tax codes, producing an annual cost of wages and using advanced payment options. The list goes on, but one thing remains the same: you’ll be kept up-to-date on the latest technologies and methods used within Sage 50 Payroll, giving you the confidence to use it self-assuredly.  What Will You Learn? Basics of setting up payroll Editing tax codes Managing bank statements and reconciliation VAT management Month-end reports Process statutory payments Create and administrate holiday schemes and employee absence Creation of chart of accounts, opening balances and rectifying mistakes What classes are included in this package? Earn a digital certificate upon successful completion acknowledged by UK and internationally acknowledged lesson There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you’ll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? This entry-level Sage Payroll Complete Course covers the basic concepts of payroll. Accountants of all levels, including those just starting, are urged to enrol in and complete this online course on Sage Payroll because there are no prerequisites. Career Path Training offered by the Sage 50 Payroll Complete Course could potentially benefit a range of roles but would particularly enhance careers in: Payroll Administrator HR Administrator Finance Manager Payroll Clerk HR Manager Assistant Accountant Financial Controller Course Contents Module 01: Payroll Basics Module 02: Company Settings Module 03: Legislation Settings Module 04: Pension Scheme Basics Module 05: Pay Elements Module 06: The Processing Date Module 07: Adding Existing Employees Module 08: Adding New Employees Module 09: Payroll Processing Basics Module 10: Entering Payments Module 11: Pre-Update Reports Module 12: Updating Records Module 13: e-Submissions Basics Module 14: Process Payroll (November) Module 15: Employee Records and Reports Module 16: Editing Employee Records Module 17: Process Payroll (December) Module 18: Resetting Payments Module 19: Quick SSP Module 20: An Employee Leaves Module 21: Final Payroll Run Module 22: Reports and Historical Data Module 23: Year-End Procedures

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Safeguarding and Counselling Course . You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Safeguarding and Counselling Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Safeguarding and Counselling Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Safeguarding and Counselling Course , like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Safeguarding and Counselling Course? 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 Safeguarding and Counselling Course 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Safeguarding and Counselling Course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Safeguarding and Counselling Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Safeguarding and Counselling Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Safeguarding and Counselling Course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Safeguarding and Counselling Course Module 01: Introduction to Safeguarding 00:21:00 Module 02: An Introduction to Safeguarding of Vulnerable Adults 00:30:00 Module 03: Laws and Guidance 00:43:00 Module 04: Safeguarding Legislations 00:30:00 Module 05: Understanding Abuse and Neglect 00:36:00 Module 06: Child Abuse 00:49:00 Module 07: Sexual Abuse 00:38:00 Module 08: Understanding the Importance of Communication in Care 00:30:00 Module 09: Sharing Information and Responding To a Disclosure 00:30:00 Module 10: Record Keeping 00:18:00 Module 11: Risks and Risk Assessment 00:16:00 What Causes Depression Introduction 00:05:00 Melancholy and the History of Counselling 00:07:00 Signs of Depression 00:07:00 Depression and the Brain 00:06:00 Depression and Neurons 00:09:00 Stress and depression 00:10:00 Environmental and Health Factors 00:04:00 Depression and Sleep Disorders 00:06:00 Somatic Symptoms 00:06:00 Risk Factors 00:07:00 Module 1: Assessment Questions 00:05:00 Different Types of Depression Classifying Depression & Different Classification Methods 00:07:00 Cyclothymia 00:06:00 Depression and Creative Minds 00:07:00 Dysthymia, Pre-Menstrual Dysphoric Disorder, and Atypical Depression 00:07:00 Bipolar / Manic Depression 00:06:00 Antenatal & Postpartum Depression 00:09:00 Bereavement and Grief 00:09:00 Dysthymia in Children and Adolescents 00:04:00 Depression and the Elderly 00:06:00 Psychosocial & Health Factors in the Elderly 00:03:00 Module 2: Assessment Questions 00:04:00 Different Types of Medicine Neurogenesis 00:04:00 Monoamine Oxidase Inhibitors 00:04:00 Serotonin Syndrome 00:03:00 Selective Serotonin Reuptake Inhibitors 00:03:00 Tyramine 00:03:00 Medication Statistics and Doctors in the UK & USA 00:10:00 Module 3: Assessment Questions 00:03:00 Complementary Alternative Therapies Lifestyle management, Diet, Exercise, Meditation 00:07:00 St John's Wort (hypericum perforatum) 00:05:00 Omega 3 Fatty Acids 00:04:00 Tai chi, Qigong 00:04:00 Yoga 00:04:00 Acupuncture 00:03:00 Art Therapy & Music Therapy 00:08:00 Module 4 Assessment Questions 00:04:00 Counselling Approaches to Depression Person Centred Therapy 00:07:00 Family or Couples Therapy 00:09:00 Stepped Care Model (approach) 00:10:00 Psychodynamic/Dynamic Interpersonal Therapy 00:06:00 Rational Emotive Behavioural Therapy 00:06:00 Clinical Hypnotherapy & Cognitive Behavioural Therapy 00:05:00 Clinical Hypnotherapy for Post Traumatic Stress Disorder 00:05:00 Gestalt Therapy 00:06:00 The Therapeutic Relationship 00:07:00 Knowledge and Qualities Necessary to a Counsellor 00:03:00 Module 5 assessment questions 00:03:00 Thank You and Good Bye! 00:03:00 Additional Study Materials Additional Study Materials: Online Depression Counselling Training 00:00:00 Assignment Assignment - Safeguarding and Counselling Course 00:00:00 Workbook - Safeguarding and Counselling Course Workbook - Safeguarding and Counselling Course 00:00:00

Overview Learn about Sales and Marketing Principles from industry experts and boost your professional skill. This Sales and Marketing Principles course will enhance your skill and make you ready for the job market. You'll get expert opinions about the best practices and problems of Sales and Marketing Principles. You'll also gain the skills of Sales and Marketing Principles to excel in your job and tips to master professional skills in no time.  You'll be connected with the community of Sales and Marketing Principles professionals and gain first-hand experience of Sales and Marketing Principles problem-solving. The Sales and Marketing Principles  is self-paced. You can complete your course and attend the examination in your suitable schedule. After completing the Sales and Marketing Principles, you'll be provided with a CPD accredited certificate which will boost your CV and help you get your dream job.  This Sales and Marketing Principles will provide you with the latest information and updates of Sales and Marketing Principles. It will keep you one step ahead of others and increase your chances of growth. Why buy this Sales and Marketing Principles? 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 Sales and Marketing Principles 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 Sales and Marketing Principles does not require you to have any prior qualifications or experience. You can just enrol and start learning.  Prerequisites This Sales and Marketing Principles was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Sales and Marketing Principles is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Sales Skills for Beginners Mindset Attitude 00:01:00 Values 00:03:00 Beliefs 00:02:00 How to Change Beliefs 00:04:00 Goals 00:06:00 Focus 00:02:00 The Extra Mile 00:03:00 Team Player 00:02:00 Accentuate the Positive 00:03:00 Be a Winner! 00:02:00 Organizational Skills Pre-call Research 00:02:00 Gaining Appointments 00:04:00 Pre-call Planning 00:04:00 Route Planning 00:04:00 Prioritizing your Time 00:02:00 Controlling the Controlable 00:03:00 Product Knowledge Know your Products 00:03:00 Features and Benefits 00:03:00 Customer Perception 00:02:00 Sales Calls Beginning Sales Calls 00:03:00 Listening & Question Listening Skills Part 1 00:07:00 Listening Skills Part 2 00:05:00 Uncovering Needs 00:05:00 Closing Sales Calls Closing a Sales Call 00:04:00 Following Up Post Call Analysis 00:05:00 Follow Up Actions 00:02:00 Onwards 00:01:00 Final Thoughts 00:01:00 Mastering Sales Techniques The Guaranteed Way to Improve Your Sales Technique The Number One Universal Killer Question in Selling 00:03:00 The Importance of Establishing the Clients Expectations 00:02:00 How to Close the Sale Without Sounding like a Salesman 00:04:00 Why People Buy and How to Get Them to Buy from Us People Buy Emotionally and Justify Logically. What to Do About It 00:04:00 Don't Assume You Know the Buyer's Priorities 00:05:00 How to Unearth the Buyer's Strategic Needs 00:03:00 The Importance of Implications 00:04:00 Why People Don't Buy and How to Counteract Any Objection Being Prepared for Objections 00:04:00 The Most Common Objections and How to Handle Them 00:04:00 How to Get People to Choose What You Want Them To 00:04:00 What Buyers Say and What They Really Mean 00:03:00 Holding a High Price What Does Value For Money Really Mean? 00:03:00 Five Proven Techniques to Save Money and Make Money 00:04:00 The Words: 'Typically', 'Realistically', 'Currently', 'Given' and 'Yet' 00:02:00 Justifying Your Price - the Power of One 00:04:00 The Final 'Killer Questions' That Allow You to Negotiate More Successfully 00:04:00 Win-Win and Increasing Average Order Value The Real Meaning of 'Win-Win' 00:04:00 The Rules for Discounting 00:03:00 How to Hold a High Price 00:04:00 How to Increase Average Order 00:03:00 The Compromise Effect 00:03:00 Sales Techniques You Need to Know All You Need to Know About Time Management 00:03:00 Recognising the Moment That Matters and the Role of 'Enough' 00:06:00 What to Do When It Starts Going Wrong 00:05:00 How to Understand Other People - Can You Clarify? 00:04:00 How to Build Your Reputation and Getting Your Client to Feel Indebted to You 00:04:00 Selling in the Long Term and Being Recommended 00:04:00

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is as follows: Phone Network Administrators Phone Network Engineers Data System Administrators Entry-level Network Engineers Channel Partners/Resellers, Customers, Employees Overview Describe the Cisco Unified Communications Manager network, service, and features Understand the importance of and configuration of redundancy and high availability in the enterprise network Describe user configuration and the user web interface Explain basic phone options and the use of BAT Explain the route plan and on-net/off-net calling Describe the various media resources, including conferencing and MOH Describe the basic phone features and use of hunt groups Administering Cisco Unified Communications Manager (ACUCM) v12.0 is a 3-day training program that provides system administrators and networking professionals with an understanding of the Cisco Unified Communications Manager System. The Cisco IT training course teaches the concepts of IP telephony based in system administration, including its function, features, and configuration. This is an entry-level IP telephony course that begins with the basic concepts of IP telephony and very quickly moves the learner forward into an understanding of system concepts: clustering, creation of phones and users, route plans, digit manipulation, media resources, and phone features, which are all important to supporting IP telephony in the enterprise network. The course focuses on Cisco Unified Communications Manager version v12.x.The course is geared to individuals that will be using and managing the system and performing administration for Level 1 and Level 2 support. Level 1 support is geared toward supporting phone users and making moves, adds, and changes to the desktop phone environment. Level 2 support is oriented to supporting changes in the organization, such as opening new office locations or relocating departments. The Cisco training course does not cover issues of initial deployment, new cluster deployment or international deployments. Also, the course does not cover issues with the underlying network that involves routers, switches, or Cisco IOS software configuration. Exploring IP Telephone Traditional Voice versus IP Telephony Clustering Overview Intracluster Communications Cisco Unified Communications Manager Clusters Clustering Options Platform Requirements Describing Deployment Models Single-Site Deployment Centralized Call-Processing Deployment Distributed Call-Processing Deployment Distributed Single-Cluster Call-Processing Deployment Hybrid Call-Processing Deployment New Advanced Multicluster Options Understanding Advanced Multisite Features Need for CAC Deploying AAR Survivable Remote Site Telephony SRST Failover Logging in to Cisco Unified Communications Manager Logging In to Cisco Unified CM Administration and Cisco Unified Serviceability Logging In to Cisco Unified Operating System Administration and the DRS Navigation Menu Command-Line Interface Examining Basic Server Configuration Server Configuration?Eliminating DNS Reliance Configuring Enterprise Parameters Describing Multilevel Administration Configuring Multilevel Administration Creating End Users Creating Roles Creating User Groups Assigning Users to User Groups Configuring DRS Backup and Restore Procedures DRS Backup Procedures DRS Restore Procedures Understanding User Configuration Understanding User Management Configuring Users Using the User Web Pages Understanding the User Web Pages Using the User Web Pages Configuring System Parameter Cisco Unified CM Configuration Cisco Unified Communications Manager Group Configuration Phone NTP Configuration Date/Time Group Codecs and Regions Location Configuration Device Pool Configuration DHCP Service Configuration Device Defaults Configuration Clusterwide Parameters Licensing Supporting Cisco Unified IP Phones Cisco Unified IP Phones Overview Specialized Cisco Unified IP 7900 Series Phones Phone Button Templates Softkey Templates Exploring Phone Registration and IP Phone Communications Cisco Unified IP Phone Registration Cisco Unified IP Phone Configuration Utilizing the Bulk Administration Tool (BAT) Overview of Cisco Unified Communications Manager BAT Cisco Unified Communications Manager TAPS Implementing Dial Plan Connectivity Organizational Dial Plan Trunks Gateways Creating Route Plans Dial Plan Overview Route Pattern Overview Digit Collection Call Routing Configuring Transition Patterns and Route Filters Translation Patterns The 9.@ Pattern Route Filters Implementing Digit Manipulation Discard Digits Instruction Transformation Masks Route Plan Report Defining Class of Control Overview of Class of Control Partitions CSS Configuration PLAR Application Using Class of Control Features Call Restriction Time of Day Routing Traditional vs. Line/Device Approach Defining Media Resources Overview of Media Resources Conference Bridge Media Termination Points Transcoder Music on Hold Annunciator Exploring Media Resource Management MRG Management Configuring MRGs Configuring MRGLs Describing Basic Features Call Park Call Pickup Cisco Call Back Shared Lines with Barge and Privacy Exploring Hunt Groups Hunt Group Overview Line Group Configuration Hunt List Configuration Hunt Pilot Configuration Final Forwarding Describing Phone Services Cisco IP Phone Services Cisco Phone Services Configuration

Course Overview Learn the Latest Skills | Accredited by CPD | Recognised Certificate | MCQ Based Exam & Tutor Support | Interactive Video Training  Advanced Cyber Security Course is one of our best selling and most popular course. This course gives you the background needed to understand basic cyber security and risk management. This program will provide you with the knowledge and abilities necessary to defend networks, create secure infrastructures, safeguard electronic assets, prevent cyberattacks, and protect your own privacy. The Advanced Cyber Security Course is organised into 3 modules and includes everything you need to become successful in this profession. What Will You Learn? Discover security vulnerabilities across an entire network by using network hacking techniques and vulnerability scanning Understand how we are tracked online by corporations, nation-states, your ISP and others Perform network monitoring to discover and identify potential hackers and malware You will learn how networking affects security systems within an organization What classes are included in this package? Earn a digital Certificate upon successful completion accredited by UK and internationally recognised accredited qualification There are no set schedules, so you can work at your own pace. Our email and live chat specialists are available to assist you 24 hours a day, 7 days a week. On weekdays, you'll have access to a full-time tutor. Learn in a user-friendly, cutting-edge online learning environment. High-quality e-learning study materials Lifetime Access Benefit from instant feedback through mock exams and multiple-choice assessments Who Should Take This Course? The Advanced Cyber Security Course course is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all students from any academic background to learn more about this subject. The Diploma in Professional Chef course is suitable for anyone who wants to gain extensive knowledge, potential experience and professional skills in the related field. This is a great opportunity for all students from any academic background to learn more about this subject. Career Path Training offered by the Advanced Cyber Security Course could potentially benefit a range of roles but would particularly enhance careers in: Software Developer Network Administrator Cybersecurity Engineer Malware Analyst Computer Forensics Analyst Security Architect 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 assessments 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 £119. Please note that overseas students may be charged an additional £10 for postage. Certificate of Achievements 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. 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 £119. Please note that overseas students may be charged an additional £10 for postage. 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 On successful completion of the Advanced Cyber Security Course, you will be required to sit an online multiple-choice assessment. 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 Quality Licence Scheme endorsed certificate of achievement. The assessment will be evaluated automatically, and the results will be given to you immediately.

Overview With the ever-increasing demand for Sales in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Sales may be. Learning about Sales or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Sales . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Sales is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Sales course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Sales course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Sales course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Sales , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Sales , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Sales , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Sales course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams.    Course Curriculum Chapter 1 Overview of Pricing Overview of Pricing 00:00 Chapter 2 Times Are Changing Times Are Changing 00:00 Chapter 3 Overview of Added Value Overview of Added Value 00:00 Chapter 4 Testimonials Testimonials 00: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

Certification After successfully completing the course, you will be able to get the UK and internationally accepted certificate to share your achievement with potential employers or include it in your CV. The PDF Certificate + Transcript is available at £6.99 (Special Offer - 50% OFF). In addition, you can get a hard copy of your certificate for £12 (Shipping cost inside the UK is free, and outside the UK is £9.99).