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