PHP database programming from zero to proficient

Database - basic understanding

Database-relational database concepts

SQL understanding.

Basic understanding of MySQL

MySQL server operation management

Client login and exit MySQL system

Basic operations of MySQL database-SQL learning preface

MySQL database basic operations-SQL syntax rules

View database

Create database

-Modify database character set

Delete database

SQL table (field) operation-create data table

View datasheet

Update data table

Delete data table

SQL data operations-new

Query data

update data

delete data

Character set concept

Detailed explanation of MySQL character set

Proofreading set concept

Proofreading set settings

Proofreading set application

MySQL database fields-basic understanding

MySQL database fields-basic classification

MySQL database field-integer

MySQL database field-display width

MySQL database field-decimal type (floating point number

MySQL database field - decimal type (fixed point number).

MySQL database field-time date type

MySQL database field-string (char and varchar

MySQL database field - string (text string)

MySQL database field - string (enumeration)

MySQL database field-string (collection) + summary

MySQL database field properties - understanding

MySQL database field properties-non-empty properties

MySQL database field properties-DEFAULT property

MySQL database field properties-PRIMARYKEY property

MySQL database field properties-AUTO_INCREMENT property

MySQL database field properties-UNIQUE property

MySQL database field properties-COMMENT property

MySQL advanced operations-basic understanding

MySQL Advanced Operations-New-Worm Replication

MySQL advanced operations-new-replace replacement

MySQL advanced operations-query-select options

MySQL advanced operations-query-alias

MySQL advanced operations-query-data source.

MySQL advanced operations-query-where clause

MySQL advanced operations-query-GROUPBY clause

MySQL advanced operations-query-HAVING clause

MySQL advanced operations-query-ORDERBY clause

MySQL advanced operations-query-LIMIT clause

MySQL Advanced Operation-Query-Summary

MySQL Advanced Operations-Update-Restrict Updates

MySQL Advanced Operation-Delete-Restrict Delete

MySQL advanced operations-delete-clear data

Database design specifications - understanding

Database Design Specification-Norm-1NF

Database design specification-normal form-2NF

Database design specifications-normal form-3NF

Database design specifications - normalization - denormalization

Database design specifications-table relationships-one-to-one

Database design specifications-table relationships-one-to-many

Database design specifications-table relationships-many-to-many

Multi-table operation - understanding

Multi-table operation-joint query

Multi-table operation-join query-understand

Multi-table operation-join query-cross join

Multi-table operation-join query-inner join

Multi-table operation-join query-outer join

Multi-table operation-join query-natural join

subquery-understand

Subquery - scalar subquery

Subquery-column subquery

Subquery-row subquery

Subquery - table subquery

MySQL Security Management-Understanding

MySQL Security Management-Data Backup and Restore-Learn

MySQL Security Management-Data Backup and Restore-File Backup and Restore

MySQL security management-data backup and restore-whole database backup and restore

MySQL Security Management-Foreign Key-Result Management

MySQL security management-foreign key-foreign key constraints

MySQL security management-transaction security

MySQL Security Management-View-Basic Operations

MySQL Security Management-View-Data Operation

MySQL Security Management-View-Algorithm

MySQL security management-user rights management

PHP operates MySQL-understand

PHP operation MySQL-load mysqli extension

PHP operates MySQL-add, delete, modify and query

HTTP protocol - understanding

HTTP protocol - understanding

HTTP protocol-HTTP request

HTTP protocol-HTTP response

Conversational Technology - Understanding

Session technology-cookie technology-principle.

Session technology-cookie technology-implementation

Session technology-cookie technology-advanced applications

Session technology-session technology-principle.

Session technology-session technology-technical implementation

Session technology-session technology-session configuration

Session technology - comparison between session and cookie

GD Image Processing-Understanding

GD image processing-getting to know the GD library

GD image processing-verification code production

GD image processing-verification code function

GD image processing-watermark production

GD image processing-watermark function

GD image processing-thumbnail production

GD image processing-thumbnail function