Boolean Education Yan Shiba MySQL introductory video tutorial

• Chapter1 mysql from entry to proficiency
• 1-1 Understand and install MySQL
• 1-2 client concept
• 1-3 The concept of tables and libraries
• 1-4 Get to know SQL
• 1-5 insert operation
• 1-6 update operation
• 1-7 delete operation
• 1-8 Simple choice
• 1-9 Understand the query model
• 1-10 Query exercises
• 1-11 Query exercises explained
• 1-12 Weird NULL
• 1-13 group group statistics
• 1-14 having filter result set
• 1-15 having comprehensive case explanation
• 1-16 order by order
• 1-17 limit usage
• 1-18 Clause Query Trap
• 1-19 where type subquery
• 1-20 from subquery
• 1-21 exists subquery
• 1-22 Novice 1+N query
• 1-23 inner join query
• 1-24 Left and right join queries and exercises
• 1-25 Connection query interview questions
• 1-26 union query
• 1-27 Union query interview questions
• 1-28 Table creation process
• 1-29 integer column
• 1-30 Integer column properties
• 1-31 Floating point columns and fixed point columns
• 1-32 character column
• 1-33 datetime column
• 1-34 Column default value
• 1-35 Primary key and auto-increment
• 1-36 Comprehensive table building case
• 1-37 Column addition, deletion and modification
• 1-38 view view
• 1-39 viewalgorithm
• 1-40 Commonly used table management statements
• 1-41 The concept of storage engine
• 1-42 Character set and garbled code issues
• 1-43 Index concept
• 1-44 Index operation syntax
• 1-45 Commonly used functions
• 1-46 transaction concept