06066300 DATABASE SYSTEM CONCEPT 2568

Home / Class / DATABASE SYSTEM CONCEPT 2568

Course Code

06066300

Open Date

June 2nd 2025 00:00

Close Date

October 31st 2025 00:00

Instructor


TA

Tag

SQL , DBMS , Database Logical Design

Chapter General   

  • 1

    Lab Playground

  • 2

    LAB- คำอธิบายโครงสร้างตารางที่ใช้ใน LAB (ฐานข้อมูล HR)

  • 3

    ประเภทของข้อมูล (Data types)

  • 4

    สรุปการเลือกใช้ประเภทข้อมูลใน 5 นาที

  • 5

    Lab Playground- Aggregate function

  • 6

    Tuition Playground

  • 7

    Ag#12 Playground

  • 8

    Database Design Tool Link

  • 9

    Conceptual ER Tool: Playlist

  • 10

    ER tool manual

  • 11

    Logical Design Tool: example

Chapter Introduction   

  • 1

    Introduction-IT

  • 2

    Introduction - DSBA

Chapter LAB 1 - Creating and Managing Tables (Data Definition Language)   

  • 1

    Slide : LAB 1 - DDL

  • 2

    Clip video-LAB 1 - DDL part 1

  • 3

    Clip video - LAB 2 - Constraints-part 1

  • 4

    Clip video LAB 1 - DDL part 2

Chapter LAB 2 - DDL - Including constraints   

  • 1

    Slide - LAB 2- DDL - Including constraints

  • 2

    Clip video - LAB 2 - Constraints-part 2

Chapter LAB 3-Data Manipulation Language (DML)   

  • 1

    Slide - LAB 3 - Manipulating data

  • 2

    Clip video - LAB 3 - DML - part 1

  • 3

    Clip video - LAB 3 - DML - part 2

Chapter LAB 4 - Basic SQL SELECT Statements   

  • 1

    Slide LAB 4 - SELECT Statements

  • 2

    Clip video - LAB 4 - Basic SQL statement 1

  • 3

    Clip video - LAB 4 - Basic SQL statement 2

  • 4

    Clip video LAB 4 - SQL (Order by)

Chapter LAB 5 - SQL Statement for Limiting data   

  • 1

    Slide LAB 5 - SQL Statement with conditions

  • 2

    Clip video LAB 5 - Select Statement with condition 1

  • 3

    Clip video LAB 5 - Select Statement with condition 2

Chapter LAB 6-Displaying Data from Multiple Tables (JOIN)   

  • 1

    Slide LAB 6 - JOIN

  • 2

    Clip video - LAB 6- JOIN- part 1

  • 3

    Clip video - LAB 6 - JOIN - part 2

Chapter LAB 7 - OUTER JOIN   

  • 1

    Slide - LAB 7 - Outer Join

  • 2

    Clip video - LAB 7 - Outer Join

Chapter LAB 8 - Aggregate Function   

  • 1

    Slide - LAB 8- Aggregate Function

  • 2

    Clip video -LAB 8- Aggregate function- Part 1

  • 3

    Clip video-LAB 8- Aggregate function- Part 2

Chapter LAB 9- Subqueries   

  • 1

    Slide LAB 9- Subqueries

  • 2

    Clip video - LAB 9- Subqueries - Part 1

  • 3

    Clip video - LAB 9- Subqueries- Part 2

Section 1

  • No Practice Available

Section 2

  • No Practice Available

Section 3

  • No Practice Available

Section 4

  • 2664

    2568-LAB01-DDL-Creating and managing tables

  • 2672

    2568-LAB02-DDL-Including constraints

  • 2716

    2568-LAB 3 -Data Manipulation Language

  • 2728

    2568-LAB 4-SQL SELECT

  • 2732

    2568-LAB05-SQL SELECT CONDITION

  • 2684

    2568-LAB06-SQL JOIN

  • 2692

    2568-LAB07-SQL OUTER JOIN

  • 2700

    2568-LAB08-SQL AGGREGATE FUNCTION

  • 2708

    2568-LAB09-SQL SUBQUERIES

