1350 Installation courses

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that in 2022/23, an estimated 1.7 million work-related ill health cases were reported in the UK alone? These can be caused by a variety of factors, from slips and falls to exposure to hazardous substances. Have you ever wondered how to keep yourself and your colleagues safe in the workplace? This Workplace Health, PUWER and Gas Engineer bundle equips you with the knowledge and skills to navigate health and safety regulations and best practices. The bundle covers a wide range of topics, from the general principles of workplace health and safety (WHS) and the Provision and Use of Work Equipment Regulations (PUWER) to the specific needs of gas engineers. You'll also gain expertise in handling spills, chemical safety, preventing infections, and using personal protective equipment (PPE) effectively. Key Features of the Workplace Health, PUWER and Gas Engineer - Endorsed Certificate Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Workplace Health, PUWER and Gas Engineer - Endorsed Certificate bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Workplace Health and Safety QLS Course 02: PUWER QLS Course 03: Gas Engineer 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Spill Management Training Course 02: Chemical Spill Course 03: COSHH Training for Assessors Course 04: Infection Prevention Training Course 05: PPE In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Workplace Health, PUWER and Gas Engineer - Endorsed Certificate courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes of Workplace Health, PUWER and Gas Engineer Gain a comprehensive understanding of Workplace Health and Safety regulations. Master the principles and application of PUWER guidelines. Develop expertise in gas engineering, including installation, maintenance, and safety protocols. Acquire the necessary skills to effectively manage and respond to chemical spills. Understand the principles of COSHH and its significance in assessing workplace hazards. Enhance your knowledge of infection prevention measures and their implementation. Learn the importance of Personal Protective Equipment (PPE) and its role in ensuring workplace safety. By enrolling in this course bundle, you'll be taking a significant step towards a safer and healthier work environment for yourself and those around you. Invest in your career and gain the skills employers are looking for in today's safety-conscious workplace. Why Choose Us? Get 3 Free QLS Endorsed Certificate upon completion of this course Get a free student ID card with this Training This course is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Lifetime access to this course materials This course comes with 24/7 tutor support Take a step toward a brighter future! *** Course Curriculum *** QLS Course 01: Workplace Health and Safety Health And Safety Laws At Workplace Health And Safety Management Common Risks And Assessments Health, Safety And Welfare At Workplace Workplace Accidents And Ill Health Electrical, Fire And Gas Safety Safety In Various Work Scenarios Equipment Hazard And Risk Control At Work Other Workplace Health And Safety Risks QLS Course 03: Gas Engineer Module 01: Introduction To Gas Engineering Module 02: Combustion Module 03: Transmission System: Pipes And Flues Module 04: Ventilation Module 05: Tightness Testing Module 06: Meter Regulator Check Module 07: Appliance Pressures And Gas Rates Module 08: Emergency Isolation Controls And Valves Module 09: Gas Safety Devices And Controls Module 10: Gas Warning Labelling Module 11: Emergency And Evacuation Procedures Module 12: Chimney Standards, Inspection And Testing Module 13: Gas Appliances And Safety Course 01: Spill Management Training Module 01: Introduction To Spill Management Module 02: Hazardous Substances Module 03: Pollution Incident Response Planning Module 04: Managing A Spill Module 05: Spill Clean-Up Guideline Module 06: Spills On A Road Or Highway Module 07: Diesel Spillages: An Overview Module 08: Site-Specific Pollution Control Options Module 09: Spill Prevention & Control Checklist Module 10: Ways To Encourage Best Practice =========>>>>> And 10 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11 = £143) QLS Endorsed Hard Copy Certificate: Free (For The 3 QLS Course: Previously it was £357) CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Employees Managers Supervisors Gas Engineers Safety Professionals Requirements No prior background or expertise is required for this Workplace Health, PUWER and Gas Engineer bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Health & Safety Officer Risk Assessor Environmental Consultant Safety Advisor Safety Manager Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. Diploma in Workplace Health and Safety at QLS Level 5 Hard copy certificate - Included Please note that International students have to pay an additional £10 as a shipment fee.

