Installing Postgres in Windows | Intro to SQL with Drills and Exercises - 2

Опубликовано: 04 Октябрь 2024
на канале: Job Ready Programmer

1,847

This video is from the course "Master SQL for Data Science"
In this lesson, I show you how to easily get your Postgres database environment up and running for Windows so that you can follow along with the rest of this SQL tutorial.
=========================================
➡️ Get the complete course today from Job Ready Programmer using the link below:
https://www.jobreadyprogrammer.com/p/...
=========================================
➡️ Learn MORE:
Access all of my software development courses using the discount below: https://www.jobreadyprogrammer.com/p/...
Email me if you have questions: [email protected]
Become Job Ready with our NEW Programming Guide (PDF): https://pages.jobreadyprogrammer.com/...
=========================================
➡️ About the course: Master SQL for Data Science
This course will turn you into a SQL query wizard. You'll learn the skills you need to extract critical insight from data sitting in a database. There are over 100 puzzles scattered throughout the course with in-depth solutions providing plenty of opportunity for you to practice. After completing the course and all of it's assignments, I promise you, you'll never be afraid to look at a large SQL query again.
Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, rollups and cubes, window functions, transposing & ranking data and using conditional expressions in very interesting ways.

➡️ Below are some of the topics you'll learn:
What is a Database, Installing Postgres, Creating Tables
SELECT Statement, WHERE Clause, AND & OR
Filtering Operators, ORDER BY, LIMIT, DISTINCT
Renaming Columns, Functions, GROUP BY & HAVING Clauses
Aggregation Queries, Subqueries, CASE Clause
Correlated Subqueries,
Table Joins, INNER and OUTER Joins,
UNION, UNION ALL and EXCEPT Clauses
Window Functions for Analytics
over 100 puzzles distributed throughout the course
=========================================
➡️ Connect with me:
LinkedIn:   / imtiaz-ahmad-80117324
Twitter:   / jobreadyproinc
=========================================
➡️ Job Ready Programmer Socials:
Job Ready Programmer Courses: https://www.jobreadyprogrammer.com/
LinkedIn Page:   / jobreadyprogrammer
Discord Community:   / discord
Facebook Page:   / jobreadyprogrammer
Instagram:   / programmerready
JRP Blog: https://www.jobreadyprogrammer.com/p/...
JRP Weekly Newsletter: https://pages.jobreadyprogrammer.com/...
Linktree: https://linktr.ee/jobreadyprogrammer
=========================================
#sql #postgresql #database #jobreadyprogrammer #databasedeveloper #softwaredeveloper #career #tableau #databases #webdeveloper #aws #admin #jobready #programmer #postgres