Reinaldo Perez, Databases 2 Weeks

[perezrei]

perezrei/databases

Study Plan

• SQLite Viewer
• SQLite Node.js
• Node-SQLite3

Week 1

• started the exercises

Check-In

I Need Help With:

Nothing, Wednesday's Q&A call answered my questions

What went well?

The exercises. I enjoy databases exercises

What went less well?

Nothing particularly

Lessons Learned

• Concepts about information systems, databases, RDMBs, relational models, tables, records, attributes, fields and keys
• SQLite Viewer, navigate a SQLite database
• Basic SQL queries: SELECT, ORDER BY, SELECT DISTINCT, WHERE, LIMIT, BETWEEN, LIKE, GROUP BY
• Communicate with SQLite databases in JavaScript with sqlite3

Sunday Prep Work

• Learn about primary keys, foreign keys, relationships and SQL injection
• Learn how to write SQL queries to read data using: JOIN
• Learn how to write basic SQL queries to create, update and delete records and tables using the following statements: INSERT, UPDATE, DELETE, CREATE TABLE, ALTER TABLE, DROP TABLE