Astro Nano
Back to second brain
4 min read
bnf-101-base-informatiques

Related: [[./Bioinformatics Certificate at CNAM|Bioinformatics Certificate at CNAM]], [[../../../Bioinformatics & Computational Thinking|Bioinformatics & Computational Thinking]], [[../../../Bioinformatics Career Change|Bioinformatics Career Change]]

[!Summary] 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|Unix Commands - BNF101 Test 1]] [[../../../cheat-sheet-unix-commands|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|Topics to study for SQL/R exam]]

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

  • [[./3 fundamentals characteristics of a computer|3 fundamentals characteristics of a computer]]
  • [[./Buses and RAM work in computer architecture|Buses and RAM work in computer architecture]]
  • [[./Computers work based on Von Neumann Machine principles|Computers work based on Von Neumann Machine principles]]
  • [[./Homebrew is a package management system|Homebrew is a package management system]]
  • [[./basics of algorithms and pseudocode|basics of algorithms and pseudocode]]

HTML & CSS

  • [[./linking images and urls in html|linking images and urls in html]]
  • [[../../../Using divs and nested divs in css|Using divs and nested divs in css]]
  • [[./website forms via html|website forms via html]]

Database theory

  • [[../../../Database Management Systems (DBMS) and three-schema architecture|Database Management Systems (DBMS) and three-schema architecture]]
  • [[../../../MERISE Method of database design|MERISE Method of database design]]
    • [[../../../MCD = modele conceptual données|MCD = modele conceptual données]]
    • [[../../../cardinality-example-MCD|cardinality-example-MCD]]
    • [[../../../total participation vs partial participation|total participation vs partial participation]]
  • [[../../../formes normales - normal forms in database formalization|formes normales - normal forms in database formalization]]
  • [[../../../PRIMARY KEY vs FOREIGN KEY|PRIMARY KEY vs FOREIGN KEY]]

SQL/R

  • [[./Postgre SQL is an open source relational database system|Postgre SQL is an open source relational database system]]
    • [[../../../2024-10-22 SQL L2|starting postgresql/psql]]
    • [[../../../differences btwn oracle and postgres|differences btwn oracle and postgres]]
  • [[../../../COMMIT and ROLLBACK|COMMIT and ROLLBACK]]
  • [[how to link postgresql and r for analysis|how to link postgresql and r for analysis]]
  • [[../../../2024-09-16 Unix Lecture 1|2024-09-16 Unix Lecture 1]]
  • [[../../../2024-09-17 BDD Lecture 1|2024-09-17 BDD Lecture 1]]
  • [[../../../2024-09-23 Unix Lecture 2|2024-09-23 Unix Lecture 2]]
  • [[../../../2024-09-24 BDD Lecture 2|2024-09-24 BDD Lecture 2]]
  • [[../../../2024-09-30 Unix Lecture 3|2024-09-30 Unix Lecture 3]]
  • [[../../../2024-10-01 BDD Lecture 3|2024-10-01 BDD Lecture 3]]
  • [[../../../2024-10-07 Unix Lecture 4|2024-10-07 Unix Lecture 4]]
  • [[../../../2024-10-15 BDD Lecture 6|2024-10-15 BDD Lecture 6]]
  • [[../../../2024-10-22 SQL L2|2024-10-22 SQL L2]]
  • [[../../../2024-10-29 SQL L3|2024-10-29 SQL L3]]
  • [[../../../2024-11-12 SQL L5|2024-11-12 SQL L5]]
  • [[../../../2024-12-03 BDD + R - session 1|2024-12-03 BDD + R - session 1]]
  • [[../../../2024-12-10 BDD + R - session 2|2024-12-10 BDD + R - session 2]]
  • [[../../../2024-12-17 BDD + R - session 3|2024-12-17 BDD + R - session 3]]
  • [[../../../BDD Slides|BDD Slides]]
  • [[./Bioinformatics Certificate at CNAM|Bioinformatics Certificate at CNAM]]
  • [[../../../Cartesian Products and Inner Joins|Cartesian Products and Inner Joins]]
  • [[../../../CSS classes|CSS classes]]
  • [[../../../CSS Lecture 1|CSS Lecture 1]]
  • [[../../../CSS Lecture 2|CSS Lecture 2]]
  • [[../../../CSS Lecture 3|CSS Lecture 3]]
  • [[./database creation syntax and data fields|database creation syntax and data fields]]
  • [[../../../Diplôme d’ingénieur Génie biologique|Diplôme d’ingénieur Génie biologique]]
  • [[../../../HTML Lecture 1|HTML Lecture 1]]
  • [[../../../HTML Lecture 2|HTML Lecture 2]]
  • [[../../../HTML Lecture 3|HTML Lecture 3]]
  • [[./linking images and urls in html|linking images and urls in html]]
  • [[./Programming MOC|Programming MOC]]
  • [[../../../quartz-to-do-note|quartz-to-do-note]]
  • [[../../../searching for proteins in a public database|searching for proteins in a public database]]
  • [[../../../Unix Commands - BNF101 Test 1|Unix Commands - BNF101 Test 1]]
  • [[./website forms via html|website forms via html]]

Other references

Unix Slides

[[../../../BDD Slides|BDD Slides]]