| (00:02:13) Prerequisite |
| (00:03:05) Introduction to the database |
| (00:12:45) Types of database |
| (00:18:26) Types of Key |
| (00:26:18) DBMS |
| (00:31:53) RDBMS |
| (00:34:32) Relations |
| (00:40:08) Sorting & Indexing |
| (00:47:15) Security |
| (00:53:40) Query Language |
| (00:59:21) SQL |
| (01:05:01) Setup XAMPP |
| (01:07:52) SHOW, CREATE AND DROP DATABASE |
| (01:13:30) Data Types |
| (01:17:37) CREATE, RENAME, DROP TABLE |
| (01:27:10) INSERT records |
| (01:40:22) SELECT records |
| (01:46:12) DISTINCT LIMIT |
| (01:51:01) Sorting |
| (01:56:50) Arithmetic Operators |
| (01:58:58) WHERE clause |
| (02:04:54) Relational Operators |
| (02:07:26) Logical Operators – AND, OR |
| (02:14:28) Logical Operators – IN, NOT IN |
| (02:19:03) Logical Operators - LIKE |
| (02:24:04) Custom name |
| (02:25:38) Constraint and AUTO_INCREMENT |
| (02:36:05) UPDATE records |
| (02:41:08) DELETE records |
| (02:45:02) UPPER & LOWER |
| (02:48:54) Functions |
| (02:57:26) Aggregate functions |
| (03:04:52) subquery |
| (03:10:28) ALTER statement |
| (03:18:01) UPDATE statement |
| (03:20:09) GROUP BY CLAUSE |
| (03:25:11) TRUNCATE TABLE |
| (03:27:48) Joining tables |
| (03:38:07) JOIN CLAUSE |
| (03:44:27) INNER JOIN |
| (03:49:28) LEFT & RIGHT JOIN |
| (03:53:32) UNION, UNION ALL |
| (03:58:17) VIEW |
| (04:07:40) Date & Time |
| (04:17:00) outro |