By: Narendra Mohan Mittal
Purchased At: Or $3.50 to buy
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
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
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.
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.
About the Author
Narendra Mohan Mittal is the Founder and Chairman of Thesis Scientist and he is working in the field of Data Science/big data/machine learning/deep learning space. He has more than 10 years in Research and Testing and he is very active in the Big Data, Data Science, Python and Machine learning.