Articles tagged with #sql.
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.