English | March 25, 2019 | ISBN: N/A | ASIN: B07Q2CW83G | 873 pages | MOBI | 4.85 Mb
MySQL 8.0 and SQL Server using Python 3.7 and PHP 7.3 by Narendra Mohan MIttal
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.
Table of Contents:
Introduction to MySQL 8.0
MySQL Python and connector is the glue that is used between a Python program and a MySQL Server database. It can be used to manipulate the database objects using data definition language (DDL) statements as well as to change or query the data through data manipulation language (DML) statements.
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.
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.