Filename Size 01. Introduction/1. Introduction to PostgreSQL.mp4 59.1 MB 01. Introduction/1. Introduction to PostgreSQL.vtt 7.9 KB 01. Introduction/2. Understand the NorthWind Data Model.mp4 99.4 MB 01. Introduction/2. Understand the NorthWind Data Model.vtt 9 KB 01. Introduction/2.1 Northwind_data_Model.png.png 402.4 KB 01. Introduction/3. Install PostgreSQL.mp4 66.9 MB 01. Introduction/3. Install PostgreSQL.vtt 6.7 KB 01. Introduction/4. pgAdmin and psql.mp4 59.5 MB 01. Introduction/4. pgAdmin and psql.vtt 8.6 KB 01. Introduction/5. Setting Up NorthWind Database.mp4 61.4 MB 01. Introduction/5. Setting Up NorthWind Database.vtt 6.9 KB 01. Introduction/5.1 Northwind_schema_Postgres.sql.sql 9.9 KB 01. Introduction/5.2 Northwind_data_Postgres.sql.sql 152.9 KB 01. Introduction/5.3 Northwind_check_data.sql.sql 1.1 KB 02. Retrieve data using SELECT statement/1. What is SELECT .mp4 30.6 MB 02. Retrieve data using SELECT statement/1. What is SELECT .vtt 3.9 KB 02. Retrieve data using SELECT statement/2. Alias in SELECT.mp4 57 MB 02. Retrieve data using SELECT statement/2. Alias in SELECT.vtt 8 KB 02. Retrieve data using SELECT statement/3. Literals in SELECT.mp4 31.6 MB 02. Retrieve data using SELECT statement/3. Literals in SELECT.vtt 4 KB 02. Retrieve data using SELECT statement/3.1 2_3_sql.txt.txt 562 B 02. Retrieve data using SELECT statement/4. Operations among Columns.mp4 48.4 MB 02. Retrieve data using SELECT statement/4. Operations among Columns.vtt 7.3 KB 02. Retrieve data using SELECT statement/4.1 2_4_sql.txt.txt 257 B 02. Retrieve data using SELECT statement/5. Concatenation Operator.mp4 31.4 MB 02. Retrieve data using SELECT statement/5. Concatenation Operator.vtt 4.3 KB 03. Data Filter in SELECT/1. Usage of Where Clause.mp4 43.1 MB 03. Data Filter in SELECT/1. Usage of Where Clause.vtt 5.8 KB 03. Data Filter in SELECT/2. Logical Operator (AND, OR, NOT).mp4 47.2 MB 03. Data Filter in SELECT/2. Logical Operator (AND, OR, NOT).vtt 6.1 KB 03. Data Filter in SELECT/3. LIKE Operator.mp4 86.8 MB 03. Data Filter in SELECT/3. LIKE Operator.vtt 11.7 KB 03. Data Filter in SELECT/4. BETWEEN Operator.mp4 57.7 MB 03. Data Filter in SELECT/4. BETWEEN Operator.vtt 7.7 KB 03. Data Filter in SELECT/5. IN , NOT IN Operators.mp4 51 MB 03. Data Filter in SELECT/5. IN , NOT IN Operators.vtt 7.2 KB 03. Data Filter in SELECT/6. Comparison Operators.mp4 38.6 MB 03. Data Filter in SELECT/6. Comparison Operators.vtt 5.3 KB 03. Data Filter in SELECT/7. LIMIT and FETCH Operators.mp4 37.7 MB 03. Data Filter in SELECT/7. LIMIT and FETCH Operators.vtt 4.9 KB 04. Data Exploration using SELECT/1. DISTINCT CLause.mp4 40.5 MB 04. Data Exploration using SELECT/1. DISTINCT CLause.vtt 5.3 KB 04. Data Exploration using SELECT/1.1 4_1_sql.txt.txt 174 B 04. Data Exploration using SELECT/2. Ordering the data.mp4 36.4 MB 04. Data Exploration using SELECT/2. Ordering the data.vtt 5.4 KB 04. Data Exploration using SELECT/2.1 4_2_sql.txt.txt 366 B 04. Data Exploration using SELECT/3. Handling NULL data.mp4 24.2 MB 04. Data Exploration using SELECT/3. Handling NULL data.vtt 3.4 KB 04. Data Exploration using SELECT/3.1 4_3_sql.txt.txt 366 B 05. Joins/1. What is JOIN.mp4 29.9 MB 05. Joins/1. What is JOIN.vtt 3.4 KB 05. Joins/2. INNER Join.mp4 61.4 MB 05. Joins/2. INNER Join.vtt 7.8 KB 05. Joins/2.1 5_2_sql.txt.txt 328 B 05. Joins/3. LEFT OUTER Join.mp4 40.7 MB 05. Joins/3. LEFT OUTER Join.vtt 5.4 KB 05. Joins/3.1 5_3_sql.txt.txt 207 B 05. Joins/4. RIGHT OUTER Join.mp4 48 MB 05. Joins/4. RIGHT OUTER Join.vtt 6.3 KB 05. Joins/4.1 5_4_sql.txt.txt 207 B 05. Joins/5. FULL OUTER Join.mp4 49.6 MB 05. Joins/5. FULL OUTER Join.vtt 6.8 KB 05. Joins/5.1 5_5_sql.txt.txt 161 B 05. Joins/5.2 Data_Creation_script.sql.sql 2.2 KB 05. Joins/6. SELF Join.mp4 45.4 MB 05. Joins/6. SELF Join.vtt 5.8 KB 05. Joins/6.1 Data_Creation_script_1.sql.sql 1.3 KB 05. Joins/6.2 5_6_sql.txt.txt 286 B 05. Joins/7. CROSS Join.mp4 26.1 MB 05. Joins/7. CROSS Join.vtt 3.5 KB 05. Joins/7.1 5_7_sql.txt.txt 111 B 06. SET Operators/1. Basics of SET Operators.mp4 22.1 MB 06. SET Operators/1. Basics of SET Operators.vtt 3.3 KB 06. SET Operators/2. UNION Operator.mp4 37.6 MB 06. SET Operators/2. UNION Operator.vtt 6.2 KB 06. SET Operators/2.1 6_2_sql.txt.txt 385 B 06. SET Operators/3. INTERSECT Operator.mp4 21.8 MB 06. SET Operators/3. INTERSECT Operator.vtt 3.5 KB 06. SET Operators/3.1 6_3_sql.txt.txt 216 B 06. SET Operators/3.2 Data_Creation_script_2.sql.sql 455 B 06. SET Operators/4. EXCEPT Operator.mp4 15.4 MB 06. SET Operators/4. EXCEPT Operator.vtt 2.9 KB 06. SET Operators/4.1 6_4_sql.txt.txt 138 B 07. Aggregate Function/1. What is Aggregate Function.mp4 29.4 MB 07. Aggregate Function/1. What is Aggregate Function.vtt 3.8 KB 07. Aggregate Function/2. SUM, AVG, COUNT, MAX, MIN.mp4 63.8 MB 07. Aggregate Function/2. SUM, AVG, COUNT, MAX, MIN.vtt 12.3 KB 07. Aggregate Function/2.1 7_2_sql.txt.txt 945 B 08. Group Data/1. Basics of Grouping data.mp4 28.1 MB 08. Group Data/1. Basics of Grouping data.vtt 3.7 KB 08. Group Data/2. Group By and Having.mp4 97.9 MB 08. Group Data/2. Group By and Having.vtt 14.4 KB 08. Group Data/2.1 8_2_sql.txt.txt 1.3 KB 09. Build Complex Queries/1. How to construct complex queries.mp4 145.3 MB 09. Build Complex Queries/1. How to construct complex queries.vtt 17 KB 09. Build Complex Queries/1.1 9_1_sql.txt.txt 4 KB 10. String and Number Built in Functions/1. Length, Lower , Upper Functions.mp4 41.6 MB Udemy Course downloader.txt 94 B