3688 Relationships courses in Garforth delivered Online

Embarking on the 'Recruitment Consultant Diploma' journey unveils the dynamic world of talent acquisition. This course seamlessly integrates the basics, like introducing the realm of recruitment consulting, with more advanced facets, such as executive search and global talent sourcing. Delve deep into candidate evaluations, cultivate robust relationships with both candidates and clients, and harness the latest technology to streamline your recruitment processes. With emphasis on legal and ethical concerns, and strategies underpinning success, this programme ensures you're primed to navigate the ever-evolving recruitment landscape. Learning Outcomes Understand the fundamentals of recruitment consulting and the role of a consultant. Analyse and implement recruitment processes, strategies, and best practices. Assess candidates effectively and understand the nuances of client-candidate relationship management. Utilise technology to its fullest in enhancing recruitment processes. Comprehend the importance of legal, ethical considerations, and international recruitment dynamics. Why buy this Recruitment Consultant Diploma? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Recruitment Consultant Diploma for? Aspiring individuals keen to break into the recruitment sector. HR professionals looking to expand their expertise in talent acquisition. Entrepreneurs aiming to set up their own recruitment agencies. Managers wanting to refine their talent sourcing and selection methods. Global companies seeking to better understand international recruitment nuances. Career path Recruitment Consultant: £22,000 - £30,000 Talent Acquisition Specialist: £28,000 - £40,000 HR Manager with recruitment focus: £35,000 - £50,000 Executive Search Consultant: £40,000 - £60,000 International Recruitment Manager: £45,000 - £65,000 Headhunter: £35,000 - £55,000 Prerequisites This Recruitment Consultant Diploma Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Recruitment Consulting Introduction to Recruitment Consulting 00:18:00 Module 02: Recruitment Process and Strategies Recruitment Process and Strategies 00:20:00 Module 03: Candidate Assessment and Selection Candidate Assessment and Selection 00:21:00 Module 04: Building Client and Candidate Relationships Building Client and Candidate Relationships 00:18:00 Module 05: Recruitment Strategies and Best Practices Recruitment Strategies and Best Practices 00:19:00 Module 06: Leveraging Technology in Recruitment Leveraging Technology in Recruitment 00:21:00 Module 07: Legal and Ethical Considerations in Recruitment Legal and Ethical Considerations in Recruitment 00:17:00 Module 08: Executive Search and Headhunting Executive Search and Headhunting 00:19:00 Module 09: International Recruitment and Global Talent Acquisition International Recruitment and Global Talent Acquisition 00:18:00

Loneliness can creep in quietly—whether you’re surrounded by people or sitting in silence. This course is designed to help you recognise the subtle signs of emotional isolation and guide you towards building meaningful human connections. With thoughtful lessons and insightful content, we’ll walk you through the psychological and social roots of loneliness, and show you how small, genuine shifts in mindset and communication can make all the difference. Ideal for anyone feeling disconnected, this course offers you an engaging space to reflect, reassess and reconnect. From understanding the science behind social connection to addressing personal barriers that keep people emotionally distant, every section is built to be relatable and uplifting. Whether you're feeling isolated due to life changes, remote working, or social anxiety, this course offers strategies that speak to your everyday reality. Let’s face it—you’re not alone in feeling alone. And thankfully, change doesn’t require a stage, spotlight or pep talk—just a moment of honesty and the willingness to learn. Learning outcomes: Understand the causes and effects of loneliness Learn techniques to build meaningful relationships Develop strategies to improve social skills Discover tools to overcome feelings of loneliness Enhance your mental and physical health Our Overcoming Loneliness course is designed to provide you with the tools and strategies needed to navigate the complex emotions of loneliness. Through this course, you'll learn about the causes and effects of loneliness, as well as the impact it can have on your mental and physical health. Our expert instructors will guide you through a variety of techniques to help you build meaningful relationships, improve your social skills, and overcome feelings of loneliness. By the end of this course, you'll be on your way to a more fulfilling and connected life. Overcoming Loneliness Course Curriculum Introduction Flow of the course Attachment styles Characteristics of attachment Identifying the obstacle Know your strengths Writing the story Identifying the challenges Attachment style of family members Additional activity Finding your satisfaction Why do I feel desperation I don't really need Person Healing your injuries Experiencing vs addicting Experience Useful meditation Additional activities Understanding your goal Happiness and Sadness I am smart Finding your satisfaction Healing Naming my social fears Social Prioritizing Cultivating Forgiving your Approaching insecurities Meditation for self Sleeping well Music Locating Beauty Applying the foundation What are your social If you get Meeting people Emotional Openness Becoming free Ten Minutes How is the course assessed? Upon completing an online module, you will immediately be given access to a specifically crafted MCQ test. For each test, the pass mark will be set to 60%. Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of __ GBP. £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone who experiences feelings of loneliness Individuals who want to improve their social skills People who want to learn how to build meaningful relationships Individuals who want to enhance their mental and physical health Professionals who work in mental health or social work fields Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Social Worker Counsellor Mental Health Professional Community Outreach Worker The salary range for these roles in the UK ranges from £20,000 to £50,000 per year. However, the salary range can vary depending on the industry and level of experience. Certificates Certificate of completion Digital certificate - £9 You can apply for a CPD Accredited PDF Certificate at the cost of £9. Certificate of completion Hard copy certificate - £15 Hard copy can be sent to you via post at the expense of £15.

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

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

