Name: Build Performant GraphQL Backends in Days Using Hasura
Price: 74.99 GBP
Availability: InStock

<p>Did you know the UK web development market is booming, with WordPress skills skyrocketing? A recent report by the UK Digital Economy Council found WordPress developer jobs surged 25% in 2023 alone!</p><p>Master WordPress and tap into this exciting trend. Design stunning websites, attract new clients, and boost your career, all without prior coding experience. Our beginner-friendly WordPress Developer Basics course will guide you every step of the way, from the fundamentals to building real-world websites.</p><p>Enrol now and unlock your WordPress potential! </p><p>This comprehensive curriculum empowers aspiring web developers with a robust skill set. Ideal for those eager to create unlimited websites, establish online communities, and enhance e-commerce ventures. Enrol now to embark on a transformative journey into the dynamic realm of WordPress web development.</p><p><strong>Learning Outcomes:</strong></p><ul><li>Create unlimited websites using WordPress for diverse purposes.</li><li>Develop a social media community website with WordPress.</li><li>Build a secure and efficient online course using LifterLMS and WordPress.</li><li>Implement SEO strategies to optimise WordPress websites.</li><li>Establish a membership site seamlessly with Memberpress on the WordPress platform.</li></ul><p>This comprehensive WordPress Developer Basics curriculum offers an immersive journey into web development. From mastering the fundamentals of WordPress and web design to constructing intricate social media community websites, e-commerce platforms, and secure online courses, participants delve into advanced topics like SEO optimisation and server setup. Tailored for aspiring web developers, the course provides hands-on experience in creating, securing, and optimising diverse WordPress-powered websites, empowering learners to navigate the dynamic landscape of web development with confidence.</p><p>This CPDQS Accredited WordPress Developer Basics consists of the following 11 courses:</p><ul><li>Basics of WordPress: Create Unlimited Websites</li><li>Web Design and WordPress Training</li><li>Wordpress Web Development: Social Media Community Website</li><li>Build Directory Website Using Wordpress</li><li>Wordpress Security Mastery</li><li>Build a Self Hosted Online Course With LifterLMS &amp; Wordpress</li><li>How To Build Easy Drag &amp; Drop Landing Pages With Wordpress</li><li>WordPress and SEO Online Course</li><li>Make a Wordpress WooCommerce Amazon Affiliate Store</li><li>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu</li><li>How To Build a Wordpress Membership Site With Memberpress</li></ul><p><strong>Certification</strong><br />Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.<br /></p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        35 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Unleash your potential in web development with WordPress Developer Basics. Perfect for:</p><ul><li>Aspiring Web Developers</li><li>Individuals eager to master WordPress</li><li>Those looking to enhance web design skills</li><li>Entrepreneurs seeking to build and secure online platforms</li></ul>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This course is open to all, catering to beginners and seasoned learners alike. No formal prerequisites. Dive into WordPress development, embracing creativity and innovation.</p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <ul><li>WordPress Developer - £40,000</li><li>Web Designer - £35,000</li><li>E-commerce Specialist - £45,000</li><li>SEO Specialist - £35,000</li><li>Online Course Developer - £50,000 annually.</li></ul>
                        </div>

One Education

WordPress Developer Basics Course

General Admission

<p>Hack the future of safety: Become a Cyber Security Specialist (Enrol Now!)</p><p>Cybercrime costs UK businesses £29bn a year. That's a staggering figure, showing the urgent need for skilled defenders like you. Our Cyber Security Specialist course equips you with the real-world knowledge and tools to combat these threats.</p><p>Master network security, ethical hacking, and incident response. Learn from industry experts, not textbook theorists. Learn the cutting-edge simulations and real-world scenarios. Emerge confident, prepared, and ready to secure the digital frontier.</p><p>Don't let your future be compromised. Enrol now and build a career in high-demand Cyber Security!</p><p><strong>What will you learn from this Cyber Security Specialist CPDQS Accredited Bundle?</strong></p><ul><li>Analyse cyber threats and vulnerabilities using CySA+ frameworks.</li><li>Conduct digital investigations and collect forensic evidence.</li><li>Implement security best practices to protect against cyberattacks.</li><li>Comprehend legal and ethical considerations in cybersecurity.</li><li>Develop Python scripts for automation and web development tasks.</li></ul><p>This comprehensive curriculum cultivates cybersecurity expertise from the ground up. Foundational knowledge in awareness, law, and fundamentals prepares you for advanced training in forensics, analysis, and intelligence. Hands-on Python programming and web development solidify your skills, equipping you for diverse cybersecurity careers like Cyber Intelligence Officer.</p><p><strong>This CPDQS Accredited Cyber Security Specialist Bundle consists of the following 11 courses:</strong></p><ul><li>CompTIA CySA+ Cybersecurity Analyst (CS0-002)</li><li>Digital Forensics for Cyber Professionals</li><li>Cyber Security Awareness Training</li><li>Cyber Security Fundamentals</li><li>Cyber Security Law</li><li>Cyber Security Advanced Training</li><li>Cyber Intelligence Officer</li><li>Computer Science With Python</li><li>Coding with Python 3</li><li>Ultimate PHP &amp; MySQL Web Development &amp; OOP Coding</li></ul><p><strong>Certification</strong><br />Once you have finished the course, you will be eligible to apply for a CPD QS accredited certificate as proof of your new skills and your continued professional development. Certificates are available as PDF for £9, or you can request a hard copy to be sent in the post for £15.</p><h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        35 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div><h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p>Embark on a cybersecurity journey with our Cyber Security Specialist program!</p><p>- IT professionals aspiring to specialise in cybersecurity.</p><p>- Students pursuing a career in the field of cybersecurity.</p><p>- Network administrators looking to enhance security skills.</p><p>- Individuals interested in protecting digital assets and data.</p><p>- Those aiming for roles as cybersecurity analysts or specialists.</p>
                        </div><h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>Welcome to the "Cyber Security Specialist" course-an open opportunity for all without stringent prerequisites. Whether you're an IT professional looking to specialize in cybersecurity or a beginner intrigued by the world of digital defence, this course is your gateway. No specific technical background is required, making it accessible to a diverse range of learners. </p>
                        </div><h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>As a Cyber Security Specialist, you'll safeguard digital assets from cyber threats. Here are five rewarding careers in this field with their annual UK salaries:</p><ul><li>Security Analyst: £30,000 - £60,000</li><li>Penetration Tester: £40,000 - £80,000</li><li>Incident Responder: £35,000 - £70,000</li><li>Security Consultant: £45,000 - £90,000</li><li>Cyber Security Architect: £50,000 - £100,000</li></ul>
                        </div>

Face the Cyber Frontier: Become a Cyber Security Specialist Course

