57 PostgreSQL courses in Cardiff delivered On Demand

Learn how to build and test APIs and web services, which form the foundation of most software engineer work with the help of this carefully structured beginner's level course. You will be learning all of this in Python, one of the world's most popular and widely used programming languages.

Experience the future of geographical analysis with our Machine Learning for Predictive Maps in Python and Leaflet course. Master the unique blend of programming, machine learning, and geographic information systems, all while honing your ability to predict and visualise spatial data in a powerful and effective way. This course offers you an unparalleled understanding of modern map creation, combined with the magic of prediction using machine learning models. Starting from the ground up, you'll be introduced to all the necessary setups and installations. After that, you will be diving into the depth of Django server-side code and front-end application code writing. The heart of the course lies in learning how to automate the machine learning pipeline, leading you to easily create predictive models.  Improve your maps with Leaflet programming, making your predictions accurate and also visually striking. By the end of this course, you will be armed with experience furnished by our comprehensive project source code and assignments, empowering you to drive data-driven decisions and insightful spatial analysis. Join us and map your way to success! Sign up today. Learning Outcomes:Upon completion of the Machine Learning course, you will be able to: Understand how to set up and install relevant software and libraries.Master Django server-side and application front-end code writing.Gain proficiency in the concepts and implementation of Machine Learning.Learn to automate Machine Learning pipelines for efficient workflows.Acquire skills in Leaflet programming for enhanced map visuals.Handle project source code effectively for real-world projects.Apply knowledge practically via assignments and gain experience. Who is this course for?This Machine Learning course is ideal for: Aspiring Data Scientists keen on harnessing geographical data.GIS professionals aiming to integrate Machine Learning into their skill set.Software Developers interested in creating geographically-focused applications.Analysts keen on enhancing their data visualisation skills with mapping. CertificationAfter studying the course materials of the Machine Learning for Predictive Maps in Python and Leaflet course, there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test, you have a range of certification options to choose from. You can claim a CPD Accredited PDF Certificate for £4.99, a CPD Accredited Hardcopy Certificate at £8.00, or you may choose to receive a PDF Transcript for £4.99 or a Hardcopy Transcript for £9.99. Select according to your needs, and we assure timely delivery of your chosen certificate. RequirementsThis professionally designed Machine Learning for Predictive Maps in Python and Leaflet course does not require you to have any prior qualifications or experience. It is open to everyone. You will be able to access the course from anywhere at any time. Just enrol and start learning! Career Path:Our Machine Learning course will help you to pursue a range of career paths, such as: Junior Data Analyst: £25,000 - £35,000 annually.Data Scientist: £40,000 - £60,000 annually.GIS Analyst: £30,000 - £45,000 annually.Geospatial Software Developer: £35,000 - £55,000 annually.Machine Learning Engineer: £50,000 - £80,000 annually.Lead Data Scientist (GIS speciality): £70,000 - £100,000+ annually. Course Curriculum Section 01: Introduction Introduction 00:10:00 Section 02: Setup and Installations Python Installation 00:04:00 Creating a Python Virtual Environment 00:07:00 Installing Django 00:09:00 Installing Visual Studio Code IDE 00:06:00 Installing PostgreSQL Database Server Part 1 00:03:00 Installing PostgreSQL Database Server Part 2 00:09:00 Section 03: Writing the Django Server-Side Code Adding the settings.py Code 00:07:00 Creating a Django Model 00:10:00 Adding the admin.py Code 00:21:00 Section 04: Writing the Application Front-end Code Creating Template Files 00:10:00 Creating Django Views 00:10:00 Creating URL Patterns for the REST API 00:09:00 Adding the index.html code 00:04:00 Adding the layout.html code 00:19:00 Creating our First Map 00:10:00 Adding Markers 00:16:00 Section 05: Machine Learning Installing Jupyter Notebook 00:07:00 Data Pre-processing 00:31:00 Model Selection 00:20:00 Model Evaluation and Building a Prediction Dataset 00:11:00 Section 06: Automating the Machine Learning Pipeline Creating a Django Model 00:04:00 Embedding the Machine Learning Pipeline in the Application 00:42:00 Creating a URL Endpoint for our Prediction Dataset 00:06:00 Section 07: Leaflet Programming Creating Multiple Basemaps 00:09:00 Creating the Marker Layer Group 00:10:00 Creating the Point Layer Group 00:12:00 Creating the Predicted Point Layer Group 00:07:00 Creating the Predicted High Risk Point Layer Group 00:12:00 Creating the Legend 00:09:00 Creating the Prediction Score Legend 00:15:00 Section 08: Project Source Code Resource 00:00:00 Assignment Assignment - Machine Learning for Predictive Maps in Python and Leaflet 00:00:00