Register on the Arduino today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get a digital certificate as a proof of your course completion. The Arduino course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Arduino Course Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Certification After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for £9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for £15.99, which will reach your doorsteps by post. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Arduino course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Course Content Introduction to Arduino Introduction To Course 00:01:00 Introduction to Embedded System and Arduino 00:04:00 Arduino Basics 00:09:00 Difference between C Syntax of Arduino and C Coding 00:10:00 Arduino and Ardublockly Installation and Program Downloading Arduino IDE and ArduinoBlockly Installation 00:10:00 Writing Program into ArduioBlockly and downloading on Board 00:11:00 Program Downloading using Arduino IDE 00:05:00 Arduino Interfaces Breadboard 00:08:00 LEDs LED Interfacing 00:11:00 Project 1: All LED Blinking 00:01:00 Project 2: Alternate LED Blinking 00:01:00 Project 3: Four LEDs ON - OFF 00:01:00 Project 4: Chaser 00:01:00 Ten Times LED Blinking 00:01:00 Switches Switch Interfacing 00:11:00 Project 6: LED and Switch Program 00:02:00 Project 7: Two LEDs and Two Switches Program 00:02:00 Buzzer Buzzer 00:03:00 Project 8: Buzzer Programming 00:01:00 Project 9: Buzzer and LED Program 00:01:00 Tri Color LED Tri-Color LED 00:05:00 Project 10: Tri-Color LED Based Red,Green, Blue Color Generation 00:01:00 Project 11: Tri Color LED Based Yellow, Cyan and Magenta Color Generation 00:01:00 Project 12: Traffic Light Controller 00:01:00 Project 13: Tri Color LED and Switch Based Color Generation 00:02:00 Seven Segment Display Seven Segment Display Interfacing 00:07:00 Project 14: Up Counter Using Seven Segment Display 00:04:00 Serial Communication Introduction Serial Communication 00:13:00 Project 15:Printing a Message into Monitor Window 00:01:00 Project 16: Message Reading Using Serial Communication 00:01:00 Project 17: Device Control 00:03:00 ADC and analog sensors ADC concepts 00:17:00 Project 18: Digital Thermometer 00:02:00 Project 19: Digital Voltmeter 00:02:00 Project 20: Digital Light Meter 00:01:00 Project 21: Temperature Controller 00:01:00 Pulse Width Modulation in Arduino Introduction To Pulse Width Modulation and its Concepts 00:12:00 Project 22: LED Fading 00:01:00 Ultrasonic Distance Sensing Ultrasonic Sensor concept 00:14:00 Project 23: Distance Meter 00:02:00 Project 24: Water Level Indicator 00:01:00 Servo Motor Interfacing Servo Interfacing with Arduino 00:15:00 Project 25: Servo Based Angular Control 00:01:00 Conclusion Conclusion 00:01:00 Resources Resources - Start Learning Arduino without Writing a Single Line of Code 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Gain the solid skills and knowledge to kickstart a successful career and learn from the experts with this

This unique syllabus teaches modules in Adobe software for A Level/GCSE and adults. Learn the basics and dive deeper with our experienced teachers, who will help you build upon your professional portfolio and provide you with what you need to work towards a professional qualification.  The below outline covers Photoshop, Illustrator, Premiere Pro, and Acrobat. Module 1: Introduction to Adobe Creative Cloud • Understanding Adobe's Creative Cloud Suite • Installation and setup • Introduction to the user interface • Navigating Adobe software Module 2: Adobe Photoshop Basics • Introduction to Photoshop • Understanding raster graphics • Essential tools and panels • Basic photo editing and retouching Module 3: Intermediate Photoshop Skills • Advanced selection techniques • Layers and blending modes • Color correction and adjustment layers • Creating and editing masks Module 4: Adobe Illustrator Fundamentals • Introduction to vector graphics • Illustrator's interface and tools • Drawing and editing shapes • Working with text and typography Module 5: Advanced Illustrator Techniques • Creating complex vector illustrations • Using the Pen tool effectively • Working with gradients and patterns • Illustrator's 3D capabilities Module 6: Adobe Premiere Pro Basics • Introduction to video editing • Premiere Pro's workspace • Importing and organising media • Basic video editing and transitions Module 7: Advanced Premiere Pro Editing • Advanced video editing techniques • Working with audio and sound • Applying effects and colour correction • Exporting video for various platforms Module 8: Adobe Acrobat for Document Management • Introduction to Adobe Acrobat • Creating, editing, and organising PDFs • Adding interactivity to PDFs • Digital signatures and security features Module 9: Integration and Workflow • Seamless integration between Adobe software • Creating assets in Photoshop/Illustrator for use in Premiere Pro • Exporting and importing files for collaborative work • Best practices for project management Module 10: Portfolio Development and Practical Projects • Final projects for each Adobe application • Developing a professional portfolio • Presenting and sharing your work • Preparing for Adobe certification exams (optional) Please note that the duration and depth of each module can vary depending on the level of expertise required and the specific needs of the learners. Additionally, it's important to adapt the curriculum to the learners' proficiency levels, whether they are A Level/GCSE students or adult learners with different experience levels.

