PHP database programming from zero to proficient

• Chapter1 PHP database programming from zero to proficient
• 1-1 Database - basic understanding
• 1-2 Database-relational database concepts
• 1-3 SQL understanding.
• 1-4 Basic understanding of MySQL
• 1-5 MySQL server operation management
• 1-6 Client login and exit MySQL system
• 1-7 Basic operations of MySQL database-SQL learning preface
• 1-8 MySQL database basic operations-SQL syntax rules
• 1-9 View database
• 1-10 Create database
• 1-11 -Modify database character set
• 1-12 Delete database
• 1-13 SQL table (field) operation-create data table
• 1-14 View datasheet
• 1-15 Update data table
• 1-16 Delete data table
• 1-17 SQL data operations-new
• 1-18 Query data
• 1-19 update data
• 1-20 delete data
• 1-21 Character set concept
• 1-22 Detailed explanation of MySQL character set
• 1-23 Proofreading set concept
• 1-24 Proofreading set settings
• 1-25 Proofreading set application
• 1-26 MySQL database fields-basic understanding
• 1-27 MySQL database fields-basic classification
• 1-28 MySQL database field-integer
• 1-29 MySQL database field-display width
• 1-30 MySQL database field-decimal type (floating point number
• 1-31 MySQL database field - decimal type (fixed point number).
• 1-32 MySQL database field-time date type
• 1-33 MySQL database field-string (char and varchar
• 1-34 MySQL database field - string (text string)
• 1-35 MySQL database field - string (enumeration)
• 1-36 MySQL database field-string (collection) + summary
• 1-37 MySQL database field properties - understanding
• 1-38 MySQL database field properties-non-empty properties
• 1-39 MySQL database field properties-DEFAULT property
• 1-40 MySQL database field properties-PRIMARYKEY property
• 1-41 MySQL database field properties-AUTO_INCREMENT property
• 1-42 MySQL database field properties-UNIQUE property
• 1-43 MySQL database field properties-COMMENT property
• 1-44 MySQL advanced operations-basic understanding
• 1-45 MySQL Advanced Operations-New-Worm Replication
• 1-46 MySQL advanced operations-new-replace replacement
• 1-47 MySQL advanced operations-query-select options
• 1-48 MySQL advanced operations-query-alias
• 1-49 MySQL advanced operations-query-data source.
• 1-50 MySQL advanced operations-query-where clause
• 1-51 MySQL advanced operations-query-GROUPBY clause
• 1-52 MySQL advanced operations-query-HAVING clause
• 1-53 MySQL advanced operations-query-ORDERBY clause
• 1-54 MySQL advanced operations-query-LIMIT clause
• 1-55 MySQL Advanced Operation-Query-Summary
• 1-56 MySQL Advanced Operations-Update-Restrict Updates
• 1-57 MySQL Advanced Operation-Delete-Restrict Delete
• 1-58 MySQL advanced operations-delete-clear data
• 1-59 Database design specifications - understanding
• 1-60 Database Design Specification-Norm-1NF
• 1-61 Database design specification-normal form-2NF
• 1-62 Database design specifications-normal form-3NF
• 1-63 Database design specifications - normalization - denormalization
• 1-64 Database design specifications-table relationships-one-to-one
• 1-65 Database design specifications-table relationships-one-to-many
• 1-66 Database design specifications-table relationships-many-to-many
• 1-67 Multi-table operation - understanding
• 1-68 Multi-table operation-joint query
• 1-69 Multi-table operation-join query-understand
• 1-70 Multi-table operation-join query-cross join
• 1-71 Multi-table operation-join query-inner join
• 1-72 Multi-table operation-join query-outer join
• 1-73 Multi-table operation-join query-natural join
• 1-74 subquery-understand
• 1-75 Subquery - scalar subquery
• 1-76 Subquery-column subquery
• 1-77 Subquery-row subquery
• 1-78 Subquery - table subquery
• 1-79 MySQL Security Management-Understanding
• 1-80 MySQL Security Management-Data Backup and Restore-Learn
• 1-81 MySQL Security Management-Data Backup and Restore-File Backup and Restore
• 1-82 MySQL security management-data backup and restore-whole database backup and restore
• 1-83 MySQL Security Management-Foreign Key-Result Management
• 1-84 MySQL security management-foreign key-foreign key constraints
• 1-85 MySQL security management-transaction security
• 1-86 MySQL Security Management-View-Basic Operations
• 1-87 MySQL Security Management-View-Data Operation
• 1-88 MySQL Security Management-View-Algorithm
• 1-89 MySQL security management-user rights management
• 1-90 PHP operates MySQL-understand
• 1-91 PHP operation MySQL-load mysqli extension
• 1-92 PHP operates MySQL-add, delete, modify and query
• 1-93 HTTP protocol - understanding
• 1-94 HTTP protocol - understanding
• 1-95 HTTP protocol-HTTP request
• 1-96 HTTP protocol-HTTP response
• 1-97 Conversational Technology - Understanding
• 1-98 Session technology-cookie technology-principle.
• 1-99 Session technology-cookie technology-implementation
• 1-100 Session technology-cookie technology-advanced applications
• 1-101 Session technology-session technology-principle.
• 1-102 Session technology-session technology-technical implementation
• 1-103 Session technology-session technology-session configuration
• 1-104 Session technology - comparison between session and cookie
• 1-105 GD Image Processing-Understanding
• 1-106 GD image processing-getting to know the GD library
• 1-107 GD image processing-verification code production
• 1-108 GD image processing-verification code function
• 1-109 GD image processing-watermark production
• 1-110 GD image processing-watermark function
• 1-111 GD image processing-thumbnail production
• 1-112 GD image processing-thumbnail function