Best Postgresql Courses

Find the best online Postgresql Courses for you. The courses are sorted based on popularity and user ratings. We do not allow paid placements in any of our rankings. We also have a separate page listing only the Free Postgresql Courses.

Google BigQuery & PostgreSQL : Big Query for Data Analysis

Become BigQuery expert by mastering Google BigQuery for data analysis. Cover all SQL qureies in PostgeSQL & Big Query

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 111313, Price: $29.99

Students: 111313, Price:  Paid

6 Reasons why you should choose this PostgreSQL and BigQuery course

  1. Carefully designed curriculum teaching you everything in SQL and Google BigQuery that you will need for Data analysis in businesses

  2. Comprehensive - covers basic and advanced SQL statements in both PostgreSQL and Google BigQuery

  3. Business related examples and case studies on SQL and Google BigQuery

  4. Ample practice exercises on Google BigQuery because SQL and Google BigQuery require practice

  5. Downloadable resources on SQL and Google BigQuery

  6. Your queries will be responded by the Instructor himself

A Verifiable Certificate of Completion is presented to all students who undertake this SQL and Google BigQuery course.

Why should you choose this course?

This is a complete tutorial on Google BigQuery and PostgreSQL which can be completed within a weekend. SQL is the most sought-after skill for Data analysis roles in all the companies. Google BigQuery is also in high demand in data analysis field. So whether you want to start a career as a data scientist or just grow you data analysis skills, or just want to learn Google BigQuery this course will cover everything you need to know to do that.

What makes us qualified to teach you?

The course is taught by Abhishek and Pukhraj. Instructors of the course have been teaching Data Science and Machine Learning for over a decade. We have experience in teaching and using Google BigQuery and PostgreSQL for data analysis purposes.

We are also the creators of some of the most popular online courses - with over 400,000 students and thousands of 5-star reviews like these ones:

I had an awesome moment taking this course. It broaden my knowledge more on the power use of SQL as an analytical tools. Kudos to the instructor! - Sikiru

Very insightful, learning very nifty tricks and enough detail to make it stick in your mind. - Armand

Our Promise

Teaching our students is our job and we are committed to it. If you have any questions about the course content, Google BigQuery, PostgreSQL, practice sheet or anything related to any topic, you can always post a question in the course or send us a direct message.

Download Practice files, take Quizzes, and complete Assignments

With each lecture, there is a practice sheet attached for you to follow along. You can also take quizzes to check your understanding of concepts on Google BigQuery and PostgreSQL. Each section contains a practice assignment for you to practically implement your learning on Google BigQuery and PostgreSQL. Solution to Assignment is also shared so that you can review your performance.

By the end of this course, your confidence in using Google BigQuery and PostgreSQL will soar. You'll have a thorough understanding of how to use Google BigQuery and PostgreSQL for Data analytics as a career opportunity.

Go ahead and click the enroll button, and I'll see you in lesson 1 of this Google BigQuery and PostgreSQL course.

Cheers

Start-Tech Academy

FAQ's

Why learn SQL?

  1. SQL is the most universal and common used database language.It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put,If you want to access databases then yes, you need to know SQL.

  2. It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people get interested data from database. It is also an English like language so anyone who can use English at a basic level can write SQL query easily.

  3. SQL is one of the most sought-after skills by hiring employers.

  4. You can earn good money

How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.

What are the steps I should follow to learn SQL?

  1. Start learning from the basics of SQL. The first 10 sections of the course cover the basics.

  2. Once done with the basics, try your hands on advanced SQL. Next 10 sections cover Advanced topics

  3. Practice your learning on the exercise provided in every section.

What's the difference between SQL and PostgreSQL?

SQL is a language. Specifically, the "Structured Query Language"

PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.

All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.

What is BigQuery used for?

BigQuery is a web service from Google that is used for handling or analyzing big data. Google BigQuery is part of the Google Cloud Platform. As a NoOps (no operations) data analytics service, Google BigQuery offers users the ability to manage data using fast SQL-like queries for real-time analysis.

Is BigQuery free?

For users of Google BigQuery the first 10GB of storage per month is free and the first 1TB of query per month is free. Post these limits, Google BigQuery is chargeable.

Which is better, PostgreSQL or MySQL?

Both are excellent products with unique strengths, and the choice is often a matter of personal preference.

PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.

Open source development will bring more features to subsequent releases of both databases.

Who uses these databases?

Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.

Google BigQuery is used by companies such as Spotify, The New York Times, Stack Etc.

React Fullstack with node/express, PostgreSQL and AWS

Learn how to setup a React Fullstack app on AWS with a PostgreSQL database

Created by Mohammad Iqbal - Full Stack Developer at Coding Spectrum

"]

Students: 42794, Price: Free

Students: 42794, Price:  Free

Learn the Most used technologies currently in web development

AWS is the most used Cloud computing platform by far, with over 30% market share.

PostgreSQL is the one of the most popular SQL based database engine in the world.

I dont think I need to say anything about React.

We will begin with the basics, then move onto setting up the database. We will setup the Express routes which will allow us to communicate with our database. Then we will build out the client side blog using React components. We will animate the posts and comments, then move onto something more difficult. We will begin AWS. I will give you a detailed explanation of how AWS works then we will go into a complex deployment with AWS.

The Complete Python & PostgreSQL Developer Course

Build 9 projects—master two essential and modern technologies in Python and PostgreSQL

Created by Rob Percival - Web Developer And Teacher

"]

Students: 30818, Price: $119.99

Students: 30818, Price:  Paid

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.

Gallop through — or go at your own speed

You'll gain immediate access over 160 lectures and more than 20 hours of content, each developed with ease of learning in mind.

Using my previous teaching experience I've created crystal-clear and original content which you'll find easy to understand - and more importantly - to absorb.

You'll find learning both quick and fun. And, I've used techniques proven to effortlessly lock that knowledge in, as you breeze through each comprehensive chapter.

Fun, fast, and effective

This course will get you from being an absolute Python and PostgreSQL beginner to an experienced software developer.

Don't believe me? I offer a full money back guarantee, so long as you request it within 30 days of your purchase of the course.

Are you ready to transform your world and become an uber-confident app developer?

I'll see you on the inside!

Database Engineer/DBA – (PostgreSQL, IBM-DB2, MariaDB,NoSQL)

Practical Database Engineering | Administration

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 29100, Price: $74.99

Students: 29100, Price:  Paid

Database engineers design new databases based on company needs, data storage needs, and the number of users accessing the database. Monitor Databases and Programs. Database engineers continuously monitor databases and related systems to ensure high functionality.

Database administrator ensures that data is available, protected from loss and corruption, and easily accessible as needed. Also they oversee the creation, maintenance and security of your databases. manages, backs up and ensures the availability of the data.

PostgreSQL is commonly known as Postgres and it is also  open source database.  PostgreSQL is a powerful, open source object-relational database system.

IBM Db2 is a family of related data management products,including relational database servers, developed and marketed by IBM.

MariaDB is great for its open-source innovation and enterprise-grade reliability, as well as its modern relational database.

