[TutsNode.com] - Mastering SQL using Postgresql

  4. Writing Basic SQL Queries

   6. Filtering Data.srt

   9. Performing Aggregations.srt

   7. Joining Tables – Inner.srt

   1.1 Standard Transformations.html

   3.1 Define Problem Statement - Daily Product Revenue.html

   5.1 Selecting or Projecting Data.html

   7.1 Joining Tables - Inner.html

   4. Preparing Tables.srt

   10.1 Sorting Data.html

   12.1 Exercises - Basic SQL Queries.html

   3. Define Problem Statement – Daily Product Revenue.srt

   2. Overview of Data Model.srt

   9. Performing Aggregations.mp4

   7. Joining Tables – Inner.mp4

   5. Selecting or Projecting Data.mp4

   3. Define Problem Statement – Daily Product Revenue.mp4

   12. Exercises - Basic SQL Queries.mp4

  2. Getting Started

   2. Using psql.srt

   2.1 Using psql.html

   4.1 Setup SQL Workbench.html

   8. Loading Data - Docker.srt

   6. SQL Workbench Features.srt

   8.1 Loading Data - Docker.html

   9.1 Exercise - Loading Data.html

   7. Data Loading Utilities.srt

   1. Connecting to Database.srt

   2. Using psql.mp4

   7. Data Loading Utilities.mp4

   5. SQL Workbench and Postgres.mp4

   1. Connecting to Database.mp4

  8. Writing Advanced SQL Queries

   9.1 Cumulative or Moving Aggregations.html

   10. Analytic Functions – Windowing.srt

   8. Analytic Functions – Aggregations.srt

   4. CTAS - Create Table As Select.srt

   3. Overview of Sub Queries.srt

   2. Named Queries - Using WITH Clause.srt

   14. Exercises - Analytics Functions - Prerequisites.html

   8.1 Analytic Functions – Aggregations.html

   10.1 Analytic Functions – Windowing.html

   14.1 Exercises - Analytics Functions.html

   13.1 Ranking and Filtering - Recap.html

   6.1 Merging or Upserting Data.html

   5.1 Advanced DML Operations.html

   1.1 Overview of Views.html

   10. Analytic Functions – Windowing.mp4

   8. Analytic Functions – Aggregations.mp4

   6. Merging or Upserting Data.mp4

   9. Cumulative or Moving Aggregations.mp4

   3. Overview of Sub Queries.mp4

   2. Named Queries - Using WITH Clause.mp4

  5. Creating Tables and Indexes

   5. Managing Constraints.srt

   3. Adding or Modifying Columns.srt

   13. Exercise 2 - Adding Foreign Keys to Tables.html

   9. Truncating Tables.srt

   1. DDL - Data Definition Language.srt

   2.1 Overview of Data Types.html

   4.1 Different Types of Constraints.html

   5.1 Managing Constraints.html

   7.1 Indexes for Constraints.html

   9.1 Truncating Tables.html

   11.1 Exercises - Managing Database Objects.html

   11. Exercises - Managing Database Objects - Pre-requisites.html

   5. Managing Constraints.mp4

   3. Adding or Modifying Columns.mp4

   2. Overview of Data Types.mp4

   1. DDL - Data Definition Language.mp4

   10. Dropping Tables.mp4

  3. DML or CRUD Operations

   1.1 Database Operations - Overview.html

   4.1 Inserting Data.html

   6.1 Deleting Data.html

   8.1 Exercise - Database Operations.html

   3. Creating Table.srt

   8. Exercise - Database Operations.srt

   7. Overview of Transactions.srt

   8. Exercise - Database Operations.mp4

   5. Updating Data.mp4

   6. Deleting Data.mp4

   1. Database Operations - Overview.mp4

  1. Introduction - Resources and Tips

   4. Must Watch - Resources for the course.srt

   6. Must Watch - How to get support for this course using Q&A.srt

   2. For Udemy new comers - Interface to take the course.srt

   1. Must Watch - Introduction.mp4

   2. For Udemy new comers - Interface to take the course.mp4

   4. Must Watch - Resources for the course.mp4

  10. Bonus Material - Setup Postgres Database on Ubuntu VM

   10. Jupyter Lab and Postgres.srt

   2. Setup Postgres using Docker.srt

   5. Create Database and User.srt

   7. Setup SQL Workbench.srt

   4.1 Accessing Postgres using Docker CLI.html

   10.1 Jupyter Lab and Postgres.html

   1.1 Introduction - Setup Postgres Database.html

   6.1 Execute SQL Scripts.html

   3.1 Docker Cheat Sheet.html

   10. Jupyter Lab and Postgres.mp4

   9. SQL Workbench Features.mp4

   2. Setup Postgres using Docker.mp4

   7. Setup SQL Workbench.mp4

   1. Introduction - Setup Postgres Database.mp4

  9. Bonus Material - Setup Jupyter Lab on Ubuntu VM

   4. Provision Ubuntu VM from GCP.srt

   3. Overview of GCP Pricing.srt

   1. Signing for GCP.srt

   2.1 Overview of GCP Web Console.html

   3.1 Overview of GCP Pricing.html

   6.1 Validating Python.html

   5.1 Setup Docker.html

   5. Setup Docker.mp4

   3. Overview of GCP Pricing.mp4

   1. Signing for GCP.mp4

  6. Partitioning Tables and Indexes

   12.1 Exercises - Partitioned Tables.html

   9. Managing Partitions - Hash.srt

   6. Managing Partitions - Range.srt

   8. Hash Partitioning.srt

   10. Usage Scenarios.srt

   1. Overview of Partitioning.srt

   2.1 List Partitioning.html

   12. Exercise - Partitioning Tables.srt

   6.1 Managing Partitions - Range.html

   8.1 Hash Partitioning.html

   10.1 Usage Scenarios.html

   5.1 Range Partitioning.html

   3. Managing Partitions - List.mp4

   6. Managing Partitions - Range.mp4

   4. Manipulating Data.mp4

   2. List Partitioning.mp4

   5. Range Partitioning.mp4

   1. Overview of Partitioning.mp4

  7. Pre-defined Functions

   7. Using CASE and WHEN.srt

   6. Handling Null Values.srt

   8. Exercises - Pre-Defined Functions - Pre-requisites.html

   13. Exercise 5 - Get last 4 digits of unique ids.html

   9. Exercise 1 - Get number of users created per year.html

   10. Exercise 2 - Get the day name.html

   12. Exercise 4 - Get user count by gender.html

   2.1 String Manipulation Functions.html

   8.1 Exercises - Pre-Defined Functions.html

   5.1 Data Type Conversion.html

   7.1 Using CASE and WHEN.html

   1. Overview of Pre-Defined Functions.mp4

   6. Handling Null Values.mp4

   3. Date Manipulation Functions.mp4

 TutsNode.com.txt

 .pad

  1

  3

  5

  7

  9

  11

  13

  15

  17

  19

  21

  23

  25

  27

  29

  31

  33

  35

  37

  39

  41

  43

  45

  47

  49

  51

  53

  55

  57

  59

  61

  63

  65

  67

  69

  71

  73

  75

  77

  79

  81

  83

  85

  87

  89

 [TGx]Downloaded from torrentgalaxy.to .txt