This Basic SQL Tutorial series will help you learn step by step Structured Query Language (SQL) with simple examples using SQL Server, which will be helpful if you are a beginner and looking for a career as SQL Developer or if you want to use it in your academic.
In this video you will learn where to use AGGREGATE FUNCTIONS, GROUP BY and HAVING CLAUSE using simple examples.
Following topics has been covered in this SQL Tutorial Video:
00:00 Introduction
01:05 AGGREGATE FUNCTIONS (COUNT,SUM,AVG,MIN,MAX)
02:57 COUNT() Function: COUNT(*), COUNT(Column_Name), COUNT(DISTINCT Column_Name)
06:11 SUM() Function: SUM(Column_Name), SUM(DISTINCT Column_Name)
08:10 AVG() Function: AVG(Column_Name), AVG(DISTINCT Column_Name)
09:12 MIN() Function
09:58 MAX() Function
10:40 What is GROUP BY Statement?
11:30 GROUP BY Query
12:24 GROUP BY Query with Aggregate Function
14:55 GROUP BY with JOIN
18:08 GROUP BY with HAVING CLAUSE
19:32 Checking duplicate rows using HAVING CLAUSE
----------------------------------------------
You could refer to the last part of this tutorial at the below links:
Basic SQL Tutorial For Beginners – Part 1: [ Ссылка ]
Basic SQL Tutorial For Beginners – Part 2: [ Ссылка ]
Basic SQL Tutorial For Beginners – Part 3: [ Ссылка ]
Basic SQL Tutorial For Beginners – Part 4: [ Ссылка ]
----------------------------------------------
Links for resources:
SQL Scripts used in this training @ Github repository:
[ Ссылка ]
SQL Server:
[ Ссылка ]
SQL Server Management Studio (SSMS):
[ Ссылка ]
------------------------------------------------------------------------
Thanks for watching! Hope this tutorial is useful for you!
Please like, share and don’t forget to subscribe the channel @trainmebuddy and hit on the bell icon so that you will be notified about the upcoming new videos!
If you have any doubts or suggestions, please feel free to put it on the comment! Thank you! :)
------------------------------------------------------------------------
#groupby #havingclause #sqlaggregatefunction #SQLProgramming #BasicSQL #SQLServer #TSQL #LearnSQL
#BasicSQLTutorialForBeginners #SQLServerWithSimpleExamples #SQLServerBasics #SQLCommand #SQLQuery #trainmeBuddy #siddharthpatra #union statement #unionall statemet #unionandunionall #sqlstatements #sqlinterviewquestions
------------------------------------------------------------------------
Ещё видео!