SQL -Structured Query Language is an internationally recognized language used to communicate and manipulate various database systems.

Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data . From our interaction with our banks to social media applications like Facebook and Instagram..

Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand  to help interact with various databases to help business intelligence and other sectors that relies on data.

NoSQL (Non-SQL or Not-only-SQL) databases are increasing in popularity due to the growth of data as they can store non-relational data on a super large scale, and can solve problems regular databases can't handle. They are widely used in Big data operations. Their main advantage is the ability to handle large data sets  effectively  as well as scalability and flexibility issues for modern applications.

Python Developer: Python/Django/Flask/PostgreSQL/MySQL/API

Develop Applications with Python step by step

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 28989, Price: $69.99

Students: 28989, Price:  Paid

Python is a dynamic modern object -oriented programming language  and can be used to do a lot of things both big and small.   Python is what is referred to as a high level language. That means it is a language that is closer to humans than computer.It is also known as a general purpose programming language due to it's flexibility. Python is an interpreted language that does not need to be complied like for example java programming language. It is interpreted and run on the fly the same time.

Python has been used in a lot of places like in creating games, for statistical data and visualization,speech and face recognition.

Some of the biggest websites on this planet earth use python in one way or another. Examples include:

  • Google

  • Youtube

  • Facebook

  • Nasa

  • Disney

  • Pixar

  • Reddit

  • Pinterest

  • Instagram

  • Spotify

  • Survey Monkey

  • Yahoo Maps

Topics covered include:

  • Interacting with Python in various ways

  • Python Operators

  • Python Data Types

  • Data type casting

  • Python String Methods and Formatting

  • Python Data Structures

  • Python Functions

  • Python DocStrings

  • Python Decorators

  • Python Control Flow Statements

  • Python Modules and Packages

  • Working with external files in Python

  • Working with dates and times

  • Working with calendars

  • Handling exception errors

  • Version control system with Git and Github

  • Web scrapping with Python

  • Python and Machine Learning

  • Web development with Django

  • Creating a database driven application

  • Python Object Oriented Programming

Projects we will create:

  • Create a web based todo app and deploy to cloud

  • Database CRUD  app with SQL Server and Python

  • MP3 Player

  • Lottery Number Simulator

  • Loan calulator

  • Create a basic calculator

  • Create a digital clock

  • Create a number guessing game

  • Create a random number generator

  • Create a countdown timer

  • Create a lottery number simulator

SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL

Learn Both SQL Server & PostgreSQL By Doing. Enhance Your Data Analytics Career With Real World Data Science Exercises

Created by Kirill Eremenko - Data Scientist

"]

Students: 24890, Price: $89.99

Students: 24890, Price:  Paid

Are you interested in a career in Data Science or Data Analytics?

In that case, inevitably you are going to encounter databases in your work.

But how do you interact with databases?

The answer is simple: SQL 

SQL stands for Structured Query Language and this is one of the main tools used to organize databases, input data into them and extract it on request.

In this course you will learn how to create queries in a popular variation of SQL called PostgreSQL. 

And even if at your workplace you are using a different variation (e.g. Oracle, SQL Server or MySQL), you will find that the skills you learn in this course are easily transferable.

But there are many SQL courses out there, so the question is:

What makes this course stand out?

The unique advantage of this course is that in addition to learning SQL you will also master the concepts of Database Design.

We will cover off topics such as:

- OLAP vs OLTP databases (Online Analytics Processing & Online Transaction Processing): you will understand exactly how and why the designs of these two types of Databases differ

- Normalization of Databases: we will show you the theory behind normalization AND together we will practice how to normalize a Database step-by-step

Why is that important?

Knowing how databases are designed is not a compulsory skill to have for a Data Scientist / Analyst. However, it's a HUGE added benefit.

These skills will allow you to better interact with databases and derive results and extract insights from your data faster.

This course is designed with the Data Scientists and Analysts in mind, so if you want to propel your Data Science career, then this course is for you!

We look forward to seeing you inside,

Kirill & Ilya

SQL for beginners with :( PostgreSQL, MySQL, SQL Server )

Master the basics of querying databases and manipulating data

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 24454, Price: $69.99

Students: 24454, Price:  Paid

SQL is a standard language for accessing and manipulating databases.

SQL is one of the most  in-demand tech skill used across many industries.

What is SQL?

SQL stands for Structured Query Language

What Can SQL do?

  • SQL lets you access and manipulate databases

  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can create views in a database

  • SQL can filter data returned from a database

  • SQL can sort data returned by a database.

  • SQL can be used to truncate and drop tables.

PostgreSQL is a powerful, open source object-relational database system.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.

MySQL is a relational database management system based on SQL – Structured Query Language. The application is used for a wide range of purposes, including data warehousing, e-commerce, and logging applications. The most common use for mySQL however, is for the purpose of a web database.

SQL SERVER is a relational database management system (RDBMS) developed by Microsoft. It is primarily designed and developed to compete with MySQL and Oracle database.

SQL Server supports ANSI SQL, which is the standard SQL (Structured Query Language) language. However, SQL Server comes with its own implementation of the SQL language, T-SQL (Transact-SQL).

T-SQL is a Microsoft propriety Language known as Transact-SQL. It provides further capabilities of declaring variable, exception handling, stored procedure, etc.

SQL Server Management Studio (SSMS) is the main interface tool for SQL Server, and it supports both 32-bit and 64-bit environments.

SQL Crash Course : PostgreSQL for Beginners

SQL course covering important topics of Business Intelligence for SQL Database ( PostgreSQL ) for Beginners

Created by Start-Tech Academy - 3,000,000+ Enrollments | 4+ Rated | 160+ Countries

"]

Students: 20462, Price: Free

Students: 20462, Price:  Free

Why learn SQL?

  1. SQL is the most universal and common used database language.It powers the most commonly used database engines like PostgreSQL, SQL Server, SQLite, and MySQL. Simply put,If you want to access databases then yes, you need to know SQL.

  2. It is not really difficult to learn SQL. SQL is not a programming language, it’s a query language. The primary objective where SQL was created was to give the possibility to common people get interested data from database. It is also an English like language so anyone who can use English at a basic level can write SQL query easily.

  3. SQL is one of the most sought-after skills by hiring employers.

  4. You can earn good money

How much time does it take to learn SQL?

SQL is easy but no one can determine the learning time it takes. It totally depends on you. The method we adopted to help you learn SQL quickly starts from the basics and takes you to advanced level within hours. You can follow the same, but remember you can learn nothing without practicing it. Practice is the only way to learn SQL quickly.

What are the steps I should follow to learn SQL?

  1. Start learning from the basics of SQL. The first 10 sections of the course cover the basics.

  2. Once done with the basic try your hands on advanced SQL. Next 10 sections cover Advanced topics

  3. Next few sections will cover help you with interviews and Vivas.

  4. Practice your learning on the exercise provided in every section.

What's the difference between SQL and PostgreSQL?

SQL is a language. Specifically, the "Structured Query Language"

PostgreSQL is one of several database systems, or RDMS (Relational Database Management System). PostgresSQL is one of several RDMS's, others of which are Oracle, Informix, MySQL, and MSQL.

All of these RDMSs use SQL as their language. Each of them have minor variations in the "dialect" of SQL that they use, but it's all still SQL.

