VOLUME 1 · CHAPTER 04
Database
Take one idea at a time. Your next lesson starts here.
In this chapter
LESSONS- 011-1 Difference Between Database and File
- 021-2-1 Data Model
- 031-2-2 Relational Model
- 041-2-3 Conceptual Design of Databases
- 051-2-4 Logical Design of Databases
- 061-2-5 Physical Design of Databases
- 071-3-1 Database Definition Function
- 081-3-2 Database Manipulation Function
- 091-3-3 Database Control Function
- 102-1-1 Definition of Database
- 112-1-2 Definition of Tables
- 122-1-3 Definition of View
- 132-1-4 Definition of Access Right
- 142-1-5 Data Storage
- 152-2-1 Reference Without Specifying Conditions
- 162-2-2 Reference With Specifying Conditions
- 172-2-3 Grouping of Data
- 182-2-4 Sorting of Data
- 192-2-5 Joining the Tables
- 202-2-6 Sub Reference (Subquery)
- 212-2-7 Other Methods of Using SQL
- 223-1 Distributed Database
- 233-2 Data Warehouse
- 243-3 Other Related Techniques
PUT IT INTO PRACTICE
Original chapter exercises
12 exercises to revisit what you’ve learned.