25814 Management courses in Huntingdon delivered Online

Overview Deliver a Presentation with Confidence Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Deliver a Presentation with Confidence Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Welcome To Create Course Promo 00:16:00 Introduction And Welcome To The Course 00:17:00 Start With A Killer Opener Get Them To Trust You 00:18:00 Get Them To Believe You 00:14:00 Get Them To Listen To You 00:09:00 Killer Opener Summary And Q&A 00:05:00 Command With Your Body Introduction 00:04:00 Take A Strong Stance 00:06:00 Move Purposefully 00:10:00 Master Eye Contact 00:06:00 Activity 00:10:00 Convince With Your Voice Introduction To Convince With Your Voice 00:04:00 Choose Your Words Wisely 00:28:00 Find Your Optimal Pace, Volume, Inflections And Tone 00:22:00 Convince With Your Voice Summary And Next Steps 00:03:00 Overcome Your Presentation Fears Introduction To Overcome Your Presentation Fears 00:08:00 Minimize The Chance Of A Misstep 00:18:00 Channel Your Strengths And Not Your Vulnerabilities 00:20:00 Focus On Your Audience's Needs And Not Your Own 00:19:00 Appear Confident And Credible Introduction To Appear Confident And Credible 00:09:00 Use Confident Language 00:20:00 Speak With A Confident Voice 00:02:00 Show Confident Body Language And Facial Expressions 00:08:00 Big Picture And Q&A 00:08:00 Downloadable Materials Resource - Deliver A Presentation With Confidence 00:00:00

Overview Communications & Public Speaking for Beginners Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Communications & Public Speaking for Beginners Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Section 01: Communications Mastery Quick, Ethical Ways to Cheat Your Way to Communication Success 00:03:00 You Are In Great Company - Find Out Who 00:02:00 GPS for Your Communications 00:02:00 You Will Be Motivating, Not Data Dumping 00:04:00 Exciting New Update to this Course 00:01:00 Getting Feedback So It Won't Hurt 00:03:00 Yes, Even Beginner CAN Tell Stories 00:04:00 Powering Your Points with Images and Slides 00:04:00 Practice in the Friendliest Environment of All 00:04:00 Test Tubes for You 00:03:00 You Have Earned a Professional Critique 00:02:00 Time to Give TJ a Piece of Your Mind 00:01:00 You have Now Mastered Basic and Beyond Communication Skills 00:09:00 Extra-Tips on How to Get Over Nervousness and Being Scared 00:09:00 Section 02: Public Speaking Mastery Intro - Public Speaking for Beginners 00:02:00 These Simple Secrets Will Make You Look Like a Public Speaking Veteran 00:03:00 You Will Never Have to Be Scared, Even Though Everybody Else Is 00:01:00 This Is How You Get Your Audience to Do What You Want 00:01:00 Unlock the Keys to Motivating Your Audience 00:04:00 Getting Feedback the Right Way to Make You Stronger 00:03:00 Mastering the Easiest Public Speaking Technique of All 00:04:00 Your Picture Will Be Worth More the a 1000 Words 00:02:00 Only Perfect Practice Makes Perfect 00:03:00 You Can Pass the Ultimate Test 00:02:00 You Have Earned a Personalize Coaching Session Now 00:01:00 Conclusion - You Are No Longer a Public Speaking Beginner 00:02:00 Section 03: Presentation Mastery Intro - Presentation Skills for Beginners 00:01:00 4 Quick Tips to Improve Your Presentation Skills In the Next Five Minutes 00:04:00 You Now Know the Dirty Little Secret of Presentation Skills 00:03:00 Never Waste Time Starting a Presentation Again 00:02:00 You Can Get the Audience to Do What You Want 00:04:00 Never Be Convicted of Death by PowerPoint 00:03:00 The Easy Way to Tell Relevant Stories 00:06:00 Your Own Free Focus Group 00:03:00 The Most Efficient Way to Practice You Presentation Skills 00:02:00 Passing the Ultimate Test 00:03:00 Now You Have Earned Personal Coaching 00:02:00 Conclusion- You Are No Longer a Beginner at Presentation Skills 00:01:00 Section 04: Create Incredible and Inexpensive Talking Head Videos The Video Advantage in All Your Proposals - Quick Win! 00:02:00 Hype versus Reality - Why Most People Never Create Simple Video 00:04:00 Mastering the Human Side Of Looking and Sounding Your Best on Video 00:10:00 How This Course Will Improve Your Business 00:02:00 Your Proposals will Stand Head and Shoulders above Your Competitors 00:06:00 Your Clients Will Find You Their Most Responsive Partner Ever 00:02:00 Your Website Can Be Video-Centric 00:02:00 Now You Can Answer Frequently Asked Questions Just Once! 00:02:00 Talk Your Customers through Your Whole Business Process 00:03:00 Have an Even Greater Presence on YouTube 00:04:00 Speak Your Thought Leadership 00:02:00 Your Exciting Video Newsletters Will Outshine Text Newsletters 00:02:00 Your Client Video Testimonials Will Prove Your Credibility Beyond a Doubt 00:03:00 Facebook Live Will Never Scare You Again 00:04:00 Project Your Best Face on Skype and Zoom 00:02:00 Deliver Keynote Speeches without Ever Leaving Home 00:04:00 Supercharge Your Public Relations Efforts with Video 00:02:00 The Crisis Communications Secret Weapon 00:02:00 Drastically Reduce Your Time Training Employees and Others 00:02:00 Anything You Can Type You Can Now Speak on Video 00:01:00 Conclusion - You are Now Ready to Use Video Successfully in All Communications 00:02:00

