- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
The path to becoming a successful poultry farmer filled with barriers, however, it's not impossible. With some hard work and persistence and proper guidance, you can be successful in this business. We brought this Diploma in Poultry Farming course to inform you about every ins and outs of poultry farming and how to establish and manage a successful poultry enterprise in no time. You will enhance your knowledge about the skills needed for poultry care and management, including wording, breeds, nutrition, infection, layers, hatching, brooding, and advertising. Additionally, this course provides information regarding various diseases including airborne diseases and explains how to prevent the spread of these diseases. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? New farm workers, new industry employees and new graduates hoping to work in the poultry industry. Individuals who want to start their flock of chickens, but they need more information. Anyone who wants to starts a poultry business. Anyone who has a farming hobby. 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. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path Poultry Farm Owner Poultry Farm Worker Poultry inspector Breeder Poultry grader Course Curriculum Update Version - Diploma in Poultry Farming Module 01: Introduction to Poultry Farming Introduction to Poultry Farming. 00:21:00 Module 02: Poultry Nutrition Poultry Nutrition 00:14:00 Module 03: Diseases Diseases 00:17:00 Module 04: Vaccination Vaccination 00:16:00 Module 05: Layers Layers 00:18:00 Module 06: Broilers Broilers 00:13:00 Module 07: Ducks Ducks 00:15:00 Module 08: Turkey Turkey 00:14:00 Module 09: Incubation Incubation 00:15:00 Module 10: Brooding Brooding 00:31:00 Module 11: Housing and the Environment Housing and the Environment 00:18:00 Module 12: Record Keeping, Economics and Marketing Record Keeping, Economics and Marketing 00:23:00 Module 13: Insect and Pest Control Insect and Pest Control 00:16:00 Module 14: Safety and Awareness Farming Safety and Awareness 00:28:00 Old Version - Diploma in Poultry Farming Poultry in UK Characteristics of Organic Poultry Systems 00:30:00 Main Issues for Consideration 00:30:00 Feeding Organic Poultry 01:00:00 Breeds 00:15:00 Brooding 01:00:00 The Growing Bird 01:00:00 Slaughter Ages 00:15:00 Killing and Processing Poultry 01:00:00 Financial Data 01:00:00 Poultry Farming How Much Investment is Required in the Poultry Business? 00:30:00 What Branch of the Poultry Business? 01:00:00 The Dollar Hen Farm 02:00:00 Where to Locate 00:30:00 The Dollar Hen Farm 00:30:00 Incubation 01:00:00 Feeding 00:30:00 Diseases 01:00:00 Difference Between Poultry Flesh and Poultry Fattening 00:30:00 Marketing Poultry Carcasses 00:30:00 Quality in Eggs 01:00:00 Marketing Organization for Eggs 01:00:00 Breeds of Chickens 01:00:00 Practical and Scientific Breeding 01:00:00 Experiment Station Work 00:30:00 Poultry on the General Farm 00:30:00 Mock Exam Mock Exam- Diploma in Poultry Farming 00:20:00 Final Exam Final Exam- Diploma in Poultry Farming 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Food Hygiene Level 2 Course
By Training Tale
This Food Hygiene Level 2 course will teach you how to maintain good hygiene practices among employees and sanitary practices at production sites, both of which are critical factors in preventing food contamination. If you work as a manager or supervisor in the catering industry, this course is perfect for you. It will assist you in exploring daily core responsibilities, such as implementing the fundamentals of a HACCP food safety management system. This comprehensive Food Hygiene Level 2 course will provide learners with an in-depth knowledge of best food hygiene practices to ensure their business is ranked at a national five-star level. Enrol yourself on this course and learn how to conduct food safety, efficiently train your employees, and implement and track a proper food safety system at work that reduces food danger hazards, controls contamination, and maintains a high standard of hygiene. ***Courses*** Course 01: Food Hygiene Level 2 Course 02: Food Allergen Awareness Training Course 03: Workplace First Aid Training Course 04: Fire Safety Level 2 Course 05: Level 3 HACCP Training [ Note: Free PDF certificate as soon as completing the Food Hygiene Level 2 course ] Level 2 Food Hygiene and Safety Course Course Curriculum Module 1: Introduction to Food Hygiene Module 2: Food Safety- An Introduction Module 3: Food Hygiene and Safety Legislation in the UK Module 4: Food Safety Management (HACCP) Module 5: Nature and Origin of Food Contamination Module 6: Controlling Contamination Module 7: Bacterial Food Poisoning Module 8: Non-Bacterial Food Poisoning Module 9: Storage and Temperature Control of Foods Module 10: Cleaning and Disinfection ------------------------------------------- Assessment Method & Certification After completing each module of the Food Hygiene Level 2 Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. You will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Food Hygiene Level 2 course is ideal for: Food Safety Manager, Factory Manager or Supervisor, Catering Manager, Head Chef, Senior food retailers. Requirements There are no specific requirements for this Food Hygiene Level 2 course because it does not require any advanced knowledge or skills. Certificates Certificate of completion Digital certificate - Included
Step into the fascinating world of children’s growth, thought processes and play behaviour with this insightful Child Development, Psychology and Playwork Course. Whether you're working with children already or looking to build your understanding, this course takes you through how young minds develop emotionally, socially and cognitively—wrapped up in a fun yet purposeful look at play and its psychological role in early years. With a solid foundation in theory and everyday application, you'll gain valuable knowledge to support children in a range of environments. Designed to balance scientific understanding with playful interaction, this course explores how children form relationships, express emotion, and make sense of their surroundings through structured and imaginative play. You’ll get to grips with key psychological concepts, developmental milestones, and the frameworks professionals use to observe and support children’s learning journeys. All content is delivered online, making it easy to fit around your schedule while gaining insight that matters. Key Features of Child Development, Psychology and Playwork Bundle CPD Accredited Child Development, Psychology and Playwork Course Instant PDF certificate Fully online, interactive Child Development, Psychology and Playworkcourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Child Development, Psychology and Playwork Bundle course to excel! To become successful in your profession, you must have a specific set of Child Development, Psychology and Playwork skills to succeed in today's competitive world. In this in-depth Child Development, Psychology and Playworktraining course, you will develop the most in-demand Child Development, Psychology and Playwork skills to kickstart your career, as well as upgrade your existing knowledge & skills. Child Development, Psychology and Playwork Curriculum Course 01: Child Psychology & Development Course 02: Child Playwork Accreditation This Child Development, Psychology and Playwork bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Child Development, Psychology and Playwork course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 20 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Child Development, Psychology and Playwork basics. Requirements No prior degree or experience is required to enrol in this course. Career path This Child Development, Psychology and Playwork Course will help you to explore avariety of career paths in the related industry. Certificates Digital certificate Digital certificate - Included Hardcopy Certificate Hard copy certificate - Included Hardcopy Certificate (UK Delivery): For those who wish to have a physical token of their achievement, we offer a high-quality, printed certificate. This hardcopy certificate is also provided free of charge. However, please note that delivery fees apply. If your shipping address is within the United Kingdom, the delivery fee will be only £3.99. Hardcopy Certificate (International Delivery): For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10.
Explore the principles and practices of business ethics in the workplace with our comprehensive course. Gain insights into ethical theories, navigating dilemmas, legal compliance, and fostering an ethical work environment. Develop crucial skills for ethical decision-making and leadership. Enroll now to promote integrity and responsibility in your organization.
The Food Hygiene Level 1, Level 2, and Level 3 bundle course is designed for food, catering, and hospitality professionals at all levels. This comprehensive training program provides crucial information on food hygiene and food safety compliance, addressing key UK legislation for both employers and staff. This all-inclusive Food Hygiene bundle offers detailed guidance on identifying food hazards in the workplace. You'll learn about food hygiene, food safety, food microbiology, hazard control, food poisoning prevention, personal hygiene, and much more. By the end of these Food Hygiene courses, you will possess the skills and theoretical knowledge to implement the best practices in food hygiene and food safety. You will be equipped to establish an effective food hygiene management system in your workplace and have the qualifications to train others on maintaining high standards of food hygiene and safe work systems, incorporating HACCP control measures. This Food Hygiene Bundle Includes: Course 01: Food Hygiene Level 1 Course 02: Food Hygiene Level 2 Course 03: Food Hygiene Level 3 Don't just dream of a great career in Food Safety sector-make it happen. Enroll in our Food Hygiene Level 1, Level 2, and Level 3 bundle course bundle today. We offer this valuable bundle at a fair price of just £14 after a discount. Key Features: CPD Quality Standards (CPD QS) 30 CPD Points Fully online, interactive food hygiene courses with audio voiceover Developed by experts Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Food Hygiene and Safety Level 1,2 & 3 Training Bundle Curriculum Outline The Food Hygiene Training Bundle includes three comprehensive courses designed to equip food, catering, and hospitality professionals with essential knowledge and skills in food hygiene. Course 01: Food Hygiene Level 1 introduces the basics of food hygiene and food safety. Learners will understand the importance of food hygiene, identify food poisoning and other illnesses, recognize contamination risks, and learn about proper waste disposal, cleaning, disinfection, and personal hygiene practices. Module 01: Introduction to Food Safety Module 02: Food Poisoning and other illnesses Module 03: Contamination Module 04: Waste Disposal, Cleaning and Disinfection Module 05: Personal Hygiene Course 02: Food Hygiene Level 2 builds on the foundational knowledge from Level 1. It covers Food Safety Management Systems (FSMS) and Hazard Analysis and Critical Control Points (HACCP), both critical aspects of food hygiene. Learners will gain a deeper understanding of food poisoning and illnesses, contamination, waste disposal, cleaning, disinfection, pest management, and personal hygiene, all within the context of food hygiene. Module 01: Introduction to Food Safety Module 02: Food Safety Management Systems (FSMS) and HACCP Module 03: Food Poisoning and other illnesses Module 04: Contamination Module 05: Waste Disposal, Cleaning and Disinfection Module 06: Pest Management Module 07: Personal Hygiene Course 03: Food Hygiene Level 3 is designed for supervisors and managers with a focus on advanced food hygiene practices. It delves into the roles and responsibilities of food supervisors and handlers, as well as relevant laws and legislation related to food hygiene. The course provides advanced training on FSMS and HACCP, food poisoning, contamination, waste disposal, cleaning, disinfection, pest management, and personal hygiene. Additionally, it includes modules on effectively training and supervising staff to maintain food hygiene standards. Module 01: Introduction to Food Safety Module 02: Roles and Responsibilities of Food Supervisors and food handlers Module 03: Laws and Legislation Module 04: Food Safety Management Systems (FSMS) and HACCP Module 05: Food Poisoning and other illnesses Module 06: Contamination Module 07: Waste Disposal, Cleaning and Disinfection Module 08: Pest Management Module 09: Personal Hygiene Module 10: Training and Supervising Staff Effectively By completing this food hygiene bundle, learners will acquire a thorough understanding of food hygiene and safety. They will learn to identify and control food hazards, prevent foodborne illnesses, and maintain high standards of personal hygiene. They will also be equipped to implement effective food hygiene management systems, comply with food hygiene laws, and train others in best practices. This food hygiene bundle ensures that professionals are well-prepared to maintain a safe and hygienic food environment in their workplaces. Learning Outcomes Understand the basics of food hygiene and safety practices. Identify and prevent food poisoning and other foodborne illnesses. Recognize and control food contamination hazards effectively. Implement waste disposal, cleaning, and disinfection protocols. Maintain high standards of personal hygiene in the workplace. Apply food safety management systems and HACCP principles. Certification After completing this Food Hygiene and Safety Level 1,2 & 3 Course, you will get a free Certificate. CPD 30 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? Food handlers in catering and hospitality sectors. Supervisors managing food safety in workplaces. Staff responsible for food hygiene compliance. Employers needing food safety training for employees. Individuals seeking food hygiene knowledge. Please be informed that this Food Hygiene and Safety Level 1,2 & 3 course doesn't provide any formal qualification. To get qualified, you have to join programs such as - Level 1 Award in Food Safety in Catering (RQF) Level 2 Award in Food Safety for Catering (RQF) Level 2 Award in Food Safety in Catering (RQF) Level 2 Award in HACCP for Catering (RQF) Level 3 Award in Food Safety for Catering (RQF) Career path After completing this bundle you will have a variety of careers to choose from. The following job sectors are: Food & Safety Inspector: £25,000 - £35,000 per annum Safety & Hygiene Advisor: £30,000 - £35,000 per annum Restaurant Manager: £28,000 - £32,000 per annum Head Chef: £35,000 - £45,000 per annum Food Safety Manager: £35,000 per annum Food Safety Officer: £40,000 - £50,000 per annum Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Our Midwifery and Maternity Care Training Course is designed for those looking to deepen their understanding of maternal health and midwifery, all from the comfort of your own home. This course provides a deep dive into the complexities of pregnancy, birth, and postnatal care, offering you a thorough grasp of key concepts without the need for in-person attendance. Whether you are starting a new career or enhancing existing knowledge, this course equips you with the knowledge to navigate the varied aspects of maternity care. With 28 years of industry experience, we bring a training programme that is built on a solid foundation of research, case studies, and expert insight. You will engage with carefully designed content that addresses the latest in maternal health practices and theoretical frameworks. From understanding the emotional aspects of maternity to the medical intricacies of childbirth, every module is crafted to enrich your expertise and provide you with a well-rounded perspective of midwifery. No matter where you are in your journey, this course ensures you're well-prepared to take on the challenges of maternity care with confidence. Key Features of Midwifery and Maternity Care Training Bundle CPD Accredited Midwifery and Maternity Care Training Course Instant PDF certificate Fully online, interactive Midwifery and Maternity Care Trainingcourse Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Enrol now in this Midwifery and Maternity Care Training Bundle course to excel! Midwifery and Maternity Care Training Curriculum Midwifery Module 01: Definition and Origin of Midwifery Module 02: Midwifery as a Career Option Module 03: Midwifery Management and Education Module 04: Midwives' Role in Health and Inequality Module 05: Social, Cultural and Spiritual Context of Childbearing Module 06: Antenatal Care and Screening Module 07: Midwifery Support in Labour: Intrapartum Care Module 08: Induction of labour Module 09: Postnatal Care as a Midwife Module 10: Nurture and Nature: The Healthy Newborn Module 11: Stillbirth, Neonatal Death and Bereavement Module 12: Infant feeding Module 13: Newborn Infection Module 14: Home Birth Module 15: Complementary and Alternative Medicines Applied to Maternity Care Module 16: Pharmacology and Medicines Management Module 17: Bleeding in Pregnancy Module 18: Medical Disorders of Pregnancy Module 19: Pre-term Labour Module 20: Twins and higher-order births Module 21: Care During the Third Stage of Labour Module 22: Terminology and Abbreviations for Midwifery Module 23: Perinatal mental health Module 24: Supporting a Healthy Pregnancy Module 25: Contraception and family planning Module 26: Effective Communication for Midwifery Module 27: Ethics in Midwifery Maternity Care Assistant Maternity Care Assistant Module 01: Introduction to Maternity Care Module 02: Terminology and Abbreviations for Maternity Care Assistant Module 03: Reproductive Anatomy & Physiology Module 04: Antenatal Care and Screening Module 05: Support in Labour: Intrapartum Care Module 06: Postnatal Care Module 07: Nurture and Nature: The Healthy Newborn Module 08: Infant feeding Module 09: Newborn Infection Module 10: Care During the Third Stage of Labour Module 11: Perinatal mental health Module 12: Supporting a Healthy Pregnancy Module 13: Effective Communication Module 14: Empathy and Comfort Skills Module 15: Team Working Module 16: Maternity Care Assistance as a Career Accreditation This Midwifery and Maternity Care Training bundle courses are CPD accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your Midwifery and Maternity Care Training course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). CPD 25 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is ideal for all employees or anyone who genuinely wishes to learn more about Midwifery and Maternity Care Training basics. Individuals aspiring to become midwives or maternity care assistants. Healthcare professionals seeking to specialize in maternity care. Students interested in reproductive health and childbirth. Those looking to pursue careers in maternity care facilities. Anyone passionate about supporting healthy pregnancies and newborns. Requirements No prior degree or experience is required to enrol in this Midwifery and Maternity Care Training course. Career path This Midwifery and Maternity Care Training Course will help you to explore avariety of career paths in the related industry. Midwife - £25K to 35K/year. Maternity Support Worker - £18K to 24K/year. Neonatal Nurse - £24K to 40K/year. Obstetrician/Gynaecologist - £40K to 100K/year. Childbirth Educator - £20K to 30K/year Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hardcopy Certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.
Discover the essential skills and knowledge needed for success in the legal profession with our comprehensive Legal Secretaries Introductory Training course. From legal writing to contract law, litigation skills to employment law, equip yourself with the expertise to thrive in law offices. Enroll now and embark on a rewarding career path in the legal field.
Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00
