Learn PostgreSQL : Video Tutorials

★ Table of Contents ★

1) Introduction To PostgreSQL

2) Installing PostgreSQL

3) Create , Select , Delete Database

4) Create and Delete Table

5) Inserting Data into Tables

6) Select in PostgreSQL

7) Arithmetic Operators

8) WHERE Clause and Comparison Operators

9) Logical Operators

10) Comments And Expressions

11) CHECK Constraint

12) UNIQUE AND NOT NULL CONSTRAINT

13) PRIMARY KEY AND FOREIGN KEY

14) ON DELETE RESTRICT AND CASCADE

15) ALTER TABLE

16) UPDATE AND DELETE IN TABLE

17) LIMIT And OFFSET Operators

18) GROUP BY And HAVING Clause

19) ORDER BY Clause

20) Numeric Data Types

21) ENUMERATION Data Type

22) Geometric Data Type

23) JSON Data Type

24) Arrays(1/3)

25) Updating Arrays(2/3)

26) Searching Arrays(3/3)

27) Mathematical Functions

28) String Functions

29) Aggregate Functions(Basic)

30) Aggregate Functions in PostgreSQL(Advanced)

31) LIKE in PostgreSQL

32) Cross Join

33) Inner Join

34) Left and Right Outer Joins

35) Full Outer Join

36) Alias In PostgreSQL

37) Views

38) UNION and UNION ALL

39) Truncate Table

40) Subqueries

-------------------------------------------------------

Disclaimer : Developer claims no credit for any video embedded in this app unless otherwise noted. Videos embedded in this app are copyright to its respectful owners. If there is an video appearing in this app that belongs to you and you do not want it to appear in this app, please contact us via email and it will be promptly removed.