Hi Baraa Sir , I guess there is a scope one correction Question no #34 ( 46:25 ) , Here we may require a subquery as the length of last_name is being calculated with white spaces which should be trimmed and length should be calculated separately ! Thank you 💗
God bless you brother, this was more concise, clear and helpful than anything else I came across. Hopefully you also start uploading content for Machine Learning and Coding with Python for Data Science
I would like to ask, how to make an update to the 'birth_date' column for the 'persons' table if i already insert a new row. Beacuse i get an error each time i tried to update any row with a date OR there may be a special date format for the database.
Hi, I will publish next week few videos about ChatGPT then start working on the advanced SQL course for data science, after that I will continue on Tableau. This is currently my plan :) Which topic you like the most?
☕ If you want to see more videos like this, Subscribe for more data tutorials like this :) bit.ly/3GiCVUE
---------------------------------
⏱ TIMESTAMPS ⏱
---------------------------------
00:00:00 Course Materials & Dataset
00:00:44 #1 SQL Task - Querying Data
00:03:32 #2 SQL Task - Querying Data
00:04:33 #3 SQL Task - Querying Data
00:06:12 #4 SQL Task - Querying Data
00:08:30 #5 SQL Task - Querying Data
00:09:44 #6 SQL Task - Querying Data
00:11:33 #7 SQL Task - Filtering Data
00:13:51 #8 SQL Task - Filtering Data
00:14:31 #9 SQL Task - Filtering Data
00:15:16 #10 SQL Task - Filtering Data
00:16:21 #11 SQL Task - Filtering Data
00:16:58 #12 SQL Task - Filtering Data
00:18:02 #13 SQL Task - Filtering Data
00:19:20 #14 SQL Task - Filtering Data
00:19:54 #15 SQL Task - Filtering Data
00:20:15 #16 SQL Task - Filtering Data
00:21:53 #17 SQL Task - Filtering Data
00:24:20 #18 SQL Task - Filtering Data
00:25:14 #19 SQL Task - Filtering Data
00:25:48 #20 SQL Task - Filtering Data
00:26:26 #21 SQL Task - Filtering Data
00:27:08 #22 SQL Task - Joining Data
00:31:52 #23 SQL Task - Joining Data
00:32:48 #24 SQL Task - Joining Data
00:33:37 #25 SQL Task - Joining Data
00:35:57 #26 SQL Task - Joining Data
00:38:14 #27 SQL Task - Functions
00:39:39 #28 SQL Task - Functions
00:41:31 #29 SQL Task - Functions
00:42:24 #30 SQL Task - Functions
00:43:00 #31 SQL Task - Functions
00:45:10 #32 SQL Task - Functions
00:46:00 #33 SQL Task - Functions
00:46:34 #34 SQL Task - Functions
00:47:27 #35 SQL Task - SQL Advanced
00:49:15 #36 SQL Task - SQL Advanced
00:49:59 #37 SQL Task - SQL Advanced
00:51:20 #38 SQL Task - SQL Advanced
00:53:27 #39 SQL Task - SQL Advanced
01:01:07 #40 SQL Task - Modifying Data
01:05:07 #41 SQL Task - Modifying Data
01:08:15 #42 SQL Task - Modifying Data
01:11:10 #43 SQL Task - Modifying Data
01:13:23 #44 SQL Task - Modifying Data
01:15:00 #45 SQL Task - Defining Data
01:21:07 #46 SQL Task - Defining Data
01:22:38 #47 SQL Task - Defining Data
01:23:02 End
Enjoy :)
Awesome tutorial on fundamental database querying, crystal clear and concise! You really master the art of teaching!
your style of teaching is very good. very slowly you are breaking down everything. It is very helpful for me as I started sql from abc.
Hi Islam, thank you so much for your nice comments and feedback! I really appreciate it
Hi Baraa Sir ,
I guess there is a scope one correction Question no #34 ( 46:25 ) , Here we may require a subquery as the length of last_name is being calculated with white spaces which should be trimmed and length should be calculated separately !
Thank you 💗
God bless you brother, this was more concise, clear and helpful than anything else I came across. Hopefully you also start uploading content for Machine Learning and Coding with Python for Data Science
Thanks Baraa , Awesome tutorial
Keep it up 💪
I would like to ask, how to make an update to the 'birth_date' column for the 'persons' table if i already insert a new row. Beacuse i get an error each time i tried to update any row with a date OR there may be a special date format for the database.
Thanks so much as usual
Your welcome!
thanks my borther
Please make video on advanced SQL before chatgpt please i wanna learn Sql
Hi, hmm i just finished the ChatGPT, i will be recording now the advanced SQL topics.
Hi Baraa, which topic will be next after sql..
Hi, I will publish next week few videos about ChatGPT then start working on the advanced SQL course for data science, after that I will continue on Tableau. This is currently my plan :) Which topic you like the most?
@@DataWithBaraa that's awesome..plz make videos on advance python as well for data science. Thanks
@@DataWithBaraa waiting for chatGPT
Hi Baraa, where can I find the dataset you used?
Hi James, in the video description you can find the link. bit.ly/3DG6yxU