Before your first session, you need to set up PostgreSQL. Please follow the PostgreSQL setup guide first.
These are the topics for week 1:
- PostgreSQL setup guide to set up your PostgreSQL instance.
- Introduction to databases
- What is an information (system)?
- What are entities?
- What is a database?
- What is the role of a database in an application?
- Introduction to Structured Query Language (SQL)
- What are data types (as applied to databases)?
- How to use SQL to Create, Read, Update and Delete (CRUD)
- Using database dumps
- Career Training II (Interview preparation)
This week we want to introduce you to the world of databases! We will start with a general introduction of what databases are, go over some terms and explain how to start thinking about your application's data. Have a look at the introduction here.
In this module, we will be cover both the relational type of databases (SQL), as well as document based databases (NoSQL). For now you do not need to know the difference, that will become apparent when we have covered both. We will start by going into relational database by learning about SQL, which is the language used when interacting with most relational databases. Have a look here.
Lastly, let's go over some practical information that will allow you to save your databases and share it with others! Learn all about database dumps here. Note that PostgreSQL uses pg_dump and pg_restore instead of MySQL's mysqldump.
Finally, it is time to continue with developing your soft skills to ace those job interviews. For that, have a look at the interview preparation repo. It is a lot to get through, so you may need some time next week as well. There is an assignment for the career training next week, you can already have a look at it if you find these things difficult.
Are you done going through the materials? High five! If you feel ready to get practical, click here.