https://img100.pixhost.to/images/617/539499712_359020115_tuto.jpg
574.71 MB | 00:11:37 | mp4 | 1280X720 | 16:9
Genre: eLearning | Language : English
Files Included :
001 Introduction (3.42 MB)
002 What is PostgreSQL (5.94 MB)
003 PostgreSQL System Architecture (4.56 MB)
004 Who is using PostgreSQL (9.74 MB)
005 Minimum Requirements (5.54 MB)
006 Download PostgreSQL (7.95 MB)
007 Installing PostgreSQL Windows (8.69 MB)
008 Verify Installation (7.29 MB)
009 Installing PostgreSQL MacOS (5.99 MB)
010 Connecting to PostgreSQL Database (11.84 MB)
011 Load Sample Database (19.5 MB)
012 Creating a new Table (7.39 MB)
013 Populating a Table (9.8 MB)
014 Query a Table (7.72 MB)
015 Server Service (8.22 MB)
016 Schema (5.88 MB)
017 Tablespace (5.56 MB)
018 Functions (9.48 MB)
019 Cast and Operators (4.5 MB)
020 Sequence (11.43 MB)
021 Extensions (7.97 MB)
022 Introduction to stored proceedures (7.44 MB)
023 Creating a function (11.71 MB)
024 UNION Operator (8.58 MB)
025 UNION ALL operator (5.9 MB)
026 INTERSECT Operator (12.4 MB)
027 EXCEPT Operator (15.46 MB)
028 IN Operator (18.85 MB)
029 AND Operator (12.35 MB)
030 OR Operator (11.45 MB)
031 Using AND with OR (15.27 MB)
032 LIKE Operator (19.73 MB)
033 Inner Joins (18.16 MB)
034 Left Join (18.89 MB)
035 Full Outer Join (17.95 MB)
036 Cross Join (12.19 MB)
037 Natural Join (18.95 MB)
038 Introduction to Aggregate Functions (1.86 MB)
039 AVG Function (13.3 MB)
040 COUNT Function (12.52 MB)
041 MAX Function (12.34 MB)
042 MIN Function (10.26 MB)
043 SUM Function (7.27 MB)
044 Introduction to PostgreSQL Triggers (7.09 MB)
045 Creating your first trigger Part 1 (11.36 MB)
046 Creating your first trigger Part 2 (9.41 MB)
047 Creating your first trigger Part 3 (15.99 MB)
048 Managing Triggers (5.45 MB)
049 Introduction to Views (2.55 MB)
050 Benefits of using Views (1.54 MB)
051 Creating a View (11.4 MB)
052 Modifying and Removing Views (8.69 MB)
053 Introduction to Updatable Views (4.59 MB)
054 Creating Updatable Views (9.42 MB)
055 Introduction to Materialized Views (2.09 MB)
056 Creating a Materialized View (11.29 MB)
057 Introduction to Analytic Functions (4.72 MB)
058 Creating Sample Tables (7.28 MB)
059 Using AVG as a Window Function (4.72 MB)
060 ROW Number Functions (9.82 MB)
061 Rank Functions (3.55 MB)
062 Dense Rank Functions (3.08 MB)
063 First Value Function (2.68 MB)
064 Last Function (4.21 MB)
065 LAG Function (3.16 MB)
066 LEAD Function (3.4 MB)]
Screenshot
https://images2.imgbox.com/0b/d5/10f5Sk9J_o.jpg
https://filecrypt.cc/Container/A3307E56EC.html
https://fikper.com/VaNVjMCaYW/PostgreSQL.-.Advanced.SQL.Queries.and.Data.Analysis.rar.html
https://filecrypt.cc/Container/20E7E66E64.html
Видео
