Read Anywhere and on Any Device!

Subscribe to Read | $0.00

Join today and start reading your favorite books for Free!

Create Free Account

Quick and Easy Sign Up!

It takes less then 1 minute to sign up, then you can enjoy Unlimited eBooks.

Sign Up Browse

Popular Genres

Read Anywhere and on Any Device!

  • Download on iOS
  • Download on Android
  • Download on iOS

THE SELF-TAUGHT CODER: The Definitive Guide to Database Programming with Python and MySQL

THE SELF-TAUGHT CODER: The Definitive Guide to Database Programming with Python and MySQL

Rismon Hasiholan Sianipar
5/5 ( ratings)
Read Download
You will learn Python/MySQL fast, easy and fun. This book provides you with a complete MySQL guidance presented in an easy-to-follow manner. This Python MySQL book shows you how to use MySQL connector/Python to access MySQL databases. You will learn how to connect to MySQL database, and perform common database operations such as SELECT, INSERT, UPDATE and DELETE. In addition, we will show you some useful tips such as how to call MySQL stored procedures from Python, and how to work with MySQL BLOB data. Each chapter has practical examples with SQL script and screenshots available. If you go through the entire chapters, you will know how to manage MySQL databases and manipulate data using various techniques such as MySQL queries, MySQL stored procedures, database views, triggers.

In the first part of the book, you will learn Basic MySQL statements including how to implement querying data, sorting data, filtering data, joining tables, grouping data, subquerying data, dan setting operators.

Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters.

In the next chapter, we will discuss the database views, how they are implemented in MySQL, and how to use them more effectively. After that, you will learn how to work with the MySQL triggers. By definition, a trigger or database trigger is a stored program executed automatically to respond to a specific event e.g., insert, update or delete occurred in a table. The database trigger is powerful tool for protecting the integrity of the data in your MySQL databases. In addition, it is useful to automate some database operations such as logging, auditing, etc.

Then, you will learn about MySQL index including creating indexes, removing indexes, listing all indexes of a table and other important features of indexes in MySQL. MySQL uses indexes to quickly find rows with specific column values. Without an index, MySQL must scan the whole table to locate the relevant rows. The larger table, the slower it searches. After that, you will find a lot of useful MySQL administration techniques including MySQL server startup and shutdown, MySQL server security, MySQL database maintenance, and backup. The last chapter gives you the most commonly used MySQL functions including aggregate functions, string functions, date time functions, control flow functions, etc.
Pages
606
Format
Kindle Edition
Publisher
SPARTA Publishing
Release
April 10, 2019

THE SELF-TAUGHT CODER: The Definitive Guide to Database Programming with Python and MySQL

Rismon Hasiholan Sianipar
5/5 ( ratings)
Read Download
You will learn Python/MySQL fast, easy and fun. This book provides you with a complete MySQL guidance presented in an easy-to-follow manner. This Python MySQL book shows you how to use MySQL connector/Python to access MySQL databases. You will learn how to connect to MySQL database, and perform common database operations such as SELECT, INSERT, UPDATE and DELETE. In addition, we will show you some useful tips such as how to call MySQL stored procedures from Python, and how to work with MySQL BLOB data. Each chapter has practical examples with SQL script and screenshots available. If you go through the entire chapters, you will know how to manage MySQL databases and manipulate data using various techniques such as MySQL queries, MySQL stored procedures, database views, triggers.

In the first part of the book, you will learn Basic MySQL statements including how to implement querying data, sorting data, filtering data, joining tables, grouping data, subquerying data, dan setting operators.

Aside from learning basic SQL statements, you will also learn step by step how to develop stored procedures in MySQL. First, we introduce you to the stored procedure concept and discuss when you should use it. Then, we show you how to use the basic elements of the procedure code such as create procedure statement, if-else, case, loop, stored procedure’s parameters.

In the next chapter, we will discuss the database views, how they are implemented in MySQL, and how to use them more effectively. After that, you will learn how to work with the MySQL triggers. By definition, a trigger or database trigger is a stored program executed automatically to respond to a specific event e.g., insert, update or delete occurred in a table. The database trigger is powerful tool for protecting the integrity of the data in your MySQL databases. In addition, it is useful to automate some database operations such as logging, auditing, etc.

Then, you will learn about MySQL index including creating indexes, removing indexes, listing all indexes of a table and other important features of indexes in MySQL. MySQL uses indexes to quickly find rows with specific column values. Without an index, MySQL must scan the whole table to locate the relevant rows. The larger table, the slower it searches. After that, you will find a lot of useful MySQL administration techniques including MySQL server startup and shutdown, MySQL server security, MySQL database maintenance, and backup. The last chapter gives you the most commonly used MySQL functions including aggregate functions, string functions, date time functions, control flow functions, etc.
Pages
606
Format
Kindle Edition
Publisher
SPARTA Publishing
Release
April 10, 2019

More books from Rismon Hasiholan Sianipar

HOUSE PRICE: ANALYSIS AND PREDICTION USING MACHINE LEARNING WITH PYTHON

0/5 ( ratings)

TIME-SERIES WEATHER FORECASTING AND PREDICTION USING MACHINE LEARNING WITH TKINTER

0/5 ( ratings)

Dasar Analisis Dan Perancangan Pemrograman Berorientasi Objek Menggunakan Java

0/5 ( ratings)

Building Three Desktop Applications with SQLite and Java GUI

0/5 ( ratings)

Building Three Java GUI Applications Using MySQL, MariaDB, and PostgreSQL

0/5 ( ratings)

Python GUI with SQL Server for Absolute Beginners: Building Responsive, Powerful Cross-platform, and Database-Driven Applications with PyQt

0/5 ( ratings)

LEARNING PyQt5: A Step by Step Tutorial to Develop MySQL-Based Applications

0/5 ( ratings)

Learn Java in One Week: The Crash Course to Develop Database-Driven Projects

0/5 ( ratings)

Think PyQt: A Smarter Way to Explore MariaDB and SQLite Driven Programming

0/5 ( ratings)

LEARNING SQL SERVER: A self-study to easy implement database-driven Java GUI applications

0/5 ( ratings)

OpenCV-Python with MariaDB for Absolute Beginners: A Hands-On, Practical Database-Driven Applications

0/5 ( ratings)

POSTGRESQL FOR PYTHON GUI: A PROGRESSIVE TUTORIAL TO DEVELOP DATABASE PROJECT

0/5 ( ratings)

Learn SQLite with Python: Building Database-Driven Desktop Projects

0/5 ( ratings)

ONLINE RETAIL CLUSTERING AND PREDICTION USING MACHINE LEARNING WITH PYTHON GUI

0/5 ( ratings)

OPINION MINING AND PREDICTION USING MACHINE LEARNING AND DEEP LEARNING WITH PYTHON GUI

0/5 ( ratings)

Learning PyQt5 with MariaDB for Absolute Beginners: A Hands-On, Practical Database Programming

0/5 ( ratings)

Java Programming For Developers: The Definitive Guide to Learn JDBC And Database Applications

0/5 ( ratings)

JAVA GUI WITH POSTGRESQL: A Practical Approach to Build Database Project for Students and Programmers

0/5 ( ratings)

Java In Practice: JDBC And Database Applications

0/5 ( ratings)

MS Access And SQL Server Crash Course: A Step by Step, Project-Based Introduction to Java GUI Programming

0/5 ( ratings)

Rate this book!

Write a review?

loader