06066300 DATABASE SYSTEM CONCEPT 2567

Home / Class / DATABASE SYSTEM CONCEPT 2567

Course Code

06066300

Open Date

June 24th 2024 00:00

Close Date

November 10th 2024 00:00

Instructor


TA

Tag

SQL , Normalizaton , DBMS , Entity Relationship Model , 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

  • 2552

    2567-LAB01-DDL-Creating and managing tables

  • 2560

    2567-LAB02-DDL-Including constraints

  • 2613

    2567-LAB 3 -Data Manipulation Language

  • 2626

    2567-LAB 4-SQL SELECT

  • 2631

    2567-LAB05-SQL SELECT CONDITION

  • 2573

    2567-LAB06-SQL JOIN

  • 2583

    2567-LAB07-SQL OUTER JOIN

  • 2593

    2567-LAB08-SQL AGGREGATE FUNCTION

  • 2603

    2567-LAB09-SQL SUBQUERIES

Section 5

  • 2553

    2567-LAB01-DDL-Creating and managing tables

  • 2561

    2567-LAB02-DDL-Including constraints

  • 2614

    2567-LAB 3 -Data Manipulation Language

  • 2627

    2567-LAB 4-SQL SELECT

  • 2632

    2567-LAB05-SQL SELECT CONDITION

  • 2574

    2567-LAB06-SQL JOIN

  • 2584

    2567-LAB07-SQL OUTER JOIN

  • 2594

    2567-LAB08-SQL AGGREGATE FUNCTION

  • 2604

    2567-LAB09-SQL SUBQUERIES

Section 6

  • 2554

    2567-LAB01-DDL-Creating and managing tables

  • 2562

    2567-LAB02-DDL-Including constraints

  • 2615

    2567-LAB 3 -Data Manipulation Language

  • 2628

    2567-LAB 4-SQL SELECT

  • 2633

    2567-LAB05-SQL SELECT CONDITION

  • 2575

    2567-LAB06-SQL JOIN

  • 2585

    2567-LAB07-SQL OUTER JOIN

  • 2595

    2567-LAB08-SQL AGGREGATE FUNCTION

  • 2605

    2567-LAB09-SQL SUBQUERIES

Section 12

  • 2555

    2567-LAB01-DDL-Creating and managing tables

  • 2563

    2567-LAB02-DDL-Including constraints

  • 2616

    2567-LAB 3 -Data Manipulation Language

  • 2629

    2567-LAB 4-SQL SELECT

  • 2634

    2567-LAB05-SQL SELECT CONDITION

  • 2576

    2567-LAB06-SQL JOIN

  • 2586

    2567-LAB07-SQL OUTER JOIN

  • 2596

    2567-LAB08-SQL AGGREGATE FUNCTION

  • 2606

    2567-LAB09-SQL SUBQUERIES

Section 1

  • No Assignment Available

Section 2

  • No Assignment Available

Section 3

  • No Assignment Available

Section 4

  • 2556

    2567-LAB01-DDL-Creating and managing tables

  • 2564

    2567-LAB02-DDL-Including constraints

  • 2617

    2567-LAB03-Data Manipulation Language

  • 2621

    2567-LAB04-SQL SELECT

  • 2568

    2567-LAB05-SQL SELECT CONDITION

  • 2578

    2567-LAB06-SQL JOIN

  • 2588

    2567-LAB07-SQL OUTER JOIN

  • 2598

    2567-LAB08-SQL AGGREGATE FUNCTION

  • 2608

    2567-LAB09-SQL SUBQUERIES

Section 5

  • 2557

    2567-LAB01-DDL-Creating and managing tables

  • 2565

    2567-LAB02-DDL-Including constraints

  • 2618

    2567-LAB03-Data Manipulation Language

  • 2622

    2567-LAB04-SQL SELECT

  • 2569

    2567-LAB05-SQL SELECT CONDITION

  • 2579

    2567-LAB06-SQL JOIN

  • 2589

    2567-LAB07-SQL OUTER JOIN

  • 2599

    2567-LAB08-SQL AGGREGATE FUNCTION

  • 2609

    2567-LAB09-SQL SUBQUERIES

Section 6

  • 2558

    2567-LAB01-DDL-Creating and managing tables

  • 2566

    2567-LAB02-DDL-Including constraints

  • 2619

    2567-LAB03-Data Manipulation Language

  • 2623

    2567-LAB04-SQL SELECT

  • 2570

    2567-LAB05-SQL SELECT CONDITION

  • 2580

    2567-LAB06-SQL JOIN

  • 2590

    2567-LAB07-SQL OUTER JOIN

  • 2600

    2567-LAB08-SQL AGGREGATE FUNCTION

  • 2610

    2567-LAB09-SQL SUBQUERIES

Section 12

  • 2559

    2567-LAB01-DDL-Creating and managing tables

  • 2567

    2567-LAB02-DDL-Including constraints

  • 2620

    2567-LAB03-Data Manipulation Language

  • 2624

    2567-LAB04-SQL SELECT

  • 2571

    2567-LAB05-SQL SELECT CONDITION

  • 2581

    2567-LAB06-SQL JOIN

  • 2591

    2567-LAB07-SQL OUTER JOIN

  • 2601

    2567-LAB08-SQL AGGREGATE FUNCTION

  • 2611

    2567-LAB09-SQL SUBQUERIES

Section 1

  • No Quiz Available

Section 2

  • No Quiz Available

Section 3

  • No Quiz Available

Section 4

  • 2660

    2567-Sec4-Quiz-2

Section 5

  • 2659

    2567-Sec5-2

Section 6

  • 2657

    2567-Sec6-2

Section 12

  • 2662

    2567-Sec12-Quiz-2

281 Members applied