Power node mysql basic video tutorial

• Chapter1 mysql basic knowledge
• 1-1 Overview
• 1-2 DBMS, SQL, DB relationships
• 1-3 MYSQL installation
• 1-4 data sheet
• 1-5 SQL statement classification
• 1-6 data preparation
• 1-7 Table description
• 1-8 Common commands
• 1-9 Demo data structure
• 1-10 Simple query
• 1-11 Conditional query
• 1-12 sort
• 1-13 Data processing functions
• 1-14 Review the content of the morning
• 1-15 Date processing_str_to_date
• 1-16 Date processing_date_format
• 1-17 grouping function
• 1-18 distinct
• 1-19 Group query
• 1-20 Connection query (1)
• 1-21 Connection query (2)
• 1-22 Connection query (3)
• 1-23 Connection query (4)
• 1-24 Connection query (5)
• 1-25 Connection query (6)
• 1-26 Connection query (7)
• 1-27 Subquery (1)
• 1-28 Subquery (2)
• 1-29 Subquery (3)
• 1-30 union
• 1-31 limit
• 1-32 Table I)
• 1-33 Table II)
• 1-34 Table (3)
• 1-35 Table (4)
• 1-36 Table (5)
• 1-37 Table (6)
• 1-38 Table (7)
• 1-39 Constraints (1)
• 1-40 Constraints (2)
• 1-41 Constraints (3)
• 1-42 Constraints (4)
• 1-43 Constraints (5)
• 1-44 Constraints (6)
• 1-45 Constraints (7)
• 1-46 Cascading updates and deletes
• 1-47 Exercise (1)
• 1-48 Exercise (2)
• 1-49 Exercise (3)
• 1-50 Exercise (4)
• 1-51 Exercise (5)
• 1-52 Exercise (6)
• 1-53 Exercise (7)
• 1-54 Exercise (8)
• 1-55 CaseWhenThenElseEnd
• 1-56 Exercise 1
• 1-57 Exercise 2
• 1-58 Exercise 3
• 1-59 Exercise 4
• 1-60 Exercise 5
• 1-61 Exercise 6
• 1-62 Exercise 7
• 1-63 Exercise 8
• 1-64 Exercise 9
• 1-65 Exercise 10
• 1-66 Exercise 11
• 1-67 Exercise 12
• 1-68 Exercise 13
• 1-69 Exercise 14
• 1-70 Exercise 15
• 1-71 Exercise 16
• 1-72 Exercise 17
• 1-73 Exercise 18
• 1-74 Exercise 19
• 1-75 Exercise 20
• 1-76 Exercise 21
• 1-77 storage engine
• 1-78 Transaction 1
• 1-79 Transaction 2
• 1-80 Transaction 3
• 1-81 Transaction 4
• 1-82 Transaction 5
• 1-83 index
• 1-84 view
• 1-85 DBA command
• 1-86 Database design three paradigms