All Database & SQL Tutorial Series & Course List

Hello my friend! Welcome to the All Database & SQL Tutorial Series & Course List on dev.rean.me! Below is the complete step-by-step learning guide covering everything from database installation, table creation, SQL queries, JOIN operations, subqueries, PostgreSQL, SQL Server, and downloadable SQL files with video tutorials in Khmer!

Click on any tutorial link below to open full step-by-step guide with video in a new tab! Let's get started!

🗄️ Database Setup & Core Fundamentals

Learn how to download and install MySQL server, understand SQL data types, and master the logical order of execution in SQL queries.

1. 01 - Download and Install MySQL with Video Tutorial in Khmer
   Step-by-step guide to download and install MySQL Community Server on Windows with root password setup.

2. 02 - SQL Data Types Explained (Numeric, String, Date & Time)
   Learn INT, VARCHAR, DATETIME, DECIMAL, and choosing the right data types for performance.

3. 03 - Order of Execution in SQL (SQL Execution Order Explained)
   Understand how database engines execute FROM, WHERE, GROUP BY, HAVING, SELECT, and ORDER BY.

💡 Tip: Always test your SQL queries on a development or local database first before running UPDATE or DELETE on a live production database! Always use WHERE clause!

---

📚 Library Database Practice & Practical Queries

Practice building a complete Library Database schema, inserting data, running basic to advanced SELECT queries, and working with subqueries.

4. 04 - Library Database Example - Create Tables with Data Download
   Create books, authors, borrowers, and issuing tables with downloadable SQL script.

5. 05 - Library Database - 10 SQL Practice Questions & Answers (Part 1)
   Basic to intermediate SELECT queries, filtering with WHERE, ORDER BY, and aggregate functions.

6. 06 - Library Database - 10 More SQL Practice Questions & Answers (Part 2)
   JOIN statements, GROUP BY aggregation, HAVING clause, and multi-table data extraction.

7. 07 - Library Database - 5 Advanced SQL Select Queries & Subqueries (Part 3)
   Advanced nested queries, subqueries, complex INNER JOINs, and conditional aggregation.

💡 Tip: When writing JOIN queries across multiple tables, always use clear table aliases (like b for books and a for authors) to keep your SQL clean and easy to read!

---

📝 Student Exam Database Hands-on Exercises

Build a Student Exam grading database, write table schemas, insert sample records, and solve 10 real-world SQL examination questions.

8. 08 - Student Exam Database Part 1 - Create Tables in MySQL
   Designing student, course, and exam grade tables with primary keys and foreign keys.

9. 09 - Student Exam Database Part 2 - Insert Sample Data with Download
   Inserting student records and exam scores with downloadable sample .sql dataset.

10. 10 - Student Exam Database Part 3 - 10 Practical SQL Select Questions
    Calculating average scores, pass/fail results, top performing students, and grade ranking.

💡 Tip: Use INDEX on columns frequently used in WHERE, JOIN, and ORDER BY clauses to speed up search query performance in large databases!

---

🏢 Enterprise Systems, PostgreSQL & SQL Server

Explore full-scale Student Management system designs across MySQL and Microsoft SQL Server, plus employee tracking in PostgreSQL.

11. 11 - Student Management System Database Design & Queries in MySQL
    Complete end-to-end database design for school/university student management system in MySQL.

12. 12 - Student Management System Database in Microsoft SQL Server
    Implementing relational database management using Microsoft SQL Server and SSMS.

13. 13 - Employee Database Example in PostgreSQL with Video Tutorial in Khmer
    Setup PostgreSQL, create employee & department tables, and run advanced relational queries.

💡 Tip: Always back up your database regularly using mysqldump or automated backups before making structural schema changes!

---

⚡ SELECT Queries Mastery & SQL Cheatsheet

Master all variations of the SELECT statement and keep the complete SQL command reference cheatsheet for quick daily lookup.

14. 14 - All Forms of SELECT Statements in SQL (Simple to Advanced Queries)
    Comprehensive guide explaining basic SELECT, DISTINCT, WHERE, LIKE, IN, BETWEEN, GROUP BY, and HAVING.

15. 15 - Complete SQL Cheatsheet with Commands & Cheat Sheet File Download
    Quick reference guide for DDL, DML, DCL, TCL commands, and downloadable PDF cheat sheet.

💡 Tip: Bookmark this course list page so you can easily return and reference any database topic or SQL code example anytime! Happy learning!