Master the basics of MySQL in 6 days video-Free online video tutorial-php.cn

Community Learn Tools Library Leisure

English

Master the basics of MySQL in 6 days video

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.

Elementary

mysql

Base

192127 person learning

185class hour

20 hours 49 minutes 19 secondsTotal course duration

2021-11-18update

王林

Gold lecturer

A total of 180 courses Student180304 Lecturer rating5.8

有朋自远方来，虽远必诛！More>>

Course Introduction Course Outline Data Download Other Courses

You will learn：

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.

Master the basics of MySQL in 6 days video

Chapter1 Chapter One
expand retract

Section1 MySQL learning path
duration： 02 minutes 25 seconds

Section2 Basic introduction to database learning path
duration： 00 minutes 40 seconds

Section3 Database basics
duration： 03 minutes 00 seconds

Section4 Database classification
duration： 04 minutes 41 seconds

Section5 Relational Database
duration： 06 minutes 44 seconds

Section6 non-relational database
duration： 06 minutes 19 seconds

Section7 Basic introduction to SQL
duration： 06 minutes 04 seconds

Section8 Basic introduction to MySQL
duration： 06 minutes 40 seconds

Section9 MySQL access
duration： 11 minutes 02 seconds

Section10 Summary of basic introduction to database
duration： 04 minutes 36 seconds
Chapter2 Chapter two
expand retract

Section1 MySQL basic operation learning path
duration： 01 minutes 37 seconds

Section2 SQL syntax rules
duration： 06 minutes 53 seconds

Section3 SQL library operation learning path
duration： 00 minutes 58 seconds

Section4 Create database
duration： 08 minutes 39 seconds

Section5 show database
duration： 04 minutes 40 seconds

Section6 Use database
duration： 03 minutes 06 seconds

Section7 Modify database
duration： 05 minutes 14 seconds

Section8 Delete database
duration： 02 minutes 58 seconds

Section9 Summary of SQL library operations
duration： 01 minutes 51 seconds

Section10 SQL table operation learning path
duration： 01 minutes 08 seconds
Chapter3 third chapter
expand retract

Section1 Create data table
duration： 12 minutes 14 seconds

Section2 show data table
duration： 09 minutes 16 seconds

Section3 View datasheet
duration： 03 minutes 54 seconds

Section4 Change data table
duration： 04 minutes 49 seconds

Section5 Change field learning path
duration： 02 minutes 26 seconds

Section6 Add new field
duration： 03 minutes 38 seconds

Section7 field position
duration： 04 minutes 02 seconds

Section8 Change field name
duration： 03 minutes 41 seconds

Section9 Modify fields
duration： 02 minutes 39 seconds

Section10 Delete field
duration： 02 minutes 32 seconds
Chapter4 Chapter Four
expand retract

Section1 Summary of SQL table operations
duration： 02 minutes 45 seconds

Section2 SQL database operation learning path
duration： 01 minutes 02 seconds

Section3 Add new data
duration： 07 minutes 32 seconds

Section4 View data
duration： 06 minutes 27 seconds

Section5 update data
duration： 04 minutes 10 seconds

Section6 delete data
duration： 03 minutes 06 seconds

Section7 Summary of SQL data operations
duration： 02 minutes 03 seconds

Section8 Character set learning path
duration： 01 minutes 29 seconds

Section9 Character set concept
duration： 16 minutes 47 seconds

Section10 MySQL character set
duration： 14 minutes 48 seconds
Chapter5 chapter Five
expand retract

Section1 Solving the problem of garbled characters
duration： 11 minutes 17 seconds

Section2 Character set setting principle
duration： 12 minutes 01 seconds

Section3 Character set summary
duration： 03 minutes 56 seconds

Section4 Proofreading Set Learning Path
duration： 00 minutes 47 seconds

Section5 Proofreading set concept
duration： 07 minutes 13 seconds

Section6 Proofing set settings
duration： 05 minutes 30 seconds

Section7 Proofreading set application
duration： 06 minutes 56 seconds

Section8 Proofreading set summary
duration： 01 minutes 57 seconds

Section9 Field type learning path
duration： 01 minutes 57 seconds

Section10 Field type role
duration： 06 minutes 34 seconds
Chapter6 Chapter Six
expand retract

Section1 integer type
duration： 11 minutes 45 seconds

Section2 display width
duration： 10 minutes 03 seconds

Section3 Decimal type (floating point number)
duration： 15 minutes 59 seconds

Section4 Decimal type (fixed point number)
duration： 08 minutes 27 seconds

Section5 String type (fixed length)
duration： 06 minutes 42 seconds

Section6 String type (variable length)
duration： 09 minutes 01 seconds

Section7 String type (text string)
duration： 06 minutes 16 seconds

Section8 String type (enumeration)
duration： 10 minutes 53 seconds

Section9 String type (collection)
duration： 13 minutes 06 seconds

Section10 Time date type (year)
duration： 06 minutes 52 seconds
Chapter7 Chapter VII
expand retract

Section1 Time date type (timestamp)
duration： 08 minutes 14 seconds

