This is the code repository for PostgreSQL 11 in 7 days , published by Packt. It contains all the supporting project files necessary to work through the video course from start to finish.
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.
- 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
To fully benefit from the coverage included in this course, you will need:
No Prior knowlegde
This course has the following software requirements:
Minimum Hardware Requirements
For successful completion of this course, students will require the computer systems with at least the following:
OS: Windows 7 or higher
Processor: 64 bit
Memory: 8 GB
Storage: 15 GB Recommended Hardware Requirements For an optimal experience with hands-on labs and other practical activities, we recommend the following configuration:
OS: MAC OSX 10 or higher | Windows 7 or higher
Processor: 64 bit
Memory: 15 - 32 GB
Storage: 50 GB
Software Requirements
Operating system: MAC OSX 10 or higher | Windows 7 or higher
Browser: Chrome (preferred)
Latest Release - PostgreSQL App (if MAC OSX) or PostgreSQL Graphical Installer if Windows
Latest Release - Postico App (if MAC OSX) or PGAdmin if Windows (PGAdmin works on MAC too)