Which is better, PostgreSQL or MySQL?

Both are excellent products with unique strengths, and the choice is often a matter of personal preference.

PostgreSQL offers overall features for traditional database applications, while MySQL focuses on faster performance for Web-based applications.

Open source development will bring more features to subsequent releases of both databases.

Who uses these databases?

Here are a few examples of companies that use PostgreSQL: Apple, BioPharm, Etsy, IMDB, Macworld, Debian, Fujitsu, Red Hat, Sun Microsystem, Cisco, Skype.

What's special about this course?

The course is created on the basis of three pillars of learning:

  1. Know (Study)

  2. Do (Practice)

  3. Review (Self feedback)

Know

We have created a set of concise and comprehensive videos to teach you all the SQL related skills you will need in your professional career.

Do

We also provide Exercises to complement the learning from the lecture video. These exercises are carefully designed to further clarify the concepts and help you with implementing the concepts on practical problems faced on-the-job.

Review

Check if you have learnt the concepts by executing your code and analyzing the result set. Ask questions in the discussion board if you face any difficulty.

Bonus Lectures

Apart from this, their is a bonus section which covers important topics from the view of job interviews and Vivas.

The Authors of this course have several years of corporate experience and hence have curated the course material keeping in mind the requirement of SQL in today's corporate world.

SQL with PostgreSQL for Beginners: Analyze | Manipulate Data

Write SQL Queries for Data Analysis and Manipulation on PostgreSQL Databases

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 20207, Price: $89.99

Students: 20207, Price:  Paid

SQL stands for Structured Query Language. It is one of the most in-demand tech skills in the world.

What Can SQL do?

  • SQL lets you access and manipulate databases

  • SQL can execute queries against a database

  • SQL can retrieve data from a database

  • SQL can insert records in a database

  • SQL can update records in a database

  • SQL can delete records from a database

  • SQL can create new databases

  • SQL can create new tables in a database

  • SQL can create stored procedures in a database

  • SQL can filter data returned from a database

  • SQL can sort data returned by a database.

  • SQL can be used to truncate and drop tables.

PostgreSQL is a powerful, open source object-relational database  management system.

PostgreSQL is an advanced, enterprise-class, and open-source relational database system. PostgreSQL supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL is a highly stable database backed by more than 20 years of development by the open-source community.

PostgreSQL is used as a primary database for many web applications as well as mobile and analytics applications.

What You Will Learn

  • Perform CRUD Operations

  • PostgreSQL Database Objects

  • Database Concepts

  • Creating a database using PostgreSQL GUI

  • Creating tables with PostgreSQL GUI and SQL Commands

  • Inserting Data into tables

  • Query and read data stored inside a table

  • Filter and Sort data from a table

  • Using Sub query to retrieve data

  • Updating existing data stored inside a database

  • Query and eliminate duplicate records

  • Deleting records stored inside database

  • Truncating a database table

  • Dropping a database table

  • Implementing Stored Procedure

  • Joining and querying data from multiple tables

  • Using various aggregate functions and grouping data

  • Using various Operators to query data

  • Using various Analytic Functions

SQL & PostgreSQL for Beginners: Become an SQL Expert

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 - IT Systems Engineer and SQL Instructor

"]

Students: 16878, Price: $129.99

Students: 16878, Price:  Paid

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 has never been higher 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 2019 survey of stackoverflow developers reported that one third of developers used PostgreSQL on a daily basis in their professional lives, up from 25% in 2018. In 2019 PostgreSQL was the fastest growing database for the third 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

  • Apply SQL string functions to data in PostgreSQL

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!

AWS RDS Databases – Fast Track

Fast-track training to work with relational databases on AWS Cloud using AWS Relational Database Service.

Created by Siddharth Mehta - Enterprise Cloud Architect, Published Author, Cloud Geek

"]

Students: 16849, Price: Free

Students: 16849, Price:  Free

Hi! Welcome to the AWS RDS Databases - Fast Track Training, the only comprehensive and most impactful course on AWS RDS that is available FREE of Cost. This is the only course you would need to get started with AWS RDS.

This course is taught by an Enterprise Cloud Architect, who leads large teams of junior architects in the real world, who has an industry experience of close to two decades in the IT industry, who is a published author, and leads technology architecture of XXX million dollar projects on cloud for multi-national clients.

This course teaches to work with the following AWS RDS Databases along with its related client tools like HeidiSQL, PgAdmin and Oracle SQL Developer. So if you are new to AWS RDS or are preparing for a quick technical discussion on AWS RDS with very limited time at hand, this is the perfect course for you.

  • MariaDB is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Organizations like Wikipedia, WordPress and Google uses MariaDB. It is an enhanced, drop-in replacement for MySQL. MariaDB is used because it is fast, scalable and robust, with a rich ecosystem of storage engines, plugins and many other tools make it very versatile for a wide variety of use cases. MariaDB is developed as open source software and as a relational database it provides an SQL interface for accessing data.

  • PostgreSQL is the one of the world’s most advanced open source and popular database. PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, macOS, Solaris), and Windows. It is abbreviated as Postgres because of ubiquitous support for the SQL standard among relational databases.

  • Oracle is a proprietary multi-model database management system from Oracle Corporation. It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads.

This course is composed of almost 90% labs and also covers the fundamental theory of important AWS RDS Concepts with some basic FAQs as well. After pursuing this course, if you have any questions related to the subject or need suggestions about pursuing the next course related to AWS data services, please do not hesitate to contact me.

I hope to see you soon in the class !

SQL CRUD Operations with PostgreSQL

Learn to perform CRUD Operations using PostgreSQL

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 15522, Price: $24.99

Students: 15522, Price:  Paid

PostgreSQL is a very popular , advanced, open-source object-relational database management system  used by a lot of organizations.

It is a very robust database management system.

Any software or a web application will typically do these set of operations called C.R.U.D.

CRUD Stands for

Create (Insert)

Read (Select)

Update

Delete

In this course we will be using SQL and PostgreSQL to perform CRUD operations .

What we will learn include:

  • How to install PostgreSQL Database Server

  • How to Load a sample database into PostgreSQL Server

  • How to Create a database and table

  • How to insert data into a table

  • How to query and retrieve data from a table

  • How to update existing data inside a table

  • How to delete data from a table

  • How to sort retrieved data from a table

  • How to Filter data using WHERE clause

  • How to remove duplicate data

  • How to use subqueries to query and retrieve data

  • How to group data using GROUP BY clause

  • How to use the HAVING clause to group data

SQL and PostgreSQL: The Complete Developer’s Guide

Become an expert with SQL and PostgreSQL! Store and fetch data, tune queries, and design efficient database structures!

Created by Stephen Grider - Engineering Architect

"]

Students: 14907, Price: $109.99

Students: 14907, Price:  Paid

Database structure design?  It's here.  Query tuning and optimization? You'll master it.  Complex queries? Yes indeed!

This is the only course online that will teach you how to design a database, store complex data, optimize your queries, everything that is needed for operating a production, scalable database!

