by Daniel Scott | Released November 2018 | ISBN: 9781789614374

Create, manage, and maintain your database efficiently using PostgreSQL in just a weekAbout This VideoLearn PostgreSQL in 7 days with 30-minutes of hands-on training followed by a 1-hour practical exercise each day.This course teaches you PostgreSQL and how to execute SQL queries. Learn about SQL and PostgreSQL in 7 Days with this easy and friendly guide.In DetailCompanies 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.All the code and supporting files for this course are available at: https://github.com/PacktPublishing/PostgreSQL-11-in-7-days Show and hide more

1. Chapter 1 : Create and Insert Data in Your Database
   • The Course Overview 00:04:40
   • Understanding PostgreSQL and Its Uses 00:03:57
   • Download and Install PostgreSQL Client pgAdmin 00:06:35
   • Setup a Practice Database Using Referenced .tar File 00:10:33
   • Create Database, Table, Insert, and Query Data – Part 1 00:06:12
   • Create Database, Table, Insert, and Query Data – Part 2 00:10:28
   • PostgreSQL Relationships Using What’s Called a Primary Key and Foreign Key 00:05:23
   • Assignment 00:01:20
2. Chapter 2 : Retrieve Data from Your PostgreSQL Database
   • Assignment Review from Day 1 00:04:38
   • Introduction to the SELECT Statement to Retrieve Rows of Data 00:06:08
   • Introduction to the SELECT DISTINCT Statement 00:06:33
   • SELECT Statement with WHERE Clause 00:09:10
   • Insert Data into Tables, Update, and Delete Rows 00:06:39
   • Assignment 00:03:07
3. Chapter 3 : Count Rows in Your Table
   • Assignment Review from Day 2 00:04:29
   • Count All Rows Using the COUNT Function 00:08:21
   • Use COUNT with the DISTINCT Clause 00:05:04
   • Order Query Results with the ORDER BY Clause 00:05:54
   • Using ORDER BY with ASC and DESC Modifiers 00:06:51
   • Assignment 00:02:24
4. Chapter 4 : Return Specific Data Using Special Conditional Clauses
   • Assignment Review from Day 3 00:02:48
   • Query Rows of Data Using the BETWEEN Operator 00:05:31
   • Introduction to NOT BETWEEN 00:05:27
   • Search for a Specified Pattern in a Column Using the LIKE Operator 00:09:05
   • Match a Value to a List of Values with the IN Operator 00:05:50
   • Assignment 00:02:34
5. Chapter 5 : Use Mathematical Operations with PostgreSQL
   • Assignment Review from Day 4 00:03:39
   • Using MIN and MAX Functions 00:07:59
   • Using MIN and MAX with the ROUND Function 00:05:25
   • Using the AVG and SUM Functions 00:07:26
   • Using AVG and SUM with the ROUND Function 00:05:17
   • Assignment 00:02:30
6. Chapter 6 : Combine Data from Two Tables Using Joins
   • Assignment Review from Day 5 00:03:10
   • Group Data with the GROUP BY Clause 00:06:56
   • The HAVING Clause 00:06:29
   • PostgreSQL Aliases and the LIMIT Clause 00:06:08
   • Exploring Inner Joins 00:08:38
   • Exploring Outer Joins 00:08:48
   • Assignment 00:03:49
7. Chapter 7 : PostgreSQL Datatypes and Table Constraints
   • Assignment Review from Day 6 00:04:39
   • Common PostgreSQL Datatypes 00:04:16
   • Common PostgreSQL Constraints 00:04:42
   • Advanced Administration of Your Database with ALTER TABLE 00:04:12
   • Assignment 00:05:16
   • Assignment Solutions Review 00:12:50
Show and hide more