dev.rean.me

#mysql

22 posts

Articles tagged with #mysql.

⭐ FEATUREDdatabase2026-09-26 · 8 min read
→

Complete SQL Developer Roadmap 2026: From Beginner to Advanced Master

Step-by-step SQL learning roadmap from complete beginner to advanced database expert. Learn relational database design, joins, CTEs, window functions, query optimization, indexing, and security.

⭐ FEATUREDdatabase2026-09-26 · 8 min read
→

Essential SQL Commands: Complete Guide with Code Examples, Best Practice Tips & Resources

Master essential SQL commands including DDL, DML, DQL, DCL, and TCL. Complete guide with practical code examples, performance & security tips, and curated related resources opening in new tabs.

php2026-09-24 · 8 min read
→

PHP Cheat Sheet with Example Code

Learn essential PHP syntax, variables, arrays, functions, control structures, MySQL CRUD, REST APIs, and security best practices in simple broken English.

⭐ FEATUREDdatabase2026-09-19 · 19 min read
→

Complete Database & SQL References & Tips with Code Examples

Comprehensive SQL reference guide covering DDL, DML, SELECT queries, JOINs, aggregation, subqueries, CTEs, indexing, transactions, data types, security, and performance tips with code examples and related tutorials.

⭐ FEATUREDphp2026-09-19 · 30 min read
→

Complete PHP References & Tips with Code Examples

Comprehensive PHP reference guide covering variables, arrays, functions, OOP, MySQL, APIs, security, and practical tips with code examples and related tutorials.

⭐ FEATUREDphp2026-09-18 · 4 min read
→

List of PHP Tutorial Series & Course List

Master PHP programming, XAMPP setup, variables, arrays, functions, control structures, MySQL CRUD, REST APIs, VS Code snippets, and PHP development tools step-by-step with this complete tutorial list.

⭐ FEATUREDdatabase2026-09-12 · 4 min read
→

All Database & SQL Tutorial Series & Course List

Master MySQL, PostgreSQL, SQL Server, database design, queries, table creation, and JOINs step-by-step with this complete tutorial series in Khmer.

database2026-08-26 · 5 min read
→

SQL Cheat Sheet — Free Download for Beginner

SQL cheat sheet free download. Learn SQL statement fast — CREATE TABLE, INSERT, SELECT, UPDATE, DELETE and more. Good for beginner who use SQL, MySQL, PostgreSQL, or SQL Server.

database2026-08-26 · 11 min read
→

SQL SELECT Statement — All Forms Explained with Example

Learn all forms of SQL SELECT statement from basic to advanced. We explain SELECT, WHERE, JOIN, GROUP BY, HAVING, Subquery, CASE, UNION, Window Function with simple example. Good for MySQL, PostgreSQL, SQL Server.

database2026-08-25 · 6 min read
→

SQL Operation Logic Order Explained

Learn how SQL engine really read and execute your query. We explain SQL logical execution order step by step with simple example. Good for beginner who use SQL, MySQL, or PostgreSQL.

database2026-08-24 · 4 min read
→

Student Exam Database Part 3 - 10 SQL SELECT Questions and Answers (Video in Khmer)

Step-by-step guide to practice 10 SQL SELECT queries for Student Exam database using INNER JOIN, GROUP BY, LIKE, YEAR(), SUM(), and Subquery. Video in Khmer.

database2026-08-24 · 9 min read
→

Student Management Database (MySQL) Example with Enrollment and Payment (video inside)

In this video, we create simple student management database step-by-step from scratch, including students table, courses table, enrollments, and payment tracking. Includes SQL queries for enrollment and payment operations.

database2026-08-23 · 3 min read
→

04-Library Database Exercise 3 - 5 Advanced SQL Questions and Answers (Video in Khmer)

Practice 5 advanced SQL queries using Library Database with Date functions (CURDATE, YEAR), AVG, SUM, MIN, MAX, and INNER JOIN. Video in Khmer.

database2026-08-23 · 3 min read
→

Student Exam Database Part 1 - Create Tables in MySQL (Video in Khmer)

Step-by-step guide to create 4 tables for Student Exam database in MySQL with Primary Keys, Foreign Keys, and EER Diagram. Video in Khmer.

database2026-08-23 · 2 min read
→

Student Exam Database Part 2 - Insert Data and Download Example (Video in Khmer)

Step-by-step guide to insert sample data into 4 tables for Student Exam database using MySQL with Foreign Key insertion rules. Video in Khmer.

database2026-08-22 · 3 min read
→

01-Library Database Example - Create Tables with Data Download (Video in Khmer)

Step-by-step guide to create tables with data download for a library database using MySQL with video tutorial in Khmer.

database2026-08-22 · 3 min read
→

02-Library Database Exercise 1 - 10 SQL Questions and Answers (Video in Khmer)

Practice 10 basic SQL SELECT queries using Library Database. Includes questions, SQL query answers, and video tutorial in Khmer.

database2026-08-22 · 4 min read
→

03-Library Database Exercise 2 - 10 More SQL Questions and Answers (Video in Khmer)

Practice 10 more SQL queries using Library Database with COUNT, GROUP BY, HAVING, and Subqueries. Includes SQL query answers and video tutorial in Khmer.

database2026-08-22 · 2 min read
→

Download and Install MySQL with Video Tutorial in Khmer (Step-by-Step)

Step-by-step guide to download and install MySQL Community Server on Windows 10/11 with video tutorial in Khmer. Learn how to set root password and test connection.

php2026-08-20 · 7 min read
→

How to Create Simple PHP API with Database & Test with Postman in Khmer

Build a RESTful PHP API with MySQL database step-by-step and test endpoints using Postman with Khmer video tutorials.

php2026-08-19 · 6 min read
→

PHP CRUD (Create, Read, Update, Delete) with MySQL Database with Video in Khmer

Master PHP CRUD (Create, Read, Update, Delete) with MySQL Database with step-by-step Khmer video tutorials and practical code examples.

php2026-08-17 · 4 min read
→

How to Download Install and Configure XAMPP for PHP or Laravel with Video Demo in Khmer

Easy step-by-step guide to download, install and configure XAMPP web server for PHP and Laravel development with video demo and error fix tips.