[ DevCourseWeb Com ] Udemy - The Complete Sql Bootcamp - A Step-By-Step Approach
File List
| File | Size |
|---|---|
| Get Bonus Downloads Here.url | 182 B |
| ~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4 | 3.54 MB |
| ~Get Your Files Here !/1 - Introduction/2 - Database Server.mp4 | 2.67 MB |
| ~Get Your Files Here !/1 - Introduction/3 - Installing PostgreSQL on Windows.mp4 | 17.27 MB |
| ~Get Your Files Here !/1 - Introduction/3 - car-rental-bkp | 6.66 KB |
| ~Get Your Files Here !/1 - Introduction/3 - postgreSQL download Link.txt | 68 B |
| ~Get Your Files Here !/1 - Introduction/4 - Installing PostgreSQL on MacOS.mp4 | 16.72 MB |
| ~Get Your Files Here !/1 - Introduction/4 - car-rental-bkp | 6.66 KB |
| ~Get Your Files Here !/1 - Introduction/4 - postgreSQL download Link.txt | 68 B |
| ~Get Your Files Here !/1 - Introduction/5 - Entity Relationship Model.mp4 | 10.68 MB |
| ~Get Your Files Here !/1 - Introduction/6 - Data Modelling and Design.mp4 | 4.36 MB |
| ~Get Your Files Here !/1 - Introduction/7 - pgAdmin Introduction.mp4 | 3.34 MB |
| ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/86 - GROUP-BY-Clause-Grouping-by-Multiple-Columns.txt | 312 B |
| ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/86 - Generating Reports by Grouping Related Data.mp4 | 1.87 MB |
| ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/87 - ROLLUP.mp4 | 2.45 MB |
| ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/88 - CUBE.mp4 | 5.39 MB |
| ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/89 - GROUPING.mp4 | 3.94 MB |
| ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/90 - GROUPING SETS.mp4 | 4.97 MB |
| ~Get Your Files Here !/11 - Joins/91 - Joining Multiple Tables.mp4 | 1.71 MB |
| ~Get Your Files Here !/11 - Joins/92 - Table aliases.mp4 | 2.25 MB |
| ~Get Your Files Here !/11 - Joins/93 - Types of JOINS.mp4 | 1.17 MB |
| ~Get Your Files Here !/11 - Joins/94 - INNER JOINON clause USING clause.mp4 | 5.29 MB |
| ~Get Your Files Here !/11 - Joins/95 - LEFT OUTER JOINON clause.mp4 | 3.07 MB |
| ~Get Your Files Here !/11 - Joins/96 - RIGHT OUTER JOINON clause.mp4 | 3.14 MB |
| ~Get Your Files Here !/11 - Joins/97 - FULL OUTER JOINON clause.mp4 | 3.32 MB |
| ~Get Your Files Here !/11 - Joins/98 - CROSS JOIN.mp4 | 3.14 MB |
| ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/100 - Windowing calculationsaggregate function.mp4 | 8.25 MB |
| ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/101 - Window Functions.mp4 | 1.94 MB |
| ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/102 - Window Function OVERORDER BY orderlist clause.mp4 | 3.45 MB |
| ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/103 - Window Function OVERPARTITION BY ORDER BY clause.mp4 | 5.02 MB |
| ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/104 - Window Function OVER without windowdefinition.mp4 | 1.53 MB |
| ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/105 - Window Function OVERPARTITION BY clause.mp4 | 1.83 MB |
| ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/106 - WINDOW clause.mp4 | 3.43 MB |
| ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/99 - Windowing.mp4 | 1.24 MB |
| ~Get Your Files Here !/13 - Common Table Expressions WITH Clause/107 - Using WITH Clause split complicated queries into smaller parts.mp4 | 4.42 MB |
| ~Get Your Files Here !/13 - Common Table Expressions WITH Clause/108 - Purpose and Benefits of the WITH Clause.mp4 | 3.22 MB |
| ~Get Your Files Here !/13 - Common Table Expressions WITH Clause/109 - Multiple Common Table Expressions CTEs.mp4 | 3.21 MB |
| ~Get Your Files Here !/14 - Subqueries/110 - SUBQUERY.mp4 | 4.04 MB |
| ~Get Your Files Here !/14 - Subqueries/111 - Scalar subquery.mp4 | 5.38 MB |
| ~Get Your Files Here !/14 - Subqueries/112 - Row subquery.mp4 | 2.94 MB |
| ~Get Your Files Here !/14 - Subqueries/113 - Subquery Expressions.mp4 | 3.45 MB |
| ~Get Your Files Here !/14 - Subqueries/114 - MultiRow Subquery IN SOMEANY ALL.mp4 | 5.06 MB |
| ~Get Your Files Here !/14 - Subqueries/115 - MultiRow Subquery NOT IN.mp4 | 2.15 MB |
| ~Get Your Files Here !/14 - Subqueries/116 - MultiRow Subquery ANYSOME.mp4 | 2.5 MB |
| ~Get Your Files Here !/14 - Subqueries/117 - Table subqueryInline View.mp4 | 3.54 MB |
| ~Get Your Files Here !/14 - Subqueries/118 - MultiRow Subquery ALL.mp4 | 1.81 MB |
| ~Get Your Files Here !/14 - Subqueries/119 - Correlated Subquery.mp4 | 2.2 MB |
| ~Get Your Files Here !/14 - Subqueries/120 - NOT EXISTS Subquery Expressions.mp4 | 2.88 MB |
| ~Get Your Files Here !/15 - Set OperatorsUNION INTERSECT EXCEPT/121 - Introduction.mp4 | 1.26 MB |
| ~Get Your Files Here !/15 - Set OperatorsUNION INTERSECT EXCEPT/122 - UNION ALL.mp4 | 8.15 MB |
| ~Get Your Files Here !/15 - Set OperatorsUNION INTERSECT EXCEPT/123 - INTERSECT ALL.mp4 | 3.18 MB |
| ~Get Your Files Here !/15 - Set OperatorsUNION INTERSECT EXCEPT/124 - EXCEPT.mp4 | 1.46 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/125 - Data definition language DDL.mp4 | 1.61 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/126 - CREATE DATABASE.mp4 | 864.6 KB |
| ~Get Your Files Here !/16 - Data DefinitionTable/127 - CREATE TABLE.mp4 | 6.41 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/128 - CREATE TABLE with AS keyword.mp4 | 4.77 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/129 - ALTER TABLE ADD Column.mp4 | 3.94 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/130 - ALTER TABLEDROP COLUMN.mp4 | 1.64 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/131 - ALTER ADD Primary key.mp4 | 3.06 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/132 - ALTER TABLEADD foreign key.mp4 | 3.46 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/133 - RENAME TABLE.mp4 | 1.44 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/134 - RENAME Column.mp4 | 1.46 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/135 - RENAME Constraint.mp4 | 1.68 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/136 - Comment on a TABLE.mp4 | 2 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/137 - ALTER TABLEDROP COLUMN.mp4 | 1.64 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/138 - Remove TABLE comment.mp4 | 1.63 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/139 - RENAME Column.mp4 | 1.46 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/140 - TRUNCATE.mp4 | 1.49 MB |
| ~Get Your Files Here !/16 - Data DefinitionTable/141 - DROP.mp4 | 2.14 MB |
| ~Get Your Files Here !/17 - Constraints/142 - Check Constraint column constraint explicit constraint name.mp4 | 6.29 MB |
| ~Get Your Files Here !/17 - Constraints/143 - Check Constraint column constraint implicit constraint name.mp4 | 4.4 MB |
| ~Get Your Files Here !/17 - Constraints/144 - Check Constraint table constraint implicit constraint name.mp4 | 4.7 MB |
| ~Get Your Files Here !/17 - Constraints/145 - Check Constraint table constraint implicit constraint name.mp4 | 4.37 MB |
| ~Get Your Files Here !/17 - Constraints/146 - NotNull Constraints column constraint explicit.mp4 | 3.18 MB |
| ~Get Your Files Here !/17 - Constraints/147 - Unique Constraints column constraint explicit constraint name.mp4 | 4.75 MB |
| ~Get Your Files Here !/17 - Constraints/148 - Unique Constraints column constraint implicit constraint name.mp4 | 4.01 MB |
| ~Get Your Files Here !/17 - Constraints/149 - Unique Constraints table constraint explicit constraint name.mp4 | 4.92 MB |
| ~Get Your Files Here !/17 - Constraints/150 - Unique Constraints table constraint implicit constraint name.mp4 | 4.48 MB |
| ~Get Your Files Here !/17 - Constraints/151 - Primary Keys column constraint implicit constraint name.mp4 | 4.32 MB |
| ~Get Your Files Here !/17 - Constraints/152 - Primary Keys table constraint implicit constraint name.mp4 | 4.7 MB |
| ~Get Your Files Here !/17 - Constraints/153 - Foreign Keys table constraint explicit constraint name.mp4 | 7.19 MB |
| ~Get Your Files Here !/17 - Constraints/154 - Foreign Keys table constraint implicit constraint name.mp4 | 5.54 MB |
| ~Get Your Files Here !/17 - Constraints/155 - Default column constraint only.mp4 | 5.05 MB |
| ~Get Your Files Here !/17 - Constraints/156 - Cleanup.mp4 | 2.73 MB |
| ~Get Your Files Here !/17 - Constraints/156 - clean-up-script.txt | 312 B |
| ~Get Your Files Here !/18 - Data Manipulation/157 - Data manipulation language DML.mp4 | 3.95 MB |
| ~Get Your Files Here !/18 - Data Manipulation/158 - SELECT.mp4 | 1.24 MB |
| ~Get Your Files Here !/18 - Data Manipulation/159 - INSERT.mp4 | 1.03 MB |
| ~Get Your Files Here !/18 - Data Manipulation/160 - Basic INSERT using literal expression and DEFAULT method 1column name.mp4 | 4.96 MB |
| ~Get Your Files Here !/18 - Data Manipulation/161 - Basic INSERT using literal expression and DEFAULT method 2values.mp4 | 2.32 MB |
| ~Get Your Files Here !/18 - Data Manipulation/162 - INSERT using query.mp4 | 1.58 MB |
| ~Get Your Files Here !/18 - Data Manipulation/163 - INSERT.mp4 | 1.58 MB |
| ~Get Your Files Here !/18 - Data Manipulation/164 - UPDATE.mp4 | 916.43 KB |
| ~Get Your Files Here !/18 - Data Manipulation/165 - UPDATE specific values.mp4 | 2.37 MB |
| ~Get Your Files Here !/18 - Data Manipulation/166 - UPDATE all values in column.mp4 | 2.08 MB |
| ~Get Your Files Here !/18 - Data Manipulation/167 - UPDATE multiple columns.mp4 | 1.88 MB |
| ~Get Your Files Here !/18 - Data Manipulation/168 - DELETE.mp4 | 484.74 KB |
| ~Get Your Files Here !/18 - Data Manipulation/169 - Delete all rows.mp4 | 1003.19 KB |
| ~Get Your Files Here !/18 - Data Manipulation/170 - MERGE.mp4 | 4.67 MB |
| ~Get Your Files Here !/18 - Data Manipulation/171 - Delete specific rows.mp4 | 4.17 MB |
Trackers
No trackers found.