Databases – SQL (PostgreSQL)
3 Week Part-Time Course
Learn how to:
Understand the difference between SQL and NoSQL databases and what they’re used for
Create and use PostgreSQL as a database for CRUD based operations
Plan the next steps in your learning path to become a better database or application developer
Learn introductory SQL skills with PostgreSQL, and understand basic database design concepts which can lead to many paths in the world of technology and development.
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
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
- What is CRUD?
- What is a relational database?
- Let’s query some data!
- Entities and Attributes
- Tables and Fields
- Create an Entity Relationship Diagram (ERD)
- Create the table structure
- Populate our tables with some data
- Explore Join statements
- JOIN, WHERE, LIKE, AS and a lot more
- Sort some records
- Insert and Delete table columns
- Update, Delete, and Insert table data
- Creating Stored Procedures
- Exploring security benefits
- Temp tables
How It Works
Participate from the comfort of your own home
Expert-Led Live Training
Learn from seasoned developers who love to teach
Learn by Doing
Create real-wold projects you’re proud to share
Skip the application process! All students admitted
Interactive Virtual Classroom
Stay engaged with our ask-a-question and messaging features
Never Miss A Class
All classes are recorded for easy playback