Overview 10 Killer Negotiating Killer Tools and Techniques Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this 10 Killer Negotiating Killer Tools and Techniques Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training After you have successfully completed your assignment, you will be qualified to apply for a CPD Certification from The Teachers Training. The PDF certificate can be downloaded after you have completed your course. Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. 10 Killer Negotiating Killer Tools and Techniques Module 01: Introduction to Killer Negotiating Tools 00:03:00 Module 02: Always Let the Other Person Go First 00:02:00 Module 03: Both Parties Feel Some Pain in a Good Negotiation 00:02:00 Module 04: Put It in the Parking Lot 00:02:00 Module 05: Leave Your Ego at the Door 00:04:00 Module 06: Don't Negotiate With Yourself 00:02:00 Module 07: Know Your Deal Killers 00:04:00 Module 08: Put the Deal on Your Paper 00:02:00 Module 09: Escalate To God 00:03:00 Module 10: Be Careful Of Deal Fatigue 00:03:00 Module 11: Know Thy Opponent 00:04:00

24 Hours Left! Don't Let Year-End Deals Slip Away - Enrol Now! This Advanced Diploma in Business Marketing at QLS Level 7 course is endorsed by The Quality Licence Scheme and accredited by CPDQS (with 180 CPD points) to make your skill development & career progression more accessible than ever! Are you looking to improve your current abilities or make a career move? If yes, our unique Business Marketing at QLS Level 7 course might help you get there! It is an expertly designed course which ensures you learn everything about the topic thoroughly. Expand your expertise with high-quality training from the Business Marketing at QLS Level 7 course. Due to Business Marketing at QLS Level 7's massive demand in the competitive market, you can use our comprehensive course as a weapon to strengthen your knowledge and boost your career development. Learn Business Marketing at QLS Level 7 from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career. The Business Marketing at QLS Level 7 course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the Business Marketing at QLS Level 7 course, an instant e-certificate will be exhibited in your profile that you can order as proof of your skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. This training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join us today and gear up for excellence! Why Prefer This Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme & another accredited by CPDQS which is completely free. Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. Take a step toward a brighter future! *** Course Curriculum *** Module 01: Basics Module 02: Process Module 03: Strategic Marketing Module 04: Marketing Environment Module 05: Market Segmentations Module 06: Consumer Buying Behaviour Module 07: Business Markets and Buying Behaviour Module 08: Marketing Research Module 09: Product Strategy Module 10: Branding Strategy Module 11: Product Life Cycle Module 12: Pricing Strategy Module 13: Marketing Channels Module 14: Integrated Marketing Communications Module 15: Advertising and Sales Promotion Module 16: Personal Selling and Public Relations Module 17: Direct and Digital Marketing Assessment Process After completing an online module, you will be given immediate access to a specially designed MCQ test. The results will be immediately analysed, and the score will be shown for your review. The passing score for each test will be set at 60%. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme after you have completed all of the exams. CPD 180 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is perfect for highly motivated people who want to improve their technical skills and prepare for the career they want! Requirements No prior background or expertise is required. Career path The course will boost your CV and aims to help you get the job or even the long-awaited promotion of your dreams. Certificates Advanced Diploma in Business Marketing at QLS Level 7 Hard copy certificate - Included Show off Your New Skills with a Certificate of Completion After successfully completing the Advanced Diploma in Business Marketing at QLS Level 7, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme andalso you can order CPDQSAccredited Certificate that is recognised all over the UK and also internationally. The certificates will be home-delivered, completely free of cost. CPDQS Accredited Certificate Digital certificate - Included

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