Beyond the Circuit: Upgrade Your Skills with Electrician with Electrical Engineering Excellence! Embark on a transformative journey with our Electrician with Electrical Engineering program, a gateway to a spectrum of career opportunities. Discover the complexities of electrical engineering, from DC circuit analysis to advanced power electronics. From mastering the fundamentals of electrical circuits to delving into smart meter installation and electrical safety, you'll gain an in-depth understanding of the field. Moreover, we're your dedicated partners in this exciting Electrician with Electrical Engineering program. Our goal isn't just to teach you; it's to support you 24/7 so you can get closer to your dream job. We're so confident with our program that we offer a 100% money-back guarantee, ensuring your complete satisfaction. Learning Outcomes By completing this Electrician with Electrical Engineering program, you will gain the following: Master the fundamentals of electrical circuits and systems. Analyse and troubleshoot short circuits in high-voltage three-phase systems. Attain PAT Level 4 certification. Acquire knowledge in HVAC systems and maintenance. Gain proficiency in installing smart meters. Learn to protect distribution stations and feeders. Develop skills in MATLAB Simulink for electrical power engineering. Understand the principles of electrical power transformers and power electronics. Ensure electrical safety in various contexts, including fire safety. Hone your career development, CV writing, and interview skills. Create a professional LinkedIn profile for enhanced visibility. Courses we will provide once you enrol in the program: Get 25 complete courses when enrolling on our Electrician with Electrical Engineering program. => Course 01: Electrician => Course 02: Electrician Skills Complete Bundle => Course 03: Electrical Engineering DC Circuit Analysis => Course 04: Short Circuit Analysis for HV Three-Phase Systems => Course 05: PAT Level 4 => Course 06: Level 3 Heating, Ventilation & Air Conditioning (HVAC) Technician => Course 07: Electronic & Electrical Devices Maintenance => Course 08: Digital Electric Circuits & Intelligent Electrical Devices => Course 09: Smart Meter Installer Training => Course 10: Distribution Station & Feeder Protection => Course 11: MATLAB Simulink for Electrical Power Engineering => Course 12: Electric Power Metering for Single and Three-Phase Systems => Course 13: Electrical 3-Phase Power Transformers Fundamentals => Course 14: Power Electronics for Electrical Engineering => Course 15: Electrical Engineering for Electrical Substations => Course 16: Light Current Systems for Electrical Engineering => Course 17: Electrical Machines for Electrical Engineering => Course 18: Trigonometry for Electrical Engineering => Course 19: Electrical and Fire Safety Training => Course 20: Advanced Electrical Safety => Course 21: Career Development Plan Fundamentals => Course 22: CV Writing and Job Searching => Course 23: Interview Skills: Ace the Interview => Course 24: Video Job Interview for Job Seekers => Course 25: How to Create a Professional LinkedIn Profile Enrol in our highly regarded Electrician with Electrical Engineering program, featuring a job-relevant curriculum that ensures your skills align with employer expectations across various sectors. Don't miss this opportunity - your success story starts now! Please feel free to contact us for any query, and we will gladly assist you. Explore & learn dynamic electrical engineering through our meticulously curated Electrician with Electrical Engineering program. From foundational electrician skills to advanced concepts like digital circuits and power electronics, our comprehensive courses ensure you have deep knowledge for diverse roles in electrical engineering. Why Choose Us? What sets us apart is our commitment to your success. Here's what you get by joining our Electrician with Electrical Engineering program: Updated Materials: Stay ahead with cutting-edge content, regularly updated to reflect industry advancements. Our commitment to your success is evident in our continuously updated materials. This dedication ensures that you are equipped with the most relevant and cutting-edge knowledge, giving you a competitive edge in the dynamic landscape of electrical engineering. Flexible Timing: Learn at your own pace, with the flexibility to study whenever and wherever suits you best. Our program accommodates your schedule, allowing you to learn at your own pace. Whether you're a working professional or managing other commitments, our flexible timing enables you to study whenever and wherever suits you best. No Hidden Cost: Certification and course materials are included in the price, with no additional surprises. Transparency is critical to a positive learning experience. When you enrol in our program, you won't encounter any hidden costs. The price includes the course certification and all necessary materials: no additional expenses. Money-Back Guarantee: Try the program risk-free within 14 days - your satisfaction is our priority. We're confident in the quality of our program, and your satisfaction is our top priority. We offer a risk-free trial period of 14 days to demonstrate this confidence. If, within this time frame, you find that the program doesn't align with your expectations, we'll refund your investment. Lifetime Access: Our program gives you full access to course materials for a lifetime. This means you can revisit critical concepts, refresh your knowledge, and stay updated on industry trends long after completing the program. Your ongoing access ensures continuous support for your career journey, fostering a learning environment that grows with you. 24/7 Support: Our dedicated support team is available around the clock to assist you on your learning path. We understand that questions and challenges can arise at any time. That's why our dedicated support team is available 24/7 to assist you on your learning path. Your success is our priority, and our commitment to round-the-clock support ensures that you have the assistance you need whenever you need it. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Electrician with Electrical Engineering program is for individuals who are: Seeking a career in electrical engineering. Aspiring HVAC technicians. Keen on mastering electronic device maintenance. Looking to specialise in power electronics. Wanting to excel in electrical safety practices. Requirements Experience is optional for this Electrician with Electrical Engineering program. Career path This Electrician with Electrical Engineering program will give you many advantages in various roles within the industry: Electrical Engineer: £35,000 - £60,000 HVAC Technician: £25,000 - £40,000 Power Electronics Specialist: £40,000 - £65,000 Smart Meter Installer: £28,000 - £45,000 Substation Engineer: £38,000 - £55,000 Electrical Safety Consultant: £45,000 - £70,000 Certificates CPD Accredited (e-Certificate) Digital certificate - Included CPD Accredited (Hard Copy Certificate) Hard copy certificate - Included e-Transcript Digital certificate - Included Hard Copy Transcript Hard copy certificate - Included Student ID Card Digital certificate - Included

