This MySQL tutorial book is a collection of notes and sample codes written by the author while he was learning MySQL himself, an ideal tutorial guide for beginners. Topics include introduction of Structured Query Language (SQL); installation of MySQL server on Windows, Linux, and macOS; using MySQL client program; accessing MySQL server from PHP, Java and Perl programs; SQL data types, literals, operations, expressions, and functions; Statements of Data Definition Language (DDL), Data Manipulation Language (DML), and Query Language; creating and using indexes; using window functions; stored procedures; transaction management; locks and deadlocks; InnoDB and other storage engines. Updated in 2023 (Version v4.46) with minor changes. For latest updates and free sample chapters, visit https://www.herongyang.com/MySQL.

This book is a collection of notes and sample codes written by the author while he was learning Linux applications. Topics include using managing users and groups; managing files and directories; managing Apache Web server and SquirrelMail; managing MySQL server; developing Python and PHP scripts; using GCC C/C++ compilers; running graphical applications on GNOME desktop and X11 servers; running Conda - Environment and Package Manager. Updated in 2023 (Version v1.02) with minor updates. For latest updates and free sample chapters, visit https://www.herongyang.com/Linux-Apps.

This PHP tutorial book is a collection of notes and sample codes written by the author while he was learning PHP himself. It can be used as a tutorial guide for beginners or a reference book for experienced developers. Topics include PHP script file syntax; data types and iterals; variables, operations and expressions; flow control statements: 'if' and 'switch'; loop statements: 'while', 'for', and 'do ... while'; function declaration, arguments, and return values; array and ordered maps; sending out emails; integrating with HTTP Web servers; accessing HTTP requests and responses; managing sessions and cookies; controlling HTTP response headers; accessing MySQL database server; accessing files and directories; using SOAP extension; managing non-ASCII characters; using classes and objects. For latest update, visit http://www.herongyang.com/PHP.

This Perl tutorial book is a collection of notes and sample codes written by the author while he was learning Perl language himself. Topics include introduction of ActivePerl; data types, variables and expressions; scalars, arrays, hash maps, and references; input/output and file systems; DBM files and MySQL access; socket communication; generating executables; XML::Simple and RPC:XML modules; LWP::UserAgent, HTTP::Request and SOAP::Lite modules; CGI, and IIS/Apache integrations. Updated in 2024 (Version v6.02) with minor updates. For latest updates and free sample chapters, visit https://www.herongyang.com/Perl.

This Python tutorial book is a collection of notes and sample codes written by the author while he was learning Python language himself. Topics include: installing Python environments on Windows, macOS and Linux computer; Python built-in data types; variables, operations, expressions and statements; user-defined functions; iterators, generators and list/set/dictionary comprehensions; modules and packages; sys, os, and pathlib modules; Anaconda Python environment manager; Jupyter Notebooks; NumPy, SciPy libraries. Updated in 2024 (Version v2.15) with minor changes. For latest updates and free sample chapters, visit https://www.herongyang.com/Python.

This JDBC tutorial book is a collection of notes and sample codes written by the author while he was learning JDBC technology himself. Topics include installing JDK and Derby database server; using Derby JDBC driver; database connection URLs; introduction to Result Set; Meta Data, Prepared Statement, CLOB, and BLOB; connection pooling with DBCP and C3P0. Updated in 2024 (Version v3.13) with minor changes. For latest updates and free sample chapters, visit https://www.herongyang.com/JDBC.

This book is a collection of notes and sample codes written by the author while he was learning Linux systems. Topics include using Cockpit Web portal for admin tasks; managing users and groups; managing files and directories; managing NTFS, CIFS, EXT4, LBA, LVM file systems; using network tools and security firewall; installing CentOS systems; using SELinux (Security-Enhanced Linux) system; DNF/YUM software package manager; SSH Server configuration and client tools; managing vsftpd - Very Secure FTP daemon; managing directory service with OpenLDAP; Updated in 2024 (Version v5.44) with email topics moved to 'Email Tutorials' book. For latest updates and free sample chapters, visit https://www.herongyang.com/Linux.