Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
postgresql Encryption(Data-at-rest) & SSL Security ...
Rating: 3.2 out of 5(10 ratings)
155 students

postgresql Encryption(Data-at-rest) & SSL Security ...

Install Ubuntu Server, Postgresql with Data-at-rest encryption ...create SSL certificates for client-server connection
Created byMohammed N.S. Al Saadi
Last updated 11/2018
English

What you'll learn

  • you will be specialized with the Ubuntu Server , Postgresql Encryption & creating SSL certificates .

Course content

1 section • 22 lectures • 4h 8m total length

  • 0 Presentation Ubuntu Server1:56

    Presentation of series 1..Installing the Ubuntu Server..see all the video details in this series.

  • 1 Preparing Hard Drive7:48

    How to wipe out the entire capacity of your new hard disk then refill with random data prior to install the Ubuntu server ..this to ensure the integrity of you hard disk.

  • 2 Ubuntu Download :Ubuntu Server 18.04_042:46

    Select the preferred Ubuntu Server  package to download.

  • 3 Server Installation :Ubuntu Server 18.0418:02

    Installation process of the Ubuntu Server 18.

  • 4 Server Config 1 :Ubuntu Server 18.04_045:30

    Adding useful plugins to the server.

  • 5 Server Config 2 :Ubuntu Server 18.0416:56

    Setting up the server firewall & the networking file "netplan"

  • 6 Add server's Users : Ubuntu Server 18.0415:25

    Add users to the server , root user, sudo user , delete a user with entire cluster data .

  • 1 Presentation Postgresql Database1:07

    Presentation of the topics in this Postgresql series

  • 2 Precompiled Package Install : Postgresql Database13:20

    Install Postgresql precompield package then partially encrypt your database using pcrypto package.

  • 3 Source Code Install from Sudo user : Postgresql Database30:49

    Install a customized Postgresql source code package using a Sudo user...then Encrypt entire databases cluster using the Data-At-Rest WIP Encryption .

  • 4 Source Code Install From ROOT user : Postgresql Database2:10

    Install a customized Postgresql source code package using a ROOT user...then Encrypt entire databases cluster using the Data-At-Rest WIP Encryption .

  • 1 Presentation SSL Client-Server Connection with Ubuntu Server 18 & Postgresql4:17

    Presentation of the topics in the videos of this series .

  • 2 Openssl.cnf config SSL Client-Server Connection with Ubuntu Server 18 & Postgr7:37

    Configure the  openssl.cnf  file prior to create any SSL certificate.

  • 3 ROOT Certificate SSL Client-Server Connection with Ubuntu Server 18 & Postgres15:29

    Create your server ROOT certificate.

  • 4 Intermediate Certificate SSL Client-Server with Ubuntu Server 18 & Postgresql27:08

    Create your server Intermediate certificate from which you will create all other certificates.

  • 5 Server Certificate SSL Client-Server with Ubuntu Server 18.04 & Postgresql19:49

    TODAY 30th Nov I uploaded the correct video(previously was wrong video uploaded , therefore I sincerely apologize to subscribers who watched the wrong video)

    Create a Server certificate...self-signed OR using Global Certificate Authority.

  • 6 Client Certificate SSL client-Server Ubuntu Server 18.04 & Postgreslq11:07

    Create Client Certificate .

  • 7 Client Machine SSL Client-Server with Ubuntu Server 18.04 & Postgresql12:32

    Copy the client key, client certificate & intermediate certificate to the client machine ..to start the SSL connection between the client machine & the Server machine.

  • 8 SSL Concept_SSL Client Server with Ubuntu Server 18.04 & Postgresql8:48

    Ween can we consider the SSL connection is fully secured based on Postgresql manual recommendations.

  • 9 SSL Concept One _ SSL Client Server with Ubuntu Server 18.04 & Postgresql7:24

    If we configure the SSL connection only from the Server side ...not fully secure connection.

  • 10 Custom Config _ SSL Client Server with Ubuntu Server 18.04 & Postgresql7:24

    If we configure the SSL connection from both sides..the server side & the client side ...Fully secure SSL connection.

  • 11 SSL Concept Two _ SSL Client Server with Ubuntu Server 18.04 & postgresql10:57

    Applying the SSL connection practically in a java application : using a Socket between the server machine & the client machine.

Requirements

  • have some knowledge about databases & Security

Description

The course consist of 3 consecutive  parts...starting with the Ubuntu Server, Postgresql & finally the SSL connection.

1- Install Ubuntu Server, configure NTP, NSCD , firewall & networking 'netplan' file .

2- Install customized source code package of Postgresql  then encrypt the entire cluster of databases with Data-At-Rest encryption technique.

3- Create all necessary certificates (ROOT,Intermediate,Trust-Chain,Server ,Client) to get a full  secure  SSL client-server connection from both sides based on (based on postgresql manual).

Who this course is for:

  • Who want encrypt entire Postgresql cluster of databases using Data-At-Rest encryption
  • Who want create SSL certificates (ROOT,Intermediate,Server & Client) , install on both server & client machines
  • Who want learn installation of Ubuntu Server 18

Report abuse