SQL Session - 4 | Update, Delete, Alter, DDL vs DML, Truncate vs Delete | Trendytech

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐌𝐚𝐬𝐭𝐞𝐫 𝐒𝐐𝐋? 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐭𝐡𝐞 𝐫𝐢𝐠𝐡𝐭 𝐰𝐚𝐲 𝐭𝐡𝐫𝐨𝐮𝐠𝐡 𝐭𝐡𝐞 𝐦𝐨𝐬𝐭 𝐬𝐨𝐮𝐠𝐡𝐭 𝐚𝐟𝐭𝐞𝐫 𝐜𝐨𝐮𝐫𝐬𝐞 - 𝐒𝐐𝐋 𝐂𝐡𝐚𝐦𝐩𝐢𝐨𝐧𝐬 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫!

"𝐀 8 𝐰𝐞𝐞𝐤 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 𝐝𝐞𝐬𝐢𝐠𝐧𝐞𝐝 𝐭𝐨 𝐡𝐞𝐥𝐩 𝐲𝐨𝐮 𝐜𝐫𝐚𝐜𝐤 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬 𝐨𝐟 𝐭𝐨𝐩 𝐩𝐫𝐨𝐝𝐮𝐜𝐭 𝐛𝐚𝐬𝐞𝐝 𝐜𝐨𝐦𝐩𝐚𝐧𝐢𝐞𝐬 𝐛𝐲 𝐝𝐞𝐯𝐞𝐥𝐨𝐩𝐢𝐧𝐠 𝐚 𝐭𝐡𝐨𝐮𝐠𝐡𝐭 𝐩𝐫𝐨𝐜𝐞𝐬𝐬 𝐚𝐧𝐝 𝐚𝐧 𝐚𝐩𝐩𝐫𝐨𝐚𝐜𝐡 𝐭𝐨 𝐬𝐨𝐥𝐯𝐞 𝐚𝐧 𝐮𝐧𝐬𝐞𝐞𝐧 𝐏𝐫𝐨𝐛𝐥𝐞𝐦."

𝐇𝐞𝐫𝐞 𝐢𝐬 𝐡𝐨𝐰 𝐲𝐨𝐮 𝐜𝐚𝐧 𝐫𝐞𝐠𝐢𝐬𝐭𝐞𝐫 𝐟𝐨𝐫 𝐭𝐡𝐞 𝐏𝐫𝐨𝐠𝐫𝐚𝐦 -

𝐖𝐚𝐧𝐭 𝐭𝐨 𝐥𝐞𝐚𝐫𝐧 𝐁𝐢𝐠 𝐃𝐚𝐭𝐚 𝐛𝐲 𝐒𝐮𝐦𝐢𝐭 𝐒𝐢𝐫?
𝐜𝐡𝐞𝐜𝐤𝐨𝐮𝐭 𝐭𝐡𝐞 𝐛𝐢𝐠 𝐝𝐚𝐭𝐚 𝐜𝐨𝐮𝐫𝐬𝐞 𝐝𝐞𝐭𝐚𝐢𝐥𝐬

I have trained over 20,000+ professionals in the field of Data Engineering in the last 5 years.

In this session we have talked about following things

TABLE OF CONTENT
1:20 CRUD Operations
2:28 Creating table and inserting records
5:50 Variants of select command
13:10 Update command
20:15 Delete command
23:45 Alter Command
29:45 DDL vs DML
35:25 Truncate command is a DDL or DML

𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:🔥

If you're looking to master SQL with real time usecases & looking to crack top product based companies, this tutorial is for you. Just follow through and you'll be able to write SQL queries in no time.

SQL, short for Structured Query Language, is a language used by software developers, data engineers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information.

Even if you are someone who is working on SQL Server, Oracle DB, PostgreSQL or any other relational DB. Then you should be able to use your learning with hardly 5% syntax change.

#SQL #RDBMS #database #bigdata #dataengineering

[sekhar]

Hi Sir,
This is my wife's feedback about SQL session. She is from Non-IT background and looking to move her career in IT. She is following SQL series, when I asked her about the session she told like " He has the best Teacher Qualities and he is explaining the topics in very clear and understandable manner. And doing RECAP in same session. This course is more than paid course. Really Big Thank you Sumit sir.

[deviduttamohanty-ibm]

I have enrolled in the paid course by some hotshot who has designed courses on top Edtech companies and is working in a MAANG company, but his sessions are, to put it mildly, below average. His sessions proved that one can be personally good at some skill, but that doesn't necessarily mean one can teach it. Sumit Sir takes the pain of explaining the simplest things which the so-called IIT alum/MAANG company employees don't think necessary when teaching an absolute beginner. Good teachers like Sumit Sir will never go out of fashion. Thanks for freely sharing your knowledge with the world.

[praveenpatel]

I watched a lot of session on SQL to gain knowledge deeply but here it is very interesting never seen before like that hereby sumit mittal sir explained with full of enery and dedication.
Universities and institutes should have instructor like them.

[suryakantborad]

Most authentic way to grasp SQL language essentials while literally leaving aside all the jargonic definitions that make it look like such a massive experience.

[gnapikarayala]

"I appreciate your teaching style, as it is clear, precise, and easy to understand. As a Network Engineer interested in transitioning to the Data side, I have taken a few Udemy courses, but yours is exceptional and stands out. Once I finish these videos, I plan on purchasing your Big Data course. Thank you for your dedicated efforts in creating this valuable content."

[saisandeep]

Makes me passionate to listen and understand the subject, I am a slow learner and from these sessions I learned pellucidly.
Became a fan of sir's teaching

[montypoddar]

Hi Sumit Sir,
I have tried many times to learn SQL and this is the very first time and able to understand everything clearly from basics. I have one request, I escape from coding because I don't have my basics strong. Can you pls start one series for that too with DSA and any one of programming language (e.g python)? It will be really helpful for lots of students.

[lakshyagoel]

Amazing SQL Playlist Sumit Sir.I am really loving it by doing it hands on.

[sanyataneja]

After seeing your teaching pattern i've enrolled in your Big Data course, love the way you explain things..

[deepikasoni]

Best content on SQL so far and its better than paid courses. Wish I could have got more teachers like you when I was studying in college. :)

[ravishankar-lyyg]

Finding this Awesome quality of Sql and Big Data Content, Free of cost on Digital Platform is a Bliss, Thanku Sumit Sir

[charansai]

sumit sir you are very good at explaining stuff with no extra confusion which is found in most of the videos.

[akshaychowdhary]

APPRECIATE your efforts for putting concepts into more simpler way. Thank a ton !!!. Looking forward for more such sessions 😀

[sandhyarani-jdre]

Amazing SQL videos Sumit Sir.I am really loving it by doing it hands on along with the playlist.

[harshitdubey]

Thanks a Lot Sumit Sir. I have completed 4 Chapters of it. and the course actually gave me the hope to learn SQL.

[sureshdarla]

thanks a lot sir, previously when I learned SQL, I missed small connections. now I am getting, videos are very clear, glad to have teachers like you.

[bhargavi_data_analyst]

Thanks a lot, I feel so blessed to have found this playlist. Thank you Sumit Sir.

[mackerbs]

Really Great Work Sir . The way you are explaining SQL Concept

[AshishKumar-sfju]

Thanku sir for this amazing content and on going series .
I'm BCA student and feeling very glad to learn the things from scratch 😇

[shaikusman]

Thanks & hatss off toyour commitment aumiot sir from bangalore...