PostgreSQL for Beginners Learn the Fundamentals of SQL

SQL，也称为结构化查询语言，是一种计算机语言，旨在存储、管理、操作和从数据库中提取数据。学习 SQL 实际上是 2021 年的顶级技能之一，可以显着改善您的职业前景。

本课程的设计使其能够有效教授，并且您在此处学到的概念可以轻松应用于现实世界的场景。

在本课程中，您将学习以下内容：

SQL 的基本语句，如 SELECT、SELECT DISTINCT、LIMIT 等等。

基本的聚合函数，如 SUM、AVG、COUNT、MAX 和 MIN。

基本的数学、字符串和时间函数和运算符。

数据类型、主键和外键、约束。

创建您自己的表，在其中插入值，并修改表的行和列。

GROUP BY 语句和用于数据分析的 HAVING 子句

在 UNION、LEFT JOIN、RIGHT JOIN、INNER JOIN、OUTER JOIN 的帮助下加入多个表。

编写复杂的查询。

高级概念，如 CASE、COALESCE、VIEWS 等。

我们不仅会涵盖概念，还会通过在 pgAdmin 上编写查询来执行实际示例。这将有助于您理解我们将在本课程中讨论的主题。我还将在整个课程中为您分配作业，这将帮助您涵盖我们将讨论的所有概念。

MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 64 lectures (7h 52m) | Size: 2.24 GB
A comprehensive course on PostgreSQL and SQL: Become a SQL Pro by writing queries using pgAdmin 4

What you’ll learn:
Learn the fundamentals of SQL.
The fundamental statements/keywords like SELECT, SELECT DISTINCT, WHERE, ORDER BY, LIMIT , and more.
Learn how to use mathematical, string, and time functions and operators.
The use of EXTRACT function.
Learn the key concepts regarding Data types, Primary and Foreign keys, and Constraints.
Create new tables, insert values into the tables, and also modify the rows and columns in a table.
Learn GROUP BY statement, and HAVING clause.
How to join mutiple tables. UNION, INNER JOIN, OUTER JOIN, LEFT OUTER JOIN, and RIGHT OUTER JOIN will be covered.
Learn how to write complex queries with Self-join and Subquery.
Learn the advanced concepts like CASE, COALESCE, NULLIF, VIEWS etc.

Requirements
This course is for absolute beginners, so no prior knowledge or experience is required.
The student should have a working computer. The computer can have Windows, MacOS, or Linux installed.

Description
Learn one of the most in-demand skills in tech industry in 2021!

SQL, also known as Structured Query Language is a computer language that is designed to store, manage, manipulate, and extract data from a database. Learning SQL is actually one of the top skills in 2021, and can significantly improve your career prospects.

This course is designed in such a way that it will taught effectively, and the concepts you learn here can easily be applied to real-world scenarios.

In this course, you will learn the following:

The Fundamental Statements of SQL like SELECT, SELECT DISTINCT, LIMIT, and much more.

Basic Aggregate functions like SUM, AVG, COUNT, MAX, and MIN.

Basic mathematical, string, and time functions and operators.

Data types, Primary & Foreign Keys, Constraints.

Creating your own tables, inserting values in them, and also modifying the rows and columns of the tables.

GROUP BY statement, and HAVING clause for data analysis

JOINING multiple tables with the help of UNION, LEFT JOIN, RIGHT JOIN, INNER JOIN, OUTER JOIN.

Writing complex queries.

Advanced concepts like CASE,COALESCE, VIEWS etc.

We will not only cover the concepts, but also perform practical examples by writing queries on pgAdmin. This will help you a lot in understanding the topics that we will discuss throughout this course. I will also give you assignments throughout this course, which will help you cover all the concepts that we will discuss.

By the end of this course, you would have acquired all the knowledge necessary for real-world scenarios.

I wish you all the best for this course, and Good Luck.

Who this course is for
Someone who deals with data on a regular basis.
Someone who is curious about learning a new programming language.
Someone who wants to be a data scientist, data analyst, etc.