Related: Bioinformatics Certificate at CNAM, Bioinformatics & Computational Thinking, 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 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 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
• Buses and RAM work in computer architecture
• Computers work based on Von Neumann Machine principles
• Homebrew is a package management system
• basics of algorithms and pseudocode

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
  • starting postgresql/psql
  • 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
• Bioinformatics Certificate at CNAM
• Cartesian Products and Inner Joins
• CSS classes
• CSS Lecture 1
• CSS Lecture 2
• CSS Lecture 3
• database creation syntax and data fields
• Diplôme d'ingénieur Génie biologique
• HTML Lecture 1
• HTML Lecture 2
• HTML Lecture 3
• linking images and urls in html
• Programming MOC
• quartz-to-do-note
• searching for proteins in a public database
• Unix Commands - BNF101 Test 1
• website forms via html

Other references

• bases de données relationnelles avec MERISE

Unix Slides

BDD Slides