$125 | Duration: 4h 21m | Video: h264, 1920x1080 | Audio: AAC, 48kHz, 2 Ch | 1.1 GB
Genre: eLearning | Language: English | November 30, 2018
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.
All the code and supporting files for this course are available at: https://github.com/PacktPublishing/PostgreSQL-11-in-7-days
Style and Approach
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.
Table of Contents
CREATE AND INSERT DATA IN YOUR DATABASE
RETRIEVE DATA FROM YOUR POSTGRESQL DATABASE
COUNT ROWS IN YOUR TABLE
RETURN SPECIFIC DATA USING SPECIAL CONDITIONAL CLAUSES
USE MATHEMATICAL OPERATIONS WITH POSTGRESQL
COMBINE DATA FROM TWO TABLES USING JOINS
POSTGRESQL DATATYPES AND TABLE CONSTRAINTS
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