Postgresql – Complete Course Bundle

Free Download Postgresql – Complete Course Bundle
Published 1/2024
MP4 | Video: h264, 1920×1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 5.15 GB | Duration: 15h 1m
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

Homepage

https://www.udemy.com/course/postgresql-complete-course-bundle/