Getting Started The primary aim of the OTHM Level 3 Diploma in Business Management is to offer learners a comprehensive grasp of how businesses operate and are organised. This qualification is designed to equip learners with the foundational knowledge, comprehension, and skills relevant to various aspects of business operations. It encourages learners to research, explore, and assess key business elements, encompassing areas like Business Communication, The Business Environment, People Management, Customer Service, Finance, and Marketing. Key Benefits Gain a thorough comprehension of business operations and organisational structure Equips learners with essential knowledge, comprehension, and practical skills required in various aspects of business activities Encourages learners to conduct research and explore critical elements of the business field, Apply the knowledge and skills gained to real-world business situations Develop effective written and oral communication skills essential for successful business interactions. Key Highlights This qualification will offer learners the requisite skills and knowledge to enter the world of work in their chosen sector We will ensure your access to the first-class education needed to achieve your goals and dreams and to maximise future opportunities. Remember! The Assessment for the qualification is done based on assignments only, and you do not need to worry about writing any exam With the School of Business and Technology London, you can complete the qualification at your own pace, choosing online or blended learning from the comfort of your home. Learning and pathway materials and study guides developed by our qualified tutors will be available around the clock in our cutting-edge learning management system. Most importantly, at the School of Business and Technology London, we will provide comprehensive tutor support through our dedicated support desk. If you choose your course with blended learning, you will also enjoy live sessions with an assigned tutor, which you can book at your convenience. About Awarding Body OTHM is an established and recognised Awarding Organisation (Certification Body) launched in 2003. OTHM has already made a mark in the UK and global online education scenario by creating and maintaining a user-friendly and skill based learning environment. OTHM has both local and international recognition which aids OTHM graduates to enhance their employability skills as well as allowing them to join degree and/or Master top-up programmes. OTHM qualifications has assembled a reputation for maintaining significant skills in a wide range of job roles and industries which comprises Business Studies, Leadership, Tourism and Hospitality Management, Health and Social Care, Information Technology, Accounting and Finance, Logistics and Supply Chain Management. Entry Requirements Learners must be 18 years of demonstrate the ability to undertake the learning and Assessment A learner not from a majority English-speaking country must provide evidence of English language competency. Progression OTHM Level 4 diplomas Direct entry into a range of Bachelor's degree programmes Learners must request before enrolment to interchange unit(s) other than the preselected units shown in the SBTL website because we need to make sure the availability of learning materials for the requested unit(s). SBTL will reject an application if the learning materials for the requested interchange unit(s) are unavailable. Learners are not allowed to make any request to interchange unit(s) once enrolment is complete. UNIT1- Communication for Business Reference No : F/618/8192 Credit : 20 || TQT : 200 The primary objective of this unit is to impart learners with essential and critical skills needed for effective communication within a business setting. Learners will cultivate an understanding of various communication forms, including non-verbal, verbal, written, and IT. This knowledge will empower learners to proficiently convey messages by choosing the most appropriate communication method based on the message's specific context and content. UNIT2- The Business Environment Reference No : J/618/8193 Credit : 20 || TQT : 200 The primary goal of this unit is to equip learners with a comprehension of the idea of a business environment. Learners will foster an awareness of diverse business sectors, structures, and functions. Furthermore, learners will acquire insights into a business's inner and outer surroundings, where both micro and macroeconomic factors wield substantial influence over business operations. This knowledge will empower learners to evaluate a business's internal and external contexts proficiently. UNIT3- People Management Reference No : L/618/8194 Credit : 20 || TQT : 200 The primary objective of this unit is to furnish learners with the essential knowledge and insights required for proficiently guiding and supervising individuals within a business. Learners will cultivate an understanding of employee motivation, employee relationships, and performance management. This knowledge will enable learners to grasp the prerequisites for leaders and managers to facilitate and promote effective employee engagement. UNIT4- Customer Service Reference No : R/618/8195 Credit : 20 || TQT : 200 The primary goal of this unit is to equip learners with the essential knowledge and comprehension needed for effective performance in a customer service position. Learners will first establish a foundation in customer service basics, then explore customer types and strategies for fostering relationships with them within a business context. Building upon an understanding of various interpersonal skills, this unit will allow learners to showcase their ability to work independently and collaboratively in a team to deliver exceptional customer experiences. UNIT5- Finance in Business Reference No : Y/618/8196 Credit : 20 || TQT : 200 The primary objective of this unit is to impart learners with the foundational knowledge necessary for documenting financial transactions and generating financial statements. Learners will acquire an understanding of various economic and accounting methods, including the double-entry accounting system, budgeting, and investment assessment. This knowledge will empower learners to document financial transactions and create accounting statements proficiently. UNIT6- Marketing Reference No : D/618/8197 Credit : 20 || TQT : 200 The primary goal of this unit is to equip learners with the essential marketing knowledge and skills necessary to participate in marketing endeavours actively. This is complemented by understanding critical marketing and campaign principles, which are the basis for generating and delivering market research findings and a marketing campaign. Delivery Methods School of Business & Technology London provides various flexible delivery methods to its learners, including online learning and blended learning. Thus, learners can choose the mode of study as per their choice and convenience. The program is self-paced and accomplished through our cutting-edge Learning Management System. Learners can interact with tutors by messaging through the SBTL Support Desk Portal System to discuss the course materials, get guidance and assistance and request assessment feedbacks on assignments. We at SBTL offer outstanding support and infrastructure for both online and blended learning. We indeed pursue an innovative learning approach where traditional regular classroom-based learning is replaced by web-based learning and incredibly high support level. Learners enrolled at SBTL are allocated a dedicated tutor, whether online or blended learning, who provide learners with comprehensive guidance and support from start to finish. The significant difference between blended learning and online learning methods at SBTL is the Block Delivery of Online Live Sessions. Learners enrolled at SBTL on blended learning are offered a block delivery of online live sessions, which can be booked in advance on their convenience at additional cost. These live sessions are relevant to the learners' program of study and aim to enhance the student's comprehension of research, methodology and other essential study skills. We try to make these live sessions as communicating as possible by providing interactive activities and presentations. Resources and Support School of Business & Technology London is dedicated to offering excellent support on every step of your learning journey. School of Business & Technology London occupies a centralised tutor support desk portal. Our support team liaises with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receives a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and streamline all the support processes efficiently. Quality learning materials made by industry experts is a significant competitive edge of the School of Business & Technology London. Quality learning materials comprised of structured lecture notes, study guides, practical applications which includes real-world examples, and case studies that will enable you to apply your knowledge. Learning materials are provided in one of the three formats, such as PDF, PowerPoint, or Interactive Text Content on the learning portal. How does the Online Learning work at SBTL? We at SBTL follow a unique approach which differentiates us from other institutions. Indeed, we have taken distance education to a new phase where the support level is incredibly high.Now a days, convenience, flexibility and user-friendliness outweigh demands. Today, the transition from traditional classroom-based learning to online platforms is a significant result of these specifications. In this context, a crucial role played by online learning by leveraging the opportunities for convenience and easier access. It benefits the people who want to enhance their career, life and education in parallel streams. SBTL's simplified online learning facilitates an individual to progress towards the accomplishment of higher career growth without stress and dilemmas. How will you study online? With the School of Business & Technology London, you can study wherever you are. You finish your program with the utmost flexibility. You will be provided with comprehensive tutor support online through SBTL Support Desk portal. How will I get tutor support online? School of Business & Technology London occupies a centralised tutor support desk portal, through which our support team liaise with both tutors and learners to provide guidance, assessment feedback, and any other study support adequately and promptly. Once a learner raises a support request through the support desk portal (Be it for guidance, assessment feedback or any additional assistance), one of the support team members assign the relevant to request to an allocated tutor. As soon as the support receive a response from the allocated tutor, it will be made available to the learner in the portal. The support desk system is in place to assist the learners adequately and to streamline all the support process efficiently. Learners should expect to receive a response on queries like guidance and assistance within 1 - 2 working days. However, if the support request is for assessment feedback, learners will receive the reply with feedback as per the time frame outlined in the Assessment Feedback Policy.

