06066300 DATABASE SYSTEM CONCEPT 2566

Home / Class / DATABASE SYSTEM CONCEPT 2566

Course Code

06066300

Open Date

September 30th 2023 00:00

Close Date

October 14th 2023 00:00

Instructor


TA

Tag

SQL , Normalizaton , DBMS , Entity Relationship Model , Database Logical Design

Chapter sadmin   

  • 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

  • 12

    Untitled Topic

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 1 - DDL part 2

Chapter LAB 2 - DDL - Including constraints   

  • 1

    Slide - LAB 2- DDL - Including constraints

  • 2

    Clip video - LAB 2 - Constraints-part 1

  • 3

    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 - Group Function   

  • 1

    Slide - LAB 8- Group By Function

  • 2

    Clip video -LAB 8- Group function- Part 1

  • 3

    Clip video-LAB 8- Group 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

Chapter sadmin   

  • 1

    Untitled Topic

Section 1

  • No Practice Available

Section 2

  • No Practice Available

Section 3

  • No Practice Available

Section 4

  • 2269

    2566-LAB01-DDL-Creating and managing tables

  • 2275

    2566-LAB02-DDL-Including constraints

  • 2308

    2566-LAB 3 -Data Manipulation Language

  • 2317

    2566-LAB 4-SQL SELECT

  • 2320

    2566-LAB05-SQL SELECT CONDITION

  • 2284

    2566-LAB06-SQL JOIN

  • 2290

    2566-LAB07-SQL OUTER JOIN

  • 2296

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2302

    2566-LAB09-SQL SUBQUERIES

Section 5

  • 2270

    2566-LAB01-DDL-Creating and managing tables

  • 2276

    2566-LAB02-DDL-Including constraints

  • 2309

    2566-LAB 3 -Data Manipulation Language

  • 2318

    2566-LAB 4-SQL SELECT

  • 2321

    2566-LAB05-SQL SELECT CONDITION

  • 2285

    2566-LAB06-SQL JOIN

  • 2291

    2566-LAB07-SQL OUTER JOIN

  • 2297

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2303

    2566-LAB09-SQL SUBQUERIES

Section 6

  • 2271

    2566-LAB01-DDL-Creating and managing tables

  • 2277

    2566-LAB02-DDL-Including constraints

  • 2310

    2566-LAB 3 -Data Manipulation Language

  • 2319

    2566-LAB 4-SQL SELECT

  • 2322

    2566-LAB05-SQL SELECT CONDITION

  • 2286

    2566-LAB06-SQL JOIN

  • 2292

    2566-LAB07-SQL OUTER JOIN

  • 2298

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2304

    2566-LAB09-SQL SUBQUERIES

Section 12

  • 2325

    2566-LAB01-DDL-Creating and managing tables

  • 2326

    2566-LAB02-DDL-Including constraints

  • 2327

    2566-LAB 3 -Data Manipulation Language

  • 2328

    2566-LAB 4-SQL SELECT

  • 2329

    2566-LAB05-SQL SELECT CONDITION

  • 2330

    2566-LAB06-SQL JOIN

  • 2331

    2566-LAB07-SQL OUTER JOIN

  • 2332

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2333

    2566-LAB09-SQL SUBQUERIES

Section 11

  • No Practice Available

Section 8

  • 2353

    2566-LAB 4-SQL SELECT

  • 2354

    2566-LAB05-SQL SELECT CONDITION

  • 2355

    2566-LAB06-SQL JOIN

  • 2356

    2566-LAB07-SQL OUTER JOIN

  • 2357

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2358

    2566-LAB09-SQL SUBQUERIES

Section 1

  • No Assignment Available

Section 2

  • No Assignment Available

Section 3

  • No Assignment Available

Section 4

  • 2272

    2566-LAB01-DDL-Creating and managing tables

  • 2278

    2566-LAB02-DDL-Including constraints

  • 2311

    2566-LAB03-Data Manipulation Language

  • 2314

    2566-LAB04-SQL SELECT

  • 2281

    2566-LAB05-SQL SELECT CONDITION

  • 2287

    2566-LAB06-SQL JOIN

  • 2293

    2566-LAB07-SQL OUTER JOIN

  • 2299

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2305

    2566-LAB09-SQL SUBQUERIES

Section 5

  • 2273

    2566-LAB01-DDL-Creating and managing tables

  • 2279

    2566-LAB02-DDL-Including constraints

  • 2312

    2566-LAB03-Data Manipulation Language

  • 2315

    2566-LAB04-SQL SELECT

  • 2282

    2566-LAB05-SQL SELECT CONDITION

  • 2288

    2566-LAB06-SQL JOIN

  • 2294

    2566-LAB07-SQL OUTER JOIN

  • 2300

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2306

    2566-LAB09-SQL SUBQUERIES

Section 6

  • 2274

    2566-LAB01-DDL-Creating and managing tables

  • 2280

    2566-LAB02-DDL-Including constraints

  • 2313

    2566-LAB03-Data Manipulation Language

  • 2316

    2566-LAB04-SQL SELECT

  • 2283

    2566-LAB05-SQL SELECT CONDITION

  • 2289

    2566-LAB06-SQL JOIN

  • 2295

    2566-LAB07-SQL OUTER JOIN

  • 2301

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2307

    2566-LAB09-SQL SUBQUERIES

Section 12

  • 2334

    2566-LAB02-DDL-Including constraints

  • 2324

    2566-LAB01-DDL-Creating and managing tables

  • 2335

    2566-LAB03-Data Manipulation Language

  • 2336

    2566-LAB04-SQL SELECT

  • 2337

    2566-LAB05-SQL SELECT CONDITION

  • 2338

    2566-LAB06-SQL JOIN

  • 2339

    2566-LAB07-SQL OUTER JOIN

  • 2340

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2341

    2566-LAB09-SQL SUBQUERIES

Section 11

  • No Assignment Available

Section 8

  • 2359

    2566-LAB04-SQL SELECT

  • 2360

    2566-LAB05-SQL SELECT CONDITION

  • 2361

    2566-LAB06-SQL JOIN

  • 2362

    2566-LAB07-SQL OUTER JOIN

  • 2363

    2566-LAB08-SQL AGGREGATE FUNCTION

  • 2364

    2566-LAB09-SQL SUBQUERIES

Section 1

  • No Quiz Available

Section 2

  • No Quiz Available

Section 3

  • No Quiz Available

Section 4

  • 2367

    Quiz 1-SEC 4

  • 2374

    Quiz 2 - Sec 4

Section 5

  • 2373

    Quiz2_sec5_66

  • 2352

    Quiz 1 - sec 5 - 66

Section 6

  • 2368

    Quiz 1 Sec 6

  • 2382

    Quiz 2 Sec 6

Section 12

  • 2366

    Quiz 1 - Sec 12

  • 2375

    Quiz 2 - Sec 12

Section 11

  • No Quiz Available

Section 8

  • No Quiz Available

235 Members applied