How I use SQL as a Data Analyst

[@LukeBarousse]

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]

Python!

[@viniciuso.4996]

Storytelling!!

[@soburgbadejoko7634]

Tableau🙂

[@shivifeb5]

Tableau

[@TcRiverrat18]

Python and any visualization tool!

[@jacknelson7516]

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]

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

[@hamzamehalli2825]

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

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

[@LukeBarousse]

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

[@Iose88]

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

[@thelee3105]

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]

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

[@Thuvu5]

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]

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]

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

[@LukeBarousse]

@@Thuvu5 you would never 😜😂

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

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]

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

[@Freeflier1978]

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]

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]

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

[@jbyanx]

Wow congrats 👏 .

[@christhesoftwareguy5672]

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

[@LukeBarousse]

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

[@KenJee_ds]

That surprise at the end is AMAZING lol

[@LukeBarousse]

😂 I was a little nervous to show this TBH 🤣

[@dantarradellas7351]

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

[@stockmarcuslittle6359]

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]

Thanks for sharing, and keep up the studies shipmate!

[@pedroelton7040]

2:49, S-Q-L is the right way, come on! hahaha Great Video Luke!

[@LukeBarousse]

😜

[@benjamin4206]

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

[@LukeBarousse]

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

[@melvin6228]

Starting my job soon, relearned SQL, already know Python/Jupyter, don't know a powerBI tool. This gave me a good understanding of how these things are used. Thanks!

[@michaelangello9209]

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

[@bigpp3397]

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]

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]

I 2nd that

[@seanmcgrady8688]

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]

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]

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

[@RESIDENTEVIL1256]

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]

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

[@tonepoet]

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]

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

[@probico]

How much time the Google certificate will take to finish?

[@tonepoet]

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

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

[@michaelghabour5547]

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]

Thank you

[@LukeBarousse]

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

[@brownbear8936]

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

[@kashifaliazim8367]

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!

[@nikitakhd7586]

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

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

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

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

[@ldld7210]

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

[@Gutsberkman]

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

[@LukeBarousse]

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

[@JAndersonThe2nd]

Thank you so much. Im curently taking the Google Data Analytics Professional Certificate and this video answered a lot of questions i was curois about. And the way you visualized this video is great, I had to leave a like and comment.

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

[@mounikasomayajula8759]

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

[@danhvokhanhtoan2984]

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

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

[@casualrich-lifeiseasy4921]

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

[@lucidviolin1298]

Finally a video that touched on the real-life situation of a data analyst job. no other video showed such a simple benefit within a video... now to binge your other videos jhah

[@LukeBarousse]

😜

[@yawmanuel9758]

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

[@siranxie844]

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

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

[@RafaelGrigorian]

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]

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

[@stephanieloeffler4581]

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]

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

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

[@abdullahadwani422]

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

[@tombachdev618]

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

[@LukeBarousse]

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

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

[@rem9486]

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]

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

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

Heck yeah!

[@John-Walker]

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]

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

[@MemeVibesCentral]

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

[@608er]

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

[@gogokostadinov]

That guy is born to teach, super easy to understand

[@jlmoramora]

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

[@eduardodeluna8245]

This is some amazing content! I'm just done learning SQL's essentials but couldn't really see the value of learning it, it is much more clear now!

[@LukeBarousse]

Glad this was helpful for you Eduardo!!

[@hyggeasian]

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

[@tanueiloyd6561]

Luke is indeed a Pro...

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

[@bansalsaurabh7]

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

[@balazsgrunsperger2459]

Great Video, very informative... however that painting / poster at the end is just so epic! Looks great !

[@LukeBarousse]

I was a little worried about sharing this at the end, but glad you liked it, my friends did a great job with it! 🤣

[@TableauTim]

Love this video Luke thanks for sharing it !

[@LukeBarousse]

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

[@muhammadmannan8621]

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]

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

[@Applefanboy2012]

How is it going?

[@tinovimbachitate8992]

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

[@LukeBarousse]

🙌🏼

[@rickdoesai4084]

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]

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

[@duythanhish]

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

[@LukeBarousse]

Heck yeah, thanks for this! 🙌🏼

[@bassemtrad3824]

normally I don't comment on videos, but I'm amazed by the way you show data and tech, amazing man, really amazing

[@LukeBarousse]

thank you for this! And glad you commented it helps!

[@ttovar17]

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

[@LukeBarousse]

Ha, I love this poster! Thanks Tami!

[@TexasGunDude]

I started as a Business Analyst last year. Currently, I'm cranking out self-service analytics in Tableau. I'm about to start the SQL specialization from the University of Michigan on Coursera. I've taken a lot of Python training, but, haven't used it professionally yet. Wish I would have started with SQL before Python.

[@LukeBarousse]