Description I have studied Eastern Philosophy and religious traditions my entire adult life and have found them to be very useful and applicable in the modern world. For literally hundreds of thousands of years, human beings have been confronted with the problems of survival, raising children, developing relationships, and overcoming endless obstacles on a daily basis. The greatest thinkers of the past have much to teach us about how to deal with these problems psychologically and emotionally. In many cases, they have given us very specific examples and teach us how to apply these strategies to our everyday lives. Eastern Philosophy can help you: 1. Reduce stress 2. Reduce worry 3. Live a more fulfilled life 4. Be happier 5. Accomplish your goals more easily 6. Overcome life's challenges more easily 7. Improve your relationships 8. The list goes on... In this course we will cover all of the above and look at how you can apply the teachings of some of the greatest minds in history to your everyday life. See you in the course! What Will I Learn? Apply the teachings of Eastern Philosophy to their life in order to live with more purpose, meaning, and joy. Who is the target audience? Anyone looking to deepen their understanding of philosophy and spirituality in order to improve their life Requirements An interest in philosophy and spirituality Introduction Introduction to Eastern Philosophy 00:12:00 The Philosophy of Yoga The Ancient Art of Yoga 00:07:00 The Yoga of Patanjali 00:07:00 The Teachings of Patanjali 00:10:00 The Teachings of Confucius Confucius the Philosopher 00:13:00 The Teachings of Confucius 00:00:00 The Teachings of Krishnamurti Krishnamurti the Anointed 00:12:00 The Philosophy of Krishnamurti 00:09:00 Applying the Teachings of Krishnamurti 00:09:00 The Teachings of Vivekananda The Philosophy of Swami Vivekananda 00:10:00 The Teachings of Vivekananda 00:09:00 Applying the Teachings of Vivekananda 00:07:00 The Teachings of Yogananda The Ultimate Yogi 00:09:00 The Teachings of Yogananda 00:10:00 Applying the Teachings of Yogananda 00:06:00 Conclusion Conclusion : Eastern Philosophy: From Confucius to Yogananda 00:02:00