Every app in the world, whether it is a mobile app built with Flutter, a web app constructed with React, or a plain HTML page, needs to store information in a database.  Although there are many different databases you can use, PostgreSQL has been a number-one pick for decades, offering scalable performance, rock-solid uptime, and flexible design systems.  This course will teach you everything you need to know about PostgreSQL to use it on your next big project!

Don't know anything about databases at all? No problem. We begin with an overview of SQL, the language used to interact with PostgreSQL. Through an incredible number of exercises, you'll get practical, hands on experience working with realistic datasets.  You will understand how to store, fetch, and update information with a series of powerful commands. 

After gaining experience with elementary operations, you will move on to understanding database design patterns, offering multiple ways to structure your database for efficient data modeling. You'll see many different scenarios with different types of data, and understand the pros and cons to several approaches.

This course is packed with practice exercises and quizzes. You'll get immediate practice on all of the different topics and features that you learn!  In addition, you'll understand exactly where to use each of these features in real and practical projects.

Besides getting practical hands-on experience, you'll also get a behind-the-scenes look at how PostgreSQL works internally. We'll dive into raw data files, investigating how PostgreSQL stores information on your hard drive bit by bit.  This knowledge is invaluable when it comes time to start tuning your queries for performance.  By having a natural instinct of how PostgreSQL works, you can plan on being able to get every last bit of performance out of your database.

Here is a partial list of some of the topics that are covered in this course:

  • Apply powerful SQL commands to store, update, and retrieve information

  • Build relationships between records using foreign keys between tables

  • Understand PostgreSQL's numerous data types, and when to use each

  • Assemble reports of business data by using aggregation pipelines

  • Work with millions of records to simulate real production queries

  • Exercise your query logic skills through the use of sets and sorting operators

  • Compose queries out of smaller reusable units using subqueries

  • Use different design patterns to efficiently model your data

  • See how to divide database objects into different schemas to maintain them more easily

  • Validate your data using simple 'check' rules

  • Construct perfect designs for common features such as 'like', 'follow', and 'tag' systems

  • Speed up your queries with indexes - you'll see exactly how they work behind the scenes!

  • Dive into some of the most complex queries around with recursive common table expressions

  • Deal with concurrency issues easily by applying transactions

I made this course to be the perfect resource for engineers just getting started with their first database.  Master the database itself, and see how to apply it with real designs.  Sign up today and master PostgreSQL!

Learn SQL Using PostgreSQL: From Zero to Hero

Master PostgreSQL starting with basics to advanced features like triggers, PL/pgSQL functions, Window Functions and CTE

Created by Will Bunker - Cofounder of bootstrapped company that became Match.com

"]

Students: 12337, Price: $99.99

Students: 12337, Price:  Paid

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.  

I want to teach you how to use PostgreSQL.  We will walk through

  • Basic selection statements

  • Joining multiple tables together

  • Grouping records to get aggregate data

  • Inserting, updating and deleting records

  • Creating tables and indexes

  • Subqueries to create sophisticated reports

  • Table constraints to keep data clean

  • Sequences to create auto incrementing fields

  • CTE - common table expressions that include recursive queries

  • Views to simply accessing complex queries

  • Conditional Expressions for queries

  • Window functions to combine regular queries with aggregate data

  • How to work with date, time and intervals

  • Create SQL Functions to capture complex statements

  • Create PL/pgSQL Functions that allow programming with if/then and loops

  • Triggers

  • Array data types

  • Composite data types

  • Transactions and concurrency control

Writing Advanced SQL Queries on PostgreSQL

Learn to create more complex SQL Queries

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 8815, Price: $89.99

Students: 8815, Price:  Paid

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  advanced queries using various analytic and aggregate functions.

What you will learn includes:
Downloading and installing PostgreSQL
Querying tables 
Introduction to Aggregate Functions
Writing queries to perform various aggregate functions like: AVG, COUNT, SUM, MIN,MAX
Introduction to Analytic Functions
Illustrating various Analytic functions
Row Number Functions
Using various types of Operators
Introduction to Table Joins
Using various types of joins
Windowing functions for working with ordered data sets
Postgresql INNER JOIN
Retrieving all Data from Table
PostgreSQL FULL OUTER JOIN
PostgreSQL CROSS JOIN
PostgreSQL NATURAL JOIN 
PostgreSQL Left Join

The course will teach you how to aggregate data,analyse data ,retrieve data from multiple tables using table joins and write more advanced queries.

SQL Crash Course for Aspiring Data Scientist

Learn SQL and Data Science FAST with hands on labs!

Created by Bob Wakefield - Data Management Expert

"]

Students: 7727, Price: Free

Students: 7727, Price:  Free

The problem with online learning and self-guided learning, especially in programming, is that you are often not certain exactly where to get started on your journey. But you do know that having to run to the IT department whenever you need data pulled, or need a dataset to be created, can sometimes leave you stranded.

SQL, as an easy programming language designed for interacting with relational databases, is your starting point when it comes to anything data related. The user base of SQL is so deep that many big data technologies utilize some kind of port of SQL.

The problem with other SQL for data science classes is that, by only covering SQL itself, they leave you hanging on your journey to data science mastery, much like when you have to rely on IT to meet your data needs.

With Mass Street University, that journey does not end with bare bones knowledge of SQL. DSCI100: SQL Crash Course for Data Science is designed to quickly get you up to speed on the basics of using SQL. But this course does more than give you the SQL foundation you need to work with data.

In DSCI100, we extend your journey by teaching you some real data science. By demonstrating how Python and Apache Spark interact with SQL in hands-on labs, we teach you how SQL is actually used in a data science workflow once you have mastered the basics.

At the end of the course, you will be able to work with relational databases to pull the necessary data you need to perform complex analyses…without the assistance of IT. You will also have a good understanding of how to use SQL with common data science languages.

No other course will grant you the tools and fuel that allow you to take control of your journey. Enroll today for a real, self-sufficient path to data science excellence.

Microsoft SQL Crash Course for Absolute Beginners

This Crash course uses Microsoft SQL Server. The SQLs used here can also used in Oracle, MySQL, PostgreSQL, SQLite,etc.

Created by Sandeep Kumar - Founder of a Training company. IT Consultant, Coach, Mentor

"]

Students: 7238, Price: Free

Students: 7238, Price:  Free

'This Course covers SQL using Microsft SQL Server but you can apply these SQL queries in Oracle, MySql, PostgreSQL, Microsoft Access, SQLite, and DB2'.

"Welcome to the most popular Quality crash Course on Microsoft SQL Server(MS SQL Server)"

  • Covers different forms of SELECT Statements

  • Explains how to filter the Records

  • All the Arithmetic operators are explained

  • NULL Values are explained

  • Beautiful examples of all the operators

  • ORDER BY, GROUP BY, HAVING clauses has examples in detail

  • The course covers all the Aggregate Functions and other Functions

  • UNION and JOINs are explained with real-life examples

  • I have explained all types of Joins

  • Data types used in Microsoft SQL

======================================================================================

Join this course which is the best "Microsoft SQL" course. I will share all the syntax of SQL with multiple examples along the way!!!

Want to start learning SQL from scratch with no previous coding experience?