Build and publish your own Android game in a few hours with the help of this practical-based course. You will gain a working knowledge of Unity and C# while building a 3D ZigZag racing Android game from start to finish. Learning Unity Android game development will provide you with a strong background to build awesome Android games.

Learn the basics and the advanced concepts of Tableau to create stunning and detailed visualizations. This course provides step-by-step guidance on how we can make data easier to understand and easier to interpret by using visualizations. We'll be working with Tableau 2020.3.

Duration 3 Days 18 CPD hours This course is intended for Developers Architects Administrators Overview By the end of the course, you should be able to meet the following objectives: Install and configure RabbitMQ Activate and use plugins such as the web management console Implement messaging patterns and applications using the Java client Set up a cluster of RabbitMQ nodes Configure high availability appropriately Tune and optimize RabbitMQ for better performance Secure RabbitMQ This intensive instructor-led course in RabbitMQ provides a deep dive into how to install, configure, and develop applications which leverage RabbitMQ messaging. The course begins with RabbitMQ installation and general configuration. It continues with developing messaging applications using the Java APIs, and delves into more advanced topics including clustering, high availability, performance, and security. Modules are accompanied by lab exercises that provide hands-on experience Introduction to Spring Essentials Kubernetes Overview BOSH Introduction Deploy, Patch & Upgrade Deploy a simple release Inside the VM Persistent Disks Patch the OS Upgrade Nginx Entry Point Set up a jumpbox Platform Infrastructure Pave the IaaS Deploy ops manager Deploy BOSH director Containerized Workloads Deploy Pivotal Container Service Provision a Kubernetes Cluster Harbor Container Registry Application Deployment Helm Advanced BOSH Deploy a distributed system Deploy Concourse CredHub Troubleshooting Concourse Deployment Concourse Day 2 Operations

Are you ready for the CCNA exam? You sure? Check your knowledge with our ICND1 Exam Prep Labs. Make sure you know the right topics

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development 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 SQL For Data Analytics & Database Development 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 For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development 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 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