Contents
Chapter 4 · DatabasePractice

LEARN WITH HARU

Video Lesson တွေက Haru အတန်းသားတွေအတွက်ပါ

Haru ရဲ့ ITPEC FE Full Course မှာ ယခု သင်ခန်းစာတွေကို တစ်ခုချင်း တစ်ကြောင်းချင်း အသေးစိတ်ရှင််ရှင်းပြထားပါတယ်

အခြေခံ မရှိတဲ့ ကျောင်းသားများစွာဟာလည်း ဒီ Course နဲ့ ပဲ အောင်မြင်ကုန်ကြပါပြီ

အတန်းမအပ်သေးပဲ Haru ဆီမှာ အစမ်းသင်ကြည့်ချင်ပါသလား?

သင်တန်းသားတွေရဲ့ စကားသံများ

သင်တန်းသားတွေရဲ့ စကားသံများ
Practice related questions (7)Progress & bookmarks

Current section

2 SQL

p. 262

Practice this section 7 linked exam questions with default filters

Progress

Not marked complete

Progress and bookmarks

p. 262

2 SQL

SQL (Structured Query Language) is a database language for using a relational database. SQL consists of DDL (Data Definition Language) that defines data, DML (Data Manipulation Language) that operates data, and others. The basic method of using SQL is explained with the following tables.

Original reference database for the SQL examples: Student has four rows and StudentNumber/Name/Gender; Subject has K11 English I, K12 English II and K21 Mathematics; Score has six dated examination rows. Original primary-key underlines, field types and the adjacent primary-key note remain attached. Source text: <Student> <Subject> StudentNumber Name Gender SubjectNumber SubjectName Kazuki 6724 Male K11 English I Yamamoto Jyugo 6725 Male K12 English II Motoyama Mone 6816 Female K21 Mathematics Yamada Chiyo Alphanumeric Alphabetical 6817 Female Yamamoto characters characters Alphanumeric Alphabetical Alphabetical characters characters characters <Score> StudentNumber SubjectNumber Score ExaminationDate 6724 K11 65 20XX-10-20 6724 K21 85 20XX-10-21 6725 K21 60 20XX-10-21 Note: 6817 K11 85 20XX-10-20 Fields underlined 6817 K12 90 20XX-10-20 in each table show 6817 K21 95 20XX-10-21 the primary key. Alphanumeric Alphanumeric Integer Date characters characters
p. 262 · Enlarge

2 - 1 Data Definition

Data definition refers to defining the database, table (i.e., base table), view (i.e., virtual table), and so on.

p. 263

2-1-1 Definition of Database

CREATE DATABASE statement is used for defining database.

Original textbook table, example or syntax box, with its complete original layout. Source text: CREATE DATABASE name
p. 263 · Enlarge

ex01: Define the database “PerformanceManagementDB”.

Original SQL worked example with its complete source code, indentation, punctuation, source frame and any attached original notes. Source text: CREATE DATABASE PerformanceManagementDB
p. 263 · Enlarge

Section progress

Original chapter exercises

Original chapter exercises →

New FE Textbook Vol.1 · IT Fundamentals · First Edition, April 2015