Learn Basic SQL in 15 Minutes (PART 2/3) | Creating Tables | SQL Tutorial | Business Intelligence

[@LearnBI]

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql

[@ilhanbayramoglu2811]

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.

[@LearnBI]

Glad you liked it!

[@Glitch405_]

Me right now kekw

[@davidmartini7764]

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.

[@hrushikeshkulkarni7353]

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.😄

[@LearnBI]

You’re welcome, glad you like it.

[@anitamurphy2323]

You are rude

[@hrushikeshkulkarni7353]

@@anitamurphy2323 how can an SQL video be rude 😅

[@jackriebel2406]

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

[@LearnBI]

Thanks very much for your positive feedback, it's much appreciated!

[@TinyKideo]

Very True, and I think this channel is underrated ...

[@omarino99]

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.

[@LearnBI]

Wow, thank you!

[@HalleluyahJJang]

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

[@LearnBI]

You’re welcome, glad they helped

[@sohailiqbalsiddiqui1954]

Any update on your career change?

[@HalleluyahJJang]

@@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

[@sohailiqbalsiddiqui1954]

@@HalleluyahJJang All the best 🙌

[@newera8388]

@@HalleluyahJJang keep going🤝🏾

[@ricardorodriguez7803]

Such a good video, so much knowledge compressed perfectly into 16 minutes. keep them coming!!

[@LearnBI]

Thanks for the feedback. Part 3 coming early 2022.

[@NavneetKaur-pr2pq]

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🙌

[@LearnBI]

Thank you, glad you found the videos helpful

[@bintangdilangit3348]

Really for me, you are the most usefull, clear, informatif, short and best video that teach sql in yt. Its so easy and short

[@LearnBI]

Glad you think so!

[@disintegratev6951]

The fact that this is free is actually mind blowing, this is amazing

[@LearnBI]

Glad you like it!

[@mussen1876]

Thanks Adam. I’m new to SQL and these videos are very helpful and are paced well.

[@irinamicov]

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.

[@LearnBI]

Glad you enjoyed it!

[@ThePatrickFamilyBand]

This was actually a legit software/coding video. Thanks for breaking down the SQL rudiments.

[@LearnBI]

You’re welcome

[@equiwave80]

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!!!

[@el_blueponcho]

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.

[@LearnBI]

Glad you’re enjoying them!

[@BryantJohnsonsimbalion45]

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!

[@LearnBI]

You're very welcome! Happy new year to you too

[@gb342002]

Getting my BI career training started with these videos. Great content Adam!

[@LearnBI]

Thanks! Glad it's helpful

[@gb342002]

How do I do that?

[@LearnBI]

@@gb342002 *glad

[@gb342002]

@@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!

[@dagsystemlimited7194]

This is absolutely great. I love this. Thank you

[@LearnBI]

Glad you like it!

[@chadgraber4575]

As a massive Bond fan, using that table as an example was a pleasant surprise.

[@LearnBI]

“The name’s SQL. MySQL” 😂

[@aiasaiascon3894]

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!!!

[@LearnBI]

Thank you for your kind words 🙏

[@shanaldoable]

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!!

[@LearnBI]

You're very welcome!

[@clinkelc]

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 😊

[@LearnBI]

You're welcome, I'm glad you like the videos

[@AmnaBajwa-v5e]

3 weeks into the semester, and I was so feeling so lost, thank you for these amazing videos!

[@LearnBI]

Glad they helped!

[@amoso.adjaottor9181]

Great to be here I love the teachings ❤👍

[@LearnBI]

Welcome!

[@carl-christianmalm863]

Thanks for the great content!! Very easy to understand and follow and much appreciated for a late bloomer in SQL :)

[@LearnBI]

You’re welcome!

[@konulaslan]

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

[@LearnBI]

You're very welcome!

[@LearnBI]

🚀 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

[@KB-uq9ti]

Thank you for this!!! I’m brand spanking new and this makes sense

[@LearnBI]

You're welcome!

[@capturethemoment1624]

Thank you for your great and understandable videos about BI :)

[@passportbro904]

just blown away, just thank you

[@LearnBI]

You’re welcome

[@ryanking855]

agree with james bond decisions as well.

[@annisaautami]

thank you for this amazing concise video! been enjoying the first part too

[@LearnBI]

My pleasure

[@barksnbrews]

Thank you so much; these make is really digestible when you're just learning a new program.

[@mbongenidube6661]

wow - you're amazing - I am learning so much and immediately applying this at work. Thank you

[@LearnBI]

You're so welcome!

[@lakshitakamboj198]

Perfect Perfect Perfect. Thank you

[@LearnBI]

You’re welcome!

[@serdip]

Amazing video series! Thank you so much for sharing your knowledge. SQL = Super Quick Learning or Something Quickly Learned 😎

[@LearnBI]

Glad you enjoyed it!

[@beebee3871]

Binging your videos to prepare for a job interview.... thank you SO MUCH for high quality content!!! 💛💛💛

[@LearnBI]

My pleasure!

[@kamirasherman7956]

Thank you for making this plain. You are appreciated 👍🏾

[@LearnBI]

You’re welcome!

[@islamifinanceurdu1435]

Underrated class

[@LearnBI]

Thank you

[@ccvc87]

I like your content, well structured and straight to the point.

[@LearnBI]

Glad you like it!

[@print_the_code9156]

This is the very best way to create a database . 👍👍👍👍👍

