How I use SQL as a Data Analyst

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:

Build a Portfolio Online
==================================
Rebate Code: "LUKE"

Books for Data Nerds
==================================

Tech for Data Nerds
==================================

Social Media / Contact Me
======================

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

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

[jacknelson]

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.

[thelee]

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!

[Freeflier]

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.

[KenJee_ds]

That surprise at the end is AMAZING lol

[newenglandnomad]

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.

[dantarradellas]

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

[shresthaditya]

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

[Thuvu]

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 🤩

[michaelangello]

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

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

[ibrahimarif]

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

[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

[benjamin]

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

[olexandertverdohleb]

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.

[RESIDENTEVIL]

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.

[bigpp]

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

[seanmcgrady]

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.

[nikitakhd]

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

[casualrich-lifeiseasy]

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