Embarking on a journey through the realm of electrical substations, the 'Electrical Engineering for Electrical Substations' course illuminates the path for aspiring electrical engineers. Imagine plunging into the intricacies of electrical substations, a pivotal component in our electrified world. This course offers a unique blend of theoretical knowledge and practical insights, vital for anyone keen on mastering the core elements of electrics and electronics. From the fundamentals in Unit 1, diving into the design of earthing systems in Unit 2, to the nuanced introduction to substation design in Unit 3, students are equipped with a comprehensive understanding of this specialised field. Moreover, the course is an opportunity to enhance one's prospects in various electrical engineering jobs, paving the way for a lucrative career. The course builds a strong foundation in electrical engineering principles and opens doors to diverse opportunities such as electrical engineering apprenticeships. It serves as a stepping stone for those seeking to delve deeper into the field, potentially leading to roles in designing and managing the heart of electrical systems - the substations. This is more than just an educational journey; it's a route to a rewarding career marked by competitive electrical engineering salaries and fulfilling job roles. For those fascinated by the latest technological advancements, the course touches upon the electrifying world of electric car engines, integrating modern innovation with traditional electrical engineering concepts. This unique blend of old and new prepares learners for a future where electrical engineering expertise is valued and essential. Imagine being at the forefront of this exciting field, where every day brings new challenges and opportunities. Learning Outcomes Gain a comprehensive understanding of the basics of electrical substations. Acquire knowledge in designing effective earthing systems. Learn the principles of substation design and management. Develop an appreciation of the integration between traditional electrical engineering and modern innovations like electric car engines. Prepare for a diverse range of electrical engineering roles in various sectors. Why buy this Electrical Engineering for Electrical Substations? 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 Electrical Engineering for Electrical Substations 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 Electrical Engineering for Electrical Substations course for? Individuals aspiring to become electrical engineers. Professionals seeking to expand their knowledge in substation design and management. Students interested in pursuing a career in electrical engineering. Technicians aiming for an electrical engineering apprenticeship. Anyone interested in the technological aspects of electric car engines. Prerequisites This Electrical Engineering for Electrical Substations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Electrical Engineering for Electrical Substations 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 Electrical Engineer: Average Salary £28,000 - £40,000 annually Substation Design Engineer: Average Salary £32,000 - £48,000 annually Electrical Project Manager: Average Salary £35,000 - £55,000 annually Senior Electrical Engineer: Average Salary £40,000 - £60,000 annually Electrical Engineering Technician: Average Salary £25,000 - £35,000 annually Renewable Energy Engineer: Average Salary £30,000 - £45,000 annually Course Curriculum Electrical Engineering for Electrical Substations Unit 1: Basics of Electrical Substations Module 1: Introduction To Electrical Substation 00:06:00 Module 2: Construction of Electrical Substation and Transformers 00:09:00 Module 3: Instrument Transformers and Principle of Operation of Trip Circuit 00:13:00 Module 4: Types Of Circuit Breakers And Fuses 00:23:00 Module 5: Types of Relays According to Function, Construction and Time Characteristics 00:06:00 Module 6: Definition of Busbar and Its Schemes 00:17:00 Module 7: Construction of Underground Cables 00:10:00 Module 8: Construction of Overhead Transmission Lines 00:15:00 Module 9: Comparison between Underground Cables and Overhead Transmission Lines@ 00:05:00 Module 10: Types of Switches In Power System and Substations 00:08:00 Module 11: Importance of Capacitor Banks in Power System 00:08:00 Module 12: Other Important Components in Electrical Substation 00:07:00 Module 13: Classification of Substations 00:05:00 Module 14: Relation between Voltage and Substations 00:02:00 Module 15: Air Insulated Substation and Gas Insulated Substation 00:09:00 Module 16: Importance of Ring Main Unit in Power System 00:07:00 Module 17:Extra Images 00:01:00 Unit 2: Design of Earthing System Module 1: Effect of Current on Human Body 00:09:00 Module 2: Types of Electric Hazards 00:08:00 Module 3: Classification of Earthing Systems 00:24:00 Module 4: Components of Earthing System 00:09:00 Module 5: Design and Resistance of Earthing Electrode 00:12:00 Module 6: Design and Resistance of Earthing Conductor 00:13:00 Module 7: Earth Resistance by Megger and Three Point Method 00:03:00 Module 8: Design Earthing or Ground Grid Using ETAP 00:21:00 Unit 3: Introduction to Design of Substation Module 1: What Ip or Ingress Protection 00:05:00 Module 2: Selection of Busbars in Electrical Substation 00:11:00 Module 3: Design of Substations 00:19:00 Module 4: Single Line Diagram of 66 to 11kv Substation 00:20:00 Assignment Assignment -Electrical Engineering for Electrical Substations 00:00:00
Ever dreamed of gliding over your keyboard with ease, letting your fingers dance to a rhythm only they know? Welcome to the Touch Typing Essentials at QLS Level 3 course, the quintessential guide to mastering the art of touch typing. As the digital age progresses, the ability to touch type swiftly and accurately has become a skill of paramount importance. Whether you're penning an email or taking a touch typing test, proficiency in this area ensures speed, efficiency, and a professional edge. If you're eager to learn to touch type, this course meticulously takes you through each letter, punctuation mark, and common combination, ensuring a comprehensive understanding and impeccable technique. Why buy this Touch Typing Essentials at QLS Level 3 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 Touch Typing Essentials at QLS Level 3 course for? Beginners seeking a structured introduction to touch typing. Writers, journalists, and bloggers aiming for faster content production. Office professionals striving to enhance productivity and efficiency. Students wishing to improve their typing skills for academic projects. Anyone looking to add a valuable skill to their personal and professional toolkit. Career path Data Entry Clerk: Average Salary - £18,000 to £23,000 per annum. Transcriptionist: Average Salary - £20,000 to £25,000 per annum. Administrative Assistant: Average Salary - £17,000 to £22,000 per annum. Copywriter: Average Salary - £23,000 to £29,000 per annum. Executive Assistant: Average Salary - £26,000 to £35,000 per annum. Legal Secretary: Average Salary - £20,000 to £28,000 per annum. Prerequisites This Touch Typing Essentials at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Touch Typing Essentials at QLS Level 3 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 £85 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 Introduction Promo 00:04:00 Course Overview 00:12:00 How to Set up Your Computer Understanding the Keyboard Layout 00:03:00 How to set up input languages - for Mac 00:09:00 How to set up input langauges - for Windows 00:12:00 How to type the letters F and J How to correctly place your fingers on the keyboard 00:07:00 How to type the letters F and J 00:04:00 How to type the letters D and K How to type the letters D and K 00:04:00 How to type the letters S and L How to type the letters S and L 00:03:00 How to type the letter A and ; (semicolon) How to type the letter A and semicolon 00:04:00 How to type the letters E and I How to type the letters E and I 00:04:00 How to type the letters R and U How to type the letters R and U 00:04:00 How to type the letters T and O How to type the letters T and O 00:04:00 How to type CAPITAL letters How to type CAPITAL letters 00:05:00 How to type the letter C and , (Comma) How to type the letter C and , (Comma) 00:04:00 How to type the letters G and H How to type the letters G and H 00:03:00 How to type the letters N and V How to type the letters N and V 00:03:00 How to type the letters W and M How to type the letters W and M 00:04:00 How to type the letters Q and P How to type the letters Q and P 00:04:00 How to type the letters B and Y How to type the letters B and Y 00:03:00 How to type the letters Z and X How to type the letters Z and X 00:04:00 How to type Colon and Semicolon How to type Colon and Semicolon 00:03:00 How to type Full Stop and Comma How to type Full Stop and Comma 00:03:00 How to type Question Mark and Exclamation Mark How to type Question Mark and Exclamation Mark 00:04:00 How to type Dash, Parentheses and Quotation Marks How to type Dash, Parentheses and Quotation Marks 00:07:00 Resources Resource - Touch Typing Essentials 00:00:00 Assignment Assignment - Touch Typing Essentials at QLS Level 3 01:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00
Embark on a transformative learning journey with our 'Read Construction & Structural Drawing Like Expert' course, meticulously crafted for those with a zeal to decode the intricate language of architectural blueprints. This course unlocks the gateway to understanding the complex layers of G+3 residential building designs. From the foundational footing layout to the sophisticated slab reinforcements, you will be guided through the arcane world of construction drawings, emerging with the knowledge to navigate this technical terrain with ease and precision. The curriculum is an architect's treasure map, leading you from the initial sketches of a residential project to the high-level detailing required for successful execution. As you traverse the course, you will witness the fusion of theory and practice with site videos, unraveling the real-world applications of structural drawings. You'll not only learn the principles of Vastu in planning but also grasp the nuances of load calculations and material specifications, all geared towards equipping you with a keen eye for structural details and the skill to interpret them expertly. Learning Outcomes Interpret architectural and structural drawings of multi-story residential buildings with clarity. Apply the principles of Vastu Shastra in building design and planning. Analyze load calculations and material requirements for construction projects. Develop the ability to detail beams, columns, and slabs from structural analysis results. Synthesize practical construction knowledge with technical drawing acumen. Why choose this Read Construction & Structural Drawing Like Expert 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 Read Construction & Structural Drawing Like Expert 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 Read Construction & Structural Drawing Like Expert course for? Aspiring construction professionals eager to master architectural drawing interpretation. Civil engineers seeking to refine their understanding of multi-story building structures. Architects looking to align design concepts with structural integrity. Technical draftspersons aiming to enhance their detailing capabilities. Project managers and site supervisors wishing to bridge the gap between drawings and physical construction. Career path Construction Project Manager: £35,000 - £70,000 Architectural Technologist: £25,000 - £50,000 Structural Engineer: £28,000 - £55,000 Building Surveyor: £22,000 - £50,000 CAD Technician: £20,000 - £40,000 Site Engineer: £25,000 - £50,000 Prerequisites This Read Construction & Structural Drawing Like Expert does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Read Construction & Structural Drawing Like Expert 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: Architectural & Structural Drawings of G+3 Residential Building Reading The Architectural Plan of G+3 Residential Building & Planning It 00:36:00 Understanding To Read Footing Layout drawing Of G+3 Building 00:31:00 Learn to Read Footing Schedule and Reinforcement Drawing of G+3 Building 00:24:00 How Combined Footing Reinforcement Is given practically at Site & What is Chair 00:26:00 Learn To Read Column Layout & Column Schedule Drawings of G+3 Building 00:14:00 Learn to Read Column Reinforcement & Column Lateral Ties & SP-34 Detailing 00:49:00 Video Explaining depth of footing, PCC, Development Length & Column Placing 00:16:00 What is Vastu & How this G+3 Building Is planned According to vastu Theory 00:38:00 Plinth Beam Layout, How to Frame Plinth Beam layout & Understand Reinforcement 00:20:00 Practical Video of Plinth Beam Reinforcement, Shuttering & Concreting 00:07:00 Learn First Floor Shuttering Layout & Slab Centering Layout with Site Videos 00:19:00 Learn to Read 1st Floor Beam Reinforcements of a G+3 Residential Building 00:24:00 Practical Video Of Beam Reinforcement and Extra Bar Provided in Beam R/F 00:06:00 Difference Between 1-way Slab & 2-way Slab 00:35:00 Practical Video of How Crank Bars are Put Up In The Slab 00:22:00 Theory of 2 way Slab & Its Importance & How it is Provided Practically at Site 00:32:00 Learn to Read slab 1st Floor Slab Reinforcement Details & Slab practical Video 00:26:00 Second Floor Shuttering Layout & Minor Changes With Respect to 1st Floor Layout 00:18:00 Second Floor Beam Details & Theory Behind Extra Bar at Support ( MUST WATCH ) 00:29:00 Second Floor Slab Details & Theory Behind Simply Supported & fixed Support Slab 00:25:00 Third-floor Slab shuttering Layout, Beam Details & Slab Reinforcement Details 00:11:00 Terrace Floor Plan & Head Room Architectural & Structural Details. 00:13:00 Section 02: Etabs Model of G+3 Residential Building Learn How the G+3 Residential Building is Modeled On E tabs Software 00:15:00 How to Define Beam, Column & Slab Sizes in the Etabs Model 00:23:00 How Dead Load & Live loads are calculated practically and Applied On The Slab 00:28:00 How to Apply Wall load on Beams & How to calculate Wall Load Manually 00:22:00 How to Create Load Pattern & Load Combinations in Etabs 00:21:00 How to check Footing Reaction & How to Size the footing Using excel Sheets 00:39:00 Check Bending Moment of Beam & understand it with Structural drawings 00:16:00 Detailing of Beam from Etabs Results & Excel Sheet Values 00:19:00 Detailing Of Stirrups, Spacing between stirrups & Logic Behind Providing Them 00:17:00 Column Detailing Manually & with Excel Sheet from Etabs Results 00:13:00
Join us on a thought-provoking trip into the core of technology with our 'Embedded Systems with 8051 Microcontroller' course. Picture yourself unraveling the mysteries of embedded systems and delving into the intricacies of the 8051 microcontroller. This course is not just a series of modules; it's an odyssey into the world of programming, interfacing, and innovation. From the foundational concepts of embedded systems to the nitty-gritty of program creation for the 8051, each module is a stepping stone towards mastery. Imagine crafting projects that involve LED alternations, switch interfacing, and even the precise control of DC motors and relays. Join us, and let the 8051 microcontroller be your passport to unlocking a realm where circuits come to life, timers dictate precision, and serial communication is your language of control. As you progress through units on LCD and ADC interfacing, envision yourself creating schematics, writing code, and connecting with the essence of each concept. This course transcends theoretical knowledge, offering hands-on experience in program downloading using Nuvoton ICSP programmer and FlashMagic. The journey concludes not just with a module on conclusions but with a sense of empowerment, equipped with the skills to conquer the intricate world of embedded systems. Learning Outcomes Master the fundamentals of embedded systems, from the basics to the intricate workings of the 8051 microcontroller. Acquire proficiency in software installation, including the setup of the Keil IDE and the creation of initial projects. Develop expertise in input and output interfacing, covering LED concepts, for loops, and switch interfacing with the 8051. Explore advanced concepts, such as DC motor and relay interfacing, LCD concepts, and serial communication principles. Gain hands-on experience in timer concepts, timer as a counter, and analog-to-digital conversion with the LM35 temperature sensor, along with the practical skills of program downloading. Why choose this Embedded Systems with 8051 Microcontroller 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 Embedded Systems with 8051 Microcontroller course for? Electronics enthusiasts eager to delve into embedded systems and microcontroller programming. Students and beginners seeking a comprehensive understanding of 8051 microcontroller applications. Hobbyists with a keen interest in hands-on projects involving LEDs, switches, motors, and more. Aspiring engineers looking to enhance their skills in the field of embedded systems. DIY enthusiasts interested in crafting innovative projects with practical applications. Career path Embedded Systems Engineer: £40,000 - £60,000 Electronics Design Engineer: £35,000 - £55,000 Control Systems Engineer: £40,000 - £65,000 Microcontroller Programmer: £30,000 - £50,000 Hardware Development Engineer: £35,000 - £60,000 Automation Specialist: £45,000 - £70,000 Prerequisites This Embedded Systems with 8051 Microcontroller does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Embedded Systems with 8051 Microcontroller 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 Module 01: Introduction to the Course 00:03:00 Module 02: Introduction to Embedded Systems 00:20:00 Module 03: Introduction to 8051 Controller 00:15:00 Module 04: Program for 8051 00:13:00 Unit 02: Software Installation Module 01: Installation of Keil IDE 00:05:00 Module 02: First Project creation on Keil 00:05:00 Unit 03: Input And Output Interfacing Module 01: Concepts on LED 00:12:00 Module 02: Project based on Led Alternate on off 00:04:00 Module 03: Using For Loop 00:05:00 Unit 04: 8051 Interfaces Module 01: Switch Interfacing with 8051 00:13:00 Unit 05: Interfacing With DC Motor And Relay Module 01: Relay Interfacing 00:11:00 Module 02: Relay Interfacing Part 2 00:03:00 Module 03: Introduction to DC Motor 00:09:00 Module 04: DC Motor Interfacing Part 2 00:07:00 Unit 06: Concepts On LCD Module 01: Introduction to LCD 00:09:00 Module 02: Creating Schematics for LCD 00:07:00 Module 03: First Program on LCD 00:07:00 Module 04: LCD Interfacing - 4 00:08:00 Unit 07: Concepts On Serial Module 01: Serial Part-01 00:07:00 Module 02: Serial Part-02 00:13:00 Module 03: Serial Part-03 00:08:00 Module 04: Serial Part-04 00:08:00 Unit 08: Timer Concepts Module 01: Timer Part-01 00:08:00 Module 02: Timer Part-02 00:07:00 Module 03: Timer Part-03 00:06:00 Unit 09: Timer As Counter Module 01: Timer as Counter 00:08:00 Unit 10: ADC With LM35 Module 01: Analog to Digital Converter with 8051 - Part 1 00:10:00 Module 02: Analog to Digital Converter with 8051 - Part 2 00:07:00 Module 03: Analog to Digital Converter with 8051 - Part 3 00:10:00 Module 04: Analog to Digital Converter with 8051 use LM35 Temperature Sensor 00:11:00 Unit 11: Stepper Motor And Program For Stepper Motor Module 01: Concepts around Stepper Motor [34] 00:15:00 Unit 12: Program Downloading Module 01: Program Downloading Using Nuvoton ICSP Programmer 00:09:00 Module 02: Program (Hex File) Downloading using FlashMagic to P89v51RD2 Controller 00:16:00 Unit 13: Conclusion Conclusion 00:01:00
The 'Learn the Art and Science of PCB Design with Eagle' course provides a comprehensive journey into the world of printed circuit board (PCB) design. PCBs are the backbone of modern electronics, and understanding how to design them is crucial for anyone interested in electronics and engineering. This course covers everything from the basics of software installation and library management to advanced techniques like double-sided PCB design and surface-mount technology (SMT) component integration. By the end of this course, you'll have the knowledge and skills to create your own PCBs for various electronic applications. In today's tech-driven world, the ability to design PCBs is a highly valuable skill. Whether you're an electronics hobbyist, a student, or a professional in the field, this course is designed to empower you with the essential skills required to bring your electronic ideas to life through PCB design. You'll gain the confidence to create custom PCBs for personal projects or even pursue a career in electronics engineering. Don't miss this opportunity to unlock the potential of PCB design and enhance your knowledge in this exciting field. Learning Outcomes Gain an understanding of PCB design principles and terminology. Install and set up Eagle software to create your first project. Learn how to create and manage libraries for schematic components. Master single-sided PCB design techniques for basic projects. Progress to designing more complex double-sided PCBs. Acquire knowledge of surface-mount technology (SMT) components. Develop the ability to create custom library components in Eagle. Explore the use of the Autorouter for efficient PCB routing. Efficiently copy frequently used parts into your component library. Understand the manufacturing process and guidelines for PCB production. Who is this course ideal for? Electronics enthusiasts and hobbyists looking to expand their skills. Students in engineering, electronics, or related fields. Professionals seeking to enhance their skill set or transition into electronics. Individuals interested in creating custom PCBs for personal projects. Anyone looking to explore the fascinating world of PCB design. Why Choose This 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. Career Path PCB Design Engineer: £25,000 - £50,000 Electronics Engineer: £30,000 - £60,000 Embedded Systems Engineer: £35,000 - £70,000 Hardware Design Engineer: £30,000 - £55,000 Electronics Technician: £20,000 - £40,000 Prerequisites No prior qualifications or experience are necessary for this 'Learn the Art and Science of PCB Design with Eagle' course. It is designed to be accessible to individuals of all backgrounds. The course is compatible with various devices, including PCs, Macs, tablets, and smartphones, and can be accessed from anywhere with an adequate internet connection. Certification Upon successful completion of the course, you can take a written assignment test. After passing the test, you can obtain a PDF certificate for a fee of £4.99. If you prefer a physical certificate, hard copies can be ordered for an additional cost of £8. Course Curriculum Unit 01: Introduction Module 01: Introduction 00:01:00 Module 02: Basics of Printed Circuit Board (Important) 00:13:00 Unit 02: Software Installation and Creating First project Module 01: Eagle Software Installation 00:04:00 Module 02: Creating Project with Eagle 00:05:00 Unit 03: Library and Schematic Module 01: Creating Schematic with Eagle 00:09:00 Module 02: Eagle Installing External Libraries 00:06:00 Module 03: Update: Directly adding External Libraries online 00:03:00 Unit 04: Single Sided PCB Design Module 01: Create First Complete Schematic in Eagle 00:07:00 Module 02: First PCB Layout, the proper placement of component 00:05:00 Module 03: Create First Single Sided PCB with Eagle 00:07:00 Module 04: Adding Name and Labels to Eagle Schematics 00:06:00 Unit 05: Creating PCB Project Module 01: Microcontroller PCB Project with Eagle Part 1 00:06:00 Module 02: Microcontroller PCB Project with Eagle Part 2 00:09:00 Module 03: Microcontroller PCB Project with Eagle Part 3 00:05:00 Unit 06: Copper Pour Module 01: Adding Copper Pour to Eagle PCB 00:06:00 Unit 07: Double Sided PCB Design Module 01: Double Sided PCB Design with Eagle 00:05:00 Module 02: Double Sided PCB Design (Hands On) 00:09:00 Unit 08: All about SMT Components Module 01: Surface Mount Devices in Eagle 00:08:00 Module 02: SMT based Schematic (FTDI Project) 00:11:00 Module 03: SMT and Double Sided PCB Design 00:09:00 Unit 09: Create Custom Library Component in Eagle Module 01: Eagle Create Custom Library Part 1 00:14:00 Module 02: Eagle Create Custom Library Part 2 00:08:00 Module 03: Eagle Create Custom Library Part 3 00:07:00 Unit 10: Using Autorouter (Cheating the Software!!!) Module 01: Use Autorouter for single sided PCB 00:05:00 Module 02: Use Autorouter for Double sided PCB 00:01:00 Unit 11: Copy frequently required parts in your library Module 01: Copy frequently required parts in your library 00:03:00 Unit 12: Manufacturing Guide Module 01: Print a Single Sided PCB 00:05:00 Module 02: Gerber File Extraction 00:03:00 Module 03: Generate Bill of Materials 00:02:00 Unit 13: Solution Videos, added as per requests Module 01: PCB Artwork of Electronic Cricket Match Circuit 00:11:00 Unit 14: Ending Notes Module 01: Eagle Current Calculation 00:08:00 Module 02: Conclusion 00:01:00 Assignment Assignment - Learn the Art and Science of PCB Design with Eagle 00:00:00
Embark on a journey to master the healing touch with our Massage Therapy course, meticulously crafted to guide you through the ancient art and science of manual healing. From the initial touchpoint, where you explore the rich tapestry of massage history, to the advanced techniques that address specific muscular and stress-related concerns, this course is a labyrinth of knowledge, waiting to be unravelled by those with a passion for wellness. The curriculum is designed to traverse various modalities, from the tranquillity of Indian head massages to the invigorating Thai foot massage, ensuring a holistic approach to the discipline. Learning Outcomes Gain an in-depth understanding of the human body's tissues, organs, and neuromuscular systems as they relate to massage therapy. Develop proficiency in a diverse range of massage techniques including Swedish, sports, and prenatal massage. Learn to blend the science of aromatherapy with massage practices for enhanced therapeutic benefits. Acquire skills in acupressure application and the methodical approach to locating pressure points for targeted relief. Understand the business aspects of massage therapy, from starting your practice to marketing and building a client base. Why choose this Massage Therapy 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 Massage Therapy 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 Massage Therapy course for? Aspiring therapists wishing to enter the realm of holistic health and wellness. Practitioners desiring to expand their repertoire with specialised massage techniques. Wellness entrepreneurs aiming to establish or grow a therapeutic business. Individuals seeking to incorporate therapeutic touch and aroma into self-care routines. Healthcare professionals looking to integrate complementary massage therapies into their practices. Career path Massage Therapist - £19,000 to £25,000 Aromatherapist - £20,000 to £30,000 Reflexologist - £18,000 to £23,000 Holistic Health Practitioner - £25,000 to £35,000 Spa Manager - £24,000 to £40,000 Wellness Coach - £22,000 to £30,000 Prerequisites This Massage Therapy does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Massage Therapy 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 Massage Therapy Introduction to Massage Therapy 00:15:00 Massage History 00:15:00 The Role of A Massage Therapist 00:30:00 Tissues, Organs, & Neuromuscular systems 01:00:00 General Benefits of Massage 00:15:00 Indian Head Massage 00:15:00 Facial Massage 00:30:00 Neck Massage 00:30:00 Back Massage 00:30:00 Full Body Massage 00:15:00 Swedish Massage 00:15:00 Sports Massage 00:30:00 LomiLomi Massage 00:15:00 Anti-Cellulite Massage 00:15:00 Hot Stone Massage 00:30:00 Thai Foot Massage 00:15:00 Prenatal Massage 00:15:00 Medical Massage 01:00:00 Baby Massage 01:00:00 Trigger Point Therapy 01:00:00 Thai Massage 01:00:00 Reflexology 01:00:00 How A Massage Therapist Can Start A Business 01:00:00 Marketing Your Business 01:00:00 Complimentary Massages 00:15:00 Building Your Clientele 00:30:00 Other Ways To Market Your Business 01:00:00 Conclusion to Massage 00:15:00 Massage Therapy with Aroma What is Aromatherapy? 00:15:00 History of Aromatherapy 00:15:00 The Definition of Aromatherapy 00:15:00 What are Essential Oils? 00:15:00 Essential Oil Safety Information 00:15:00 Administration of Essential Oils 00:30:00 The Art of Blending 00:15:00 Blending Basics 00:15:00 Harmonizing Your Blend 00:30:00 Aromatherapy Baths 00:15:00 Aromatherapy for Stress 00:15:00 Aromatherapy for Children 00:14:00 Application of Essential Oils 00:15:00 Table of the Basic Methods of Use of Essential Oils 00:15:00 The Holistic Approach 00:30:00 Understanding Disease / Pathology 00:30:00 The Benefits of a Holistic Aromatherapy Treatment 00:15:00 Accupressure & Massage Acupressure 00:30:00 How Acupressure Works 00:30:00 Locating A Pressure Point 01:00:00 Acupressure Techniques 00:30:00 How To Apply Pressure 00:30:00 Breathing 00:30:00 Things To Be Careful Of 00:30:00 Acupressure For Specific Problems 00:30:00 If You Feel It's Not Working 00:15:00 Practical Self Massage 01:00:00 Handheld Massagers 00:30:00 Mock Exam Mock Exam - Massage and Aromatherapy course 00:30:00 Final Exam Final Exam - Massage and Aromatherapy course 00:30:00
The 'Web Application Penetration Testing' course is a comprehensive guide to identifying and mitigating vulnerabilities within web applications. Participants will learn the techniques and methodologies used by ethical hackers to assess and secure web applications against cyber threats. Covering topics such as cross-site scripting, SQL injection, authentication attacks, and more, this course equips learners with the knowledge and skills to perform effective penetration testing and enhance web application security. Learning Outcomes Understand the fundamentals of web application penetration testing and its importance in cybersecurity. Prepare for penetration testing activities, including setting up testing environments and tools. Explore web application technologies and their potential vulnerabilities. Learn the art of information gathering and mapping applications for vulnerability assessment. Master techniques to identify and exploit cross-site scripting (XSS) vulnerabilities. Why choose this Web Application Penetration Testing 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 Web Application Penetration Testing Course 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 Web Application Penetration Testing Course for? Ethical hackers and cybersecurity professionals aiming to specialize in web application security. IT professionals seeking to expand their knowledge in identifying and mitigating web application vulnerabilities. Web developers interested in understanding and addressing potential security risks in their applications. Penetration testers aiming to enhance their skillset in assessing and securing web applications. Career path Penetration Tester: £25,000 - £70,000 Ethical Hacker: £30,000 - £80,000 Application Security Analyst: £35,000 - £65,000 Cybersecurity Consultant: £40,000 - £90,000 Web Security Administrator: £32,000 - £68,000 Vulnerability Assessment Analyst: £28,000 - £60,000 Prerequisites This Web Application Penetration Testing Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Web Application Penetration Testing 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 Unit 01: INTRODUCTION About The Course 00:03:00 Unit 02: BE PREPARED Web Attack Simulation Lab 00:12:00 Unit 03: WEB APPLICATION TECHNOLOGIES Web application technologies 101 - PDF 01:34:00 HTTP Protocol Basics 00:11:00 Encoding Schemes 00:13:00 Same Origin Policy - SOP 00:06:00 HTTP Cookies 00:11:00 Cross-origin resource sharing 00:05:00 Web application proxy - Burp suite 00:09:00 Unit 04: INFORMATION GATHERING - MAPPING THE APPLICATIONS Fingerprinting web server 00:05:00 DNS Analysis - Enumerating subdomains 00:04:00 Metasploit for web application attacks 00:12:00 Web technologies analysis in real time 00:03:00 Outdated web application to server takeover 00:08:00 BruteForcing Web applications 00:06:00 Shodan HQ 00:07:00 Harvesting the data 00:05:00 Finding link of target with Maltego CE 00:09:00 Unit 05: CROSS-SITE SCRIPTING ATTACKS - XSS Cross Site Scripting- XSS - PDF 01:08:00 Cross site scripting 00:07:00 Reflected XSS 00:14:00 Persistent XSS 00:11:00 DOM-based XSS 00:10:00 Website defacement through XSS 00:09:00 XML Documents & database 00:14:00 Generating XSS attack payloads 00:13:00 XSS in PHP, ASP & JS Code review 00:13:00 Cookie stealing through XSS 00:12:00 Advanced XSS phishing attacks 00:08:00 Advanced XSS with BeEF attacks 00:10:00 Advanced XSS attacks with Burp suite 00:08:00 Code Review Guide 06:20:00 Unit 06: SQL INJECTION ATTACKS - EXPLOITATIONS SQL Injection attacks - PDF 01:30:00 Introduction to SQL Injection 00:16:00 Dangers of SQL Injection 00:05:00 Hunting for SQL Injection vulnerabilities 00:20:00 In-band SQL Injection attacks 00:27:00 Blind SQL Injection attack in-action 00:10:00 Exploiting SQL injection - SQLMap 00:09:00 Fuzzing for SQL Injection - Burp Intruder 00:14:00 Unit 07: CROSS SITE REQUEST FORGERY - XSRF CSRF or XSRF attack methods 00:12:00 Anti-CSRF Token methods 00:15:00 Anti-CSRF token stealing-NOT easy 00:11:00 Unit 08: AUTHENTICATION & AUTHORIZATION ATTACKS Authentication bypass-hydra 00:11:00 HTTP Verb Tampering 00:09:00 HTTP parameter pollution - HPP 00:06:00 Authentication 00:10:00 Unit 09: CLIENT SIDE SECURITY TESTING Client side control bypass 00:10:00 Unit 10: FILE RELATED VULNERABILITIES LFI & RFI attacks 00:13:00 Unrestricted file upload - content type 00:06:00 Unrestricted File Upload - Extension Type 00:06:00 Remote code execution using Shell Uploads 00:09:00 Unit 11: XML EXTERNAL ENTITY ATTACKS - XXE XML Documents & database 00:14:00 XXE attacks in action 00:14:00 Resources Advance intruder attack types 00:23:00 Finding details with open source 00:17:00 Assignment Assignment - Web Application Penetration Testing Course 00:00:00
Welcome to Trigonometry Basics, your key to unlocking the magic of mathematics! This course is not just about numbers; it's about empowering you with skills that open doors to exciting possibilities. Imagine conquering the world of triangles, circles, and real-world problem-solving like a mathematical superhero! In Trigonometry Basics, you won't just memorise formulas; you'll journey through engaging modules, discovering the secrets of the unit circle, cracking the code of right triangles, and unleashing the power of polar coordinates. This isn't just a course; it's your ticket to mastering math and gaining a superpower that's invaluable in science, engineering, and beyond. Whether you're gearing up for a STEM career, diving into the wonders of mathematics, or simply curious about how trigonometry shapes our world, this course is your guide. It's not just about passing tests; it's about unleashing your inner problem-solving hero! So, are you ready to transform triangles from puzzling to powerful? Let's dive into the world of Trigonometry Basics! Learning Outcomes Understand the foundational principles of trigonometry. Apply the unit circle approach to solve trigonometric problems. Demonstrate proficiency in solving trigonometry using right triangles. Analyse and solve complex problems using analytic trigonometry. Gain competence in working with polar coordinates. Utilise trigonometric concepts in real-world problem-solving scenarios. Apply acquired knowledge through practical assignments effectively. Develop a strong foundation for advanced mathematical concepts. Who is this course for Students seeking to strengthen their mathematical fundamentals. Individuals pursuing careers in engineering or physical sciences. Enthusiasts interested in the practical applications of trigonometry. Professionals looking to enhance problem-solving skills. Anyone preparing for further studies in mathematics or related fields. Why Choose This 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. Career Path Engineering roles (e.g., Mechanical Engineer): £25,000 - £50,000. Data Analyst: £20,000 - £40,000. Computer Programmer: £25,000 - £45,000. Physics Research Assistant: £22,000 - £35,000. Mathematics Teacher: £25,000 - £40,000. Certification Upon completion of the Trigonometry Basics course, a written assignment test is available, which can be taken during or at the course's conclusion. After successfully passing the test, learners have the opportunity to obtain a downloadable PDF certificate for a fee of £4.99. Alternatively, an original hard copy certificate can be ordered at an additional cost of £8. Prerequisites No prior qualifications or experience are necessary for enrollment in the Trigonometry Basics course. This program, crafted by industry professionals, is compatible with PCs, Macs, tablets, and smartphones. Accessibility is ensured, allowing learners to engage with the course from any location, provided there is a reliable internet connection. Course Curriculum Course Promo Course Promo 00:02:00 Module 01: Fundamentals Number Tools 00:10:00 Graphing Tools 00:06:00 The Coordinate Plane 00:06:00 Module 02: Trigonometry Unit Circle Approach Introduction 00:01:00 The Unit Circle 00:08:00 Terminal Points 00:31:00 Reference Number 00:22:00 Trigonometric Functions 00:12:00 Evaluating Trigonometric Functions 00:14:00 Graph of Sine & Cosine 00:24:00 Sine & Cosine Graph Transformations 00:17:00 Tangent & Cotangent Graphs 00:20:00 Secant & Cosecant Graphs 00:25:00 Domain and Range of Sin, Cos and Tan 00:22:00 Examples 00:13:00 Domain and Range of Sec, Csc and Cot 00:13:00 Examples 00:16:00 Module 03: Trigonometry: Right Triangle Approach Introduction 00:01:00 Angles 00:16:00 Standard Position 00:08:00 Trigonometric Ratios 00:15:00 Examples 00:13:00 Special Angles 00:24:00 Examples 00:05:00 Reference Angle 00:14:00 Evaluating Trig Functions and Points 00:18:00 Inverse Trigonometric Functions 00:12:00 The Law of Sines 00:13:00 The Law of Cosines 00:10:00 Area of a Triangle 00:08:00 Module 04: Analytic Trigonometry Introduction 00:01:00 Fundamental Identities 00:10:00 Examples 00:18:00 Addition and Subtraction Formulas 00:15:00 Sums of Sines and Cosines 00:07:00 Double Angle Formulas 00:10:00 Half Angle Formulas 00:08:00 Formulas for Lowering Powers 00:05:00 Sum-to-Product Formulas 00:06:00 Product-to-Sum Formulas 00:05:00 Module 05: Polar Coordinates Polar Coordinates 00:19:00 Polar and Rectangular Coordinates 00:11:00 Polar Equations 00:07:00 Graph of Polar Equations 00:18:00 Symmetry 00:17:00 Common Polar Curves 00:12:00 Graphing Complex Numbers 00:06:00 Modulus 00:04:00 Polar Form of Complex Numbers 00:09:00 Multiplication and Division 00:07:00 De Moivre's Theorem 00:05:00 nth Roots of a Complex Number 00:21:00 Resources Resource - Trigonometry Basics 00:00:00 Assignment Assignment - Trigonometry Basics 00:00:00
Do you love fitness and want to make a difference in people's lives? Our Personal Trainer / Fitness Instructor course offers that opportunity. Many people struggle to find fitness guidance, and this course addresses that issue by giving you the knowledge and skills to help them effectively. In today's health-conscious world, becoming a certified fitness professional means more than just a job; it's about inspiring hope. With this course, you'll understand human anatomy deeply, enabling you to create effective fitness programs. You'll be the guide who helps clients achieve their goals, improving their well-being and confidence. Enrolling in our Personal Trainer / Fitness Instructor course is not just a choice; it's a commitment to creating a positive impact. Witnessing your clients' transformations, both physically and mentally, will be immensely satisfying. This career offers emotional and financial rewards, an investment in your future, and in the lives you'll change. Join our course, become a certified fitness professional, and take the first step toward a fulfilling career. Learning Outcomes Understand human anatomy for effective exercise prescription. Perform client assessments to tailor fitness programs. Master resistance training techniques for muscle development. Access exercise instruction videos for practical knowledge. Design cardio and endurance programs for diverse clients. Enhance flexibility and mobility through targeted exercises. Complete a written assignment to reinforce learning.. Why choose this Personal Trainer / Fitness Instructor 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 Personal Trainer / Fitness Instructor course for? Aspiring fitness enthusiasts eager to become certified trainers. Individuals seeking a flexible, accessible learning experience. Career changers looking to make a positive impact on clients' lives. Fitness enthusiasts interested in anatomy and exercise science. Anyone with a passion for health and wellness. Career path Fitness Instructor: £18,000 - £30,000 per year. Personal Trainer: £20,000 - £45,000 per year. Gym Manager: £25,000 - £35,000 per year. Wellness Coach: £25,000 - £45,000 per year. Physical Therapist: £25,000 - £50,000 per year. Prerequisites This Personal Trainer / Fitness Instructor does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Personal Trainer / Fitness Instructor 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 Introduction Course Promo 00:02:00 Introduction & What You Will Learn 00:03:00 Get To Know Your Instructor 00:02:00 How to Get Your Certificate 00:01:00 The Roles & Responsibilities Of A Fitness Coach 00:02:00 Anatomy Anatomy Introduction 00:01:00 Nervous System 00:02:00 Bones & Joints 00:01:00 Muscular System 00:02:00 The 2 Types Of Muscle Fibers 00:03:00 Muscle Contractions Explained 00:02:00 Muscle Agonist & Anatagonist 00:02:00 Cardiovascular System 00:02:00 Client Assessment Client Assessment Intro 00:01:00 The Client Interview 00:02:00 Fitness Assessment 00:03:00 Harvard Step Test 00:02:00 Strength Test: How To Estimate Your 1 Rep Max 00:04:00 Resistance Training Resistance Training Overview 00:01:00 Bodyweight Training vs Weight Training 00:02:00 Bodyweight Fundamentals 00:02:00 Muscle Building Formula 00:09:00 Fat Loss Formula 00:06:00 Hypertrophy Explained: The 3 Types Of Muscle Growth 00:04:00 Weight Training Fundamentals 00:03:00 Progressive Overload 00:03:00 How To Create The Perfect Resistance Training 00:09:00 The 4 Fundamental Exercises For Muscle Growth 00:03:00 How To Warm Up Before Lifting Weights 00:03:00 Exercise Instruction Videos Bench Press 00:01:00 Squats 00:01:00 Deadlift 00:01:00 Overhead Press / Military Press 00:01:00 Barbell Row 00:01:00 Pull-Up 00:01:00 Push-Ups 00:01:00 Bodyweight Squat 00:01:00 Lunges 00:01:00 Pull-Up 2 00:01:00 Cardio & Endurance Training Cardio Introduction 00:01:00 The Different Types Of Cardio 00:02:00 Creating The Right Cardio Workout 00:04:00 How To Measure Heart Rate During A Workout 00:02:00 Weight Loss Exercising Myths 00:08:00 Cardio vs Weigh Training - Which Is Better For Weight Loss 00:07:00 Cardio For Weight Loss 00:04:00 HIIT Explained 00:07:00 Hiit Workout 00:05:00 How To Warm Up Correctly 00:02:00 Flexibility Flexibility Introduction 00:01:00 Most Common Stretching Mistakes 00:04:00 Static vs Dynamic Stretching 00:05:00 Sample Stretching Routine 00:03:00 Assignment Assignment - Personal Trainer / Fitness Instructor 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