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
