2896 ARC courses delivered Online

Embark on a digital crafting odyssey, diving into the intricate world of web creation with our 'PHP Web Development with MySQL; GitHub & Heroku' course. Visualise your first step into this digital tapestry with the 'Introduction' unit, an inviting prelude that demystifies the realm of server-side scripting. As learners unfurl the sails of their developmental journey, they'll configure their coding environment, laying the robust groundwork for a future in web architecture. Advancing into the heart of PHP, our syllabus navigates through the crucial syntax and fundamentals that form the bedrock of dynamic website construction. Engage with the creation of interactive forms, delve into database manipulation using MySQL, and master user authentication processes. This course promises a transformative learning expedition, from first principles to deploying live web applications, all while ensuring each participant garners the confidence to stitch together the seams of secure, responsive online experiences. Learning Outcomes Comprehend PHP fundamentals and create robust web applications. Configure environments for PHP development with precision. Integrate MySQL databases for dynamic content management. Construct and handle secure PHP forms for data collection. Implement user authentication to safeguard web applications. Why choose this PHP Web Development with MySQL; GitHub & Heroku course? 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 PHP Web Development with MySQL; GitHub & Heroku course for? Novices embarking on web development careers. Technologists eager to learn server-side scripting. Data managers focusing on MySQL database integration. Coders looking to understand PHP in web applications. Developers aiming to utilise GitHub and Heroku for deployment. Career path Web Developer: £25,000 - £50,000 PHP Developer: £24,000 - £45,000 MySQL Database Administrator: £30,000 - £60,000 User Authentication Specialist: £35,000 - £55,000 Back-End Developer: £28,000 - £53,000 DevOps Engineer: £40,000 - £70,000 Prerequisites This PHP Web Development with MySQL; GitHub & Heroku does not require you to have any prior qualifications or experience. You can just enrol and start learning.This PHP Web Development with MySQL; GitHub & Heroku 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 Unit 01: Introduction Introduction 00:06:00 Unit 02: Environment Configuration Module 01: Setup a PHP Environment using XAMPP 00:16:00 Module 02: Install Composer Package Manager 00:03:00 Module 03: Visual Studio Code - Web Development Add ons 00:12:00 Module 04: Create a GitHub Account 00:13:00 Module 05: Create a Heroku Account 00:08:00 Unit 03: PHP Basics and Syntax Module 01: How PHP Works 00:29:00 Module 02: IFELSE Statements 00:19:00 Module 03: Switch Statements 00:09:00 Module 04: FOR Loop 00:10:00 Module 05: WHILE AND DOWHILE Loops 00:14:00 Module 06: PHP Arrays and Manipulation 00:13:00 Module 07: String Manipulation Functions 00:28:00 Module 08: Date and Time Manipulation Functions 00:15:00 Module 09: User Defined Functions 00:22:00 Module 10: PHP Include and Require 00:22:00 Module 11: PHP Website Layout - With Bootstrap 00:23:00 Module 12: Add Project to Github 00:08:00 Module 13: Publish Website to Heroku 00:20:00 Unit 04: PHP Forms and MySQL and User Authentication Module 01: Project and Website Setup 00:21:00 Module 02: Create a Bootstrap 4 Form 00:28:00 Module 03: PHP Form - $_GET Action 00:23:00 Module 04: PHP Form - $_POST Action 00:11:00 Module 05: Design Database with phpMyAdmin 00:19:00 Module 06: Connect to Database using PHP PDO 00:18:00 Module 07: Save Records to Database 00:38:00 Module 08: View Database Records 00:36:00 Module 09: View One Record's Details 00:28:00 Module 10: Update Database Records 00:34:00 Module 11: Delete Database Records 00:11:00 Module 12: Final Touches: Form Validation, Error Messages, Success Messages 00:17:00 Module 13: Create Heroku App and Remote Database 00:21:00 Module 14: Setup Authentication Tables in Database 00:20:00 Module 15: Setup Login and Authentication 00:29:00 Module 16: Control User Access 00:08:00 Module 17: Sending Confirmation Emails 00:31:00 Module 18: Upload Profile Pictures 00:31:00 Module 19: Final Touches 00:14:00 Resources Resources - PHP Web Development w/ MySQL GitHub & Heroku 00:00:00 Assignment Assignment - PHP Web Development with MySQL; GitHub & Heroku 00:00:00

