Database Technology
A working wiki for the term. Assignments and their write-ups, weekly dev logs tracking what broke and what didn't, discussion blogs unpacking the readings, mock interviews against real questions, and the integrations stitching the course project together.
Course summary
Covers intermediate programming in an SQL relational database. Provides an introduction to non-relational databases as used in Cloud Computing and Big Data. The RDMS topics include views, models, stored procedures, triggers, indexing, JOINs and abstraction techniques, query construct efficiency. Introduction to noSQL databases: uses, terminology, indexing, storage, compute consumption, compression, and reliability.
The work happens in two parallel tracks. One is conceptual: readings, discussion posts, and interview-style questions to sharpen vocabulary and intuition. The other is practical: a term-long project that begins with an entity model on paper and ends with a working application backed by a real database, deployed and queryable.
Present and effectively communicate complex technical concepts and constraints to a wide range of technical and non-technical stakeholders. Research trends in software development and acquire and integrate new skills and knowledge to keep abreast of changes within the software development profession.
Jump in
Assignments
Weekly deliverables and their write-ups
Dev Logs
What broke this week and what fixed it
Discussion Blogs
Long-form posts unpacking the readings
Mock Interviews
Database questions and worked answers
Integrations
The tools and services stitched together
Practicum
Professional updates and progress reports