How I use SQL as a Data Analyst
HTML-код
- Опубликовано: 9 июн 2024
- SQL for Data Science 👉🏼 lukeb.co/SQLdataScience
Coursera Plus (7-day free trial) 👉🏼 lukeb.co/CourseraPlus
Data Nerds!! Let's discuss how SQL is used in Data Science. For this, I cover the basics of how to use SQL; Additionally, we talk about popular database options (MySQL, PostgreSQL, SQLite, SQL Server, Oracle) and editors to use (VS Code, DBeaver, Access).
Certificates & Courses
==================================
Coursera Courses:
📜 Google Data Analytics Certificate (START HERE) 👉🏼 lukeb.co/GoogleCert
💿 SQL for Data Science 👉🏼 lukeb.co/SQLdataScience
🧾 Excel Skills for Business 👉🏼 lukeb.co/ExcelBusinessAnalyst
🐍 Python for Everybody 👉🏼 lukeb.co/PythonForEverybody
📊 Data Visualization with Tableau 👉🏼 lukeb.co/Tableau_UCDavis
🏴☠️ Data Science: Foundations using R 👉🏼 lukeb.co/RforDataScienceJH
Coursera Plus Subscription (Monthly $59USD) 👉🏼 lukeb.co/CourseraMonthly
Coursera Plus Subscription (Annual $399USD) 👉🏼 lukeb.co/CourseraYearly
👨🏼🏫 All courses 👉🏼 kit.co/lukebarousse/data-anal...
Build a Portfolio Online
==================================
👩🏻💻Build portfolio here 👉🏼 hostinger.com/luke
Rebate Code: "LUKE"
My Portfolio 👉🏼 lukebarousse.tech/
Books for Data Nerds
==================================
📚 Books I’ve read 👉🏼 kit.co/lukebarousse/book-reco...
📗 Data Science Must Read 👉🏼 geni.us/StorytellingWithData
📙 Tableau 👉🏼 geni.us/tableau
📘 Power BI👉🏼 geni.us/powerbi
📕 Python 👉🏼 geni.us/pythontricks
Tech for Data Nerds
==================================
⚙️ Tech I use 👉🏼 kit.co/lukebarousse/computer-...
🪟Windows on a Mac (Parallels VM) 👉🏼 lukeb.co/ParallelsFreeTrial
👨🏼💻 M1 Macbook Air (Mac of choice) 👉🏼 geni.us/M1macAir8GB
💻 Dell XPS 13 (PC of choice) 👉🏼 geni.us/DellNewXPS13
💻 Asus Vivo Book (Lowest Cost PC) 👉🏼 geni.us/AsusVivoBook15
💻Lenovo IdeaPad (Best Value PC)👉🏼 geni.us/LenovoIdeaPad15
Social Media / Contact Me
======================
🙋🏼♂️Newsletter: www.lukebarousse.com/
🌄 Instagram: / lukebarousse
⏰ TikTok: / lukebarousse
📘 Facebook: / datavizbyluke
📥 Business Inquiries: luke@lukebarousse.com
00:00 Intro
00:44 Types of analysis w/ SQL
02:34 What is SQL?
03:14 How to query w/ SQL?
05:25 What database to use?
06:12 NoSQL vs SQL
07:09 SQL Course Recommendation
08:16 Where to keep database?
09:27 Cloud database options
10:14 SQL editors
11: 57 How I use SQL!
14:16 Suprise ending
As a member of the Amazon, Coursera, Hostinger, Parallels, and Interview Query Affiliate Programs, I earn a commission from qualifying purchases on the links above. It costs you nothing but helps me with content creation.
#datanerd #dataanalyst #datascience 
Наука
Data Nerds!! I'm thinking about starting a video series on: "How I use ________ as a Data Analyst"
🛠 What tools/skills would you want me to make videos on?
Python!
Storytelling!!
Tableau🙂
Tableau
Python and any visualization tool!
This was one of the most comprehensive explanations of how to start with SQL I have seen yet! Great channel mate and love the content.
Aw thanks for noticing this Jack!! 🙌🏼🙌🏼
@@LukeBarousse I'm very bad at mathematical, i'm wondering if its possible for me to became a data analyst? even with my low level in math?
@@hamzamehalli2825 You do need a basic understanding of maths, especially statistics, but not too much.
@@hamzamehalli2825 I would agree with Ravioli on this one!
For me too, finally I understand what is data analyst doing and relationship between SQL and individual database. Thank you.
I recently graduated and was happy I was able to get a job working with data. So much exposure with SQL makes me so happy because this is my foundation of experience towards furthering my career. Your channel helped me!
Heck yeah!! Congratulations on landing the new role, this is so awesome to hear!! So glad the channel could help 🙌🏼
OMFG, been studying sql for a while. This video is the first one to get to the damn point with a real work work query question. I'm so tired of fake example queries and practice tests.
That surprise at the end is AMAZING lol
😂 I was a little nervous to show this TBH 🤣
Luke, your videos are outstanding. They’re incredibly clear and still entertaining. Thank you for taking time to do these.
Awesome! As an sql veteran, this was essential and a fantastic connectivity overview for ‘new’ tools. Thanks. 👍
Had my 1st interview with a NAVSEA contractor that is modernizing data analytics programs. SQL and viz were all we talked about. He stressed it's more important to under SQL and viz fundamentals, and the rest will come with time and training. 2nd interview is next week. The 20 years of ship maintenance availabilites and navigating NAVSEA while active duty finally paid off. The domain experience is 100% why they called me 1 day after submitting my resume.
Congrats on passing the 1st interview!! good to hear they are using the core tools for the job!!
Good luck on round 2, you got this!
soooo how did it go?! You have the internet behind you waiting for an update!
Wow congrats 👏 .
I just got a job with NAVSEA as well in the DC area
@@christhesoftwareguy5672 Heck yeah; congrats on the new role!
This is the best video I have ever seen on SQL. I'm a complete beginner and this has given me the direction I need to start my journey! More like this!!!!
Thank you, this was so helpful for beginners like me. I learned so much! Great engaging editing as well, I cant wait to check out the rest of your videos as well
Luke, thank YOU for the inspiration and teaching you provide to your subscribers/students with every video you publish! I'm currently finishing Course 6 in the Google Data Analytics Certification (aka The Tableau Data Visualization section). I started DataCamp's SQL Fundamentals Track about two weeks ago for two reasons: (1) I didn't want to lose the SQL knowledge I worked hard to learn in Courses 3-5. (2) Every reason you described in your amazing video. I have a family relative who is a data scientist, and he reinforced the importance of SQL skills in a data science career. 90% of the real, daily, and unglorified work of a data science professional is the processing, the cleaning, and the preparation of the data in SQL BEFORE analysis (whether it's in R, Power BI, or Python). The 10% sexy stuff is the analysis (aka the stuff most people want to talk and brag about). Thank you for presenting in your work what's real and for keeping it real. All the best to you in 2022 and Keep Doing What You're Doing!
You are so right about the 90/10 rule... the unglorified work is definetly in the cleaning and SQL is so important for this. Interesting to hear your using another course to supplement your SQL knowledge while also pursuing the Google Data Analytics Certificate!! Too cool! I love me some datacamp as well, so I think you made a good choice!!
Thanks again for the kind words
So simple and clear. Thank you so much! Haven’t found the RUclipsr who can break down things in such an easy-to-understand way! Really well done for that! Examples and boss-employee scenes really help too
Thanks for noticing this Nikita!! 🙌🏼 Glad to hear that this was helpful!!
Woah.. such an awesome video Luke!! It's easily the best introduction to SQL and databases for data analysts! I thought I knew some SQL but really learned a lot from your explanation and enjoyed it. Thank you for querying my name, that's so sweet 🤩
Aw thanks so much for this and I've learned a lot from your videos as well!!
BTW,now that you commented, I gotta go update my database... again 😂🤣
@@LukeBarousse Hahaha very well. Be careful, next time I might add some secret code that would corrupt your subscriber database.. jk🤣
@@Thuvu5 you would never 😜😂
Such a nice and one of the most comprehensive explanations on how to start with SQL!
randomly found this video, and was surprised. Your explanation on databases is so well-put and informative!
This video was so on time! Just started learning more about SQL going through the Google Data Analytics course. Great content as always Luke!
Heck yeah, glad to supplement your Google Data Analytics learnings! Keep up the studies.
Wow... I came in for a brief overview on SQL and I got much more. Thank you a bunch for sharing Coursera! I was able to find additional free courses that will be beneficial in my career advancement. Blessings to you Luke
This is the most useful and simple SQL and DA workflow video I've found on the internet.
Hi Luke, thank you for such a wonderfully informative channel on data analytics.
I'm looking to transition from nursing to data analytics, and I'm finding it to be very resourceful on what steps I need to take going forward!
Aw you got this Theresa, keep up the hard work!
Super timely as always, Luke. Into the SQL portion of the Google Data Analytics certification and a bit perplexed at the formatting. I get the importance, but it's French (so far) to me. Your videos are really pulling me through this and I can't thank you enough for these!!!!!
Aw thanks so much for this! Good luck with the Certification, you got this!
How much time the Google certificate will take to finish?
@@probico From what I've heard, it's normally a 6 month course, but you can finish it much quicker. There are 8 modules (with the capstone project). I'm at the beginning of module 4 and I started at the end of November, so I've done 3 modules in 2 months. The 6 months spreads the learning out pretty well and makes it very comfortable and manageable.
@@probico The course intro says it's around 6 months, but you can actually do it mush faster. From my personal experience, the time wasn't a problem but to truly understand the concepts in every single chapter.
0:50-Adhoc analysis
1:09-Descriptive Analysis
1:15-Diagonstic Analysis
1:45-Giving analysis to non technical people
7:45-SQL course
Great explanation of SQL and the impact it has in relation to other topics.
Awsomeeee pretttyyy clearrr it was. i got so much clarity by you no one taught me these keypoints in my career
I have been on my Data journey for a few years now and I have a decent grasp of all the skills independently. This video, especially the last portion truly helped me get an idea of how I would orchestrate these skills to fulfill actual job roles.
So glad this video was helpful in helping you understand that!
The way you talk is so good 👍🏻it is so clear and doesn’t bored one off
Thank you so much Luke, all your content is pure gold! 🙏
A very comprehensive introduction to data analysis. Thank you, Luke!
Heck yeah, thanks for this! 🙌🏼
Thank you man. I’m getting started in data analysis and this blazed the trail. 🙏🏻
Man you are incredible, explaining with live examples 🙌🏻🙌🏻🙌🏻
Luke is indeed a Pro...
Awesome as expected Luke! Got me inspired to learn SQL this weekend!
Would it be possible to get a PowerBI tutorial from you as well Luke? 😁
Thanks, Rem!! And you may have read my mind about the Power BI 🤫
Great video clears all my questions
This video shows how deep you are in the data field
Though a short video, but deep explained.
You don't know how much this video helped me. There was too much useless theory in the class that I took and I was stressed sbout how I was gonna use it in the workplace but this gave me a clearer path for my researches. Thank you!
Thank you for sharing! I’m starting my Data Analyst journey today. 🎉🎉🎉
Excellent! I got an awful lot out of this video as I am just dipping my toes in the water with SQL and Python - this video kind of put everything into perspective for me. Superb!
Thank you for your service! I was an Avionics Tech in the Marine Corps, spent a lot of time around sailors. I have been studying SQL for an upcoming business intelligence position for my employer. Your videos have been awesome! Keep it up!
Thanks for sharing, and keep up the studies shipmate!
Dude, your video was spot on! Best video I've seen for data analyst beginers. Helped me a lot. Very clear and simple explanation. Subscribing!!
Heck yeah!
Detailed in depth without 'big words' for a beginner. I just started SQL, thanks for informing me why I need to immerse myself in it
Thanks Luke! I've finished the SQL course on the Google analytics certificate and I'm looking to develop my skills. I'll be checking out more of your videos!
Congrats on finishing up the SQL course! I think it's a great intro into this field 🙌🏼
I have watched so many videos so many lectures but the way you explain all those things it's just wow!! I am glad you are my mentor
Thank you Sir
A lot of respect from Pakistan!
The kind of video I was looking for! Thank you Luke!
Thank you, hope it helped ya out!
Yo! I can’t believe I made it into your vid. Thanks. Now I am a certified Data Nerd!
Heck yeah you did!! Always love reading your comments so had to throw ya in!! #DataNerd
Very useful video Luke, thank you for making video on SQL 👏👏🙌😊
Heck yeah! Glad you found it useful, Shikhar!!
That unboxing part was so awesome! Cheers to the guys who made this poster
🙌🏼 thank you!!And i'm blessed with some good friend and subscribers!
Love this video Luke thanks for sharing it !
Thanks Tableau Tim!! Love your videos BTW, I used them when I was learning Tableau!!
As usual, clearing out my doubts. Thanks!
Thank you so much for this video! I always understand when you explain things. I hope you do a SQL course🙂
Aw thanks for this! Let me see what I can do about a course for this!
Thanks for the overviews, loved that suprise ending!
😜 Glad you enjoyed it!
Thanks Luke, can't thank you enough for this video. Keep doing this.
Incredible content, you have an ease explaining these topics which reflects your knowledge, and I thank you for sharing that knowledge, have a great day!
Thanks so much for this Adrian!!
Thanks for this highly informative and detailed upload
Trying to be more engaged in the RUclips community 😊 GREAT video I was terrified of SQL until I watched this video. Grasped the concept perfectly. THANK YOU!
A beautiful video, I have subscribed Luke. I just finished a degree in data analysis and this brought back the joys of me first understanding the power behind SQL and my dislike for using MS Access.
This video is done so well! The explanation is on point!
Thanks so much for this!!
Thanks for sharing this Luke.
Very helpful 🔥🔥
So glad you enjoyed it Prathamesh!! 🙌🏼
Awesome explanation of RL use for SQL.
As usual, love your videos Luke! Great work!
Heck yeah! Thanks Kunal!
What a great poster. Super cool! Love the ending. Ha. Thanks for the entertaining us along with providing useful info.
Ha, I love this poster! Thanks Tami!
Wasn't expecting this much information, this is really thorough Luke!:)
I have a love hate relationship with SQL but you managed to make me watch the whole thing 😅
Ha! Thanks Rick. I also have a very mutual feeling for SQL 🤣
THIS IS IT! That's what I needed to see to understand what a data analyst does. I would love to see going through a project that's asked and how do you solve it (mayde a description of the meeting with manager too). If someone has a video in mind I would love to watch it
This comment means a lot!! Thanks so much for this and so glad this video could help!
Let me see what I can do about the project video, there seems to be a lot of curiosity on this topic so stay tuned!
I 2nd that
This was brilliant thanks so much.
Great channel! I love the way you explain complicated topics. I look forward to watching a video review with Qlik Sense
Let me see what I can do about this topic of Qlik Sense, thanks for the recommendation!
Wow, this is awesome for a fresher like me and I will follow you always to learn more using SQL as a Data Analyst
GREAT STUFF, LUKE YOU ARE A TRUE PROFESSIONAL
I appreciate it Ran!
This is the best explanation that I've come across.
Aw thanks for this!
Wow! Nice work towards the end!!😀😀😀😀
Thanks for staying until the end!!
Hi Luke, first time notice your channel. Thx for your sharing. How nice if I could download your knowledge instantly...
Pls share more so that we can continue to learned from you...
🙏
I requested for this and you delivered 🤩
Yeah you did! Thanks for the request, Sunny. I'm thinking about doing more videos like this on other tools.
Wow, great content! Very clear and concise!
Thanks for noticing this Joanna!! 🙌🏼
I have learned a lot from you
Thanks a million
Solid overview of SQL👌
Saw myself subscribing before the video even ended.
Great content...
🙌🏼
Great Video, very informative... however that painting / poster at the end is just so epic! Looks great !
I was a little worried about sharing this at the end, but glad you liked it, my friends did a great job with it! 🤣
Thanks for the video, this was helpful. Great quality! Wow @ the gift lolz
best explanation of the use of SQL. You rock brother!
Great video, thank you!
Very interesting Luke! It was really puzzling for me how SQL works and how relevant it was to my job.
I was just as confused when I started in data analytics, so you are not alone! Glad this was helpful!
Great content Luke, as always!!
Thanks Germano!!
Only 1/3 of the way through and I have already learned so much. Thank you.
Heck yeah! So glad you're getting value out of this one!
Wonderful insights, thanks a lot Luke.
My pleasure, Nathan!
Awesome explanation & overview of SQL and some of its real-life application, Luke, thanks!
And who doesn't love an awesome surprise? ☺️
Love me a good suprise ending!! Thanks for this Paula!!
Absolutely awesome! You have inspired me as I prefer using SQL to analyze and transform data for reporting over other tools
Heck yeah, this is awesome Peter!
Love DBeaver! Been using it for 6 months on a work project and have now moved to using it on personal projects. It is such a powerful tool for writing SQL
Recently started using Python for SQL templating with Pandas and JinjaSQL
Good to hear someone else's experience with DBeaver, thanks for sharing this John!
Great Video as always, Luke! ❤️
Thanks Tuan!! 💙
Amazingly informative video. Thank you!!
Thanks Ekin!!
The gifts from the subscribers were hilarious! had a blast. good to see, that data nerds have a decent sense of humor :D
Another great video. For my new job interview I need prepare some tasks in SQL and I solve the tools for that. Great timing. Thanks 🙏😄👍
Thanks for this!! and also what great timing for this to drop!
The joy this video brought me as an aspiring data analyst is indescribable! Thanks for explaining everything so well!
Aw hech yeah! Glad it was inspiring!
This was awesome!
This is great! I’ve recently started learning SQL and I have plenty of experience in tableau, R, python, and ArcGIS. Your explanation of how SQL interfaces with other software was way helpful. This’ll help me a lot going forward with how powerful I’m realizing SQL is.
Such a powerful tool and can be integrated so well with the other skills you already have. Glad this helped!!
Now this is what I love to watch thanks budd much appreciated 🙏
Glad you enjoyed it
Excellent video! Very comprehensive, and so much more than just about sql. Everyone getting into analytics should watch this first as a primer, to get a holistic view of the analytic process. I especially liked the boss section with different types of queries. When online learning you don't get a sense of the type requests in a real world business context. A bloke in a suit to kick you up the backside always works lol!
🤣😂 My boss is always on my back about the data they want. 😂
Also I didn't actually think anyone would care to hear about me and my boss's interaction so this is interesting to hear!
That guy is born to teach, super easy to understand
Your videos are awesome!
Amazing creative work sir ❤
Amazing video!!! Thank you for sharing your experience.
Aw thanks for this Vinicius!
Finally, finally someone explained me SQL form basics and its uses.
perfect timing, thank you so much!!
No problem at all, Alejandro!
Thank s for videos, you make analytics more interesting .....
Thank you for this! I'm trying too!
Great video. I'm actually going through that Coursera specialization right now. I love it.
Heck yeah, this is great to hear and good luck in finishing it up!
Great content.Very well explained.Yes see you in the next one💯
Heck yeah! More to come!