Whether the Highfield Customer Service e-learning course is used as part of the training for a level 2 customer service qualification or as a stand-alone training course for staff and managers, learners will understand what is meant by, and how to deliver, good customer service in your organisation. From the basic principles of customer service to understanding and anticipating customers’ wants and needs, the course breaks information into engaging and interactive chunks. Areas covered Customer service principles Customers’ needs and expectations Behaviour and interpersonal skills Responding to problems or complaints Who is it aimed at? The course is useful for staff, managers, and apprentices working within any business

Master essential skills of the fundamentals of marketing to fast track your career in this evolving industry with the Marketing Fundamentals Level 2 course. In this course, you will explore the marketing cycle, various marketing strategies and the elements of a successful marketing campaign. Advertising is a crucial aspect of marketing, and you will gain a thorough insight into the process involved in pushing a product or service out to the public. Throughout this course, you will learn practical exercises and explore case studies that will help you to gain valuable sales skills and understand how consumers think.  Kickstart your career today and gain the knowledge to stand out in this competitive field! Learning Objectives Gain an understanding of the basic principles of strategic marketing Understand the main steps in the marketing process, from the marketing mix to data analysis Learn about the different types of marketing environments, their internal and external factors Have a comprehensive knowledge of consumer buying behaviour and trends Familiarise with the major types of business markets and their characteristics Explore your job opportunities in marketing, career growth, and the core skills required for this industry Broaden your understanding of marketing research, with expert methods and strategies Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the course. Good understanding of English language, numeracy and ICT are required to attend this course. Certificate of Completion 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 £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Course Curriculum Module 01: Basics of Marketing Basics of Marketing 00:30:00 Assessment Module 01 Module 01 Final Quiz Exam - Marketing Fundamentals 00:10:00 Module 02: The Marketing Process The Marketing Process 00:40:00 Assessment Module 02 Module 02 Final Quiz Exam - Marketing Fundamentals 00:10:00 Module 03: Strategic Marketing Strategic Marketing 01:00:00 Assessment Module 03 Module 03 Final Quiz Exam - Marketing Fundamentals 00:10:00 Module 04: Marketing Environment Marketing Environment 00:20:00 Assessment Module 04 Module 04 Final Quiz Exam - Marketing Fundamentals 00:10:00 Module 05: Market Segmentations Market Segmentations 00:40:00 Assessment Module 05 Module 05 Final Quiz Exam - Marketing Fundamentals 00:10:00 Module 06: Consumer Buying Behaviour Consumer Buying Behaviour 01:00:00 Assessment Module 06 Module 06 Final Quiz Exam - Marketing Fundamentals 00:10:00 Module 07: Business Markets and Buying Behaviour Business Markets and Buying Behaviour 00:40:00 Assessment Module 07 Module 07 Final Quiz Exam - Marketing Fundamentals 00:10:00 Order Your Certificate

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 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

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