64 PostgreSQL courses

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

Duration 3 Days 18 CPD hours This course is intended for Data Wrangling with Python takes a practical approach to equip beginners with the most essential data analysis tools in the shortest possible time. It contains multiple activities that use real-life business scenarios for you to practice and apply your new skills in a highly relevant context. Overview By the end of this course, you will be confident in using a diverse array of sources to extract, clean, transform, and format your data efficiently. In this course you will start with the absolute basics of Python, focusing mainly on data structures. Then you will delve into the fundamental tools of data wrangling like NumPy and Pandas libraries. You'll explore useful insights into why you should stay away from traditional ways of data cleaning, as done in other languages, and take advantage of the specialized pre-built routines in Python.This combination of Python tips and tricks will also demonstrate how to use the same Python backend and extract/transform data from an array of sources including the Internet, large database vaults, and Excel financial tables. To help you prepare for more challenging scenarios, you'll cover how to handle missing or wrong data, and reformat it based on the requirements from the downstream analytics tool. The course will further help you grasp concepts through real-world examples and datasets. Introduction to Data Structure using Python Python for Data Wrangling Lists, Sets, Strings, Tuples, and Dictionaries Advanced Operations on Built-In Data Structure Advanced Data Structures Basic File Operations in Python Introduction to NumPy, Pandas, and Matplotlib NumPy Arrays Pandas DataFrames Statistics and Visualization with NumPy and Pandas Using NumPy and Pandas to Calculate Basic Descriptive Statistics on the DataFrame Deep Dive into Data Wrangling with Python Subsetting, Filtering, and Grouping Detecting Outliers and Handling Missing Values Concatenating, Merging, and Joining Useful Methods of Pandas Get Comfortable with a Different Kind of Data Sources Reading Data from Different Text-Based (and Non-Text-Based) Sources Introduction to BeautifulSoup4 and Web Page Parsing Learning the Hidden Secrets of Data Wrangling Advanced List Comprehension and the zip Function Data Formatting Advanced Web Scraping and Data Gathering Basics of Web Scraping and BeautifulSoup libraries Reading Data from XML RDBMS and SQL Refresher of RDBMS and SQL Using an RDBMS (MySQL/PostgreSQL/SQLite) Application in real life and Conclusion of course Applying Your Knowledge to a Real-life Data Wrangling Task An Extension to Data Wrangling

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Joomla Basics Do you want to build a stunning website using Joomla? Do you want to be an expert in Joomla? The course will teach you the advanced features and functions of Joomla. Course Description: Do you want to be a web developer and want to design website? The course focuses the advanced part of Joomla so that you can develop a professional website using Joomla. Joomla is a CMS (Content Management System) that connects your website to a MySQLi, MySQL, or PostgreSQL database so that you can make content management. This is a free and open source platform that helps you to publish website content. Joomla is the perfect solution for corporate Web sites or portals, Online magazines, newspapers, and publications, E-commerce and online reservations, School and Church website, Government applications, Classified sites, personal homepage, etc. For using Joomla, you do not need any programming, planning or coding. Just download Joomla and customise your website. The thing you need to know is the procedures of using Joomla, the components, modules, plug-ins of Joomla and how to use the plug-ins and Joomla template or Joomla theme to make the website stunning. The course focuses all the necessary information about Joomla so that you can able to create a Joomla site. Course Highlights Joomla for Beginners is an award winning and the best selling course that has been given the CPD Certification & IAO accreditation. It is the most suitable course anyone looking to work in this or relevant sector. It is considered one of the perfect courses in the UK that can help students/learners to get familiar with the topic and gain necessary skills to perform well in this field. We have packed Joomla for Beginners into 6 modules for teaching you everything you need to become successful in this profession. To provide you ease of access, this course is designed for both part-time and full-time students. You can become accredited in just 6 hours and it is also possible to study at your own pace. We have experienced tutors who will help you throughout the comprehensive syllabus of this course and answer all your queries through email. For further clarification, you will be able to recognize your qualification by checking the validity from our dedicated website. Why You Should Choose Joomla for Beginners Lifetime access to the course No hidden fees or exam charges CPD Accredited certification on successful completion Full Tutor support on weekdays (Monday - Friday) Efficient exam system, assessment and instant results Download Printable PDF certificate immediately after completion Obtain the original print copy of your certificate, dispatch the next working day for as little as £9. Improve your chance of gaining professional skills and better earning potential. Who is this Course for? Joomla for Beginners is CPD certified and IAO accredited. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic backgrounds. Requirements Our Joomla for Beginners is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path You will be ready to enter the relevant job market after completing this course. You will be able to gain necessary knowledge and skills required to succeed in this sector. All our Diplomas' are CPD and IAO accredited so you will be able to stand out in the crowd by adding our qualifications to your CV and Resume. Chapter-01 INTRODUCTION TO JOOMLA FREE 00:30:00 Chapter-02 SCOPE OF JOOMLA FREE 00:30:00 Chapter-03 BENEFITS OF JOOMLA 00:30:00 Chapter-04 COMPARISON WITH OTHER CONTENT MANAGEMENT SYSTEMS 01:00:00 Chapter-05 WHY DEVELOPERS DRAWS TO JOOMLA? 00:30:00 Chapter-06 How do I in install Joomla? 03:00:00 Mock Exam Final Exam

Are you ready to embark on an enlightening journey of wisdom with the SQL bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - SQL Programming. Delve into eight immersive CPD Accredited courses, each a standalone course: The Complete SQL from Scratch: Bootcamp The Complete MySQL Server from Scratch: Bootcamp SQL for Data Science, Data Analytics and Data Visualization Python Programming from Scratch with My SQL Database Building Web Applications with Django and PostgreSQL Ultimate PHP & MySQL Web Development Course & OOP Coding Programming AutoCAD with SQL Server Database Using C# Microsoft SQL Server Development for Everyone! Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the SQL Programming bundle illuminate your path to wisdom. The SQL Programming bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the SQL Programming package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the SQL bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the SQL Programming community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the SQL bundle. Establish robust bases across each course nestled within the SQL bundle. Decipher intricate concepts through the articulate content of the SQL bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the SQL bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The SQL bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the SQL bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The SQL bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the SQL bundle allows learners to make meaningful contributions to their chosen fields. Embark on the SQL journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the SQL bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the SQL bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99