<p><strong>***24 Hour Limited Time Flash Sale***</strong></p><p><strong> </strong><strong>Software Engineering: Master Programming, Web Design &amp; Development </strong><strong>Admission Gifts </strong></p><p><strong> FREE PDF &amp; Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter</strong></p><p>Are you a professional feeling stuck in your career, struggling to keep up with the ever-changing demands of the industry? Or perhaps you're a beginner, unsure of where to start or how to break into your desired field. Whichever stage you're in, our exclusive Software Engineering: Master Programming, Web Design &amp; Development Bundle provides unique insights and tools that can help you achieve your goals.</p><p>Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Software Engineering: Master Programming, Web Design &amp; Development bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level.</p><p><strong>But that's not all. When you enrol in Software Engineering: Master Programming, Web Design &amp; Development Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free.</strong></p><p><strong>Courses Are Included In this Software Engineering: Master Programming, Web Design &amp; Development Career Bundle:</strong></p><ul><li> Course 01: Coding with Scratch</li><li> Course 02: C# Programming - Beginner to Advanced</li><li> Course 03: Python Programming Bible</li><li> Course 04: Machine Learning with Python Course</li><li> Course 05: JavaScript Fundamentals</li><li> Course 06: Refactor Javascript</li><li> Course 07: Penetration Testing with OWASP ZAP</li><li> Course 08: Advanced SAS Programming Using MacrosSQL</li><li> Course 09: How To Startup Your Own SaaS (Software As a Service) Company (SaaS Evolution)</li><li> Course 10: Three.js &amp; WebGL 3D Programming</li><li> Course 11: Stripe with C#</li><li> Course 12: C++ Development: The Complete Coding Guide</li><li> Course 13: Bootstrap - Responsive Web Design</li><li> Course 14: Masterclass Bootstrap 5 Course - Responsive Web Design</li><li> Course 15: Diploma in User Experience UI/UX Design (Advanced)</li><li> Course 16: Advanced Diploma in PHP Web Development with MySQL, GitHub &amp; Heroku</li><li> Course 17: Node JS: API Development with Swagger</li><li> Course 18: HTML Web Development Crash Course</li><li> Course 19: CSS Web Development</li><li> Course 20: .NET Core API Development</li><li> Course 21: Graphic Design Using Canva</li><li> Course 22: Basics of WordPress: Create Unlimited Websites</li><li> Course 23: The Ultimate WordPress for Beginners Step-by-Step Blueprint</li><li> Course 24: Using WordPress for Affiliate Marketing</li><li> Course 25: WordPress 5.0 for Beginners to Advanced</li><li> Course 26: WordPress and SEO Online Course</li><li> Course 27: How To Build Easy Drag &amp; Drop Landing Pages With Wordpress</li><li> Course 28: Make a Wordpress WooCommerce Amazon Affiliate Store</li><li> Course 29: Wordpress Security Mastery</li><li> Course 30: How To Build a Wordpress Membership Site With Memberpress</li></ul><p>With Software Engineering: Master Programming, Web Design &amp; Development, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner.</p><p>Don't let this opportunity pass you by. Enrol in Software Engineering: Master Programming, Web Design &amp; Development today and take the first step towards achieving your goals and dreams.</p><p><strong>Why buy this Software Engineering: Master Programming, Web Design &amp; Development?</strong></p><ul><li><strong>Free CPD Accredited Certificate</strong> upon completion of Software Engineering: Master Programming, Web Design &amp; Development</li><li>Get <strong>a free student ID card</strong> with Software Engineering: Master Programming, Web Design &amp; Development</li><li><strong>Lifetime access</strong> to the Software Engineering: Master Programming, Web Design &amp; Development course materials</li><li>Get instant access to this Software Engineering: Master Programming, Web Design &amp; Development course</li><li>Learn Software Engineering: Master Programming, Web Design &amp; Development from anywhere in the world</li><li>24/7 tutor support with the Software Engineering: Master Programming, Web Design &amp; Development course.</li></ul> <p><strong>Start your learning journey straightaway with our Software Engineering: Master Programming, Web Design &amp; Development Training!</strong></p><p>Software Engineering: Master Programming, Web Design &amp; Development premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of the Software Engineering: Master Programming, Web Design &amp; Development is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience.</p><p><strong>Certification</strong></p><p>You have to complete the assignment given at the end of the Software Engineering: Master Programming, Web Design &amp; Development course. After passing the Software Engineering: Master Programming, Web Design &amp; Development exam You will be entitled to claim a PDF &amp; Hardcopy certificate accredited by CPD Quality standards completely free.</p> <h2>
        
        <div>CPD</div>
    </h2>

                        <div id="cpd">
                            <div>
                                <div>
                                    <div>
                                        300 CPD hours / points
                                    </div>
                                        <div>
                                            Accredited by CPD Quality Standards
                                        </div>
                                </div>
                            </div>
                        </div> <h2>
        
        <div>Who is this course for?</div>
    </h2>

                        <div id="who_is_this_course_for">
                            <p><strong>This Software Engineering: Master Programming, Web Design &amp; Development course is ideal for:</strong></p><ul><li>Students seeking mastery in Software Engineering: Master Programming, Web Design &amp; Development</li><li>Professionals seeking to enhance Software Engineering: Master Programming, Web Design &amp; Development skills</li><li>Individuals looking for a Software Engineering: Master Programming, Web Design &amp; Development-related career.</li><li>Anyone passionate about Software Engineering: Master Programming, Web Design &amp; Development</li></ul>
                        </div> <h2>
        
        <div>Requirements</div>
    </h2>

                        <div id="requirements">
                            <p>This <strong>Software Engineering: Master Programming, Web Design &amp; Development </strong>doesn't require prior experience and is suitable for diverse learners.</p>
                        </div> <h2>
        
        <div>Career path</div>
    </h2>

                        <div id="career_path">
                            <p>This <strong>Software Engineering: Master Programming, Web Design &amp; Development </strong>bundle will allow you to kickstart or take your career in the related sector to the next stage.</p>
                        </div> <h2>
        
        <div>Certificates</div>
    </h2>

                        <div id="optional_extras">
                                    <h4>CPD Accredited Digital Certificate</h4>
        <p>
            Digital certificate -
            Included
        </p>
        <h4>CPD Accredited Hard Copy Certificate</h4>
        <p>
            Hard copy certificate -
            Included
        </p>
            <div><p>If you are an international student, you will be required to pay an additional fee of <strong>10 GBP</strong> for international delivery, and <strong>4.99 GBP</strong> for delivery within the UK, for each certificate</p></div>

                        </div>

Academy for Health and Fitness

Software Engineering: Master Programming, Web Design & Development

<strong>Gain n-depth knowledge about Docker technology and the confidence to help your company or your own project to apply the right Docker deployment workflow. Learn all about Docker, Docker REST API, and Docker continuous integration to build Docker images.</strong>
        <p>Docker is a set of platforms as service products that use OS-level virtualization to deliver software in packages called containers. The service has both free and premium tiers.

This course starts by explaining what Docker is and an overview of Docker. You will learn the basics of Docker such as image pull, run a container, stop containers, and delete images. You will also explore how to create your own Docker network as well as how to link containers to custom networks. Along with this, you will learn how to make a connection between containers running on different networks and how to delete the custom network. You will also be well versed in changing the permission of volume from read-write to read-only.

Furthermore, you will learn to clone a volume and mount it to another container. You will explore how to push images to our DockerHub account. You will learn to create your first Docker file and create multi-tier with docker-compose. Finally, you will understand how to use WordPress and MySQL with Docker Compose and how to work with the REST API of Docker Engine.

By the end of this Docker course, you will gain in-depth knowledge about Docker and general DevOps skills to help your company or your own project to apply the right Docker workflow and continuously deliver better software.