I did a similar thing to you in learning Python before SQL. It's not that big of a deal in my opinion and I think you will still be fine. Good luck with the studies the PostgreSQL for EVerybody is a great course!

[@automanie]

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]

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

[@StevenPham2310]

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

[@sunnygawande5283]

I requested for this and you delivered 🤩

[@LukeBarousse]

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

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

[@shikharsaxena8984]

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

[@LukeBarousse]

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

[@MoeDavinci]

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

[@arcadevampire]

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]

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

[@paradise2324]

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

[@LukeBarousse]

Aw thanks for this!

[@candycandy4357]

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

[@peternguynguyen5208]

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

[@LukeBarousse]

Heck yeah, this is awesome Peter!

[@hitheresa]

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]

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

[@ranrosenhaus8414]

GREAT STUFF, LUKE YOU ARE A TRUE PROFESSIONAL

[@LukeBarousse]

I appreciate it Ran!

[@rishabhsahu6102]

love this video I'm early in my data career and was wondering what are the practical use of sql, python and excel in the real world

[@damariusmcnair8906]

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

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

[@justinsmithing]

Perfect info. Well presented. Thank you!

[@DaBaSoftware]

Thanks for the overviews, loved that suprise ending!

[@LukeBarousse]

😜 Glad you enjoyed it!

[@katherinecaro8820]

Thank you so much! Here is a data nerd starting the data analysis path :) and your videos have helped me a lot.

[@LukeBarousse]

No problem at all Katherine!! You got this! 🙌🏼

[@lifeseasy3924]

Hey I have learnt so much from this video. Thanks a lot!

[@Lavishlyashleyy]

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

[@LukeBarousse]

Aw hech yeah! Glad it was inspiring!

[@chacmool2581]

A neat trick is that you can query an SQL database from within R or Python onto a dataframe with the RODBC and SQLite packages, respectively.

[@syhusada1130]

but that still need SQL syntax

[@chacmool2581]

@@syhusada1130 Yes. Of course! How else would one query SQL databases if not with SQL?

[@LukeBarousse]

Heck yeah, I also like doing this with Pandas in Python!!

[@kendra850]

I love connecting to SQL via vscode. I find vscode to work better then R. If I have an error, then vscode well tell me the rewrite whereas R just says error without feedback

[@LukeBarousse]

@@kendra850 the joys (and pains of R)

[@ashleywitherspoon5487]

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

[@LukeBarousse]

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

[@alexweaver3929]

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

[@LukeBarousse]

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

[@jessehenderson836]

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]

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

[@FatimaFarhan-p7c]

can you upload a tutorial on how to use vscode for different databases ,especially like PostgreSQL or mysql

[@alberttu8120]

It opens the requirements for some basic data warehousing processes. While SQL Server (or any db) isn't data warehousing proper infastructure, projects or org that don't have large data requirements can use the DB as a place for processed historical data. Knowing and using SQL for this purpose will bring alot of value and elevate you as a data analyst.

[@waleedbensumaidea3947]

at 11:05 I recently installed the extension of sql in VScode, But when I run the query the result shows in new tab at the left sid of the screen. How can I let result show in the down like here 11:05

[@adriansantiagov5329]

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]

Thanks so much for this Adrian!!

[@ruwindarowel8200]

I just started getting into the learning curve of becoming a data analyst and your videos have been super helpful❤❤❤❤❤❤❤❤

[@LukeBarousse]

I'm so glad they've been helpful!

[@iamkv]

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

[@LukeBarousse]

Thank you, hope it helped ya out!

[@leslielebrasia]

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

[@youssefahmed6383]

On time video 👌 Brilliant Luke ♥️

[@LukeBarousse]

Thanks for this Youssef!!

[@sumitapathak2900]

Now this is my favourite data science channel

[@LukeBarousse]

Glad you like it!! 🙌🏼

[@AlekseySergeychuk]

This is the best video about SeQuel, I've ever seen! Thank you Luke! With love from Russia)

[@LukeBarousse]

Heck yeah, glad it helped ya! Love from 🇺🇸! 🤙🏼

[@alecestrada5799]

Awesome explanation of RL use for SQL.

[@arjunrajeshirke9933]

Luke can you please make a video on which one is most popular and in demand in terms of usage, functionality and market capitalisation today ? 1. Database or snowflake data warehouse ?? 2. Python or R? 3. Tableau or Power BI?

[@RJM95]

Thanks for this video-it is very helpful for a basic understanding of SQL. I currently work as a budget analyst and frequently use MS Excel. I’m interested in learning SQL to further develop my skills in data analysis. 🤘

[@neztorsmiths6328]

As usual, clearing out my doubts. Thanks!

[@abdirazakmohamedibrahim2281]

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

[@prathameshsawant5525]

Thanks for sharing this Luke. Very helpful 🔥🔥

[@LukeBarousse]

So glad you enjoyed it Prathamesh!! 🙌🏼