Postgresql - Complete Course Bundle

Become an expert in PostgreSQL. Store and fetch data, tune queries, and design efficient database structures

What you'll learn

How to make use of multiple PostgreSQL instances in the cloud

The theory of PostgreSQL architecture and how it works under-the-hood

Understand PostgreSQL Process and Memory Architecture.

Step-by-step walkthrough to perform simple to complex postgreSQL queries

Requirements

A Mac, PC, or Linux-based Computer

Description

The goal of this course is to help the trainees understand each and single concepts that fall under the domain of PostgreSQL which is a relational database management system. This training will be enabling the trainees to master the concept of PostgreSQL from scratch and to help implement and manage this database. After completing this course, the trainees will be able to solve all the problems that could be solved using a robust database like PostgreSQL.The main objective of this course is to assist all the interested folks on how the concepts of PostgreSQL could be leveraged to draft solutions for various data storage and processing related problems. One of the main objectives is also to provide practical exposure to all of the trainees so that they could understand how things could get implemented. The projects have also been added in the course to reinforce the understanding of the trainees on particular concepts.PostgreSQL Course Fundamentals will be the first unit where you will be learning about all the fundamental level topics of PostgreSQL. It will be around four and a half an hour video tutorial where you will be covering all the topics that are considered under the beginner level topics. The first half an hour of the course has been devoted to introducing the trainees about PostgreSQL while the remaining time will be used to details the concepts that will be used further while working on the project or while learning the advanced level topics. After completing this unit, you will be able to work very effectively with all the fundamental level topics.

Overview

Section 1: PostgreSQL Course

Lecture 1 Introduction to PostgreSQL

Lecture 2 Continue PostgreSQL Introduction

Lecture 3 Drop Database

Lecture 4 Drop Database Continue

Lecture 5 Insert Into Table

Lecture 6 Insert Into Table Continue

Lecture 7 Adding Constraints

Lecture 8 Numeric Types

Lecture 9 Advantages of SQL Part 1

Lecture 10 Advantages of SQL Part 2

Lecture 11 Advantages of SQL Part 3

Lecture 12 Constraints

Lecture 13 Operators

Lecture 14 Basic of Table

Lecture 15 Constraints Concepts

Lecture 16 Constraint Concept

Lecture 17 Constraint Concept Continue

Lecture 18 Primary Key

Lecture 19 Foreign Key

Lecture 20 Modifying Table Part 1

Lecture 21 Modifying Table Part 2

Lecture 22 Modifying Table Part 3

Lecture 23 Modifying Table Part 4

Section 2: Project On PostgreSQL: E-Commerce Reporting And Analysis

Lecture 24 Introduction to Project

Lecture 25 Introduction to Project Continue

Lecture 26 Installation

Lecture 27 Installation Continue

Lecture 28 Managing Databases

Lecture 29 Managing Tables

Lecture 30 Managing Tables Continue

Lecture 31 Datatypes

Lecture 32 Constraints

Lecture 33 Understanding Case Study Dataset

Lecture 34 Import CSV Dataset Into Table

Lecture 35 Querying the Database Tables

Lecture 36 Querying the Database Tables Continue

Lecture 37 Filtering the Records

Lecture 38 Using Subqueries

Lecture 39 Grouping Data

Lecture 40 Using Joins Part 1

Lecture 41 Using Joins Part 2

Lecture 42 Using Joins Part 3

Lecture 43 Grouping Sets

Lecture 44 Grouping Sets Continue

Lecture 45 Cube and Rollup

Lecture 46 PGAdmin4

Lecture 47 Reporting Introduction

Lecture 48 Reporting Project Assignment Part 1

Lecture 49 Reporting Project Assignment Part 2

Lecture 50 Reporting Project Assignment Part 3

Section 3: PostgreSQL Project - Solving Employee Records Queries

Lecture 51 Introduction to Project

Lecture 52 Setting Up with PostgreSQL

Lecture 53 Creating Employee Table

Lecture 54 Appraisal Tables

Lecture 55 Query for Joining Tables

Lecture 56 Query For Appraisal

Lecture 57 Query for Finding Salaries

Lecture 58 Output of the Project

Section 4: PostgreSQL 2023 Training

Lecture 59 PostgreSQL Basic

Lecture 60 Downloading of PostgreSQL

Lecture 61 Installing and Configuring PostgreSQL

Lecture 62 Tables Using Query

Lecture 63 Inserting Records in Humanresource Database

Lecture 64 Executing Queries from Command Line

Lecture 65 Creating and Inserting Records in SampleDB

Lecture 66 Creating and Inserting Records in SampleDB Continued

Lecture 67 Multi-Insert Statement

Lecture 68 Statement

Lecture 69 More on Upsert

Lecture 70 Assignment Explanation

Lecture 71 Various Select Clause

Lecture 72 Using Aggregate Function in Select

Lecture 73 More on Aggregate Functions

Lecture 74 Using More Clauses in Select Statement

Lecture 75 Order by Clause

Lecture 76 Char and Like Clause

Lecture 77 More on Like Clause

Lecture 78 Using Group by and Having Clause

Section 5: PostgreSQL Tutorials - The Fundamentals

Lecture 79 Introduction to PostgreSQL

Lecture 80 Benefits of PostgreSQL

Lecture 81 Aspect of Database

Lecture 82 Types of Data

Lecture 83 Issuing Database Commands

Lecture 84 Table Structure

Lecture 85 Inserting Data in Table

Lecture 86 Retrieving the Data

Lecture 87 Sorting of Data

Lecture 88 Analyzing of Various Queries

Lecture 89 Destroying a Table

Lecture 90 Customization of Queries

Lecture 91 Understanding Null Values

Lecture 92 Performing Complex Clause

Lecture 93 Uses of Distinct Keyword

Lecture 94 Set Show and Reset

Lecture 95 SQL Aggregates

Lecture 96 Group By and Having Clause

Lecture 97 Concept of Joining Tables

Lecture 98 Requirement for Joining Tables

Lecture 99 Creating Join Tables

Lecture 100 Inserting Customer Value

Lecture 101 Three or Four Table Joins

Lecture 102 Additional Join

Lecture 103 One to Many Joins

Lecture 104 Concept of Self Joins

Lecture 105 Concept of Referential Integrity

Lecture 106 Numbering Rows

Lecture 107 Creating Functions for Sequences

Lecture 108 Combining Selects

Lecture 109 Understanding Subqueries

Lecture 110 Executing Subqueries

Lecture 111 Update with FROM Clause

Lecture 112 Creating Tables using Select

Lecture 113 Concept of Performance

Lecture 114 Understanding PostgreSQL

Anyone wanting to learn SQL or PostgreSQL,Complete beginners to database world,Anyone wants to learn from basic to advanced functionality of PostgreSQL,Anyone wanting to learn advanced query expressions,Application engineers seeking to expand their backend skillset