[@ainadalilah]

free online platform for sql, which on is recommended? w3school ?

[@LuisNunez777]

Great videos Mate, thank you

[@LearnBI]

Glad you like them!

[@bondlavern]

This was fantastic!

[@LearnBI]

Thank you!

[@Thabo622]

thank you for making videos interesting and easy to follow

[@LearnBI]

Glad you like them!

[@hirudikapremaratne2034]

Learned a lot. Thanks!

[@LearnBI]

You’re welcome!

[@yogalakshmi3356]

it's great!! I loved it. To the point and crisp

[@LearnBI]

Glad you liked it!

[@Vophsigem]

Thank you!

[@ElodieSarel]

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? :)

[@LearnBI]

Yes, with the right tool. You would still need to check that all the fields have been assigned the correct data type.

[@AstroAce7]

Thank you for this content. Subbed:)!

[@LearnBI]

Thanks!

[@FCMGA]

what a life savior thank you good sir.

[@LearnBI]

You’re welcome

[@vinodhvalleri6595]

Hey ur the unique and primarkey in which explains in SQL u are the best ❤️❤️❤️

[@LearnBI]

Thanks ☺️

[@youssefrizk5905]

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.

[@LearnBI]

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.

[@ccostanz22]

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?

[@LearnBI]

Just answered this question on your other comment kzbin.info/www/bejne/oZOupaxrj7t-g7s&lc=UgyYAvDnoObOU7xkeHl4AaABAg

[@ccostanz22]

@@LearnBI thanks much, will look into it this weekend.

[@lauraheilbrun5122]

So helpful, thank you!

[@LearnBI]

Glad it was helpful!

[@TiieMee-d3w]

✨ You are a star

[@knowix1996]

That was great. Thank you.

[@LearnBI]

You’re welcome

[@sonalisharma8340]

hii,please make more videos.your way of teaching is so easy.

[@LearnBI]

That’s the plan!

[@sabuein]

Thank you. Very helpful.

[@LearnBI]

You're welcome!

[@dezc55555]

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

[@LearnBI]

Hi Dez. Not sure I understand the use case. Copy from where? Or do you mean INSERT? If so, the tutorial explains this.

[@hxsouv]

This was very informative. Thank you! Do you have cheat sheets for part 1 and 2 of basic SQL?

[@LearnBI]

Glad you liked it. Sorry, no cheat sheet for those parts.

[@aiasaiascon3894]

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! 😄

[@LearnBI]

I know! Woody Allen as a Bond villain, it’s a bit ridiculous. But then the film is pretty ridiculous 🤣

[@wvldent]

Excellent Presentation

[@LearnBI]

Thank you!

[@yoni1991]

you are amazing. thank you

[@LearnBI]

Thank you too!

[@newssir5790]

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)

[@dane-c7g]

Amazing videos, helps a lot :)

[@LearnBI]

Thanks, glad to help!

[@IMXHUSTLAAA]

thank you you really helped

[@neutrinoBH]

Very nice video, Thanks.

[@LearnBI]

Thanks!

[@chukwuemekamusic663]

thank you

[@LearnBI]

You're welcome

[@SYNC4646]

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.

[@LearnBI]

Yes, that is indeed very fun!

[@jimmysjohns2466]

Thanks for the video! I am trying to follow along at home - do you have a link available to download this data source?

[@LearnBI]

Not currently, sorry

[@richieforrest5611]

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

[@LearnBI]

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.

[@sphamandlandlovu3554]

I just want to know. Is this coding, programming or both?

[@LearnBI]

It can be both 😁

[@stephencrawford8210]

How do I know what software to use for writing this SQL code?

[@LearnBI]

You could use Navicat or MySQL Workbench

[@WorkingClassDabrowa]

That's better explained in English than in my native language elsewhere. Thank you.

[@LearnBI]

Glad to hear that!

[@matthewbryson6423]

Where do you find this Dataset?

[@LearnBI]

I made it myself

[@LM-ch8rh]

hi. does anyone have a suggestion for an alternative to Navicat that's free?

[@LearnBI]

MySQL Workbench

[@LM-ch8rh]

@@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

[@paulacarvajal5315]

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.

[@RameesahFarooqui]

If there's a heaven, there is a special place for you in it

[@LearnBI]

Thank you, that’s kind of you 🙏🏻

[@Islamrulzzz]

I am taking data analytics course,and SQL seems so complicated…😮

[@LearnBI]

Not as complicated as you might think

[@robwebber5657]

am I the only one who cannot unsee "The Spay Who Loved Me"?

[@tiffanygray9]

I disagree because I personally LOVE Woody Allen because I confused him with Woody Boyd from cheers and zombie land lol 😂

[@LearnBI]

😂

[@leothalion3983]

Just help me close out a B.A degree!

[@trollplayz6483]

My SQL test is tomorrow loll

[@LearnBI]

Hope this helped!

[@trollplayz6483]

@@LearnBI it helped a lot!

[@RichardLOCOSalazar]

⁹😊⁹90😊😊

[@samuelnjogu2004]

Manchester United can't even win in sql😢

[@hrist3820]

GOAT shit!!

[@helpanimals-]

How the hell am I supposed to remember all this? commas, dots, brackets...jesus

[@LearnBI]

It’s called “learning” 😉

[@itsyourboyyy]

It's too much content for a beginner

[@LearnBI]

The good thing about video is that you can watch it over and over.