Embark on a riveting journey from ChatGPT novice to maestro with our 'ChatGPT Masterclass: A Complete ChatGPT Zero to Hero!' This isn't just a course; it's your passport to mastering the intricacies of ChatGPT. In the initial sections, we handhold you through the basics, ensuring a solid foundation. As you progress, delve into the world of developers, discovering how ChatGPT can be harnessed for coding marvels. But this course isn't limited to tech whizzes; entrepreneurs can scale their business using the prowess of ChatGPT in Section 04. For students, Section 05 unveils the academic wonders of ChatGPT, while Section 08 ventures into artistic realms with Dall-E 2. Brace yourself for a transformative experience as you explore the power of ChatGPT across diverse domains, from Excel to graphic art. Learning Outcomes Master the fundamentals of ChatGPT, progressing from the basics to advanced applications. Harness ChatGPT for coding and development, unlocking its potential for developers. Scale your business using ChatGPT, understanding its applications in entrepreneurship. Explore academic applications, discovering how ChatGPT enhances student learning. Unleash the artistic side of ChatGPT, creating graphic art with Dall-E 2. Why choose this ChatGPT Masterclass: A Complete ChatGPT Zero to Hero course? 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 ChatGPT Masterclass: A Complete ChatGPT Zero to Hero course for? Aspiring ChatGPT enthusiasts eager to transition from zero to hero. Developers seeking to integrate ChatGPT into their coding repertoire. Entrepreneurs aiming to leverage ChatGPT for business growth. Students exploring the academic applications of conversational AI. Creatives and graphic artists interested in the artistic possibilities of ChatGPT. Career path Conversational AI Developer: £50,000 - £80,000 Entrepreneurial AI Strategist: £60,000 - £90,000 AI-enhanced Education Specialist: £45,000 - £70,000 Creative AI Artist: £40,000 - £60,000 AI Solutions Architect: £55,000 - £85,000 Innovative Tech Entrepreneur: £70,000 - £100,000 Prerequisites This ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This ChatGPT Masterclass: A Complete ChatGPT Zero to Hero! 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 Section 01: Getting Started Introduction 00:04:00 Start on Windows, macOS, and Linux 00:01:00 How to ask great questions 00:02:00 FAQs 00:01:00 Section 02: ChatGPT - Basic What is ChatGPT 00:05:00 Create a ChatGPT account 00:06:00 How to use ChatGPT 00:10:00 ChatGPT for day-to-day activities 00:04:00 Advanced ChatGPT Plus 00:05:00 Section 03: ChatGPT for Developers ChatGPT for programmers 00:12:00 Improve Problem-solving skills 00:06:00 Create an Algorithms 00:06:00 How to build a website with ChatGPT 00:05:00 Develop a Stunning Landing page for product sales 00:07:00 Create a Documentation 00:03:00 Code Debugging with ChatGPT 00:05:00 Section 04: Build, and Scale your Business Using ChatGPT The Best Businesses Ideas to start with ChatGPT 00:05:00 SEO Basics for your website 00:06:00 How to make an online course using ChatGPT 00:05:00 Selling Competitive products with ChatGPT 00:04:00 Exercise on real-world sales query 00:01:00 Solution for an exercise 00:02:00 ection 05: ChatGPT for Students ChatGPT to Prepare Resume 00:03:00 Interview preparation with ChatGPT 00:05:00 ChatGPT for PowerPoint content 00:03:00 Innovative Job Searching using ChatGPT 00:04:00 Write a short film with ChatGPT for Creative Fiction and Screenplays 00:03:00 Section 06: The Power of ChatGPT Make the best diet plan for a day 00:03:00 Suggest a meal plan with seafood as the special ingredient 00:03:00 Write a Business Email for the franchise 00:03:00 Create Legal documents like sale deeds etc. 00:03:00 Section 07: ChatGPT for Excel professionals Sum with ChatGPT 00:05:00 VLOOKUP with ChatGPT 00:05:00 Section 08: Generate Incredible Graphic Art with Dall-E 2 Introduction to Dall-E 2 00:04:00 Dall-E 2 Creating 3D Graphic design 00:03:00 Dall-E 2 Deep Dive in Editing your own image 00:04:00 How to Make Money with Dall-E 2 00:03:00 Section 09: The Best Tools and Extensions using ChatGPT Integrating ChatGPT with Google Search 00:06:00

