PHP database programming from zero to proficient-Free online video tutorial-php.cn

Community Learn Tools Library Leisure

English

PHP database programming from zero to proficient

This course starts from the shallower to the deeper, explaining the knowledge points related to the MySQL database in detail and complete, and finally forms a complete database programming knowledge system. A course suitable for novices or veterans to review

Elementary

PHP database programming from zero foundation to mastery

314130 person learning

112class hour

13 hours 54 minutes 22 secondsTotal course duration

2023-05-22update

-

Gold lecturer

A total of 43 courses Student53535 Lecturer rating5.0

More>>

Course Introduction Course Outline Other Courses

You will learn：

This course starts from the shallower to the deeper, explaining the knowledge points related to the MySQL database in detail and complete, and finally forms a complete database programming knowledge system. A course suitable for novices or veterans to review

PHP database programming from zero to proficient

Chapter1 PHP database programming from zero to proficient
expand retract

Section1 Database - basic understanding
duration： 11 minutes 03 seconds

Section2 Database-relational database concepts
duration： 07 minutes 31 seconds

Section3 SQL understanding.
duration： 05 minutes 58 seconds

Section4 Basic understanding of MySQL
duration： 08 minutes 00 seconds

Section5 MySQL server operation management
duration： 03 minutes 39 seconds

Section6 Client login and exit MySQL system
duration： 08 minutes 29 seconds

Section7 Basic operations of MySQL database-SQL learning preface
duration： 02 minutes 21 seconds

Section8 MySQL database basic operations-SQL syntax rules
duration： 08 minutes 04 seconds

Section9 View database
duration： 08 minutes 32 seconds

Section10 Create database
duration： 09 minutes 24 seconds

Section11 -Modify database character set
duration： 02 minutes 53 seconds

Section12 Delete database
duration： 04 minutes 54 seconds

Section13 SQL table (field) operation-create data table
duration： 15 minutes 56 seconds

Section14 View datasheet
duration： 07 minutes 58 seconds

Section15 Update data table
duration： 13 minutes 24 seconds

Section16 Delete data table
duration： 04 minutes 49 seconds

Section17 SQL data operations-new
duration： 07 minutes 00 seconds

Section18 Query data
duration： 04 minutes 46 seconds

Section19 update data
duration： 04 minutes 06 seconds

Section20 delete data
duration： 03 minutes 12 seconds

Section21 Character set concept
duration： 08 minutes 48 seconds

Section22 Detailed explanation of MySQL character set
duration： 15 minutes 02 seconds

Section23 Proofreading set concept
duration： 04 minutes 17 seconds

Section24 Proofreading set settings
duration： 06 minutes 46 seconds

Section25 Proofreading set application
duration： 05 minutes 08 seconds

Section26 MySQL database fields-basic understanding
duration： 01 minutes 13 seconds

Section27 MySQL database fields-basic classification
duration： 02 minutes 14 seconds

Section28 MySQL database field-integer
duration： 07 minutes 59 seconds

Section29 MySQL database field-display width
duration： 07 minutes 17 seconds

