Related: Bioinformatics Certificate at CNAM, Bioinformatics MOC, Bioinformatics Career Change
About
Lecture notes + their atomic notes from the BNF101: Base Informatiques et Bases de Données class I’m taking during Fall 2024 at CNAM.
Unix Commands - BNF101 Test 1
cheat-sheet-unix-commands
BDD - SQL/R
why SQL?
Quote
it’s incredibly useful mentally in the way it makes you understand data key relationships and what can go wrong with matching this-field-to-that-field. reddit
topics-to-study-sql-R
Concepts
These are atomic notes based on my personal lecture notes. This allows me to link information across lectures and courses, without making my raw notes public. :)
Computer science basics
HTML & CSS
- linking images and urls in html
- Using divs and nested divs in css
- website forms via html
Database theory
- Database Management Systems (DBMS) and three-schema architecture
- MERISE Method of database design
- MCD = modele conceptual données
- cardinality-example-MCD
- total participation vs partial participation
- formes normales - normal forms in database formalization
- PRIMARY KEY vs FOREIGN KEY
SQL/R
- Postgre SQL is an open source relational database system
- 2024-10-22 SQL L2
- differences btwn oracle and postgres
- COMMIT and ROLLBACK
- how to link postgresql and r for analysis
-
2024-09-16 Unix Lecture 1
-
2024-09-17 BDD Lecture 1
-
2024-09-23 Unix Lecture 2
-
2024-09-24 BDD Lecture 2
-
2024-09-30 Unix Lecture 3
-
2024-10-01 BDD Lecture 3
-
2024-10-07 Unix Lecture 4
-
2024-10-15 BDD Lecture 6
-
2024-10-22 SQL L2
-
2024-10-29 SQL L3
-
2024-11-12 SQL L5
-
2024-12-03 BDD + R - session 1
-
2024-12-10 BDD + R - session 2
-
2024-12-17 BDD + R - session 3
-
BDD Slides
-
CSS Lecture 1
-
CSS Lecture 2
-
CSS Lecture 3
-
HTML Lecture 1
-
HTML Lecture 2
-
HTML Lecture 3
-
quartz-to-do-note
-
Unix Commands - BNF101 Test 1