Mastering SQL using Postgresql | C58BBAA8BC201C355D1ECC346A29338F16FCDB1D

Mastering SQL using Postgresql

Name	Mastering SQL using Postgresql	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	4.6 GB
Total Files	378
Last Seen	2025-05-25 23:48
Hash	C58BBAA8BC201C355D1ECC346A29338F16FCDB1D

/.../4. Writing Basic SQL Queries/
6. Filtering Data.mp4	123.6 MB
6. Filtering Data.srt	20.2 KB
10. Sorting Data.srt	19.5 KB
9. Performing Aggregations.srt	17.4 KB
8. Joining Tables – Outer.srt	11.1 KB
7. Joining Tables – Inner.srt	10.7 KB
1. Standard Transformations.srt	2.7 KB
1.1 Standard Transformations.html	0.2 KB
2.1 Overview of Data Model.html	0.2 KB
3.1 Define Problem Statement - Daily Product Revenue.html	0.2 KB
4.1 Preparing Tables.html	0.1 KB
5.1 Selecting or Projecting Data.html	0.2 KB
6.1 Filtering Data.html	0.1 KB
7.1 Joining Tables - Inner.html	0.2 KB
8.1 Joining Tables - Outer.html	0.2 KB
4. Preparing Tables.srt	8.1 KB
9.1 Performing Aggregations.html	0.2 KB
10.1 Sorting Data.html	0.1 KB
11.1 Solution - Daily Product Revenue.html	0.2 KB
12.1 Exercises - Basic SQL Queries.html	0.2 KB
5. Selecting or Projecting Data.srt	6.3 KB
3. Define Problem Statement – Daily Product Revenue.srt	6.0 KB
11. Solution – Daily Product Revenue.srt	5.9 KB
2. Overview of Data Model.srt	5.1 KB
10. Sorting Data.mp4	107.9 MB
9. Performing Aggregations.mp4	99.7 MB
8. Joining Tables – Outer.mp4	58.9 MB
7. Joining Tables – Inner.mp4	56.4 MB
4. Preparing Tables.mp4	43.2 MB
5. Selecting or Projecting Data.mp4	35.0 MB
11. Solution – Daily Product Revenue.mp4	33.6 MB
3. Define Problem Statement – Daily Product Revenue.mp4	26.6 MB
2. Overview of Data Model.mp4	26.6 MB
12. Exercises - Basic SQL Queries.mp4	25.2 MB
1. Standard Transformations.mp4	7.9 MB
/
TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/2. Getting Started/
3. Setup Postgres using Docker.srt	21.8 KB
2. Using psql.srt	18.2 KB
1.1 Connecting to Database.html	0.1 KB
2.1 Using psql.html	0.1 KB
3.1 Setup Postgres using Docker.html	0.1 KB
4.1 Setup SQL Workbench.html	0.1 KB
5.1 SQL Workbench and Postgres.html	0.1 KB
8. Loading Data - Docker.srt	12.8 KB
6.1 SQL Workbench Features.html	0.1 KB
6. SQL Workbench Features.srt	12.6 KB
7.1 Data Loading Utilities.html	0.1 KB
8.1 Loading Data - Docker.html	0.2 KB
9. Exercise - Loading Data.html	2.0 KB
9.1 Exercise - Loading Data.html	0.1 KB
3. Setup Postgres using Docker.mp4	118.0 MB
7. Data Loading Utilities.srt	11.6 KB
5. SQL Workbench and Postgres.srt	8.9 KB
1. Connecting to Database.srt	6.7 KB
4. Setup SQL Workbench.srt	6.2 KB
2. Using psql.mp4	99.8 MB
8. Loading Data - Docker.mp4	69.4 MB
7. Data Loading Utilities.mp4	55.7 MB
6. SQL Workbench Features.mp4	53.0 MB
5. SQL Workbench and Postgres.mp4	41.1 MB
4. Setup SQL Workbench.mp4	34.2 MB
1. Connecting to Database.mp4	29.6 MB
/.../8. Writing Advanced SQL Queries/
11. Analytic Functions – Ranking.srt	20.1 KB
9.1 Cumulative or Moving Aggregations.html	0.2 KB
5. Advanced DML Operations.srt	19.0 KB
10. Analytic Functions – Windowing.srt	18.9 KB
12. Analytic Functions - Filtering.srt	16.5 KB
8. Analytic Functions – Aggregations.srt	13.6 KB
6. Merging or Upserting Data.srt	12.5 KB
4. CTAS - Create Table As Select.srt	11.8 KB
9. Cumulative or Moving Aggregations.srt	11.0 KB
3. Overview of Sub Queries.srt	10.7 KB
7. Overview of Analytic Functions.srt	7.5 KB
2. Named Queries - Using WITH Clause.srt	6.1 KB
13. Ranking and Filtering - Recap.srt	5.0 KB
14. Exercises - Analytics Functions - Prerequisites.html	2.0 KB
2.1 Named Queries - Using WITH Clause.html	0.2 KB
8.1 Analytic Functions – Aggregations.html	0.2 KB
7.1 Overview of Analytic Functions.html	0.2 KB
10.1 Analytic Functions – Windowing.html	0.2 KB
11.1 Analytic Functions – Windowing.html	0.2 KB
14.1 Exercises - Analytics Functions.html	0.2 KB
12.1 Analytic Functions - Filtering.html	0.2 KB
13.1 Ranking and Filtering - Recap.html	0.2 KB
11.2 Analytic Functions – Ranking.html	0.2 KB
6.1 Merging or Upserting Data.html	0.2 KB
3.1 Overview of Sub Queries.html	0.2 KB
5.1 Advanced DML Operations.html	0.2 KB
4.1 CTAS - Create Table as Select.html	0.2 KB
1.1 Overview of Views.html	0.2 KB
5. Advanced DML Operations.mp4	91.7 MB
10. Analytic Functions – Windowing.mp4	86.3 MB
11. Analytic Functions – Ranking.mp4	76.2 MB
8. Analytic Functions – Aggregations.mp4	69.6 MB
12. Analytic Functions - Filtering.mp4	61.7 MB
6. Merging or Upserting Data.mp4	58.3 MB
4. CTAS - Create Table As Select.mp4	54.7 MB
9. Cumulative or Moving Aggregations.mp4	53.6 MB
1. Overview of Views.mp4	49.0 MB
3. Overview of Sub Queries.mp4	43.5 MB
7. Overview of Analytic Functions.mp4	40.0 MB
2. Named Queries - Using WITH Clause.mp4	28.7 MB
13. Ranking and Filtering - Recap.mp4	20.1 MB
/.../5. Creating Tables and Indexes/
8. Overview of Sequences.srt	20.0 KB
5. Managing Constraints.srt	16.1 KB
6. Indexes on Tables.srt	14.0 KB
3. Adding or Modifying Columns.srt	12.8 KB
4. Different Types of Constraints.srt	11.9 KB
13. Exercise 2 - Adding Foreign Keys to Tables.html	1.2 KB
2. Overview of Data Types.srt	11.1 KB
9. Truncating Tables.srt	10.0 KB
7. Indexes for Constraints.srt	8.5 KB
1. DDL - Data Definition Language.srt	8.4 KB
1.1 DDL – Data Definition Language.html	0.2 KB
2.1 Overview of Data Types.html	0.2 KB
3.1 Adding or Modifying Columns.html	0.2 KB
4.1 Different Types of Constraints.html	0.2 KB
10. Dropping Tables.srt	5.9 KB
5.1 Managing Constraints.html	0.2 KB
6.1 Indexes on Tables.html	0.2 KB
7.1 Indexes for Constraints.html	0.2 KB
8.1 Overview of Sequences.html	0.2 KB
9.1 Truncating Tables.html	0.2 KB
10.1 Dropping Tables.html	0.1 KB
11.1 Exercises - Managing Database Objects.html	0.2 KB
12. Exercise 1 - Adding Sequences.html	0.6 KB
11. Exercises - Managing Database Objects - Pre-requisites.html	3.7 KB
8. Overview of Sequences.mp4	113.0 MB
5. Managing Constraints.mp4	93.2 MB
6. Indexes on Tables.mp4	77.8 MB
3. Adding or Modifying Columns.mp4	75.6 MB
4. Different Types of Constraints.mp4	74.5 MB
2. Overview of Data Types.mp4	61.2 MB
9. Truncating Tables.mp4	57.5 MB
1. DDL - Data Definition Language.mp4	51.9 MB
7. Indexes for Constraints.mp4	46.2 MB
10. Dropping Tables.mp4	33.6 MB
/.../3. DML or CRUD Operations/
6. Deleting Data.srt	4.4 KB
1.1 Database Operations - Overview.html	0.2 KB
2.1 CRUD Operations.html	0.1 KB
4.1 Inserting Data.html	0.1 KB
5.1 Updating Data.html	0.1 KB
6.1 Deleting Data.html	0.1 KB
7.1 Overview of Transactions.html	0.2 KB
8.1 Exercise - Database Operations.html	0.2 KB
4. Inserting Data.srt	8.6 KB
3. Creating Table.srt	8.2 KB
5. Updating Data.srt	8.0 KB
8. Exercise - Database Operations.srt	7.2 KB
1. Database Operations - Overview.srt	3.5 KB
7. Overview of Transactions.srt	3.3 KB
3.1 Creating Table.html	0.1 KB
8. Exercise - Database Operations.mp4	48.4 MB
4. Inserting Data.mp4	48.3 MB
5. Updating Data.mp4	45.6 MB
3. Creating Table.mp4	38.9 MB
6. Deleting Data.mp4	20.2 MB
7. Overview of Transactions.mp4	15.0 MB
1. Database Operations - Overview.mp4	14.7 MB
2. CRUD Operations.mp4	13.6 MB
/.../1. Introduction - Resources and Tips/
5. Resources - PDF.html	0.2 KB
4. Must Watch - Resources for the course.srt	2.6 KB
5.1 Mastering SQL using Postgresql.pdf	722.2 KB
6. Must Watch - How to get support for this course using Q&A.srt	11.8 KB
1. Must Watch - Introduction.srt	11.7 KB
2. For Udemy new comers - Interface to take the course.srt	5.2 KB
3. For Udemy new comers - Navigating through the course.srt	3.1 KB
1. Must Watch - Introduction.mp4	67.0 MB
6. Must Watch - How to get support for this course using Q&A.mp4	57.4 MB
2. For Udemy new comers - Interface to take the course.mp4	30.8 MB
3. For Udemy new comers - Navigating through the course.mp4	20.6 MB
4. Must Watch - Resources for the course.mp4	17.1 MB
/.../10. Bonus Material - Setup Postgres Database on Ubuntu VM/
3. Docker Cheat Sheet.srt	19.6 KB
10. Jupyter Lab and Postgres.srt	16.2 KB
9. SQL Workbench Features.srt	12.6 KB
2. Setup Postgres using Docker.srt	10.9 KB
6. Execute SQL Scripts.srt	9.2 KB
5. Create Database and User.srt	8.2 KB
4. Accessing Postgres using Docker CLI.srt	7.4 KB
7. Setup SQL Workbench.srt	6.2 KB
1. Introduction - Setup Postgres Database.srt	2.3 KB
4.1 Accessing Postgres using Docker CLI.html	0.2 KB
8.1 SQL Workbench and Postgres.html	0.2 KB
10.1 Jupyter Lab and Postgres.html	0.2 KB
5.1 Create Database and User.html	0.2 KB
1.1 Introduction - Setup Postgres Database.html	0.2 KB
9.1 SQL Workbench Features.html	0.2 KB
6.1 Execute SQL Scripts.html	0.1 KB
7.1 Setup SQL Workbench.html	0.1 KB
3.1 Docker Cheat Sheet.html	0.1 KB
3. Docker Cheat Sheet.mp4	96.7 MB
10. Jupyter Lab and Postgres.mp4	83.2 MB
8. SQL Workbench and Postgres.mp4	82.1 MB
9. SQL Workbench Features.mp4	53.0 MB
6. Execute SQL Scripts.mp4	52.0 MB
2. Setup Postgres using Docker.mp4	51.3 MB
5. Create Database and User.mp4	42.3 MB
7. Setup SQL Workbench.mp4	34.2 MB
4. Accessing Postgres using Docker CLI.mp4	32.8 MB
1. Introduction - Setup Postgres Database.mp4	7.6 MB
/.../9. Bonus Material - Setup Jupyter Lab on Ubuntu VM/
7. Setup Jupyter Lab.srt	16.4 KB
4. Provision Ubuntu VM from GCP.srt	12.9 KB
5. Setup Docker.srt	12.5 KB
3. Overview of GCP Pricing.srt	9.4 KB
6. Validating Python.srt	5.9 KB
1. Signing for GCP.srt	5.4 KB
2. Overview of GCP Web Console.srt	3.6 KB
2.1 Overview of GCP Web Console.html	0.2 KB
4.1 Provision Ubuntu VM from GCP.html	0.2 KB
3.1 Overview of GCP Pricing.html	0.2 KB
1.1 Signing for GCP.html	0.1 KB
6.1 Validating Python.html	0.1 KB
7.1 Setup Jupyter Lab.html	0.1 KB
5.1 Setup Docker.html	0.1 KB
7. Setup Jupyter Lab.mp4	82.8 MB
5. Setup Docker.mp4	78.1 MB
4. Provision Ubuntu VM from GCP.mp4	56.1 MB
3. Overview of GCP Pricing.mp4	46.2 MB
6. Validating Python.mp4	36.0 MB
1. Signing for GCP.mp4	24.7 MB
2. Overview of GCP Web Console.mp4	14.9 MB
/.../6. Partitioning Tables and Indexes/
7. Repartitioning - Range.srt	13.0 KB
12.1 Exercises - Partitioned Tables.html	0.2 KB
3. Managing Partitions - List.srt	9.8 KB
9. Managing Partitions - Hash.srt	9.5 KB
11. Sub Partitioning.srt	9.2 KB
6. Managing Partitions - Range.srt	8.3 KB
4. Manipulating Data.srt	6.5 KB
8. Hash Partitioning.srt	6.3 KB
2. List Partitioning.srt	5.8 KB
10. Usage Scenarios.srt	5.3 KB
5. Range Partitioning.srt	3.9 KB
1. Overview of Partitioning.srt	2.3 KB
1.1 Overview of Partitioning.html	0.2 KB
2.1 List Partitioning.html	0.2 KB
3.1 Managing Partitions - List.html	0.2 KB
12. Exercise - Partitioning Tables.srt	2.8 KB
4.1 Manipulating Data.html	0.2 KB
6.1 Managing Partitions - Range.html	0.2 KB
7.1 Repartitioning - Range.html	0.2 KB
8.1 Hash Partitioning.html	0.2 KB
9.1 Managing Partitions - Hash.html	0.2 KB
10.1 Usage Scenarios.html	0.2 KB
11.1 Sub Partitioning.html	0.2 KB
5.1 Range Partitioning.html	0.2 KB
7. Repartitioning - Range.mp4	76.9 MB
3. Managing Partitions - List.mp4	55.2 MB
9. Managing Partitions - Hash.mp4	48.7 MB
6. Managing Partitions - Range.mp4	48.4 MB
11. Sub Partitioning.mp4	44.0 MB
4. Manipulating Data.mp4	32.3 MB
10. Usage Scenarios.mp4	29.6 MB
2. List Partitioning.mp4	29.3 MB
8. Hash Partitioning.mp4	27.9 MB
5. Range Partitioning.mp4	19.8 MB
12. Exercise - Partitioning Tables.mp4	10.3 MB
1. Overview of Partitioning.mp4	9.3 MB
/.pad/
0	0.1 KB
1	0.0 KB
2	231.7 KB
3	145.5 KB
4	824.1 KB
5	940.2 KB
6	807.0 KB
7	82.1 KB
8	599.7 KB
9	725.4 KB
10	702.4 KB
11	69.3 KB
12	696.2 KB
13	504.8 KB
14	892.7 KB
15	670.6 KB
16	369.6 KB
17	951.7 KB
18	971.0 KB
19	682.0 KB
20	898.3 KB
21	145.8 KB
22	126.2 KB
23	711.8 KB
24	878.4 KB
25	371.5 KB
26	133.4 KB
27	278.0 KB
28	232.0 KB
29	495.5 KB
30	947.9 KB
31	408.9 KB
32	900.4 KB
33	890.5 KB
34	458.7 KB
35	466.6 KB
36	383.8 KB
37	523.2 KB
38	110.0 KB
39	284.4 KB
40	616.3 KB
41	901.2 KB
42	913.4 KB
43	951.8 KB
44	391.1 KB
45	974.8 KB
46	976.0 KB
47	533.7 KB
48	26.5 KB
49	529.7 KB
50	656.5 KB
51	881.6 KB
52	633.2 KB
53	672.6 KB
54	803.5 KB
55	889.4 KB
56	968.8 KB
57	741.4 KB
58	670.4 KB
59	393.3 KB
60	401.1 KB
61	963.3 KB
62	968.1 KB
63	797.8 KB
64	194.3 KB
65	627.2 KB
66	762.1 KB
67	853.5 KB
68	93.3 KB
69	652.4 KB
70	252.9 KB
71	384.1 KB
72	634.5 KB
73	662.0 KB
74	1.0 MB
75	435.5 KB
76	773.1 KB
77	410.9 KB
78	809.4 KB
79	859.6 KB
80	109.3 KB
81	700.5 KB
82	716.3 KB
83	791.9 KB
84	20.0 KB
85	44.0 KB
86	899.7 KB
87	225.2 KB
88	116.0 KB
89	199.5 KB
90	512.6 KB
/.../7. Pre-defined Functions/
4. Overview of Numeric Functions.srt	10.5 KB
7. Using CASE and WHEN.srt	9.3 KB
1. Overview of Pre-Defined Functions.srt	7.8 KB
6. Handling Null Values.srt	6.3 KB
5. Data Type Conversion.srt	5.5 KB
8. Exercises - Pre-Defined Functions - Pre-requisites.html	4.4 KB
3. Date Manipulation Functions.srt	3.0 KB
13. Exercise 5 - Get last 4 digits of unique ids.html	1.1 KB
2. String Manipulation Functions.srt	2.1 KB
9. Exercise 1 - Get number of users created per year.html	0.9 KB
11. Exercise 3 - Get user details added in 2019.html	0.8 KB
10. Exercise 2 - Get the day name.html	0.7 KB
14. Exercise 6 - Get user count by country code.html	0.7 KB
12. Exercise 4 - Get user count by gender.html	0.7 KB
1.1 Overview of Pre-Defined Functions.html	0.2 KB
2.1 String Manipulation Functions.html	0.2 KB
3.1 Date Manipulation Functions.html	0.2 KB
8.1 Exercises - Pre-Defined Functions.html	0.2 KB
4.1 Overview of Numeric Functions.html	0.2 KB
5.1 Data Type Conversion.html	0.1 KB
6.1 Handling NULL Values.html	0.1 KB
7.1 Using CASE and WHEN.html	0.1 KB
7. Using CASE and WHEN.mp4	47.8 MB
1. Overview of Pre-Defined Functions.mp4	43.4 MB
4. Overview of Numeric Functions.mp4	42.4 MB
6. Handling Null Values.mp4	28.1 MB
5. Data Type Conversion.mp4	24.4 MB
3. Date Manipulation Functions.mp4	12.7 MB
2. String Manipulation Functions.mp4	8.2 MB
Total files 378