Description
In general terms, a database is a service running alongside your application software that allows your code to save, search, and modify information that will survive past a single run (or session, or instance, or application). This track provides a broad overview of concepts common to all databases, using two particular widely-used database engines -- PostgreSQL and MongoDB -- for illustration and practical examples of relational (SQL) and document (NoSQL) DBs.
Goals
The student will learn...
- the general history of databases
- the relational database model
- the "NoSQL" document database model
Topics
Application-Vs-Integration-DatabasesBlobCallbacksCollectionConnectionCreateCrudDatabasesDeleteDocumentDocument-DatabaseIndexJoinMongodbMongodb-QueriesMongodb-ShellPrimary-KeyQuery-SearchReadRecordSchemaServersShardingTil-AppTransactionUpdate