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

🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql
Watch Part 1 Here - • Learn Basic SQL in 15 ...
Watch Part 3 Here - • Learn Basic SQL in 15 ...
In this 2nd SQL tutorial for beginners in the series teaching you basic SQL fundamentals in 15 minutes, we talk about tables. What they are, how to create them and how to manage the data in them. Don't forget to check out part 1 to learn what is SQL. What you learn over the course of these videos can be applied to MySQL, PostgreSQL and others.
🔵 LEARNSQL.COM
A comprehensive set of 56 hands-on online SQL courses for teams and individuals
geni.us/learnsql
00:00 Intro
01:08 What are data tables?
02:38 SQL data types
04:25 The data source
05:47 Creating a data table in SQL
08:27 Deleting a data table in SQL
08:44 SQL column constraints
11:45 Inserting data into a SQL table
13:49 Updating SQL tables
16:53 Outro
🏠 JOIN THE LEARN BI ACADEMY - geni.us/lbi_academy
🚀 BECOME A BI ANALYST - geni.us/lbia_biasp
🏆 TAKE THE BI CONSULTANT MASTERCLASS - geni.us/lbia_bicm
🧰 TOOLS & SKILLS
Excel For BI Analysts - geni.us/lbia_excel
SQL For BI Analysts - geni.us/lbia_sql
Power BI For BI Analysts - geni.us/lbia_powerbi
Tableau For BI Analysts - geni.us/lbia_tableau
Looker Studio For BI Analysts - geni.us/lbia_lookerstudio
📊 DATA ANALYST PROJECTS
All Projects - geni.us/lbia_projects
Ben’s Pizzeria - geni.us/pizzaproject
Hotel Reservations - geni.us/hotelproject
Multi-Channel Marketing - geni.us/multichannelproject
Call Centre - geni.us/callcentreproject
🎥 RECOMMENDED VIEWING
7 Steps to Your 1st BI Analyst Job - geni.us/7stepstobivid
Learn Basic SQL in 15 Minutes - geni.us/learnbasicsql15-1
BI For Beginners Playlist - geni.us/biforbeginners-play
📕 FREE EBOOKS
7 Top Tips For Better Dashboard Design - geni.us/dashdes-ebook
Skills You Need To Succeed In BI - geni.us/biskills-ebook
7 Steps to Your 1st BI Job - geni.us/7stepstobi-ebook
📊 DATA HUBS & WEBSITES:
Power My Analytics - geni.us/YLc9Re
Windsor.ai - geni.us/windsorai
Kaggle - www.kaggle.com/
Statista - www.statista.com/
Data World - data.world/
DISCLAIMER: Some of the above links are affiliate links where I'll earn a small commission if you make a purchase using them, at no additional cost to you. It really helps support the channel so thanks in advance if you do use them 🙏
✅ LET'S CONNECT!
BUSINESS INQUIRIES - learnbi.online/contact
CONSULTING CALL WITH ADAM - geni.us/bookacall-adamfiner
JOIN MY MAILING LIST - geni.us/PSgRsF
FACEBOOK GROUP - geni.us/learnbi-fbg
#sqltutorial #sql #learnsql

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

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

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

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

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

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

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

[@mussen1876]

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

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

[@KB-uq9ti]

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

[@LearnBI]

You're welcome!

[@LucyAI666]

short and sweet just best video on sql thanks

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

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

[@lakshitakamboj198]

Perfect Perfect Perfect. Thank you

[@LearnBI]

You’re welcome!

[@ThePatrickFamilyBand]

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

[@LearnBI]

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

[@candacechavigne5560]

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

[@chadgraber4575]

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

[@LearnBI]

“The name’s SQL. MySQL” 😂

[@kamirasherman7956]

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

[@LearnBI]

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

[@print_the_code9156]

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

[@hirudikapremaratne2034]

Learned a lot. Thanks!

[@LearnBI]

You’re welcome!

[@amoso.adjaottor9181]

Great to be here I love the teachings ❤👍

[@LearnBI]

Welcome!

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

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

[@bondlavern]

This was fantastic!

[@LearnBI]

Thank you!

[@LuisNunez777]

Great videos Mate, thank you

[@LearnBI]

Glad you like them!

[@passportbro904]

just blown away, just thank you

[@LearnBI]

You’re welcome

[@disintegratev6951]

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

[@LearnBI]

Glad you like it!

[@ccvc87]

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

[@LearnBI]

Glad you like it!

[@catchme24I7]

Thank you for this content. Subbed:)!

[@LearnBI]

Thanks!

[@Thabo622]

thank you for making videos interesting and easy to follow

[@LearnBI]

Glad you like them!

[@lauraheilbrun5122]

So helpful, thank you!

[@LearnBI]

Glad it was helpful!

[@Ivan_J29]

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!

[@user-tt7nk4zp2s]

✨ You are a star

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

[@ryanking855]

agree with james bond decisions as well.

[@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 ☺️

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

[@islamifinanceurdu1435]

Underrated class

[@LearnBI]

Thank you

[@mbongenidube6661]

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

[@LearnBI]

You're so welcome!

[@sabuein]

Thank you. Very helpful.

[@LearnBI]

You're welcome!

[@IMXHUSTLAAA]

thank you you really helped

[@knowix1996]

That was great. Thank you.

[@LearnBI]

You’re welcome

[@captainsloth5895]

Amazing videos, helps a lot :)

[@LearnBI]

Thanks, glad to help!

[@yogalakshmi3356]

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

[@LearnBI]

Glad you liked it!

[@beebee3871]

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

[@LearnBI]

My pleasure!

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

[@yoni1991]

you are amazing. thank you

[@LearnBI]

Thank you too!

[@neutrinoBH]

Very nice video, Thanks.

[@LearnBI]

Thanks!

[@wvldent]

Excellent Presentation

[@LearnBI]

Thank you!

[@sonalisharma8340]

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

[@LearnBI]

That’s the plan!

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

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

[@pooppaul]

adam is the goat

[@chukwuemekamusic6635]

thank you

[@LearnBI]

You're welcome

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

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

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

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

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

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

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

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

[@WorkingClassDabrowa]

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

[@LearnBI]

Glad to hear that!

[@user-xl8mz3kh4b]

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

[@LearnBI]

Thank you, that’s kind of you 🙏🏻

[@stephencrawford8210]

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

[@LearnBI]

You could use Navicat or MySQL Workbench

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

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

[@matthewbryson6423]

Where do you find this Dataset?

[@LearnBI]

I made it myself

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

[@sphamandlandlovu3554]

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

[@LearnBI]

It can be both 😁

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

[@robwebber5657]

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

[@leothalion3983]

Just help me close out a B.A degree!

[@Islamrulzzz]

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

[@LearnBI]

Not as complicated as you might think

[@tiffanygray9]

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

[@LearnBI]

😂

[@trollplayz6483]

My SQL test is tomorrow loll

[@LearnBI]

Hope this helped!

[@trollplayz6483]

@@LearnBI it helped a lot!

[@hrist3820]

GOAT shit!!

[@user-pc5oe3rb7d]

⁹😊⁹90😊😊

[@samuelnjogu2004]

Manchester United can't even win in sql😢

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

[@Lailahiipek]

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