You have come to the right place. Please have a look at the Course content carefully and ask a few questions yourself?

  • I have shared all the codes which are used in this course

  • Is the Course taught by a real-time expert? I have more than 15  years of experience as an Instructor and more than 10 years of experience in SQL. I firmly believe that if an Instructor does not have a good experience, he/she will flood the course with poor content.

  • Is the Course content clear and Precise? The content is short, crisp, and clear.

  • The course assumes no prior knowledge of MS SQL(Microsoft SQL Server) and teaches you from scratch to an advanced level

  • Once you Enroll in this Course, you get lifetime access to this course and you will get all the future updates.

  • The course does not cover T-SQL directly but it will help you to learn T-SQL also.

  • This will also help you to get Microsoft certification.

  • This Course is not for DBA(Database Administration) but certainly, helps you to become better.

  • If you plan to work with other databases like Oracle, MySQL, SQLite, PostgreSQL, etc, it will be extremely helpful.

  • If you are a data scientist (Data Analysis role) or willing to become a data scientist, then SQL is a must and this course helps in data analytics.

Do you want to start on SQL but have no experience with SQL? 
If you have some prior knowledge of SQL or if you are a complete fresher, you are at the right place. The Course teaches you to SQL right from Scratch. It will be the best course for absolute beginners.

There’s no risk involved in taking this Course!
I am sure that this is the best crash course on SQL and it is the perfect starting point to learn the basics of SQL.

What if you are stuck?

I personally answer all the questions which are asked here. If you are stuck anywhere, ask a question or you can message me directly and I will answer all your doubts.

Are you getting updated content?

Yes, I keep updating the content always to make sure, I provide all the information to my students.

Once you enroll for this course-

1) Selecting Records from Table - SELECT statement in SQL

2) Filtering the Records - Using WHERE clause in SQL

3) Sorting Records - Using ORDER BY clause

5) Grouping data - using GROUP BY clause

6) complete guide with examples of all the Functions - All aggregate functions covered

7) Creating simple and advanced Tables - with constraints and without constraints

8) Keys, Index - PRIMARY KEY, FOREIGN KEY, UNIQUE INDEX

9) Inserting records(loading) - with INSERT Statement

10) Updating the records of a Table - Using UPDATE statement

11) Combining multiple tables - Using UNIONS

12) Joining multiple columns of different tables - Using JOINs

13) Modify table properties - ALTER statement

14) Deleting records from the table - DELETE statement

15) Removing tables from the database permanently - DROP statement

Note: This course helps to learn SQL using Microsoft SQL Server but it will also help to master SQL if you want to learn Oracle SQL, MySql, PostgreSQL, SQLite, DB2, etc.

The Complete Python/PostgreSQL Course 2.0

Take the next step in your Python development by leveraging the power of PostgreSQL and databases!

Created by Codestars by Rob Percival - Teaching the Next Generation of Coders

"]

Students: 6926, Price: $109.99

Students: 6926, Price:  Paid

Master PostgreSQL and use it in your Python apps!

Python and PostgreSQL are two of the most in-demand skills in the world. After completing this course, you'll be confident in adding both to your resume/CV.

In addition, all the database knowledge you'll gain in this course is easily transferable to other databases such as MySQL, Microsoft SQL Server, Amazon Redshift, Oracle, and others!

The focus of this course is on fully understanding PostgreSQL and effectively integrating it with your Python applications. If you're a Python developer or you use Python at all, and you want to start using a PostgreSQL database, you're going to love this course!

You will:

  • Add data storage to your Python apps with in-memory databases, SQLite, and PostgreSQL.

  • Understand when to use different types of databases in your applications.

  • Build a programming journal project to learn how to add a SQLite database to your application.

  • Create a movie watch-list app to explore how to improve your database design over time, as well as how to model different types of relationships.

  • Migrate the movie watch-list app to PostgreSQL to identify the differences between PostgreSQL and SQLite.

  • Build a polling app to learn about advanced data analysis with GROUP BY, PostgreSQL window functions, and nested queries.

  • Extend the polling app to work with dates and times, and avoid common timezone pitfalls.

  • Learn how to structure Python apps professionally, to make development easy when working with databases.

  • Explore advanced SQL and PostgreSQL concepts such as user-defined functions, stored procedures, locking, and async database connections with Python.

  • Take all your knowledge and apply it to produce data analysis reports and charts using matplotlib.

As you can see, you're going to learn a lot!

But this is a no-nonsense, no-frills course. Every lecture has been planned, crafted, and edited to be perfectly concise and to the point. That way you can learn everything, quickly and easily.

Throughout the course, we have animated diagrams to explain database concepts, as well as code-along videos when we're working with Python. But you won't just be watching me code! I've carefully planned and mapped out every project and feature we add, and I encourage you to try them on your own first, before following along with me!

Also, throughout the course, I provide data sets with challenges and exercises for you to practice what you've learned.

I've been teaching and helping students online for over 7 years, and this course is the culmination of my teaching experience. I know how to help you understand concepts fully and quickly, in the best way for you.

Upon completing this course you'll be able to easily extend your Python applications with database functionality using PostgreSQL. You'll know how to answer questions using data, and you'll definitely be able to list PostgreSQL as one of your strongest skills.

Check out the free preview videos for more information and to try out the course!

I'll see you on the inside!

Top Database Bundle: MySQL, PostgreSQL, SQLite3, SQL Server

Learn MySQL, POSTGRES, SQLite, and Microsoft SQL Server The Fast and Easy Way!

Created by John Elder - Founder of Codemy

"]

Students: 6896, Price: $99.99

Students: 6896, Price:  Paid

In this course we'll learn the MySQL Database, the POSTGRES Database,  the SQLite Database, and the Microsoft SQL Server from an absolute Beginner level all the way to Advanced in no time at all!

This course is aimed at the absolute beginner, you don't need any coding or database experience at all!

We'll start out by downloading and installing each of these databases - all for free. This will give you all the tools you need to start writing and running code for your databases. 

Then, we'll dive into very basic database concepts. Things like:

  • What Is A Database

  • How To Install Each Database

  • How To Install Git Bash Terminal

  • How To Connect To Your Database

  • How To Create A Database

After that, we'll move into more intermediate topics like:

  • How To Create A Table

  • How To Insert One Record Into Table

  • How To Insert Many Records Into Table

  • Understanding Data Types

  • How To Select Data From Table

  • How To Format Our Results

  • How To Use The Where Clause

  • How To Use The Like Clause and Wildcards

  • How To Use AND and OR

  • How To Updating Records

  • How To Limit and Order Results

  • How To Delete Records

  • How To Delete (Drop) A Table And Backups

Finally we'll finish up with more advanced topics like:

  • Foreign Keys

  • Inner Joins

  • Join Where Hacks

  • And More...

We'll learn all of those things for MySQL, PostgreSQL, SQLite, and Microsoft SQL Server. We'll start with MySQL, and then move over to PostgreSQL, then hit SQLite before finishing up with Microsoft SQL Server. This is a bundle course of four of my other popular courses.

These databases are four of the greatest databases to learn, and learning has never been this easy!  They're the most popular and in demand for a reason! Let's learn some databases!

I'll see you on the inside!

-John Elder

Intro To PostgreSQL Databases With PgAdmin For Beginners