Embark on a journey to uncover the labyrinthine world of digital financial security with the 'Hacked Credit and Debit Card Recovery Course'. Navigate through the depths of the web, from understanding the diverse range of websites to delving deep into the dark corridors of the internet, equipping yourself with invaluable cyber intelligence. Through this course, you'll decode various threat perceptions, familiarise yourself with card fraud intricacies, and master the art of information recovery - all tailored to ensure your digital financial transactions remain impervious to threats. Learning Outcomes Understand the fundamentals of cyber threats and their impact on digital financial transactions. Differentiate between various website types and their susceptibility to cyber-attacks. Analyse threat actors and their modus operandi in the cyber realm. Gain insights into the deep and dark web and the tools necessary for information recovery. Acquire proficiency in information handling procedures to maintain digital financial security. Why buy this Hacked Credit and Debit Card Recovery Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Hacked Credit and Debit Card Recovery Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Hacked Credit and Debit Card Recovery Course for? Individuals keen on enhancing their understanding of digital financial security. Banking and finance professionals looking to fortify their defence mechanisms. Cybersecurity enthusiasts aiming to delve into card fraud detection and prevention. Internet users wanting to safeguard their online financial transactions. Tech-savvy individuals eager to explore deep and dark web intelligence. Prerequisites This Hacked Credit and Debit Card Recovery Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Hacked Credit and Debit Card Recovery Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Cyber Security Analyst: £35,000 - £55,000 Fraud Detection Analyst: £30,000 - £50,000 Dark Web Researcher: £40,000 - £65,000 Information Security Officer: £45,000 - £70,000 Threat Intelligence Specialist: £50,000 - £75,000 Financial Security Consultant: £55,000 - £80,000 Course Curriculum Unit 01: Introduction Introduction & Objective 00:01:00 Unit 02: Types of Website Types of Website 00:01:00 Surface Web 00:01:00 Deep Web 00:01:00 Dark Web 00:03:00 2016 - 2017 Profit Comparison from 5000 00:01:00 Intelligence Agency Web 00:01:00 Quantum Computers 00:01:00 Polymeric Falcighol Derivation 00:01:00 Graphical representation 00:01:00 Unit 03: Threat Perception Threat Perception 00:01:00 Threat Actor 00:01:00 Threat Actor-Compared to a Hacker Or Attacker 00:01:00 Is the Dark Net Market gone? 00:03:00 Unit 04: Card Fraud Card Fraud 00:04:00 Card-Not-Present Fraud (CNP) 00:02:00 Unit 05: Threat Ninja Threat Ninja 00:01:00 Threat Ninja Architecture 00:03:00 Adaptive Assessment 00:01:00 Secure Coat Approach 00:01:00 Secure Coat's Value Proposition 00:02:00 Challenge 00:01:00 Unit 06: Threat Actor Analysis Threat Actor Analysis 00:00:00 Kuchinoni - ATM Theft 00:01:00 Insider Threats 00:01:00 Unit 07: Cyber Security Monitoring Cyber Security Monitoring 00:01:00 Protect Your Company via DDWM 00:01:00 Unit 08: Threat Life Cycle Threat Life Cycle 00:06:00 Unit 09: Information Leakage Points Information Leakage Points 00:04:00 Unit 10: Valuable Information Valuable Information 00:09:00 Unit 11: Area of Search Area of Search 00:01:00 Sell Cards at Social Media, Messenger, etc. Groups 00:01:00 Unit 12: Deep & Dark Web Intelligence and Information Recovery Deep & Dark Web Intelligence and Information Recovery 00:01:00 Unit 13: Banking Fraud Types Banking Fraud Types 00:01:00 Card Fraud- Nilson Report 00:01:00 U.S. Card Fraud Losses 00:01:00 Card Fraud Statistics 00:05:00 Unit 14: Threat Ninja Tool Secure Coat Threat Ninja Portal 00:01:00 Threat Ninja Demo 00:05:00 Unit 15: Information Handing Procedures Information Handling Procedures 00:01:00 Card Discard Life Cycle 00:02:00 Unit 16: Course Wrap up Congratulations and Course Summary 00:03:00 Thank you! 00:01:00 Unit 17: Bonus Rise in the price of the Crypto Coin 00:06:00 Assignment Assignment - Hacked Credit and Debit Card Recovery Course 00:00:00

