| |=--------------------------------------------------=| | |
| _________________ .____ ___________________ | |
| / _____/\_____ \ | | \_ _____/\______ \ | |
| \_____ \ / / \ \| | | __)_ | | \ | |
| / \/ \_/. \ |___ | \ | ` \ | |
| /_______ /\_____\ \_/_______ \/_______ //_______ / | |
| \/ \__> \/ \/ \/ | |
| |=--------------------------------------------------=| | |
| ; ; | |
| . Chapter 1 : SQL roots . | |
| . [|01.01 - DEDUCOM ] . | |
| . [|01.02 - Data-base Management Subsystem] . | |
| . . | |
| . Chapter 2 : Relation Database Management Systems . | |
| . [|02.01 - DBMS and Database Layers] . | |
| . [|02.02 - Data Dictionary] . | |
| . [|02.03 - SQL, DDL and DML] . | |
| . [|02.04 - Conceptual Model] . | |
| . [|02.05 - Semantic gap] . | |
| . [|02.06 - Query language] . | |
| , , | |
| . Chapter 3 : Hands-On SQL . | |
| . [|03.01 - SQLite Kernel For Jupyter] . | |
| . [|03.02 - Table Definition] . | |
| . [|03.03 - Rows inserting] . | |
| . [|03.04 - Querying the data I.] . | |
| . [|03.05 - Querying the data II.] . | |
| . [|03.06 - Querying the data III.] . | |
| . [|03.07 - Relations] . | |
| . [|03.08 - Joins] . | |
| . [|03.09 - Updating records] . | |
| . [|03.10 - Set operations] . | |
| , , | |
| |=--------------------------------------------------=| | |
| |=--------------------------------------------------=| | |
| ;| Thanks Linux and Vim | Visit https://sqlok.org |; | |
| |=--------------------------------------------------=| | |