Section1 Database - basic understanding

11 minutes03 seconds

Section2 Database-relational database concepts

07 minutes31 seconds

Section3 SQL understanding.

05 minutes58 seconds

Section4 Basic understanding of MySQL

08 minutes00 seconds

Section5 MySQL server operation management

03 minutes39 seconds

Section6 Client login and exit MySQL system

08 minutes29 seconds

Section7 Basic operations of MySQL database-SQL learning preface

02 minutes21 seconds

Section8 MySQL database basic operations-SQL syntax rules

08 minutes04 seconds

Section9 View database

08 minutes32 seconds

Section10 Create database

09 minutes24 seconds

Section11 -Modify database character set

02 minutes53 seconds

Section12 Delete database

04 minutes54 seconds

Section13 SQL table (field) operation-create data table

15 minutes56 seconds

Section14 View datasheet

07 minutes58 seconds

Section15 Update data table

13 minutes24 seconds

Section16 Delete data table

04 minutes49 seconds

Section17 SQL data operations-new

07 minutes00 seconds

Section18 Query data

04 minutes46 seconds

Section19 update data

04 minutes06 seconds

Section20 delete data

03 minutes12 seconds

Section21 Character set concept

08 minutes48 seconds

Section22 Detailed explanation of MySQL character set

15 minutes02 seconds

Section23 Proofreading set concept

04 minutes17 seconds

Section24 Proofreading set settings

06 minutes46 seconds

Section25 Proofreading set application

05 minutes08 seconds

Section26 MySQL database fields-basic understanding

01 minutes13 seconds

Section27 MySQL database fields-basic classification

02 minutes14 seconds

Section28 MySQL database field-integer

07 minutes59 seconds

Section29 MySQL database field-display width

07 minutes17 seconds

