Название: MySQL 8.0 and SQL Server using Python 3.7 and PHP 7.3 Автор: Narendra Mohan MIttal Издательство: Amazon Digital Services LLC Год: 2019 Формат: mobi/pdf(conv.) Страниц: 873 Размер: 12.5 Mb Язык: English
This book is for Students, Teachers and Professional that want learn MySQL 8.0 and SQL server using Python 3.7 and PHP 7.3 This book introduces the MySQL versions, editions, and the three APIs. This book also explores MySQL 8.0 Database and Table with SQL Server In-Memory OLTP using Python and PHP code. And then also Intoduce Dynamic SQL and SQL Transactions. Introduction to Dynamic SQL Dynamic SQL is quite simple to understand, and once acquainted, the number of applications can become staggering. Dynamic SQL seeks to solve scenarios where we want to operate on one or many objects, but do not know all of the pertinent details as we write our code. SQL Server In-Memory OLTP This book explains the importance of in-memory databases and the problems they address. It provides an overview of the Microsoft In-Memory OLTP implementation (code name Hekaton) and its design goals. It discusses the high-level architecture of the In-Memory OLTP Engine and how it is integrated into SQL Server. MySQL 8.0 Database and Table This book introduces the concept of a database and a practical way of testing it. Using the examples, you will create a MariaDB or MySQL database and a table. As you work through the examples, you will become familiar with the database administration interface. Create Web Page and Database using PHP and SQL This book will demonstrate how a simple database can be linked to a web page so that the page can interact with users. The general public will have access to the website but will not have access to the database structure or the data contained in the tables. They will not be permitted to view the protected pages, such as a members-only page, because they have no password until they register. Linux Tips for SQL If you are a Windows user and even a strong Powershell user, you may need a few tips on navigating the Linux shell and system. This book includes a few commands, scripts, and navigation tips I’ve learned as I’ve spent time installing, demonstrating, and presenting SQL Server on Linux.