Intro To SQL and PostgreSQL for Creating Databases and Writing SQL Queries using PostgreSQL and PgAdmin 4

Created by John Elder - Founder of Codemy

"]

Students: 6794, Price: $99.99

Students: 6794, Price:  Paid

In this course I'll teach you how to setup and use PostgreSQL databases with the PgAdmin 4 interface! 

There's a reason why Postgres is so popular, find out why in this course!

You have many databases to choose from, and even many free databases to choose from. But Postgresql is constantly ranked a top database for everything from data analytics to basic web development - and everything in between. 

Postgres is pretty easy to use!  You'll be amazed at how quick and easy it is to dive in and get started!

In this course, you learn to:

  • Install pgAdmin and PostgreSQL

  • What Is A Database

  • pgAdmin Overview

  • Create Table Columns

  • Add Data To A Table

  • PostgreSQL Select Statements

  • PostgreSQL Where Clause

  • PostgreSQL Wildcards

  • PostgreSQL AND OR NOT

  • PostgreSQL Order By

  • PostgreSQL Insert Into

  • PostgreSQL Update

  • PostgreSQL Delete

  • PostgreSQL Limit

  • pgAdmin Menu Walkthru

  • PostgreSQL Foreign Keys

  • PostgreSQL Inner Join

  • PostgreSQL Join Where Hack

  • PostgreSQL Delete Table

  • PostgreSQL Import and Export Tables

  • PostgreSQL Backup and Restore Database

  • And More!

This course is perfect for anyone just starting out, you don't need any special skills or prior knowledge to take this course.

And as always, we offer a 100% money back guarantee if you aren't completely happy with the course.  No questions asked!

My name is John Elder and I have nearly 40 courses here at udemy, with close to 45,000 students and over 105,000 enrollments. I've been writing code and developing neat things online for over 20 years and I'd love to teach you what I know!

What are you waiting for, let's learn some PostgreSQL database wizardry!

-John Elder

CEO Codemy. com

PostgreSQL Database Administration (DBA) for Beginners

Learn Practical Database Administration

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 5235, Price: $94.99

Students: 5235, Price:  Paid

PostgreSQL is commonly known as Postgres and it is also  open source database.

PostgreSQL is a powerful, open source object-relational database system.

A database administrator’s (DBA) primary job is to ensure that data is available, protected from loss and corruption, and easily accessible as needed.

The PostgreSQL administration covers some of  the most important PostgreSQL database server administration activities.

Some of the Key Responsibilities of a Database Administrator includes:

  • Database Management

  • Database Backup and restore

  • Tablespace management

  • Role Management

  • Managing users

  • Securing database via proper role management

A DBA ( Database administrator) has to perform several responsibilities to ensure the smooth running of the SQL sever database.

In this course, we will go over the basics of the PostgreSQL. We will cover topics ranging from installations, to writing basic queries and retrieving data from tables. We will also explore the logic of joining tables to retrieve data and much more.

 The course also covers the basics of creating tables, storing data with data types, and working with expressions,  operators, and strings.

Topics also includes:

  • Installing PostgreSQL

  • Loading sample database

  • Creating database and tables

  • Performing CRUD operations

  • Joining Tables

  • Using aggregate and analytic functions

  • Creating views and triggers

This is a practical hands-on course that will equip you with the skills and confidence to work with PostgreSQL .

Ethical Hacking with Nmap and Metasploit Framework Part-2

Learn to conduct vulnerability assessment with Nmap and penetration testing Metasploit

Created by Rajneesh Gupta - Cyber Security Practitioner and Instructor

"]

Students: 4700, Price: Free

Students: 4700, Price:  Free

Learn to conduct vulnerability assessment with Nmap and penetration testing Metasploit framework.

Nmap ("Network Mapper") is a free and open source (license) utility for network discovery and security auditing. Many systems and network administrators also find it useful for tasks such as network inventory, managing service upgrade schedules, and monitoring host or service uptime.

The Metasploit Project was undertaken in 2003 by H.D. Moore for use as a Perl-based portable network tool, with assistance from core developer Matt Miller. It was fully converted to Ruby by 2007, and the license was acquired by Rapid7 in 2009, where it remains as part of the Boston-based company’s repertoire of IDS signature development and targeted remote exploit, fuzzing, anti-forensic, and evasion tools.

Up and Running With PostgreSQL 11

The Modern and Most Used Relational Database

Created by Nelson Jamal - Software Engineer

"]

Students: 4542, Price: $74.99

Students: 4542, Price:  Paid

Overview

PostgreSQL is a general purpose and object-relational database management system, the most advanced open source database system widely used to build back end systems.

Startups including big companies such as Apple, Cisco, Redhat and more use Postgres to drive their business.

The Goal of this course is to help anyone to become familiar with Relational Databases and learn most common used SQL statements, allowing you execute queries agains any relational database.

Course Road Map

  • Introduction to PostgreSQL

  • Setup your environment and get ready to start coding for both MacOS and Windows

  • Create, Read, Update & Delete (CRUD) commands

  • Learn about different ways of filtering data using where clause

  • Work with Date and Timestamps

  • Lean how to to Join and Left Join to combine data from one more tables

  • Postgres extensions and how sequences are managed

  • Learn how to create tables with the right constraints

  • Learn how to export data to CSV files

  • Congratulations. You will be ready to right SQL and have a great understanding of Postgres database

Let's get started now

PostgreSQL v12 Database Administration on Windows and Linux

Comprehensive Guide to PostgreSQL v12 Database Administration : Walk-in a Beginner, Walk-Out an Expert

Created by Sadiq Basha - Senior Production Database Administrator

"]

Students: 2983, Price: $34.99

Students: 2983, Price:  Paid

PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.

PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.

The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.

Topics covered are:

  • PostgreSQL Process and Memory Architecture

  • Installation of PostgreSQL v12 - Windows and Linux

  • Setup PostgreSQL v12 Environment Variables - Windows and Linux

  • PostgreSQL Page Layout

  • Database Directory Layout

  • PostgreSQL Configuration Files

  • Cluster in PostgreSQL (Initdb,Start/Stop,Reload/Restart Cluster)

  • Createdb/Dropdb, Createuser/Dropuser Utility

  • Create Schema and Schema Search Path

  • Psql Interface Commands

  • Pg System Catalogs

  • Working with PostgreSQL Objects

  • CRUD Operations

  • Table Inheritance

  • Table Partitioning

  • Tablespace in PostgreSQL

  • Backup, Continuous Archiving and PITR (Point-in-Time-Recovery)

  • Explain plan and Query Execution Cost

  • Maintenance (Updating Planner Statistics, Vacuum, Routine Reindex & Cluster)

  • Data Fragmentation

  • Transaction ID wraparound, Vacuum freeze, Auto_Vacuum Demon

  • Pgadmin 4

  • Uninstall PostgreSQL v12 on Windows and Linux

  • Bonus Module

PostgreSQL Bootcamp: SQL and PostgreSQL Database Masterclass

Become a Database Guru from Basic to Advance SQL PostgreSQL queries. Use SQL queries for Data analysis and Visualization

Created by Prathap G - Technical Enterprise Architect

"]

Students: 2921, Price: $74.99

Students: 2921, Price:  Paid

