PostgreSQL Advanced SQL Queries and Data Analysis | 378C734C2032EDEA873CB4AF1C9EC844E127AD53

PostgreSQL Advanced SQL Queries and Data Analysis

Name	PostgreSQL - Advanced SQL Queries and Data Analysis	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	630.7 MB
Total Files	67
Last Seen
Hash	378C734C2032EDEA873CB4AF1C9EC844E127AD53

/03 Some PostgreSQL Operators/
032 LIKE Operator.mp4	20.7 MB
024 UNION Operator.mp4	9.0 MB
025 UNION ALL operator.mp4	6.2 MB
026 INTERSECT Operator.mp4	13.0 MB
027 EXCEPT Operator.mp4	16.2 MB
028 IN Operator.mp4	19.8 MB
029 AND Operator.mp4	12.9 MB
030 OR Operator.mp4	12.0 MB
031 Using AND with OR.mp4	16.0 MB
/01 Installation and Setup/
002 What is PostgreSQL.mp4	6.2 MB
003 PostgreSQL System Architecture.mp4	4.8 MB
004 Who is using PostgreSQL.mp4	10.2 MB
005 Minimum Requirements.mp4	5.8 MB
006 Download PostgreSQL.mp4	8.3 MB
007 Installing PostgreSQL Windows.mp4	9.1 MB
008 Verify Installation.mp4	7.6 MB
009 Installing PostgreSQL MacOS.mp4	6.3 MB
010 Connecting to PostgreSQL Database.mp4	12.4 MB
011 Load Sample Database.mp4	20.4 MB
012 Creating a new Table.mp4	7.7 MB
013 Populating a Table.mp4	10.3 MB
014 Query a Table.mp4	8.1 MB
001 Introduction.mp4	3.6 MB
/attached files/
011 dvdrental.tar	2.8 MB
/02 PostgreSQL Server and Database Objects/
015 Server Service.mp4	8.6 MB
016 Schema.mp4	6.2 MB
017 Tablespace.mp4	5.8 MB
018 Functions.mp4	9.9 MB
019 Cast and Operators.mp4	4.7 MB
020 Sequence.mp4	12.0 MB
021 Extensions.mp4	8.4 MB
022 Introduction to stored proceedures.mp4	7.8 MB
023 Creating a function.mp4	12.3 MB
/04 Table Joins/
033 Inner Joins.mp4	19.0 MB
034 Left Join.mp4	19.8 MB
035 Full Outer Join.mp4	18.8 MB
036 Cross Join.mp4	12.8 MB
037 Natural Join.mp4	19.9 MB
/05 Aggregate Functions/
038 Introduction to Aggregate Functions.mp4	2.0 MB
039 AVG Function.mp4	13.9 MB
040 COUNT Function.mp4	13.1 MB
041 MAX Function.mp4	12.9 MB
042 MIN Function.mp4	10.8 MB
043 SUM Function.mp4	7.6 MB
/06 Triggers/
044 Introduction to PostgreSQL Triggers.mp4	7.4 MB
045 Creating your first trigger Part 1.mp4	11.9 MB
046 Creating your first trigger Part 2.mp4	9.9 MB
047 Creating your first trigger Part 3.mp4	16.8 MB
048 Managing Triggers.mp4	5.7 MB
/07 PostgreSQL Views/
049 Introduction to Views.mp4	2.7 MB
050 Benefits of using Views.mp4	1.6 MB
051 Creating a View.mp4	12.0 MB
052 Modifying and Removing Views.mp4	9.1 MB
053 Introduction to Updatable Views.mp4	4.8 MB
054 Creating Updatable Views.mp4	9.9 MB
055 Introduction to Materialized Views.mp4	2.2 MB
056 Creating a Materialized View.mp4	11.8 MB
/08 Analytic Functions/
057 Introduction to Analytic Functions.mp4	4.9 MB
058 Creating Sample Tables.mp4	7.6 MB
059 Using AVG as a Window Function.mp4	4.9 MB
060 ROW Number Functions.mp4	10.3 MB
061 Rank Functions.mp4	3.7 MB
062 Dense Rank Functions.mp4	3.2 MB
063 First Value Function.mp4	2.8 MB
064 Last Function.mp4	4.4 MB
065 LAG Function.mp4	3.3 MB
066 LEAD Function.mp4	3.6 MB
Total files 67