In this course students will learn to build basic databases with PostgreSQL. They will also learn to use and manage data inside their database. They will learn to create, read, update and delete the data in a PostgreSQL table.
Students will create a basic database and populate it with data in order to access and manipulate it throughout the course.
Topics will include:
- NoSQL vs SQL
- SQL terminology
- Design considerations with SQL databases
- CRUD operations with SQL
- Backups and restores with MongoDB
Students will leave this course with an introductory level knowledge of database design and usage, particularly in regards to SQL. The knowledge gained in this course will be an excellent introduction to managing data in a full-stack application that utilizes any SQL type database.
The course content assumes knowledge of how to use the computer including installing software. No prior programming knowledge is required.
Students should have a smoothly running Windows, Mac, or Linux computer to use for the duration of the course.
By the end of the course students will:
- Create a PostgreSQL database and populate it with data
- Learn how to access and manipulate the data in their database
- Plan the next steps in their learning path to become a better database or application developer