Mastering SQL using Postgresql using ITVersity Labs
86 videos • 19,395 views • by itversity
As part of this series, we have covered all the aspects for you be expert in writing SQL Queries.
1
Mastering SQL - Postgresql - Getting Started - Connecting to Database
itversity
Download
2
Mastering SQL - Postgresql - Getting Started - Using psql
itversity
Download
3
Mastering SQL - Postgresql - Getting Started - Setup Postgres using Docker
itversity
Download
4
Mastering SQL - Postgresql - Getting Started - Setup SQL Workbench
itversity
Download
5
Mastering SQL - Postgresql - Getting Started - SQL Workbench and Postgres
itversity
Download
6
Mastering SQL - Postgresql - Getting Started - SQL Workbench Features
itversity
Download
7
Mastering SQL - Postgresql - Getting Started - Data Loading Utilities
itversity
Download
8
Mastering SQL - Postgresql - Getting Started - Loading Data - Docker
itversity
Download
9
Mastering SQL - Postgresql - DML or CRUD Operations - Inserting Data
itversity
Download
10
Mastering SQL - Postgresql - DML or CRUD Operations - Updating Data
itversity
Download
11
Mastering SQL - Postgresql - DML or CRUD Operations - Deleting Data
itversity
Download
12
Mastering SQL - Postgresql - DML or CRUD Operations - Overview of Transactions
itversity
Download
13
Mastering SQL - Postgresql - DML or CRUD Operations - Exercises - Database Operations
itversity
Download
14
Mastering SQL - Postgresql - Writing Basic SQL Queries - Standard Transformations
itversity
Download
15
Mastering SQL - Postgresql - Writing Basic SQL Queries - Overview of Data Model
itversity
Download
16
Mastering SQL - Postgresql - Writing Basic SQL Queries - Define Problem Statement
itversity
Download
17
Mastering SQL - Postgresql - Writing Basic SQL Queries - Preparing Tables
itversity
Download
18
Mastering SQL - Postgresql - Writing Basic SQL Queries - Selecting or Projecting Data
itversity
Download
19
Mastering SQL - Postgresql - Writing Basic SQL Queries - Filtering Data
itversity
Download
20
Mastering SQL - Postgresql - Writing Basic SQL Queries - Joining Tables – Inner
itversity
Download
21
Mastering SQL - Postgresql - Writing Basic SQL Queries - Joining Tables - Outer
itversity
Download
22
Mastering SQL - Postgresql - Writing Basic SQL Queries - Performing Aggregations
itversity
Download
23
Mastering SQL - Postgresql - Writing Basic SQL Queries - Sorting Data
itversity
Download
24
Mastering SQL - Postgresql - Writing Basic SQL Queries - Solution – Daily Product Revenue
itversity
Download
25
Mastering SQL - Postgresql - Writing Basic SQL Queries - Exercises - Basic SQL Queries
itversity
Download
26
Mastering SQL - Postgresql - Creating Tables and Indexes - DDL – Data Definition Language
itversity
Download
27
Mastering SQL - Postgresql - Creating Tables and Indexes - Overview of Data Types
itversity
Download
28
Mastering SQL - Postgresql - Creating Tables and Indexes - Adding or Modifying Columns
itversity
Download
29
Mastering SQL - Postgresql - Creating Tables and Indexes - Different Types of Constraints
itversity
Download
30
Mastering SQL - Postgresql - Creating Tables and Indexes - Managing Constraints
itversity
Download
31
Mastering SQL - Postgresql - Creating Tables and Indexes - Indexes on Tables
itversity
Download
32
Mastering SQL - Postgresql - Creating Tables and Indexes - Indexes for Constraints
itversity
Download
33
Mastering SQL - Postgresql - Creating Tables and Indexes - Overview of Sequences
itversity
Download
34
Mastering SQL - Postgresql - Creating Tables and Indexes - Truncating Tables
itversity
Download
35
Mastering SQL - Postgresql - Creating Tables and Indexes - Dropping Tables
itversity
Download
36
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Overview of Partitioning
itversity
Download
37
Mastering SQL - Postgresql - Partitioning Tables and Indexes - List Partitioning
itversity
Download
38
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Managing Partitions - List
itversity
Download
39
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Manipulating Data
itversity
Download
40
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Range Partitioning
itversity
Download
41
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Managing Partitions - Range
itversity
Download
42
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Repartitioning - Range
itversity
Download
43
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Hash Partitioning
itversity
Download
44
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Managing Partitions - Hash
itversity
Download
45
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Usage Scenarios
itversity
Download
46
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Sub Partitioning
itversity
Download
47
Mastering SQL - Postgresql - Partitioning Tables and Indexes - Exercises - Partitioning Tables
itversity
Download
48
Mastering SQL - Postgresql - Pre-defined Functions - Overview of Pre-Defined Functions
itversity
Download
49
Mastering SQL - Postgresql - Pre-defined Functions - String Manipulation Functions
itversity
Download
50
Mastering SQL - Postgresql - Pre-defined Functions - Case Conversion and Length
itversity
Download
51
Mastering SQL - Postgresql - Pre-defined Functions - Extracting Data - substr and split_part
itversity
Download
52
Mastering SQL - Postgresql - Pre-defined Functions - Using position or strpos
itversity
Download
53
Mastering SQL - Postgresql - Pre-defined Functions - Trimming and Padding Functions
itversity
Download
54
Mastering SQL - Postgresql - Pre-defined Functions - Reverse and Concatenating multiple strings
itversity
Download
55
Mastering SQL - Postgresql - Pre-defined Functions - String Replacement
itversity
Download
56
Mastering SQL - Postgresql - Pre-defined Functions - Date Manipulation Functions
itversity
Download
57
Mastering SQL - Postgresql - Pre-defined Functions - Getting Current Date and Timestamp
itversity
Download
58
Mastering SQL - Postgresql - Pre-defined Functions - Date Arithmetic
itversity
Download
59
Mastering SQL - Postgresql - Pre-defined Functions - Beginning Date or Time - date_trunc
itversity
Download
60
Mastering SQL - Postgresql - Pre-defined Functions - Extracting information using to_char
itversity
Download
61
Mastering SQL - Postgresql - Pre-defined Functions - Extracting information - extract
itversity
Download
62
Mastering SQL - Postgresql - Pre-defined Functions - Dealing with Unix Timestamp
itversity
Download
63
Mastering SQL - Postgresql - Pre-defined Functions - Overview of Numeric Functions
itversity
Download
64
Mastering SQL - Postgresql - Pre-defined Functions - Data Type Conversion
itversity
Download
65
Mastering SQL - Postgresql - Pre-defined Functions - Handling NULL Values
itversity
Download
66
Mastering SQL - Postgresql - Pre-defined Functions - Using CASE and WHEN
itversity
Download
67
Mastering SQL - Postgresql - Advanced SQL - Overview of Views
itversity
Download
68
Mastering SQL - Postgresql - Advanced SQL - Named Queries - Using WITH Clause
itversity
Download
69
Mastering SQL - Postgresql - Advanced SQL - Overview of Sub Queries
itversity
Download
70
Mastering SQL - Postgresql - Advanced SQL - CTAS - Create Table as Select
itversity
Download
71
Mastering SQL - Postgresql - Advanced SQL - Advanced DML Operations
itversity
Download
72
Mastering SQL - Postgresql - Advanced SQL - Merging or Upserting Data
itversity
Download
73
Mastering SQL - Postgresql - Advanced SQL - Pivoting Rows into Columns
itversity
Download
74
Mastering SQL - Postgresql - Advanced SQL - Overview of Analytic Functions
itversity
Download
75
Mastering SQL - Postgresql - Advanced SQL - Analytic Functions – Aggregations
itversity
Download
76
Mastering SQL - Postgresql - Advanced SQL - Cumulative or Moving Aggregations
itversity
Download
77
Mastering SQL - Postgresql - Advanced SQL - Analytic Functions – Windowing
itversity
Download
78
Mastering SQL - Postgresql - Advanced SQL - Analytic Functions – Ranking
itversity
Download
79
Mastering SQL - Postgresql - Advanced SQL - Analytic Functions - Filtering
itversity
Download
80
Mastering SQL - Postgresql - Advanced SQL - Ranking and Filtering - Recap
itversity
Download
81
Mastering SQL - Postgresql - DML or CRUD Operations- Creating Table
itversity
Download
82
Mastering SQL - Postgresql - DML or CRUD Operations - CRUD Operations
itversity
Download
83
Mastering SQL - Postgresql - DML or CRUD Operations - Overview
itversity
Download
84
Understanding Databases: A Simple Guide to Different Types and Their Uses
itversity
Download
85
Install and Manage PostgreSQL on Windows or Mac: Using pgAdmin and Task Manager Guide
itversity
Download
86
Getting Started with SQL: Setup Postgres Database and Tables | Step-by-Step Tutorial with Commands
itversity
Download