Get hands-on with Kafka monitoring setup with Prometheus and Grafana, Kafka operations and Kafka cluster upgrades Setup in AWS.

Course Overview Take geospatial figures and turn them into functional applications for multiple uses by learning how to Create Smart Maps in Python and Leaflet Level 3. This intuitive training will give you expert guidance on using a wide variety of tools and methods to create impressive IT projects for professional or personal use. This comprehensive Python tutorial coaching experience provides expert tuition for using essential platforms such as PostgreSQL and PostGIS. Using step-by-step instructions and professional education, you will use this gained knowledge to become more proficient in writing many types of Python GIS applications from scratch and achieve impressive programming feats. It will help you attain an amazing range of IT skills, making you a valuable commodity in the IT sector. This best selling Create Smart Maps in Python and Leaflet Level 3 has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Create Smart Maps in Python and Leaflet Level 3 is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Create Smart Maps in Python and Leaflet Level 3 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 Create Smart Maps in Python and Leaflet Level 3 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. After successfully completing the Create Smart Maps in Python and Leaflet Level 3, 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 Create Smart Maps in Python and Leaflet Level 3 will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Create Smart Maps in Python and Leaflet Level 3 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.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

This course will help you become familiar with the process of building web applications in Python. From understanding Python fundamentals, to studying the database structure to building, and deploying applications, you will learn it all with the help of interesting activities

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!

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Course Overview! 00:04:00 Installation And Getting Started The Final Milestone! 00:01:00 Installing and setting up PostgreSQL 00:09:00 Case Study : Demo Case Study Part 1 00:04:00 Case Study Part 2 00:06:00 Fundamental SQL statements CREATE 00:11:00 Exercise 1: Create DB and Table 00:01:00 INSERT 00:09:00 Import data from File 00:05:00 Exercise 2: Inserting and Importing 00:01:00 SELECT statement 00:03:00 SELECT DISTINCT 00:06:00 WHERE 00:04:00 Logical Operators 00:06:00 Exercise 3: SELECT & WHERE 00:01:00 UPDATE 00:05:00 DELETE 00:04:00 ALTER 00:17:00 Exercise 4: Updating Table 00:01:00 Restore And Back-Up Restore and Back-up 00:07:00 Exercise 5: Restore and Back-up 00:01:00 Selection Commands: Filtering IN 00:04:00 BETWEEN 00:05:00 LIKE 00:08:00 Exercise 6: In, Like & Between 00:01:00 Selection Commands: Ordering Side Lecture: Commenting in SQL 00:01:00 ORDER BY 00:07:00 LIMIT 00:03:00 Exercise 7: Sorting 00:01:00 Alias AS 00:03:00 Aggregate Commands COUNT 00:05:00 SUM 00:03:00 AVERAGE 00:03:00 MIN & MAX 00:04:00 Exercise 8: Aggregate functions 00:01:00 Group By Commands GROUP BY 00:12:00 HAVING 00:05:00 Exercise 9: Group By 00:01:00 Conditional Statement CASE WHEN 00:05:00 Joins Introduction to Joins 00:02:00 Inner Join 00:08:00 Left Join 00:07:00 Right Join 00:06:00 Full Outer Join 00:05:00 Cross Join 00:04:00 Except 00:03:00 Union 00:03:00 Exercise 10: Joins 00:01:00 Subqueries Subqueries 00:14:00 Exercise 11: Subqueries 00:01:00 Views And Indexes VIEWS 00:07:00 INDEX 00:06:00 Exercise 12: Views 00:01:00 String Functions LENGTH 00:03:00 Upper Lower 00:02:00 REPLACE 00:04:00 TRIM, LTRIM, RTRIM 00:07:00 CONCATENATION 00:03:00 SUBSTRING 00:06:00 LIST AGGREGATION 00:05:00 Exercise 13: String Functions 00:02:00 Mathematical Functions CEIL & FLOOR 00:03:00 RANDOM 00:05:00 SETSEED 00:04:00 ROUND 00:02:00 POWER 00:02:00 Exercise 14: Mathematical Functions 00:01:00 Date-Time Functions CURRENT DATE & TIME 00:04:00 AGE 00:03:00 EXTRACT 00:08:00 Exercise 15: Date-time functions 00:01:00 Pattern (String) Matching PATTERN MATCHING BASICS 00:07:00 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 00:15:00 Exercise 16: Pattern Matching 00:01:00 Data Type Conversion Functions Converting Numbers/ Date to String 00:11:00 Converting String to Numbers/ Date 00:06:00 User Access Control Functions User Access Control 00:13:00 Bonus Section: Nail That Interview! Tablespace 00:05:00 PRIMARY KEY & FOREIGN KEY 00:05:00 ACID compliance 00:06:00 Truncate 00:04:00 Performance Tuning Tips TIP 1 (EXPLAIN) 00:04:00 TIP 2 00:01:00 TIP 3 00:02:00 TIP 4 (VACCUM) 00:01:00 TIP 5 00:02:00 TIP 6 (STRING FUNCTIONS) 00:02:00 TIP 7 (JOINS) 00:02:00 TIP 8 (SCHEMAS) 00:04:00 Bonus Section : Database Basics What is SQL 00:02:00 Tables and DBMS 00:03:00 Types of SQL commands 00:04:00 PostgreSQL 00:02:00 The Final Milestone! 00:01:00 Supplementary Resources Supplementary Resources - SQL Masterclass 00:00:00 Assessment Assessment - SQL Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview This comprehensive course on Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4. It is available to all students, of all academic backgrounds. Requirements Our Web Scraping and Mapping Dam Levels in Python and Leaflet Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 8 sections • 22 lectures • 04:20:00 total length •Introduction: 00:16:00 •Installing PostgreSQL and PostGIS: 00:08:00 •Creating the Application Database: 00:03:00 •Installing Django in a Python Virtual Environment: 00:08:00 •Installing the ATOM IDE: 00:09:00 •Creating the Django Base Project: 00:08:00 •Adding the Database Configuration to the settings.py File: 00:09:00 •Creating a Model in the models.py File: 00:07:00 •Extracting Data from the Web: 00:24:00 •Cleaning and Transforming the Data Part 1: 00:18:00 •Cleaning and Transforming the Data Part 2: 00:10:00 •Loading the Data into the Model: 00:12:00 •Adding the Web Map Tile Service Link in settings.py: 00:08:00 •Reading from the Model and Creating a GeoJSON Dataset: 00:12:00 •Adding Template Files (HTML): 00:10:00 •Adding a Layout and the Base Map: 00:25:00 •Plotting Circle Markers: 00:16:00 •Creating a Sliding Sidebar: 00:14:00 •Creating a Doughnut Chart: 00:19:00 •Creating a Multi-Bar Bar Chart: 00:12:00 •Creating a Multi-Bar Bar Chart: 00:12:00 •Resource: 00:00:00

