codepedia.de
HTML
CSS
Javascript
  • Javascript
  • JS for Web
  • JQuery
  • Async JS
Backend
  • Basics
  • Node
  • Express
  • Connect DB to Node
GIT
Databases
  • Basics
  • SQL
  • No SQL
Vue
  • Vue
  • Vue Router
  • Vue-State-Management
  • Vite
  • Quasar
  • Nuxt
  • Vue Animation
  • VuePress (opens new window)
Misc.
  • Command Line
  • VS Code
  • Jetbrains IntelliJ
  • Markdown
  • Design
  • Performance
  • Clean Code
  • Fake API
  • SSH
About/Imprint
HTML
CSS
Javascript
  • Javascript
  • JS for Web
  • JQuery
  • Async JS
Backend
  • Basics
  • Node
  • Express
  • Connect DB to Node
GIT
Databases
  • Basics
  • SQL
  • No SQL
Vue
  • Vue
  • Vue Router
  • Vue-State-Management
  • Vite
  • Quasar
  • Nuxt
  • Vue Animation
  • VuePress (opens new window)
Misc.
  • Command Line
  • VS Code
  • Jetbrains IntelliJ
  • Markdown
  • Design
  • Performance
  • Clean Code
  • Fake API
  • SSH
About/Imprint
  • SQL Databases

    • SQL Overview
    • SQL Databases
    • SQL Tables
    • SQL Create
    • SQL Read
    • SQL Aggregate Functions
    • SQL Conditional Statements
    • SQL Constraints
    • SQL Update
    • SQL Delete
    • SQL Operators
    • SQL Relations
    • Database Modelling
    • SQL Multiple Tables
    • SQL Joins
    • Manage SQL-DB
    • Designing Relational Databases
    • SQL Commands Reference
    • SQL w3 Database Handling
    • SQL Links

    # SQL Links

    • Handout - Databases.pdf

    • https://www.sachsen.schule/~terra2014/sql_abfragen.php (opens new window)

    • SELEECT basics (opens new window)

    • MariaDB Knowledge Base (opens new window)

    • W3schoolSQLtutorial (opens new window)

    MariaDB Foreign Key tutorial (opens new window)

    • ERDiagramsYoutubetutorial (opens new window)

    • JoiningTables (opens new window)

    • ModeAdvancedJoins (opens new window)

    • https://www.codecademy.com/articles/sql-commands (opens new window)

    https://www.w3schools.com/sql/default.asp (opens new window) -> great ressource

    SQLITE playground (opens new window)

    # w3 schools

    • MySQL Data Types (opens new window)
    • MySQL Functions (opens new window)

    ← SQL w3 Database Handling