Book Image

PostgreSQL 11 in 7 days [Video]

By : Daniel Scott
Book Image

PostgreSQL 11 in 7 days [Video]

By: Daniel Scott

Overview of this book

<p>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.</p> <p>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.</p> <p>By the end of the course, you will have an invaluable knowledge of both SQL and the PostgreSQL database engine.</p> <p><span id="description" class="sugar_field">All the code and supporting files for this course are available at: <a href="https://github.com/PacktPublishing/PostgreSQL-11-in-7-days" target="_new">https://github.com/PacktPublishing/PostgreSQL-11-in-7-days</a></span></p> <h1>Style and Approach</h1> <p>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.</p>

Related Content you might be interested in

Current Title:

Small book image
PostgreSQL 11 in 7 days [Video]
Daniel Scott
Nov, 2018 | 4 hours 21 minutes
No titles found
Table of Contents (7 chapters)
Free Chapter
1
Create and Insert Data in Your Database
The Course Overview
Understanding PostgreSQL and Its Uses
Download and Install PostgreSQL Client pgAdmin
Setup a Practice Database Using Referenced .tar File
Create Database, Table, Insert, and Query Data – Part 1
Create Database, Table, Insert, and Query Data – Part 2
PostgreSQL Relationships Using What’s Called a Primary Key and Foreign Key
Assignment
2
Retrieve Data from Your PostgreSQL Database
Assignment Review from Day 1
Introduction to the SELECT Statement to Retrieve Rows of Data
Introduction to the SELECT DISTINCT Statement
SELECT Statement with WHERE Clause
Insert Data into Tables, Update, and Delete Rows
Assignment
3
Count Rows in Your Table
Assignment Review from Day 2
Count All Rows Using the COUNT Function
Use COUNT with the DISTINCT Clause
Order Query Results with the ORDER BY Clause
Using ORDER BY with ASC and DESC Modifiers
Assignment
4
Return Specific Data Using Special Conditional Clauses
Assignment Review from Day 3
Query Rows of Data Using the BETWEEN Operator
Introduction to NOT BETWEEN
Search for a Specified Pattern in a Column Using the LIKE Operator
Match a Value to a List of Values with the IN Operator
Assignment
5
Use Mathematical Operations with PostgreSQL
Assignment Review from Day 4
Using MIN and MAX Functions
Using MIN and MAX with the ROUND Function
Using the AVG and SUM Functions
Using AVG and SUM with the ROUND Function
Assignment
6
Combine Data from Two Tables Using Joins
Assignment Review from Day 5
Group Data with the GROUP BY Clause
The HAVING Clause
PostgreSQL Aliases and the LIMIT Clause
Exploring Inner Joins
Exploring Outer Joins
Assignment
7
PostgreSQL Datatypes and Table Constraints
Assignment Review from Day 6
Common PostgreSQL Datatypes
Common PostgreSQL Constraints
Advanced Administration of Your Database with ALTER TABLE
Assignment
Assignment Solutions Review
Chapter 6
Combine Data from Two Tables Using Joins
Content Locked
Section 4
PostgreSQL Aliases and the LIMIT Clause
As queries become more verbose, it’s important to learn methods to make queries more meaningful and easier to understand. One of the best solutions to this problem is PostgreSQL Aliases and the LIMIT clause. - Introduce the main topic and provide examples of the syntax - Demonstrate a use case of Aliases and LIMIT in pgAdmin
Previous Section
End of Section 4
Next Section