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

@LearnBI

2 жыл бұрын

Glad you liked it!

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

2 жыл бұрын

You’re welcome, glad you like it.

@anitamurphy2323

Жыл бұрын

You are rude

@hrushikeshkulkarni7353

Жыл бұрын

@@anitamurphy2323 how can an SQL video be rude 😅

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.

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

2 жыл бұрын

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

@TinyKideo

2 жыл бұрын

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

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

@LearnBI

2 жыл бұрын

Thanks for the feedback. Part 3 coming early 2022.

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

2 жыл бұрын

Wow, thank you!

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

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!

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

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

2 жыл бұрын

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🤝🏾

short and sweet just best video on sql thanks

🚀 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

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

@LearnBI

Жыл бұрын

“The name’s SQL. MySQL” 😂

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

2 жыл бұрын

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

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

@LearnBI

Жыл бұрын

Glad you like it!

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

2 жыл бұрын

Glad you think so!

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

@LearnBI

2 жыл бұрын

You're welcome!

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

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

@LearnBI

Жыл бұрын

You’re welcome!

thank you you really helped

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

9 ай бұрын

Thank you, glad you found the videos helpful

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

@LearnBI

Жыл бұрын

You’re welcome

✨ You are a star

just blown away, just thank you

@LearnBI

Ай бұрын

You’re welcome

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

11 ай бұрын

Glad you’re enjoying them!

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

@LearnBI

11 ай бұрын

You’re welcome!

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

@LearnBI

Күн бұрын

My pleasure

Learned a lot. Thanks!

@LearnBI

2 жыл бұрын

You’re welcome!

Perfect Perfect Perfect. Thank you

@LearnBI

2 жыл бұрын

You’re 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!

@LearnBI

Жыл бұрын

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

This was fantastic!

@LearnBI

2 жыл бұрын

Thank you!

Great videos Mate, thank you

@LearnBI

2 жыл бұрын

Glad you like them!

agree with james bond decisions as well.

Great to be here I love the teachings ❤👍

@LearnBI

Жыл бұрын

Welcome!

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

@LearnBI

2 жыл бұрын

Thanks ☺️

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

@LearnBI

Жыл бұрын

Glad you like it!

Thank you for this content. Subbed:)!

@LearnBI

2 жыл бұрын

Thanks!

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

@LearnBI

7 ай бұрын

You're so welcome!

So helpful, thank you!

@LearnBI

Жыл бұрын

Glad it was helpful!

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!

thank you for making videos interesting and easy to follow

@LearnBI

2 жыл бұрын

Glad you like them!

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

@LearnBI

18 күн бұрын

My pleasure!

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

@LearnBI

Жыл бұрын

Glad you enjoyed it!

what a life savior thank you good sir.

@LearnBI

Жыл бұрын

You’re welcome

Amazing videos, helps a lot :)

@LearnBI

2 жыл бұрын

Thanks, glad to help!

Underrated class

@LearnBI

2 жыл бұрын

Thank you

Thank you. Very helpful.

@LearnBI

2 жыл бұрын

You're welcome!

That was great. Thank you.

@LearnBI

Жыл бұрын

You’re welcome

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!

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

@LearnBI

2 жыл бұрын

Glad you liked it!

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

@LearnBI

7 ай бұрын

Thanks! Glad it's helpful

@gb342002

7 ай бұрын

How do I do that?

@LearnBI

7 ай бұрын

@@gb342002 *glad

@gb342002

7 ай бұрын

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

Excellent Presentation

@LearnBI

2 жыл бұрын

Thank you!

Very nice video, Thanks.

@LearnBI

2 жыл бұрын

Thanks!

you are amazing. thank you

@LearnBI

2 жыл бұрын

Thank you too!

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

@LearnBI

Жыл бұрын

That’s the plan!

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

2 жыл бұрын

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.

adam is the goat

thank you

@LearnBI

Жыл бұрын

You're welcome

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

2 жыл бұрын

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

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.

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.

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

2 жыл бұрын

Just answered this question on your other comment kzread.info/dash/bejne/nZZ_1ttuirmxfbw.html&lc=UgyYAvDnoObOU7xkeHl4AaABAg

@ccostanz22

2 жыл бұрын

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

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.

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

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

9 ай бұрын

Yes, that is indeed very fun!

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

@LearnBI

2 жыл бұрын

Glad to hear that!

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

2 жыл бұрын

Thank you for your kind words 🙏

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

@LearnBI

2 ай бұрын

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)

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

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

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

@LearnBI

Жыл бұрын

It can be both 😁

Where do you find this Dataset?

@LearnBI

2 жыл бұрын

I made it myself

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

@LearnBI

7 ай бұрын

You could use Navicat or MySQL Workbench

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.

Just help me close out a B.A degree!

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

@LearnBI

10 ай бұрын

Not as complicated as you might think

My SQL test is tomorrow loll

@LearnBI

2 жыл бұрын

Hope this helped!

@trollplayz6483

2 жыл бұрын

@@LearnBI it helped a lot!

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

@LearnBI

2 жыл бұрын

😂

GOAT shit!!

⁹😊⁹90😊😊

Manchester United can't even win in sql😢

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

@LearnBI

Жыл бұрын

It’s called “learning” 😉

It's too much content for a beginner

@LearnBI

4 ай бұрын

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

If you were my teacher in highschool, I'd be in much better place now