Section30 MySQL database field-decimal type (floating point number
duration： 09 minutes 08 seconds

Section31 MySQL database field - decimal type (fixed point number).
duration： 05 minutes 29 seconds

Section32 MySQL database field-time date type
duration： 11 minutes 48 seconds

Section33 MySQL database field-string (char and varchar
duration： 10 minutes 49 seconds

Section34 MySQL database field - string (text string)
duration： 04 minutes 25 seconds

Section35 MySQL database field - string (enumeration)
duration： 05 minutes 58 seconds

Section36 MySQL database field-string (collection) + summary
duration： 08 minutes 23 seconds

Section37 MySQL database field properties - understanding
duration： 02 minutes 28 seconds

Section38 MySQL database field properties-non-empty properties
duration： 06 minutes 03 seconds

Section39 MySQL database field properties-DEFAULT property
duration： 05 minutes 59 seconds

Section40 MySQL database field properties-PRIMARYKEY property
duration： 14 minutes 44 seconds

Section41 MySQL database field properties-AUTO_INCREMENT property
duration： 13 minutes 20 seconds

Section42 MySQL database field properties-UNIQUE property
duration： 13 minutes 39 seconds

Section43 MySQL database field properties-COMMENT property
duration： 03 minutes 29 seconds

Section44 MySQL advanced operations-basic understanding
duration： 01 minutes 32 seconds

Section45 MySQL Advanced Operations-New-Worm Replication
duration： 06 minutes 30 seconds

Section46 MySQL advanced operations-new-replace replacement
duration： 06 minutes 00 seconds

Section47 MySQL advanced operations-query-select options
duration： 04 minutes 43 seconds

Section48 MySQL advanced operations-query-alias
duration： 05 minutes 45 seconds

Section49 MySQL advanced operations-query-data source.
duration： 07 minutes 22 seconds

Section50 MySQL advanced operations-query-where clause
duration： 10 minutes 32 seconds

Section51 MySQL advanced operations-query-GROUPBY clause
duration： 19 minutes 36 seconds

Section52 MySQL advanced operations-query-HAVING clause
duration： 04 minutes 33 seconds

Section53 MySQL advanced operations-query-ORDERBY clause
duration： 05 minutes 48 seconds

Section54 MySQL advanced operations-query-LIMIT clause
duration： 04 minutes 54 seconds

Section55 MySQL Advanced Operation-Query-Summary
duration： 02 minutes 00 seconds

Section56 MySQL Advanced Operations-Update-Restrict Updates
duration： 02 minutes 27 seconds

Section57 MySQL Advanced Operation-Delete-Restrict Delete
duration： 01 minutes 00 seconds

Section58 MySQL advanced operations-delete-clear data
duration： 03 minutes 21 seconds

Section59 Database design specifications - understanding
duration： 03 minutes 29 seconds

Section60 Database Design Specification-Norm-1NF
duration： 03 minutes 10 seconds

Section61 Database design specification-normal form-2NF
duration： 05 minutes 04 seconds

Section62 Database design specifications-normal form-3NF
duration： 05 minutes 12 seconds

Section63 Database design specifications - normalization - denormalization
duration： 03 minutes 31 seconds

Section64 Database design specifications-table relationships-one-to-one
duration： 04 minutes 21 seconds

Section65 Database design specifications-table relationships-one-to-many
duration： 04 minutes 54 seconds

Section66 Database design specifications-table relationships-many-to-many
duration： 05 minutes 11 seconds

Section67 Multi-table operation - understanding
duration： 01 minutes 30 seconds

Section68 Multi-table operation-joint query
duration： 13 minutes 06 seconds

Section69 Multi-table operation-join query-understand
duration： 02 minutes 07 seconds

Section70 Multi-table operation-join query-cross join
duration： 04 minutes 44 seconds

Section71 Multi-table operation-join query-inner join
duration： 10 minutes 45 seconds

Section72 Multi-table operation-join query-outer join
duration： 11 minutes 33 seconds

Section73 Multi-table operation-join query-natural join
duration： 07 minutes 46 seconds

Section74 subquery-understand
duration： 02 minutes 17 seconds

Section75 Subquery - scalar subquery
duration： 03 minutes 21 seconds

Section76 Subquery-column subquery
duration： 06 minutes 53 seconds

Section77 Subquery-row subquery
duration： 03 minutes 47 seconds

Section78 Subquery - table subquery
duration： 07 minutes 44 seconds

Section79 MySQL Security Management-Understanding
duration： 02 minutes 03 seconds

Section80 MySQL Security Management-Data Backup and Restore-Learn
duration： 03 minutes 07 seconds

Section81 MySQL Security Management-Data Backup and Restore-File Backup and Restore
duration： 06 minutes 24 seconds

Section82 MySQL security management-data backup and restore-whole database backup and restore
duration： 08 minutes 47 seconds

Section83 MySQL Security Management-Foreign Key-Result Management
duration： 06 minutes 24 seconds

Section84 MySQL security management-foreign key-foreign key constraints
duration： 12 minutes 29 seconds

Section85 MySQL security management-transaction security
duration： 18 minutes 03 seconds

Section86 MySQL Security Management-View-Basic Operations
duration： 05 minutes 59 seconds

Section87 MySQL Security Management-View-Data Operation
duration： 05 minutes 03 seconds

Section88 MySQL Security Management-View-Algorithm
duration： 08 minutes 00 seconds

Section89 MySQL security management-user rights management
duration： 11 minutes 25 seconds

Section90 PHP operates MySQL-understand
duration： 02 minutes 37 seconds

Section91 PHP operation MySQL-load mysqli extension
duration： 07 minutes 57 seconds

Section92 PHP operates MySQL-add, delete, modify and query
duration： 30 minutes 26 seconds

Section93 HTTP protocol - understanding
duration： 01 minutes 33 seconds

Section94 HTTP protocol - understanding
duration： 07 minutes 09 seconds

Section95 HTTP protocol-HTTP request
duration： 05 minutes 57 seconds

Section96 HTTP protocol-HTTP response
duration： 19 minutes 08 seconds

Section97 Conversational Technology - Understanding
duration： 02 minutes 29 seconds

Section98 Session technology-cookie technology-principle.
duration： 04 minutes 34 seconds

Section99 Session technology-cookie technology-implementation
duration： 09 minutes 43 seconds

Section100 Session technology-cookie technology-advanced applications
duration： 17 minutes 21 seconds

Section101 Session technology-session technology-principle.
duration： 03 minutes 11 seconds

Section102 Session technology-session technology-technical implementation
duration： 16 minutes 10 seconds

Section103 Session technology-session technology-session configuration
duration： 06 minutes 00 seconds

Section104 Session technology - comparison between session and cookie
duration： 02 minutes 51 seconds

Section105 GD Image Processing-Understanding
duration： 01 minutes 04 seconds

Section106 GD image processing-getting to know the GD library
duration： 05 minutes 32 seconds

Section107 GD image processing-verification code production
duration： 15 minutes 10 seconds

Section108 GD image processing-verification code function
duration： 17 minutes 59 seconds

Section109 GD image processing-watermark production
duration： 10 minutes 43 seconds

Section110 GD image processing-watermark function
duration： 11 minutes 42 seconds

Section111 GD image processing-thumbnail production
duration： 11 minutes 37 seconds

Section112 GD image processing-thumbnail function
duration： 22 minutes 52 seconds

- Lecturer Other Courses

ElementaryHTML front-end basics Part 6

338215
Collection
IntermediateHTML5 development practice: front-end production of Baidu takeout mobile website

64135
Collection
ElementaryFrom scratch to WEB responsive layout

160416
Collection
ElementaryGet started quickly with HTML5

54594
Collection
ElementaryGet started quickly with CSS3

78117
Collection
Intermediatetouch video tutorial

81596
Collection
IntermediateWeb front-end development hybrid development video tutorial

30701
Collection
IntermediateHTML5 Canvas animation practical tutorial

56975
Collection
Elementarybootstrap3 series (English) + Twitter Bootstrap101 series

47689
Collection
ElementaryBrothers Zhang Cheng UI tutorial Bootstrap video tutorial

43606
Collection
ElementaryBacking Network BootStrap video tutorial

42718
Collection
ElementaryBootstrap responsive web layout

188870
Collection

Start Learning

This course includes：

13 hours 54 minutes 22 seconds Watch videos anytime

0 Download Resources

Popular courses Latest courses

More>