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.
Learn about network building blocks (Routers, Switches, WAPs), network hardware components, cable types, resource sharing, and cloud computing with video tutorials.
Learn about laptop hardware components, SODIMM RAM, OLED/IPS displays, ACPI power management, smartphone hardware, and troubleshooting with video tutorials.
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.
Learn basic principles of networking, LAN vs WAN, OSI & TCP/IP models, IP addresses, ISP technologies, and network troubleshooting with video tutorials.
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.