PostgreSQL Crash Course (2023)

What is PostgreSQL ?

1. PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads.

2. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

Why to use PostgreSQL ?

1. PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset.

2. In addition to being free and open source, PostgreSQL is highly extensible.

3. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database!

Why to choose this Course ?

In this course you will learn wide range of SQL techniques, beyond basic CRUD (Create, Read, Update, and Delete) operations in PostgreSQL. You will learn the specifics of aggregation, transactions, reading and parsing CSV files and inserting data into a database.

Also you will learn more about the historical design of databases and the use of SQL in the PostgreSQL environment. Using SQL techniques and common commands (INSERT INTO, WHERE, ORDER BY, ON DELETE CASCADE, etc.) will enable you to create tables, column types and define the schema of your data in PostgreSQL. You will learn about data modeling and how to represent one-to-many and many-to-many relationships in PostgreSQL. Course contains some interesting quizzes on basis of PostgreSQL concepts like creating tables, inserting data, designing data models, creating relational structures and inserting and querying relational data in tables.

Enjoy the course !