Company: Packt Publishing Author: John Elder Full Title: Introduction To PostgreSQL Databases With PgAdmin For Beginners Year: 2019 Language: English Genre: Educational: Databases Skill Level: - Price: €183.99 - Files: MP4 Time: 01:42:31 Video: AVC, 1920 x 1080 (1.778) at 30.000 fps, 400 kbps Audio: AAC at 132 Kbps, 2 channels, 48.0 KHz Create databases and write SQL queries using PostgreSQL and PgAdmin 4. In this course, I'll teach you how to set up and use PostgreSQL databases with the PgAdmin 4 interface! There's a reason why Postgre is so popular; find out why in this course! You have many databases to choose from, many of them even free. But PostgreSQL is constantly ranked as a top database for everything from data analytics to basic web development—and everything in between. Postgre is pretty easy to use! You'll be amazed at how quick and easy it is to dive in and get started! Style and Approach A complete course packed with step-by-step instructions, working examples, and helpful advice. Learn: ✓ Understand how to use PostgreSQL databases with PgAdmin 4 ✓ Understand the basics of what a Database can do ✓ How to install PostgreSQL and PgAdmin 4 ✓ You'll learn how to create a database and table ✓ How to put data in and take data out using PgAdmin ✓ How to update and delete data from a database ✓ How to explore what's in a database whenever you want ✓ How to create basic reports with the data from your database ✓ SQL commands such as select, where, and, or, not, order by, and insert into ✓ SQL commands such as update, delete, limit, inner join, and more ✓ All about primary keys ✓ All about foreign keys ✓ How to backup and restore database ✓ How to backup and restore tables Features: ✓ Learn to install PostgreSQL and PgAdmin 4 ✓ Learn how to use PostgreSQL databases with PgAdmin 4 Lessons: 1. Introduction 01. Introduction 02. Installing pgAdmin and PostgreSQL 03. What Is A Database 04. pgAdmin Overview 05. Create Table Columns 06. Add Data To A Table 07. PostgreSQL Select Statements 08. PostgreSQL Where Clause 09. PostgreSQL Wildcards 10. PostgreSQL AND OR NOT 11. PostgreSQL Order By 12. PostgreSQL Insert Into 13. PostgreSQL Update 14. PostgreSQL Delete 15. PostgreSQL Limit 16. pgAdmin Menu Walkthru 17. PostgreSQL Foreign Keys 18. PostgreSQL Inner Join 19. PostgreSQL Join Where Hack 20. PostgreSQL Delete Table 21. PostgreSQL Import and Export Tables 22. PostgreSQL Backup and Restore Database 23. Bonus Our members see more. Join us! ------------- Our members see more. Join us!