Pluralsight – Combining and Filtering Data with PostgreSQL

Pluralsight – Combining and Filtering Data with PostgreSQL-XQZT
English | Size: 230.21 MB
Category: Tutorial


In this course, Combining and Filtering Data with PostgreSQL, you will learn how to expand your queries to retrieve additional data and achieve your desired results. First, you will learn the fundamentals of data types and how to work with string functions. Next, you will discover aggregate functions and how to filter aggregate results. Then, you will explore how to use joins to retrieve data from multiple tables. Set theory and unions will also be used to combine multiple result sets. Subqueries and common table expressions are introduced to help conduct more sophisticated analyses using multiple filter criteria Finally, you will figure out window functions and how to partition and analyze data. When you re finished with this course, you will have the skills and knowledge of PostgreSQL necessary to begin writing more complex queries to [Read more…]

Packt – The Complete Python and PostgreSQL Developer Course

Packt – The Complete Python and PostgreSQL Developer Course-RiDWARE
English | Size: 7.74 GB
Category: CBTs


Learn
Understand software and programming with Python from beginning to end
Create Python applications ranging from beginner-level, basic applications to advanced, useful, and engaging applications
Learn how to extend Python applications by using professional data storage: PostgreSQL
Understand advanced concepts, such as data structures and algorithms, that are extremely useful in jobs and interviews [Read more…]

Packt – Introduction to Postgresql Databases With Pgadmin for Beginners

Packt – Introduction to Postgresql Databases With Pgadmin for Beginners-JGTiSO
English | Size:
Category: Tutorial


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
About
In this course, I’ll teach you how to set up and use PostgreSQL databases with the PgAdmin 4 interface!
[Read more…]

SQL & PostgreSQL From beginner to pro

SQL & PostgreSQL From beginner to pro
English | Size: 873.09 MB
Category: Tutorial

If you want to learn how to gain insights from data but are too intimidated by databases to know where to start, then this course is for you. This course is designed to help you master SQL & PostgreSQL, one of the most highly in-demand skills in the computer science sector today.

It doesn’t matter who you are, whether you are a business owner, marketer or programmer. This course will teach you everything even if you don’t have any previous experience. I try to make this course as engaging as possible. Yes, that’s right, it’s possible to make an engaging course on databases. [Read more…]

Udemy – PostgreSQL Advanced SQL Queries and Data Analysis

Udemy – PostgreSQL: Advanced SQL Queries and Data Analysis
English | Size: 601.48 MB
Category: CBTs

PostgreSQL is commonly known as Postgres and it is also open source database. There is an increasing need for data scientists and analysts to understand relational data stores. Organizations have long used SQL databases to store transactional data as well as business intelligence related data. If you need to work with SQL databases, this course is designed to help you learn how to perform common relational database and data science tasks, including writing advanced queries,data analysis , finding, exploration, and extraction within relational databases. [Read more…]

Udemy PostgreSQL From Zero to Hero

Udemy PostgreSQL From Zero to Hero
English | Size: 559.63 MB
Category: CBTs

Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users. [Read more…]

Udemy – PostgreSQL From Zero to Hero

Udemy – PostgreSQL: From Zero to Hero
English | Size: 556.39 MB
Category: CBTs

Learning SQL was one of the most valuable skills I learned while building Match. We had one of the largest instances of Microsoft SQL Server in the 90s with millions of records to keep the site running. The better we got at SQL, the better we could make the site work for our users and answers sophisticated questions about our users. [Read more…]

The Complete Python & PostgreSQL Developer Course

The Complete Python & PostgreSQL Developer Course
English | Size: 3.58 GB
Category: CBTs

Ever wanted to learn one of the most popular programming languages on the planet? Why not learn two of the most popular at the same time?
Python and SQL are used by many technology companies, small and large. That’s because they are powerful, yet extremely flexible.
Python is used in the industry for things like embedded software, web development, desktop applications, and even mobile apps!
PostgreSQL allows your applications to become even more powerful by storing, retrieving, and filtering through large data sets easily.
This course is your one-stop shop for everything Python and PostgreSQL, and the instructor is constantly available to support your learning and answer questions. [Read more…]

Udemy – Learn Database Design using PostgreSQL

Udemy - Learn Database Design using PostgreSQL

Title: Udemy – Learn Database Design using PostgreSQL
Video Format: MP4
File Size: 939 MB
[Read more…]

Pluralsight – A Tour of PostgreSQL with Rob Sullivan

Pluralsight - A Tour of PostgreSQL with Rob Sullivan

Title: Pluralsight – A Tour of PostgreSQL with Rob Sullivan
Video Format: MP4
File Size: 682 MB
More info
[Read more…]