Name: Master the basics of MySQL in 6 days video
Uploaded: 2021-11-18T17:43:44+8:00
Duration: 1249 min 19 s
Description: This set is a video tutorial on the basics of MySQL database, including form value transfer + project for 1 day, a total of 6 days. The course explains in detail the relevant knowledge of MySQL, including MySQL overview, MySQL application environment, MySQL system features, MySQL basics for beginners, MySQL management tools, how to install MySQL and new MySQL features.

Chapter1Chapter One: MySQL learning path
02 minutes25 seconds; Basic introduction to database learning path
00 minutes40 seconds; Database basics
03 minutes00 seconds; Database classification
04 minutes41 seconds; Relational Database
06 minutes44 seconds; non-relational database
06 minutes19 seconds; Basic introduction to SQL
06 minutes04 seconds; Basic introduction to MySQL
06 minutes40 seconds; MySQL access
11 minutes02 seconds; Summary of basic introduction to database
04 minutes36 seconds
Chapter2Chapter two: MySQL basic operation learning path
01 minutes37 seconds; SQL syntax rules
06 minutes53 seconds; SQL library operation learning path
00 minutes58 seconds; Create database
08 minutes39 seconds; show database
04 minutes40 seconds; Use database
03 minutes06 seconds; Modify database
05 minutes14 seconds; Delete database
02 minutes58 seconds; Summary of SQL library operations
01 minutes51 seconds; SQL table operation learning path
01 minutes08 seconds
Chapter3third chapter: Create data table
12 minutes14 seconds; show data table
09 minutes16 seconds; View datasheet
03 minutes54 seconds; Change data table
04 minutes49 seconds; Change field learning path
02 minutes26 seconds; Add new field
03 minutes38 seconds; field position
04 minutes02 seconds; Change field name
03 minutes41 seconds; Modify fields
02 minutes39 seconds; Delete field
02 minutes32 seconds
Chapter4Chapter Four: Summary of SQL table operations
02 minutes45 seconds; SQL database operation learning path
01 minutes02 seconds; Add new data
07 minutes32 seconds; View data
06 minutes27 seconds; update data
04 minutes10 seconds; delete data
03 minutes06 seconds; Summary of SQL data operations
02 minutes03 seconds; Character set learning path
01 minutes29 seconds; Character set concept
16 minutes47 seconds; MySQL character set
14 minutes48 seconds
Chapter5chapter Five: Solving the problem of garbled characters
11 minutes17 seconds; Character set setting principle
12 minutes01 seconds; Character set summary
03 minutes56 seconds; Proofreading Set Learning Path
00 minutes47 seconds; Proofreading set concept
07 minutes13 seconds; Proofing set settings
05 minutes30 seconds; Proofreading set application
06 minutes56 seconds; Proofreading set summary
01 minutes57 seconds; Field type learning path
01 minutes57 seconds; Field type role
06 minutes34 seconds
Chapter6Chapter Six: integer type
11 minutes45 seconds; display width
10 minutes03 seconds; Decimal type (floating point number)
15 minutes59 seconds; Decimal type (fixed point number)
08 minutes27 seconds; String type (fixed length)
06 minutes42 seconds; String type (variable length)
09 minutes01 seconds; String type (text string)
06 minutes16 seconds; String type (enumeration)
10 minutes53 seconds; String type (collection)
13 minutes06 seconds; Time date type (year)
06 minutes52 seconds
Chapter7Chapter VII: Time date type (timestamp)
08 minutes14 seconds; Time date type (date)
03 minutes45 seconds; Time date type (date time)
03 minutes58 seconds; Time date type (time)
05 minutes26 seconds; Field type summary
03 minutes15 seconds; Attribute learning path
01 minutes05 seconds; Attribute function
04 minutes05 seconds; Null attribute
05 minutes23 seconds; Default attribute
08 minutes00 seconds; primary key
12 minutes12 seconds
Chapter8chapter eight: Primary key management
03 minutes42 seconds; self-increasing property
09 minutes28 seconds; self-growth management
06 minutes47 seconds; unique key
10 minutes23 seconds; Unique key management
04 minutes51 seconds; comment attribute
04 minutes57 seconds; Property summary
02 minutes02 seconds; MySQL record length
11 minutes37 seconds; Paradigm learning path
06 minutes10 seconds; First normal form 1NF
04 minutes47 seconds
Chapter9Chapter nine: Second normal form 2NF
08 minutes47 seconds; Third normal form 3NF
05 minutes31 seconds; denormalization
05 minutes15 seconds; Summary of design paradigms
02 minutes03 seconds; Table relationship learning path
05 minutes38 seconds; one-to-one relationship
05 minutes05 seconds; one-to-many relationship
07 minutes13 seconds; many-to-many relationship
06 minutes22 seconds; Table relationship summary
02 minutes42 seconds; MySQL advanced SQL operation learning path
03 minutes15 seconds
Chapter10chapter Ten: New learning path for data
01 minutes01 seconds; Batch insert
06 minutes24 seconds; worm replication
08 minutes30 seconds; primary key conflict
12 minutes30 seconds; Data query learning path
01 minutes50 seconds; Query options
07 minutes05 seconds; Field selection and aliasing
11 minutes21 seconds; data source
11 minutes59 seconds; where child clause
04 minutes34 seconds; operator
10 minutes23 seconds
Chapter11Chapter 11: Group statistics (group by)
15 minutes06 seconds; Lookback statistics
07 minutes22 seconds; Group sorting
03 minutes17 seconds; having clause
06 minutes18 seconds; order by child clause
05 minutes41 seconds; limit clause
05 minutes35 seconds; Data query summary
02 minutes32 seconds; Update data (restrict updates)
03 minutes46 seconds; Restrict deletion
02 minutes05 seconds; Clear data
04 minutes18 seconds
Chapter12Chapter 12: MySQL multi-table operation learning path
03 minutes01 seconds; Federated Query Learning Path
00 minutes58 seconds; Union query
10 minutes11 seconds; Union query sorting
05 minutes40 seconds; Connect Query Learning Path
02 minutes48 seconds; cross connect
02 minutes48 seconds; inner join
09 minutes33 seconds; outer join
07 minutes08 seconds; natural connection
07 minutes17 seconds; using keyword
04 minutes27 seconds
Chapter13Chapter 13: Join query summary
01 minutes44 seconds; Subquery learning path
03 minutes49 seconds; subquery classification
03 minutes25 seconds; scalar subquery
04 minutes45 seconds; column subquery
04 minutes22 seconds; row subquery
05 minutes14 seconds; Table subquery
08 minutes37 seconds; exists subquery
05 minutes04 seconds; comparison method
04 minutes27 seconds; Subquery summary
02 minutes46 seconds
Chapter14Chapter 14: MySQL security management learning path
02 minutes58 seconds; Foreign key constraint learning path
01 minutes04 seconds; foreign key
07 minutes09 seconds; foreign key constraints
14 minutes23 seconds; Foreign key management
04 minutes49 seconds; Transaction Security Learning Path
01 minutes22 seconds; affairs
08 minutes21 seconds; transaction processing
11 minutes42 seconds; Transaction characteristics
05 minutes51 seconds; Preprocessing learning path
00 minutes52 seconds
Chapter15Chapter 15: preprocessing
10 minutes29 seconds; Preprocessing parameters
07 minutes36 seconds; View Learning Path
01 minutes28 seconds; view
09 minutes49 seconds; View management
05 minutes57 seconds; View data operations
13 minutes35 seconds; View algorithm
08 minutes45 seconds; Data backup and restore learning path
03 minutes54 seconds; Table data backup
11 minutes48 seconds; Table data restoration
08 minutes34 seconds
Chapter16Chapter 16: File backup
06 minutes30 seconds; File restore
03 minutes25 seconds; SQL backup
10 minutes58 seconds; SQL restore
07 minutes48 seconds; Data backup and restore summary
03 minutes50 seconds; User management learning path
01 minutes02 seconds; Account management
10 minutes31 seconds; authority management
16 minutes04 seconds; role management
10 minutes31 seconds; PHP operation MySQL database learning path
01 minutes21 seconds
Chapter17Chapter 17: PHP extension
04 minutes45 seconds; MySQLi extension
13 minutes36 seconds; MySQLi common functions
05 minutes21 seconds; Add new data
12 minutes34 seconds; update data
06 minutes17 seconds; delete data
06 minutes20 seconds; Query data
12 minutes06 seconds; Summary of operating MySQL database with PHP
22 minutes03 seconds; Form value passing learning path
00 minutes35 seconds; form value
05 minutes16 seconds
Chapter18Chapter 18: post value
04 minutes15 seconds; get pass value
04 minutes27 seconds; PHP receives form data
11 minutes46 seconds; News Management System Learning Path
11 minutes46 seconds; Database Design
09 minutes41 seconds; Add news (display form)
13 minutes40 seconds; Add new news (data into database)
12 minutes23 seconds; encapsulation
32 minutes29 seconds; news list
11 minutes28 seconds; delete news
13 minutes00 seconds
Chapter19Chapter 19: View news
09 minutes48 seconds; Editorial News
14 minutes35 seconds; Pagination (top)
10 minutes38 seconds; Pagination (below)
23 minutes17 seconds; Project improvement and summary
07 minutes21 seconds

Master the basics of MySQL in 6 days video

About Instructor

php.cn