*** This Course purchase includes video lectures, practice files, quizzes, & assignments, 1-on-1 instructor support, LIFETIME access and a 100%MONEY-BACK GUARANTEE***

Please note that this course will be continuously getting updated with more videos to keep you up to date on PostgreSQL. You will find lot of new lecture covering new features in the area of  PostgreSQL. Best part about this course is that, You can also demand a lecture on a specific topic of  PostgreSQL, which comes under the scope and I will make sure that the section on that Topic is added .

This course is designed for the beginners and freshers to gain knowledge on PostgreSQL and to use them in their projects/assignments. You will find different techniques to construct the SQL queries. The professionals who have zero knowledge or very less knowledge on SQL queries, will find this course extremely useful.

Learning SQL and PostgreSQL also helps you to become better data analyst and eventually would help you to get into the field of Data Science/ Data Analysis/ Data Visualization.

I will Guide you through a STEP by STEP approach on how to write SQL Queries. I will also explain about different ways to write very efficient SQL queries. I will first start with the installation of  PostgreSQL database and PgAdmin 4 and then will install the North wind database model. I will then start writing some of the Simple SQL Queries and then slowly move towards filtering, grouping  and slicing the data. Then, I will be working on more complicated topics like Joins, Operators, Inbuilt Functions and eventually by the end of the course you would be able to write complicated SQL queries.

You should be able to complete this course in a week time, if you dedicate 2 hours of your time daily and this journey will take you from zero to Hero.

Important Topics covered:

  • Installation of PostgreSQL and Pgadmin 4

  • What is a SQL and Database and its Background

  • Understanding the Northwind Data Model

  • Selecting the data from Tables

  • Filtering the data from Tables

    Usage of Arithmetic and Logical Operators

  • Understand the GROUP BY , HAVING

  • Understand Various SET Operators

  • Learn Various Joins in PostgreSQL

  • Step by Step approach in creation of Complex SQL Queries

  • Sorting of Data

  • String, Number In Built Functions

  • Data Conversion Functions

  • DML and DDL Statements

Briefly, The knowledge of SQL and PostgreSQL is a must for IT professionals and this course is one stop shop for gaining this necessary and in-demand skill.

Trust me, I will make sure you have an awesome learning experience and will hold your hand and take you step by step!!! 

Happy PostgreSQL Learning :-)

Learn SQL using PostgreSQL Server – Beginner to Expert

Practical Hands-on Real World SQL Skills

Created by Bluelime Learning Solutions - Learning made simple

"]

Students: 2617, Price: $89.99

Students: 2617, Price:  Paid

SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.

Data is everywhere and growing at a rapid rate. Most Software application we interact with daily deals with stored data . From our interaction with our banks to social media applications like Facebook and Instagram..

Due to the relevance and dependency on data , professionals that are skilled in SQL are always in high demand  to help interact with various databases to help business intelligence and other sectors that relies on data.

This course will teach you from absolute beginner to expert so you can be confident with enough skills to build simple to complex queries to communicate and interact with databases.

We will be using PostgreSQL  Server to host our database.

PostgreSQL Server is a relational database management system  -RDBMS   used by lots  of companies all over the world

What You Will Learn include:

  • How to extract  data from multiple Database Tables using Joins

  • How to insert new data into database with SQL

  • How to update existing data inside a database

  • How to delete data from a database

  • How to filter data

  • How to sort data

  • How to create and query views

  • How to  build a stored procedure

  • How to use Aggregate functions to summarize returned data

  • How to group data

  • Creating views

  • Creating Triggers

  • Creating sub-queries

  • Data Analysis with Analytic functions

SQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions.

Everywhere data is being collected, every transaction, every web page visit,every payment—all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information.

There is a demand for people who can use  data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions.

PostgreSQL High Performance Tuning Guide

Tips for Tuning PostgreSQL 12 like a Pro | Learn how to prevent Postgres performance problems

Created by Lucian Oprea - Software Engineer

"]

Students: 2371, Price: $39.99

Students: 2371, Price:  Paid

PostgreSQL is one of the most powerful and easy-to-use database management systems. It has strong support from the community and is being actively developed with a new release every year.

PostgreSQL supports the most advanced features included in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All of this makes PostgreSQL a very attractive solution in software systems.

However, getting the best performance from it has not been an easy subject to tackle. You need just the right combination of rules of thumb to get started, proper testing, solid monitoring, and maintenance to keep your system running well, and hints for add-on tools to add the features the core database doesn't try to handle on its own.

This course is structured to give you both the theoretical and practical aspects to implement a High-Performance Postgres. It will help you build dynamic database solutions for enterprise applications using the latest release of PostgreSQL 12.

You'll examine all the advanced aspects of PostgreSQL 12 in detail, including logical replication, database clusters, performance tuning, and monitoring. You will also work with the PostgreSQL optimizer, configure Postgres for high speed by looking at transactions, locking, indexes, and optimizing queries.

You are expected to have some exposure to databases. Basic familiarity with database objects such as tables and indexes is expected. You will find this course really useful if you have no or a little exposure to PostgreSQL. If you have been working with PostgreSQL for a few years, you should still find a few useful commands that you were not aware of or a couple of optimization approaches you have not tried. You will also gain more insight into how the database works.

Postgres High-Performance Tuning Guide Overview:

Understanding PostgreSQL Server Architecture

  • In this section, we will explore the PostgreSQL Architecture.

  • Shared Buffers works in cooperation with operating system cache, rather than replacing it. These caches improve performance by reducing the physical I/O necessary.

  • Why we need to set Checkpoints carefully to limit crash recovery time, while not impacting the rest of the system's performance.

  • This section will give you all an introduction to why we need the WAL Writer and also the Background Writer.

  • See the stages that the Query Processor has to pass in order to obtain the results.

  • The utility Subsystem provides ways to maintain the database, such as claiming storage, updating statistics and logging.

Configuring Vacuum for Performance

  • We will understand why any time we do an UPDATE or DELETE, we will leave a dead row behind (and potentially a dead index entry) that needs to be cleaned up later by some form of vacuum.

  • We will learn that when tables grow very large because of excessive dead tuples then performance will tend to decrease. Therefore the VACUUM process should never be avoided.

  • This section explains why it's better to have a steady low-intensity vacuum work, using the autovacuum feature of the database, instead of disabling that feature and having to do that cleanup in larger blocks.

How to use an Index efficiently

  • Understand that adding an index increase overhead every time you add or change rows in a table. Each index needs to satisfy enough queries to justify how much it costs to maintain.

  • In this section, we'll explain why the execution plan of a query depends on the data inside the table. If the data has low carnality, PostgreSQL will most probably ignore the index

  • In this section we'll learn why an index is only useful if it is selective; it can be used to only return a small portion of the rows in a table.

  • In this section, we will explore how to use bitmap scans effectively

Index Optimization Tips

  • On top of just using indexes, it is also possible to implement custom strategies for your particular application to speed things up

  • How to be able to answer queries by only using the data in an index using covering indexes.

  • This section covers why defining indexes on foreign keys it's a good practice.

  • In this section, we will explore partial indexes and how small, efficient index can be enjoyed.

  • Indexes can require periodic rebuilding to return them to optimum performance, and clustering the underlying data against the index order can also help improve their speed for queries.

  • We'll explain when it's useful to modify the fill factor parameter of a table.

  • In this section, we will see in which cases it's better to use a combined index vs multiple independent indexes.