Embark on a captivating journey into animation with the 'Animation Designer (Drawings, Timing, Overlapping, Coloring) Complete Course.' This comprehensive program unveils the magic behind bringing characters and stories to life, guiding you through the intricate animation design process. From the foundational principles to the nuanced skills of timing and colouring, this course is a tapestry of creativity and technical prowess. Imagine the thrill of seeing your drawings evolve from simple sketches to dynamic, emotionally resonant characters. Delve more profoundly, and you'll explore the 12 core principles of animation design that serve as the industry's heartbeat. Each module, from 'Squash and Stretch' to 'Solid Drawing,' is a stepping stone towards mastery. You'll not just learn; you'll experience the transformation of inanimate sketches into vivid, lifelike animations. The course's practical segments, including the step-by-step creation of a cartoony elephant and bunny, offer an immersive experience. You'll witness firsthand the intricate process of animating characters, from drafting to adding final touches like shadows and backgrounds. This course is not just about learning; it's about evolving as a creator. It will give you the knowledge and skills to express your creativity through animation. Whether it's the precise timing of movements, the subtle art of colouring, or the understanding of how to stage your animations for maximum impact, you'll emerge as a well-rounded animation designer. Your journey through this course is not just about acquiring skills; it's about unlocking a new realm of artistic possibilities. Learning Outcomes of Animation Design course: Acquire a comprehensive knowledge of the 12 principles of animation. Develop proficiency in creating fluid animations with techniques like easing in and out. Gain skills in designing appealing animations with a focus on staging and character appeal. Master the art of character animation, including complex movements like walk and run cycles. Learn to use animation software tools effectively for drawing, colouring, and refining animations. Why buy this Animation Design Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Animation Designer (Drawings, Timing, Overlapping, Coloring) Complete Course you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Animation Design course for? Aspiring animators seeking to gain a foundational understanding of animation principles. Graphic designers interested in expanding their skill set into the animation domain. Art students aiming to specialize in character design and animation. Creative professionals looking to incorporate animation into their digital storytelling. Hobbyists and enthusiasts eager to explore the art of animation and character creation. Prerequisites This Animation Designer (Drawings, Timing, Overlapping, Coloring) Complete Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Animator: £20,000 - £36,000 annually Graphic Designer with Animation Skills: £22,000 - £40,000 annually Character Designer for Animation: £24,000 - £45,000 annually Multimedia Artist: £23,000 - £39,000 annually Animation Director: £30,000 - £60,000 annually Freelance Animation Artist: Varies based on project and experience Course Curriculum INTRODUCTION Introduction 00:02:00 THE 12 PRINCIPLES OF ANIMATION Introduction of the 12 Principles of Animation 00:02:00 Squash and Stretch 00:03:00 Ease In and Ease Out 00:02:00 Timing 00:02:00 Anticipation 00:04:00 Follow Through and Overlapping Action 00:02:00 Exaggeration 00:02:00 Arcs 00:04:00 Secondary Action 00:02:00 Pose to Pose and Straight Ahead 00:02:00 Appeal 00:01:00 Staging 00:01:00 Solid Drawing 00:01:00 JUMPING ELEPHANT Jumping Elephant Part 1 00:15:00 Jumping Elephant Part 2 00:18:00 WALKCYCLE Introduction 00:10:00 Overview of The App Flippa Clip 00:05:00 Walkcycle of Cartoony Elephant - Part 1 00:23:00 Walkcycle of Cartoony Elephant - Part 2, Overlapping Action 00:07:00 Walkcycle of Cartoony Elephant - Part 3, Adding The Ears 00:06:00 Walkcycle of Cartoony Elephant - Part 4, Outlines 00:15:00 Walkcycle of Cartoony Elephant - Part 5, Clean up 00:06:00 Walkcycle of Cartoony Elephant - Part 6, Adding the eyes 00:08:00 Walkcycle of Cartoony Elephant - Part 7, Adding the Pupils 00:04:00 Walkcycle of Cartoony Elephant - Part 8, Coloring 00:06:00 Walkcycle of Cartoony Elephant - Part 9, Adding Shadows 00:16:00 Walkcycle of Cartoony Elephant - Part 10, Adding Background 00:14:00 Walkcycle of Cartoony Elephant - Part 11, Coloring the Background 00:15:00 RUNCYCLE Runcycle - INTRODUCTION 00:05:00 RunCycle of a Cartoony Bunny - Part 1, Draw the frames 00:17:00 RunCycle of a Cartoony Bunny - Part 2, Refining the Drawings 00:11:00 RunCycle of a Cartoony Bunny - Part 3, Adding the Ears 00:07:00 RunCycle of a Cartoony Bunny - Part 4, Front Run 00:28:00 RunCycle of a Cartoony Bunny - Part 5, Adding the Facials 00:08:00 DIALOGUE Dialogue - Drawing Thumbnails 00:05:00 Dialogue - Timing the Key Poses 00:21:00 Dialogue - Polishing the Animation 00:09:00