All resources are placed here: https://github.com/PacktPublishing/Docker---A-Beginner-s-Hands-on-Guide</p>
        <h2>What You Will Learn</h2><p>Understand the basics of Docker<br>Understand how to create your own Docker network<br>Learn how to delete the custom network<br>Learn how to clone a volume and mount to another container<br>Learn to create your first Docker file<br>Learn to work with REST API of Docker engine</p>
        <h2>Audience</h2><p>This Docker course is designed for every DevOps engineer. It can also be taken by system administrators, cloud infrastructure engineers, and developers.</p>
        <h2>Approach</h2><p>This Docker course is very hands-on; it provides you with not only the theory but also real-life examples of developing Docker applications that you can try out on your own laptop.</p>
        <h2>Key Features</h2><p>Explore the best practices of working with Docker technology in the field * Design multi-container applications and automate the workflow using Compose * Learn essential Docker concepts that one should know to work in production</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Docker---A-Beginner-s-Hands-on-Guide</p>
        <h2>About the Author</h2><h3>Himanshu Sharma</h3><p>Himanshu Sharma is an expert in Kubernetes, containers, and cloud-native infrastructure. He has more than 12 years of IT experience in a variety of industries, including medical devices, entertainment, enterprise software, and cloud computing. He is passionate about learning new technologies and believes the best way to learn is by doing it practically.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video explains the course overview.</p></td></tr><tr><td style='padding: 15px;'><p>2. Overview of Docker</p><p style='margin: 0'>This video explains the Docker.</p></td></tr></tbody></table><br><h4>2. Installation of Docker</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Installation of Docker</p><p style='margin: 0'>This video explains the Docker installation.</p></td></tr></tbody></table><br><h4>3. Docker Basic Part - 1</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Image pull, Running a Container, Stop/Delete Containers, Delete Images</p><p style='margin: 0'>This video introduces you to image pull, running a container, stop/delete containers, delete images.</p></td></tr></tbody></table><br><h4>4. Docker Basics Part - 2</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Docker Inspect, Logs, Expose Container to the Outside World</p><p style='margin: 0'>This video explains the learning objectives of the course.</p></td></tr></tbody></table><br><h4>5. Docker Network</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Default Network, Creating Own Network, Link Containers to Custom Network</p><p style='margin: 0'>This video explains default network, creating own network, link containers to custom network.</p></td></tr></tbody></table><br><h4>6. Docker Network Part - 2</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Working with Host Network and Learning How to Delete Multiple Containers and Images</p><p style='margin: 0'>This video explains working with host network and learning how to delete multiple containers and images.</p></td></tr></tbody></table><br><h4>7. Make Connection Between Containers Running on Different Networks</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Make Connection Between Containers Running on Different Networks</p><p style='margin: 0'>This video explains how to make connections between containers running on different networks.</p></td></tr></tbody></table><br><h4>8. Delete the Network</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. How to Delete the Custom Network</p><p style='margin: 0'>This video explains how to delete the custom network.</p></td></tr></tbody></table><br><h4>9. Non-Root User</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Got Permission Denied While Trying to Connect to the Docker with a Non-Root User</p><p style='margin: 0'>This video explains how to connect to Docker with a non-root user.</p></td></tr></tbody></table><br><h4>10. Docker Volume with RO/RW Permission</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. How to Change the Permission of Volume from Read Write to Read Only</p><p style='margin: 0'>This video explains how to change the permission of volume from read write to read only.</p></td></tr></tbody></table><br><h4>11. Cloning of a Volume</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Clone a Volume and Mount to Another Container</p><p style='margin: 0'>This video explains how to clone a volume and mount to another container.</p></td></tr></tbody></table><br><h4>12. Create an Image of a Running Container</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Learn How to Create an Image of a Container</p><p style='margin: 0'>This video explains how to create an image of a container.</p></td></tr></tbody></table><br><h4>13. Tagging Images</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Learn How to Tag the Images and Use Them</p><p style='margin: 0'>This video explains how to tag images and use them.</p></td></tr></tbody></table><br><h4>14. Push Custom Images to Docker Hub</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Let's Push Images to Our Docker Hub Account</p><p style='margin: 0'>This video explains how to push images to our Docker Hub account.</p></td></tr></tbody></table><br><h4>15. Rename Your Container</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Rename Your Container</p><p style='margin: 0'>This video explains renaming the Docker container.</p></td></tr></tbody></table><br><h4>16. Dockerfile</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Create Your First Dockerfile</p><p style='margin: 0'>This video explains how to create your first Dockerfile.</p></td></tr></tbody></table><br><h4>17. Dockerfile - ENTRYPOINT and CMD</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. ENTRYPOINT Versus CMD</p><p style='margin: 0'>This video explains ENTRYPOINT versus CMD.</p></td></tr></tbody></table><br><h4>18. Dockerfile - Switching Users While Creating Image</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Dockerfile - Switching Users While Creating Image</p><p style='margin: 0'>This video explains switching users while creating an image.</p></td></tr></tbody></table><br><h4>19. Dockerfile - Few More Things</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Few More Things</p><p style='margin: 0'>This video explains more about Dockerfile.</p></td></tr></tbody></table><br><h4>20. Docker Compose</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Let's Dive into Docker Compose</p><p style='margin: 0'>This video explains Docker Compose.</p></td></tr></tbody></table><br><h4>21. Running Multiple Containers with Docker Compose</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Create Multi-Tier with Docker Compose</p><p style='margin: 0'>This video explains how to create a multi-tier with Docker Compose.</p></td></tr></tbody></table><br><h4>22. Build Image from Docker Compose</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Build an Image from Docker Compose and Run the Container at the Same Time</p><p style='margin: 0'>This video explains how to build an image from Docker Compose and run the container at the same time.</p></td></tr></tbody></table><br><h4>23. Create a WordPress Website with Docker Compose</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Using WordPress and MySQL with Docker Compose</p><p style='margin: 0'>This video explains using WordPress and MySQL with Docker Compose.</p></td></tr></tbody></table><br><h4>24. Using REST API of Docker</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Work with REST API of Docker Engine</p><p style='margin: 0'>This video explains working with REST API of Docker Engine.</p></td></tr></tbody></table><br><h4>25. Continuous Integration (CI) Between GitHub and Docker Hub</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Continuous Integration (CI) with GitHub and Docker Hub</p><p style='margin: 0'>This video explains Continuous Integration (CI) with GitHub and Docker hub.</p></td></tr></tbody></table>

Packt

Docker

Programming

Gain n-depth knowledge about Docker technology and the confidence to help your company or your own project to apply the right Docker deployment workflow. Learn all about Docker, Docker REST API, and Docker continuous integration to build Docker images.

Docker - A Beginner's Hands-On Guide

<strong>This course takes you through the concepts of object-oriented programming (OOP) and shows you how to use them for writing flawless Python programs.</strong>
        <p>From DevOps to cloud computing and data science, the Python programming language is used in almost every field of computer science. But what happens when you use the principles of object-oriented programming (OOP) in Python? Find out in this course.

The course starts with an introduction to OOP concepts and then gradually proceeds towards giving you a detailed insight into OOPs concepts. You will find out what is abstraction, encapsulation, inheritance, and polymorphism in OOP in detail.

By the end of this course, you will be well-versed with Python OOP and will have developed the skills to write clean Python code and take your Python skills to the next level.

The code files and all related files are uploaded on GitHub at https://github.com/PacktPublishing/Python-Object-Oriented-Programming-Hands-on-for-Beginners</p>
        <h2>What You Will Learn</h2><p>Set up a live Python environment in a browser<br>Explore modules, class constructs, and object attributes<br>Grasp techniques to import modules and access object attributes<br>Distinguish between public and private access modifier<br>Use getter and setter methods in object-oriented programming (OOP)<br>Become familiar with abstract classes and methods</p>
        <h2>Audience</h2><p>If you are a software engineer, developer, DevOps engineer, cloud engineer, or software architect, who wants to use object-oriented programming (OOP) concepts for writing clean and error-free Python programs, this course is for you. A basic understanding of Python programming is needed to get started with this course.</p>
        <h2>Approach</h2><p>With the help of example source code and interesting activities, this course helps you to understand how to use object-oriented programming (OOP) concepts in Python programming.</p>
        <h2>Key Features</h2><p>Get to grips with the four pillars of object-oriented programming (OOP) * Find out the role of OOP concepts in Python * Learn how to create classes using the principles of OOP</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Python-Object-Oriented-Programming-Hands-on-for-Beginners</p>
        <h2>About the Author</h2><h3>Coding Gears | Train Your Brain</h3><p>GlobalETraining (brand name - CodingGears) offers self-paced technical courses and makes them easy to learn.

They have been in the IT training business for many years, offering training courses in Unix, Windows, C#, Java, Python programming, SQL server, manual testing, automation, and so on. Their instructors have 20+ years of experience in various technical areas such as software development, software testing, Windows systems, and network administration, Unix/Linux systems and network administration, virtualization technologies, storage, shell scripting, database management systems (MS SQL Server, MySQL, IBM DB2, Cassandra), containerization (Dockers), Mesos, Marathon, Jenkins, Jira, Elastic Cloud Storage (ECS), Gluster file system, CoreOS, Ansible, and other areas.

CodingGears/GlobalETraining has mentored thousands of students for over a decade and has extensive experience in delivering training-both in-class and online.</p>
        <h2>Course Outline</h2><h4>1. Welcome</h4><p></p><br><h4>2. Object-oriented Programming (OOP) Essentials</h4><p></p><br><h4>3. Object-oriented Programming (OOP) - Getting Deeper - Part 1</h4><p></p><br><h4>4. Object-Oriented Programming (OOP) - Getting Deeper - Part 2</h4><p></p>

Python

This course takes you through the concepts of object-oriented programming (OOP) and shows you how to use them for writing flawless Python programs.

Python Object-Oriented Programming: Hands-on for Beginners [Updated for 2021]

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Gain in-demand web development skills and take your programming skills to the next level, with the</span><b> Advanced Diploma in Web Development</b><span>.</span></p><p><span>This complete certificate in web development will walk you through the process of setting up virtual cloud servers and developing database-driven websites using the most up-to-date web technologies. Broken down into 20 in-depth modules, it covers core topics such as the web development process, web application planning, web hosting and system requirements, HTML development, CSS, and JavaScript.</span></p><p><span>You will also familiarise yourself with the Bootstrap framework, jQuery library, MySql, and Ajax, equipping you with the in-demand skills required to take your first steps into the world of web development. Enrol in this video-guided course today and boost your CV with an industry-recognised qualification.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>Advanced Diploma in Web Development </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>Advanced Diploma in Web Development </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p>
<p>The <strong>Advanced Diploma in Web Development </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>Advanced Diploma in Web Development </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p>
<p>After successfully completing the<strong> Advanced Diploma in Web Development</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>Advanced Diploma in Web Development </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p>
<p>We know that you are busy and that time is precious, so we have designed the <strong>Advanced Diploma in Web Development </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p>
<p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

Course Cloud

Advanced Diploma in Web Development

<strong>This course will help you to learn the basic concepts of Python programming. From understanding variables to functions and debugging the programs to exception handling, you will master it all with the help of engaging exercises and projects.</strong>
        <p>With Python, you can build applications, such as Google, Instagram, Spotify, and Reddit. But to make such applications, you should have a strong knowledge of the fundamentals of Python. This course will be your step-by-step guide to master the fundamentals of Python programming.

The course starts by walking you through the process of setting up a Python development environment. Next, you will get an overview of the versions and history of Python programming and write a simple 'Hello World' program to understand the structure of Python code. Moving along, you will get a detailed understanding of Python variables, datatypes, built-in functions, conditional statements, and loops. Next, you will learn how to work with lists, tuples, sets, dictionaries, strings, functions, modules, and packages in Python. Later, you will learn to debug your Python program, work with files, and learn how to handle exceptions. Next, you will learn how to use numbers and date and time functions in Python programs and study the concepts of package management. Finally, you will learn to create, activate, and deactivate Python virtual environments and get an overview of comprehensions and decorators.

