▲
0
0

report

Udemy - Mastering SQL using Postgresql

seeders: 0
leechers: 0
Download torrent
Added 5 years ago by tutsnode in Other
Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - Mastering SQL using Postgresql (Size: 4.25 GB)
  .pad
  0 136 B
  1 36 B
  2 226.29 KB
  3 142.1 KB
  4 804.83 KB
  5 918.21 KB
  6 788.08 KB
  7 80.18 KB
  8 585.61 KB
  9 708.36 KB
  10 685.96 KB
  11 67.7 KB
  12 679.9 KB
  13 492.95 KB
  14 871.77 KB
  15 654.89 KB
  16 360.92 KB
  17 929.35 KB
  18 948.25 KB
  19 666.02 KB
  20 877.25 KB
  21 142.43 KB
  22 123.21 KB
  23 695.15 KB
  24 857.78 KB
  25 362.8 KB
  26 130.27 KB
  27 271.47 KB
  28 226.53 KB
  29 483.9 KB
  30 925.65 KB
  31 399.34 KB
  32 879.25 KB
  33 869.67 KB
  34 447.99 KB
  35 455.66 KB
  36 374.8 KB
  37 510.94 KB
  38 107.44 KB
  39 277.78 KB
  40 601.83 KB
  41 880.08 KB
  42 892.01 KB
  43 929.49 KB
  44 381.92 KB
  45 951.92 KB
  46 953.15 KB
  47 521.22 KB
  48 25.91 KB
  49 517.31 KB
  50 641.16 KB
  51 860.97 KB
  52 618.33 KB
  53 656.85 KB
  54 784.63 KB
  55 868.51 KB
  56 946.04 KB
  57 724.03 KB
  58 654.73 KB
  59 384.06 KB
  60 391.73 KB
  61 940.73 KB
  62 945.38 KB
  63 779.05 KB
  64 189.72 KB
  65 612.47 KB
  66 744.28 KB
  67 833.47 KB
  68 91.07 KB
  69 637.12 KB
  70 246.98 KB
  71 375.13 KB
  72 619.66 KB
  73 646.47 KB
  74 1013.31 KB
  75 425.28 KB
  76 755.01 KB
  77 401.31 KB
  78 790.42 KB
  79 839.46 KB
  80 106.78 KB
  81 684.08 KB
  82 699.54 KB
  83 773.38 KB
  84 19.53 KB
  85 43 KB
  86 878.62 KB
  87 219.88 KB
  88 113.24 KB
  89 194.83 KB
  90 500.59 KB
  TutsNode.com.txt 63 B
  [TGx]Downloaded from torrentgalaxy.to .txt 585 B
  [TutsNode.com] - Mastering SQL using Postgresql
  1. Introduction - Resources and Tips
  1. Must Watch - Introduction.mp4 63.86 MB
  1. Must Watch - Introduction.srt 11.42 KB
  2. For Udemy new comers - Interface to take the course.mp4 29.4 MB
  2. For Udemy new comers - Interface to take the course.srt 5.09 KB
  3. For Udemy new comers - Navigating through the course.mp4 19.61 MB
  3. For Udemy new comers - Navigating through the course.srt 3.04 KB
  4. Must Watch - Resources for the course.mp4 16.33 MB
  4. Must Watch - Resources for the course.srt 2.49 KB
  5. Resources - PDF.html 219 B
  5.1 Mastering SQL using Postgresql.pdf 705.27 KB
  6. Must Watch - How to get support for this course using Q&A.mp4 54.73 MB
  6. Must Watch - How to get support for this course using Q&A.srt 11.5 KB
  10. Bonus Material - Setup Postgres Database on Ubuntu VM
  1. Introduction - Setup Postgres Database.mp4 7.28 MB
  1. Introduction - Setup Postgres Database.srt 2.29 KB
  1.1 Introduction - Setup Postgres Database.html 152 B
  10. Jupyter Lab and Postgres.mp4 79.33 MB
  10. Jupyter Lab and Postgres.srt 15.85 KB
  10.1 Jupyter Lab and Postgres.html 155 B
  2. Setup Postgres using Docker.mp4 48.9 MB
  2. Setup Postgres using Docker.srt 10.66 KB
  3. Docker Cheat Sheet.mp4 92.23 MB
  3. Docker Cheat Sheet.srt 19.17 KB
  3.1 Docker Cheat Sheet.html 147 B
  4. Accessing Postgres using Docker CLI.mp4 31.24 MB
  4. Accessing Postgres using Docker CLI.srt 7.2 KB
  4.1 Accessing Postgres using Docker CLI.html 164 B
  5. Create Database and User.mp4 40.36 MB
  5. Create Database and User.srt 8 KB
  5.1 Create Database and User.html 153 B
  6. Execute SQL Scripts.mp4 49.63 MB
  6. Execute SQL Scripts.srt 9.01 KB
  6.1 Execute SQL Scripts.html 148 B
  7. Setup SQL Workbench.mp4 32.62 MB
  7. Setup SQL Workbench.srt 6.08 KB
  7.1 Setup SQL Workbench.html 148 B
  8. SQL Workbench and Postgres.mp4 78.34 MB
  8.1 SQL Workbench and Postgres.html 155 B
  9. SQL Workbench Features.mp4 50.56 MB
  9. SQL Workbench Features.srt 12.3 KB
  9.1 SQL Workbench Features.html 151 B
  2. Getting Started
  1. Connecting to Database.mp4 28.27 MB
  1. Connecting to Database.srt 6.56 KB
  1.1 Connecting to Database.html 143 B
  2. Using psql.mp4 95.21 MB
  2. Using psql.srt 17.76 KB
  2.1 Using psql.html 131 B
  3. Setup Postgres using Docker.mp4 112.57 MB
  3. Setup Postgres using Docker.srt 21.3 KB
  3.1 Setup Postgres using Docker.html 148 B
  4. Setup SQL Workbench.mp4 32.62 MB
  4. Setup SQL Workbench.srt 6.08 KB
  4.1 Setup SQL Workbench.html 140 B
  5. SQL Workbench and Postgres.mp4 39.23 MB
  5. SQL Workbench and Postgres.srt 8.71 KB
  5.1 SQL Workbench and Postgres.html 147 B
  6. SQL Workbench Features.mp4 50.56 MB
  6. SQL Workbench Features.srt 12.3 KB
  6.1 SQL Workbench Features.html 143 B
  7. Data Loading Utilities.mp4 53.1 MB
  7. Data Loading Utilities.srt 11.29 KB
  7.1 Data Loading Utilities.html 143 B
  8. Loading Data - Docker.mp4 66.14 MB
  8. Loading Data - Docker.srt 12.47 KB
  8.1 Loading Data - Docker.html 152 B
  9. Exercise - Loading Data.html 1.95 KB
  9.1 Exercise - Loading Data.html 142 B
  3. DML or CRUD Operations
  1. Database Operations - Overview.mp4 13.98 MB
  1. Database Operations - Overview.srt 3.39 KB
  1.1 Database Operations - Overview.html 159 B
  2. CRUD Operations.mp4 12.96 MB
  2.1 CRUD Operations.html 143 B
  3. Creating Table.mp4 37.08 MB
  3. Creating Table.srt 7.96 KB
  3.1 Creating Table.html 142 B
  4. Inserting Data.mp4 46.09 MB
  4. Inserting Data.srt 8.42 KB
  4.1 Inserting Data.html 142 B
  5. Updating Data.mp4 43.49 MB
  5. Updating Data.srt 7.84 KB
  5.1 Updating Data.html 141 B
  6. Deleting Data.mp4 19.23 MB
  6. Deleting Data.srt 4.29 KB
  6.1 Deleting Data.html 141 B
  7. Overview of Transactions.mp4 14.32 MB
  7. Overview of Transactions.srt 3.2 KB
  7.1 Overview of Transactions.html 152 B
  8. Exercise - Database Operations.mp4 46.14 MB
  8. Exercise - Database Operations.srt 7.03 KB
  8.1 Exercise - Database Operations.html 157 B
  4. Writing Basic SQL Queries
  1. Standard Transformations.mp4 7.51 MB
  1. Standard Transformations.srt 2.65 KB
  1.1 Standard Transformations.html 155 B
  10. Sorting Data.mp4 102.86 MB
  10. Sorting Data.srt 19 KB
  10.1 Sorting Data.html 143 B
  11. Solution – Daily Product Revenue.mp4 32.08 MB
  11. Solution – Daily Product Revenue.srt 5.79 KB
  11.1 Solution - Daily Product Revenue.html 161 B
  12. Exercises - Basic SQL Queries.mp4 24.01 MB
  12.1 Exercises - Basic SQL Queries.html 158 B
  2. Overview of Data Model.mp4 25.37 MB
  2. Overview of Data Model.srt 4.98 KB
  2.1 Overview of Data Model.html 153 B
  3. Define Problem Statement – Daily Product Revenue.mp4 25.39 MB
  3. Define Problem Statement – Daily Product Revenue.srt 5.9 KB
  3.1 Define Problem Statement - Daily Product Revenue.html 155 B
  4. Preparing Tables.mp4 41.16 MB
  4. Preparing Tables.srt 7.9 KB
  4.1 Preparing Tables.html 147 B
  5. Selecting or Projecting Data.mp4 33.36 MB
  5. Selecting or Projecting Data.srt 6.2 KB
  5.1 Selecting or Projecting Data.html 159 B
  6. Filtering Data.mp4 117.92 MB
  6. Filtering Data.srt 19.74 KB
  6.1 Filtering Data.html 145 B
  7. Joining Tables – Inner.mp4 53.78 MB
  7. Joining Tables – Inner.srt 10.43 KB
  7.1 Joining Tables - Inner.html 151 B
  8. Joining Tables – Outer.mp4 56.16 MB
  8. Joining Tables – Outer.srt 10.79 KB
  8.1 Joining Tables - Outer.html 151 B
  9. Performing Aggregations.mp4 95.1 MB
  9. Performing Aggregations.srt 17.01 KB
  9.1 Performing Aggregations.html 154 B
  5. Creating Tables and Indexes
  1. DDL - Data Definition Language.mp4 49.5 MB
  1. DDL - Data Definition Language.srt 8.17 KB
  1.1 DDL – Data Definition Language.html 158 B
  10. Dropping Tables.mp4 32.08 MB
  10. Dropping Tables.srt 5.8 KB
  10.1 Dropping Tables.html 148 B
  11. Exercises - Managing Database Objects - Pre-requisites.html 3.62 KB
  11.1 Exercises - Managing Database Objects.html 162 B
  12. Exercise 1 - Adding Sequences.html 626 B
  13. Exercise 2 - Adding Foreign Keys to Tables.html 1.21 KB
  2. Overview of Data Types.mp4 58.32 MB
  2. Overview of Data Types.srt 10.87 KB
  2.1 Overview of Data Types.html 155 B
  3. Adding or Modifying Columns.mp4 72.09 MB
  3. Adding or Modifying Columns.srt 12.46 KB
  3.1 Adding or Modifying Columns.html 160 B
  4. Different Types of Constraints.mp4 71.07 MB
  4. Different Types of Constraints.srt 11.63 KB
  4.1 Different Types of Constraints.html 163 B
  5. Managing Constraints.mp4 88.92 MB
  5. Managing Constraints.srt 15.7 KB
  5.1 Managing Constraints.html 153 B
  6. Indexes on Tables.mp4 74.15 MB
  6. Indexes on Tables.srt 13.68 KB
  6.1 Indexes on Tables.html 150 B
  7. Indexes for Constraints.mp4 44.07 MB
  7. Indexes for Constraints.srt 8.28 KB
  7.1 Indexes for Constraints.html 156 B
  8. Overview of Sequences.mp4 107.76 MB
  8. Overview of Sequences.srt 19.53 KB
  8.1 Overview of Sequences.html 154 B
  9. Truncating Tables.mp4 54.87 MB
  9. Truncating Tables.srt 9.74 KB
  9.1 Truncating Tables.html 150 B
  6. Partitioning Tables and Indexes
  1. Overview of Partitioning.mp4 8.89 MB
  1. Overview of Partitioning.srt 2.24 KB
  1.1 Overview of Partitioning.html 161 B
  10. Usage Scenarios.mp4 28.19 MB
  10. Usage Scenarios.srt 5.16 KB
  10.1 Usage Scenarios.html 152 B
  11. Sub Partitioning.mp4 41.97 MB
  11. Sub Partitioning.srt 8.94 KB
  11.1 Sub Partitioning.html 153 B
  12. Exercise - Partitioning Tables.mp4 9.79 MB
  12. Exercise - Partitioning Tables.srt 2.69 KB
  12.1 Exercises - Partitioned Tables.html 166 B
  2. List Partitioning.mp4 27.91 MB
  2. List Partitioning.srt 5.62 KB
  2.1 List Partitioning.html 154 B
  3. Managing Partitions - List.mp4 52.61 MB
  3. Managing Partitions - List.srt 9.54 KB
  3.1 Managing Partitions - List.html 161 B
  4. Manipulating Data.mp4 30.81 MB
  4. Manipulating Data.srt 6.33 KB
  4.1 Manipulating Data.html 154 B
  5. Range Partitioning.mp4 18.9 MB
  5. Range Partitioning.srt 3.78 KB
  5.1 Range Partitioning.html 155 B
  6. Managing Partitions - Range.mp4 46.13 MB
  6. Managing Partitions - Range.srt 8.12 KB
  6.1 Managing Partitions - Range.html 162 B
  7. Repartitioning - Range.mp4 73.36 MB
  7. Repartitioning - Range.srt 12.69 KB
  7.1 Repartitioning - Range.html 157 B
  8. Hash Partitioning.mp4 26.63 MB
  8. Hash Partitioning.srt 6.12 KB
  8.1 Hash Partitioning.html 154 B
  9. Managing Partitions - Hash.mp4 46.41 MB
  9. Managing Partitions - Hash.srt 9.3 KB
  9.1 Managing Partitions - Hash.html 161 B
  7. Pre-defined Functions
  1. Overview of Pre-Defined Functions.mp4 41.37 MB
  1. Overview of Pre-Defined Functions.srt 7.64 KB
  1.1 Overview of Pre-Defined Functions.html 158 B
  10. Exercise 2 - Get the day name.html 719 B
  11. Exercise 3 - Get user details added in 2019.html 777 B
  12. Exercise 4 - Get user count by gender.html 668 B
  13. Exercise 5 - Get last 4 digits of unique ids.html 1.1 KB
  14. Exercise 6 - Get user count by country code.html 682 B
  2. String Manipulation Functions.mp4 7.81 MB
  2. String Manipulation Functions.srt 2.03 KB
  2.1 String Manipulation Functions.html 155 B
  3. Date Manipulation Functions.mp4 12.14 MB
  3. Date Manipulation Functions.srt 2.96 KB
  3.1 Date Manipulation Functions.html 153 B
  4. Overview of Numeric Functions.mp4 40.4 MB
  4. Overview of Numeric Functions.srt 10.27 KB
  4.1 Overview of Numeric Functions.html 155 B
  5. Data Type Conversion.mp4 23.26 MB
  5. Data Type Conversion.srt 5.38 KB
  5.1 Data Type Conversion.html 146 B
  6. Handling Null Values.mp4 26.76 MB
  6. Handling Null Values.srt 6.11 KB
  6.1 Handling NULL Values.html 146 B
  7. Using CASE and WHEN.mp4 45.63 MB
  7. Using CASE and WHEN.srt 9.13 KB
  7.1 Using CASE and WHEN.html 145 B
  8. Exercises - Pre-Defined Functions - Pre-requisites.html 4.27 KB
  8.1 Exercises - Pre-Defined Functions.html 156 B
  9. Exercise 1 - Get number of users created per year.html 875 B
  8. Writing Advanced SQL Queries
  1. Overview of Views.mp4 46.73 MB
  1.1 Overview of Views.html 151 B
  10. Analytic Functions – Windowing.mp4 82.31 MB
  10. Analytic Functions – Windowing.srt 18.48 KB
  10.1 Analytic Functions – Windowing.html 162 B
  11. Analytic Functions – Ranking.mp4 72.65 MB
  11. Analytic Functions – Ranking.srt 19.67 KB
  11.1 Analytic Functions – Windowing.html 162 B
  11.2 Analytic Functions – Ranking.html 160 B
  12. Analytic Functions - Filtering.mp4 58.88 MB
  12. Analytic Functions - Filtering.srt 16.08 KB
  12.1 Analytic Functions - Filtering.html 161 B
  13. Ranking and Filtering - Recap.mp4 19.18 MB
  13. Ranking and Filtering - Recap.srt 4.91 KB
  13.1 Ranking and Filtering - Recap.html 161 B
  14. Exercises - Analytics Functions - Prerequisites.html 1.91 KB
  14.1 Exercises - Analytics Functions.html 162 B
  2. Named Queries - Using WITH Clause.mp4 27.38 MB
  2. Named Queries - Using WITH Clause.srt 5.93 KB
  2.1 Named Queries - Using WITH Clause.html 165 B
  3. Overview of Sub Queries.mp4 41.49 MB
  3. Overview of Sub Queries.srt 10.5 KB
  3.1 Overview of Sub Queries.html 157 B
  4. CTAS - Create Table As Select.mp4 52.14 MB
  4. CTAS - Create Table As Select.srt 11.55 KB
  4.1 CTAS - Create Table as Select.html 156 B
  5. Advanced DML Operations.mp4 87.43 MB
  5. Advanced DML Operations.srt 18.53 KB
  5.1 Advanced DML Operations.html 157 B
  6. Merging or Upserting Data.mp4 55.65 MB
  6. Merging or Upserting Data.srt 12.2 KB
  6.1 Merging or Upserting Data.html 159 B
  7. Overview of Analytic Functions.mp4 38.15 MB
  7. Overview of Analytic Functions.srt 7.29 KB
  7.1 Overview of Analytic Functions.html 164 B
  8. Analytic Functions – Aggregations.mp4 66.35 MB
  8. Analytic Functions – Aggregations.srt 13.31 KB
  8.1 Analytic Functions – Aggregations.html 165 B
  9. Cumulative or Moving Aggregations.mp4 51.15 MB
  9. Cumulative or Moving Aggregations.srt 10.77 KB
  9.1 Cumulative or Moving Aggregations.html 167 B
  9. Bonus Material - Setup Jupyter Lab on Ubuntu VM
  1. Signing for GCP.mp4 23.58 MB
  1. Signing for GCP.srt 5.32 KB
  1.1 Signing for GCP.html 146 B
  2. Overview of GCP Web Console.mp4 14.24 MB
  2. Overview of GCP Web Console.srt 3.49 KB
  2.1 Overview of GCP Web Console.html 157 B
  3. Overview of GCP Pricing.mp4 44.07 MB
  3. Overview of GCP Pricing.srt 9.22 KB
  3.1 Overview of GCP Pricing.html 151 B
  4. Provision Ubuntu VM from GCP.mp4 53.53 MB
  4. Provision Ubuntu VM from GCP.srt 12.57 KB
  4.1 Provision Ubuntu VM from GCP.html 153 B
  5. Setup Docker.mp4 74.52 MB
  5. Setup Docker.srt 12.17 KB
  5.1 Setup Docker.html 140 B
  6. Validating Python.mp4 34.29 MB
  6. Validating Python.srt 5.79 KB
  6.1 Validating Python.html 145 B
  7. Setup Jupyter Lab.mp4 78.93 MB
  7. Setup Jupyter Lab.srt 16.05 KB
  7.1 Setup Jupyter Lab.html 145 B

