introduction database
TRANSCRIPT
![Page 1: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/1.jpg)
TEACHERS : INAD.227 & FHAD.214
Course name: introduction to database
Hour : 4
Course code: PRG 182
1
Unit :data processing using ‘SQL’
![Page 2: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/2.jpg)
Motivation
2
![Page 3: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/3.jpg)
Content:1. Moti vati on.2. Introducti on About database.3. History.4. Processing database by using MySQL : .• How to create a table in database?• How to insert data in the created table?• Showing data by using ‘ where(condition) ’ .
5. Summary.6. References.
3
![Page 4: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/4.jpg)
Database introduction
4
![Page 5: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/5.jpg)
user
5
![Page 6: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/6.jpg)
6
History
Dr. Edgar Frankl . Codd 1790
![Page 7: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/7.jpg)
How to create a table in database?ID name age
Department
Teachers
Students
DATABASE
7
![Page 8: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/8.jpg)
ID name age
227 Inad 30
217 Osama 12
How to insert data in the created table?
8
![Page 9: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/9.jpg)
showing data by using ‘ where(condition) ’
ID name age
227 Inad 30
217 Osama 12
The row
9
![Page 10: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/10.jpg)
Quiz
10
![Page 11: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/11.jpg)
The Summary
11
1. Introducti on About database.
2. History.
3. Processing database by using MySQL :
• How to create a table in database?
• How to insert data in the created table?
• Showing data by using ‘ where(condition) ’ .
![Page 12: introduction database](https://reader030.vdocuments.us/reader030/viewer/2022032620/55c5f9e8bb61eb1f078b45da/html5/thumbnails/12.jpg)
References • http://sqlzoo.net/wiki/Main_Page
• http://www.epa.gov/ttn/airs/airsaqs/training/SQL%20Basics.pdf
• Book name: Pro MySQL .Written by Jay Pipes،Michael Kruckenberg .ISBN 1-59059-505-X.
12