Intermediate SQL Tutorial - Part1 | CASE Statement with Realtime Examples
This Intermediate SQL Tutorial series will help you learn intermediate concepts of SQL with step by step and simple examples with real-time use cases.
In this video you will learn where to use CASE statement using simple and real-time examples.
Following topics has been covered in this SQL Tutorial Video:
00:00 Introduction
00:47 What is CASE Statement?
01:43 Syntax of CASE Statement
02:42 CASE Statement with two or more conditions
07:55 CASE Statement with calculation
09:36 CASE Statement with GROUP BY
10:47 CASE Statement with ORDER BY
12:30 Real-time examples/ use cases of CASE Statement
----------------------------------------------
You could refer to the last part of this tutorial at the below links:
Basic SQL Tutorial For Beginners – Part 1: • The Basic Statements & Installation - SQL ...
Basic SQL Tutorial For Beginners – Part 2: • Database | Insert, Update, Delete, Truncat...
Basic SQL Tutorial For Beginners – Part 3: • All SQL Joins - SQL Beginners Series p.3
Basic SQL Tutorial For Beginners – Part 4: • Union & Union All - SQL Beginners Series p.4
Basic SQL Tutorial for Beginners – Part 5: • Aggregate Functions, Group By, Having - SQ...
----------------------------------------------
Links for resources:
SQL Scripts used in this training @ GitHub repository (please use latest script from this path for this video):
https://github.com/trainmebuddy/Inter...
SQL Server:
https://www.microsoft.com/en-in/sql-s...
SQL Server Management Studio (SSMS):
https://learn.microsoft.com/en-us/sql...
------------------------------------------------------------------------
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! :)
------------------------------------------------------------------------
#sqlcasestatement #casewhen #sqlprogramming #BasicSQL #SQLServer #TSQL #LearnSQL
#BasicSQLTutorialForBeginners #SQLServerWithSimpleExamples #SQLServerBasics #SQLCommand #SQLQuery #trainmeBuddy #siddharthpatra #sqlstatements #sqlinterviewquestions #sqlinterviewquestionsandanswers train me buddy siddharth patra
------------------------------------------------------------------------
Sur cette page du site, vous pouvez voir la vidéo en ligne Intermediate SQL Tutorial - Part1 | CASE Statement with Realtime Examples durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur Train Me Buddy 19 février 2023, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 506 fois et il a aimé 57 téléspectateurs. Bon visionnage!
