Torrent details for "MySQL 8.0 and PostgreSQL 11.0 with Live Projects using PHP 7.3 - 2019 - MOBI - zeke23" Log in to bookmark
Controls:
Language:
EnglishTotal Size:
3.82 MB
Info Hash:
b2f53ad141469da05980dfe31a4e8a48ffc0fea3
Added By:
Added:
09-04-2019 13:16 (edited 11-04-2019 18:20) by cRAYz
Views:
682
Health:
Seeds:
0
Leechers:
0
Completed:
131
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.