SQL session 9 | A few more Datatypes | Trendytech

[@sumitmittal07]

Checkout the Big Data course details here: trendytech.in/?referrer=youtube_sql10

[@prashantgortakar6436]

I really appreciate your dedication towards teaching.
I know you were not well from last week, but even after recording the new session for students is truly shows dedication towards teaching.
Thanks 👍 for teaching.

[@chandanamushkam7918]

Thank you so much for making this series, I have tried to learn SQL from courses, and videos but never felt this confident and interested.

[@ayushvanvary]

recording lecture at so early morning , for us you are really a Gem to the tech industry thanks alot sir for this playlist..

[@Cristi1665]

Thanks, Sir for these valuable sessions.Very crip and understandable.
I am trying to insert a decimal value 12000.1 in a Decimal type SALARY(6,2) and it is throwing an error "out of range value for column SALARY". Post-reading the content, I realised that (6,2) only allows a total of 6 digits including a preset 0 after (.1), Hence the system reads it 12000.10 which outranges the limit.

[@rahultewari8354]

hey (6,2) means that total digits will be at 6 , before decimal you can have max 4 digits and after that 2.

[@ritumdutta2438]

Can you please extend the Group By session by adding "Having" clause , and how "Having" "Where" "Group by" and "Order by" together work?

[@nibubabu]

Thank you Sir! On update clause was new for me!

[@sumitmittal07]

Glad you found it helpful.

[@sandeepmishra5753]

@@sumitmittal07 Me too

[@poojag4335]

I appreciate the efforts.

[@greatmonk]

Thank you for sharing!!!!!

[@Sandip_Patle]

🔰 Thank you for these great insights sir....🙏🏻

[@sumitmittal07]

Happy to hear that you found it helpful

[@shubhamSharma-du4ir]

Thank you so much, sir.

[@shubhamkulshrestha4697]

Sir what is the notepad you are using on the MAC ?

[@VaradT_15]

Sir where we can find the notes? Please attach in description if possible. Thanks

[@vishnujatav6329]

Good one

[@hasanmougharbel8030]

Hey there,
God bless your efforts.
I have a simple enquiry as a new sql learner.
How is sessions handled in sql applications? Are sessions related only to transactions or it is much broader than that?
Thanks a lot.

[@girih-yt6de]

sir where will i get the notes that u type?

[@sumitmittal07]

SQL Notes - github.com/bigdatabysumitm/NotesOfUA-camSQLSeries.git

[@adityapurigoswami2626]

Thanks for the awesome video again... I am not able to define "changed_at TIMESTAMP DEFAULT NOW()" in SQL Server... I am trying to use GETDATE() there but it's giving error that "Defaults can't be created on columns of data type timestamp". Any suggestions?

[@subbukalyanam]

use Current_timestamp instead of now

[@amanpathak7507]

What about timestamp_ntz and others??

[@paragdhusiya4953]

Sir please provide the file in which you write the explanation during video

[@somnathghosh9179]

How to copy lines from sublime to terminal?

[@Jo.gg789]

Copy from editor and paste on terminal using right click

[@sunilrao6090]

how to convert utc to ist

[@rashidalikhan3613]

is this SQL course enough to get the job or do i need to learn more concepts.

[@niteshanjane2969]

where is session 8

[@amuladhanunjay7946]

Sir 📝 please