Section 5

  • 2665

    2568-LAB01-DDL-Creating and managing tables

  • 2673

    2568-LAB02-DDL-Including constraints

  • 2717

    2568-LAB 3 -Data Manipulation Language

  • 2729

    2568-LAB 4-SQL SELECT

  • 2733

    2568-LAB05-SQL SELECT CONDITION

  • 2685

    2568-LAB06-SQL JOIN

  • 2693

    2568-LAB07-SQL OUTER JOIN

  • 2701

    2568-LAB08-SQL AGGREGATE FUNCTION

  • 2709

    2568-LAB09-SQL SUBQUERIES

Section 6

  • 2666

    2568-LAB01-DDL-Creating and managing tables

  • 2674

    2568-LAB02-DDL-Including constraints

  • 2718

    2568-LAB 3 -Data Manipulation Language

  • 2730

    2568-LAB 4-SQL SELECT

  • 2734

    2568-LAB05-SQL SELECT CONDITION

  • 2686

    2568-LAB06-SQL JOIN

  • 2694

    2568-LAB07-SQL OUTER JOIN

  • 2702

    2568-LAB08-SQL AGGREGATE FUNCTION

  • 2710

    2568-LAB09-SQL SUBQUERIES

Section 12

  • 2667

    2568-LAB01-DDL-Creating and managing tables

  • 2675

    2568-LAB02-DDL-Including constraints

  • 2719

    2568-LAB 3 -Data Manipulation Language

  • 2731

    2568-LAB 4-SQL SELECT

  • 2735

    2568-LAB05-SQL SELECT CONDITION

  • 2687

    2568-LAB06-SQL JOIN

  • 2695

    2568-LAB07-SQL OUTER JOIN

  • 2703

    2568-LAB08-SQL AGGREGATE FUNCTION

  • 2711

    2568-LAB09-SQL SUBQUERIES

Section 1

  • No Assignment Available

Section 2

  • No Assignment Available

Section 3

  • No Assignment Available

Section 4

  • 2668

    2568-LAB01-DDL-Creating and managing tables

  • 2676

    2568-LAB02-DDL-Including constraints

  • 2720

    2568-LAB03-Data Manipulation Language

  • 2724

    2568-LAB04-SQL SELECT

  • 2680

    2568-LAB05-SQL SELECT CONDITION

  • 2688

    2568-LAB06-SQL JOIN

  • 2696

    2568-LAB07-SQL OUTER JOIN

  • 2704

    2568-LAB08-SQL AGGREGATE FUNCTION

  • 2712

    2568-LAB09-SQL SUBQUERIES

Section 5

  • 2669

    2568-LAB01-DDL-Creating and managing tables

  • 2677

    2568-LAB02-DDL-Including constraints

  • 2721

    2568-LAB03-Data Manipulation Language

  • 2725

    2568-LAB04-SQL SELECT

  • 2681

    2568-LAB05-SQL SELECT CONDITION

  • 2689

    2568-LAB06-SQL JOIN

  • 2697

    2568-LAB07-SQL OUTER JOIN

  • 2705

    2568-LAB08-SQL AGGREGATE FUNCTION

  • 2713

    2568-LAB09-SQL SUBQUERIES

Section 6

  • 2670

    2568-LAB01-DDL-Creating and managing tables

  • 2678

    2568-LAB02-DDL-Including constraints

  • 2722

    2568-LAB03-Data Manipulation Language

  • 2726

    2568-LAB04-SQL SELECT

  • 2682

    2568-LAB05-SQL SELECT CONDITION

  • 2690

    2568-LAB06-SQL JOIN

  • 2698

    2568-LAB07-SQL OUTER JOIN

  • 2706

    2568-LAB08-SQL AGGREGATE FUNCTION

  • 2714

    2568-LAB09-SQL SUBQUERIES

Section 12

  • 2671

    2568-LAB01-DDL-Creating and managing tables

  • 2679

    2568-LAB02-DDL-Including constraints

  • 2723

    2568-LAB03-Data Manipulation Language

  • 2727

    2568-LAB04-SQL SELECT

  • 2683

    2568-LAB05-SQL SELECT CONDITION

  • 2691

    2568-LAB06-SQL JOIN

  • 2699

    2568-LAB07-SQL OUTER JOIN

  • 2707

    2568-LAB08-SQL AGGREGATE FUNCTION

  • 2715

    2568-LAB09-SQL SUBQUERIES

Section 1

  • No Quiz Available

Section 2

  • No Quiz Available

Section 3

  • No Quiz Available

Section 4

  • No Quiz Available

Section 5

  • No Quiz Available

Section 6

  • No Quiz Available

Section 12

  • No Quiz Available

248 Members applied