Geek Academy mysql video tutorial
"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.
190408
person learning
56
class hour
2023-05-22
update time
07 Hours53 minutes26 seconds
Total course duration
You will learn
After studying "Geek Academy MySQL Video Tutorial" you will understand and be familiar with all the knowledge points about the database, master the basic add, delete, modify and query statements. You can combine it with PHP and use it skillfully to create a complete project.
Geek Academy mysql video tutorial
Section1 Introduction and use of MySQL
13 minutes14 seconds
Section2 PHP operation MySQL
16 minutes08 seconds
Section3 User data query
16 minutes39 seconds
Section4 Adding user data and preventing SQL injection attacks
17 minutes31 seconds
Section5 Modify user data
16 minutes11 seconds
Section6 Delete user data
05 minutes14 seconds
Chapter1 PHP giving MySQL
Section1 Introduction to MySQL
04 minutes13 seconds
Section2 Install MySQL on a Mac computer
06 minutes49 seconds
Section3 Install MySQL on a Windows computer
06 minutes58 seconds
Section4 Install MySQL on a Linux computer
07 minutes20 seconds
Chapter2 MySQL introduction and installation
Section1 Create, use and delete MySQL database
06 minutes16 seconds
Section2 MySQL database table operations
07 minutes01 seconds
Section3 Obtain information about databases and tables and an introduction to database physical files
04 minutes45 seconds
Chapter3 Working with MySQL databases and tables
Section1 MySQL numeric types
10 minutes51 seconds
Section2 MySQL character type
07 minutes43 seconds
Section3 MySQL date and time types
05 minutes31 seconds
Chapter4 MySQL data types
Section1 MySQL connects to the database through shell
06 minutes53 seconds
Section2 MySQL Connect to the database through MySQL Workbench
04 minutes28 seconds
Section3 MySQL Connect to the database through Navicat for MySQL
05 minutes20 seconds
Chapter5 MySQL connect to database
Section1 MySQL arithmetic operators
06 minutes32 seconds
Section2 MySQL comparison operators
09 minutes46 seconds
Section3 MySQL logical operators and bitwise operators
07 minutes05 seconds
Chapter6 MySQL operators
Section1 MySQL basic insert data
06 minutes44 seconds
Section2 MySQL advanced insert data
08 minutes25 seconds
Section3 MySQL update data and delete data
06 minutes21 seconds
Chapter7 MySQL operation data
Section1 MySQL math functions and aggregate functions
11 minutes19 seconds
Section2 MySQL string functions
08 minutes14 seconds
Section3 MySQL date and time functions
04 minutes41 seconds
Section4 MySQL data encryption function
09 minutes06 seconds
Section5 MySQL control flow functions
06 minutes00 seconds
Section6 MySQL formatting functions and type conversion functions
07 minutes14 seconds
Chapter8 MySQL function
Section1 MySQL connection concepts and types
05 minutes29 seconds
Section2 MySQL cross join, inner join and outer join
11 minutes18 seconds
Section3 MySQL self joins and unions
07 minutes58 seconds
Chapter9 MySQL joins and unions
Section1 The concept of MySQL subquery
07 minutes53 seconds
Section2 Common ways to use MySQL subqueries (1)
07 minutes32 seconds
Section3 Common ways to use MySQL subqueries (2)
06 minutes29 seconds
Chapter10 MySQL subquery
Section1 Basic concepts of MySQL transaction processing
08 minutes28 seconds
Section2 MySQL transaction life cycle
09 minutes23 seconds
Section3 Autocommit for MySQL transactions
04 minutes26 seconds
Chapter11 Basic concepts of MySQL transactions
Section1 The concept of MySQL transaction isolation level and serialization isolation
10 minutes23 seconds
Section2 MySQL transaction isolation levels repeatable read, committed read and uncommitted read
11 minutes57 seconds
Section3 MySQL performance and table locking for non-transactional tables
11 minutes10 seconds
Chapter12 MySQL transaction isolation levels and locks
Section1 Basic tasks of MySQL database management
05 minutes41 seconds
Section2 MySQL authorization table
06 minutes06 seconds
Section3 MySQL permission control
08 minutes37 seconds
Chapter13 MySQL management and permission management
Section1 PDO object knowledge
12 minutes10 seconds
Section2 PDO object initialization
11 minutes07 seconds
Section3 PDO object application
12 minutes12 seconds
Chapter14 Understanding and Application of PDO Objects
Section1 Course Introduction
01 minutes33 seconds
Section2 PDO exception handling
07 minutes43 seconds
Section3 PDO preprocessing
14 minutes44 seconds
Section4 PDO transaction processing
13 minutes07 seconds
Chapter15 PDO security processing and transaction processing
Section1 System introduction and construction
02 minutes54 seconds
Section2 Add and view system functions
In calculation
Section3 System function deletion and modification
14 minutes34 seconds
Chapter16 PDO project example-student information management system
Data Name
The courseware is currently not available for download, and the staff are organizing it. Please pay more attention to this course in the future~
巴扎黑 Lecturer Other Courses
Free
Popular courses
JAVA Beginner's Video Tutorial
753 class hour
2982764
Little Turtle's zero-based introduction to learning Python video tutorial
60 class hour
546854
Quick introduction to web front-end development
8 class hour
220816
Master PS video tutorials from scratch
268 class hour
1003583
Latest courses
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
[Web front-end] Node.js quick start
16 class hour
16702
Complete collection of foreign web development full-stack courses
12 class hour
13513
Go language practical GraphQL
10 class hour
11163
550W fan master learns JavaScript from scratch step by step
1 class hour
1265
