SQL Tutorial 6: MySQL Built-in Functions in SQL

MySQL Built-in Functions in SQL
-------------------------------
1) Strings functions - operate on string data types
2) Numeric functions - operate on numeric data types
3) Date functions - operate on date data types
4) Aggregate functions - operate on all of the data types and produce summarized result sets
#########################
Udemy Courses:
#########################
Manual Testing+Agile with Jira Tool
************************************
► shorturl.at/xNXZ4
Selenium with Java+Cucumber
********************************
► shorturl.at/aIKMW
Selenium with Python & PyTest
********************************
► shorturl.at/ELW09
Selenium with python using Robot framework
****************************************
► shorturl.at/bcDPZ
API Testing(Postman, RestAssured & SoapUI)
*****************************************
► shorturl.at/uAWY7
Web & API Automation using Cypress with Javascript
********************************************
► rb.gy/4uum2n
Playwright with Javascript
**************************
► shorturl.at/gALZ1
Jmeter-Performance Testing
************************
► rb.gy/ocj7r2
SDET Essencials(Full Stack QA)
*************************
► rb.gy/hlnf2v
Appium-Mobile Automation Testing
************************************
► rb.gy/wmzv64
Java Collections
*****************
► bit.ly/3S66ezE
Python Programming
*********************
► urlis.net/gdsf...
Cucumber BDD Framework
***************************
► bit.ly/3F7d69r
Protractor with Javascript
***************************
► urlis.net/4udd...
####################################
KZbin Playlists:
####################################
Manual Testing & Agile
***********************
► bit.ly/3ujvaYa
► bit.ly/3OYzxQj
SQL
*************************
► bit.ly/3R6XjeG
► bit.ly/3nE0a1s
► bit.ly/3IeKuuJ
linux & Shell Scripting
**********************
► bit.ly/3up1Z6a
► bit.ly/3nzvGxx
Java
**********************
► bit.ly/3R9QfOs
► bit.ly/3AoRMKM
► bit.ly/3IbTTDn
► bit.ly/3ybXInv
► bit.ly/3yCoHdw
Selenium With Java+Cucumber
********************************
► bit.ly/3P2FMm4
► bit.ly/3yhiIt4
► bit.ly/3uokzet
► bit.ly/3a7XIND
► bit.ly/3umN2S9
► bit.ly/3aar7GW
► bit.ly/3y9kD2S
► bit.ly/3uhLskn
Python
********************************
► bit.ly/3agNgU0
► bit.ly/3NJNnoy
► bit.ly/2CTQ4mR
► bit.ly/3OIYWh1
Selenium With Python,Pytest&Behave
***************************************
► bit.ly/3OHHoC9
► bit.ly/3IeNLdv
► bit.ly/2J4tPeT
► bit.ly/3ydSkAq
Selenium With Python Using Robert Framework
(Web&API Testing)
*************************************************
► bit.ly/3nUvlpr
► bit.ly/3nUvE3z
API Testing (Postman,SoapUi,&Rest Assured)
**********************************************
► bit.ly/3OXacWY
► bit.ly/3yh0UhE
► bit.ly/3nC9DWQ
► bit.ly/3yGfhNS
► bit.ly/3OJa11H
► bit.ly/3P2slCC
Mobile App Testing Appium
****************************
► bit.ly/3Al49HG
Performance Testing Jmeter
*******************************
► bit.ly/3nz4fE7
Maven,Jenkins,Git,Github,CI/CD
*******************************
► bit.ly/3P16HPj
► bit.ly/3yhlUVA
► bit.ly/3afYfwT
► bit.ly/3yGzweG
► bit.ly/3yF73Ws
► bit.ly/3NCOmH7
SQL,DB Testing&ETL,Bigdata
*******************************
► bit.ly/3NKOcNY
► bit.ly/3OVpDyI
► bit.ly/3NEvUy0
► bit.ly/3IryxlT
► bit.ly/3RkWBLh
JavaScript Based Automation Tools
********************************
► bit.ly/3nUx51X
► bit.ly/3AqI6Q0
► bit.ly/3yeurbT
► bit.ly/3ujzpTK
Selector Hub Tools
********************
►rb.gy/h3h424
GraphQL
******************
► rb.gy/sj3gys
Cypress API Testing
********************
► shorturl.at/fjKPX
Cypress Web Testing
**********************
► shorturl.at/agjlK
Playwright with Javascipt
**************************
► shorturl.at/adSTY
#SQLFunctions
#MySQLFunctions
#SQLBuiltInFunctions
#MySQLTutorials
#SQLTips
#DatabaseFunctions
#SQLQueries
#MySQLLearning
#SQLMastery
#DataManipulation
#SQLBasics
#MySQLTraining
#SQLSyntax
#DatabaseSkills
#SQLDevelopment
#MySQLQueries
#SQLFunctionsGuide
#LearnSQL
#MySQLFunctions101
#SQLForBeginners
#DataAnalysis
#SQLServer
#MySQLDatabase
#SQLLanguage
#CodingSQL
#MySQLFundamentals
#SQLProgramming
#DataManagement
#QueryingData
#MySQLSyntax
#SQLTipsAndTricks
#DatabaseTutorial
#SQLReference
#MySQLExplained
#SQLQueries101
#DataManipulationSQL
#LearnMySQL
#SQLFunctionsExplained
#DatabaseDevelopment
#SQLSkills
#MySQLData
#SQLQuerying
#AdvancedSQL
#MySQLFunctionsTutorial
#SQLDatabases
#DataProcessing
#SQLTutorialSeries
#MySQLQuery
#SQLByExample

[@aigerimdzhanybekova3053]

Greetings from Kyrgyzstan the best tutorial on covering MySQL

[@basanagoudabiradar8669]

