Тёмный

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

Adam Finer - Learn BI Online
Подписаться 95 тыс.
Просмотров 177 тыс.
50% 1

🚨 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

Опубликовано:

 

5 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 168   
@LearnBI
@LearnBI 2 месяца назад
🚨 WANT MORE? GET MY FULL SQL COURSE HERE: geni.us/lbia_sql
@ilhanbayramoglu2811
@ilhanbayramoglu2811 2 года назад
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
@LearnBI 2 года назад
Glad you liked it!
@hrushikeshkulkarni7353
@hrushikeshkulkarni7353 2 года назад
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
@LearnBI 2 года назад
You’re welcome, glad you like it.
@anitamurphy2323
@anitamurphy2323 Год назад
You are rude
@hrushikeshkulkarni7353
@hrushikeshkulkarni7353 Год назад
@@anitamurphy2323 how can an SQL video be rude 😅
@davidmartini7764
@davidmartini7764 5 месяцев назад
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.
@jackriebel2406
@jackriebel2406 2 года назад
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
@LearnBI 2 года назад
Thanks very much for your positive feedback, it's much appreciated!
@TinyKideo
@TinyKideo 2 года назад
Very True, and I think this channel is underrated ...
@mussen1876
@mussen1876 Год назад
Thanks Adam. I’m new to SQL and these videos are very helpful and are paced well.
@equiwave80
@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!!!
@ricardorodriguez7803
@ricardorodriguez7803 2 года назад
Such a good video, so much knowledge compressed perfectly into 16 minutes. keep them coming!!
@LearnBI
@LearnBI 2 года назад
Thanks for the feedback. Part 3 coming early 2022.
@candacechavigne5560
@candacechavigne5560 5 месяцев назад
Thank you so much; these make is really digestible when you're just learning a new program.
@irinamicov
@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
@LearnBI Год назад
Glad you enjoyed it!
@omarino99
@omarino99 2 года назад
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
@LearnBI 2 года назад
Wow, thank you!
@kamirasherman7956
@kamirasherman7956 11 месяцев назад
Thank you for making this plain. You are appreciated 👍🏾
@LearnBI
@LearnBI 11 месяцев назад
You’re welcome!
@chadgraber4575
@chadgraber4575 Год назад
As a massive Bond fan, using that table as an example was a pleasant surprise.
@LearnBI
@LearnBI Год назад
“The name’s SQL. MySQL” 😂
@bintangdilangit3348
@bintangdilangit3348 2 года назад
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
@LearnBI 2 года назад
Glad you think so!
@ThePatrickFamilyBand
@ThePatrickFamilyBand Год назад
This was actually a legit software/coding video. Thanks for breaking down the SQL rudiments.
@LearnBI
@LearnBI Год назад
You’re welcome
@LucyAI666
@LucyAI666 7 месяцев назад
short and sweet just best video on sql thanks
@ccvc87
@ccvc87 Год назад
I like your content, well structured and straight to the point.
@LearnBI
@LearnBI Год назад
Glad you like it!
@BryantJohnsonsimbalion45
@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
@LearnBI Год назад
You're very welcome! Happy new year to you too
@vinodhvalleri6595
@vinodhvalleri6595 2 года назад
Hey ur the unique and primarkey in which explains in SQL u are the best ❤️❤️❤️
@LearnBI
@LearnBI 2 года назад
Thanks ☺️
@KB-uq9ti
@KB-uq9ti 2 года назад
Thank you for this!!! I’m brand spanking new and this makes sense
@LearnBI
@LearnBI 2 года назад
You're welcome!
@carl-christianmalm863
@carl-christianmalm863 Год назад
Thanks for the great content!! Very easy to understand and follow and much appreciated for a late bloomer in SQL :)
@LearnBI
@LearnBI Год назад
You’re welcome!
@hirudikapremaratne2034
@hirudikapremaratne2034 2 года назад
Learned a lot. Thanks!
@LearnBI
@LearnBI 2 года назад
You’re welcome!
@clinkelc
@clinkelc 2 года назад
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
@LearnBI 2 года назад
You're welcome, I'm glad you like the videos
@lakshitakamboj198
@lakshitakamboj198 2 года назад
Perfect Perfect Perfect. Thank you
@LearnBI
@LearnBI 2 года назад
You’re welcome!
@NavneetKaur-pr2pq
@NavneetKaur-pr2pq 9 месяцев назад
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
@LearnBI 9 месяцев назад
Thank you, glad you found the videos helpful
@amoso.adjaottor9181
@amoso.adjaottor9181 Год назад
Great to be here I love the teachings ❤👍
@LearnBI
@LearnBI Год назад
Welcome!
@annisaautami
@annisaautami 18 дней назад
thank you for this amazing concise video! been enjoying the first part too
@LearnBI
@LearnBI 18 дней назад
My pleasure
@print_the_code9156
@print_the_code9156 Год назад
This is the very best way to create a database . 👍👍👍👍👍
@disintegratev6951
@disintegratev6951 Год назад
The fact that this is free is actually mind blowing, this is amazing
@LearnBI
@LearnBI Год назад
Glad you like it!
@mbongenidube6661
@mbongenidube6661 7 месяцев назад
wow - you're amazing - I am learning so much and immediately applying this at work. Thank you
@LearnBI
@LearnBI 7 месяцев назад
You're so welcome!
@bondlavern
@bondlavern 2 года назад
This was fantastic!
@LearnBI
@LearnBI 2 года назад
Thank you!
@beebee3871
@beebee3871 Месяц назад
Binging your videos to prepare for a job interview.... thank you SO MUCH for high quality content!!! 💛💛💛
@LearnBI
@LearnBI Месяц назад
My pleasure!
@lauraheilbrun5122
@lauraheilbrun5122 Год назад
So helpful, thank you!
@LearnBI
@LearnBI Год назад
Glad it was helpful!
@Thabo622
@Thabo622 2 года назад
thank you for making videos interesting and easy to follow
@LearnBI
@LearnBI 2 года назад
Glad you like them!
@passportbro904
@passportbro904 2 месяца назад
just blown away, just thank you
@LearnBI
@LearnBI 2 месяца назад
You’re welcome
@FCMGA
@FCMGA Год назад
what a life savior thank you good sir.
@LearnBI
@LearnBI Год назад
You’re welcome
@subreezi
@subreezi 2 года назад
Thank you for this content. Subbed:)!
@LearnBI
@LearnBI 2 года назад
Thanks!
@LuisNunez777
@LuisNunez777 2 года назад
Great videos Mate, thank you
@LearnBI
@LearnBI 2 года назад
Glad you like them!
@sabuein
@sabuein 2 года назад
Thank you. Very helpful.
@LearnBI
@LearnBI 2 года назад
You're welcome!
@konulaslan
@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
@LearnBI Год назад
You're very welcome!
@Ivan_J29
@Ivan_J29 11 месяцев назад
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
@LearnBI 11 месяцев назад
Glad you’re enjoying them!
@serdip
@serdip Год назад
Amazing video series! Thank you so much for sharing your knowledge. SQL = Super Quick Learning or Something Quickly Learned 😎
@LearnBI
@LearnBI Год назад
Glad you enjoyed it!
@HalleluyahJJang
@HalleluyahJJang 2 года назад
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
@LearnBI 2 года назад
You’re welcome, glad they helped
@sohailiqbalsiddiqui1954
@sohailiqbalsiddiqui1954 Год назад
Any update on your career change?
@HalleluyahJJang
@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
@sohailiqbalsiddiqui1954 Год назад
@@HalleluyahJJang All the best 🙌
@newera8388
@newera8388 Год назад
@@HalleluyahJJang keep going🤝🏾
@knowix1996
@knowix1996 Год назад
That was great. Thank you.
@LearnBI
@LearnBI Год назад
You’re welcome
@ryanking855
@ryanking855 2 года назад
agree with james bond decisions as well.
@yogalakshmi3356
@yogalakshmi3356 2 года назад
it's great!! I loved it. To the point and crisp
@LearnBI
@LearnBI 2 года назад
Glad you liked it!
@islamifinanceurdu1435
@islamifinanceurdu1435 2 года назад
Underrated class
@LearnBI
@LearnBI 2 года назад
Thank you
@IMXHUSTLAAA
@IMXHUSTLAAA 3 месяца назад
thank you you really helped
@captainsloth5895
@captainsloth5895 2 года назад
Amazing videos, helps a lot :)
@LearnBI
@LearnBI 2 года назад
Thanks, glad to help!
@user-tt7nk4zp2s
@user-tt7nk4zp2s 5 месяцев назад
✨ You are a star
@wvldent
@wvldent 2 года назад
Excellent Presentation
@LearnBI
@LearnBI 2 года назад
Thank you!
@yoni1991
@yoni1991 2 года назад
you are amazing. thank you
@LearnBI
@LearnBI 2 года назад
Thank you too!
@LearnBI
@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
@shanaldoable
@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
@LearnBI Год назад
You're very welcome!
@sonalisharma8340
@sonalisharma8340 Год назад
hii,please make more videos.your way of teaching is so easy.
@LearnBI
@LearnBI Год назад
That’s the plan!
@neutrinoBH
@neutrinoBH 2 года назад
Very nice video, Thanks.
@LearnBI
@LearnBI 2 года назад
Thanks!
@gb342002
@gb342002 7 месяцев назад
Getting my BI career training started with these videos. Great content Adam!
@LearnBI
@LearnBI 7 месяцев назад
Thanks! Glad it's helpful
@gb342002
@gb342002 7 месяцев назад
How do I do that?
@LearnBI
@LearnBI 7 месяцев назад
@@gb342002 *glad
@gb342002
@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!
@chukwuemekamusic6635
@chukwuemekamusic6635 Год назад
thank you
@LearnBI
@LearnBI Год назад
You're welcome
@youssefrizk5905
@youssefrizk5905 2 года назад
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
@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.
@aiasaiascon3894
@aiasaiascon3894 2 года назад
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
@LearnBI 2 года назад
I know! Woody Allen as a Bond villain, it’s a bit ridiculous. But then the film is pretty ridiculous 🤣
@hxsouv
@hxsouv Год назад
This was very informative. Thank you! Do you have cheat sheets for part 1 and 2 of basic SQL?
@LearnBI
@LearnBI Год назад
Glad you liked it. Sorry, no cheat sheet for those parts.
@dezc55555
@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
@LearnBI Год назад
Hi Dez. Not sure I understand the use case. Copy from where? Or do you mean INSERT? If so, the tutorial explains this.
@pooppaul
@pooppaul 8 месяцев назад
adam is the goat
@ElodieSarel
@ElodieSarel 2 месяца назад
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
@LearnBI Месяц назад
Yes, with the right tool. You would still need to check that all the fields have been assigned the correct data type.
@ccostanz22
@ccostanz22 2 года назад
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
@LearnBI 2 года назад
Just answered this question on your other comment ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kbKty5ZVKMY.html&lc=UgyYAvDnoObOU7xkeHl4AaABAg
@ccostanz22
@ccostanz22 2 года назад
@@LearnBI thanks much, will look into it this weekend.
@jimmysjohns2466
@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
@LearnBI Год назад
Not currently, sorry
@newssir5790
@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)
@WorkingClassDabrowa
@WorkingClassDabrowa 2 года назад
That's better explained in English than in my native language elsewhere. Thank you.
@LearnBI
@LearnBI 2 года назад
Glad to hear that!
@user-xl8mz3kh4b
@user-xl8mz3kh4b 3 месяца назад
If there's a heaven, there is a special place for you in it
@LearnBI
@LearnBI 3 месяца назад
Thank you, that’s kind of you 🙏🏻
@SYNC4646
@SYNC4646 10 месяцев назад
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
@LearnBI 10 месяцев назад
Yes, that is indeed very fun!
@LM-ch8rh
@LM-ch8rh Год назад
hi. does anyone have a suggestion for an alternative to Navicat that's free?
@LearnBI
@LearnBI Год назад
MySQL Workbench
@LM-ch8rh
@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
@richieforrest5611
@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
@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.
@stephencrawford8210
@stephencrawford8210 8 месяцев назад
How do I know what software to use for writing this SQL code?
@LearnBI
@LearnBI 8 месяцев назад
You could use Navicat or MySQL Workbench
@matthewbryson6423
@matthewbryson6423 2 года назад
Where do you find this Dataset?
@LearnBI
@LearnBI 2 года назад
I made it myself
@leothalion3983
@leothalion3983 2 года назад
Just help me close out a B.A degree!
@sphamandlandlovu3554
@sphamandlandlovu3554 2 года назад
I just want to know. Is this coding, programming or both?
@LearnBI
@LearnBI 2 года назад
It can be both 😁
@robwebber5657
@robwebber5657 2 года назад
am I the only one who cannot unsee "The Spay Who Loved Me"?
@Islamrulzzz
@Islamrulzzz 11 месяцев назад
I am taking data analytics course,and SQL seems so complicated…😮
@LearnBI
@LearnBI 11 месяцев назад
Not as complicated as you might think
@tiffanygray9
@tiffanygray9 2 года назад
I disagree because I personally LOVE Woody Allen because I confused him with Woody Boyd from cheers and zombie land lol 😂
@LearnBI
@LearnBI 2 года назад
😂
@hrist3820
@hrist3820 8 месяцев назад
GOAT shit!!
@trollplayz6483
@trollplayz6483 2 года назад
My SQL test is tomorrow loll
@LearnBI
@LearnBI 2 года назад
Hope this helped!
@trollplayz6483
@trollplayz6483 2 года назад
@@LearnBI it helped a lot!
@user-pc5oe3rb7d
@user-pc5oe3rb7d 8 месяцев назад
⁹😊⁹90😊😊
@samuelnjogu2004
@samuelnjogu2004 7 месяцев назад
Manchester United can't even win in sql😢
@helpanimals-
@helpanimals- 2 года назад
How the hell am I supposed to remember all this? commas, dots, brackets...jesus
@LearnBI
@LearnBI 2 года назад
It’s called “learning” 😉
@itsyourboyyy
@itsyourboyyy 5 месяцев назад
It's too much content for a beginner
@LearnBI
@LearnBI 5 месяцев назад
The good thing about video is that you can watch it over and over.
@aiasaiascon3894
@aiasaiascon3894 2 года назад
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
@LearnBI 2 года назад
Thank you for your kind words 🙏
@Lailahiipek
@Lailahiipek 29 дней назад
If you were my teacher in highschool, I'd be in much better place now
Далее