Section2 Time date type (date)
duration： 03 minutes 45 seconds

Section3 Time date type (date time)
duration： 03 minutes 58 seconds

Section4 Time date type (time)
duration： 05 minutes 26 seconds

Section5 Field type summary
duration： 03 minutes 15 seconds

Section6 Attribute learning path
duration： 01 minutes 05 seconds

Section7 Attribute function
duration： 04 minutes 05 seconds

Section8 Null attribute
duration： 05 minutes 23 seconds

Section9 Default attribute
duration： 08 minutes 00 seconds

Section10 primary key
duration： 12 minutes 12 seconds
Chapter8 chapter eight
expand retract

Section1 Primary key management
duration： 03 minutes 42 seconds

Section2 self-increasing property
duration： 09 minutes 28 seconds

Section3 self-growth management
duration： 06 minutes 47 seconds

Section4 unique key
duration： 10 minutes 23 seconds

Section5 Unique key management
duration： 04 minutes 51 seconds

Section6 comment attribute
duration： 04 minutes 57 seconds

Section7 Property summary
duration： 02 minutes 02 seconds

Section8 MySQL record length
duration： 11 minutes 37 seconds

Section9 Paradigm learning path
duration： 06 minutes 10 seconds

Section10 First normal form 1NF
duration： 04 minutes 47 seconds
Chapter9 Chapter nine
expand retract

Section1 Second normal form 2NF
duration： 08 minutes 47 seconds

Section2 Third normal form 3NF
duration： 05 minutes 31 seconds

Section3 denormalization
duration： 05 minutes 15 seconds

Section4 Summary of design paradigms
duration： 02 minutes 03 seconds

Section5 Table relationship learning path
duration： 05 minutes 38 seconds

Section6 one-to-one relationship
duration： 05 minutes 05 seconds

Section7 one-to-many relationship
duration： 07 minutes 13 seconds

Section8 many-to-many relationship
duration： 06 minutes 22 seconds

Section9 Table relationship summary
duration： 02 minutes 42 seconds

Section10 MySQL advanced SQL operation learning path
duration： 03 minutes 15 seconds
Chapter10 chapter Ten
expand retract

Section1 New learning path for data
duration： 01 minutes 01 seconds

Section2 Batch insert
duration： 06 minutes 24 seconds

Section3 worm replication
duration： 08 minutes 30 seconds

Section4 primary key conflict
duration： 12 minutes 30 seconds

Section5 Data query learning path
duration： 01 minutes 50 seconds

Section6 Query options
duration： 07 minutes 05 seconds

Section7 Field selection and aliasing
duration： 11 minutes 21 seconds

Section8 data source
duration： 11 minutes 59 seconds

Section9 where child clause
duration： 04 minutes 34 seconds

Section10 operator
duration： 10 minutes 23 seconds
Chapter11 Chapter 11
expand retract

Section1 Group statistics (group by)
duration： 15 minutes 06 seconds

Section2 Lookback statistics
duration： 07 minutes 22 seconds

Section3 Group sorting
duration： 03 minutes 17 seconds

Section4 having clause
duration： 06 minutes 18 seconds

Section5 order by child clause
duration： 05 minutes 41 seconds

Section6 limit clause
duration： 05 minutes 35 seconds

Section7 Data query summary
duration： 02 minutes 32 seconds

Section8 Update data (restrict updates)
duration： 03 minutes 46 seconds

Section9 Restrict deletion
duration： 02 minutes 05 seconds

Section10 Clear data
duration： 04 minutes 18 seconds
Chapter12 Chapter 12
expand retract

Section1 MySQL multi-table operation learning path
duration： 03 minutes 01 seconds

Section2 Federated Query Learning Path
duration： 00 minutes 58 seconds

Section3 Union query
duration： 10 minutes 11 seconds

Section4 Union query sorting
duration： 05 minutes 40 seconds

Section5 Connect Query Learning Path
duration： 02 minutes 48 seconds

Section6 cross connect
duration： 02 minutes 48 seconds

Section7 inner join
duration： 09 minutes 33 seconds

Section8 outer join
duration： 07 minutes 08 seconds

Section9 natural connection
duration： 07 minutes 17 seconds

Section10 using keyword
duration： 04 minutes 27 seconds
Chapter13 Chapter 13
expand retract

Section1 Join query summary
duration： 01 minutes 44 seconds

Section2 Subquery learning path
duration： 03 minutes 49 seconds

Section3 subquery classification
duration： 03 minutes 25 seconds

Section4 scalar subquery
duration： 04 minutes 45 seconds

Section5 column subquery
duration： 04 minutes 22 seconds

Section6 row subquery
duration： 05 minutes 14 seconds

Section7 Table subquery
duration： 08 minutes 37 seconds

Section8 exists subquery
duration： 05 minutes 04 seconds

Section9 comparison method
duration： 04 minutes 27 seconds

Section10 Subquery summary
duration： 02 minutes 46 seconds
Chapter14 Chapter 14
expand retract

Section1 MySQL security management learning path
duration： 02 minutes 58 seconds

Section2 Foreign key constraint learning path
duration： 01 minutes 04 seconds

