Udemy - The Complete Sql Bootcamp - A Step-By-Step Approach

Files:

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