Published Book on Amazon
 |
All of IOT Starting with the Latest Raspberry Pi from Beginner to Advanced – Volume 1 |
 |
All of IOT Starting with the Latest Raspberry Pi from Beginner to Advanced – Volume 2 |
출판된 한글판 도서
 |
최신 라즈베리파이(Raspberry Pi)로 시작하는 사물인터넷(IOT)의 모든 것 – 초보에서 고급까지 (상) |
 |
최신 라즈베리파이(Raspberry Pi)로 시작하는 사물인터넷(IOT)의 모든 것 – 초보에서 고급까지 (하) |
Original Book Contents
Table of Contents
1. Up to the Point of Writing This Book
2. Overall Composition of This Book
4. Level of Content Covered in This Book
5. Conventions Used in This Book
Chapter 1 Overview of Raspberry Pi
1.1.1 Birth of the Raspberry Pi
1.1.2 Development History of the Raspberry Pi
1.2 Features of the Raspberry Pi
Chapter 2 Hardware of Raspberry Pi
2.1 Hardware Configuration of Raspberry Pi
2.1.1 Basic configuration of Raspberry Pi
2.1.2 Characteristics Comparison of Raspberry Pi Model
2.4.1 Micro USB Power Supply Port
2.4.2 Current Consumption by Device
2.5 Video and Audio Devices 46
2.5.4 3.5mm Audio Jack and Composite Video
2.6.2 Power Constraints of USB Port
Chapter 3 Buying & Installing Device/Part
3.1 Selection of Raspberry Pi Model
3.4.2 External Mass Storage Device
3.5 Power Adapter and Power Supply Cable
3.6.1 WAN Connection Device, LAN Hub and Router
3.8.1 HDMI Cable and HDMI Supporting Monitor
3.9.2 Camera Supporting CSI Port
3.9.3 Raspberry Pi Dedicated Camera
3.9.3.3 Installing Raspberry Pi Dedicated Camera H/W
Chapter 4 Installing Operating System
4.1.1 List for Installable Operating Systems
4.1.2 Reviewing Major Operating Systems
4.1.2.1 Linux Related Operation Systems
4.1.2.2 Other Operating Systems
4.2 Overview of Installing Operating System
4.2.1 Installation Method of Operating System
4.2.2 About Installing Multiple Operating Systems
4.3.2 <NOOBS> Utility and Formatting SD Card
4.4 Downloading and Preparing the Installation File
4.4.1 Downloading from Raspberry Pi Homepage
4.4.2 Downloading from Other Soruces
4.5 Installation Using <NOOBS> Utility
4.5.1 Overview of <NOOBS> Utility
4.5.2 Downloading and Preparing <NOOBS> Utility Program
4.5.2.1 Downloading <NOOBS> Utility Program
4.5.2.2 Copying the <NOOBS> Utility File on SD Card
4.5.2.3 Preparing Hardware System and Internet Access
4.5.3 Function of <NOOBS> Utility
4.5.3.1 Starting <NOOBS> Utility
4.5.3.2 Rainbow Color Screen of <NOOBS> Utility
4.5.3.3 Booting Screen of <NOOBS> Utility
4.5.3.4 Installation Screen of <NOOBS> Utility
4.5.3.5 Function of Button on <NOOBS> Utility Screen
4.5.3.6 What If <NOOBS> Utility Screen is invisible
4.5.4 Installing OS Using <NOOBS>Utility
4.5.4.1 Selection of Operating System and Progress
4.5.4.2 Installing Multiple OS Using <NOOBS> Utility
4.5.5 Utilizing <NOOBS> Utility after Installing OS
4.5.5.1 <NOOBS> Utility Booting Screen
4.5.5.2 Booting Operation System Installed
4.5.5.3 Recovery Mode of <NOOBS> Utility
4.6 Installation Using Operating System Image
4.6.1 Downloading and Preparing Operation System Image File
4.6.2 Copying Image File to SD Card
4.6.3 Operating Operating System Installed
Chapter 5 System Startup and Shutdown
5.1.2 Selection of Booting Operation System
5.1.4 What If Screen is Invisible at Booting
5.2.2 Default User Account "pi"
5.4.1 How to Terminate the System
Chapter 6 System Connection & Termination
6.1 Overview of System Connection
6.1.1 Basic Diagram of Sysem Configuration
6.1.2 Overview of System Connection
6.1.2.1 Console and Terminal Concept
6.1.2.2 Terminal Connection and Desktop GUI connection
6.1.2.3 Local Connection and Remote Connection
6.2.1 Progress Flow of Terminal at Console
6.2.2 Setting for Local Connection Method
6.2.3 Local Terminal Connection
6.2.3.1 Starting Local Terminal Connection
6.2.3.2 Logging on Terminal and Starting Shell Program
6.2.3.3 Starting Desktop Window from Shell Terminal
6.2.4 Local Desktop GUI connection
6.2.4.1 Local Desktop GUI connection and Logon
6.2.4.2 Using Terminal Shell in Desktop Window
6.3 System Connection and Termination
6.3.2 System Termination in Terminal
6.3.3 System Termination on Window
Chapter 7 Overview of Desktop Window
7.1 Window Features of Raspbian OS
7.1.3 Differences from Windows of Other Operating System
7.2.2 Configuration of Panel Area
7.2.3 Configuration of Desktop Area
7.3 Detail Structure of Panel (Menu and Taskbar)
7.3.2.3 Creating an Execution Icon of Program on Desktop
7.3.2.4 Confirming Properties for Program
7.3.3 Application Launch Bar (Start Task)
7.4 Detail Structure of Desktop Area
7.4.2 Setting Desktop Properties
7.4.2.1 Setting Desktop Preference
7.4.2.2 Setting Icon Alignment
7.4.3 Creation of Folder and File
7.5 Overview of Key Execution Program
7.5.1.1 File Manager (PCManFm)
7.5.1.6 Image Viewer (GPicView)
7.5.1.7 Calculator (Galculator)
7.5.2.1 Mathematica & Wolfram Language
7.5.3 Internet Web Browser (EpicHany)
7.7.1 Mouse and Keyboard Settings
7.7.2 Theme and Appearance Settings
Chapter 8 Terminal and Shell Program
8.1.1 How to Start Terminal Program
8.1.2 Configuration of Terminal Screen
8.1.3 Working on Terminal Screen
8.2.1 Shell and BASH (Bourne Again Shell)
8.2.2 Specifying Default Shell Program
Chapter 9 Configuring Raspberry Pi System
9.1 Overview of System configuration
9.1.1 Meaning of System Configuration
9.1.2 Target items for System setting
9.2 How to Configure the System
9.2.1 How to Configure Using "raspi-config" Command
9.2.2 How to Configure Using Desktop Window
9.3 Setting File System Expansion
9.4 Changing Password for Default User "pi"
9.4.1 Meaning of Default User Account "pi"
9.4.2 Procedure of Changing Password
9.5 Setting Boot Startup Screen
9.5.1 Types of Boot Startup Screen
9.6 Setting Internationaliation Options
9.6.1 Common Menu for Setting Internationalization Options
9.8 Setting Camera and Audio Device
9.8.1 Enabling Raspberry Pi Camera
9.10 Setting Peripherals Interface Device
9.10.1 Setting SPI (Serial Peripheral Interface)
9.10.2 Setting I2C (Inter-Integrated Circuit)
Chapter 10 Understanding Shell Command
10.1.1 Standard Input and Output
10.1.3.1 Overview of Quoting Rule
10.1.4 Utilizing Command Execution History
10.1.4.1 Retrieving History by Arrow Keys
10.2.1.3 Declaring Data Types of Variable
10.2.1.4 "unset" Command - Delete Variable Definition
10.2.1.5 "set" Command - Set Shell Call Parameter
10.2.2.1 "env" Command – Confirm Environment Variable
10.2.2.2 "export" Command – Define Environment Variable
10.2.2.3 Fixing Value of Environment Variable Permanently
10.3.2 Applied Priority of Profile
10.4.1 "clear" Command - Clear Screen
10.4.3 "man" Command - Get Help on Commands
10.5 Commands Related to Operation
10.5.1 "expr" Command – Arithmetic Operation
10.5.2 "test" Command – Logical Operation
10.6 Commands Related to Selective Execution. 335
10.6.1 "&&" Command - Execute Command by "and" Method
10.6.2 "||" Command - Execute Command by "or" Method
10.7 Commands Related to Program Execution
10.7.1 "which" Command - Check Path Name of Executable File
10.7.2 ";" Command - Execute Multiple Commands Successively. 339
10.7.3 Executing Program on Background/Foreground
10.7.3.1 "&" Command - Execute on Background
10.7.3.2 "jobs" Command – Check Current Background Job
10.7.3.3 Moving Foreground Job to Background
10.7.3.4 "fg" Command – Switch Back Job to Foreground
10.7.3.5 "bg" Command – Resume Paused Background Job
10.7.3.6 Changing Background Job into Pausing State
10.7.3.7 "kill" Command – Terminate Job
10.7.4 "exit" Command – Terminate Process
10.8 Commands to Adjust Input and Output
10.8.2 Redirection Command – Change Input and Output Device
10.9 Commands Related to Data Manipulation
10.10 Commands Related to System Information
10.10.1 "date" Command- Confirm & Change Time Information
10.10.2 "cal" Command and "ncal" Command
11.1.1 Network Connection and IP Address
11.1.2 "ifconfig" Command - Verify Network Status & IP Address
11.2 Information for Network Setting
11.2.1 Information for Network Setting
11.2.2 Setting Assignment Method of IP Address
11.3.2 Communication with Host Name
11.5.1 Setting Wi-Fi with Panel Menu
11.5.2 Setting Wireless Connection with Configuration File
11.6 Setting Static IP Address
11.6.1 How to Specify Static IP Address on DHCP Server
11.6.2 How to Set up Static IP Address in Raspberry Pi
11.7 Activation and Stop of Network
11.7.1 Network Activation/Stop by "ifup" and "ifdwon" Command
11.7.2 Activation and Stop with "ifconfig" Command
11.8 Configuration and Connection of Bluetooth
11.8.1 Publishing Raspberry Pi to an External Bluetooth Device
11.8.2 Registering & Releasing Bluetooth Devices to Raspberry Pi
Chapter 12 User and User Group
12.1.1 System Default Users and Additional Created Users
12.1.1.2 Additional Created User
12.1.2 System Administrator and Normal User
12.1.3 Super User and Normal User
12.1.3.2 Commands Requiring Super User
12.1.3.3 Working as the Super User by "sudo" Command
12.1.3.4 Working as the Super User by "su" Command
12.1.3.5 "visudo" Command - Control Super User Privilege
12.2 Logon User and Working user
12.2.1.1 Meaning of Logon User
12.2.1.2 Confirming Logon User in Desktop Window
12.2.1.3 Confirming Logon User in Terminal Screen
12.2.2.1 Meaning or Working user
12.2.2.2 Confirming Working user by Terminal Information
12.2.2.3 Confirming Working user by "whoami" Command
12.2.2.4 Changing Working user with "su" Command
12.3 Managing User Account in the System
12.4.1 Necessity for Creating User
12.4.2 Necessary Considerations for Creating User
12.4.3 "adduser" Command – Create User
12.5 "deluser" Command - Delete User
12.6.1 "usermod" Command – Change User
12.6.2.1 Overview of Changing User Password
12.6.2.3 Changing Password for System Default User "pi"
12.7.2 Relationship between User and User Group
12.7.4 Managing Relationship between User and User Group
12.7.5 "addgroup" Command – Create User Group
12.7.6 "delgroup" Command – Delete User Group
12.7.7 Assignment of User Account to User Group
12.7.7.1 Review of Processing Method
12.7.7.2 Assigning User Group with "adduser" Command
Chapter 13 Control of File Permission
13.1 Understanding Scheme of File Permissions
13.1.1 Confirming Permission Information on File
13.1.2 Confirming Permission Information on Window Screen
13.1.3 Framework for Owner User and Owner Group of File
13.1.4 Permission System on File
13.2 Changing Permission on File
13.2.1 Changing Owner User and Owner Group of File
13.2.1.1 "chown" Command – Change Owner User of File
13.2.1.2 "chgrp" Command - Change Owner Group of File
13.2.2 Changing Permissions on File
13.2.2.1 Changing Permission with "chmod" Command
13.2.2.2 Changing Permission by Symbol Representation
13.2.2.3 Changing Permission by Number Representation
Chapter 14 Understanding Device
14.1.1 Device Type and "/dev" Directory
14.1.2.2 Naming Rules for Device
14.1.3.1 Block Device Characteristics
14.1.3.3 Naming Rules for Disk Device
14.1.3.4 "blkid" Command - Check Block Device Data
14.1.4.1 Characteristics of Network Device
14.1.4.2 Device Type and Naming Rules of Network
14.2.1 "lsusb" Command – Confirm USB Device
14.2.2 USB Device and Device File
14.2.2.1 USB Device and "/dev" File
14.2.2.2 Relationship between USB Device and Others
Chapter 15 Storage Device and Filesystem
15.1 Management of Logical Storage Device
15.1.1.1 "fdisk" Command – Manage Partition
15.1.1.2 "cfdisk" Command - Menu-Based Disk Operation
15.1.2.1 What Is Formatting Disk?
15.1.2.2 "mkfs" Command – Format Disk. 503
15.1.3.2 Creating Directory for Mount
15.1.3.3 Adjusting Permissions on the Mount Directory
15.1.3.4 "mount" Command - Specify Directory for Device
15.1.3.5 Setting Automatic Mount
15.1.3.6 "umount" Command - Release Device's Directory
15.1.4 Review of Special Device
15.1.4.2 USB Storage Device and Mount
16.1 Basic Structure of Directory and File
16.1.1 Concept of Directory and File
16.1.2 Naming Rules for Directory and File
16.1.3 Specifying Paths for Directory and File
16.1.4 Special Directory and Special File
16.2 Management of Directory and File
16.2.1.1 "mkdir" Command – Create Directory
16.2.1.2 Processing in Desktop Window
16.2.2 Renaming Directory and File
16.2.2.1 "mv" Command - Rename File
16.2.2.2 Processing in Desktop Window
16.2.3.1 File Creation Using "touch" Command
16.2.3.2 File Creation Using "echo" and ">" Command
16.2.3.3 File Creation Using Text Editor Program
16.2.3.4 Processing in Desktop Window
16.2.4 Moving Directory and File
16.2.4.1 "mv" Commmand – Move Directory and File
16.2.4.2 Processing in Desktop Window
16.2.5 Copying Directory and File
16.2.5.1 "cp" Command – Copy Directory and File
16.2.5.2 Processing in Desktop Window
16.2.6 Deleting Directory and File
16.2.6.1 "rmdir" Command - Delete Directory
16.2.6.2 "rm" Command – Delete Directory and File
16.2.6.3 Processing in Desktop Window
16.2.7 Management and Recovery of Data in [Trash Can]
16.2.7.1 Viewing the Data in [Trash Can]
16.2.7.2 Completing Clearing of Data in [Trash Can]
16.2.7.3 Recovery of Data in [Trash Can]
16.3.1 "cd" Command - Move Current File Path
16.3.2 "pwd" Command - Check Current File Path
16.3.3 Searching for File Name
16.3.3.1 "find" Command - Retrieve File Name
16.3.3.2 Processing in Desktop Window
16.3.4 Searching for Files by File Content
16.3.4.1 "grep" Command - Retrieve Files by File Content
16.3.4.2 Processing in Desktop Window
16.3.5 Checking Used Space of Directory/File
16.3.5.1 "du" Command - Check Used Space of Directory/File
16.3.5.2 Processing in Desktop Window
16.3.6 Determining Type of File
16.3.6.1 "file" Command - Determine Type of File
16.3.6.2 Processing in Desktop Window
16.3.7 Checking Contents of Directory
16.3.7.1 "ls" Command - Check Content of Directory
16.3.7.2 How to Check Contents of Folder in Desktop Window
16.3.8 Checking Contents of Text File
16.3.8.1 Checking File Contents Using "cat" Command
16.3.8.2 Checking File Contents Using "more" Command
16.3.8.3 Checking File Contents Using "less" Command
16.3.8.4 Checking File Contents Using Text Editor Program
16.3.8.5 How to Check File Contents in Desktop Window
Chapter 17 Program Installation & Upgrade
17.1.4 Source List of Package Repository
17.1.5 Naming Rules for Package
17.2.1 Overview of the Package Management Tool
17.2.2 Package Management Tool – dpkg
17.2.3 Package Management Tool - APT
17.2.4 Package Management Tool – aptitude
17.3 Checking Program Package List and Status
17.4 Obtaining Installer Program Source
17.4.1 How to Use Program Registered in Package Repository
17.4.2 How to Download from Internet with "wget" Command
17.4.3 How to Download from Internet Using GitHub
17.5 Installing and Reinstalling Program
17.5.1 Comparison of Installation by Source Distribution Method
17.5.2 Installing Programs Distributed in Package Repository
17.5.3 Installing Programs Distributed in Package Format
17.5.4 Installing Programs Distributed in the General File Format
17.6 Uninstalling Programs and Cleaning Files
17.6.1.1 "apt-get remove" Command
17.6.1.2 "apt-get purge" Command
17.6.1.3 "apt-get autoremove" Command
17.6.2 Cleaning Program Package File
17.6.2.1 "apt-get clean" Command
17.6.2.2 "apt-get autoclean" Command
17.7 Update and Upgrade of Program
17.7.2 "apt-get update" command - Update Local Package DB
17.7.3 "apt-get upgrade" Command- Reflect Updated Program
17.8 Upgrade of System Kernel and Firmware
18.1 Overview of Remote Connection
18.1.1 Remote System Connection
18.1.2 Remote Drive Connection
18.2 Remote Terminal Connection
18.2.3 SSH Connection on Unix/Linux Series, and Apple Mac
18.2.4 SSH Connection with <PuTTy> Program in MS Windows
18.3 Remote Desktop GUI connection
18.3.1 Remote Desktop Connection Using <XRDP> Program
18.3.2 Desktop GUI connection Using VNC Program
18.3.2.1 Installing <TightVNC> Server
18.3.2.2 Automatic Startup of <TightVNC> Server
18.3.2.3 Connecting Using VNC client
18.4.1 Remote Drive Connection Using <Samba> Program
18.4.1.1 Installing <Samba> Server Program
18.4.1.2 Connecting from <Samba> Client
18.4.2 Remote Drive Connection Using SCP Program
18.4.2.1 Installing/Enabling SSH server Program
18.4.2.2 Connecting from SCP Client
19.1.1.1 "top" Command - Check Main System Information
19.1.1.2 "free" Command – Check Memory Status
19.1.1.3 "ps" Command – Check Process Snapshot
19.1.1.4 System Monitoring with Desktop Window
19.1.2.1 "kill" Command – Terminate Process Using PID
19.1.2.2 "killall" Command – Terminate Process with Name
19.1.2.3 Terminating Process Using Desktop Window
19.2 Storage Device Monitoring
19.2.1 Checking Storage Device
19.2.1.1 "df" Command – Check File System Disk Space
19.2.1.2 "du" Command - Check Disk Usage by Directory
19.2.1.3 Checking Disk Usage by Using Desktop Window
19.3 "/proc" Folder and Process Information
19.3.1 Types of Information in "/proc" Folder
19.3.2 Checking System Information in "/proc" Folder
19.3.2.1 Information about CPU and Memory
19.3.2.2 Information about File System
19.3.3 Checking Each Process Information in "/proc/<PID>/"
Chapter 20 Batch Run and Automatic Run
20.1.1 Individual Run and Batch Run
20.1.2 Manual Run and Automatic Run
20.2 Batch Run of Commands via Script
20.2.1.2 Commands Available in Script
20.2.2 How Shell Runs Commands
20.2.2.1 Types of Kernel's System Calls
20.2.2.2 How Shell Runs According to Command Type
20.2.2.3 Bash's Working Procedure
20.2.3 Basics of Script Syntax
20.2.4.3 Arithmetic Operation of Integer Number Type
20.2.4.4 Arithmetic Operation of Real Number Type
20.2.5 Execution Control of Script
20.2.5.1 Optional Processing according to Conditions
20.2.5.2 Repetitive Processing
20.2.6.1 Preparing to Run Script File
20.3 Automatic Run with Init Script
20.3.1.1 Definition of Run Level
20.3.1.2 "runlevel" Command – Check Run Level
20.3.1.3 "telinit" Command – Change Run Level
20.3.2.2 "pstree" Command – Check Booting Process Tree
20.3.3.1 Meaning of Init Script
20.3.3.2 How to Create Init Script by Run Level
20.3.3.3 Creating Init Script to Run Application Daemon
20.3.4 Automatic Execution by Run Level at Booting
20.3.4.1 Principles of Registering Init Script
20.3.4.2 "update-rc.d" Command – Automatic Registering
20.3.4.3 Starting and Stopping Init Script
20.3.5 Automatic Run regardless of Run Level at Booting
20.4 Automatic Run by Schedule
20.4.2 "crontab" Command - Manage Crontab
Chapter 21 Office and Utility Program
21.1 Open Office - Office Software
21.1.1 Available Office Programs
21.1.2.1 Summary of <Libre Office>
21.1.2.2 Installing <Libre Office> Program
21.1.2.3 Running and Using <Libre Office> Program
21.2 <Gimp> Program – Edit Image File
21.2.1 Installing <Gimp> Program
21.3 <Scrot> Program - Capture Screen
21.3.1 Installing <Scrot> Program
21.3.2 Screen Capture Using <Scrot> Program
21.3.2.1 Overview of Program Execution
21.3.2.2 Capturing Full Screen
21.3.2.3 Capturing Partial Screen
21.4 <CUPS> Program - Network Printing
21.4.1 Printer Status just before Program Installation
21.4.2 Installing <CUPS> Program
21.4.3 Setting up Printer Server Using <CUPS> Program
21.4.4 Verifying Printer Installation and Printing
Chapter 22 Utilizing Multimedia
22.1 Using Raspberry Pi camera
22.1.1.1 Installing Raspberry Pi Dedicated Camera
22.1.1.2 Setup of Raspberry Pi Camera and GPU Memory
22.1.2 Processing API for Raspberry Pi Camera
22.1.2.1 MMAL (Multi-Media Abstraction Layer)
22.1.2.2 V4L2 (Video For Linux2)
22.1.3 Taking Picture and Video Using Pi Camera
22.1.3.1 Overview of Shooting Command for Pi Camera
22.1.3.2 Taking Pictures with "raspistill" Command
22.1.3.3 Recording Video Using "raspivid" Command
22.1.4.1 Playing Video Using <OMXplayer> Program
22.1.4.2 Playing Video Using <Mplayer> Program
22.1.5 Converting Video Format Using <FFMPEG> Program
22.1.6 Viewing Video on an External Computer
22.1.6.1 Basic framework to Transmit/Receive Video Data
22.1.6.2 <Netcat> Program – Transmit/Receive Video via Network
22.1.6.3 Sending Video Data Using "raspivid" Command
22.1.6.4 Receiving/Playing a Video on Linux
22.1.6.5 Receiving/Playing Video on MS Window
22.1.6.6 Receiving/Playing Video on Mac
22.1.7 Broadcasting Video over Internet
22.1.7.1 Framework to Transmit Video over Web
22.1.7.2 <VLC> server – Transmit Video from Raspberry Pi
22.1.7.3 <VLC> client – Playing Video on MS Windows
22.1.8 Motion Detecting Web Camera - <Motion> Program
22.1.8.1 Framework to Access Camera via Web
22.1.8.2 Capturing Motion Detection in Raspberry Pi System
22.2.1 <SSMTP> Program - Mail Transfer Agent
22.2.2 <MUTT> Program - Mail Transmitting Auxiliary Tool
23.1 Overview of Program Basics
23.1.1 Significance of Program
23.1.2 What We Can Do with Program
23.1.3 Available Major Languages and Tools
23.2 Mathematica or Wolfram language
23.2.2.1 Starting in Desktop GUI Environment
23.2.2.2 Working in Terminal Environment
23.2.3.1 How to Write Program in Mathematica
23.2.3.2 Saving and Reusing Program
23.3.3.1 Step 1 - First Sounds with Sonic Pi
23.3.3.3 Step 3 - MIDI Note and Music Note
23.3.3.4 Change Sound Using Synthesizer
23.3.3.6 Step 6 - Playing Two Tunes at the Same Time
23.4.4 Basics of Using Program
23.4.4.2 Start and Stop of Program
23.4.4.4 Specifying the Detail Characteristics of the Block
23.4.4.5 Connection with Other Commands
23.4.4.6 Completing Connection with Other Commands
23.4.4.7 Processing Sequence between Blocks
23.4.4.8 Repetitive Processing
23.4.5 Explaining How to Write Program Using Example
23.4.5.2 Changing the Appearance of [Cat] Sprite
23.4.6.1 Sensing with PicoBoard
23.4.6.2 Implementing Robotics with LEGO
23.5.1.2 Python 2 and Python 3
23.5.2.1 Starting in the Desktop GUI environment
23.5.2.2 Working in Terminal Environment
23.5.3.1 Starting Statement of Python
23.5.3.3 Indentation of Program
23.5.4.1 Creating Python Program file in IDLE
23.5.4.2 Running Python program File in Shell
23.5.4.3 Using Executable Python Program File
23.5.5 Learning Python through Game
23.5.6 Learning Python Using Simple Example
23.6.3 Saving, Compiling and Running Program
23.7.2 Checking the Current version
23.7.3 Writing and Running Program
23.7.3.1 Writing Program Source Code
23.7.3.2 Compiling and Running Program
Chapter 24 Utilizing Database and Web
24.1.1 Needs for Database and Web
24.2.1 Relational Database and SQL
24.2.1.2 Introduction and Features of MySQL
24.2.2 Installing <MySQL Server>
24.2.2.1 Installing <MySQL Server>
24.2.2.2 Configuring <MySQL Server>
24.2.3.1 <MySQL Administrator> – mysqladmin command
24.2.3.2 <MySQL Shell> – "mysql" command
24.2.3.3 <MySQL Backup> – "mysqldump" command
24.2.3.4 <MySQL Import> – "mysqlimport" command
24.2.4 Using <MySQL Shell> – "mysql" command
24.2.4.1 Basic Framework of <MySQL Shell>
24.2.4.2 Starting <MySQL Shell> Program
24.2.4.3 Using MySQL Shell Command
24.2.5.1 Introduction of Database SQL
24.2.5.2 Querying Database Information – "SHOW" SQL
24.2.5.3 Creating Database – "CREATE DATABASE" SQL
24.2.5.4 Deleting Database – "DROP DATABASE" SQL
24.2.5.5 Creating DB User–"CREATE USER"/"DROP USER" SQL
24.2.5.6 Managing User Privilege – "GRANT"/"REVOKE" SQL
24.2.5.7 Creating Table – "CREATE TABLE" SQL
24.2.5.8 Deleting Table – "DROP TABLE" SQL
24.2.5.9 Querying Table Information – "EXPLAIN"/"DESCRIBE" SQL
24.2.5.10 Inserting Table Data – "INSERT" SQL
24.2.5.11 Quering Table Data – "SELECT" SQL
24.2.5.12 Changing Table Data – "UPDATE" SQL
24.2.5.13 Deleting Table Data – "DELETE" SQL
24.3.1.2 Introduction and Features of Apache
24.3.2 Installing <Apache Web Server>
24.3.2.1 Installing <Apache Web Server>
24.3.2.2 Configuring Apache Server
24.3.4.1 Using Link to Other URL
24.3.4.5 Entering Data Using Form
24.4.1.2 Overview and Features of PHP
24.4.2 Installing PHP and Connection Tool to MySQL
24.4.3.1 Basic Structure of PHP
24.4.3.2 Rule of PHP Statement
24.4.4.4 Incremental/Decremental Operator
24.4.6.3 Stopping and Continuing Loop Processing
24.4.7 Stop and Return of Processing
24.4.7.1 "exit" Statement and "die" Statement
24.4.8.1 Definition of Function
24.4.9 Including PHP Script File
24.4.9.1 "include" Statement and "require" Statement
24.4.9.2 "include_once" statement and "require_once" statement 447
24.4.10 Transmission Methods of PHP and Key Global Variable
24.4.10.1 POST/GET Method of HTTP and PHP Processing
24.4.10.2 Global Variable of PHP
24.4.11 PHP and MySQL database
24.4.11.2 Interface Method of the <mysqli>
24.4.11.3 Details of <mysqli> Object-Oriented Interface
24.4.11.4 Usage of <mysqli> Object-Oriented Interface
24.4.12.1 Preparing Main Document
24.4.12.2 Preparing Works for Database and Table
24.4.12.3 Connecting and Disconnecting Database
24.4.12.4 Writing script to Query Data in Database Table
24.4.12.5 Writing Scrit to Update Database Table Data
24.4.12.6 Flow of Managing Screen for Table "employee"
25.1 Raspberry Pi and External Interface
25.1.1 Meaning of External Interface
25.1.2 GPIO of the Raspberry Pi
25.2.1.2 List and Function of GPIO Pin
25.2.3 Precautions and Features in Using GPIO
25.3 Basics of Electricity/Electronics
25.3.1 Current, Resistance, and Voltage
25.3.1.2 Voltage and Electric Potential
25.4 Basics of Electronic Circuit
25.4.2 Series and Parallel of Resistance
25.4.2.1 Series Connection of Resistance
25.4.2.2 Parallel Connection of Resistance
25.4.2.3 Why to Use Resistance
25.4.3 Series and Parallel of Power
25.4.3.3 Series and Parallel Connection
25.4.4.1 First Law - The Law of Current
25.4.4.2 Second Law – The Law of Voltage
25.4.5 Pull-up Resistor and Pull-down Resistor
25.4.5.2 Why to Use Resistor in Pull-up/Pull-down State
25.4.5.5 Resistance Value of Pull-up Resistor
25.5 Preparations and Usages for Interface
25.5.2.1 Structure of Breadboard
25.5.2.2 How to Use Breadboard
25.5.4.2 Reading Resistor Value
25.6.1 Meaning of GPIO Library
25.6.2.1 Overview of <WiringPi> Library
25.6.2.2 Pin Map of <WiringPi> library
25.6.2.3 Installing <WiringPi> Library
25.6.2.5 Basic usage of <WiringPi> Library
25.6.3.1 Overview of <RPi.GPIO> Library
25.6.3.2 Installing <RPi.GPIO> library
25.6.3.3 Usage of <RPi.GPIO> Library
25.7.1 Digital Output – LED On/Off 560
25.7.1.2 Example of Using <WiringPi> Library
25.7.1.3 Example of <RPi.GPIO> Library
25.7.2 Digital Input – Button Input
25.7.2.1 Input Method of <RPi.GPIO> library
25.7.2.2 Push Button Connection and Circuit Description
25.7.2.3 Processing Button Input with Falling Method
25.7.2.4 Processing Button Input with Interrupt Method
25.8.2 Measuring Temperature with Digital Sensor DS18b20
25.8.2.1 Features of DS18B20 Sensor
25.8.2.2 Connection between Raspberry Pi and Sensor
25.8.2.3 Enabling 1-Wire Bus Protocol
25.8.2.4 Interface File for Measuring Value of DS18B20
25.8.2.5 Writing Program to Process Temperature Value
25.8.3 Utilizing Digital DHT11 Humidity/Temperature Sensor
25.8.3.1 Feature of the Sensor
25.8.3.2 Writing Program with <WiringPi> Library
25.8.3.3 Writing Program with <RPi.GPIO> Library
25.8.3.4 Raspberry Pi and Real Time Processing
25.10.1 I2C (Inter-Integrated Circuit) device
25.10.2 SPI (Serial Peripheral Interface)
25.10.3 UART (Universal Asynchronous Receiver/Transmitter)