SQL & PostgreSQL for Beginners (Udemy.com)
SQL & PostgreSQL Tutorial: Become an Expert in SQL and PostgreSQL by Writing SQL Queries using PostgreSQL and PgAdmin 4.
Created by: Jon Avis - SQL Instructor
Produced in 2021
What you will learn
- How to create a database from scratch.
- Use SQL to perform data analysis.
- Perform complex SQL queries using joins and subqueries.
- Understand database concepts such as database relationships.
- Confident putting SQL and PostgreSQL on your resume.
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 92 / 100
Course Description
Become an expert in SQL and PostgreSQL with this bestselling course!
SQL is one of the most in-demand tech skills across many industries so learning SQL is one of the best ways to boost your career! After taking this course you will be comfortable putting SQL and PostgreSQL on your resume/CV.
In the age of Big Data and Data Analysis, demand for employees with SQL skills is high and will only increase in the future. Stand out from the crowd and learn SQL today.
PostgreSQL is 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 IMDb.
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.
Here's what students are saying about this SQL course:
Christopher says - "A really great course. The structure was well setup and the pacing was perfect. Each section and lecture flowed well in to the next. The exercises and solutions were very helpful. I was new to sql and postgresql before taking this course but I can now say that I am comfortable with both."
Erin Todd says - "I love this course so far very easy to follow and interactive."
Raymond Beauchamp says - "Amount of information is good for a beginner course. Was beneficial in increasing my understanding of the subject. Instructor was knowledgeable, and was easy to follow."
John Hellmann says - "Very concise lectures! Was a great course overall"
Abhinav Sharma says - "The explanations are really clear and the course structure is very well thought out."
By the end of this course you will know how to:
A step-by-step video of how to install and setup PostgreSQL is included and the setup is completely FREE.
The SQL code for each video is included as a resource so you can easily access it.
There are SQL exercises, and video solutions, along the way to help you improve your knowledge and SQL skills.
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.
Watch the free preview videos and start learning SQL - one of the most important and in-demand technology skills!
Who this course is for:
SQL is one of the most in-demand tech skills across many industries so learning SQL is one of the best ways to boost your career! After taking this course you will be comfortable putting SQL and PostgreSQL on your resume/CV.
In the age of Big Data and Data Analysis, demand for employees with SQL skills is high and will only increase in the future. Stand out from the crowd and learn SQL today.
PostgreSQL is 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 IMDb.
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.
Here's what students are saying about this SQL course:
Christopher says - "A really great course. The structure was well setup and the pacing was perfect. Each section and lecture flowed well in to the next. The exercises and solutions were very helpful. I was new to sql and postgresql before taking this course but I can now say that I am comfortable with both."
Erin Todd says - "I love this course so far very easy to follow and interactive."
Raymond Beauchamp says - "Amount of information is good for a beginner course. Was beneficial in increasing my understanding of the subject. Instructor was knowledgeable, and was easy to follow."
John Hellmann says - "Very concise lectures! Was a great course overall"
Abhinav Sharma says - "The explanations are really clear and the course structure is very well thought out."
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 limit data 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 subqueries
A step-by-step video of how to install and setup PostgreSQL is included and the setup is completely FREE.
The SQL code for each video is included as a resource so you can easily access it.
There are SQL exercises, and video solutions, along the way to help you improve your knowledge and SQL skills.
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.
Watch the free preview videos and start learning SQL - one of the most important and in-demand technology skills!
Who this course is for:
- Anyone wanting to learn SQL or PostgreSQL.
- Anyone with a basic knowledge of SQL but is new to PostgreSQL.
- Anyone wanting to learn more about databases.
Instructor Details
- 4.6 Rating
392 Reviews
Jon Avis - SQL Instructor
Hi, my name is Jon. I am from the UK and currently work in Hong Kong. I work in the financial industry as an IT Systems Engineer. This has allowed me to become an expert on SQL, Databases, Unix, Shell Scripting and coding in multiple languages.
Part of my role as a Systems Engineer is to teach complex, technical subjects to colleagues. Through Udemy I hope to do the same to many more students around the globe.
More postgresql courses
SQL and PostgreSQL: The Complete Developer's Guide (2021)
4.8 (60 Reviews)
Provider: Udemy
Time: 22h
$11.99
Practical SQL Bootcamp for Data Analysts and Data Scientists (2021)
4.8 (50 Reviews)
- Provider: Udemy
- Time: 3.5h
$11.99
Python 3 Complete Masterclass - Make Your Job Tasks Easier! (2021)
4.7 (414 Reviews)
- Provider: Udemy
- Time: 15.5h
$11.99
Reviews
- Video Duration:
8h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2021 - Language:
English, English [Auto-generated] - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
