MySQL Tutorials - Herong's Tutorial Examples


Book Description

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.







Linux Apps Tutorials - Herong's Tutorial Examples


Book Description

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.




Perl Tutorials - Herong's Tutorial Examples


Book Description

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.




JDBC for MySQL - Herong's Tutorial Examples


Book Description

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 MySQL server; using MySQL JDBC driver (MySQL Connector/J); 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-MySQL.




JDBC Tutorials - Herong's Tutorial Examples


Book Description

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.




MySQL


Book Description

MySQL is the most popular Open Source Relational SQL Database Management System. MySQL is one of the best RDBMS being used for developing various web-based software applications. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. This tutorial will give you a quick start to MySQL and make you comfortable with MySQL programming. This tutorial is prepared for the beginners to help them understand the basics-to-advanced concepts related to MySQL languages. Before you start doing practice with various types of examples given in this tutorial, it is being assumed that you are already aware about what a database is, especially an RDBMS and what is a computer programming language.




MySQL Tutorial


Book Description

A concise introduction to the fundamentals of working with MySQL. MySQL is an open-source relational database management system that is rapidly growing in popularity. Known for its speed, reliability, and ease of use, MySQL has proven itself to be particularly well suited both for beginners and for experienced developers to create sophisticated database-backed Web sites and applications. MySQL Tutorial is a clear, concise introduction to the fundamental concepts and techniques of working with MySQL. It teaches the beginning MySQL user how to create and administer powerful databases that can be used at home, at work, and on the Web. Whether you are a novice to databases or a technical professional looking to find out more about how MySQL works, MySQL Tutorial efficiently guides you through the information you need in order to get started with MySQL and quickly become proficient.




Mac Tutorials - Herong's Tutorial Examples


Book Description

This book is a collection of notes and sample codes written by the author while he was learning macOS. Topics include Macintosh OS history; macOS basic functionalities; storage file systems; reviewing resource usage on running processes; installing productivity and programming tools; installing Java and related tools; installing Apache Web server and MySQL database server; using Keychain Access to manage passwords and certificates. Updated in 2023 (Version v3.07) with minor changes. For latest updates and free sample chapters, visit https://www.herongyang.com/Mac.




Python Tutorials - Herong's Tutorial Examples


Book Description

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 comprehensions; modules and packages; sys, os, and pathlib modules; Anaconda Python environment manager; Jupyter Notebooks; NumPy, SciPy libraries. Updated in 2023 (Version v2.14) with minor changes. For latest updates and free sample chapters, visit https://www.herongyang.com/Python.