I have started from the aggregate functions, as I continue, I will add all the timestamps. 0:34 : Database: The Basics 19:54 : SQL Basics 36:05 : CRUD operations in SQL 1:12:22 : Primary Key vs Unique Key 1:39:17 : DDL vs DML commands 2:18:27 : Foreign Key constraint 3:01:14 : Distinct, Order By, Limit, Like clause in SQL 3:47:48 : Aggregate Functions 4:20:11 : More Data Types 4:40:02 : Logical Operators 4:57:14 : CASE WHEN statements 5:07:34 : Joins 5:40:24 : Important SQL Interview Questions 5:58:35 : Over() and Partition by clauses 6:16:12 : Windows function (row_num()) 6:31:20 : Windows function (rank(), dense_rank()) 6:49:37 : Indexes and Order of Execution in SQL 7:53:07 : SQL WITH clause (common table expression)
@ektalamba8497
11 ай бұрын
how can i get the word document, sir is creating here. thanks
@maulikshah9078
9 ай бұрын
Thanks, it will be helpful
@Mangesh115
9 ай бұрын
Thank you 😊
@makarand1985
8 ай бұрын
God bless you brother !!!
@sreekanthreddy8360
7 ай бұрын
@asparshraj9016 Thanks for the timestamps. If you having a running notes on this. Could you please share it. It will be helpful.
@shrutisamal
8 ай бұрын
0:34 : Database: The Basics 19:54 : SQL Basics 36:05 : CRUD operations in SQL 1:12:22 : Primary Key vs Unique Key 1:39:17 : DDL vs DML commands 2:18:27 : Foreign Key constraint 3:01:14 : Distinct, Order By, Limit, Like clause in SQL 3:33:13 : Order of execution 3:47:48 : Aggregate Functions 4:20:10 : Other data types(decimal, timestamp) 4:40:02 : Logical operators(not,not like,or,between,not between,in,not in,case statements) 5:07:34 : Joins 5:40:24 : Where vs Having (Important for SQL Interview) 5:58:35 : Over() and Partition by clauses 6:16:12 : Windows function (row_num()) 6:31:20 : Windows function (rank(), dense_rank()) 6:49:37 : Indexes and Order of Execution in SQL (seek,scan,clustered index,non-cluster index)
@user-rc2uc1kv6w
8 ай бұрын
DID THEY TAUGHT TRIGGERS, WINDOWS FUNCTIONS, STORED PROCEDURES TOO??
@krishnakumarkumar5710
9 ай бұрын
The way you teach is the reason behind people becoming Data engineer and getting good packages after taking your training. I will be one of them soon. Thanks LORD Sumit Mittal.
@ujjwaltitarmare214
7 ай бұрын
Kitna package hain approx bata dijiye
@krishnakumarkumar5710
7 ай бұрын
@@ujjwaltitarmare214 jarra comment thik se padhiyo
@ujjwaltitarmare214
7 ай бұрын
@@krishnakumarkumar5710 Phir bi aapne dusro se pata kiya ho..kitna mil jana chayein
@bullseye9723
5 ай бұрын
@@krishnakumarkumar5710 bro after learning sql then what more should be learn to become data engineer for good package?
@darshandave9145
3 ай бұрын
Yes i also want to know this things
@sgn1989
8 ай бұрын
Great video, very informative! Thanks for sharing. Watched it at 2x and finished it in less than 5 hours.
@sutapakar7522
5 ай бұрын
I have completed your 9 hours SQL training. I have learnt a lot. Thanks for the initiative.
@rajashekar4171
4 ай бұрын
Great
@Prasad1487
11 ай бұрын
SQL course is everywhere but not the best explanation... Thanks Sumith Ji.
@sunilotari7481
7 ай бұрын
1st of all thanks sir ji, zero se heero ki tayyari mai lag chuka hu lets see aage kahatak jayenge
@samadhanghutugade9962
Жыл бұрын
This one is best.. Start to End.. Thank u sir... 😊🙏🏻
@sanatlamichhane2949
10 ай бұрын
Great video! I've been wanting to grasp this SQL concept for a while, and your explanation really helped me finally nail it. However, when it comes to Common Table Expressions (CTE), I felt a bit lost. I might need to delve deeper into CTE, but thank you for creating such an informative video!
@TarabShaikh-ij2dt
7 ай бұрын
Almost 3 hours into this goldmine, just have one thing to say - FABULOUS way of teaching! 👏
@sumitmittal07
7 ай бұрын
Great to hear!
@Anubhavkumar2103
6 ай бұрын
Hii bhai Could you please tell me.. 1. Is this lecture worth it for campus placement. 2. Is the content of this lecture complete or not ? Thank you in advance 😊
@Tiyasha-n1l
10 ай бұрын
hi sir , for enrollment date by using only timestamp is throwing error , it needs to be updated to 'enrollment_date TIMESTAMP DEFAULT current_timestamp NOT null '.
@aamirimran9373
Жыл бұрын
Oh my god thankyou soooo much sir ❤🎉
@mkarvj
Ай бұрын
Great video, very informative! Thank you so much for teaching sir.
@RahulChougule-w6p
Жыл бұрын
Thank you Sir for this wonderful tutorial. But would have suggest add individual sessions to previous SQL playlist.
@akshatakarekar5437
Жыл бұрын
Hello Sumit, just into an hour of this course and loving it so far. A follow up question- For the part where you showed how when middle name is not given while inserting it sets a null value to it but how does the compiler know that it is null for middle name and not for other string values such as firstname or last name?
@SeneXeL
11 ай бұрын
Can you explain better your question?
@sharathkumarvydyam9017
5 ай бұрын
thanks for providing entire course in one video
@mtad-health
Жыл бұрын
I'm watching and learning, thanks
@optionkingrobot
3 ай бұрын
Really Enjoying Thanks sirji
@shaileshtiwari6700
Жыл бұрын
Thank you sir for your hard work regarding student support.
@hitaljain
Ай бұрын
This video is very helpful sir thank you so much to upload this video
@riddhishah790
Жыл бұрын
Thank you very informative and simple to understand the way you are explaining. I have completed first session I have a query when to use uppercase and when lowercase while typing query Thank you
@Razakhan-jl3sw
11 ай бұрын
Good job Sumit !! I really got a new insight into learning sql
@avgspacelover
5 ай бұрын
learned a lot, thank you for the series! can you make more of these one shot videos on different topics please?
@yoursbhansali
11 ай бұрын
what is secondary key? is it unique key ?
@prasadaraochaduvula4262
7 ай бұрын
🎉🎉🎉 this is good for now and this is enough for job role on Sql
@Anubhavkumar2103
6 ай бұрын
Hii bhai Could you please tell me.. 1. Is this lecture worth it for campus placement. 2. Is the content of this lecture complete or not ? Thank you in advance 😊
@kmthailu2262
4 ай бұрын
Thank you! This is very helpful
@Prashanthmutike
6 күн бұрын
great explanation
@tejasvaidya8464
Жыл бұрын
Sir timestamp given in description are not working can you please fix that.
@makarand1985
8 ай бұрын
Thanks a lot Sir 🙏🙏🙏
@allurianusha6111
5 ай бұрын
Sir superb explanation
@BOSS-AI-20
Жыл бұрын
If you could add the Time stamps it would be great
@knight2000-NC
10 ай бұрын
are these tables in 3rd normal form. Thank You.
@manikumar9015
6 ай бұрын
sir explanation is good enough but it would be better for learners if you give some pratice sesssion
@mahendranath2504
10 ай бұрын
nice thank you so much 👍
@mohammadfurquan241
Жыл бұрын
📌First Like, first view First Comment Thank you so much Sir 🪄
@mahavirsinghrajpurohit8004
4 ай бұрын
Order by and distinct will work together if you add order by column name with select.
@AnmolSharma-wz3px
9 ай бұрын
in the example at 7:40:54 we can see that it went for clustered index scan. Is it because customer_id is not a primary key on orders table ?
@kiranmg4831
7 ай бұрын
Sir, I can't copy and paste inside the page. What is the setting for that ? It is showing Can't access the clipboard.
@sulaimanhasan6272
8 ай бұрын
Thanks, Very useful
@koushikchoudhury2179
3 ай бұрын
Sir , Kindly share the practice data set so that we can practice parallely
@Techwithgk369
8 ай бұрын
Waiting for your python course like SQL sir🎉🎉🎉
@pandiripavankumar3333
11 ай бұрын
Sir I want to learn sql in detail. Do you offer it online. What is the time reqd. to learn it online.
@navjotsingh-hl1jg
11 ай бұрын
sir video is awesome but sir please provide next time data also .
@pranavganesh1855
8 ай бұрын
Do we have videos for Stored proc and Triggers by Sumit??
@NishantGautam-ju9sr
6 ай бұрын
@sumit Hi I am starting to learn SQL, groomide is giving a lot of issues in creating queries Is there any substitute available that I can use ??
@mdshaquibalam3806
Жыл бұрын
Best course on SQL
@Njooo5
11 ай бұрын
Thanks, but will this course be for MySql?
@greenshadowooo
Жыл бұрын
A very useful sharing ! 😊😊😊
@Lets_growww
2 ай бұрын
Great 👍
@figh761
5 ай бұрын
I have question : does the sql syntax is different for sql server, mysql and oracle. How you prepare for a sql developer test. Should I learn all these flavours
@Tony_stark551
7 ай бұрын
I have zero knowledge of SQL can i start this course and gain expert level knowledge??
@ronitsonlima9882
8 ай бұрын
Please change your logo location. When you write something sometimes below it's not showing
@chandrasekhar7995
9 ай бұрын
one completed, today ,excellent
@iffathunnisa6905
3 ай бұрын
can we get the link or anything of the notes file you are maintaining everything in,so its easy for us to back and revise the concepts.
@sumitmittal07
2 ай бұрын
Sql notes can be found here -github.com/bigdatabysumitm/NotesOfKZitemSQLSeries.git
@VinodKopuri-r4k
Жыл бұрын
could you please upload advanced concepts as well sir
@santoshkiran5858
Жыл бұрын
Indeed A Awesome 👍 learning Thanks a lot n lot's 🤝🤝🤝
@ShyamSundar-bw9yv
7 ай бұрын
Can someone tell me is this the complete tutorial of SQL or is there any other topics to be learnt? Is this enough If I watch this full video to learn SQL completely?
@tejasviadepu4359
11 ай бұрын
@Trendytech Insights: Are there any free tools we can use for the SQL? Goorm errors out while creating a container, it say unable to create the container. Please @Sumit Sir advise!
@krishnamohan-tn6br
5 ай бұрын
same problem here please tell me any alternate method
@akkys97
11 ай бұрын
Kindly Correct the Time Stamp Sir???
@nagarjunmopuru7003
10 ай бұрын
Could you please share sql notes it will be very helpful
@SunilSonawane-j1k
Жыл бұрын
why do we store various data item in multiple table? and then rejoin them to get data in single table?
@RahulKumar-me3eb
Жыл бұрын
Good question
@nysankofficial
22 күн бұрын
at what time does he show how to download the MySQL??
@rajatrj5714
11 ай бұрын
in my ssms """ Could not find stored procedure 'show'.""" this error is coming.... and 51:50 also showed error ...
@AyushSingh-m5o
2 ай бұрын
i am already enjoying this,does anyone has handwritten pdf
@sumitmittal07
2 ай бұрын
Sql notes can be found here -github.com/bigdatabysumitm/NotesOfKZitemSQLSeries.git
@AyushSingh-m5o
2 ай бұрын
thank you sir,i want certificate aswell
@kiranmg4831
7 ай бұрын
Sir, I can't copy and paste inside the page. What is the setting for that ? It is showing Can't access the clipboard.
@FLASHTUBE1552
9 ай бұрын
Sir example me "rajes'h" s ke baad single inverted commas kyu lagaya
@syedroshan8449
7 ай бұрын
Hats off to you sir, covered almost all topics, and provide these resources for free, you are an amzing person sir❤❤❤
@Sheebakhanam-y4e
Жыл бұрын
'Show' command is not working in MySQL. Why?
@TasmiyaZaheer-k5j
11 ай бұрын
sir please help , in the insert values command i keep getting this error ERROR 1054 (42S22): Unknown column 'kapil' in 'field list', the insert command i typed is exactly as told by you; INSERT INTO employee (Firstname, middlename, lastname, age, salary, location) VALUES (kapil,kuma r, sharma, 28, 10000, banglore);
the way sir is wrting all the notes down is there a way to get this text file ??
@sumitmittal07
2 ай бұрын
Sql notes can be found here -github.com/bigdatabysumitm/NotesOfKZitemSQLSeries.git
@atulanand4824
Жыл бұрын
Please share the notebook link sir, it's an amazing video
@paxipulpax745
8 ай бұрын
Access blocked: This app’s request is invalid i cannot creéte an account
@chiranjibguragain3076
Жыл бұрын
can someone provide topics with timestamps please??
@mtad-healthfitness
11 ай бұрын
Assalamualikum, sir may i know total how many session for this mysql covered here?and is it enough for a data analyst ? thanks.
@sowmiyasri173
Жыл бұрын
Timestamps please!
@pritomswarnakar4343
6 ай бұрын
Hi sir I need this document to learn your sql code. It's very much important to me.
@princeyadav-fz9kh
Жыл бұрын
sir will u provide pl/sql ??
@anonymous-ju4be
9 ай бұрын
Is this enough for placement ?
@gopichand5717
Жыл бұрын
Please share Full python course aswell sir
@sumitmittal07
Жыл бұрын
planning for it very soon
@kvshalini14
11 ай бұрын
i could never make goormide container run .I'm getting error that server is unable to retrieve the file .Could someone help me? i tried using in incognito window as well
@parthasarathy5222
7 ай бұрын
Even im facing pls help
@SHAKEB1000
Жыл бұрын
Sir ne hair transplant krwaya hai kya?BTW handsom lag rahai hai
@saumyakumari3441
6 ай бұрын
Is Auto-increment only goes with primary key ?
@DeepakTiwari-et3bd
5 ай бұрын
there can only be one auto_increment. you can have it with primary or unique key
@rabeeahmohammedyaqeen3956
3 ай бұрын
are you doing on command prompt or what
@rajatrj5714
11 ай бұрын
i am not able to execute all these operations in my SSMS "SQL SERVER MANAGEMENT STUDIO"
@whyme_141
4 ай бұрын
Ssms is very complicated
@gowtham7231
2 ай бұрын
Triggers, Stored procedures, User defined functions, Cursors, Views missed
@modikishore8295
2 ай бұрын
Anyone please let me know how to download that word document?
@JAVEDKHAN-nh2tw
9 ай бұрын
Sir please release python for data engineers
@SonPham-yn9nc
6 ай бұрын
Indian IT > teacher > course in college
@beticohernandez9536
11 ай бұрын
Buen video
@krishnamohan-tn6br
5 ай бұрын
goormide does not given premission to new container sir
@Rohitkumar-ms8pt
6 ай бұрын
whatever command I give always getting this error- "command not found" any idea? Thanks in advance
@sumitmittal07
6 ай бұрын
Can you share the commands that you are trying to execute and in which environment are you executing the commands
@Rohitkumar-ms8pt
6 ай бұрын
Hi @@sumitmittal07 I am following the video exactly step by step -created account of goorm -created a container - gave command- msql-ctl-cli; (ps- this is my first intro to SQL, I am extremly new. Probably I am missing something) Thanks in advance!
@whyme_141
4 ай бұрын
Lot of people are facing this issue. M also facing this issue. Any solution?
@harishwarank6445
6 ай бұрын
Hi Sir, Can I get the source code for this course ?
@ranjithraghunathan1267
11 ай бұрын
all the codes in the goorm editor i write and execute go away if i dont use the laptop for some time.
@PROTECHRAHUL
Жыл бұрын
Does this video explains relationships ?
@MrDFJohnson
11 ай бұрын
Watch it and find out. You'll learn something. If it doesn't then there are DB books and articles online that explain database theory including relationships
@maddyy1024
3 ай бұрын
does MYSQL and groomide have same features?? anyone please reply
@ResultsData
4 ай бұрын
Im stuck at loading the container .. It takes ages to load
Пікірлер: 163