By the end of this course, you will have gained the knowledge and skills of all the basic concepts of Python programming and will be ready to take up advanced Python concepts.

The code files and all related files are uploaded on GitHub at https://github.com/PacktPublishing/Python-Programming-for-Beginners-Hands-on-Online-Lab-</p>
        <h2>What You Will Learn</h2><p>Explore Python datatypes variables and functions<br>Find out how to create and work with modules and packages<br>Read and write a CSV and binary file<br>Grasp techniques to handle exceptions<br>Find out how to debug Python programs<br>Create, activate, and deactivate Python virtual environments</p>
        <h2>Audience</h2><p>This course is designed for anyone who is interested in learning the basics of Python programming. There are no prerequisites to take this course as you will learn everything from scratch.</p>
        <h2>Approach</h2><p>Featuring labs, exercises, and interesting projects, this course takes you through the fundamental concepts of Python programming from scratch.</p>
        <h2>Key Features</h2><p>Gain a solid understanding of the fundamentals of Python 3 * Become comfortable in using Python datatypes, functions, packages, and modules * Apply your learning to write and run simple Python scripts from the Linux terminal</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Python-Programming-for-Beginners-Hands-on-Online-Lab-</p>
        <h2>About the Author</h2><h3>Coding Gears | Train Your Brain</h3><p>GlobalETraining (brand name - CodingGears) offers self-paced technical courses and makes them easy to learn.

They have been in the IT training business for many years, offering training courses in Unix, Windows, C#, Java, Python programming, SQL server, manual testing, automation, and so on. Their instructors have 20+ years of experience in various technical areas such as software development, software testing, Windows systems, and network administration, Unix/Linux systems and network administration, virtualization technologies, storage, shell scripting, database management systems (MS SQL Server, MySQL, IBM DB2, Cassandra), containerization (Dockers), Mesos, Marathon, Jenkins, Jira, Elastic Cloud Storage (ECS), Gluster file system, CoreOS, Ansible, and other areas.

CodingGears/GlobalETraining has mentored thousands of students for over a decade and has extensive experience in delivering training-both in-class and online.</p>
        <h2>Course Outline</h2><h4>1. Welcome</h4><p></p><br><h4>2. Setting up the Python Development Environment</h4><p></p><br><h4>3. Python - Absolute Basics</h4><p></p><br><h4>4. Variables, Data Types, and Built-in Functions</h4><p></p><br><h4>5. Conditional Statements and Loops</h4><p></p><br><h4>6. Working with Lists</h4><p></p><br><h4>7. Working with Tuples</h4><p></p><br><h4>8. Working with Sets</h4><p></p><br><h4>9. Working with Dictionaries</h4><p></p><br><h4>10. Working with Strings</h4><p></p><br><h4>11. Functions</h4><p></p><br><h4>12. Modules and Packages</h4><p></p><br><h4>13. Debugging</h4><p></p><br><h4>14. Working with Files (Files Input/Output)</h4><p></p><br><h4>15. Handling Exceptions</h4><p></p><br><h4>16. Working with Numbers</h4><p></p><br><h4>17. Working with Dates and Times</h4><p></p><br><h4>18. Package Management</h4><p></p><br><h4>19. Python Virtual Environments</h4><p></p><br><h4>20. Comprehensions</h4><p></p><br><h4>21. Decorators</h4><p></p><br><h4>22. Generators</h4><p></p><br><h4>23. Miscellaneous and Additional Resources</h4><p></p>

Linux

Debugging

This course will help you to learn the basic concepts of Python programming. From understanding variables to functions and debugging the programs to exception handling, you will master it all with the help of engaging exercises and projects.

Python Programming for Beginners: Hands-on (Online Lab)

<strong>This course covers all the basics to more advanced features and dives into all the little details about Hasura.

Hasura provides a platform to create your GraphQL backends easier and faster than you ever thought possible without writing a single line of code!</strong>
        <p>If you're a developer struggling with GraphQL because of its complexity or simply because it takes too much time, this is going to be the most exciting news for you.

If you get to know that your existing PostgreSQL (and soon MySQL too) can be turned into a powerful GraphQL API in a matter of seconds or build a performant GraphQL backend from start to finish in a couple of hours with very little to no coding-would you be interested?

This course provides you with a solution. This course will talk about 'Hasura', which will help you create your GraphQL backends easier and faster than you ever thought possible without writing a single line of code!

Here, you will look at how to let the CRUD code write itself without you even touching your keyboard. Then you'll learn how to play with all the different features in Hasura using the 'playground' approach. After that, you'll understand how to easily navigate through the most common errors that can cost you a huge chunk of your time if you don't know about them. Finally, you'll use Angular and React apps to enhance Hasura features and deploy the code on GitHub Actions.

By the end of this course, you'll be able to use every functionality to create your GraphQL backends effortlessly in record time.

The resource files are uploaded on the GitHub repository at https://github.com/PacktPublishing/Blazing-Fast-GraphQL-Backend-Development-Using-Hasura</p>
        <h2>What You Will Learn</h2><p>Use a simple file uploading strategy with GraphQL, Hasura Actions, and Firebase storage<br>Easily integrate and delegate custom logic to micro-services (REST and GraphQL) created with Firebase Cloud functions<br>Database migrations and metadata to help your database evolve successfully<br>Create role-based access to the data<br>Create full React and Angular application examples with Apollo GraphQL client and Hasura backend<br>Build real-time queries to the Hasura GraphQL server</p>
        <h2>Audience</h2><p>This course is for frontend developers looking for a new, easy, and fast way for GraphQL backend development and backend developers looking for incredibly performing GraphQL endpoints with minimal effort. Product managers who are looking for a tool for quick idea validation and developers who need an amazing tool for extremely fast GraphQL backend prototyping will also benefit from this course.<br><br>To get the maximum benefit from this course, a basic understanding of Docker along with an understanding of GraphQL and a little experience in web development will be required.</p>
        <h2>Approach</h2><p>The course uses step-by-step approach methodology to explain concepts thoroughly while using hands-on exercises. The easy step-by-step instructions will help you get the maximum value by following the author. The course is divided into small modules so that you can quickly go through the one you need.</p>
        <h2>Key Features</h2><p>Transform your database into a GraphQL server with built-in sorting, full-text search, and pagination in a few minutes * Use a simple file uploading strategy with GraphQL, Hasura actions, and Firebase storage * Build a CI/CD pipeline with GitHub Actions that deploys the Hasura project on development and production environments</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/Blazing-Fast-GraphQL-Backend-Development-Using-Hasura</p>
        <h2>About the Author</h2><h3>Dmytro Mezhenskyi</h3><p>Dmytro Mezhenskyi has been working as a front-end developer since 2013 and has experience with different projects, different scales, and frameworks. Teaching has inspired him a lot and he decided to spread his knowledge through the medium of online courses in order to help hundreds of people become better developers.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><br><h4>2. Basics - Queries / Mutations / Real-Time Subscriptions</h4><p></p><br><h4>3. Delegation of custom Logic to 3rd party Micro-Services</h4><p></p><br><h4>4. Authentication in Hasura</h4><p></p><br><h4>5. Database Migrations & Metadata</h4><p></p><br><h4>6. File Uploading & Small Improvements</h4><p></p><br><h4>7. Example with Angular (Material), Apollo Client, Firebase Storage & Hasura Server</h4><p></p><br><h4>8. Example with React (Material), Apollo Client, Firebase Storage & Hasura Server</h4><p></p>

Web Development

GraphQL

This course covers all the basics to more advanced features and dives into all the little details about Hasura.

Hasura provides a platform to create your GraphQL backends easier and faster than you ever thought possible without writing a single line of code!

Build Performant GraphQL Backends in Days Using Hasura