Welcome to Microsoft sql server development for everyone Course. The world of data is a vast and complex one. But with the right tools, it can be yours to explore. SQL Server is one of those tools. It's a powerful database management system that can help you store, manage, and analyse data in ways that were never before possible.   In this Microsoft SQL Server Development for Everyone! course, you'll learn the basics of SQL Server development. You'll learn how to create and manage databases, tables, and data. You'll also learn how to write SQL queries to manipulate data.   Starting with a solid Introduction to SQL, you'll grasp core concepts and gain a strong foundation. We'll then dive into Manipulating Tables and Data, equipping you with effective skills for storing, retrieving, updating, and deleting information.   But we won't stop there! Our in-depth exploration of Relationships and Foreign Keys will ensure you understand the importance of data integrity and how to establish connections between tables. You'll create robust and reliable databases with enforced referential integrity. Next, we'll empower you with the tools of Group By and Aggregate Functions, enabling efficient data analysis and summarisation. Extracting meaningful insights from vast amounts of information will become second nature to you.   To become a well-rounded SQL Server developer, we'll conclude the course with Advanced SQL Server Objects and Concepts. You'll gain a deep understanding of essential elements like stored procedures, views, triggers, and indexes. This knowledge will optimise performance and streamline your development process.   By the end of this Microsoft SQL Server Development for Everyone! course, you'll have a strong understanding of how to use SQL Server to manage and manipulate data. You'll be able to build powerful applications that make better decisions. Become a sought-after SQL Server developer and master the art of data management. Join us today and unlock your data-driven potential!   Learning Outcomes: Through this comprehensive course, you should be able to:   Understand core concepts and gain a strong foundation in SQL Server development. Acquire skills to effectively manipulate tables and data. Establish relationships and enforce data integrity using foreign keys. Utilise group by and aggregate functions for efficient data analysis. Explore advanced SQL Server objects and concepts like stored procedures and views. Gain proficiency in implementing triggers and optimising database performance. Develop the ability to create robust and reliable databases.   Who is this course for? This Microsoft SQL Server Development for Everyone! course is perfect for:   Aspiring developers looking to enhance their programming skills. Professionals seeking to expand their knowledge of SQL Server development. Individuals interested in exploring the world of databases and data management. Students or graduates pursuing a career in database administration or development. Curious learners eager to harness the power of SQL Server.   Career Path Our course will help you to pursue a range of careers, including:   Database Administrator: £25,000 - £60,000 per year. SQL Developer: £30,000 - £65,000 per year. Data Analyst: £25,000 - £55,000 per year. Business Intelligence Developer: £35,000 - £70,000 per year. Software Engineer: £30,000 - £70,000 per year. Data Engineer: £40,000 - £80,000 per year. Database Architect: £45,000 - £90,000 per year. Certification After studying the course materials of the Microsoft SQL Server Development for Everyone! there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Prerequisites This Microsoft SQL Server Development for Everyone! does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Microsoft SQL Server Development for Everyone! 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.   Course Curriculum 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 Assignment Assignment - Microsoft SQL Server Development for Everyone! 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special IT for Recruiters Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The IT for Recruiters Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This IT for Recruiters Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This IT for Recruiters Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this IT for Recruiters? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the IT for Recruiters there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This IT for Recruiters course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This IT for Recruiters does not require you to have any prior qualifications or experience. You can just enrol and start learning.This IT for Recruiters was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This IT for Recruiters is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Introduction 00:02:00 IT Fundamentals What is hardware and software 00:04:00 Server 00:08:00 Project Life cycle 00:06:00 Software Development Life Cycle 00:08:00 IT Terms Basics Methodologies 00:09:00 CMS 00:04:00 API 00:04:00 CI/CD 00:04:00 Stacks 00:03:00 Native and Hybrid Native Apps 00:02:00 IT Positions CTO 00:13:00 IT Architect 00:08:00 Product Owner 00:12:00 Project Manager 00:13:00 Product Manager 00:06:00 PO vs PM vs Product Manager 00:07:00 PO vs Product Manager 00:04:00 Business Analyst 00:09:00 Business Intelligence Specialist 00:06:00 Data Engineer 00:05:00 Data Scientist 00:07:00 Data Engineer vs Data Scientist 00:07:00 Agile Coach 00:14:00 Scrum Master 00:08:00 Agile Coach vs Scrum Master 00:01:00 Frontend Developer 00:06:00 Backend Developer 00:06:00 Fullstack Developer 00:04:00 Frontend vs Backend vs Fullstack Developer 00:02:00 iOS Developer 00:03:00 Android Developer 00:04:00 UX Designer 00:09:00 UI Designer 00:08:00 UX vs UI Designer 00:04:00 QA Engineer_Tester 00:09:00 SysAdmin 00:07:00 DevOps 00:05:00 SEO 00:10:00 IT Technologies. Programming Languages and Frameworks Programming languages and frameworks. Intro 00:01:00 Programming languages and frameworks 00:08:00 Java 00:03:00 JavaScript 00:02:00 Python 00:01:00 C 00:02:00 C++ 00:03:00 C# 00:02:00 HTML 00:02:00 PHP 00:02:00 SWIFT 00:02:00 Objective-C 00:01:00 Ruby 00:02:00 SQL 00:02:00 Go (Golang) 00:01:00 Databases Database 00:05:00 Types of Databases 00:07:00 From Recruiter to Recruiter The day of an IT Recruiter 00:05:00 Key principles 00:03:00 Sourcing Tipps 00:03:00 Good Bye Video Good Bye Video 00:01:00

