Database

Ievads:

01.07 Ceturdiena

Database

• database : 
• database server : 
• connector : 
• DBMS : 
• SQL : 
• sqlite : 
• MySQL : 

1. Datu kopas ar struktūru
2. Serveris...
3. Nezinu
4. Datu bāzu MS - īsti nezinu
5. Structured Query Language
6. Nezinu
7. Nezinu

SQLite

DBeaver

Database: 2

Iepazīties ar to struktūru

02.07 Piekdiena

no chinook.db

https://miro.com/app/board/o9J_l88BykE=/

Database: 3

SQLite to MySQL

05.07 Pirmdiena

https://miro.com/app/board/o9J_l88BykE=/

Introduction to MySQL

• SQLite to MYSQL (Tables and connection only)
• From SQLite (chinook.db) took .schema
• Used MS Excel to convert correct syntax
• Entered the sequence with reference to the existing tables