DevCourseWeb com Udemy The Complete Sql Bootcamp Step By Step Approach

DevCourseWeb com Udemy The Complete Sql Bootcamp Step By Step Approach

Name	[ DevCourseWeb.com ] Udemy - The Complete Sql Bootcamp - A Step-By-Step Approach	DOWNLOAD Copy Link
Total Size	692.9 MB
Total Files	215
Last Seen	2025-02-20 00:14
Hash	1219F10077C3FC793D0861F9DA8D33FF4B77D17F

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