Udemy - PostgreSQL Bootcamp Go From Beginner to Advanced, 60+hours (10.2023)
File List
| File | Size |
|---|---|
| 01. Welcome/1. Course Introduction.mp4 | 2.06 MB |
| 01. Welcome/1. Course Introduction.vtt | 1.5 KB |
| 01. Welcome/2. countries_iso_codes.csv | 11.45 KB |
| 01. Welcome/2. northwind.sql | 341.51 KB |
| 01. Welcome/2. Sample Data Files.html | 492 B |
| 01. Welcome/2. sample_data.zip | 1.41 MB |
| 01. Welcome/2. trades.sql | 510.16 KB |
| 02. Introduction to PostgreSQL/1. Installing PostgreSQL on Mac.mp4 | 5.29 MB |
| 02. Introduction to PostgreSQL/1. Installing PostgreSQL on Mac.vtt | 2.59 KB |
| 02. Introduction to PostgreSQL/2. Installing PostgreSQL on Windows.mp4 | 25.65 MB |
| 02. Introduction to PostgreSQL/2. Installing PostgreSQL on Windows.vtt | 7.21 KB |
| 02. Introduction to PostgreSQL/3. Configure pgAdmin 4 client.mp4 | 7.53 MB |
| 02. Introduction to PostgreSQL/3. Configure pgAdmin 4 client.vtt | 2.66 KB |
| 02. Introduction to PostgreSQL/4. Creating a Database User.mp4 | 11.54 MB |
| 02. Introduction to PostgreSQL/4. Creating a Database User.vtt | 5.29 KB |
| 02. Introduction to PostgreSQL/5. Creating a Database.mp4 | 10.55 MB |
| 02. Introduction to PostgreSQL/5. Creating a Database.vtt | 3.39 KB |
| 02. Introduction to PostgreSQL/6. Running a query in pgAdmin tool.mp4 | 5.7 MB |
| 02. Introduction to PostgreSQL/6. Running a query in pgAdmin tool.vtt | 2.71 KB |
| 02. Introduction to PostgreSQL/7. Install sample data files on server.mp4 | 10.51 MB |
| 02. Introduction to PostgreSQL/7. Install sample data files on server.vtt | 3.06 KB |
| 02. Introduction to PostgreSQL/7. sample_data.zip | 1.41 MB |
| 02. Introduction to PostgreSQL/8. Install Human Resources (hr) database.mp4 | 8.17 MB |
| 02. Introduction to PostgreSQL/8. Install Human Resources (hr) database.vtt | 2.52 KB |
| 02. Introduction to PostgreSQL/8. sample_data.zip | 1.41 MB |
| 02. Introduction to PostgreSQL/9. Install sample stocks market data.mp4 | 28.3 MB |
| 02. Introduction to PostgreSQL/9. Install sample stocks market data.vtt | 2.51 KB |
| 02. Introduction to PostgreSQL/9. sample_data.zip | 1.41 MB |
| 02. Introduction to PostgreSQL/10. Install northwind database.mp4 | 31.58 MB |
| 02. Introduction to PostgreSQL/10. Install northwind database.vtt | 7.04 KB |
| 02. Introduction to PostgreSQL/10. northwind.sql | 341.51 KB |
| 02. Introduction to PostgreSQL/11. Drop a database.mp4 | 13.55 MB |
| 02. Introduction to PostgreSQL/11. Drop a database.vtt | 4.5 KB |
| 03. Creating and Modifying Tables/1. Movie Database Structure.mp4 | 12.18 MB |
| 03. Creating and Modifying Tables/1. Movie Database Structure.vtt | 4.43 KB |
| 03. Creating and Modifying Tables/2. Creating the movie database and a actors table.mp4 | 20.52 MB |
| 03. Creating and Modifying Tables/2. Creating the movie database and a actors table.vtt | 6.73 KB |
| 03. Creating and Modifying Tables/2. q_creating movies database and actors table.sql | 186 B |
| 03. Creating and Modifying Tables/3. Creating the directors table.mp4 | 14.4 MB |
| 03. Creating and Modifying Tables/3. Creating the directors table.vtt | 3.38 KB |
| 03. Creating and Modifying Tables/3. q_creating the directors table.sql | 227 B |
| 03. Creating and Modifying Tables/4. Creating the movies table with a foreign key.mp4 | 20.44 MB |
| 03. Creating and Modifying Tables/4. Creating the movies table with a foreign key.vtt | 6.29 KB |
| 03. Creating and Modifying Tables/4. q_creating the movies table with a foreign key.sql | 258 B |
| 03. Creating and Modifying Tables/5. Creating the movies_revenues table.mp4 | 13.09 MB |
| 03. Creating and Modifying Tables/5. Creating the movies_revenues table.vtt | 3.8 KB |
| 03. Creating and Modifying Tables/5. q_creating the movies_revenues table.sql | 216 B |
| 03. Creating and Modifying Tables/6. Creating a Junction table with movies and actors tables.mp4 | 15.6 MB |
| 03. Creating and Modifying Tables/6. Creating a Junction table with movies and actors tables.vtt | 4.48 KB |
| 03. Creating and Modifying Tables/6. q_creating a junction table with movies and actors table.sql | 184 B |
| 03. Creating and Modifying Tables/7. Install sample data for 'movies' database.mp4 | 41.02 MB |
| 03. Creating and Modifying Tables/7. Install sample data for 'movies' database.vtt | 6.97 KB |
| 03. Creating and Modifying Tables/7. sample_data.zip | 1.41 MB |
| 03. Creating and Modifying Tables/8. 2021-04-01_15-33-06-faabd956903cfa4c427d171bb035faff.png | 98.38 KB |
| 03. Creating and Modifying Tables/8. 2021-04-01_15-33-22-3cc7c77c6f93d169a2ca456613da1080.png | 58.46 KB |
| 03. Creating and Modifying Tables/8. Create a sample Database mydata.html | 1.22 KB |
| 03. Creating and Modifying Tables/9. Using pgAdmin - Create and modify a table.mp4 | 21.17 MB |
| 03. Creating and Modifying Tables/9. Using pgAdmin - Create and modify a table.vtt | 5.72 KB |
| 03. Creating and Modifying Tables/10. Using pgAdmin - View table structure, and create column.mp4 | 21.61 MB |
| 03. Creating and Modifying Tables/10. Using pgAdmin - View table structure, and create column.vtt | 6.55 KB |
| 03. Creating and Modifying Tables/11. Using pgAdmin - Rename, delete and change the data type of a column.mp4 | 56.72 MB |
| 03. Creating and Modifying Tables/11. Using pgAdmin - Rename, delete and change the data type of a column.vtt | 8.01 KB |
| 03. Creating and Modifying Tables/12. Deleting tables from a database.mp4 | 9.65 MB |
| 03. Creating and Modifying Tables/12. Deleting tables from a database.vtt | 3.12 KB |
| 03. Creating and Modifying Tables/12. q_deleting tables from a database.sql | 119 B |
| 04. Modifying Data in the tables/1. Insert a data into table.mp4 | 18.3 MB |
| 04. Modifying Data in the tables/1. Insert a data into table.vtt | 5.22 KB |
| 04. Modifying Data in the tables/1. q_insert data into table.sql | 267 B |
| 04. Modifying Data in the tables/2. Insert multiple records into a table.mp4 | 9.55 MB |
| 04. Modifying Data in the tables/2. Insert multiple records into a table.vtt | 3.03 KB |
| 04. Modifying Data in the tables/2. q_insert multiple records into a table.sql | 137 B |
| 04. Modifying Data in the tables/3. Insert a data that had quotes.mp4 | 7.52 MB |
| 04. Modifying Data in the tables/3. Insert a data that had quotes.vtt | 2.31 KB |
| 04. Modifying Data in the tables/3. q_insert a data that had quotes.sql | 93 B |
| 04. Modifying Data in the tables/4. q_use RETURNING to get info on added rows.sql | 224 B |
| 04. Modifying Data in the tables/4. Use RETURNING to get info on added rows.mp4 | 11.07 MB |
| 04. Modifying Data in the tables/4. Use RETURNING to get info on added rows.vtt | 3.36 KB |
| 04. Modifying Data in the tables/5. q_update_data_in_a_table.sql | 165 B |
| 04. Modifying Data in the tables/5. Update data in a table.mp4 | 18.84 MB |
| 04. Modifying Data in the tables/5. Update data in a table.vtt | 3.58 KB |
| 04. Modifying Data in the tables/6. q_updating_a_row_and_returning_the_updated_row.sql | 102 B |
| 04. Modifying Data in the tables/6. Updating a row and returning the updated row.mp4 | 10.84 MB |
| 04. Modifying Data in the tables/6. Updating a row and returning the updated row.vtt | 2.6 KB |
| 04. Modifying Data in the tables/7. q_updating_all_records_in_a_table.sql | 62 B |
| 04. Modifying Data in the tables/7. Updating all records in a table.mp4 | 13.08 MB |
| 04. Modifying Data in the tables/7. Updating all records in a table.vtt | 3.55 KB |
| 04. Modifying Data in the tables/8. Delete data from a table.mp4 | 13.12 MB |
| 04. Modifying Data in the tables/8. Delete data from a table.vtt | 3.65 KB |
| 04. Modifying Data in the tables/8. q_delete_data_from_a_table.sql | 96 B |
| 04. Modifying Data in the tables/9. q_upsert.sql | 618 B |
| 04. Modifying Data in the tables/9. Using UPSERT.mp4 | 38.29 MB |
| 04. Modifying Data in the tables/9. Using UPSERT.vtt | 12.27 KB |
| 05. Querying Data/1. Select all data from a table.mp4 | 39.15 MB |
| 05. Querying Data/1. Select all data from a table.vtt | 7.45 KB |
| 05. Querying Data/2. Selecting specific columns from a table.mp4 | 15.86 MB |
| 05. Querying Data/2. Selecting specific columns from a table.vtt | 4.31 KB |
| 05. Querying Data/3. Adding Aliases to columns in a table.mp4 | 48.37 MB |
| 05. Querying Data/3. Adding Aliases to columns in a table.vtt | 11.12 KB |
| 05. Querying Data/4. Using SELECT statement for expressions.mp4 | 13.45 MB |
| 05. Querying Data/4. Using SELECT statement for expressions.vtt | 3.59 KB |
Trackers
No trackers found.