<div id="menu0">
									<div>
			<div>
				<div>
							<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Overview</span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This MySql Masterclass course will unlock your full potential and will show you how to <strong>excel in a career in MySql Masterclass</strong>. So upskill now and reach your full potential. Everything you need to get started in MySql Masterclass is available in this course.</p><p>Learning and progressing are the hallmarks of personal development. This MySql Masterclass will <strong>quickly teach you the must-have</strong> <strong>skills</strong> needed to start in the relevant industry.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div>
							
					<div></div>
										<div></div>
														
							
					<div></div>
										<div></div>
														
							
					<div></div>
										<div></div>
														
							
					<div></div>
										<div></div>
														
					</div>
			</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>In This MySql Masterclass Course, You Will:</span></strong></h3></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><ul><li>Learn strategies to boost your workplace efficiency.</li><li>Hone your MySql Masterclass skills to help you advance your career.</li><li>Acquire a comprehensive understanding of various MySql Masterclass topics and tips from industry experts.</li><li>Learn in-demand MySql Masterclass skills that are in <strong>high demand among UK employers</strong>, which will help you to kickstart your career.</li></ul></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This MySql Masterclass course covers everything you must know to stand against the tough competition in the MySql Masterclass field. </p><p>The future is truly yours to seize with this MySql Masterclass. Enrol today and complete the course to achieve a MySql Masterclass <strong>certificate</strong> that can change your professional career forever.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Additional Perks of Buying a Course From Institute of Mental Health</span></strong><b></b></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><ul><li>Study online - whenever and wherever you want.</li><li>One-to-one support from a dedicated tutor throughout your course.</li><li>Certificate immediately upon course completion</li><li>100% Money back guarantee</li><li>Exclusive discounts on your next course purchase from Institute of Mental Health </li></ul></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>Enrolling in the MySql Masterclass course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div></div>
				</div>
				</div>
				<div>
				<div>
					<div><h3><strong><span>Process of Evaluation</span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><section><div><div><div><div><div><div><div><div><p>After studying the MySql Masterclass course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate. </p></div></div></div></div></div></div></div></div></section></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Certificate of Achievement</span><span><br /></span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>Upon successfully completing the MySql Masterclass course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Who Is This Course for?</span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This MySql Masterclass is suitable for anyone aspiring to start a career in MySql Masterclass; even if you are new to this and have no prior knowledge on MySql Masterclass, this course is going to be very easy for you to understand. </p><p>And if you are already working in the MySql Masterclass field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. </p><p>Taking this MySql Masterclass course is a win-win for you in all aspects. </p><p>This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
				<section>
						<div>
				<div>
				<div>
			<div>
					<div>
				<div>
				<div>
					<div><h3><strong><span>Requirements</span></strong></h3></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This MySql Masterclass course has no prerequisite. </p><p>You don't need any educational qualification or experience to enrol in the MySql Masterclass course.</p><p>Do note: you must be at least 16 years old to enrol.</p><p>Any internet-connected device, such as a computer, tablet, or smartphone, can access this online MySql Masterclass course.</p><p>Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills.</p></div>
				</div>
				</div>
						</div>
			</div>
		</div>
						</div>
			</div>
		</section>
						</div>
			</div>
		</div>
								</div>
						<div id="menu1">
							<div>
											<div>
				<h3>
	<span>Course Curriculum</span>
</h3>

<div>
<table>				<tbody><tr>
					<td colspan="4">MySql Masterclass</td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 1: Introduction on MySQL</td>
					<td> </td>
					<td><span><i></i> 01:00:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 2: Data Types</td>
					<td> </td>
					<td><span><i></i> 00:51:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 3: SELECT Statements</td>
					<td> </td>
					<td><span><i></i> 00:59:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 4: Backticks</td>
					<td> </td>
					<td><span><i></i> 00:15:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 5: NULL</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 6: Limit and Offset</td>
					<td> </td>
					<td><span><i></i> 00:13:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 7: Creating databases</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 8: Using Variables</td>
					<td> </td>
					<td><span><i></i> 00:25:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 9: Comment MySQL</td>
					<td> </td>
					<td><span><i></i> 00:14:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 10: INSERT Statements</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 11: DELETE Statements</td>
					<td> </td>
					<td><span><i></i> 00:21:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 12: UPDATE Statements</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 13: ORDER BY Clause</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 14: Group By</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 15: Errors in MySQL</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 16: Joins</td>
					<td> </td>
					<td><span><i></i> 00:37:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 17: Joins continued</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 18: UNION</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 19: Arithmetic</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 20: String operations</td>
					<td> </td>
					<td><span><i></i> 00:33:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 21: Date and Time Operations</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 22: Handling Time Zones</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 23: Regular Expressions</td>
					<td> </td>
					<td><span><i></i> 00:19:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 24: VIEWS</td>
					<td> </td>
					<td><span><i></i> 00:20:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 25: Table Creation</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 26: ALTER TABLE</td>
					<td> </td>
					<td><span><i></i> 00:23:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 27: Drop Table</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 28: MySQL LOCK TABLE</td>
					<td> </td>
					<td><span><i></i> 00:10:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 29: Error codes</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 30: Stored routines (procedures and functions)</td>
					<td> </td>
					<td><span><i></i> 00:29:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 31: Indexes and Keys</td>
					<td> </td>
					<td><span><i></i> 00:24:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 32: Full-Text search</td>
					<td> </td>
					<td><span><i></i> 00:18:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 33: PREPARE Statements</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 34: JSON</td>
					<td> </td>
					<td><span><i></i> 00:11:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 35: Extract values from JSON type</td>
					<td> </td>
					<td><span><i></i> 00:05:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 36: MySQL Admin</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 37: TRIGGERS</td>
					<td> </td>
					<td><span><i></i> 00:12:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 38: Configuration and tuning</td>
					<td> </td>
					<td><span><i></i> 00:07:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 39: Events</td>
					<td> </td>
					<td><span><i></i> 00:08:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 40: ENUM</td>
					<td> </td>
					<td><span><i></i> 00:09:00</span></td>
				</tr>
								<tr>
					<td><i></i></td>
					<td>Module 41: Collations, Transactions, Log files, Replication, Backup</td>
					<td> </td>
					<td><span><i></i> 00:41:00</span></td>
				</tr>
				</tbody></table></div>

			</div>
									</div>
						</div>
						<div id="menu2">
							
						</div>

Overview
This MySql Masterclass course will unlock your full potential and will show you how to excel in a career in MySql Masterclass. So upskill now and reach your full potential. Everything you need to get started in MySql Masterclass is available in this course.
Learning and progressing are the hallmarks of personal development. This MySql Masterclass will quickly teach you the must-have skills needed to start in the relevant industry.
In This MySql Masterclass Course, You Will:
Learn strategies to boost your workplace efficiency.
Hone your MySql Masterclass skills to help you advance your career.
Acquire a comprehensive understanding of various MySql Masterclass topics and tips from industry experts.
Learn in-demand MySql Masterclass skills that are in high demand among UK employers, which will help you to kickstart your career.
This MySql Masterclass course covers everything you must know to stand against the tough competition in the MySql Masterclass field. 
The future is truly yours to seize with this MySql Masterclass. Enrol today and complete the course to achieve a MySql Masterclass certificate that can change your professional career forever.
Additional Perks of Buying a Course From Institute of Mental Health
Study online - whenever and wherever you want.
One-to-one support from a dedicated tutor throughout your course.
Certificate immediately upon course completion
100% Money back guarantee
Exclusive discounts on your next course purchase from Institute of Mental Health
Enrolling in the MySql Masterclass course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now.
Process of Evaluation
After studying the MySql Masterclass course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate. 
Certificate of Achievement

Upon successfully completing the MySql Masterclass course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99.
Who Is This Course for?
This MySql Masterclass is suitable for anyone aspiring to start a career in MySql Masterclass; even if you are new to this and have no prior knowledge on MySql Masterclass, this course is going to be very easy for you to understand. 
And if you are already working in the MySql Masterclass field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. 
Taking this MySql Masterclass course is a win-win for you in all aspects. 
This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education.
Requirements
This MySql Masterclass course has no prerequisite. 
You don't need any educational qualification or experience to enrol in the MySql Masterclass course.
Do note: you must be at least 16 years old to enrol.
Any internet-connected device, such as a computer, tablet, or smartphone, can access this online MySql Masterclass course.
Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills.
 Course Curriculum

MySql Masterclass			
	Module 1: Introduction on MySQL		01:00:00
	Module 2: Data Types		00:51:00
	Module 3: SELECT Statements		00:59:00
	Module 4: Backticks		00:15:00
	Module 5: NULL		00:18:00
	Module 6: Limit and Offset		00:13:00
	Module 7: Creating databases		00:18:00
	Module 8: Using Variables		00:25:00
	Module 9: Comment MySQL		00:14:00
	Module 10: INSERT Statements		00:29:00
	Module 11: DELETE Statements		00:21:00
	Module 12: UPDATE Statements		00:20:00
	Module 13: ORDER BY Clause		00:08:00
	Module 14: Group By		00:18:00
	Module 15: Errors in MySQL		00:10:00
	Module 16: Joins		00:37:00
	Module 17: Joins continued		00:11:00
	Module 18: UNION		00:18:00
	Module 19: Arithmetic		00:20:00
	Module 20: String operations		00:33:00
	Module 21: Date and Time Operations		00:08:00
	Module 22: Handling Time Zones		00:07:00
	Module 23: Regular Expressions		00:19:00
	Module 24: VIEWS		00:20:00
	Module 25: Table Creation		00:23:00
	Module 26: ALTER TABLE		00:23:00
	Module 27: Drop Table		00:05:00
	Module 28: MySQL LOCK TABLE		00:10:00
	Module 29: Error codes		00:08:00
	Module 30: Stored routines (procedures and functions)		00:29:00
	Module 31: Indexes and Keys		00:24:00
	Module 32: Full-Text search		00:18:00
	Module 33: PREPARE Statements		00:09:00
	Module 34: JSON		00:11:00
	Module 35: Extract values from JSON type		00:05:00
	Module 36: MySQL Admin		00:08:00
	Module 37: TRIGGERS		00:12:00
	Module 38: Configuration and tuning		00:07:00
	Module 39: Events		00:08:00
	Module 40: ENUM		00:09:00
	Module 41: Collations, Transactions, Log files, Replication, Backup		00:41:00

