English | April 1, 2019 | ISBN: N/A | ASIN: B07Q5VW2N7 | 628 Pages | MOBI | 3.82 MB



How to Use This Book

This book is for Students, Teachers, and Professional that want to learn MySQL 8.0 and PostgreSQL 11.0 with live projects using PHP 7.3. This book also explains SQL Stored Procedures, Joins and Views and User-Defined Functions with examples. And the second Section of this book explains Concepts of Performance Optimization with Pooling Resources in PostgreSQL 11.0 and Physical Database Designing Concepts. And the Third Section of this book explains Concepts of PostgreSQL 11.0 System Information Functions, Constraints and Queries and then Create the Website Database and Connect with PayPal using PHP 7.3.



Table of Contents

1.Introduction to MySQL 8.0 and PostgreSQL 11.0

2.SQL Stored Procedures

3.Understanding Joins and Views

4.User-Defined Functions

5.Concepts of Performance Optimization

6.Pooling Resources in PostgreSQL 11.0

7.Physical Database Designing Concepts

8.PostgreSQL 11.0 System Information Functions

9.Create Website Database and Connect with PayPal

10.Executing Constraints and Queries

11.Adding Security Validation in Database using PHP 7.3



Using PostgreSQL

PostgreSQL is a full-featured enterprise-class database management system with a great community. The latest version of PostgreSQL as of writing this book was 11.0. You don't absolutely need the latest version; in fact, I use version 11.0 in this text.

PostgreSQL is ACID compliant. So need to worry about the atomicity, consistency, isolation, and durability of your databases. PostgreSQL is POSIX compliant and supports Windows, Linux, Mac OS/X, and major UNIX platforms. PostgreSQL uses write-ahead logging for crash recoveries and point in time recoveries of the databases.



SQL Stored Procedures

This chapter explains how to use the SQL/PSM building blocks. It explains the structure of an Stored Procedures, its parameters, and their usage then uses that information to explain how to create cursor-returning Stored Procedures. This chapter also explains how to use Stored Procedures, particularly those that return cursors.



User-Defined Functions

This chapter will introduce the concept of the user-defined function (UDF), in its multiple forms. The chapter starts with the anatomy of a UDF, presents a few examples, and later explains how to use UDFs in your code. The chapter will discuss the use of user-defined table functions (UDTFs), an often ignored form of UDF.



PostgreSQL 11.0 System Information Functions

One aspect of PostgreSQL administration, which is unfortunately ignored too frequently, is system monitoring. Provisioning, constructing, and maintaining a high availability cluster is difficult by itself, without the extra complications inherent in setting up yet more infrastructures.



Create Website Database and Connect with PayPal using PHP 7.3

The tutorials in this chapter assume that website users are applying for membership in an organization that requires a membership fee. Website databases for such organizations require addresses and possibly the telephone numbers of their members. These forms can also use pull-down menus to allow the user to choose a class of membership.

After completing this chapter, you will be able to

Create a database that includes two tables

Understand the importance of documentation

Create an extended registration form with a drop-down menu

Add PayPal and debit/credit card information

Create variable pricing displays

Apply pagination to the display of records

Create code that edits records

The first step is to create a new database.