This is a great refresher. I studied SQL and struggled a bit. After a year of not revisitng it, this helped me tremendously in remembering and relearning the material.
I have to pay attention to every word you are uttering so that I don't miss anything. Such is the amount of quality content in this small video. I am new to SQL and looking forward to learn. Thanks for the video.😄
These videos are incredible with the amount of knowledge and how well you explain it, and the fact that you use (at least for this series) football tables and other fun tables like the james bond film table just makes the videos that much better, only had to watch one video to subscribe
These videos are pure genius. You managed to maximize the amount of expressible knowledge in the space of all the words that one can utter in the span of 15 minutes. Great job.
@@sohailiqbalsiddiqui1954 I got into a managerial role in a data science company, have found out that I'm more interested in software engineering than data science, so currently on a learning path for that, hoping to finally get out of management jobs and into an engineering job with this one, fingers crossed
Thanks for this superb video!!! It was a lot of informative details bundled up in a short time... On a lighter note, I started watching bond films thanks to my father who was a big Sean Connery fan... I am a Pierce Brosnan fan as I actively started watching Bond films after Goldeneye. Now when I revisit the old Bond movies I can truly understand why Sean Connery truly made the James Bond character a Global icon!!!
i had very minimal understanding of SQL. However, after 2 videos, i feel a lot better about SQL than I did before. One thing that really allowed me to grasp the concept is the topics for the data (i.e. FIFA for video 1 and James Bond for video 2). One more to go, appreciate the tutorials.
Hi Adam - I agree with -Hrushikesh Kulkarni - that is a really good video and I believe it is the way you speak and express that makes the videos so good. Keep up - thank you so much!!!
This is PURE GOLD information. Delivered in a superbly simple manner! Precise, Concise, Relevant, and EASY TO UNDERSTAND! Thank you, Indeed, Adam Finer! Happy New Year!
🚀 BI CAREER STARTER PROGRAM 🚀 A fully mentored certification program taking you from ZERO TO BI ANALYST IN 12 WEEKS. Your new career starts here 👉🏻 geni.us/bicsp
Thank you for the amazing explanation, I am new to SQL and data analyst and your videos are amazing. I just have a query : If we can directly upload the database directly to Navicat, then why we are creating the table and uploading the data into it.
The data used in part 1 is a pre-built SQLite database so the tables have already been created. This video teaches you how to create new tables in a database.
Your videos are great, thanks so much. I guess if we want to upload a table directly, and not write all the fields manually, it would be possible too right? :)
Any recommendations on where to be able to practice this stuff? I work as a product sales analyst and working to learn SQL. These videos have been by far the most helpful and i now have access to our teradata servers. Looking for somewhere i can practice?
Hi Adam!!! - I cannot remember watching Casino Royale of 1967! which explains why I cannot recall Woody Allen??? in Bond films??? Wow!!!! I have no specific disagreement with "Never Say Never Again" though sometimes I get greedy with data and I would have like you to include them! 😄
Hi Adam, I just came across your tutorial and want to thank you for putting this together. Very helpful and easy to follow. I do have one question regarding the insert of values/data into the table. If I want to copy all rows into the bond table, what would be the query? Thanks
sir is this true about decimal: In SQL, the decimal(5,1) data type specifies a decimal number with a total of 5 digits and 1 digit after the decimal point. Here's what each part of the specification represents: The first number (5) indicates the total number of digits allowed for the number, both before and after the decimal point. The second number (1) specifies the number of digits allowed after the decimal point. In the case of decimal(5,1), you have a maximum of 5 digits in total, with 1 digit reserved for the decimal part. This means you can have numbers ranging from -999.9 to 999.9. Here are some examples of valid numbers for a decimal(5,1) column: 123.4 -45.6 0.0 999.9 And here are some examples of invalid numbers for a decimal(5,1) column: 1234.5 (exceeds the total number of digits allowed) -12.34 (exceeds the number of digits after the decimal point allowed) 1000.0 (exceeds the maximum value allowed)
FUN FACT:-we don't need to insert any numbers into the ID column every time because The ID column is an auto-increment field and will be generated automatically when a new record is inserted into the table.
I've got stuck at 5.35, because I can't work out how to set up a new MySQL connection. I'm using Navicat Premium. Super frustrating. Establishing a new connection is super easy, but Navicat wants to know Host, Port, User Name and Passsword, and of course I can't give it those if the database doesn't exist yet! Adam can you provide some instructions on how to get Navicat set up for the instructions from 5.35 onward please. Thanks
You’ll either need to download and install an rdbms (MySQL in this case) on your compute or create and instance in the cloud (e.g. cloud.google.com - paid). Once you’ve done this, you’ll be able to create a connection to it in Navicat.
@@LearnBI thank you so much for your suggestion. so glad i found your channel. just starting out with SQL but have used FileMaker to start a DB so have some experience with that. i downloaded the free Navicat 2-week trial then when that runs out I'll switch to MySQLWorkbench
You didn't showed the outcome of the table. Where is the final table? You built new tabs with new queries a lot, then where is the outcome? I was following the video with my Navicat.
🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql
Imagine learning 1 semester of a lesson in 45 minutes... Now he makes it reality! Thanks man,zero to hero for sql starters like me.
Glad you liked it!
Me right now kekw
This is a great refresher. I studied SQL and struggled a bit. After a year of not revisitng it, this helped me tremendously in remembering and relearning the material.
I have to pay attention to every word you are uttering so that I don't miss anything. Such is the amount of quality content in this small video. I am new to SQL and looking forward to learn. Thanks for the video.😄
You’re welcome, glad you like it.
You are rude
@@anitamurphy2323 how can an SQL video be rude 😅
These videos are incredible with the amount of knowledge and how well you explain it, and the fact that you use (at least for this series) football tables and other fun tables like the james bond film table just makes the videos that much better, only had to watch one video to subscribe
Thanks very much for your positive feedback, it's much appreciated!
Very True, and I think this channel is underrated ...
These videos are pure genius. You managed to maximize the amount of expressible knowledge in the space of all the words that one can utter in the span of 15 minutes. Great job.
Wow, thank you!
I'm doing some self learning to get into a Data Science career path, both the SQL vids were super informative and clear, appreciated them a lot
You’re welcome, glad they helped
Any update on your career change?
@@sohailiqbalsiddiqui1954 I got into a managerial role in a data science company, have found out that I'm more interested in software engineering than data science, so currently on a learning path for that, hoping to finally get out of management jobs and into an engineering job with this one, fingers crossed
@@HalleluyahJJang All the best 🙌
@@HalleluyahJJang keep going🤝🏾
The fact that this is free is actually mind blowing, this is amazing
Glad you like it!
I was just searching to get a good start for sql learning and i came across to ur videos…surely the best tutorial for beginners🙌
Thank you, glad you found the videos helpful
Such a good video, so much knowledge compressed perfectly into 16 minutes. keep them coming!!
Thanks for the feedback. Part 3 coming early 2022.
As a massive Bond fan, using that table as an example was a pleasant surprise.
“The name’s SQL. MySQL” 😂
This was actually a legit software/coding video. Thanks for breaking down the SQL rudiments.
You’re welcome
3 weeks into the semester, and I was so feeling so lost, thank you for these amazing videos!
Glad they helped!
Really for me, you are the most usefull, clear, informatif, short and best video that teach sql in yt. Its so easy and short
Glad you think so!
Thanks Adam. I’m new to SQL and these videos are very helpful and are paced well.
Thanks for this superb video!!!
It was a lot of informative details bundled up in a short time...
On a lighter note, I started watching bond films thanks to my father who was a big Sean Connery fan...
I am a Pierce Brosnan fan as I actively started watching Bond films after Goldeneye.
Now when I revisit the old Bond movies I can truly understand why Sean Connery truly made the James Bond character a Global icon!!!
This is absolutely great. I love this. Thank you
Glad you like it!
i had very minimal understanding of SQL. However, after 2 videos, i feel a lot better about SQL than I did before. One thing that really allowed me to grasp the concept is the topics for the data (i.e. FIFA for video 1 and James Bond for video 2). One more to go, appreciate the tutorials.
Glad you’re enjoying them!
Getting my BI career training started with these videos. Great content Adam!
Thanks! Glad it's helpful
How do I do that?
@@gb342002 *glad
@@LearnBI Got it! Well awesome you respond to all your viewers. I'll pay it back or forward some day when I'm in my new career!
Great to be here I love the teachings ❤👍
Welcome!
I really like how you put things so simply making SQL learnable for beginners. Thanks a bunch. I really appreciate it. 13.06.2023, 5:47 a.m
You're very welcome!
Thank you so much; these make is really digestible when you're just learning a new program.
Thank you for this!!! I’m brand spanking new and this makes sense
You're welcome!
just blown away, just thank you
You’re welcome
Binging your videos to prepare for a job interview.... thank you SO MUCH for high quality content!!! 💛💛💛
My pleasure!
Hi Adam - I agree with -Hrushikesh Kulkarni - that is a really good video and I believe it is the way you speak and express that makes the videos so good. Keep up - thank you so much!!!
Thank you for your kind words 🙏
I’m not sure if it’s the desire I have or maybe you just make it so much interesting to learn.
Thanks either ways for making the lecture available 😊
You're welcome, I'm glad you like the videos
Another fantastic video! I must say, apart from the content itself, I also appreciate how well it's delivered and the quality of the video editing.
Glad you enjoyed it!
Thank you for your great and understandable videos about BI :)
Perfect Perfect Perfect. Thank you
You’re welcome!
thank you for this amazing concise video! been enjoying the first part too
My pleasure
Not sure why my college wants a software program to "teach me". I cannot get tutoring help at my school....this was SUPER helpful!! Thank you!!
You're very welcome!
Thank you for making this plain. You are appreciated 👍🏾
You’re welcome!
agree with james bond decisions as well.
Underrated class
Thank you
This is the very best way to create a database . 👍👍👍👍👍
wow - you're amazing - I am learning so much and immediately applying this at work. Thank you
You're so welcome!
This is PURE GOLD information. Delivered in a superbly simple manner! Precise, Concise, Relevant, and EASY TO UNDERSTAND! Thank you, Indeed, Adam Finer! Happy New Year!
You're very welcome! Happy new year to you too
Thanks for the great content!! Very easy to understand and follow and much appreciated for a late bloomer in SQL :)
You’re welcome!
Thank you!
what a life savior thank you good sir.
You’re welcome
Amazing video series! Thank you so much for sharing your knowledge.
SQL = Super Quick Learning or Something Quickly Learned 😎
Glad you enjoyed it!
✨ You are a star
I like your content, well structured and straight to the point.
Glad you like it!
Hey ur the unique and primarkey in which explains in SQL u are the best ❤️❤️❤️
Thanks ☺️
Learned a lot. Thanks!
You’re welcome!
This was fantastic!
Thank you!
thank you for making videos interesting and easy to follow
Glad you like them!
So helpful, thank you!
Glad it was helpful!
That was great. Thank you.
You’re welcome
it's great!! I loved it. To the point and crisp
Glad you liked it!
🚀 BI CAREER STARTER PROGRAM 🚀
A fully mentored certification program taking you from ZERO TO BI ANALYST IN 12 WEEKS.
Your new career starts here 👉🏻 geni.us/bicsp
Thank you. Very helpful.
You're welcome!
Great videos Mate, thank you
Glad you like them!
Thank you for this content. Subbed:)!
Thanks!
hii,please make more videos.your way of teaching is so easy.
That’s the plan!
you are amazing. thank you
Thank you too!
thank you
You're welcome
Excellent Presentation
Thank you!
thank you you really helped
Very nice video, Thanks.
Thanks!
Amazing videos, helps a lot :)
Thanks, glad to help!
Thank you for the amazing explanation, I am new to SQL and data analyst and your videos are amazing. I just have a query :
If we can directly upload the database directly to Navicat, then why we are creating the table and uploading the data into it.
The data used in part 1 is a pre-built SQLite database so the tables have already been created. This video teaches you how to create new tables in a database.
That's better explained in English than in my native language elsewhere. Thank you.
Glad to hear that!
Your videos are great, thanks so much. I guess if we want to upload a table directly, and not write all the fields manually, it would be possible too right? :)
Yes, with the right tool. You would still need to check that all the fields have been assigned the correct data type.
Any recommendations on where to be able to practice this stuff? I work as a product sales analyst and working to learn SQL. These videos have been by far the most helpful and i now have access to our teradata servers. Looking for somewhere i can practice?
Just answered this question on your other comment th-cam.com/video/kbKty5ZVKMY/w-d-xo.html&lc=UgyYAvDnoObOU7xkeHl4AaABAg
@@LearnBI thanks much, will look into it this weekend.
This was very informative. Thank you! Do you have cheat sheets for part 1 and 2 of basic SQL?
Glad you liked it. Sorry, no cheat sheet for those parts.
Hi Adam!!! - I cannot remember watching Casino Royale of 1967! which explains why I cannot recall Woody Allen??? in Bond films??? Wow!!!! I have no specific disagreement with "Never Say Never Again" though sometimes I get greedy with data and I would have like you to include them! 😄
I know! Woody Allen as a Bond villain, it’s a bit ridiculous. But then the film is pretty ridiculous 🤣
Hi Adam, I just came across your tutorial and want to thank you for putting this together. Very helpful and easy to follow. I do have one question regarding the insert of values/data into the table. If I want to copy all rows into the bond table, what would be the query? Thanks
Hi Dez. Not sure I understand the use case. Copy from where? Or do you mean INSERT? If so, the tutorial explains this.
Thanks for the video! I am trying to follow along at home - do you have a link available to download this data source?
Not currently, sorry
free online platform for sql, which on is recommended? w3school ?
If there's a heaven, there is a special place for you in it
Thank you, that’s kind of you 🙏🏻
sir is this true about decimal: In SQL, the decimal(5,1) data type specifies a decimal number with a total of 5 digits and 1 digit after the decimal point. Here's what each part of the specification represents:
The first number (5) indicates the total number of digits allowed for the number, both before and after the decimal point.
The second number (1) specifies the number of digits allowed after the decimal point.
In the case of decimal(5,1), you have a maximum of 5 digits in total, with 1 digit reserved for the decimal part. This means you can have numbers ranging from -999.9 to 999.9.
Here are some examples of valid numbers for a decimal(5,1) column:
123.4
-45.6
0.0
999.9
And here are some examples of invalid numbers for a decimal(5,1) column:
1234.5 (exceeds the total number of digits allowed)
-12.34 (exceeds the number of digits after the decimal point allowed)
1000.0 (exceeds the maximum value allowed)
am I the only one who cannot unsee "The Spay Who Loved Me"?
FUN FACT:-we don't need to insert any numbers into the ID column every time because The ID column is an auto-increment field and will be generated automatically when a new record is inserted into the table.
Yes, that is indeed very fun!
I've got stuck at 5.35, because I can't work out how to set up a new MySQL connection. I'm using Navicat Premium. Super frustrating. Establishing a new connection is super easy, but Navicat wants to know Host, Port, User Name and Passsword, and of course I can't give it those if the database doesn't exist yet!
Adam can you provide some instructions on how to get Navicat set up for the instructions from 5.35 onward please. Thanks
You’ll either need to download and install an rdbms (MySQL in this case) on your compute or create and instance in the cloud (e.g. cloud.google.com - paid). Once you’ve done this, you’ll be able to create a connection to it in Navicat.
hi. does anyone have a suggestion for an alternative to Navicat that's free?
MySQL Workbench
@@LearnBI thank you so much for your suggestion. so glad i found your channel. just starting out with SQL but have used FileMaker to start a DB so have some experience with that. i downloaded the free Navicat 2-week trial then when that runs out I'll switch to MySQLWorkbench
How do I know what software to use for writing this SQL code?
You could use Navicat or MySQL Workbench
Where do you find this Dataset?
I made it myself
I just want to know. Is this coding, programming or both?
It can be both 😁
I disagree because I personally LOVE Woody Allen because I confused him with Woody Boyd from cheers and zombie land lol 😂
😂
I am taking data analytics course,and SQL seems so complicated…😮
Not as complicated as you might think
You didn't showed the outcome of the table. Where is the final table? You built new tabs with new queries a lot, then where is the outcome? I was following the video with my Navicat.
My SQL test is tomorrow loll
Hope this helped!
@@LearnBI it helped a lot!
Just help me close out a B.A degree!
GOAT shit!!
Manchester United can't even win in sql😢
⁹😊⁹90😊😊
How the hell am I supposed to remember all this? commas, dots, brackets...jesus
It’s called “learning” 😉
It's too much content for a beginner
The good thing about video is that you can watch it over and over.