Relational Databases And PostgreSQL

Course Description

Every app in the world needs to store information in a database. Although there are many different databases you can use, PostgreSQL has been a number-one pick for decades, offering scalable performance, rock-solid uptime, and flexible design systems. This course will teach you everything you need to know about PostgreSQL to use it on your next big project!

Content

1. Introduction
2. Retrieve data using select statement
3. Data filter in select
4. Data exploration using select
5. Joins
6. Set Operators
7. Aggregate function
8. Group Data
9. Build compress quieries
10. String and number builtin functions
11. Date and time built in functions
12. Datatype conversion builtin functions
13. Sub-query
14. DML Operations