Do you struggle with networking, feeling nervous and lacking confidence when meeting new people? That's understandable, but don't let that fear hold you back any longer! Our Networking Know How Masterclass is specifically designed to help you overcome these challenges and give you the skills and confidence you need to network with ease. So, whether you're new to networking or simply looking to improve your skills, our expert guidance will take you through the process and provide you with practical tips and techniques to help you make meaningful connections. By the end of the course, you'll feel comfortable and confident reaching out to others, making small talk, and creating valuable relationships. You'll learn how to network like a pro, and you'll leave the course with a whole new level of confidence, ready to build your professional network and reach your goals. So why wait? Sign up for the course today and start your journey to successful networking!

Being stressed to a certain degree is normal. It is a psychological and physical reaction to the things happening in your life. While a minimal amount of stress can be a motivating factor to urge you to perform better, but increased and continuous stress can cause serious damage to your mental and physical self. This Anxiety & Stress Management Coaching Certification is designed for anyone who wants to coach others about time management, personal or business goals, and self-improvement. To help you through the process, celebrity life coach expert Felix Harder will guide you through the Anxiety & Stress Management Coaching Certification program in a simple, comprehensive manner.  Felix Harder is a certified life coach program developer, fitness coach, nutritionist, and author of numerous best-selling fitness practice books on Amazon. Felix has been guiding over 20,000 global students with proven psychological management routines, nutrition plans, mental and physical fitness strategies, and routines. His ultimate goal is to help people to live fitter, healthier, and happier life. The first step to stress management is to recognize it and deal with it without stressing further. This course is designed to help you understand the root of your stress and to provide you with tools to manage them better. You will be able to teach your clients to identify the issues and resolve them to relieve stress through simple basic exercise and mind hacks. Learning Outcome Gain a deeper understanding of what makes people stressed and how to deal with different levels of stress. Discover the importance of eating healthy and getting an adequate amount of sleep. Explore the psychological aspects of the human mind, why people stress over a situation beyond their control, and how to negate this mindset. Learn how to deal with negative situations with a positive attitude. Uncover different stress management techniques used by professionals and how to incorporate them into your lifestyle. Learn how you can change the way that you perceive various situations. Why You Should Choose 'Anxiety & Stress Management Coaching Certification (CPD)' Course 2.5+ hours of on-demand video lectures, comprehensive articles, and downloadable resources. Lifetime access to the course. No hidden charges or exam fees. Affordable premium-quality E-learning content, you can learn at your own pace. Transparent assessment system, instant results, full tutor supports. Internationally recognized CPD Accredited certification, instantly downloadable PDF copy on successful completion. Obtain the original print copy of your certificate, dispatched the next working day for as little as £9. You will learn the different psychological aspects of stress and the benefits of stress management. You will explore various techniques and strategies to gain control of your actions to help you manage your stress and enable you to help people to lead a happier and healthier life. Who Is This Course For? This course is perfect for professionals like therapists, mental health workers, and growth hack programmers who want to develop their life coaching skills to coach others about personal development, personal transformation, and self-improvement.  It is also great for beginners who want to improve their stress management skills and aspire to build a career in life coaching. Requirements No specific qualifications are required. Fully accessible from any internet-enabled smart device. Career Path The Internationally recognized CPD Accredited certification received upon course completion will boost up your resume if you are a working professional in the psychological healthcare sector or aspiring to pursue a career as a specialist Life Coach. Introduction Introduction & What You Will Learn FREE 00:03:00 The Difference Between Stress And Anxiety FREE 00:03:00 Short vs Long Term Stress 00:02:00 The Effects Of Stress & Anxiety On Your Body 00:05:00 Science-Based Stress & Anxiety Management What Is Science-Based Stress & Anxiety Management 00:02:00 Proven Strategies & Techniques 00:02:00 Calm Breathing Calm Breathing Overview 00:01:00 The Benefits Of Proper Breathing 00:03:00 Breathing Exercise #1 - Three Part Breath 00:02:00 Breathing Exercise #2 - Bellows Breath 00:02:00 Breathing Exercise #3 - Diaphragmatic Breathing 00:02:00 Progressive Muscle Relaxation Progressive Muscle Relaxation Overview 00:02:00 How PMR Helps Reduce Stress & Anxiety 00:03:00 Complete PMR Routine 00:07:00 Exercise For Stress Management Exercise For Stress Management Overview 00:01:00 How Exercise Helps Reduce Stress 00:05:00 Stress Management Workout 00:03:00 Beginner Weight Lifting Routine 00:06:00 What Is HIIT Cardio 00:03:00 How To Design A HIIT Cardio Workout 00:05:00 Nutrition For Stress Management Dieting For Stress Management Overview 00:01:00 How Your Diet Affects Your Health 00:04:00 How To Eat For A Longer & Healthier Life 00:01:00 How Many Calories Should You Consume? 00:02:00 Calculating TDEE 00:03:00 Healthy Weight Ranges 00:02:00 The Right Food Choices 00:02:00 The Best Foods For Stress Relief 00:03:00 The Best Foods For Energy 00:03:00 Supplements For Improved Sleep 00:02:00 Supplements For More Focus 00:02:00 Relationships & Stress Relief Relationships & Stress Overview 00:01:00 The Health Benefits Of Strong Relationships 00:03:00 How To Build Stronger Relationships 00:04:00 How To Fix A Broken Friendship 00:06:00 How To Manage Stress In A Romantic Relationship 00:04:00 Organizing Your Environment Organizing Your Environment For Stress Management 00:01:00 The Modern Problem 00:04:00 Why We Are Faced With Too Many Distractions 00:02:00 How To Reduce Your Decisions 00:05:00 Organizing Your Home 00:07:00 Organizing Your Time 00:06:00 Organizing Your Work 00:08:00