Section30 MySQL database field-decimal type (floating point number

09 minutes08 seconds

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

05 minutes29 seconds

Section32 MySQL database field-time date type

11 minutes48 seconds

Section33 MySQL database field-string (char and varchar

10 minutes49 seconds

Section34 MySQL database field - string (text string)

04 minutes25 seconds

Section35 MySQL database field - string (enumeration)

05 minutes58 seconds

Section36 MySQL database field-string (collection) + summary

08 minutes23 seconds

Section37 MySQL database field properties - understanding

02 minutes28 seconds

Section38 MySQL database field properties-non-empty properties

06 minutes03 seconds

Section39 MySQL database field properties-DEFAULT property

05 minutes59 seconds

Section40 MySQL database field properties-PRIMARYKEY property

14 minutes44 seconds

Section41 MySQL database field properties-AUTO_INCREMENT property

13 minutes20 seconds

Section42 MySQL database field properties-UNIQUE property

13 minutes39 seconds

Section43 MySQL database field properties-COMMENT property

03 minutes29 seconds

Section44 MySQL advanced operations-basic understanding

01 minutes32 seconds

Section45 MySQL Advanced Operations-New-Worm Replication

06 minutes30 seconds

Section46 MySQL advanced operations-new-replace replacement

06 minutes00 seconds

Section47 MySQL advanced operations-query-select options

04 minutes43 seconds

Section48 MySQL advanced operations-query-alias

05 minutes45 seconds

Section49 MySQL advanced operations-query-data source.

07 minutes22 seconds

Section50 MySQL advanced operations-query-where clause

10 minutes32 seconds

Section51 MySQL advanced operations-query-GROUPBY clause

19 minutes36 seconds

Section52 MySQL advanced operations-query-HAVING clause

04 minutes33 seconds

Section53 MySQL advanced operations-query-ORDERBY clause

05 minutes48 seconds

Section54 MySQL advanced operations-query-LIMIT clause

04 minutes54 seconds

Section55 MySQL Advanced Operation-Query-Summary

02 minutes00 seconds

Section56 MySQL Advanced Operations-Update-Restrict Updates

02 minutes27 seconds

Section57 MySQL Advanced Operation-Delete-Restrict Delete

01 minutes00 seconds

Section58 MySQL advanced operations-delete-clear data

03 minutes21 seconds

Section59 Database design specifications - understanding

03 minutes29 seconds

Section60 Database Design Specification-Norm-1NF

03 minutes10 seconds

Section61 Database design specification-normal form-2NF

05 minutes04 seconds

Section62 Database design specifications-normal form-3NF

05 minutes12 seconds

Section63 Database design specifications - normalization - denormalization

03 minutes31 seconds

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

04 minutes21 seconds

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

04 minutes54 seconds

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

05 minutes11 seconds

Section67 Multi-table operation - understanding

01 minutes30 seconds

Section68 Multi-table operation-joint query

13 minutes06 seconds

Section69 Multi-table operation-join query-understand

02 minutes07 seconds

Section70 Multi-table operation-join query-cross join

04 minutes44 seconds

Section71 Multi-table operation-join query-inner join

10 minutes45 seconds

Section72 Multi-table operation-join query-outer join

11 minutes33 seconds

Section73 Multi-table operation-join query-natural join

07 minutes46 seconds

Section74 subquery-understand

02 minutes17 seconds

Section75 Subquery - scalar subquery

03 minutes21 seconds

Section76 Subquery-column subquery

06 minutes53 seconds

Section77 Subquery-row subquery

03 minutes47 seconds

Section78 Subquery - table subquery

07 minutes44 seconds

Section79 MySQL Security Management-Understanding

02 minutes03 seconds

Section80 MySQL Security Management-Data Backup and Restore-Learn

03 minutes07 seconds

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

06 minutes24 seconds

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

08 minutes47 seconds

Section83 MySQL Security Management-Foreign Key-Result Management

06 minutes24 seconds

Section84 MySQL security management-foreign key-foreign key constraints

12 minutes29 seconds

Section85 MySQL security management-transaction security

18 minutes03 seconds

Section86 MySQL Security Management-View-Basic Operations

05 minutes59 seconds

Section87 MySQL Security Management-View-Data Operation

05 minutes03 seconds

Section88 MySQL Security Management-View-Algorithm

08 minutes00 seconds

Section89 MySQL security management-user rights management

11 minutes25 seconds

Section90 PHP operates MySQL-understand

02 minutes37 seconds

Section91 PHP operation MySQL-load mysqli extension

07 minutes57 seconds

Section92 PHP operates MySQL-add, delete, modify and query

30 minutes26 seconds

Section93 HTTP protocol - understanding

01 minutes33 seconds

Section94 HTTP protocol - understanding

07 minutes09 seconds

Section95 HTTP protocol-HTTP request

05 minutes57 seconds

Section96 HTTP protocol-HTTP response

19 minutes08 seconds

Section97 Conversational Technology - Understanding

02 minutes29 seconds

Section98 Session technology-cookie technology-principle.

04 minutes34 seconds

Section99 Session technology-cookie technology-implementation

09 minutes43 seconds

Section100 Session technology-cookie technology-advanced applications

17 minutes21 seconds

Section101 Session technology-session technology-principle.

03 minutes11 seconds

Section102 Session technology-session technology-technical implementation

16 minutes10 seconds

Section103 Session technology-session technology-session configuration

06 minutes00 seconds

Section104 Session technology - comparison between session and cookie

02 minutes51 seconds

Section105 GD Image Processing-Understanding

01 minutes04 seconds

Section106 GD image processing-getting to know the GD library

05 minutes32 seconds

Section107 GD image processing-verification code production

15 minutes10 seconds

Section108 GD image processing-verification code function

17 minutes59 seconds

Section109 GD image processing-watermark production

10 minutes43 seconds

Section110 GD image processing-watermark function

11 minutes42 seconds

Section111 GD image processing-thumbnail production

11 minutes37 seconds

Section112 GD image processing-thumbnail function

22 minutes52 seconds