|
|
1 - Introduction.mp4
|
MP4
|
3.5 MB
|
|
|
10 - Literalconstant.mp4
|
MP4
|
900.3 KB
|
|
|
100 - Windowing calculationsaggregate function.mp4
|
MP4
|
8.2 MB
|
|
|
101 - Window Functions.mp4
|
MP4
|
1.9 MB
|
|
|
102 - Window Function OVERORDER BY orderlist clause.mp4
|
MP4
|
3.5 MB
|
|
|
103 - Window Function OVERPARTITION BY ORDER BY clause.mp4
|
MP4
|
5 MB
|
|
|
104 - Window Function OVER without windowdefinition.mp4
|
MP4
|
1.5 MB
|
|
|
105 - Window Function OVERPARTITION BY clause.mp4
|
MP4
|
1.8 MB
|
|
|
106 - WINDOW clause.mp4
|
MP4
|
3.4 MB
|
|
|
107 - Using WITH Clause split complicated queries into smaller parts.mp4
|
MP4
|
4.4 MB
|
|
|
108 - Purpose and Benefits of the WITH Clause.mp4
|
MP4
|
3.2 MB
|
|
|
109 - Multiple Common Table Expressions CTEs.mp4
|
MP4
|
3.2 MB
|
|
|
11 - Nonnumeric Literals.mp4
|
MP4
|
1.5 MB
|
|
|
110 - SUBQUERY.mp4
|
MP4
|
4 MB
|
|
|
111 - Scalar subquery.mp4
|
MP4
|
5.4 MB
|
|
|
112 - Row subquery.mp4
|
MP4
|
2.9 MB
|
|
|
113 - Subquery Expressions.mp4
|
MP4
|
3.4 MB
|
|
|
114 - MultiRow Subquery IN SOMEANY ALL.mp4
|
MP4
|
5.1 MB
|
|
|
115 - MultiRow Subquery NOT IN.mp4
|
MP4
|
2.1 MB
|
|
|
116 - MultiRow Subquery ANYSOME.mp4
|
MP4
|
2.5 MB
|
|
|
117 - Table subqueryInline View.mp4
|
MP4
|
3.5 MB
|
|
|
118 - MultiRow Subquery ALL.mp4
|
MP4
|
1.8 MB
|
|
|
119 - Correlated Subquery.mp4
|
MP4
|
2.2 MB
|
|
|
12 - Numeric Literals.mp4
|
MP4
|
1.6 MB
|
|
|
120 - NOT EXISTS Subquery Expressions.mp4
|
MP4
|
2.9 MB
|
|
|
121 - Introduction.mp4
|
MP4
|
1.3 MB
|
|
|
122 - UNION ALL.mp4
|
MP4
|
8.1 MB
|
|
|
123 - INTERSECT ALL.mp4
|
MP4
|
3.2 MB
|
|
|
124 - EXCEPT.mp4
|
MP4
|
1.5 MB
|
|
|
125 - Data definition language DDL.mp4
|
MP4
|
1.6 MB
|
|
|
126 - CREATE DATABASE.mp4
|
MP4
|
864.6 KB
|
|
|
127 - CREATE TABLE.mp4
|
MP4
|
6.4 MB
|
|
|
128 - CREATE TABLE with AS keyword.mp4
|
MP4
|
4.8 MB
|
|
|
129 - ALTER TABLE ADD Column.mp4
|
MP4
|
3.9 MB
|
|
|
13 - Arithmetic Expression Operators.mp4
|
MP4
|
1.5 MB
|
|
|
130 - ALTER TABLEDROP COLUMN.mp4
|
MP4
|
1.6 MB
|
|
|
131 - ALTER ADD Primary key.mp4
|
MP4
|
3.1 MB
|
|
|
132 - ALTER TABLEADD foreign key.mp4
|
MP4
|
3.5 MB
|
|
|
133 - RENAME TABLE.mp4
|
MP4
|
1.4 MB
|
|
|
134 - RENAME Column.mp4
|
MP4
|
1.5 MB
|
|
|
135 - RENAME Constraint.mp4
|
MP4
|
1.7 MB
|
|
|
136 - Comment on a TABLE.mp4
|
MP4
|
2 MB
|
|
|
137 - ALTER TABLEDROP COLUMN.mp4
|
MP4
|
1.6 MB
|
|
|
138 - Remove TABLE comment.mp4
|
MP4
|
1.6 MB
|
|
|
139 - RENAME Column.mp4
|
MP4
|
1.5 MB
|
|
|
14 - Mathematical Operator Precedence.mp4
|
MP4
|
5.1 MB
|
|
|
140 - TRUNCATE.mp4
|
MP4
|
1.5 MB
|
|
|
141 - DROP.mp4
|
MP4
|
2.1 MB
|
|
|
142 - Check Constraint column constraint explicit constraint name.mp4
|
MP4
|
6.3 MB
|
|
|
143 - Check Constraint column constraint implicit constraint name.mp4
|
MP4
|
4.4 MB
|
|
|
144 - Check Constraint table constraint implicit constraint name.mp4
|
MP4
|
4.7 MB
|
|
|
145 - Check Constraint table constraint implicit constraint name.mp4
|
MP4
|
4.4 MB
|
|
|
146 - NotNull Constraints column constraint explicit.mp4
|
MP4
|
3.2 MB
|
|
|
147 - Unique Constraints column constraint explicit constraint name.mp4
|
MP4
|
4.8 MB
|
|
|
148 - Unique Constraints column constraint implicit constraint name.mp4
|
MP4
|
4 MB
|
|
|
149 - Unique Constraints table constraint explicit constraint name.mp4
|
MP4
|
4.9 MB
|
|
|
15 - Using aliases.mp4
|
MP4
|
1.4 MB
|
|
|
150 - Unique Constraints table constraint implicit constraint name.mp4
|
MP4
|
4.5 MB
|
|
|
151 - Primary Keys column constraint implicit constraint name.mp4
|
MP4
|
4.3 MB
|
|
|
152 - Primary Keys table constraint implicit constraint name.mp4
|
MP4
|
4.7 MB
|
|
|
153 - Foreign Keys table constraint explicit constraint name.mp4
|
MP4
|
7.2 MB
|
|
|
154 - Foreign Keys table constraint implicit constraint name.mp4
|
MP4
|
5.5 MB
|
|
|
155 - Default column constraint only.mp4
|
MP4
|
5 MB
|
|
|
156 - Cleanup.mp4
|
MP4
|
2.7 MB
|
|
|
156 - clean-up-script.txt
|
TXT
|
307.2 B
|
|
|
157 - Data manipulation language DML.mp4
|
MP4
|
4 MB
|
|
|
158 - SELECT.mp4
|
MP4
|
1.2 MB
|
|
|
159 - INSERT.mp4
|
MP4
|
1 MB
|
|
|
16 - Escape character sequence.mp4
|
MP4
|
1.5 MB
|
|
|
160 - Basic INSERT using literal expression and DEFAULT method 1column name.mp4
|
MP4
|
5 MB
|
|
|
161 - Basic INSERT using literal expression and DEFAULT method 2values.mp4
|
MP4
|
2.3 MB
|
|
|
162 - INSERT using query.mp4
|
MP4
|
1.6 MB
|
|
|
163 - INSERT.mp4
|
MP4
|
1.6 MB
|
|
|
164 - UPDATE.mp4
|
MP4
|
916.4 KB
|
|
|
165 - UPDATE specific values.mp4
|
MP4
|
2.4 MB
|
|
|
166 - UPDATE all values in column.mp4
|
MP4
|
2.1 MB
|
|
|
167 - UPDATE multiple columns.mp4
|
MP4
|
1.9 MB
|
|
|
168 - DELETE.mp4
|
MP4
|
484.7 KB
|
|
|
17 - Concatenation Operator.mp4
|
MP4
|
4.5 MB
|
|
|
170 - MERGE.mp4
|
MP4
|
4.7 MB
|
|
|
171 - Delete specific rows.mp4
|
MP4
|
4.2 MB
|
|
|
172 - Cleanup.mp4
|
MP4
|
2.7 MB
|
|
|
172 - clean-up-script.txt
|
TXT
|
307.2 B
|
|
|
173 - Disable autocommit in pgAdmin4 37.mp4
|
MP4
|
1.2 MB
|
|
|
174 - COMMIT.mp4
|
MP4
|
3.7 MB
|
|
|
175 - ROLLBACK.mp4
|
MP4
|
5.4 MB
|
|
|
176 - SAVEPOINT.mp4
|
MP4
|
5.3 MB
|
|
|
177 - CREATE SEQUENCE.mp4
|
MP4
|
12.4 MB
|
|
|
178 - Sequence Functions.mp4
|
MP4
|
512.4 KB
|
|
|
179 - NEXTVAL.mp4
|
MP4
|
1.2 MB
|
|
|
18 - Comments Within SQL Statements code.mp4
|
MP4
|
3.3 MB
|
|
|
180 - CURRVAL.mp4
|
MP4
|
2.2 MB
|
|
|
181 - ALTER Sequence.mp4
|
MP4
|
2 MB
|
|
|
182 - RENAME a Sequence.mp4
|
MP4
|
1.8 MB
|
|
|
183 - COMMENT on Sequence.mp4
|
MP4
|
1.5 MB
|
|
|
184 - DROP sequence.mp4
|
MP4
|
1.4 MB
|
|
|
185 - Create a View.mp4
|
MP4
|
4.5 MB
|
|
|
186 - SELECT from a View.mp4
|
MP4
|
1.1 MB
|
|
|
187 - OR REPLACE keyword.mp4
|
MP4
|
2.3 MB
|
|
|
188 - ALTER VIEW.mp4
|
MP4
|
1.6 MB
|
|
|
189 - RENAME a View.mp4
|
MP4
|
1.4 MB
|
|
|
19 - Data Types.mp4
|
MP4
|
2.4 MB
|
|
|
190 - COMMENT.mp4
|
MP4
|
1.6 MB
|
|
|
191 - Drop a View.mp4
|
MP4
|
2.2 MB
|
|
|
192 - Cleanup.mp4
|
MP4
|
1.6 MB
|
|
|
193 - CREATE USER.mp4
|
MP4
|
2 MB
|
|
|
194 - CREATE ROLE.mp4
|
MP4
|
1.8 MB
|
|
|
195 - Data Control Language DCL.mp4
|
MP4
|
1.9 MB
|
|
|
196 - GRANT specific privileges to a role.mp4
|
MP4
|
3.8 MB
|
|
|
197 - GRANT ALL PRIVILEGES to a role.mp4
|
MP4
|
2.3 MB
|
|
|
198 - GRANT specific privileges to a user.mp4
|
MP4
|
1.9 MB
|
|
|
199 - GRANTadd members on the existing role.mp4
|
MP4
|
2.9 MB
|
|
|
2 - Database Server.mp4
|
MP4
|
2.7 MB
|
|
|
20 - Cast FunctionCAST and cast operator.mp4
|
MP4
|
2 MB
|
|
|
200 - REVOKE specific privileges from a role.mp4
|
MP4
|
2 MB
|
|
|
201 - REVOKE ALL PRIVILEGES from a role.mp4
|
MP4
|
2 MB
|
|
|
202 - REVOKE remove members on the existing role.mp4
|
MP4
|
1.5 MB
|
|
|
203 - DROP USERS.mp4
|
MP4
|
3 MB
|
|
|
204 - DROP ROLES.mp4
|
MP4
|
2.4 MB
|
|
|
21 - Numeric Data Types.mp4
|
MP4
|
3.3 MB
|
|
|
22 - Character Data Types.mp4
|
MP4
|
1.5 MB
|
|
|
23 - Date Time Data Types.mp4
|
MP4
|
564.1 KB
|
|
|
24 - Boolean Data Type.mp4
|
MP4
|
298.2 KB
|
|
|
25 - SELECTING columns or expressions FROM a table.mp4
|
MP4
|
2.1 MB
|
|
|
26 - Selecting All Columns.mp4
|
MP4
|
1.2 MB
|
|
|
27 - Selecting Specific Columns or Expressions.mp4
|
MP4
|
3.1 MB
|
|
|
28 - Using Column Aliases.mp4
|
MP4
|
6.4 MB
|
|
|
29 - Eliminating duplicate rows.mp4
|
MP4
|
2.3 MB
|
|
|
3 - Data Types.html
|
HTML
|
102.4 B
|
|
|
3 - Installing PostgreSQL on Windows.mp4
|
MP4
|
17.3 MB
|
|
|
3 - car-rental-bkp
|
|
6.7 KB
|
|
|
3 - postgreSQL download Link.txt
|
TXT
|
102.4 B
|
|
|
30 - SELECT from a generated VALUES Lists.mp4
|
MP4
|
5.2 MB
|
|
|
31 - Using WHERE Clause.mp4
|
MP4
|
1.6 MB
|
|
|
32 - Comparison Operators.mp4
|
MP4
|
6.2 MB
|
|
|
33 - Match any Range search condition NOT BETWEEN.mp4
|
MP4
|
3 MB
|
|
|
34 - Match any of a list of values NOT IN.mp4
|
MP4
|
3.4 MB
|
|
|
35 - Pattern match search condition NOT LIKE.mp4
|
MP4
|
3.9 MB
|
|
|
36 - Using IS NOT NULL Conditions.mp4
|
MP4
|
2.1 MB
|
|
|
37 - Using the AND Operator.mp4
|
MP4
|
1.9 MB
|
|
|
38 - Using the OR Operator.mp4
|
MP4
|
1.8 MB
|
|
|
39 - Rules of PrecedenceOrder of operation.mp4
|
MP4
|
7.9 MB
|
|
|
4 - Installing PostgreSQL on MacOS.mp4
|
MP4
|
16.7 MB
|
|
|
4 - car-rental-bkp
|
|
6.7 KB
|
|
|
4 - postgreSQL download Link.txt
|
TXT
|
102.4 B
|
|
|
40 - ORDER BY clause.mp4
|
MP4
|
7.5 MB
|
|
|
41 - OFFSET.mp4
|
MP4
|
2.2 MB
|
|
|
42 - FETCH.mp4
|
MP4
|
4 MB
|
|
|
43 - LIMIT.mp4
|
MP4
|
1.2 MB
|
|
|
44 - OFFSET and FETCH.mp4
|
MP4
|
1.5 MB
|
|
|
45 - OFFSET and LIMIT.mp4
|
MP4
|
1.3 MB
|
|
|
46 - Functions and Operators.mp4
|
MP4
|
564.8 KB
|
|
|
47 - String functions and Operators String Concatenation.mp4
|
MP4
|
2.9 MB
|
|
|
48 - String functionsCase Conversion.mp4
|
MP4
|
1.9 MB
|
|
|
49 - Show part of a stringLEFTRIGHT SUBSTR.mp4
|
MP4
|
3.8 MB
|
|
|
5 - Entity Relationship Model.mp4
|
MP4
|
10.7 MB
|
|
|
50 - Remove from a StringTRIMLTRIMRTRIM.mp4
|
MP4
|
3 MB
|
|
|
51 - Add and Replace characters in a StringLPAD RPAD REPLACE.mp4
|
MP4
|
2.8 MB
|
|
|
52 - Length of stringLENGTH.mp4
|
MP4
|
1.2 MB
|
|
|
53 - Using MODULUS Function.mp4
|
MP4
|
1.9 MB
|
|
|
54 - Using CEILING and FLOOR Function.mp4
|
MP4
|
1.9 MB
|
|
|
55 - Using ROUND and TRUNCATE Function.mp4
|
MP4
|
3.1 MB
|
|
|
56 - Date Time Functions.mp4
|
MP4
|
1.4 MB
|
|
|
57 - CREATE-TABLE-xxtab.txt
|
TXT
|
307.2 B
|
|
|
57 - Introduction.mp4
|
MP4
|
1.8 MB
|
|
|
58 - POSIXRegular Expressions.mp4
|
MP4
|
1.8 MB
|
|
|
59 - Regular Expression Atoms.mp4
|
MP4
|
4 MB
|
|
|
6 - Data Modelling and Design.mp4
|
MP4
|
4.4 MB
|
|
|
60 - Literal Characters.mp4
|
MP4
|
906.2 KB
|
|
|
61 - Dot.mp4
|
MP4
|
1.2 MB
|
|
|
62 - Regular Expression Constraints also called Anchors.mp4
|
MP4
|
2.8 MB
|
|
|
63 - Regular Expression Quantifiers.mp4
|
MP4
|
6.4 MB
|
|
|
64 - Bracket Expressions Character classes.mp4
|
MP4
|
14.3 MB
|
|
|
65 - Escaping characters.mp4
|
MP4
|
2.1 MB
|
|
|
66 - GroupsParentheses.mp4
|
MP4
|
1.3 MB
|
|
|
67 - Alternatives.mp4
|
MP4
|
1.1 MB
|
|
|
68 - REGEXPCOUNT.mp4
|
MP4
|
2 MB
|
|
|
69 - REGEXPINSTR.mp4
|
MP4
|
5.2 MB
|
|
|
7 - pgAdmin Introduction.mp4
|
MP4
|
3.3 MB
|
|
|
70 - REGEXPLIKE.mp4
|
MP4
|
2.3 MB
|
|
|
71 - REGEXPREPLACE.mp4
|
MP4
|
3.6 MB
|
|
|
72 - REGEXPSUBSTR.mp4
|
MP4
|
3.6 MB
|
|
|
73 - Conditional Expressions.mp4
|
MP4
|
4 MB
|
|
|
74 - CASE Statement.mp4
|
MP4
|
7.5 MB
|
|
|
75 - NULLIF.mp4
|
MP4
|
2.5 MB
|
|
|
76 - COALESCE.mp4
|
MP4
|
3 MB
|
|
|
77 - LEAST and GREATEST.mp4
|
MP4
|
3.5 MB
|
|
|
78 - Aggregate Functions.mp4
|
MP4
|
2.8 MB
|
|
|
79 - Using Aggregate Functions on the entire column data set.mp4
|
MP4
|
2.2 MB
|
|
|
8 - Basic Select Statement.mp4
|
MP4
|
4.8 MB
|
|
|
80 - Using Aggregate Functions with WHERE clause.mp4
|
MP4
|
1.6 MB
|
|
|
81 - COUNT Aggregate Function.mp4
|
MP4
|
5.5 MB
|
|
|
82 - Handling Null values in Aggregate Functions.mp4
|
MP4
|
3.5 MB
|
|
|
83 - GROUP BY Clause.mp4
|
MP4
|
5.4 MB
|
|
|
84 - GROUP BY ClauseGrouping by Multiple Columns.mp4
|
MP4
|
8.4 MB
|
|
|
85 - HAVING Clause Filter Groups using Aggregated column.mp4
|
MP4
|
3.5 MB
|
|
|
86 - GROUP-BY-Clause-Grouping-by-Multiple-Columns.txt
|
TXT
|
307.2 B
|
|
|
86 - Generating Reports by Grouping Related Data.mp4
|
MP4
|
1.9 MB
|
|
|
87 - ROLLUP.mp4
|
MP4
|
2.5 MB
|
|
|
88 - CUBE.mp4
|
MP4
|
5.4 MB
|
|
|
89 - GROUPING.mp4
|
MP4
|
3.9 MB
|
|
|
9 - Literalcharacter String.mp4
|
MP4
|
3.7 MB
|
|
|
90 - GROUPING SETS.mp4
|
MP4
|
5 MB
|
|
|
91 - Joining Multiple Tables.mp4
|
MP4
|
1.7 MB
|
|
|
92 - Table aliases.mp4
|
MP4
|
2.3 MB
|
|
|
93 - Types of JOINS.mp4
|
MP4
|
1.2 MB
|
|
|
94 - INNER JOINON clause USING clause.mp4
|
MP4
|
5.3 MB
|
|
|
95 - LEFT OUTER JOINON clause.mp4
|
MP4
|
3.1 MB
|
|
|
96 - RIGHT OUTER JOINON clause.mp4
|
MP4
|
3.1 MB
|
|
|
97 - FULL OUTER JOINON clause.mp4
|
MP4
|
3.3 MB
|
|
|
98 - CROSS JOIN.mp4
|
MP4
|
3.1 MB
|
|
|
99 - Windowing.mp4
|
MP4
|
1.2 MB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
