Geek Academy mysql video tutorial

• Chapter1 PHP giving MySQL
• 1-1 Introduction and use of MySQL
• 1-2 PHP operation MySQL
• 1-3 User data query
• 1-4 Adding user data and preventing SQL injection attacks
• 1-5 Modify user data
• 1-6 Delete user data
• Chapter2 MySQL introduction and installation
• 2-1 Introduction to MySQL
• 2-2 Install MySQL on a Mac computer
• 2-3 Install MySQL on a Windows computer
• 2-4 Install MySQL on a Linux computer
• Chapter3 Working with MySQL databases and tables
• 3-1 Create, use and delete MySQL database
• 3-2 MySQL database table operations
• 3-3 Obtain information about databases and tables and an introduction to database physical files
• Chapter4 MySQL data types
• 4-1 MySQL numeric types
• 4-2 MySQL character type
• 4-3 MySQL date and time types
• Chapter5 MySQL connect to database
• 5-1 MySQL connects to the database through shell
• 5-2 MySQL Connect to the database through MySQL Workbench
• 5-3 MySQL Connect to the database through Navicat for MySQL
• Chapter6 MySQL operators
• 6-1 MySQL arithmetic operators
• 6-2 MySQL comparison operators
• 6-3 MySQL logical operators and bitwise operators
• Chapter7 MySQL operation data
• 7-1 MySQL basic insert data
• 7-2 MySQL advanced insert data
• 7-3 MySQL update data and delete data
• Chapter8 MySQL function
• 8-1 MySQL math functions and aggregate functions
• 8-2 MySQL string functions
• 8-3 MySQL date and time functions
• 8-4 MySQL data encryption function
• 8-5 MySQL control flow functions
• 8-6 MySQL formatting functions and type conversion functions
• Chapter9 MySQL joins and unions
• 9-1 MySQL connection concepts and types
• 9-2 MySQL cross join, inner join and outer join
• 9-3 MySQL self joins and unions
• Chapter10 MySQL subquery
• 10-1 The concept of MySQL subquery
• 10-2 Common ways to use MySQL subqueries (1)
• 10-3 Common ways to use MySQL subqueries (2)
• Chapter11 Basic concepts of MySQL transactions
• 11-1 Basic concepts of MySQL transaction processing
• 11-2 MySQL transaction life cycle
• 11-3 Autocommit for MySQL transactions
• Chapter12 MySQL transaction isolation levels and locks
• 12-1 The concept of MySQL transaction isolation level and serialization isolation
• 12-2 MySQL transaction isolation levels repeatable read, committed read and uncommitted read
• 12-3 MySQL performance and table locking for non-transactional tables
• Chapter13 MySQL management and permission management
• 13-1 Basic tasks of MySQL database management
• 13-2 MySQL authorization table
• 13-3 MySQL permission control
• Chapter14 Understanding and Application of PDO Objects
• 14-1 PDO object knowledge
• 14-2 PDO object initialization
• 14-3 PDO object application
• Chapter15 PDO security processing and transaction processing
• 15-1 Course Introduction
• 15-2 PDO exception handling
• 15-3 PDO preprocessing
• 15-4 PDO transaction processing
• Chapter16 PDO project example-student information management system
• 16-1 System introduction and construction
• 16-2 Add and view system functions
• 16-3 System function deletion and modification