Name: Geek Academy mysql video tutorial
Uploaded: 2022-04-21T17:21:46+8:00
Duration: 473 min 26 s
Description: "Geek Academy MySQL Video Tutorial" explains to everyone the basic knowledge about databases and database operations, including database installation, database connections, database additions, deletions, modifications, PDO, etc.

Chapter1PHP giving MySQL: Introduction and use of MySQL
13 minutes14 seconds; PHP operation MySQL
16 minutes08 seconds; User data query
16 minutes39 seconds; Adding user data and preventing SQL injection attacks
17 minutes31 seconds; Modify user data
16 minutes11 seconds; Delete user data
05 minutes14 seconds
Chapter2MySQL introduction and installation: Introduction to MySQL
04 minutes13 seconds; Install MySQL on a Mac computer
06 minutes49 seconds; Install MySQL on a Windows computer
06 minutes58 seconds; Install MySQL on a Linux computer
07 minutes20 seconds
Chapter3Working with MySQL databases and tables: Create, use and delete MySQL database
06 minutes16 seconds; MySQL database table operations
07 minutes01 seconds; Obtain information about databases and tables and an introduction to database physical files
04 minutes45 seconds
Chapter4MySQL data types: MySQL numeric types
10 minutes51 seconds; MySQL character type
07 minutes43 seconds; MySQL date and time types
05 minutes31 seconds
Chapter5MySQL connect to database: MySQL connects to the database through shell
06 minutes53 seconds; MySQL Connect to the database through MySQL Workbench
04 minutes28 seconds; MySQL Connect to the database through Navicat for MySQL
05 minutes20 seconds
Chapter6MySQL operators: MySQL arithmetic operators
06 minutes32 seconds; MySQL comparison operators
09 minutes46 seconds; MySQL logical operators and bitwise operators
07 minutes05 seconds
Chapter7MySQL operation data: MySQL basic insert data
06 minutes44 seconds; MySQL advanced insert data
08 minutes25 seconds; MySQL update data and delete data
06 minutes21 seconds
Chapter8MySQL function: MySQL math functions and aggregate functions
11 minutes19 seconds; MySQL string functions
08 minutes14 seconds; MySQL date and time functions
04 minutes41 seconds; MySQL data encryption function
09 minutes06 seconds; MySQL control flow functions
06 minutes00 seconds; MySQL formatting functions and type conversion functions
07 minutes14 seconds
Chapter9MySQL joins and unions: MySQL connection concepts and types
05 minutes29 seconds; MySQL cross join, inner join and outer join
11 minutes18 seconds; MySQL self joins and unions
07 minutes58 seconds
Chapter10MySQL subquery: The concept of MySQL subquery
07 minutes53 seconds; Common ways to use MySQL subqueries (1)
07 minutes32 seconds; Common ways to use MySQL subqueries (2)
06 minutes29 seconds
Chapter11Basic concepts of MySQL transactions: Basic concepts of MySQL transaction processing
08 minutes28 seconds; MySQL transaction life cycle
09 minutes23 seconds; Autocommit for MySQL transactions
04 minutes26 seconds
Chapter12MySQL transaction isolation levels and locks: The concept of MySQL transaction isolation level and serialization isolation
10 minutes23 seconds; MySQL transaction isolation levels repeatable read, committed read and uncommitted read
11 minutes57 seconds; MySQL performance and table locking for non-transactional tables
11 minutes10 seconds
Chapter13MySQL management and permission management: Basic tasks of MySQL database management
05 minutes41 seconds; MySQL authorization table
06 minutes06 seconds; MySQL permission control
08 minutes37 seconds
Chapter14Understanding and Application of PDO Objects: PDO object knowledge
12 minutes10 seconds; PDO object initialization
11 minutes07 seconds; PDO object application
12 minutes12 seconds
Chapter15PDO security processing and transaction processing: Course Introduction
01 minutes33 seconds; PDO exception handling
07 minutes43 seconds; PDO preprocessing
14 minutes44 seconds; PDO transaction processing
13 minutes07 seconds
Chapter16PDO project example-student information management system: System introduction and construction
02 minutes54 seconds; Add and view system functions; System function deletion and modification
14 minutes34 seconds

Geek Academy mysql video tutorial

About Instructor

php.cn