Explore everything that Vue.js has to offer from the ground up, all while building 4 projects to put your knowledge into practice. You will learn all of the essential Vue skills, along with the new Vue.js 3 features and syntax.

Feeling Stuck in Your Career? TheWeb Application Penetration Testing - 30 CoursesBundle is Your Skill-Building Solution. This exceptional collection of 30 premium courses is designed to encourage growth and improve your career opportunities. Suited to meet different interests and goals, the Web Application Penetration Testing bundle provides an engaging learning experience, helping you learn skills across various disciplines. With the Web Application Penetration Testing - 30 CoursesBundle, you'll have a personalised journey that aligns with your career goals and interests. This comprehensive package helps you confidently tackle new challenges, whether entering a new field or enhancing your existing knowledge. The Web Application Penetration Testing bundle is your gateway to expanding your career options, increasing job demand, and enhancing your skill set. By enrolling in this bundle, you'll receive complimentary PDF certificates for all courses, adding value to your resume at no extra cost. Develop key skills and achieve important progress in your career and personal development. Start your journey today and experience the transformative impact of the Web Application Penetration Testing bundle on your job life and career growth! This Web Application Penetration Testing - 30 CoursesBundle Comprises the Following CPD Accredited Courses: Course 01: Web Application Penetration Testing Course Course 02: Penetration Testing with OWASP ZAP: Mastery course Course 03: CompTIA PenTest+ (Ethical Hacking) Course 04: Secure Programming of Web Applications - Developers and TPMs Course 05: IT Administration and Networking Course 06: CPTE - Certified Penetration Testing Engineer Course 07: Mile2 Certified Network Forensics Examiner (CNFE) Course 08: Computer Networks Security from Scratch to Advanced Course 09: CompTIA Security+ (SY0-601) Course 10: CompTIA CySA+ Cybersecurity Analyst (CS0-002) Course 11: CompTIA Network+ Certification (N10-007) Course 12: Learn Ethical Hacking From A-Z: Beginner To Expert Course 13: The Complete Python 3 Course: Beginner to Advanced! Course 14: Deep Learning & Neural Networks Python - Keras Course 15: Machine Learning with Python Course Course 16: Azure Machine Learning Course 17: JavaScript Basics Course 18: Building Web Applications with Django and PostgreSQL Course 19: Cyber Security Awareness Training Course 20: Cyber Security Incident Handling and Incident Response Course 21: Career Development Plan Fundamentals Course 22: CV Writing and Job Searching Course 23: Learn to Level Up Your Leadership Course 24: Networking Skills for Personal Success Course 25: Ace Your Presentations: Public Speaking Masterclass Course 26: Learn to Make a Fresh Start in Your Life Course 27: Motivation - Motivating Yourself & Others Course 28: Excel: Top 50 Microsoft Excel Formulas in 50 Minutes! Course 29: Decision-Making and Critical Thinking Course 30: Time Management Training - Online Course What will make you stand out? Upon completion of this online Application Penetration Testing - 30 Courses Bundle, you will gain the following: CPD QS Accredited Proficiency with this web Application Penetration Testing Bundle After successfully completing the Web Application Penetration Testing bundle, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Web Application Penetration Testing Bundle The online test with immediate results You can study and complete the Web Application Penetration Testing bundle at your own pace. Study for the Web Application Penetration Testing bundle using any internet-connected device, such as a computer, tablet, or mobile device. The Web Application Penetration Testing - 30 Coursesbundle is a premier learning resource, with each course module holding respected CPD accreditation, symbolising exceptional quality. The content is packed with knowledge and is regularly updated to ensure it remains relevant. This bundle offers not just education but a constantly improving learning experience designed to enrich both your personal and professional development. Advance the future of learning with the Web Application Penetration Testing bundle, a comprehensive, complete collection of 30 courses. Each course in the Web Application Penetration Testing bundle has been handpicked by our experts to provide a broad range of learning opportunities. Together, these modules form an important and well-rounded learning experience. Our mission is to deliver high-quality, accessible education for everyone. Whether you are starting your career, switching industries, or enhancing your professional skills, the Web Application Penetration Testing bundle offers the flexibility and convenience to learn at your own pace. Make the Counselling, Psychology & Art Therapy package your trusted partner in your lifelong learning journey. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Web Application Penetration Testing - 30 Courses bundle is perfect for: Expand your knowledge and skillset for a fulfilling career with the Web Application Penetration Testing bundle. Become a more valuable professional by earning CPD certification and mastering in-demand skills with the Web Application Penetration Testing bundle. Discover your passion or explore new career options with the diverse learning opportunities in the Web Application Penetration Testing bundle. Learn on your schedule, in the comfort of your home - the Web Application Penetration Testing bundle offers ultimate flexibility for busy individuals. Requirements You are warmly invited to register for this bundle. Please be aware that no formal entry requirements or qualifications are necessary. This curriculum has been crafted to be open to everyone, regardless of previous experience or educational attainment. Career path Gain a wide range of skills across various fields, improve your problem-solving capabilities, and keep current with industry trends. Perfect for those aiming for career advancement, exploring a new professional direction, or pursuing personal growth. Begin your journey with the Web Application Penetration Testing - 30 Courses bundle. Certificates CPD Certificates Digital certificate - Included