The 'Linux Shell Scripting' course offers comprehensive training in shell scripting for Linux environments. From creating a local Linux shell scripting environment to network scripting and automation, learners will develop practical skills to automate tasks, process data, and improve efficiency using shell scripts. Learning Outcomes: Set up a local Linux shell scripting environment for practical learning. Create shell scripts for user and account management, including password generation and handling shell script arguments. Apply Linux programming conventions to maintain clear and efficient code. Develop shell scripts that parse command-line options for flexible user interaction. Utilize shell scripting for data processing, transformation, and reporting tasks. Automate network scripting and distributed systems for enhanced efficiency. Summarize the key concepts and techniques learned throughout the course. Access additional course extras and resources for further exploration and practice. Why buy this Linux Shell Scripting? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Linux Shell Scripting there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Linux Shell Scripting course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Linux Shell Scripting does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Linux Shell Scripting was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Linux Shell Scripting is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Course Introduction Introduction and Course Overview 00:02:00 Course Downloads 00:03:00 Unit 02: Creating a Local Linux Shell Scripting Environment Creating a Local Lab Environment Using Vagrant and VirtualBox - Background 00:16:00 Exercise 1 Instructions - Creating a Local Linux Shell Scripting Lab Environment 00:28:00 Exercise 1 - Walkthrough - Part I - Windows Users Only 00:04:00 Exercise 1 - Walkthrough - Part I - Mac Users Only 00:02:00 Exercise 1 - Walkthrough - Part I - Linux (CentOS/RHEL) Users Only 00:03:00 Exercise 1 - Walkthrough - Part II - All Users 00:23:00 Unit 03: User and Account Creation - Shell Scripting Project 1 Section Introduction 00:03:00 Getting Started with Shell Scripting: Naming, Permissions, Variables, Builtins. 00:35:00 Special Variables, Pseudocode, Command Substitution, if Statement, Conditionals. 00:23:00 Exit Statuses, Return Codes, String Test Conditionals, More Special Variables. 00:18:00 Reading Standard Input, Creating Accounts, Username Conventions, More Quoting. 00:23:00 Exercise 2 - Instructions 00:12:00 Exercise 2 - Walkthrough 00:21:00 Unit 04: Password Generation and Shell Script Arguments - Shell Scripting Project 2 Random Data, Cryptographic Hash Functions, Text and String Manipulation. 00:31:00 Positional Parameters, Arguments, for Loops, Special Parameters 00:30:00 The while Loop, Infinite Loops, Shifting, Sleeping 00:16:00 Exercise 3 - Instructions 00:12:00 Exercise 3 - Walkthrough 00:20:00 Unit 05: Linux Programming Conventions - Shell Scripting Project 3 Advanced Standard Input, Standard Output, and Standard Error - Part I 00:13:00 Advanced Standard Input, Standard Output, and Standard Error - Part II 00:26:00 Exercise 4 - Instructions 00:05:00 Exercise 4 - Walkthrough 00:12:00 Unit 06: Parsing Command Line Options - Shell Scripting Project 4 Case Statements 00:20:00 Functions 00:33:00 Parsing Command Line Options with getopts, Part 1 00:20:00 Parsing Command Line Options with getopts, Part 2 00:18:00 Deleting and Disabling Linux Accounts, Part 1 of 4 (Finding Files) 00:11:00 Deleting and Disabling Linux Accounts, Part 2 of 4 (The userdel command) 00:05:00 Deleting and Disabling Linux Accounts, Part 3 of 4 (Archives with tar) 00:14:00 Deleting and Disabling Linux Accounts, Part 4 of 4 (Disabling Accounts) 00:08:00 Deleting Users - Exercise 5 - Instructions 00:14:00 Deleting Users - Exercise 5 - Walkthrough 00:33:00 Unit 07: Transforming Data / Data Processing / Reporting - Shell Scripting Project 5 Cut and Awk 00:22:00 Cut and Awk Demonstration Script: Open Network Ports 00:10:00 Sort and Uniq 00:18:00 Parsing Log Files - Exercise 6 - Walkthrough 00:15:00 Sed 00:29:00 Unit 08: Network Scripting & Automation of Distributed Systems: Shell Scripting Project 6 Configuring a Mini Network and Scripting for Remote Systems 00:30:00 Scripting Remote Commands - Walkthrough - Part 1 00:26:00 Scripting Remote Commands - Exercise - Instructions 00:12:00 Scripting Remote Commands - Walkthrough - Part 2 00:13:00 Unit 09: Course Summary Summary 00:08:00 Unit 10: Course Extras What Shell Scripting Is and Why You Should Learn It 00:10:00 Resources Resources - Linux Shell Scripting 00:00:00 Assignment Assignment - Linux Shell Scripting 00:00:00

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are 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. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Food Handlers Certificate Online: Your Passport to Culinary Safety Ever wondered what makes a great chef more than just a maestro of flavours? It's their commitment to food safety. Welcome to the Food Handlers Certificate Online, where you'll become the unsung hero of every kitchen, ensuring every bite is not just delicious but safe. Culinary Safety: Where Taste Meets Trust Picture yourself as the guardian of the culinary realm. Your mission: to make sure every dish that leaves your kitchen isn't just a delight to the taste buds but also safe to eat. It's not just a job; it's a delicious adventure into the world of food safety. From Kitchen Novice to Culinary Hero In this course, you'll unlock the secrets to safeguarding food safety. It's not about wearing a chef's hat; it's about donning the cloak of safety that every culinary wizard needs. From understanding the intricacies of food safety legislation to mastering the art of supervision, you'll be ready to conquer the kitchen like a pro. Steering Clear of Culinary Hazards Every culinary hero knows that the kitchen is filled with hazards. But you won't just identify them; you'll learn to tame them. Whether it's bacterial food poisoning or foodborne illnesses, you'll be the detective and the solution, ensuring the dishes you create are a culinary masterpiece, free from harm. Temperature: The Maestro of the Culinary Symphony Just like a maestro conducting an orchestra, you'll understand the significance of temperature control. From checking, verifying, and recording temperature to using it to create culinary wonders, you'll be the conductor of the culinary orchestra, ensuring every note is pitch-perfect. Culinary Cleanliness: Your Armor in the Kitchen In this course, you'll master the art of personal hygiene. Imagine it as your armor, protecting both you and the dishes you create. You'll dive deep into personal cleanliness, ensuring your culinary creations are a testament to hygiene. Food Preservation and Equipment Mastery In the culinary world, you're not just a chef; you're an architect. Discover how to design food premises and select equipment that makes your kitchen a haven of safety. You'll understand food spoilage and preservation, ensuring every ingredient stays fresh. Safeguarding the Kitchen Domain In the world of culinary guardianship, waste disposal, cleaning, and disinfection are your tools of the trade. Like a master sculptor, you'll craft a pristine culinary environment that's free from pests and a shining example of cleanliness. The Key to a Safe Culinary Future With the Food Handlers Certificate Online, you're not just learning; you're embracing a career. You're not just safeguarding dishes; you're protecting the trust of diners. You're the reason they can savor their meals without worry. So, are you ready to embark on a career where taste meets trust, and every dish is a testament to safety? Join us in this culinary adventure, and you won't just earn a certificate; you'll become the guardian of culinary delights everywhere. Your journey into the world of food safety awaits! Learning Outcomes Understand the foundational principles of food safety and its importance. Gain insights into food safety legislation and its application in the industry. Recognise and manage contamination hazards efficiently. Master the methods to control and prevent bacterial food poisoning. Develop a thorough understanding of food temperature control and its verification. Explore the intricacies of food spoilage, preservation, and safe disposal methods. Attain proficiency in managing food allergens, understanding their implications and treatments. Delve into the principles and essentials of effective food labelling. Why Choose Our Food Handlers Certificate Online Course? Gain unlimited access to the course material indefinitely. Obtain a digital Certificate, Transcript, and student ID all-inclusive in the course fee. Rest assured, there are no hidden fees. Upon course completion, acquire CPD accredited qualifications. Benefit from one-to-one professional assistance every weekday. Instantly receive the PDF certificate upon successfully passing. Get your original certificate and transcript on the next working day. Learn with ease from the comfort of your home. Certification: Upon completing the course materials, a written assignment test is provided, which can be taken during or at the end of the course. Once you pass the test, you can claim the PDF certificate for £5.99. For original Hard Copy certificates, you can place an order at an additional cost of £9.60. Who is this Food Handlers Certificate Online course for? Aspiring food handlers aiming to join the food industry. Entrepreneurs venturing into the food business. Professionals in the food industry seeking to enhance their knowledge in safety measures. Managers overseeing food safety in restaurants, cafes, and catering services. Food consultants and auditors focused on quality assurance. Prerequisites: Enrolling in this Food Handlers Certificate Online doesn't necessitate any previous qualifications or experience. You can simply sign up and commence your learning journey. Crafted by professionals, this Food Handlers Certificate Online is compatible with a wide range of devices, including PCs, Macs, tablets, and smartphones. You'll have the flexibility to access the course from any location at any time, provided you have a stable internet connection. Career path Food Safety Auditor: £25,000 - £40,000 Food Quality Assurance Manager: £30,000 - £55,000 Restaurant Manager: £20,000 - £45,000 Food Labelling Specialist: £22,000 - £50,000 Pest Control Technician in Food Industry: £18,000 - £35,000 Food Safety Trainer: £24,000 - £48,000 Course Curriculum Module 01: Food Safety - Introduction Food Safety - Introduction 00:30:00 Module 02: Supervision of Food Safety Supervision of Food Safety 00:34:00 Module 03: Food Safety Legislation Food Safety Legislation 00:33:00 Module 04: Food Safety Management Systems Food Safety Management System 00:41:00 Module 05: Contamination Hazards Contamination Hazards 00:28:00 Module 06: Controlling Contamination Controlling Contamination 00:39:00 Module 07: Bacterial Food Poisoning and Food-Borne Illness Bacterial Food Poisoning and Food-Borne Illness 00:32:00 Module 08: Personal Hygiene Personal Hygiene 00:25:00 Module 09: Food and Temperature Control Food and Temperature Control 00:31:00 Module 10: Checking, Verifying and Recording Temperature Checking, Verifying and Recording Temperature 00:25:00 Module 11: Food Spoilage and Preservation Food Spoilage and Preservation 00:38:00 Module 12: Food Premises and Equipment: The Design and Construction Food Premises and Equipment: The Design and Construction 00:30:00 Module 13: Waste Disposal, Cleaning, and Disinfection Waste Disposal, Cleaning and Disinfection 00:35:00 Module 14: Pest Management Pest Management 00:29:00 Module 15: Food Safety Training for the Staff Food Safety Training for the Staff 00:29:00 Module 16: Basics of Food Allergens Basics of Food Allergens 00:16:00 Module 17: Allergen Guidance for Food Businesses Allergen Guidance for Food Businesses 00:24:00 Module 18: Allergic Reactions and Treatments Allergic Reactions and Treatments 00:23:00 Module 19: Introduction to Food Labelling Introduction to Food Labelling 00:16:00 Module 20: General Principles of Food Labelling General Principles of Food Labelling 00:24:00

