$125 | Duration: 4h 21m | Video: h264, 1920x1080 | Audio: AAC, 48kHz, 2 Ch | 1.1 GBGenre: eLearning | Language: English | November 30, 2018Create, manage, and maintain your database efficiently using PostgreSQL in just a weekCompanies 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:Style and ApproachA 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 ContentsCREATE AND INSERT DATA IN YOUR DATABASERETRIEVE DATA FROM YOUR POSTGRESQL DATABASECOUNT ROWS IN YOUR TABLERETURN SPECIFIC DATA USING SPECIAL CONDITIONAL CLAUSESUSE MATHEMATICAL OPERATIONS WITH POSTGRESQLCOMBINE DATA FROM TWO TABLES USING JOINSPOSTGRESQL DATATYPES AND TABLE CONSTRAINTSWhat You Will LearnWrite SQL statements for PostgreSQLCreate databases and database structures with SQL queries using PostgreSQLBuild complex PostgreSQL statements using subqueriesInsert and manipulate data in a PostgreSQL databaseUse Structured Query Language (SQL) to manipulate data in databases