Articles tagged with #database.
Master MySQL, PostgreSQL, SQL Server, database design, queries, table creation, and JOINs step-by-step with this complete tutorial series in Khmer.
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.
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.
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.
Step-by-step guide to create Employee table and insert sample data using PostgreSQL and write basic SQL queries. 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.
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.
Practice 5 advanced SQL queries using Library Database with Date functions (CURDATE, YEAR), AVG, SUM, MIN, MAX, and INNER JOIN. Video in Khmer.
Simple guide to understand common SQL Data Types in Database like Numeric, String, Date, Binary, and Boolean with practical tips. Learn differences between DBMS systems.
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.
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.
Step-by-step guide to create tables with data download for a library database using MySQL with video tutorial in Khmer.
Practice 10 basic SQL SELECT queries using Library Database. Includes questions, SQL query answers, and video tutorial 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.
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.
Build a RESTful PHP API with MySQL database step-by-step and test endpoints using Postman with Khmer video tutorials.
Master PHP CRUD (Create, Read, Update, Delete) with MySQL Database with step-by-step Khmer video tutorials and practical code examples.