Good explanation sir 👍

[@sdetpavan]

Thanks

[@saikrishnan9298]

Really Awesome teaching sir. You are making all the concepts look simple. thanks a lot

[@sdetpavan]

Welcome

[@RichyRich18]

best ever lacture on yt.. salute to the teacher!!

[@sdetpavan]

My pleasure

[@user-yj6cs5rv2m]

Hi sir, your teaching is excellent sir, I never seen this type of teaching (you are explaining from scratch.)

[@sdetpavan]

Thanks

[@subankaracharya6879]

Hi sir , I loved the way you teach . Thank you so much for all your Support.

[@sdetpavan]

You are most welcome

[@amolagrawal1949]

sir it would be great if you provide us the presented ppt.

[@santoshkumar-to7lb]

became a fan of your teachings. Thanks for this efforts.

[@sdetpavan]

Welcome

[@Moinsharmila]

Thank you so much, really your teaching is very awsome

[@sdetpavan]

Thanks and welcome

[@akhileshghatate4157]

At 11:46 INSTR function returning O as 2 but there are two O's. How would it show two O's locations. Please explain.

[@soumyabiswal406]

Thank you so much sir for this best explanation on functions..

[@sdetpavan]

Welcome

[@nageshjadhav3197]

Your Teaching is so excellent sir.......

[@sdetpavan]

Thanks

[@guduuubabu7188]

Thanks a lot Pawan Sir.. Nice to see ur Testing Videos every time.. 👍🏻

[@sdetpavan]

Welcome

[@sivasai5382]

thankyou sir really helpfull

[@sdetpavan]

Welcome

[@aadarshsingh2265]

Great tutorial!

[@sdetpavan]

Thank you!

[@b28-omkarpansare23]

thanks sir for such wonderful videos .

[@sdetpavan]

Most welcome

[@mohamediburahimp7661]

Luv ur teaching sir😀😀😀😀😀🤞🤞🤞

[@Avirajvlogs8]

tq sir

[@sdetpavan]

Welcome

[@sivaprasad6739]

Your way of teaching is awsome

[@sdetpavan]

Thanks

[@neerajg6976]

What's the difference between Max() vs greatest ()??

[@amanpreetkaur-eu6lp]

Very much helpful sir thank you so much🥰🥰🥰🥰🥰🥰🥰

[@sdetpavan]

Most welcome

[@yutiumare3024]

Thank you sir 🙌🙌🙌🙌 really helpful

[@sdetpavan]

Welcome

[@keshavbhagat8318]

Very Very Thank You Sir 🙏

[@sdetpavan]

Most welcome

[@muhammadjunaidmajeed1211]

Excellent!

[@sdetpavan]

Thanks

[@arjunjadhav8054]

Great sir , Can You Provide we All slides in Description link ?

[@chaitucherry879]

Hi sir, These videos help me a lot to understand SQL,. Can I get any that ppt or notes?

[@hemav1369]

Hi Sir.. how to find duplicate salary of emplyees

[@susmithareddy1404]

Excellent teaching sir,please give the pdf of this SQL videos

[@romanyakymets738]

Thank you very much

[@sdetpavan]

You are welcome

[@khaliddalwale8906]

Sir suppose I pass upper laters in upper() function does still it's returning Upper case laters Is it like that only It's not checking the wheather in function we are passing uppercase or lowercase e.g. select upper('KHALID') then it's returning uppercase only It's not checking in which case we are providing data Can you show some light on this

[@surajpokharkar8571]

Thank you..

[@sdetpavan]

You're welcome

[@nbkmpat]

Hello Sir, how to trim strings from only left or right side

[@gopikrishna3492]

Select ltrim( gk) from table name

[@ukshahrukh]

THANKS SIR PLEASE CAN TELL HOW TO ADD HR DATABASE .......

[@v2factsandupdates327]

Awesome

[@sdetpavan]

Thanks

[@Rider-jn6zh]

In concat function there is no space btn first and last name...what is the solution for that

[@saranyachandrabos3541]

Thank you sir

[@sdetpavan]

Most welcome!

[@nageshjadhav3197]

hi sir in Oracle Numeric function is not Runed error shows

[@AkashRealme71]

SELECT DAY ("2019-05-19") returns 19 , I think 19 is not day, it returns in the weekdays, if I am wrong then please correct me refer to video time 28:00 mins

[@muthu_vrn]

Shall i get this ppt?

[@sakshinagpal4497]

Can anyone please help me to get PPT.which sir is using in online sessions?

[@karanvir2670]

Can you provide this pdf sir ... for learning

[@javeedkhan-vx7xh]

where to download this PPT?

[@sdetpavan]

www.pavantestingtools.com/p/sql-tutorials.html

[@sumithraramesh591]

@@sdetpavan Thank u so much for the link

[@surjeetkaur4117]

Sir if we give syntax: Select POW(2, -2) ; then it returns 0.25 how??

[@sreejx]

2 to the power -2 is same as 1/(2^2) = 1/4 = 0.25

[@nehathakkhar1956]

Hello Sir, from where can we import HR database, can you provide the link? thanks

[@Rohit-su3tf]

They said they provide but they will not give us🙄

[@priyashah5914]

download any free database for practice.

[@priyashah5914]

After downloading, go to server tab and you will find import data, click there!

[@sowmyakumaresan2671]

Sir ur email id to contact you for letting u know about the issue which I got

[@Eternal_Truth8]

12:35

[@arindomdas6476]

Amazing tutorial series sir u r the best Sir please Giv that ref link in description (mysql_official)

[@pandikuntamaidhili]

Thank you sir

[@sdetpavan]

Welcome

[@mekidtube4404]

Thank you sir

[@sdetpavan]

Welcome