search

Next Section： 逆规范化968 plays

5 秒后自动播放下一节
Next Section
  Watch Again

Master the basics of MySQL in 6 days video

Introduction >
ChapterCourseware
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
  • CancelreplySending
  • Cancelpost a noteSending