IOMH - Institute of Mental Health

Database

Data Entry

Data Architecture

MySql Masterclass

<strong>MySQL: Learn how to use MySQL and PHP to build reports and work with databases for web applications</strong>
        <p>This course will take you on a journey where you'll establish the strongest possible foundation in database development by learning how to use MySQL (the most popular open source database in the world), write queries, create reports, build web applications, and incorporate MySQL as the database layer. Turn your development dreams into a reality by taking this course and putting a check mark next to your growing development skillset.

You will learn to: 
&bull;	Set up MySQL
&bull;	Work with online IDEs
&bull;	Create databases and queries
&bull;	Use logical operators
&bull;	Manipulate tables/rows/data
&bull;	Understand how joins work and use them
&bull;	Create admin features
&bull;	Implement deployment production
&bull;	And a lot more

All the code files are placed at https://github.com/PacktPublishing/The-Complete-MySQL-Developer-Course</p>
        <h2>What You Will Learn</h2><p>Build web applications using MySQL and PHP<br>Establish a solid foundation for databases and SQL <br>Learn how joins work and use them <br>Build web applications with PHP, HTML, and CSS, with MySQL as the database layer <br>Perform CRUD operations and authentication from web applications <br>Create admin features <br>Implement deployment production</p>
        <h2>Audience</h2><p>This course is designed for anyone keen to learn MySQL and database technologies, build web applications, or make a career in the tech industry.</p>
        <h2>Approach</h2><p>This course is a seamless blend of text, videos, and code examples that will help you learn efficiently as you progress through the course. You'll start with the absolute basics (installing and creating databases) and work your way through building web applications with MySQL as the database. By the end of this course, you'll be able to apply what you've learnt and do virtually anything you want with databases.</p>
        <h2>Key Features</h2><p>Learn to build reports and web applications using MySQL and PHP  * Establish a strong foundation for databases and SQL</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/the-complete-mysql-developer-course</p>
        <h2>About the Author</h2><h3>Codestars By Rob Percival</h3><p>Rob Percival is a highly regarded web developer and Udemy instructor with over 1.7 million students. Over 500,000 of them have taken Rob's Complete Web Developer Course 2.0, as well as his Android Developer and iOS Developer courses.</p>
        <h2>Course Outline</h2><h4>1. Introduction to the course and MySQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction</p><p style='margin: 0'>This video introduces the course</p></td></tr><tr><td style='padding: 15px;'><p>2. Development environment overview</p><p style='margin: 0'>This video tells you why to use an online IDE to develop code in this course</p></td></tr><tr><td style='padding: 15px;'><p>3. Sign up for cloud based IDE for development</p><p style='margin: 0'>Learn to use cloud9 to sign up for development environment</p></td></tr></tbody></table><br><h4>2. Creating Databases and Introduction to Queries</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Power of Databases</p><p style='margin: 0'>Learn MySQL and understand how wide is it's reach</p></td></tr><tr><td style='padding: 15px;'><p>2. Create a Database/Schema</p><p style='margin: 0'>Learn how to create a database/schema</p></td></tr><tr><td style='padding: 15px;'><p>3. Intro to tables and conventions used</p><p style='margin: 0'>This video look at tables, structures for queries and syntax used in the course</p></td></tr><tr><td style='padding: 15px;'><p>4. Working with tables</p><p style='margin: 0'>Learn how to work with tables in databases</p></td></tr><tr><td style='padding: 15px;'><p>5. Inserting rows of data</p><p style='margin: 0'>Learn how to insert data into tables</p></td></tr><tr><td style='padding: 15px;'><p>6. Select</p><p style='margin: 0'>Learn about "select" in MySQL</p></td></tr><tr><td style='padding: 15px;'><p>7. Concat and substring</p><p style='margin: 0'>Learn how to work with the concat and substring operators</p></td></tr><tr><td style='padding: 15px;'><p>8. Homework challenge - bowling scores!</p><p style='margin: 0'>This video is about Homework code challenge</p></td></tr><tr><td style='padding: 15px;'><p>9. Solution - bowling score challenge</p><p style='margin: 0'>This video is about Solution - bowling score challenge</p></td></tr><tr><td style='padding: 15px;'><p>10. Alternate method of homework solution - script</p><p style='margin: 0'>This video shows how to use scripts to develop code and running them instead of using the console</p></td></tr><tr><td style='padding: 15px;'><p>11. MySQL, Oracle, SQL Server</p><p style='margin: 0'>This video will have a look at SQL</p></td></tr><tr><td style='padding: 15px;'><p>12. Limit, order by and distinct</p><p style='margin: 0'>Learn how to use additional features like limit, order by and distinct</p></td></tr><tr><td style='padding: 15px;'><p>13. Count, like and group by</p><p style='margin: 0'>Learn how to use count, like and group by features</p></td></tr><tr><td style='padding: 15px;'><p>14. Min and max</p><p style='margin: 0'>Learn how to use min and max</p></td></tr><tr><td style='padding: 15px;'><p>15. Code challenge project - create a new report</p><p style='margin: 0'>This video is about code challenge to create a new report</p></td></tr></tbody></table><br><h4>3. Logical operators and dates</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Data types in MySQL</p><p style='margin: 0'>Learn about different data types and their features</p></td></tr><tr><td style='padding: 15px;'><p>2. Where and not equal</p><p style='margin: 0'>Learn the details about where and how to use it, along with not equal</p></td></tr><tr><td style='padding: 15px;'><p>3. Comparison operators</p><p style='margin: 0'>This video is about working with comparison operators</p></td></tr><tr><td style='padding: 15px;'><p>4. Or</p><p style='margin: 0'>This video describes working with "Or"</p></td></tr><tr><td style='padding: 15px;'><p>5. Null and blanks</p><p style='margin: 0'>This video is about working with null entries and blanks</p></td></tr><tr><td style='padding: 15px;'><p>6. Case statements</p><p style='margin: 0'>This video is about Working with case</p></td></tr><tr><td style='padding: 15px;'><p>7. Dates and times</p><p style='margin: 0'>Learn how to work with date and time formats</p></td></tr><tr><td style='padding: 15px;'><p>8. Date, time and math</p><p style='margin: 0'>This video is about Date, time and math.</p></td></tr><tr><td style='padding: 15px;'><p>9. Section 3 final project - Create a report on birthdays</p><p style='margin: 0'>This video creates a report on birthdays.</p></td></tr></tbody></table><br><h4>4. Update and delete rows</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Update</p><p style='margin: 0'>This video shows how to update rows of data in tables</p></td></tr><tr><td style='padding: 15px;'><p>2. Update based on comparison</p><p style='margin: 0'>This video gives you more info and usage of update</p></td></tr><tr><td style='padding: 15px;'><p>3. Delete</p><p style='margin: 0'>This video shows how to use delete to remove data</p></td></tr></tbody></table><br><h4>5. Multiple tables and JOINS</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Primary keys, foreign keys</p><p style='margin: 0'>Learn about primary and foreign keys</p></td></tr><tr><td style='padding: 15px;'><p>2. Data prep for joins</p><p style='margin: 0'>This video shows to setup tables and data to work with joins</p></td></tr><tr><td style='padding: 15px;'><p>3. Joins and aliases</p><p style='margin: 0'>Learn about joins and using aliases</p></td></tr><tr><td style='padding: 15px;'><p>4. More about joins</p><p style='margin: 0'>Learn about Joins more in-depth</p></td></tr><tr><td style='padding: 15px;'><p>5. Inner, Left, Outer, Right joins</p><p style='margin: 0'>Learn about inner, left, outer and right joins</p></td></tr><tr><td style='padding: 15px;'><p>6. Left outer joins</p><p style='margin: 0'>Learn about left joins</p></td></tr><tr><td style='padding: 15px;'><p>7. Fix a bad join challenge</p><p style='margin: 0'>This video shows how to fix a bad join</p></td></tr><tr><td style='padding: 15px;'><p>8. Subselects</p><p style='margin: 0'>Learn about subselects</p></td></tr><tr><td style='padding: 15px;'><p>9. More subselects</p><p style='margin: 0'>This video is about Subselects more in-depth</p></td></tr><tr><td style='padding: 15px;'><p>10. Section 5 - Final Project Part 1</p><p style='margin: 0'>This video is Part 1 of final project for section 5</p></td></tr><tr><td style='padding: 15px;'><p>11. Section 5 - Final Project Part 2</p><p style='margin: 0'>This video is Part 2 of final project for section 5</p></td></tr></tbody></table><br><h4>6. Web apps - Data collection from a survey</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to Web App Development</p><p style='margin: 0'>This video is an Intro to building web applications</p></td></tr><tr><td style='padding: 15px;'><p>2. HTML and CSS</p><p style='margin: 0'>This video is about working with HTML and CSS - web building blocks</p></td></tr><tr><td style='padding: 15px;'><p>3. Start form collector project</p><p style='margin: 0'>This video starts the web app</p></td></tr><tr><td style='padding: 15px;'><p>4. Add styling to form</p><p style='margin: 0'>This video shows how to add styling to the form collector</p></td></tr><tr><td style='padding: 15px;'><p>5. Create table</p><p style='margin: 0'>This video shows how to create a table for the app using sql</p></td></tr><tr><td style='padding: 15px;'><p>6. Config and other php</p><p style='margin: 0'>This video shows to create a config file along with other php</p></td></tr><tr><td style='padding: 15px;'><p>7. Complete receiver</p><p style='margin: 0'>This video contains code for receiver.php</p></td></tr><tr><td style='padding: 15px;'><p>8. Start SQL Functons</p><p style='margin: 0'>This video is about working on SQLFunctions file</p></td></tr><tr><td style='padding: 15px;'><p>9. Preview and understand steps taken for web app</p><p style='margin: 0'>This video is about the steps taken for web app</p></td></tr><tr><td style='padding: 15px;'><p>10. Add browser display</p><p style='margin: 0'>This video shows to add a browser display for the web app</p></td></tr><tr><td style='padding: 15px;'><p>11. Project - Convert to poll!</p><p style='margin: 0'>This video is about the Final project for section 6</p></td></tr></tbody></table><br><h4>7. CRUD and PHP</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. CRUD - Introduction</p><p style='margin: 0'>This video is an introduction to CRUD</p></td></tr><tr><td style='padding: 15px;'><p>2. Create action</p><p style='margin: 0'>This video shows how to build the create action for the To Do app</p></td></tr><tr><td style='padding: 15px;'><p>3. Read</p><p style='margin: 0'>This video shows to Implement Read action for app</p></td></tr><tr><td style='padding: 15px;'><p>4. Update action</p><p style='margin: 0'>This video shows how to Implement update action for the app</p></td></tr><tr><td style='padding: 15px;'><p>5. Delete action</p><p style='margin: 0'>This video Implements the delete action for to-do's</p></td></tr></tbody></table><br><h4>8. Authentication with PHP and MySQL</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Introduction to authentication</p><p style='margin: 0'>This video is an introduction to authentication</p></td></tr><tr><td style='padding: 15px;'><p>2. Complete user sign-up</p><p style='margin: 0'>This video is about complete user sign-up</p></td></tr><tr><td style='padding: 15px;'><p>3. Login users</p><p style='margin: 0'>This video Implements log in and log out functionality</p></td></tr><tr><td style='padding: 15px;'><p>4. Enforce log in for app</p><p style='margin: 0'>This video shows how to add requirements to users to be logged in</p></td></tr><tr><td style='padding: 15px;'><p>5. Sessions</p><p style='margin: 0'>Learn about Sessions.</p></td></tr></tbody></table><br><h4>9. Challenge section - Build a WebAdmin site</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Challenge section intro and get started</p><p style='margin: 0'>This video introduces challenge section</p></td></tr><tr><td style='padding: 15px;'><p>2. Challenge section project day 2</p><p style='margin: 0'>This video contains day 2 items of challenge project</p></td></tr><tr><td style='padding: 15px;'><p>3. Project day 3, 4 and 5</p><p style='margin: 0'>This video contains day 3, 4 and 5 items of challenge project</p></td></tr><tr><td style='padding: 15px;'><p>4. Project day 6, 7 and completion</p><p style='margin: 0'>This video contains items of Project day 6 and 7 leading to completion</p></td></tr></tbody></table><br><h4>10. Deploy to production</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Deploy to production using a hosting service</p><p style='margin: 0'>This video shows how to deploy web apps to production using a hosting service</p></td></tr></tbody></table><br><h4>11. Stored Procedures and Scheduled jobs</h4><p></p><table width='100%'><tbody><tr><td style='padding: 15px;'><p>1. Thank you</p><p style='margin: 0'>This video tells thank you for taking the course.</p></td></tr></tbody></table>