Unlock the secrets to landing your dream mechanical engineering job. Our Crack Your Mechanical Engineer Interview course equips you with the essential knowledge and interview techniques to impress employers. From fundamental mechanical engineering principles to in-demand industry specialisations, gain the confidence to ace your interview and launch a fulfilling career. Learning Outcomes: Master foundational mechanical engineering concepts. Explore diverse fields like manufacturing and material science. Gain a solid understanding of strength of materials and theory of machines. Delve into automotive engineering and fluid mechanics. Solidify your grasp of thermodynamics, RAC & HMT. Why buy this Crack Your Mechanical Engineer Interview course? 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. Certification After studying the course materials of the Crack Your Mechanical Engineer Interview there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? Individuals seeking mechanical engineer jobs. Graduates with a mechanical engineering degree. Professionals aiming to transition into mechanical engineering. Aspiring engineers seeking a strong foundation in the field. Anyone interested in understanding mechanical engineering concepts. Prerequisites This Crack Your Mechanical Engineer Interview does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Crack Your Mechanical Engineer Interview was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Mechanical Engineer: £30,000 - £60,000 Per Annum Design Engineer: £35,000 - £70,000 Per Annum Production Engineer: £32,000 - £58,000 Per Annum Maintenance Engineer: £30,000 - £55,000 Per Annum Project Engineer: £40,000 - £80,000 Per Annum Manufacturing Engineer: £38,000 - £65,000 Per Annum Course Curriculum Section 01: Introduction Scope of the course 00:03:00 Section 02: Basic Mechanical Engineering (BME) Introduction to Basic Mechanical Engineering 00:02:00 Explain the term torque 00:03:00 State Archimedes Principle 00:02:00 What is the importance of tolerance in engineering? 00:04:00 Explain different types of fits 00:03:00 Section 03: Manufacturing & Material Science Introduction to Manufacturing & Material Science 00:01:00 Define pitting 00:03:00 Distinguish Between A Jig And Fixture 00:03:00 Explain knurling 00:03:00 Why is heat treatment of steel metal crucial? 00:03:00 What is extruded aluminium? 00:02:00 What do you mean by annealing? 00:04:00 How is martensite structure formed in steel? 00:04:00 Section 04: Strength Of Material (SOM) Introduction to Strength Of Material 00:01:00 Define a uniformly distributed load 00:04:00 Define Buckling Factor 00:02:00 Is it the stress that produces strain or vice-versa 00:04:00 What is the value of modulus of elasticity of steel? 00:03:00 What is Stress Concentration? 00:03:00 Section 05: Theory Of Machine (TOM) Introduction to Theory Of Machine 00:01:00 What is gear ratio? 00:01:00 What do you mean by cotter joint 00:04:00 What are the advantages of Gear drive? 00:04:00 What are the benefits of cycloidal gears? 00:03:00 Section 06: Automobile Engineering Introduction to automobile engineering 00:01:00 What are the various types of brakes? 00:03:00 Differentiate between scavenging and supercharging 00:03:00 In IC engine, which part is known as column? 00:03:00 What causes white smoke in two-stroke locomotive engines? 00:03:00 What is the difference between turbochargers and superchargers? 00:02:00 Section 07: Fluid Mechanics (FM) Introduction to Fluid Mechanics 00:01:00 Explain The Difference Between Rotational And Irrotational Flow? 00:03:00 Navier Stokes Equation Represents The Conservation Of Which Quantity? 00:03:00 What are major and minor head losses in a fluid flow system? 00:03:00 What is a Newtonian fluid? 00:05:00 What are the differences between elbows and bends? Which has greater head losses? 00:05:00 What is the ratio of the thickness of TBL to the thickness of HBL? 00:03:00 Section 08: Thermodynamics Introduction to Thermodynamics 00:01:00 What is the second law of thermodynamics? 00:04:00 What is the difference between the heat engine & heat pump? 00:05:00 Section 09: RAC & HMT Introduction to RAC & HMT 00:01:00 What is Refrigeration? What is the unit of refrigeration? 00:03:00 Which Cycle is used in Air Refrigeration System? 00:02:00 What do you mean by emissive power? 00:02:00 What is Under-cooling or Sub-cooling of refrigeration system? 00:03:00 Explain mechanical refrigeration 00:02:00 What is heat transfer co-efficient? 00:01:00 Section 10: Miscellaneous What is the advantage of using pneumatic? 00:03:00 Define least count and how to calculate for vernier callipers? 00:02:00 Why do you need a biological shield in nuclear plants? 00:03:00 What Is The Value Of Coefficient Of Friction For Ball Bearing? 00:02:00