2024-04-05 Datubāzes

[Rozkalns]

MySQL Resurss w3schools

1. https://www.w3schools.com/mysql/default.asp

Uzdevums:

https://docs.google.com/presentation/d/1qU8AAPDR6tXaSrG-jOD7sXCQzM4-GW1aveU0zrtwYbE/edit?usp=sharing

Papildu resursi

• Datubāzes dizaineris: https://www.dbdesigner.net/
  • https://erd.dbdesigner.net/designer/schema/13959-web-application
  • https://erd.dbdesigner.net/designer/schema/1481807604-library-system
• PHPMyAdmin Izmēģinājums (bez docker): https://www.phpmyadmin.net/try/

https://www.db-fiddle.com/f/4ZAfF8saetftm2o8Q8yfFw/0

group by, sum = https://www.db-fiddle.com/f/4ZAfF8saetftm2o8Q8yfFw/1

https://www.db-fiddle.com/f/8LBcg37b7qLAGVDWw8h9fR/0

RPG datubāze:
piemērs - inventory: https://www.db-fiddle.com/f/8LBcg37b7qLAGVDWw8h9fR/2