Database Programming

MySQL

MySQL: Learn how to use MySQL and PHP to build reports and work with databases for web applications

The Complete MySQL Developer Course

<strong>This course will help you to get familiarized with the concepts of MySQL Server and MySQL Workbench needed for database development and management. From basic SQL queries and statements to handling relationships and aggregate functions, you will learn all that you need with the help of real-time activities.</strong>
        <p>MySQL is a database that is used by the biggest social media platforms, such as Facebook, Twitter, and YouTube. Thanks to its performance, reliability, and ease-of-use, MySQL has become one of the most popular open-source databases. This course will help you get to grips with the fundamentals of the two most powerful MySQL assets-MySQL Server and MySQL Workbench-for effectively designing and maintaining databases.
The course begins with an introduction to MySQL Server and its databases and demonstrates the process of installing MySQL Server and MySQL Workbench on your machine. Once the setup is complete, you'll explore the concepts of manipulating data and tables with MySQL queries. Moving on, you will discover how to connect, create, and remove a database; how to insert data into the table using SQL scripts and Workbench; how to select, update, and delete data in the table; along with learning some CRUD operations. As you progress, you'll understand the importance of relationships, foreign keys, and normalization in MySQL. Finally, you will delve into aggregate functions, such as AVG, COUNT, MIN, and MAX, and find out how to perform calculations on a set of values and return a single value.
By the end of this course, you'll have gained the basic MySQL Server and MySQL Workbench skills needed to design and maintain databases.

The code files are placed here: https://github.com/PacktPublishing/MySQL-Database-Development-Mastery</p>
        <h2>What You Will Learn</h2><p>Familiarize yourself with MySQL Server and MySQL Workbench<br>Find out how to create a database from scratch<br>Manipulate data and tables with CRUD operations<br>Create relationships with the Workbench table design tool<br>Use aggregate functions to perform quick mathematical operations<br>Export your query results to an Excel sheet using MySQL Workbench</p>
        <h2>Audience</h2><p>Whether you are a beginner-level or an experienced database administrator or developer looking to get familiar with MySQL Server and MySQL Workbench database development techniques, this course is for you. You can get started with this course without any prior knowledge of database concepts.</p>
        <h2>Approach</h2><p>With the help of useful examples and activities, this course will help you learn how to use MySQL Server and MySQL Workbench for designing and managing databases.</p>
        <h2>Key Features</h2><p>Discover how to create and manage databases in MySQL Server and MySQL Workbench * Gain a comprehensive understanding of SQL queries, statements, and structures * Build a small school management database to understand the development principles of a database</p>
        <h2>Github Repo</h2><p>https://github.com/PacktPublishing/MySQL-Database-Development-Mastery</p>
        <h2>About the Author</h2><h3>Trevoir Williams</h3><p>Trevoir Williams is a software engineer and part-time lecturer. With a master's degree in computer science, he has spent over a decade teaching web, software, and database development courses. He also has extensive industry experience in web application development, Azure Cloud system, and server administration.

He enjoys teaching IT and development courses and hopes to impart knowledge of the latest developments in industry standards and techniques to his students.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><br><h4>2. Manipulating Tables and Data - CRUD Operations</h4><p></p><br><h4>3. Relationships and Foreign Keys</h4><p></p><br><h4>4. Aggregate Functions</h4><p></p><br><h4>5. BONUS Discounts</h4><p></p>

This course will help you to get familiarized with the concepts of MySQL Server and MySQL Workbench needed for database development and management. From basic SQL queries and statements to handling relationships and aggregate functions, you will learn all that you need with the help of real-time activities.

MySQL Database Development Mastery

<strong>Explore the quick and easy way to learn the MySQL Database with Python</strong>
        <p>Today databases are highly valued as they allow users to effectively manage, access, and update data. MySQL is one of the most popular databases and has a wide variety of applications in e-commerce, data warehousing, and website management. When combined with Python, one of the most popular and powerful programming languages today, you'll be able to manage data efficiently and systematically.

