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

• Udemy - The Complete Sql Bootcamp - A Step-By-Step Approach
• ~Get Your Files Here !/1 - Introduction/1 - Introduction.mp4 3.5 MB
• ~Get Your Files Here !/1 - Introduction/2 - Database Server.mp4 2.7 MB
• ~Get Your Files Here !/1 - Introduction/3 - car-rental-bkp 6.7 KB
• ~Get Your Files Here !/1 - Introduction/3 - Installing PostgreSQL on Windows.mp4 17.3 MB
• ~Get Your Files Here !/1 - Introduction/3 - postgreSQL download Link.txt 68 B
• ~Get Your Files Here !/1 - Introduction/4 - car-rental-bkp 6.7 KB
• ~Get Your Files Here !/1 - Introduction/4 - Installing PostgreSQL on MacOS.mp4 16.7 MB
• ~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.7 MB
• ~Get Your Files Here !/1 - Introduction/6 - Data Modelling and Design.mp4 4.4 MB
• ~Get Your Files Here !/1 - Introduction/7 - pgAdmin Introduction.mp4 3.3 MB
• ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/86 - Generating Reports by Grouping Related Data.mp4 1.9 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/87 - ROLLUP.mp4 2.5 MB
• ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/88 - CUBE.mp4 5.4 MB
• ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/89 - GROUPING.mp4 3.9 MB
• ~Get Your Files Here !/10 - Generating Reports with CUBE ROLLUP GROUPING SET/90 - GROUPING SETS.mp4 5 MB
• ~Get Your Files Here !/11 - Joins/91 - Joining Multiple Tables.mp4 1.7 MB
• ~Get Your Files Here !/11 - Joins/92 - Table aliases.mp4 2.3 MB
• ~Get Your Files Here !/11 - Joins/93 - Types of JOINS.mp4 1.2 MB
• ~Get Your Files Here !/11 - Joins/94 - INNER JOINON clause USING clause.mp4 5.3 MB
• ~Get Your Files Here !/11 - Joins/95 - LEFT OUTER JOINON clause.mp4 3.1 MB
• ~Get Your Files Here !/11 - Joins/96 - RIGHT OUTER JOINON clause.mp4 3.1 MB
• ~Get Your Files Here !/11 - Joins/97 - FULL OUTER JOINON clause.mp4 3.3 MB
• ~Get Your Files Here !/11 - Joins/98 - CROSS JOIN.mp4 3.1 MB
• ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/100 - Windowing calculationsaggregate function.mp4 8.2 MB
• ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/101 - Window Functions.mp4 1.9 MB
• ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/102 - Window Function OVERORDER BY orderlist clause.mp4 3.5 MB
• ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/103 - Window Function OVERPARTITION BY ORDER BY clause.mp4 5 MB
• ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/104 - Window Function OVER without windowdefinition.mp4 1.5 MB
• ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/105 - Window Function OVERPARTITION BY clause.mp4 1.8 MB
• ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/106 - WINDOW clause.mp4 3.4 MB
• ~Get Your Files Here !/12 - Window Functions RANK DENSERANK ROWNUMBER/99 - Windowing.mp4 1.2 MB
• ~Get Your Files Here !/13 - Common Table Expressions WITH Clause/107 - Using WITH Clause split complicated queries into smaller parts.mp4 4.4 MB
• ~Get Your Files Here !/13 - Common Table Expressions WITH Clause/108 - Purpose and Benefits of the WITH Clause.mp4 3.2 MB
• ~Get Your Files Here !/13 - Common Table Expressions WITH Clause/109 - Multiple Common Table Expressions CTEs.mp4 3.2 MB
• ~Get Your Files Here !/14 - Subqueries/110 - SUBQUERY.mp4 4 MB
• ~Get Your Files Here !/14 - Subqueries/111 - Scalar subquery.mp4 5.4 MB
• ~Get Your Files Here !/14 - Subqueries/112 - Row subquery.mp4 2.9 MB
• ~Get Your Files Here !/14 - Subqueries/113 - Subquery Expressions.mp4 3.4 MB
• ~Get Your Files Here !/14 - Subqueries/114 - MultiRow Subquery IN SOMEANY ALL.mp4 5.1 MB
• ~Get Your Files Here !/14 - Subqueries/115 - MultiRow Subquery NOT IN.mp4 2.1 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.5 MB
• ~Get Your Files Here !/14 - Subqueries/118 - MultiRow Subquery ALL.mp4 1.8 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.9 MB
• ~Get Your Files Here !/15 - Set OperatorsUNION INTERSECT EXCEPT/121 - Introduction.mp4 1.3 MB
• ~Get Your Files Here !/15 - Set OperatorsUNION INTERSECT EXCEPT/122 - UNION ALL.mp4 8.1 MB
• ~Get Your Files Here !/15 - Set OperatorsUNION INTERSECT EXCEPT/123 - INTERSECT ALL.mp4 3.2 MB
• ~Get Your Files Here !/15 - Set OperatorsUNION INTERSECT EXCEPT/124 - EXCEPT.mp4 1.5 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/125 - Data definition language DDL.mp4 1.6 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.4 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/128 - CREATE TABLE with AS keyword.mp4 4.8 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/129 - ALTER TABLE ADD Column.mp4 3.9 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/130 - ALTER TABLEDROP COLUMN.mp4 1.6 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/131 - ALTER ADD Primary key.mp4 3.1 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/132 - ALTER TABLEADD foreign key.mp4 3.5 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/133 - RENAME TABLE.mp4 1.4 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/134 - RENAME Column.mp4 1.5 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/135 - RENAME Constraint.mp4 1.7 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.6 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/138 - Remove TABLE comment.mp4 1.6 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/139 - RENAME Column.mp4 1.5 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/140 - TRUNCATE.mp4 1.5 MB
• ~Get Your Files Here !/16 - Data DefinitionTable/141 - DROP.mp4 2.1 MB
• ~Get Your Files Here !/17 - Constraints/142 - Check Constraint column constraint explicit constraint name.mp4 6.3 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.4 MB
• ~Get Your Files Here !/17 - Constraints/146 - NotNull Constraints column constraint explicit.mp4 3.2 MB
• ~Get Your Files Here !/17 - Constraints/147 - Unique Constraints column constraint explicit constraint name.mp4 4.8 MB
• ~Get Your Files Here !/17 - Constraints/148 - Unique Constraints column constraint implicit constraint name.mp4 4 MB
• ~Get Your Files Here !/17 - Constraints/149 - Unique Constraints table constraint explicit constraint name.mp4 4.9 MB
• ~Get Your Files Here !/17 - Constraints/150 - Unique Constraints table constraint implicit constraint name.mp4 4.5 MB
• ~Get Your Files Here !/17 - Constraints/151 - Primary Keys column constraint implicit constraint name.mp4 4.3 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.2 MB
• ~Get Your Files Here !/17 - Constraints/154 - Foreign Keys table constraint implicit constraint name.mp4 5.5 MB
• ~Get Your Files Here !/17 - Constraints/155 - Default column constraint only.mp4 5 MB
• ~Get Your Files Here !/17 - Constraints/156 - clean-up-script.txt 312 B
• ~Get Your Files Here !/17 - Constraints/156 - Cleanup.mp4 2.7 MB
• ~Get Your Files Here !/18 - Data Manipulation/157 - Data manipulation language DML.mp4 4 MB
• ~Get Your Files Here !/18 - Data Manipulation/158 - SELECT.mp4 1.2 MB
• ~Get Your Files Here !/18 - Data Manipulation/159 - INSERT.mp4 1 MB
• ~Get Your Files Here !/18 - Data Manipulation/160 - Basic INSERT using literal expression and DEFAULT method 1column name.mp4 5 MB
• ~Get Your Files Here !/18 - Data Manipulation/161 - Basic INSERT using literal expression and DEFAULT method 2values.mp4 2.3 MB
• ~Get Your Files Here !/18 - Data Manipulation/162 - INSERT using query.mp4 1.6 MB
• ~Get Your Files Here !/18 - Data Manipulation/163 - INSERT.mp4 1.6 MB
• ~Get Your Files Here !/18 - Data Manipulation/164 - UPDATE.mp4 916.4 KB
• ~Get Your Files Here !/18 - Data Manipulation/165 - UPDATE specific values.mp4 2.4 MB
• ~Get Your Files Here !/18 - Data Manipulation/166 - UPDATE all values in column.mp4 2.1 MB
• ~Get Your Files Here !/18 - Data Manipulation/167 - UPDATE multiple columns.mp4 1.9 MB
• ~Get Your Files Here !/18 - Data Manipulation/168 - DELETE.mp4 484.7 KB
• ~Get Your Files Here !/18 - Data Manipulation/169 - Delete all rows.mp4 1003.2 KB
• ~Get Your Files Here !/18 - Data Manipulation/170 - MERGE.mp4 4.7 MB

No comments yet.