5.00
(1 Rating)

PostgreSQL

Categories: PostgreSQL, SQL
Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

PostgreSQL

PostgreSQL is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

PostgreSQL, also known as Postgres, is a free and open-source relational database management system emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley

Optimizing Storage and Managing Cleanup in PostgreSQL | by Harshit Dwivedi | Coding Blocks | Medium

What is PostgreSQL used for?
PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications. The latest major version is PostgreSQL 12.
IS It worth Learning ?
Yes it’s worth to learn postgres SQL. before starting to learn you need to learn some fundamental basis concepts in SQL like DDL ,DML , SP, etc etc. PostgreSQL is rapidly growing to become an alternative to Oracle DB. It’s the most preferred Open source database for heavy load data warehouse system.
Show More

Course Content

PostgreSQL For Everybody

  • Introduction
    00:00
  • Using PythonAnywhere to run SQL
    00:00
  • Using the DBeaver Client to Run SQL Commands
    00:00
  • PostgreSQL Musical Track Database (CSV)
    00:00
  • PostgreSQL Demonstration: Database Design and Many to Many
    00:00
  • PostgreSQL Demonstration: Creating and Loading a Database
    00:00
  • PostgreSQL Demonstration: SELECT DISTINCT
    00:00
  • PosgreSQL Demonstration: GROUP BY
    00:00
  • PostgreSQL Demonstration: Sub Query
    00:00
  • PostgreSQL Demonstration: Transactions
    00:00
  • PostgreSQL Demonstration: Stored Procedures
    00:00
  • PostgreSQL Demonstration: Loading and Normalizing CSV Data
    00:00
  • PostgreSQL Demonstration: Generating and Scanning Text
    00:00
  • PostgreSQL Demonstration: Regular Expressions
    00:00
  • PostgreSQL Demonstration: Flat files, Regular Expressions, Storing Email
    00:00
  • FullText 01 Blocks 1080
    00:00
  • FullText 02 Index 1080
    00:00
  • FullText 03 Invert SQL 1080
    00:00
  • Demonstration: 05 01 Inverted SQL edited
    00:00
  • FullText 04 Invert PG 1080
    00:00
  • Demonstration: 05 02 String GIN raw
    00:00
  • FullText 05 Natural SQL 1080
    00:00
  • Demonstration: 05 03 stop stem raw
    00:00
  • Lecture: 05 FullText 06 Natural PG 1080
    00:00
  • Demonstration: 05 04 fulltext functions raw
    00:00
  • Demonstration: 05 05 tsvector gin raw
    00:00
  • Lecture: PY-PG 06 01 Python 1080
    00:00
  • Demonstration: 06 01 simple raw
    00:00
  • Demonstration: Book 06 02 loadbook raw
    00:00
  • Lecture: Mail 06 02 Gmane
    00:00
  • Demonstration: Mail 1/3 06 03 gmane raw
    00:00
  • Demonstration: Mail 2/3 06 04 gmane edited
    00:00
  • Lecture: Ranking 06 03 Rank 1080
    00:00
  • Demonstration: Mail 3/3 06 05 gmane raw
    00:00
  • Lecture: JSON 06 04 JSON 1080
    00:00
  • Lecture: 06 05 JSON Python 1080
    00:00
  • Lecture: PG+JSONB 06 06 PostgreSQL JSON 1080
    00:00
  • Demonstration: Tracks 06 06 jsonb raw
    00:00
  • Lecture: 06 07 Swapi 1080
    00:00
  • Demonstration: API 1/2 06 07 swapi raw
    00:00
  • Demonstration: API 2/2 06 08 swapi raw
    00:00
  • Database Architectures (07 01 acid base)
    00:00
  • Scaling ACID Databases (07 02 acid scale) (fixed)
    00:00
  • True Cloud Applications (Part 1) 07 03 cloud first gen 1 1080
    00:00
  • First Generation Cloud Applications (Part 2) (07 04 cloud first gen 2 fixed)
    00:00
  • Second Generation Cloud Applications (07 05 cloud second gen fixed)1080
    00:00
  • Emerging BASE Databases 07 06 base
    00:00
  • Evolving ACID Databases (07 07 acid reaction 1080)
    00:00
  • Elastic Search Overview (7.x)
    00:00
  • Elastic Search 7.x Python Code
    00:00
  • Demonstration: Loading a book into Elastic Search
    00:00
  • Demonstration: Using Elastic Search’s REST API
    00:00
  • Demonstration: Scraping an Email API and Loading it into Elastic Search
    00:00
  • Demonstration: Loading A Tweet into Elastic Search
    00:00
  • Why Combine Pandas and SQL
    00:00
  • Using SQL in Pandas
    00:00

Student Ratings & Reviews

5.0
Total 1 Rating
5
1 Rating
4
0 Rating
3
0 Rating
2
0 Rating
1
0 Rating
R
1 year ago
well structured course

Want to receive push notifications for all major on-site activities?