PostgreSQL 11 in 7 days

PostgreSQL 11 in 7 days

English | MP4 | AVC 1920×1080 | AAC 48KHz 2ch | 4h 21m | 1.16 GB

Create, manage, and maintain your database efficiently using PostgreSQL in just a week

Companies value their data; as a result, it’s becoming more important for professionals to have technical knowledge of data management. PostgreSQL is by far one of the most popular and powerful SQL engines among other platforms such as MariaDB, MySQL, and SQL Server.

PostgreSQL in 7 Days will help you unravel the potential of PostgreSQL in a short time. You will learn about relational databases to present usable and accurate data in tables with rows and columns in just a week. You also cover the latest features of PostgreSQL 11.

By the end of the course, you will have an invaluable knowledge of both SQL and the PostgreSQL database engine.

A comprehensive course packed with step-by-step instructions on how to use PostgreSQL in just a week. This course is divided into clear chunks so you can learn at your own pace and focus on your own area of interest.

What You Will Learn

  • Write SQL statements for PostgreSQL
  • Create databases and database structures with SQL queries using PostgreSQL
  • Build complex PostgreSQL statements using subqueries
  • Insert and manipulate data in a PostgreSQL database
  • Use Structured Query Language (SQL) to manipulate data in databases
Table of Contents

Create and Insert Data in Your Database
1 The Course Overview
2 Understanding PostgreSQL and Its Uses
3 Download and Install PostgreSQL Client pgAdmin
4 Setup a Practice Database Using Referenced .tar File
5 Create Database, Table, Insert, and Query Data – Part 1
6 Create Database, Table, Insert, and Query Data – Part 2
7 PostgreSQL Relationships Using What’s Called a Primary Key and Foreign Key
8 Assignment

Retrieve Data from Your PostgreSQL Database
9 Assignment Review from Day 1
10 Introduction to the SELECT Statement to Retrieve Rows of Data
11 Introduction to the SELECT DISTINCT Statement
12 SELECT Statement with WHERE Clause
13 Insert Data into Tables, Update, and Delete Rows
14 Assignment

Count Rows in Your Table
15 Assignment Review from Day 2
16 Count All Rows Using the COUNT Function
17 Use COUNT with the DISTINCT Clause
18 Order Query Results with the ORDER BY Clause
19 Using ORDER BY with ASC and DESC Modifiers
20 Assignment

Return Specific Data Using Special Conditional Clauses
21 Assignment Review from Day 3
22 Query Rows of Data Using the BETWEEN Operator
23 Introduction to NOT BETWEEN
24 Search for a Specified Pattern in a Column Using the LIKE Operator
25 Match a Value to a List of Values with the IN Operator
26 Assignment

Use Mathematical Operations with PostgreSQL
27 Assignment Review from Day 4
28 Using MIN and MAX Functions
29 Using MIN and MAX with the ROUND Function
30 Using the AVG and SUM Functions
31 Using AVG and SUM with the ROUND Function
32 Assignment

Combine Data from Two Tables Using Joins
33 Assignment Review from Day 5
34 Group Data with the GROUP BY Clause
35 The HAVING Clause
36 PostgreSQL Aliases and the LIMIT Clause
37 Exploring Inner Joins
38 Exploring Outer Joins
39 Assignment

PostgreSQL Datatypes and Table Constraints
40 Assignment Review from Day 6
41 Common PostgreSQL Datatypes
42 Common PostgreSQL Constraints
43 Advanced Administration of Your Database with ALTER TABLE
44 Assignment
45 Assignment Solutions Review