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