Section3 foreign key
duration： 07 minutes 09 seconds

Section4 foreign key constraints
duration： 14 minutes 23 seconds

Section5 Foreign key management
duration： 04 minutes 49 seconds

Section6 Transaction Security Learning Path
duration： 01 minutes 22 seconds

Section7 affairs
duration： 08 minutes 21 seconds

Section8 transaction processing
duration： 11 minutes 42 seconds

Section9 Transaction characteristics
duration： 05 minutes 51 seconds

Section10 Preprocessing learning path
duration： 00 minutes 52 seconds
Chapter15 Chapter 15
expand retract

Section1 preprocessing
duration： 10 minutes 29 seconds

Section2 Preprocessing parameters
duration： 07 minutes 36 seconds

Section3 View Learning Path
duration： 01 minutes 28 seconds

Section4 view
duration： 09 minutes 49 seconds

Section5 View management
duration： 05 minutes 57 seconds

Section6 View data operations
duration： 13 minutes 35 seconds

Section7 View algorithm
duration： 08 minutes 45 seconds

Section8 Data backup and restore learning path
duration： 03 minutes 54 seconds

Section9 Table data backup
duration： 11 minutes 48 seconds

Section10 Table data restoration
duration： 08 minutes 34 seconds
Chapter16 Chapter 16
expand retract

Section1 File backup
duration： 06 minutes 30 seconds

Section2 File restore
duration： 03 minutes 25 seconds

Section3 SQL backup
duration： 10 minutes 58 seconds

Section4 SQL restore
duration： 07 minutes 48 seconds

Section5 Data backup and restore summary
duration： 03 minutes 50 seconds

Section6 User management learning path
duration： 01 minutes 02 seconds

Section7 Account management
duration： 10 minutes 31 seconds

Section8 authority management
duration： 16 minutes 04 seconds

Section9 role management
duration： 10 minutes 31 seconds

Section10 PHP operation MySQL database learning path
duration： 01 minutes 21 seconds
Chapter17 Chapter 17
expand retract

Section1 PHP extension
duration： 04 minutes 45 seconds

Section2 MySQLi extension
duration： 13 minutes 36 seconds

Section3 MySQLi common functions
duration： 05 minutes 21 seconds

Section4 Add new data
duration： 12 minutes 34 seconds

Section5 update data
duration： 06 minutes 17 seconds

Section6 delete data
duration： 06 minutes 20 seconds

Section7 Query data
duration： 12 minutes 06 seconds

Section8 Summary of operating MySQL database with PHP
duration： 22 minutes 03 seconds

Section9 Form value passing learning path
duration： 00 minutes 35 seconds

Section10 form value
duration： 05 minutes 16 seconds
Chapter18 Chapter 18
expand retract

Section1 post value
duration： 04 minutes 15 seconds

Section2 get pass value
duration： 04 minutes 27 seconds

Section3 PHP receives form data
duration： 11 minutes 46 seconds

Section4 News Management System Learning Path
duration： 11 minutes 46 seconds

Section5 Database Design
duration： 09 minutes 41 seconds

Section6 Add news (display form)
duration： 13 minutes 40 seconds

Section7 Add new news (data into database)
duration： 12 minutes 23 seconds

Section8 encapsulation
duration： 32 minutes 29 seconds

Section9 news list
duration： 11 minutes 28 seconds

Section10 delete news
duration： 13 minutes 00 seconds
Chapter19 Chapter 19
expand retract

Section1 View news
duration： 09 minutes 48 seconds

Section2 Editorial News
duration： 14 minutes 35 seconds

Section3 Pagination (top)
duration： 10 minutes 38 seconds

Section4 Pagination (below)
duration： 23 minutes 17 seconds

Section5 Project improvement and summary
duration： 07 minutes 21 seconds

Data Name operate
[must see]Master MySQL Basics Video Courseware in 6 Days Download

王林 Lecturer Other Courses

ElementaryComplete collection of interview questions in front-end disciplines (Season 1)

22834
Collection
ElementaryFlexible box + responsive page layout practice

8836
Collection
ElementaryMake a responsive website from scratch—Grid layout

17318
Collection
ElementaryThe most easy-to-understand HTML+CSS course in 9 days

43847
Collection
ElementaryBasic tutorial for getting started with Web front-end

236019
Collection
ElementaryWeb front-end development-Zero Basic Programming Admission Guide

65632
Collection
ElementaryFront-end basic HTML5+CSS3 from entry to proficiency (full version)

295428
Collection
ElementaryThe latest CSS3 tutorial is quick and easy to understand

22153
Collection
ElementaryCSS3 Flex flexible box model makes layout fly

27993
Collection
ElementaryLearn DIV+CSS layout in one day (five practical exercises)

10844
Collection
ElementaryHTML5+CSS practice project [Hand Knock Onmyoji official website]

10602
Collection
ElementaryMobile layout: HTML5+CSS3 advanced and enhanced version

120585
Collection

Start Learning

This course includes：

20 hours 49 minutes 19 seconds Watch videos anytime

1 Download Resources

Popular courses Latest courses

More>