Next Section: DBA命令1829 plays

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

Power node mysql basic video tutorial

Introduction >
ChapterCourseware
Chapter1mysql basic knowledge

Overview

04 minutes34 seconds

DBMS, SQL, DB relationships

13 minutes17 seconds

MYSQL installation

20 minutes23 seconds

data sheet

09 minutes54 seconds

SQL statement classification

07 minutes38 seconds

data preparation

05 minutes32 seconds

Table description

14 minutes33 seconds

Common commands

06 minutes15 seconds

Demo data structure

03 minutes29 seconds

Simple query

11 minutes24 seconds

Conditional query

28 minutes51 seconds

sort

06 minutes23 seconds

Data processing functions

13 minutes58 seconds

Review the content of the morning

17 minutes08 seconds

Date processing_str_to_date

26 minutes46 seconds

Date processing_date_format

08 minutes01 seconds

grouping function

12 minutes06 seconds

distinct

06 minutes28 seconds

Group query

36 minutes34 seconds

Connection query (1)

15 minutes41 seconds

Connection query (2)

09 minutes31 seconds

Connection query (3)

05 minutes17 seconds

Connection query (4)

09 minutes42 seconds

Connection query (5)

15 minutes27 seconds

Connection query (6)

02 minutes22 seconds

Connection query (7)

07 minutes34 seconds

Subquery (1)

05 minutes01 seconds

Subquery (2)

08 minutes30 seconds

Subquery (3)

03 minutes54 seconds

union

06 minutes54 seconds

limit

15 minutes12 seconds

Table I)

29 minutes39 seconds

Table II)

08 minutes47 seconds

Table (3)

26 minutes45 seconds

Table (4)

14 minutes29 seconds

Table (5)

11 minutes47 seconds

Table (6)

05 minutes54 seconds

Table (7)

12 minutes54 seconds

Constraints (1)

08 minutes35 seconds

Constraints (2)

16 minutes40 seconds

Constraints (3)

03 minutes22 seconds

Constraints (4)

28 minutes15 seconds

Constraints (5)

03 minutes40 seconds

Constraints (6)

21 minutes57 seconds

Constraints (7)

07 minutes32 seconds

Cascading updates and deletes

14 minutes58 seconds

Exercise (1)

06 minutes23 seconds

Exercise (2)

03 minutes09 seconds

Exercise (3)

08 minutes27 seconds

Exercise (4)

05 minutes46 seconds

Exercise (5)

08 minutes52 seconds

Exercise (6)

02 minutes28 seconds

Exercise (7)

08 minutes15 seconds

Exercise (8)

09 minutes33 seconds

CaseWhenThenElseEnd

03 minutes46 seconds

Exercise 1

04 minutes31 seconds

Exercise 2

03 minutes23 seconds

Exercise 3

36 minutes43 seconds

Exercise 4

03 minutes55 seconds

Exercise 5

02 minutes37 seconds

Exercise 6

06 minutes17 seconds

Exercise 7

02 minutes05 seconds

Exercise 8

04 minutes51 seconds

Exercise 9

00 minutes48 seconds

Exercise 10

05 minutes34 seconds

Exercise 11

04 minutes43 seconds

Exercise 12

06 minutes06 seconds

Exercise 13

01 minutes58 seconds

Exercise 14

02 minutes19 seconds

Exercise 15

02 minutes12 seconds

Exercise 16

15 minutes57 seconds

Exercise 17

03 minutes03 seconds

Exercise 18

02 minutes41 seconds

Exercise 19

05 minutes20 seconds

Exercise 20

05 minutes16 seconds

Exercise 21

02 minutes09 seconds

storage engine

27 minutes41 seconds

Transaction 1

17 minutes51 seconds

Transaction 2

13 minutes20 seconds

Transaction 3

14 minutes42 seconds

Transaction 4

22 minutes00 seconds

Transaction 5

28 minutes39 seconds

index

23 minutes28 seconds

view

09 minutes22 seconds

DBA command

11 minutes05 seconds

Database design three paradigms

20 minutes26 seconds
  • CancelreplySending
  • Cancelpost a noteSending