Description



Description

About Postgresql

Postgresql is one of the leading datatabase. It is an open source database and used for different types of applications.

Web Applications
Mobile Applications
Data Logging Applications

Even though it is relational database and best suited for transactional systems (OLTP), it’s flavors such as Redshift are extensively used for Analytical or Decision Support Systems.

Course Details

This course is primarily designed to go through basic and advanced SQL using Postgres Database. You will be learning following aspects of SQL as well as Postgres Database.

Setup Postgres Database using Docker
Connect to Postgres using different interfaces such as psql, SQL Workbench, Jupyter with SQL magic etc.
Understand utilities to load the data
Performing CRUD or DML Operations
Writing basic SQL Queries such as filtering, joins, aggregations, sorting etc
Creating tables, constraints and indexes
Different partitioning strategies while creating tables
Using pre-defined functions provided by Postgresql
Writing advanced SQL queries using analytic functions

Desired Audience

Here are the desired audience for this course.

College students and entry level professionals to get hands on expertise with respect to SQL to be prepared for the interviews.
Experienced application developers to understand key aspects of Databases to improve their productivity.
Data Engineers and Data Warehouse Developers to understand the relevance of SQL and other key concepts.
Testers to improve their query writing abilities to validate data in the tables as part of running their test cases.
Business Analysts to write ad-hoc queries to understand data better or troubleshoot data quality issues.
Any other hands on IT Professional who want to improve their query writing and tuning capabilities.

