How I use SQL as a Data Analyst

Ғылым және технология

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

Пікірлер: 870

  • @LukeBarousse
    @LukeBarousse2 жыл бұрын

    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?

  • @thomasroberts2663

    @thomasroberts2663

    2 жыл бұрын

    Python!

  • @viniciuso.4996

    @viniciuso.4996

    2 жыл бұрын

    Storytelling!!

  • @soburgbadejoko7634

    @soburgbadejoko7634

    2 жыл бұрын

    Tableau🙂

  • @shivifeb5

    @shivifeb5

    2 жыл бұрын

    Tableau

  • @TcRiverrat18

    @TcRiverrat18

    Жыл бұрын

    Python and any visualization tool!

  • @jacknelson7516
    @jacknelson75162 жыл бұрын

    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.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Aw thanks for noticing this Jack!! 🙌🏼🙌🏼

  • @hamzamehalli2825

    @hamzamehalli2825

    2 жыл бұрын

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

  • @Hellios92

    @Hellios92

    2 жыл бұрын

    @@hamzamehalli2825 You do need a basic understanding of maths, especially statistics, but not too much.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    @@hamzamehalli2825 I would agree with Ravioli on this one!

  • @Iose88

    @Iose88

    Жыл бұрын

    For me too, finally I understand what is data analyst doing and relationship between SQL and individual database. Thank you.

  • @thelee3105
    @thelee31052 жыл бұрын

    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!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Heck yeah!! Congratulations on landing the new role, this is so awesome to hear!! So glad the channel could help 🙌🏼

  • @newenglandnomad9405
    @newenglandnomad9405Ай бұрын

    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.

  • @dantarradellas7351
    @dantarradellas7351 Жыл бұрын

    Awesome! As an sql veteran, this was essential and a fantastic connectivity overview for ‘new’ tools. Thanks. 👍

  • @ibrahimarif3144
    @ibrahimarif3144 Жыл бұрын

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

  • @TonyFaustino
    @TonyFaustino2 жыл бұрын

    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!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    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

  • @608er
    @608er Жыл бұрын

    Luke, your videos are outstanding. They’re incredibly clear and still entertaining. Thank you for taking time to do these.

  • @Thuvu5
    @Thuvu52 жыл бұрын

    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 🤩

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    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 😂🤣

  • @Thuvu5

    @Thuvu5

    2 жыл бұрын

    @@LukeBarousse Hahaha very well. Be careful, next time I might add some secret code that would corrupt your subscriber database.. jk🤣

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    @@Thuvu5 you would never 😜😂

  • @nikitakhd7586
    @nikitakhd75862 жыл бұрын

    So simple and clear. Thank you so much! Haven’t found the KZreadr 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

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks for noticing this Nikita!! 🙌🏼 Glad to hear that this was helpful!!

  • @duythanhish
    @duythanhish2 жыл бұрын

    A very comprehensive introduction to data analysis. Thank you, Luke!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Heck yeah, thanks for this! 🙌🏼

  • @makeuplily
    @makeuplily Жыл бұрын

    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

  • @KenJee_ds
    @KenJee_ds2 жыл бұрын

    That surprise at the end is AMAZING lol

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    😂 I was a little nervous to show this TBH 🤣

  • @casualrich-lifeiseasy4921
    @casualrich-lifeiseasy49212 жыл бұрын

    randomly found this video, and was surprised. Your explanation on databases is so well-put and informative!

  • @Freeflier1978
    @Freeflier19782 жыл бұрын

    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.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    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!

  • @TinMaN01803

    @TinMaN01803

    2 жыл бұрын

    soooo how did it go?! You have the internet behind you waiting for an update!

  • @jbyanx

    @jbyanx

    2 жыл бұрын

    Wow congrats 👏 .

  • @christhesoftwareguy5672

    @christhesoftwareguy5672

    2 жыл бұрын

    I just got a job with NAVSEA as well in the DC area

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    @@christhesoftwareguy5672 Heck yeah; congrats on the new role!

  • @siranxie844
    @siranxie844 Жыл бұрын

    Such a nice and one of the most comprehensive explanations on how to start with SQL!

  • @RESIDENTEVIL1256
    @RESIDENTEVIL12562 жыл бұрын

    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.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    So glad this video was helpful in helping you understand that!

  • @BananaChan1010
    @BananaChan1010 Жыл бұрын

    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

  • @andreayomalan9528
    @andreayomalan9528 Жыл бұрын

    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!

  • @danhvokhanhtoan2984
    @danhvokhanhtoan2984 Жыл бұрын

    This is the most useful and simple SQL and DA workflow video I've found on the internet.

  • @stockmarcuslittle6359
    @stockmarcuslittle63596 ай бұрын

    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!

  • @LukeBarousse

    @LukeBarousse

    6 ай бұрын

    Thanks for sharing, and keep up the studies shipmate!

  • @RafaelGrigorian
    @RafaelGrigorian2 жыл бұрын

    This video was so on time! Just started learning more about SQL going through the Google Data Analytics course. Great content as always Luke!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Heck yeah, glad to supplement your Google Data Analytics learnings! Keep up the studies.

  • @tonepoet
    @tonepoet2 жыл бұрын

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

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Aw thanks so much for this! Good luck with the Certification, you got this!

  • @probico

    @probico

    2 жыл бұрын

    How much time the Google certificate will take to finish?

  • @tonepoet

    @tonepoet

    2 жыл бұрын

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

  • @5orrowonthevibe

    @5orrowonthevibe

    2 жыл бұрын

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

  • @benjamin4206
    @benjamin42062 жыл бұрын

    Yo! I can’t believe I made it into your vid. Thanks. Now I am a certified Data Nerd!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Heck yeah you did!! Always love reading your comments so had to throw ya in!! #DataNerd

  • @Amb3rjack
    @Amb3rjack Жыл бұрын

    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!

  • @shresthaditya2950
    @shresthaditya2950 Жыл бұрын

    0:50-Adhoc analysis 1:09-Descriptive Analysis 1:15-Diagonstic Analysis 1:45-Giving analysis to non technical people 7:45-SQL course

  • @MoeDavinci
    @MoeDavinci Жыл бұрын

    Great explanation of SQL and the impact it has in relation to other topics.

  • @michaelangello9209
    @michaelangello920910 ай бұрын

    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

  • @TableauTim
    @TableauTim2 жыл бұрын

    Love this video Luke thanks for sharing it !

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks Tableau Tim!! Love your videos BTW, I used them when I was learning Tableau!!

  • @yawmanuel9758
    @yawmanuel97582 жыл бұрын

    This video shows how deep you are in the data field Though a short video, but deep explained.

  • @hyggeasian
    @hyggeasian Жыл бұрын

    Man you are incredible, explaining with live examples 🙌🏻🙌🏻🙌🏻

  • @tanueiloyd6561

    @tanueiloyd6561

    Жыл бұрын

    Luke is indeed a Pro...

  • @hitheresa
    @hitheresa2 жыл бұрын

    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!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Aw you got this Theresa, keep up the hard work!

  • @LorisLiusso
    @LorisLiusso2 жыл бұрын

    Thank you so much Luke, all your content is pure gold! 🙏

  • @John-Walker
    @John-Walker2 жыл бұрын

    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

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Good to hear someone else's experience with DBeaver, thanks for sharing this John!

  • @ww2hungary827
    @ww2hungary827 Жыл бұрын

    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.

  • @kashifaliazim8367
    @kashifaliazim83673 ай бұрын

    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!

  • @stephanieloeffler4581
    @stephanieloeffler45812 жыл бұрын

    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!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Congrats on finishing up the SQL course! I think it's a great intro into this field 🙌🏼

  • @rem9486
    @rem94862 жыл бұрын

    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? 😁

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks, Rem!! And you may have read my mind about the Power BI 🤫

  • @brownbear8936
    @brownbear8936 Жыл бұрын

    The gifts from the subscribers were hilarious! had a blast. good to see, that data nerds have a decent sense of humor :D

  • @jlmoramora
    @jlmoramora11 ай бұрын

    Thank you man. I’m getting started in data analysis and this blazed the trail. 🙏🏻

  • @jessehenderson836
    @jessehenderson8362 жыл бұрын

    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.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Such a powerful tool and can be integrated so well with the other skills you already have. Glad this helped!!

  • @abdullahadwani422
    @abdullahadwani42223 күн бұрын

    The way you talk is so good 👍🏻it is so clear and doesn’t bored one off

  • @bigpp3397
    @bigpp33972 жыл бұрын

    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

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    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!

  • @probico

    @probico

    2 жыл бұрын

    I 2nd that

  • @mounikasomayajula8759
    @mounikasomayajula8759 Жыл бұрын

    Awsomeeee pretttyyy clearrr it was. i got so much clarity by you no one taught me these keypoints in my career

  • @lebrasia
    @lebrasia Жыл бұрын

    Trying to be more engaged in the KZread community 😊 GREAT video I was terrified of SQL until I watched this video. Grasped the concept perfectly. THANK YOU!

  • @Gutsberkman
    @Gutsberkman2 жыл бұрын

    That unboxing part was so awesome! Cheers to the guys who made this poster

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    🙌🏼 thank you!!And i'm blessed with some good friend and subscribers!

  • @rickdoesai4084
    @rickdoesai40842 жыл бұрын

    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 😅

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Ha! Thanks Rick. I also have a very mutual feeling for SQL 🤣

  • @neztorsmiths6328
    @neztorsmiths6328 Жыл бұрын

    As usual, clearing out my doubts. Thanks!

  • @StevenPham2310
    @StevenPham23107 ай бұрын

    Thank you for sharing! I’m starting my Data Analyst journey today. 🎉🎉🎉

  • @abdirazakmohamedibrahim2281
    @abdirazakmohamedibrahim2281 Жыл бұрын

    Thanks Luke, can't thank you enough for this video. Keep doing this.

  • @iamkv
    @iamkv2 жыл бұрын

    The kind of video I was looking for! Thank you Luke!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thank you, hope it helped ya out!

  • @ashleywitherspoon5487
    @ashleywitherspoon54872 жыл бұрын

    Thank you so much for this video! I always understand when you explain things. I hope you do a SQL course🙂

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Aw thanks for this! Let me see what I can do about a course for this!

  • @muhammadmannan8621
    @muhammadmannan86212 жыл бұрын

    This year I recently committed myself about going on a path to become a data analyst and finding this channel has done nothing but deepen and excite my desire to achieve that goal! The content you make is dope!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    My dude, thanks so much for this. This comment made my day!! Keep up the hard work 🙌🏼

  • @Applefanboy2012

    @Applefanboy2012

    Жыл бұрын

    How is it going?

  • @arcadevampire
    @arcadevampire2 жыл бұрын

    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!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

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

  • @michaelghabour5547
    @michaelghabour55472 жыл бұрын

    From all data analyst videos I ever seen while learning SQL… plus my love for data… that’s the best video I ever seen hands down

  • @michaelghabour5547

    @michaelghabour5547

    2 жыл бұрын

    Thank you

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Ha! Thank you for this, Michael!! 🙌🏼 Glad you enjoyed it!

  • @DaBaSoftware
    @DaBaSoftware2 жыл бұрын

    Thanks for the overviews, loved that suprise ending!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    😜 Glad you enjoyed it!

  • @kunalghosh8852
    @kunalghosh88522 жыл бұрын

    As usual, love your videos Luke! Great work!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Heck yeah! Thanks Kunal!

  • @shikharsaxena8984
    @shikharsaxena89842 жыл бұрын

    Very useful video Luke, thank you for making video on SQL 👏👏🙌😊

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Heck yeah! Glad you found it useful, Shikhar!!

  • @prathameshsawant5525
    @prathameshsawant55252 жыл бұрын

    Thanks for sharing this Luke. Very helpful 🔥🔥

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    So glad you enjoyed it Prathamesh!! 🙌🏼

  • @peternguynguyen5208
    @peternguynguyen52082 жыл бұрын

    Absolutely awesome! You have inspired me as I prefer using SQL to analyze and transform data for reporting over other tools

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Heck yeah, this is awesome Peter!

  • @PaulasPicks
    @PaulasPicks2 жыл бұрын

    Awesome explanation & overview of SQL and some of its real-life application, Luke, thanks! And who doesn't love an awesome surprise? ☺️

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Love me a good suprise ending!! Thanks for this Paula!!

  • @djender
    @djender Жыл бұрын

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

  • @LukeBarousse

    @LukeBarousse

    Жыл бұрын

    Heck yeah!

  • @joyprincessw.9415
    @joyprincessw.94152 жыл бұрын

    This video is done so well! The explanation is on point!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks so much for this!!

  • @alecestrada5799
    @alecestrada5799 Жыл бұрын

    Awesome explanation of RL use for SQL.

  • @Lavishlyashleyy
    @Lavishlyashleyy Жыл бұрын

    The joy this video brought me as an aspiring data analyst is indescribable! Thanks for explaining everything so well!

  • @LukeBarousse

    @LukeBarousse

    Жыл бұрын

    Aw hech yeah! Glad it was inspiring!

  • @FSANCHEZog
    @FSANCHEZog Жыл бұрын

    Great video clears all my questions

  • @louiem2
    @louiem2 Жыл бұрын

    Thanks for this highly informative and detailed upload

  • @MemeVibesCentral
    @MemeVibesCentral8 ай бұрын

    I'm love sql, I was learn through Google data analyst and try deeper in SQl for data science. My journey just started

  • @adriansantiagov5329
    @adriansantiagov53292 жыл бұрын

    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!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks so much for this Adrian!!

  • @tanueiloyd6561
    @tanueiloyd6561 Жыл бұрын

    Wow, this is awesome for a fresher like me and I will follow you always to learn more using SQL as a Data Analyst

  • @ranrosenhaus8414
    @ranrosenhaus8414 Жыл бұрын

    GREAT STUFF, LUKE YOU ARE A TRUE PROFESSIONAL

  • @LukeBarousse

    @LukeBarousse

    Жыл бұрын

    I appreciate it Ran!

  • @automanie
    @automanie2 жыл бұрын

    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 🙏😄👍

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks for this!! and also what great timing for this to drop!

  • @alexweaver3929
    @alexweaver39292 жыл бұрын

    Only 1/3 of the way through and I have already learned so much. Thank you.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Heck yeah! So glad you're getting value out of this one!

  • @rodrocdl
    @rodrocdl2 жыл бұрын

    Very interesting Luke! It was really puzzling for me how SQL works and how relevant it was to my job.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    I was just as confused when I started in data analytics, so you are not alone! Glad this was helpful!

  • @ttovar17
    @ttovar172 жыл бұрын

    What a great poster. Super cool! Love the ending. Ha. Thanks for the entertaining us along with providing useful info.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Ha, I love this poster! Thanks Tami!

  • @sunnygawande5283
    @sunnygawande52832 жыл бұрын

    I requested for this and you delivered 🤩

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Yeah you did! Thanks for the request, Sunny. I'm thinking about doing more videos like this on other tools.

  • @TuanSihan
    @TuanSihan2 жыл бұрын

    Great Video as always, Luke! ❤️

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks Tuan!! 💙

  • @olexandertverdohleb9874
    @olexandertverdohleb9874 Жыл бұрын

    Working as data analyst over the last five years in Dubai. Using SQL for the last 3 years. Regret that didn't start learning this tool before. It is so easy, universal and practical, that I applied it at almost every single project: CRM system, marker share calculation system, data warehouse, data orchestration, automatic import / export, calculation tools etc. I am using SQLite, Python, Excel and Power BI mostly. Ps. Thanks Luke for your channel. It helps me to structure my existing knowledge + inspirational for new ways of using it.

  • @LukeBarousse

    @LukeBarousse

    Жыл бұрын

    Heck yeah, glad this could help, Olexander; and thanks for sharing your experience with SQL!

  • @ldld7210

    @ldld7210

    Жыл бұрын

    How is the devOps & Cloud sector over in the Gulf?

  • @francescomacaluso7003
    @francescomacaluso70032 жыл бұрын

    Great channel! I love the way you explain complicated topics. I look forward to watching a video review with Qlik Sense

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Let me see what I can do about this topic of Qlik Sense, thanks for the recommendation!

  • @bansalsaurabh7
    @bansalsaurabh7 Жыл бұрын

    Finally, finally someone explained me SQL form basics and its uses.

  • @Seftehandle
    @Seftehandle Жыл бұрын

    Thanks a lot for this video I am completing the capstone project currently, the rest of the specialization I have finished! I am very thankful for this recommendation. Looking for one for Python next :)

  • @DaltonPietersen
    @DaltonPietersen Жыл бұрын

    This was brilliant thanks so much.

  • @damariusmcnair8906
    @damariusmcnair89068 ай бұрын

    best explanation of the use of SQL. You rock brother!

  • @tombachdev618
    @tombachdev6182 жыл бұрын

    This is the best "Data Analyst job in a nutshell" video I have ever seen! Luke is the boss!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    That's interesting, I didn't really see this as that type of video, but know that I reflect on it... it kind of is 🤣 Thanks for the kind words!! 🙌🏼

  • @laloak47po
    @laloak47po2 жыл бұрын

    This was awesome!

  • @paradise2324
    @paradise23242 жыл бұрын

    This is the best explanation that I've come across.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Aw thanks for this!

  • @SirPoopyPants
    @SirPoopyPants8 ай бұрын

    Dave and Alex - EPIC!!!!!!!!!!!!

  • @AnaPaulaKendall
    @AnaPaulaKendall8 ай бұрын

    Great video, thank you!

  • @candycandy4357
    @candycandy435710 ай бұрын

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

  • @foodathomeph4421
    @foodathomeph44212 жыл бұрын

    Wow! Nice work towards the end!!😀😀😀😀

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks for staying until the end!!

  • @seanmcgrady8688
    @seanmcgrady86882 жыл бұрын

    Initially, I thought I'd try for a data scientist role, but after encountering your video and channel, it seems like working as a data analyst, developing my skills & experience to level up sounds like the best plan for me. I've about finished the Dataquest plan for Data Analyst. Afterward, I'm going to work through a solid Excel project & Power BI or Tableau project. I'm nearly at the application stage, and I've got 20+ projects in Python, and ~3 in SQL. I just need to make something decorative, and I'm applying! I discovered your channel late in my development, but it has been invaluable in helping me reach its end. Thank you.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Hey Sean! I think you made the right choice (obviously I'm biased) BUT I truly do believe its a great role to start in this field and dive right in! Good luck with your projects, you seem like you are on a great path!

  • @seanmcgrady8688

    @seanmcgrady8688

    2 жыл бұрын

    @@LukeBarousse Thanks, Luke. It means more than you know.

  • @GermanoMacedoVieira
    @GermanoMacedoVieira2 жыл бұрын

    Great content Luke, as always!!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks Germano!!

  • @ClaudioBOsorio
    @ClaudioBOsorio2 жыл бұрын

    Nice to see your channel is growing fast. It would be nice to have some hands on mini projects, Q&A, live discussions as well, maybe in a second channel while posting the summaries in this one.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks for this Claudio!! 🙌🏼 I do want to get into more projects and Q&A's as I think the community wants it... I need to investigate this second channel idea, so thanks for this!

  • @nathankwendo4634
    @nathankwendo46342 жыл бұрын

    Wonderful insights, thanks a lot Luke.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    My pleasure, Nathan!

  • @tinovimbachitate8992
    @tinovimbachitate8992 Жыл бұрын

    Solid overview of SQL👌 Saw myself subscribing before the video even ended. Great content...

  • @LukeBarousse

    @LukeBarousse

    Жыл бұрын

    🙌🏼

  • @asiasowa
    @asiasowa2 жыл бұрын

    Wow, great content! Very clear and concise!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks for noticing this Joanna!! 🙌🏼

  • @gogokostadinov
    @gogokostadinov Жыл бұрын

    That guy is born to teach, super easy to understand

  • @ekinuyar
    @ekinuyar2 жыл бұрын

    Amazingly informative video. Thank you!!

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Thanks Ekin!!

  • @bigyadav
    @bigyadav Жыл бұрын

    Amazing creative work sir ❤

  • @viniciuso.4996
    @viniciuso.49962 жыл бұрын

    Amazing video!!! Thank you for sharing your experience.

  • @LukeBarousse

    @LukeBarousse

    2 жыл бұрын

    Aw thanks for this Vinicius!

Келесі