0 items in the shopping cart

MySQL 8.0 and SQL Server using Python 3.7 and PHP 7.3

 MySQL 8.0 and SQL Server using Python 3.7 and PHP 7.3

MySQL 8.0 and SQL Server using Python 3.7 and PHP 7.3

$10.00

KETAB DOWNLOAD

by Narendra Mohan MIttal (Author)

How to Use This Book

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


1.Introduction to MySQL 8.0
2.Introduction to Dynamic SQL
3.SQL Server In-Memory OLTP
4.MySQL 8.0 Database and Table
5.SQL Indexes
6.Create Database Using PHP
7.Create Table Expressions
8.Recursive Table Expressions using MySQL
9.SQL Server Backup and Restore
10.Performance Analysis
11.Data Manipulation Language (DML)
12.Create SQL Transactions
13.SQL Server on Linux
14.Physical Database Designing
15.Dynamic Searches
16.What Is SQL Injection?
17.Migration and Backup a Website
18.An SQL/PSM and DCP Crash Course
19.Concurrency in SQL Server
20.Database Design Terms
21.Handling Downtime

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.

Year 2019
Pages 547
Language English
Format PDF
Size 10 MB
ASIN B07Q2CW83G