Developers from non CS or IT background at times struggle in writing queries and this course will provide required database skills to take their overall application development skills to next level.

Key Objectives

The course is designed for the professionals to achieve these key objectives related to databases using Postgresql.

Ability to interpret data models.
Using database IDEs to interact with databases.
Data loading strategies to load data into database tables.
Write basic as well as advanced SQL queries.
Ability to create tables, partition tables, indexes etc.
Understand and use constraints effectively based up on the requirements.
Effective usage of functions provided by Postgresql.
Ability to write queries using advanced features such as Analytic Functions
Differences between RDBMS and Data Warehouse concepts by comparing Postgresql with Redshift.

“This course is primarily designed to gain key database skills for application developers, data engineers, testers, business analysts etc.”

Recommended Training Approach

Here are the details related to the training approach.

It is self paced with reference material, code snippets and videos.
One can use existing Postgres Database or setup their own environment using Docker (look at bonus material).
All sections will be available from Day 1. However, we recommend to set a target between 1 to 2 sections per week.
It is highly recommended to take care of the exercises at the end to ensure that you are able to meet all the key objectives for each module.
Support will be provided using Udemy Platform. Just send us the question and our team will respond. Please do not send personal messages in Udemy.

Who this course is for:

College students and entry level professionals to get hands on expertise with respect to SQL to be prepared for the interviews.
Experienced application developers to understand key aspects of Databases to improve their productivity.
Data Engineers and Data Warehouse Developers to understand the relevance of SQL and other key concepts.
Testers to improve their query writing abilities to validate data in the tables as part of running their test cases.
Business Analysts to write ad-hoc queries to understand data better or troubleshoot data quality issues.
Any other hands on IT Professional who want to improve their query writing and tuning capabilities.

Requirements

Computer with decent configuration (At least 4 GB RAM and Dual Core, 8 GB RAM and Quad Core is highly desired)
Any standard browser (preferably Chrome)
High Speed Internet
Engineering or Science Degree
Ability to use computer
Knowledge or working experience with databases is highly desired

Last Updated 12/2020

Related Torrents

torrent name size uploader age seed leech
Udemy - Mastering Ceph Storage Cluster Administration and Deployment Posted by freecoursewb in Other
3.2 GB freecoursewb 4 weeks 12 15
Udemy - Mastering Groovy EPM Examples Posted by freecoursewb in Other
3.7 GB freecoursewb 4 weeks 8 13
Udemy - Mastering IEC 60947-6-1 - Transfer Switching Equipment (TSE) Posted by freecoursewb in Other
3.8 GB freecoursewb 4 weeks 10 15
Udemy - AI - Mastering Claude for Creatives Posted by freecoursewb in Other
1.1 GB freecoursewb 2 months 22 4
Udemy - Mastering CAN Network - Vector CANoe,CANalyzer, CAPL and Theory Posted by freecoursewb in Other
1.4 GB freecoursewb 2 months 0 0