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