Database Design & Development

The goal of this track is to learn how to create databases using PostgreSQL. Much of the internet is the flow of information and databases, like PostgreSQL, store data so that it can be displayed on the web. After this track, you will be able to: Be able to explain what a database isDifferentiate the differences between a SQL and a NoSQL databaseCreate and manipulate a PostgreSQL tableDownload PostgreSQL and run a SQL database on your computerCreate, update, and delete data in a SQL databaseWrite SQL queriesPerform SQL calculationsWork with multiple tablesUse techniques for designing relational databasesRead and design Entity Relationship Diagrams (ERDs)Imagine data needs of famous sites - how might their databases be designed