MySQL learning path
02 minutes25 secondsBasic introduction to database learning path
00 minutes40 secondsDatabase basics
03 minutes00 secondsDatabase classification
04 minutes41 secondsRelational Database
06 minutes44 secondsnon-relational database
06 minutes19 secondsBasic introduction to SQL
06 minutes04 secondsBasic introduction to MySQL
06 minutes40 secondsMySQL access
11 minutes02 secondsSummary of basic introduction to database
04 minutes36 secondsMySQL basic operation learning path
01 minutes37 secondsSQL syntax rules
06 minutes53 secondsSQL library operation learning path
00 minutes58 secondsCreate database
08 minutes39 secondsshow database
04 minutes40 secondsUse database
03 minutes06 secondsModify database
05 minutes14 secondsDelete database
02 minutes58 secondsSummary of SQL library operations
01 minutes51 secondsSQL table operation learning path
01 minutes08 secondsCreate data table
12 minutes14 secondsshow data table
09 minutes16 secondsView datasheet
03 minutes54 secondsChange data table
04 minutes49 secondsChange field learning path
02 minutes26 secondsAdd new field
03 minutes38 secondsfield position
04 minutes02 secondsChange field name
03 minutes41 secondsModify fields
02 minutes39 secondsDelete field
02 minutes32 secondsSummary of SQL table operations
02 minutes45 secondsSQL database operation learning path
01 minutes02 secondsAdd new data
07 minutes32 secondsView data
06 minutes27 secondsupdate data
04 minutes10 secondsdelete data
03 minutes06 secondsSummary of SQL data operations
02 minutes03 secondsCharacter set learning path
01 minutes29 secondsCharacter set concept
16 minutes47 secondsMySQL character set
14 minutes48 secondsSolving the problem of garbled characters
11 minutes17 secondsCharacter set setting principle
12 minutes01 secondsCharacter set summary
03 minutes56 secondsProofreading Set Learning Path
00 minutes47 secondsProofreading set concept
07 minutes13 secondsProofing set settings
05 minutes30 secondsProofreading set application
06 minutes56 secondsProofreading set summary
01 minutes57 secondsField type learning path
01 minutes57 secondsField type role
06 minutes34 secondsinteger type
11 minutes45 secondsdisplay width
10 minutes03 secondsDecimal type (floating point number)
15 minutes59 secondsDecimal type (fixed point number)
08 minutes27 secondsString type (fixed length)
06 minutes42 secondsString type (variable length)
09 minutes01 secondsString type (text string)
06 minutes16 secondsString type (enumeration)
10 minutes53 secondsString type (collection)
13 minutes06 secondsTime date type (year)
06 minutes52 secondsTime date type (timestamp)
08 minutes14 secondsTime date type (date)
03 minutes45 secondsTime date type (date time)
03 minutes58 secondsTime date type (time)
05 minutes26 secondsField type summary
03 minutes15 secondsAttribute learning path
01 minutes05 secondsAttribute function
04 minutes05 secondsNull attribute
05 minutes23 secondsDefault attribute
08 minutes00 secondsprimary key
12 minutes12 secondsPrimary key management
03 minutes42 secondsself-increasing property
09 minutes28 secondsself-growth management
06 minutes47 secondsunique key
10 minutes23 secondsUnique key management
04 minutes51 secondscomment attribute
04 minutes57 secondsProperty summary
02 minutes02 secondsMySQL record length
11 minutes37 secondsParadigm learning path
06 minutes10 secondsFirst normal form 1NF
04 minutes47 secondsSecond normal form 2NF
08 minutes47 secondsThird normal form 3NF
05 minutes31 secondsdenormalization
05 minutes15 secondsSummary of design paradigms
02 minutes03 secondsTable relationship learning path
05 minutes38 secondsone-to-one relationship
05 minutes05 secondsone-to-many relationship
07 minutes13 secondsmany-to-many relationship
06 minutes22 secondsTable relationship summary
02 minutes42 secondsMySQL advanced SQL operation learning path
03 minutes15 secondsNew learning path for data
01 minutes01 secondsBatch insert
06 minutes24 secondsworm replication
08 minutes30 secondsprimary key conflict
12 minutes30 secondsData query learning path
01 minutes50 secondsQuery options
07 minutes05 secondsField selection and aliasing
11 minutes21 secondsdata source
11 minutes59 secondswhere child clause
04 minutes34 secondsoperator
10 minutes23 secondsGroup statistics (group by)
15 minutes06 secondsLookback statistics
07 minutes22 secondsGroup sorting
03 minutes17 secondshaving clause
06 minutes18 secondsorder by child clause
05 minutes41 secondslimit clause
05 minutes35 secondsData query summary
02 minutes32 secondsUpdate data (restrict updates)
03 minutes46 secondsRestrict deletion
02 minutes05 secondsClear data
04 minutes18 secondsMySQL multi-table operation learning path
03 minutes01 secondsFederated Query Learning Path
00 minutes58 secondsUnion query
10 minutes11 secondsUnion query sorting
05 minutes40 secondsConnect Query Learning Path
02 minutes48 secondscross connect
02 minutes48 secondsinner join
09 minutes33 secondsouter join
07 minutes08 secondsnatural connection
07 minutes17 secondsusing keyword
04 minutes27 secondsJoin query summary
01 minutes44 secondsSubquery learning path
03 minutes49 secondssubquery classification
03 minutes25 secondsscalar subquery
04 minutes45 secondscolumn subquery
04 minutes22 secondsrow subquery
05 minutes14 secondsTable subquery
08 minutes37 secondsexists subquery
05 minutes04 secondscomparison method
04 minutes27 secondsSubquery summary
02 minutes46 secondsMySQL security management learning path
02 minutes58 secondsForeign key constraint learning path
01 minutes04 secondsforeign key
07 minutes09 secondsforeign key constraints
14 minutes23 secondsForeign key management
04 minutes49 secondsTransaction Security Learning Path
01 minutes22 secondsaffairs
08 minutes21 secondstransaction processing
11 minutes42 secondsTransaction characteristics
05 minutes51 secondsPreprocessing learning path
00 minutes52 secondspreprocessing
10 minutes29 secondsPreprocessing parameters
07 minutes36 secondsView Learning Path
01 minutes28 secondsview
09 minutes49 secondsView management
05 minutes57 secondsView data operations
13 minutes35 secondsView algorithm
08 minutes45 secondsData backup and restore learning path
03 minutes54 secondsTable data backup
11 minutes48 secondsTable data restoration
08 minutes34 secondsFile backup
06 minutes30 secondsFile restore
03 minutes25 secondsSQL backup
10 minutes58 secondsSQL restore
07 minutes48 secondsData backup and restore summary
03 minutes50 secondsUser management learning path
01 minutes02 secondsAccount management
10 minutes31 secondsauthority management
16 minutes04 secondsrole management
10 minutes31 secondsPHP operation MySQL database learning path
01 minutes21 secondsPHP extension
04 minutes45 secondsMySQLi extension
13 minutes36 secondsMySQLi common functions
05 minutes21 secondsAdd new data
12 minutes34 secondsupdate data
06 minutes17 secondsdelete data
06 minutes20 secondsQuery data
12 minutes06 secondsSummary of operating MySQL database with PHP
22 minutes03 secondsForm value passing learning path
00 minutes35 secondsform value
05 minutes16 secondspost value
04 minutes15 secondsget pass value
04 minutes27 secondsPHP receives form data
11 minutes46 secondsNews Management System Learning Path
11 minutes46 secondsDatabase Design
09 minutes41 secondsAdd news (display form)
13 minutes40 secondsAdd new news (data into database)
12 minutes23 secondsencapsulation
32 minutes29 secondsnews list
11 minutes28 secondsdelete news
13 minutes00 secondsView news
09 minutes48 secondsEditorial News
14 minutes35 secondsPagination (top)
10 minutes38 secondsPagination (below)
23 minutes17 secondsProject improvement and summary
07 minutes21 secondsThis 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.