In this course, you'll get started by understanding the basics of using MySQL with Python. You'll learn how to install MySQL and Python, before going on to develop databases. In addition to this, you'll explore the technique of creating tables for safely storing data. The course will then guide you on how to add, sort, and retrieve data through functions such as INSERT, ORDER BY, and SELECT. As you progress, you'll be equipped with the knowledge of inserting a single record as well as multiple records into a table. Toward the end, you will discover clauses such as WHERE and LIKE, and later learn to update records.

By the end of this course, you will have learned how to confidently use Python with MySQL for your database management needs.  

All code files are placed at https://github.com/PacktPublishing/Using-MySQL-Databases-With-Python</p>
        <h2>What You Will Learn</h2><p>Get up to speed with the working of a database<br>Understand how to install Python, MySQL, Git Bash, and MySQL Connector<br>Work through creating a table<br>Explore how to connect to a database in Python<br>Update and delete data from the database<br>Discover the technique of inserting a single record as well as multiple records into a table<br>Create basic reports with the data from your database</p>
        <h2>Audience</h2><p>This course is for anyone who wants to use the MySQL Database with Python. Although a basic understanding of Python programming is required, knowledge of databases or MySQL is not necessary.</p>
        <h2>Approach</h2><p>A complete course packed with step-by-step instructions, working examples, and helpful advice.</p>
        <h2>Key Features</h2><p>Learn to use MySQL databases with Python * Get to grips with adding, sorting and pulling specific data</p>
        <h2>Github Repo</h2><p>https://github.com/packtpublishing/using-mysql-databases-with-python</p>
        <h2>About the Author</h2><h3>John Elder</h3><p>John Elder is a pioneer in Web Development who created one of the first Internet advertising networks back in 1997. He sold it to a publicly traded company at the height of the dot com boom and then went on to create the best-selling Submission-Spider search engine submission software that's been used by over 3 million individuals and small businesses in over 45 countries.

John graduated with honors with a degree in economics from Washington University in St. Louis where he was an artsci scholar. Today he teaches Web Development courses at Codemy the online code school he founded.</p>
        <h2>Course Outline</h2><h4>1. Introduction</h4><p></p><br><h4>2. What is a Database</h4><p></p><br><h4>3. Install Python</h4><p></p><br><h4>4. Install Git Bash Terminal</h4><p></p><br><h4>5. Download MySQL</h4><p></p><br><h4>6. Install MySQL and Workbench</h4><p></p><br><h4>7. Install MySQL Connector</h4><p></p><br><h4>8. Connect to Database in Python</h4><p></p><br><h4>9. Explore MySQL Workbench</h4><p></p><br><h4>10. Create a Database</h4><p></p><br><h4>11. Create a Table</h4><p></p><br><h4>12. Insert One record into table</h4><p></p><br><h4>13. Insert Many records into Table</h4><p></p><br><h4>14. Understanding Data Types</h4><p></p><br><h4>15. Select Data from Table</h4><p></p><br><h4>16. Format our results</h4><p></p><br><h4>17. The Where Clause</h4><p></p><br><h4>18. Using AND and OR</h4><p></p><br><h4>19. The Like Clause and Wild cards</h4><p></p><br><h4>20. Updating Records</h4><p></p><br><h4>21. Limit and Ordering</h4><p></p><br><h4>22. Delete Records</h4><p></p><br><h4>23. Delete (Drop) a Table and Backups</h4><p></p>

Explore the quick and easy way to learn the MySQL Database with Python

Using MySQL Databases with Python

Develop your SQL skills, with useful insights into the MySQL syntax, SQL join statements, and more

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Master MySQL by learning all the web development skills for creating complex, high-quality web databases.</span></p><p><span>The <strong>Basic MySQL Online Course</strong> covers the complete fundamentals of MySQL for relational database management, e-commerce and logging applications. It is designed to equip learners with in-demand industry skills, taking them through the basics such as installation, for those who are new to the field. </span></p><p><span>This practical training course will explore all the core features of MySQL, as well as best practices for cross platform development, taught by an experienced professional in the field. If you are looking to establish a career in programming or computer science, then this in-depth training will ensure you gain a competitive edge in the job market.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>Basic MySQL Online Course </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>Basic MySQL Online Course </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>Basic MySQL Online Course </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>Basic MySQL Online Course </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the<strong> Basic MySQL Online Course</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>Basic MySQL Online Course </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>Basic MySQL Online Course </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

Basic MySQL Online Course

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Become a PHP &amp; MySQL pro by learning all the web development features for creating websites.</span></p><p><span>The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding</strong> course covers everything you need to know to master PHP programming and gain valuable industry skills. It will take you through the fundamentals of PHP and MySQL, starting from the very basics for complete beginners. </span></p><p><span>Through this in-depth training course, you will familiarise with all the features of MySQL, and learn best practices for cross platform development, taught by an expert in the field. If you are looking to kickstart a career in programming or computer science, then this course will equip you with up-to-date skills that will ensure you gain a competitive edge in the job market.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the<strong> PHP &amp; MySQL Web Development &amp; OOP Coding</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>PHP &amp; MySQL Web Development &amp; OOP Coding </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

PHP & MySQL Web Development & OOP Coding

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p>The comprehensive MySQL Database Development has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the MySQL Database Development today, and learn from the very best the industry has to offer!</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p>This best selling MySQL Database Development has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth MySQL Database Development is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The MySQL Database Development is CPD-accredited, so you can be confident you're completing a quality training course which will boost your CV and enhance your career potential. The MySQL Database Development is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the MySQL Database Development, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the MySQL Database Development will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the MySQL Database Development to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

MySQL Database Development

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<div>
				<div>
					<div><p><span>The comprehensive Complete MySql has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Complete MySql today, and learn from the very best the industry has to offer!</span></p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div><p><span>This best selling Complete MySql has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Complete MySql is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</span></p><p><span><span>The Complete MySql is CPD-accredited, so you can be confident you're completing a quality training course  will boost your CV and enhance your career potential. The Complete MySql is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</span></span></p><p><span><span>After successfully completing the Complete MySql, you will be awarded a certificate of completion  as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Complete MySql will help you stand out from the crowd. You can also validate your certification on our website.</span></span></p><p><span><span>We know that you are busy and that time is precious, so we have designed the Complete MySql to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </span></span></p><p><span><span>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</span></span></p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>

Complete MySql

<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
			<h2><b>Course Overview</b></h2>		</div>
				</div>
				<div>
				<div>
					<div><p><span>Learn how to Install and configure NGINX on Ubuntu step-by-step. Includes MySQL, PHP, PhpMyAdmin, WordPress &amp; SSL integration.</span></p><p><span>NGINX is one of the most powerful Web Server technologies in the world. In this course, you will learn how to install NGINX on a DigitalOcean droplet or any virtual server of your choice, with complete step-by-step guidance. It also covers key topics such as the differences between Apache &amp; NGINX, configuring DNS one files, and creating a database for WordPress.</span></p><p><span>This practical training course is a great introduction to NGINX and other open source software, ideal for students interested in web development and web design. There are no specific entry requirements for this course, which can be studied on a part-time or full-time basis.</span></p></div>
				</div>
				</div>
				<div>
				<div>
					<div><p>This best selling <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>is suitable for anyone who wants to build their professional skill set and improve their expert knowledge.</p><p>The <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn.</p><p>After successfully completing the<strong> Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu</strong>, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>will help you stand out from the crowd. You can also validate your certification on our website.</p><p>We know that you are busy and that time is precious, so we have designed the <strong>Install NGINX, PHP, MySQL, SSL &amp; WordPress on Ubuntu </strong>to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device. </p><p>Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.</p></div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div><div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					</div>
				</div>
				<section>
						<div>
							<div>
					<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
				<div>
			<div>
							<div>
						<div>
				<div>
					<div>
											
															
											</div>
				</div>
				</div>
						</div>
					</div>
		</div>
								</div>
					</div>
		</section>
						</div>
					</div>
		</div>
								</div>
					</div>

332 Courses

WordPress Developer Basics Course

By One Education

WordPress Developer Basics Course

By One Education

Face the Cyber Frontier: Become a Cyber Security Specialist Course

By One Education

Face the Cyber Frontier: Become a Cyber Security Specialist Course

By One Education

Software Engineering: Master Programming, Web Design & Development

By Academy for Health and Fitness

Docker - A Beginner's Hands-On Guide

By Packt

Python Object-Oriented Programming: Hands-on for Beginners [Updated for 2021]

By Packt

Advanced Diploma in Web Development

By Course Cloud

Python Programming for Beginners: Hands-on (Online Lab)

By Packt

Build Performant GraphQL Backends in Days Using Hasura

By Packt

Search By Location