What you'll learn

Learn how to install and setup PostgreSQL

Become an Expert by Writing SQL Queries using PostgreSQL and PgAdmin 4

Be comfortable going on an interview with your SQL & PostgreSQL knowledge

You will understand the usefulness of a databases than a spreadsheet

Learn how to insert, create, read, update and as well how to manipulate data in a PostgreSQL database

Requirements

Basic computer knowledge (no programming or database knowledge required)

Description

Become an Expert by Writing  SQL Queries using PostgreSQL and PgAdmin 4!

SQL is one of the most in-demand tech skills across many industries today.  At the end of this course you will be comfortable putting SQL and PostgreSQL on your resume/CV. The demand for employees with SQL skills is high In this age of Big Data and Data Analysis, and will continue to increase in the future. 

PostgreSQL - the World’s most advanced open source relational database. It has a strong reputation for its reliability, data integrity and robustness. Because of this, PostgreSQL is one of the most popular and widely used database systems in the world. Companies who use PostgreSQL include Apple, Cisco, Spotify, Fujitsu, Skype, Netflix and Instagram.

A 2018 survey of stackoverflow developers reported that one third of developers used PostgreSQL on a daily basis in their professional lives, up from 25% in 2017. In 2019 PostgreSQL was the fastest growing database for the second year in a row. PostgreSQL experience really is a desired skill in the tech industry.

By the end of this course you will know how to:

Create a relational database from scratch

Create, alter and delete tables from a database

Insert, update and delete data from a table

Retrieve data from a database using select queries

Filter data using where clauses and logical operators

Order and retrieved from a table

Use aggregate functions and group data to gain more meaningful insights from a database

Relate tables together using database relationships

Use SQL join queries to retrieve data from multiple tables in a single query

Master complex SQL sub-queries

Understand Foreign Key Relationship

And many more................

This course also comes with a step-by-step video on how to install and setup PostgreSQL on your machine and the setup is completely FREE.

I will be actively answering any questions you may have about the course in the Q&A section.

The course will be continually updated with more sections in the future.

See you in the course

Who this course is for:

For absolute beginners

Homepage:

https://www.udemy.com/course/sql-mastery-with-postgresql-pgadmin-for-beginners/