Course Overview The database is a must for collecting, saving, sorting and finding out data of your website or software. An effective database can make your software more engaging and interactive. learn how to use Microsoft SQL Server from this Microsoft SQL Server Development course and boost the quality of your software. This Microsoft SQL Server Development course will teach you the functions of databases and querying from scratch. You will learn about Microsoft SQL Server, relational database management systems, various functions, tables and relationships from this course. You will be able to use the database for your software development and management. This course will also teach you the best practices for database development and management. Learning Outcomes Learn how to use Microsoft SQL management studio Familiarize with basic database design Learn how you can use select statements Be able to insert delete or update data into data tables Learn about the best practices for database development Create relationships among multiple tables Learn how you can use foreign keys Be able to create Complex database objects Understand how to backup and restore database Who is this course for? This course is helpful for anyone who wants to learn about the database management system and SQL servers. You will be able to understand the function of the database, logic and usability of the database for your Microsoft SQL server development. Entry Requirement This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Certification After you have successfully completed the course, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry-leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path Microsoft SQL Server Development is a useful qualification to possess and would be beneficial for any related profession or industry such as: Software Engineer Web Developers Data Security Officers Database Administrators Database Developers Introduction Introduction to SQL Server and Databases 00:04:00 Download and Install SQL Server Express 00:05:00 Manipulating Tables and Data Connect to Database Instance and Create a Database 00:06:00 Drop or Remove Database 00:04:00 What is a Database Table? 00:02:00 Create an SQL Database Table 00:32:00 Insert Data into the Table with SQL Script 00:15:00 Insert Data into the Table with Management Studio 00:05:00 Select Data from the Table with SQL Script 00:09:00 More Advanced Select Queries Part 1 00:18:00 Update Data in the Table 00:10:00 Update Data in the Table with Management Studio GUI 00:02:00 Delete Data from the Table with SQL Script 00:06:00 Delete Data from the Table with Management Studio GUI 00:01:00 Relationships and Foreign Keys What are Relationships, Foreign Keys and Normalization 00:11:00 Create a Relationship in SQL Server 00:19:00 Insert Records in Related Tables 00:13:00 Run Queries on Related Tables 00:19:00 Left, Right and Full Joins 00:11:00 Group By and Aggregate Functions Grouping Data using SQL GROUP BY Clause 00:12:00 SQL AVG Aggregate Function 00:11:00 SQL COUNT Aggregate Function 00:04:00 SQL MAX and MIN Aggregate Functions 00:04:00 SQL SUM Aggregate Function 00:04:00 Advanced SQL Server Objects and Concepts Create and Manage Views 00:23:00 Scalar Valued Functions 00:27:00 Inline Table Valued Functions 00:09:00 Multi Statement Table Valued Functions 00:12:00 Stored Procedures 00:28:00 Table Triggers 00:19:00 Database Scripting, Backup and Restore 00:15:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Stress. For a little word it sure creates a LOT of trouble and - well -there's certainly a LOT to be stressed about! Money, exams, work, relationships, health, family, the future. That's before we talk about global issues like human rights, energy and climate. Maybe we're now even stressed about our stress! It's easy to feel like we're sinking, like there's nothing can be done, that this is how it will always be. But, what if that's not the case? What if there's a way to have a different relationship with stress? What if you could boss your stress not the other way around?