Making Use of Statistics

  • In this section, you'll explore statistics that can help you find and sort the queries that are responsible for most of the load on the system.

  • PostgreSQL offers a large set of statistics. In this section, we'll make it easier to take advantage of their insights.

  • We'll get to see the fastest way to detect missing indexes but we'll also explore when it's necessary to drop indexes.

Spotting Query Problems

  • We'll explain how to read query plans and understand how each of the underlying node types works.

  • We'll get to see how queries are executed as a series of nodes that each do a small task, such as fetching data aggregation or sorting.

  • We'll explore portions of the query that actually had the longest execution time, and see if they had an appropriate matching cost.

  • The variation between estimated and actual rows can cause major planning issues. We'll explore what we can do in such cases.

Query Optimizations Tips

  • We'll see why it's important to first question the semantic correctness of a statement before attacking the performance problem

  • We'll understand why we should avoid SELECT *, ORDER BY and DISTINCT unless we really need them and there is no other way

  • We'll explore PostgreSQL features such as CASE syntax and parallel queries to reduce time execution for queries

How to set shared_buffers for better performance

  • We will see that the PostgreSQL allocation for the default shared_buffers is extremely low and we need to increase it to allow proper shared memory size for the database.

  • We will cover how shared_buffers works in cooperation with operating system cache, rather than replacing it and we should size it as only a moderate percentage of total RAM.

  • We will understand that if we want to do better than allocating a percentage to the shared_buffers relative to the OS cache, we need to analyze the buffers cache content

Scaling and Replication

  • We'll see how replication can also be used to improve the performance of a software system by making it possible to distribute the load on several database servers.

  • In some cases, the functionality of replication provided by PostgreSQL isn't enough. There are third-party solutions that work around PostgreSQL, providing extra features, such as Pgpool-II which can work as a load balancer and Postgres-XL which implement a multi-server distributed database solution that can operate very large amounts of data and handle a huge load.

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

Learn about Subqueries, CTEs, Indexes, PL/SQL, PL/pgSQL, Triggers, Cursors, Partitions, Views, JSON, Window Functions...

Created by Adnan Waheed - Founder KlickAnalytics.com and ex-Bloomberg employee

"]

Students: 2063, Price: $89.99

Students: 2063, Price:  Paid

Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more...

I've design this course from step-by-step move from basic to advanced topics. Here is a partial list of some of the topics that are covered in 50+ sections and 60+ hours of this course:

  • Apply powerful SQL commands to store, update and retrieve information

  • Step-by-step walkthrough to perform simple to complex SQL queries

  • How to create a database from the scratch, Creating and modifying tables

  • Using UPSERT for INSERT and UPDATE at the same time

  • Query data with ORDER BY, Logical operators, and filters

  • Understand PostgreSQL various data types with examples

  • Data type conversions with CAST, and conversion functions

  • Create your own user-defined data types

  • Explore table and column constraints, create multiple composite constraints, see data integrity operations

  • Create your own custom sequences

  • Parsing data with queries using string functions

  • Aggregate data with aggregate functions

  • Date/Time data types, Intervals, and handling timezones

  • Grouping Data with GROUP BY, conditional filter with HAVING

  • Joining Multiple Tables with various joins techniques

  • Combining Queries together with UNION, INTERSECT, and EXCEPT

  • Understand and create PostgreSQL Schemas, ownership, security privileges

  • Constructing arrays and ranges, query array data with conditional filters

  • Storing data with JSONB objects and Indexing

  • Query performance optimization with indexes, understanding indexes nodes and outputs

  • Create and update regular and materialize views

  • Simple to advances step-by-step Subqueries

  • Creating Common Table Expressions (CTEs), and recursive CTEs queries

  • Making data into group sets

  • Simple to advanced Windows Functions

  • Using regular expressions for text patterns

  • Powerful text searches in PostgreSQL

  • Create and exploring table partitioning techniques

  • Server programming with SQL and PL/pqSQL

  • Creating Stores Procedures

  • Extending PostgreSQL echosystem with custom indexes, and aggregate functions

  • Creating, and executing Triggers

  • Using Cursors

  • pqsql Utility Commands

  • Creating Crosstab reports

  • Making our database for storing global language data - Internationalization

  • Running queries with PostgreSQL transactions

  • Crating, and Managing PostgreSQL Security

  • All about PostgreSQL internals on how data gets stored and much more

  • Running hundreds of queries on sample databases like HR, Northwind, Stock Markets, Word Trades database

This comprehensive course will teach you everything about PostgreSQL to use in your next big project!

Master the PostgreSQL database, and see how to apply it with real world database and queries. Sign up today and master PostgreSQL!

Beginner’s Guide to PostgreSQL

PostgreSQL Tutorial: What you need to know to get started with relational databases in PostgreSQL

Created by Miguel Alho - Develeper and Owner of Miguel Alho - Multimedia

"]

Students: 1919, Price: $49.99

Students: 1919, Price:  Paid

PostgreSQL is an awesome open source relational database, that's fast and easy to use. We've used it here at my company in a few large projects with great performance.

In this beginner level PostgreSQL tutorial course I'll be going over all the basic concepts of relational databases and dive into how to use PostgreSQL. No previous database experience is required for this PostgreSQL tutorial course - all the basic concepts like tables and relations are covered. It's thorough and meant to help anyone starting out with databases.

The PostgreSQL tutorial course covers database concepts, database installation and connection, client software used to connect to and manage the database (pgAdminIII) and also the main SQL statements and how they work with PostgreSQL.

This PostgreSQL tutorial course is currently under construction, with close to 5 hours of material already available. Considering that, I'll be offering it at a discounted price. Once finished, it will be priced at $99.

</p>

Distributed SQL and YugabyteDB Fundamentals

Learn the core concepts of distributed SQL, put them into practice using YugabyteDB and take the certification exam

Created by Jimmy Guerrero - VP Developer Relations

"]

Students: 1508, Price: Free

Students: 1508, Price:  Free

This course will teach you the core concepts of distributed SQL and what makes it different from monolithic databases like Oracle, SQL Server PostgreSQL and MySQL. Through lectures and hands-on exercises you'll develop the knowledge and skills to configure and get started with YugabyteDB. Over the span of 90 minutes we'll covered the following topics in-depth:

  • Distributed SQL terms, definitions, and comparisons

  • YugabyteDB architecture and design principles

  • YSQL API development

  • Course review and exam prep

We also worked through a variety of hands-on exercises including:

  • Single and multi-node cluster installs on Mac, Linux, and Kubernetes

  • JDBC connectivity

  • User management and basic security

  • Working with databases and schemas

  • Creating objects and loading data from external files

  • Creating and exploring a sample database

  • Creating functions and triggers

  • Setting up admin tools like pgAdmin, TablePlus, and DBeaver

  • Using a Java load generator

  • Testing fault tolerance (remove node, add node, rebalancing)

  • TPC-C benchmarking