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-scr