| 1 - Introduction.mp4 | 3.5 MB | ||
| 10 - Literalconstant.mp4 | 900.3 KB | ||
| 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 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 | ||
| 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 | ||
| 11 - Nonnumeric Literals.mp4 | 1.5 MB | ||
| 110 - SUBQUERY.mp4 | 4 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 | ||
| 12 - Numeric Literals.mp4 | 1.6 MB | ||
| 120 - NOT EXISTS Subquery Expressions.mp4 | 2.9 MB | ||
| 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 | ||
| 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 | ||
| 13 - Arithmetic Expression Operators.mp4 | 1.5 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 MB | ||
| 137 - ALTER TABLEDROP COLUMN.mp4 | 1.6 MB | ||
| 138 - Remove TABLE comment.mp4 | 1.6 MB | ||
| 139 - RENAME Column.mp4 | 1.5 MB | ||
| 14 - Mathematical Operator Precedence.mp4 | 5.1 MB | ||
| 140 - TRUNCATE.mp4 | 1.5 MB | ||
| 141 - DROP.mp4 | 2.1 MB | ||
| 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 MB | ||
| 149 - Unique Constraints table constraint explicit constraint name.mp4 | 4.9 MB | ||
| 15 - Using aliases.mp4 | 1.4 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 MB | ||
| 156 - Cleanup.mp4 | 2.7 MB | ||
| 156 - clean-up-script.txt | 307.2 B | ||
| 157 - Data manipulation language DML.mp4 | 4 MB | ||
| 158 - SELECT.mp4 | 1.2 MB | ||
| 159 - INSERT.mp4 | 1 MB | ||
| 16 - Escape character sequence.mp4 | 1.5 MB | ||
| 160 - Basic INSERT using literal expression and DEFAULT method 1column name.mp4 | 5 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 | ||
| 17 - Concatenation Operator.mp4 | 4.5 MB | ||
| 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 | 307.2 B | ||
| 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 | ||
| 177 - CREATE SEQUENCE.mp4 | 12.4 MB | ||
| 178 - Sequence Functions.mp4 | 512.4 KB | ||
| 179 - NEXTVAL.mp4 | 1.2 MB | ||
| 18 - Comments Within SQL Statements code.mp4 | 3.3 MB | ||
| 180 - CURRVAL.mp4 | 2.2 MB | ||
| 181 - ALTER Sequence.mp4 | 2 MB | ||
| 182 - RENAME a Sequence.mp4 | 1.8 MB | ||
| 183 - COMMENT on Sequence.mp4 | 1.5 MB | ||
| 184 - DROP sequence.mp4 | 1.4 MB | ||
| 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 | ||
| 19 - Data Types.mp4 | 2.4 MB | ||
| 190 - COMMENT.mp4 | 1.6 MB | ||
| 191 - Drop a View.mp4 | 2.2 MB | ||
| 192 - Cleanup.mp4 | 1.6 MB | ||
| 193 - CREATE USER.mp4 | 2 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 | ||
| 2 - Database Server.mp4 | 2.7 MB | ||
| 20 - Cast FunctionCAST and cast operator.mp4 | 2 MB | ||
| 200 - REVOKE specific privileges from a role.mp4 | 2 MB | ||
| 201 - REVOKE ALL PRIVILEGES from a role.mp4 | 2 MB | ||
| 202 - REVOKE remove members on the existing role.mp4 | 1.5 MB | ||
| 203 - DROP USERS.mp4 | 3 MB | ||
| 204 - DROP ROLES.mp4 | 2.4 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 | ||
| 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 | ||
| 3 - Data Types.html | 102.4 B | ||
| 3 - Installing PostgreSQL on Windows.mp4 | 17.3 MB | ||
| 3 - car-rental-bkp | 6.7 KB | ||
| 3 - postgreSQL download Link.txt | 102.4 B | ||
| 30 - SELECT from a generated VALUES Lists.mp4 | 5.2 MB | ||
| 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 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 | ||
| 4 - Installing PostgreSQL on MacOS.mp4 | 16.7 MB | ||
| 4 - car-rental-bkp | 6.7 KB | ||
| 4 - postgreSQL download Link.txt | 102.4 B | ||
| 40 - ORDER BY clause.mp4 | 7.5 MB | ||
| 41 - OFFSET.mp4 | 2.2 MB | ||
| 42 - FETCH.mp4 | 4 MB | ||
| 43 - LIMIT.mp4 | 1.2 MB | ||
| 44 - OFFSET and FETCH.mp4 | 1.5 MB | ||
| 45 - OFFSET and LIMIT.mp4 | 1.3 MB | ||
| 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 | ||
| 5 - Entity Relationship Model.mp4 | 10.7 MB | ||
| 50 - Remove from a StringTRIMLTRIMRTRIM.mp4 | 3 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 | ||
| 57 - CREATE-TABLE-xxtab.txt | 307.2 B | ||
| 57 - Introduction.mp4 | 1.8 MB | ||
| 58 - POSIXRegular Expressions.mp4 | 1.8 MB | ||
| 59 - Regular Expression Atoms.mp4 | 4 MB | ||
| 6 - Data Modelling and Design.mp4 | 4.4 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 MB | ||
| 69 - REGEXPINSTR.mp4 | 5.2 MB | ||
| 7 - pgAdmin Introduction.mp4 | 3.3 MB | ||
| 70 - REGEXPLIKE.mp4 | 2.3 MB | ||
| 71 - REGEXPREPLACE.mp4 | 3.6 MB | ||
| 72 - REGEXPSUBSTR.mp4 | 3.6 MB | ||
| 73 - Conditional Expressions.mp4 | 4 MB | ||
| 74 - CASE Statement.mp4 | 7.5 MB | ||
| 75 - NULLIF.mp4 | 2.5 MB | ||
| 76 - COALESCE.mp4 | 3 MB | ||
| 77 - LEAST and GREATEST.mp4 | 3.5 MB | ||
| 78 - Aggregate Functions.mp4 | 2.8 MB | ||
| 79 - Using Aggregate Functions on the entire column data set.mp4 | 2.2 MB | ||
| 8 - Basic Select Statement.mp4 | 4.8 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 | ||
| 86 - GROUP-BY-Clause-Grouping-by-Multiple-Columns.txt | 307.2 B | ||
| 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 | ||
| 9 - Literalcharacter String.mp4 | 3.7 MB | ||
| 90 - GROUPING SETS.mp4 | 5 MB | ||
| 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 | ||
| 99 - Windowing.mp4 | 1.2 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 214 total files | |||
The Complete Sql Bootcamp: A Step-By-Step Approach
https://DevCourseWeb.com
Published 10/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 660.91 MB | Duration: 2h 45m
Master SQL
What you'll learn
Generate reports and address business challenges
Write Complex Queries Using Common Table Expressions (CTEs)
Lean about GROUP by clause
Master SQL Joins and Window Functions (RANK, DENSE_RANK, ROW_NUMBER)
Master SQL for Data Analytics and Business Intelligence
Master SQL for Data Migration and Data Manipulation
Create Database Objects
Requirements
No SQL experience is required, and you will learn all that you need.
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 503.7 MB | freecoursewb | 6 days | 20 | 11 | |
| 784.3 MB | freecoursewb | 6 days | 18 | 6 | |
| 2.2 GB | freecoursewb | 6 days | 0 | 0 | |
| 3.7 GB | freecoursewb | 6 days | 0 | 0 | |
| 3.3 GB | freecoursewb | 6 days | 24 | 16 |
All Comments