5 Ways SQL Is Used in the Data Industry #shorts #data #sql #datascientist #dataanalyst

codebasics · Intermediate ·📊 Data Analytics & Business Intelligence ·1y ago

Key Takeaways

The video discusses five ways SQL is utilized in the data industry, including ad hoc analysis, report generation, EDA machine learning, BI tools, and ETL/data migration, using tools such as relational databases, SQL store procedures, Jupyter notebooks, PowerBI, and Tableau.

Full Transcript

There are five ways SQL is used in the data industry. Number one is ad hoc analysis. As a data analyst, you might write ad hoc SQL queries on your relational database to get insights on your data. Number two is report generation. Your business manager can come to you and ask to generate a report for slicing and dicing data. For this purpose, you might write SQL store procedure. Number three is EDA machine learning. As a data scientist, when you're building a machine learning model, you need to pull the data in your Jupyter notebook. And often this data is in SQL database. You'll be writing SQL query for that. Fourth one is inside BI tools. When you're plugging your data source to PowerBI or Tableau, you will write SQL query to filter or transform data. The last one is ETL and data migration. Data engineers use SQL to perform ETL and data transformation in their pipeline.
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Playlist

Uploads from codebasics · codebasics · 0 of 60

← Previous Next →
1 Python Tutorial - 1. Install python on windows
Python Tutorial - 1. Install python on windows
codebasics
 2 Python Tutorial - 2. Variables
Python Tutorial - 2. Variables
codebasics
 3 Python Tutorial - 3. Numbers
Python Tutorial - 3. Numbers
codebasics
 4 Python Tutorial - 4. Strings
Python Tutorial - 4. Strings
codebasics
 5 Python Tutorial - 5. Lists
Python Tutorial - 5. Lists
codebasics
 6 Python Tutorial - 6. Install PyCharm on Windows
Python Tutorial - 6. Install PyCharm on Windows
codebasics
 7 PyCharm Tutorial - 7. Debug python code using PyCharm
PyCharm Tutorial - 7. Debug python code using PyCharm
codebasics
 8 Python Tutorial - 8. If Statement
Python Tutorial - 8. If Statement
codebasics
 9 Python Tutorial - 9. For loop
Python Tutorial - 9. For loop
codebasics
 10 Python Tutorial - 10. Functions
Python Tutorial - 10. Functions
codebasics
 11 Python Tutorial - 11. Dictionaries and Tuples
Python Tutorial - 11. Dictionaries and Tuples
codebasics
 12 Python Tutorial - 12. Modules
Python Tutorial - 12. Modules
codebasics
 13 Python Tutorial - 13. Reading/Writing Files
Python Tutorial - 13. Reading/Writing Files
codebasics
 14 How to install Julia on Windows
How to install Julia on Windows
codebasics
 15 Python Tutorial - 14. Working With JSON
Python Tutorial - 14. Working With JSON
codebasics
 16 Julia Tutorial - 1. Variables
Julia Tutorial - 1. Variables
codebasics
 17 Julia Tutorial - 2. Numbers
Julia Tutorial - 2. Numbers
codebasics
 18 Python Tutorial - 15. if __name__ == "__main__"
Python Tutorial - 15. if __name__ == "__main__"
codebasics
 19 Julia Tutorial - Why Should I Learn Julia Programming Language
Julia Tutorial - Why Should I Learn Julia Programming Language
codebasics
 20 Python Tutorial - 16. Exception Handling
Python Tutorial - 16. Exception Handling
codebasics
 21 Julia Tutorial - 3. Complex and Rational Numbers
Julia Tutorial - 3. Complex and Rational Numbers
codebasics
 22 Julia Tutorial - 4. Strings
Julia Tutorial - 4. Strings
codebasics
 23 Python Tutorial - 17. Class and Objects
Python Tutorial - 17. Class and Objects
codebasics
 24 Julia Tutorial - 5. Functions
Julia Tutorial - 5. Functions
codebasics
 25 Julia Tutorial - 6. If Statement and Ternary Operator
Julia Tutorial - 6. If Statement and Ternary Operator
codebasics
 26 Julia Tutorial - 7. For While Loop
Julia Tutorial - 7. For While Loop
codebasics
 27 Python Tutorial - 18. Inheritance
Python Tutorial - 18. Inheritance
codebasics
 28 Julia Tutorial - 8. begin and (;) Compound Expressions
Julia Tutorial - 8. begin and (;) Compound Expressions
codebasics
 29 Python Tutorial - 12.1 - Install Python Module (using pip)
Python Tutorial - 12.1 - Install Python Module (using pip)
codebasics
 30 Julia Tutorial - 9. Tasks (a.k.a. Generators or Coroutines)
Julia Tutorial - 9. Tasks (a.k.a. Generators or Coroutines)
codebasics
 31 Julia Tutorial - 10. Exception Handling
Julia Tutorial - 10. Exception Handling
codebasics
 32 Python Tutorial - 19. Multiple Inheritance
Python Tutorial - 19. Multiple Inheritance
codebasics
 33 Python Tutorial - 20. Raise Exception And Finally
Python Tutorial - 20. Raise Exception And Finally
codebasics
 34 Python Tutorial - 21. Iterators
Python Tutorial - 21. Iterators
codebasics
 35 Python Tutorial - 22. Generators
Python Tutorial - 22. Generators
codebasics
 36 Python Tutorial - 23. List Set Dict Comprehensions
Python Tutorial - 23. List Set Dict Comprehensions
codebasics
 37 Python Tutorial - 24. Sets and Frozen Sets
Python Tutorial - 24. Sets and Frozen Sets
codebasics
 38 Python Tutorial - 25. Command line argument processing using argparse
Python Tutorial - 25. Command line argument processing using argparse
codebasics
 39 Debugging Tips - What is bug and debugging?
Debugging Tips - What is bug and debugging?
codebasics
 40 Debugging Tips - Conditional Breakpoint
Debugging Tips - Conditional Breakpoint
codebasics
 41 Debugging Tips - Watches and Call Stack
Debugging Tips - Watches and Call Stack
codebasics
 42 Python Tutorial - 26. Multithreading - Introduction
Python Tutorial - 26. Multithreading - Introduction
codebasics
 43 Git Tutorial 3: How To Install Git
Git Tutorial 3: How To Install Git
codebasics
 44 Git Tutorial 1: What is git / What is version control system?
Git Tutorial 1: What is git / What is version control system?
codebasics
 45 Git Tutorial 2 : What is Github? | github tutorial
Git Tutorial 2 : What is Github? | github tutorial
codebasics
 46 Git Tutorial 4: Basic Commands: add, commit, push
Git Tutorial 4: Basic Commands: add, commit, push
codebasics
 47 Git Tutorial 5: Undoing/Reverting/Resetting code changes
Git Tutorial 5: Undoing/Reverting/Resetting code changes
codebasics
 48 Git Tutorial 6: Branches (Create, Merge, Delete a branch)
Git Tutorial 6: Branches (Create, Merge, Delete a branch)
codebasics
 49 Git Github Tutorial 10: What is Pull Request?
Git Github Tutorial 10: What is Pull Request?
codebasics
 50 Git Tutorial 7: What is HEAD?
Git Tutorial 7: What is HEAD?
codebasics
 51 Git Tutorial 9: Diff and Merge using meld
Git Tutorial 9: Diff and Merge using meld
codebasics
 52 Difference between Multiprocessing and Multithreading
Difference between Multiprocessing and Multithreading
codebasics
 53 Python Tutorial - 27. Multiprocessing Introduction
Python Tutorial - 27. Multiprocessing Introduction
codebasics
 54 Python Tutorial - 28. Sharing Data Between Processes Using Array and Value
Python Tutorial - 28. Sharing Data Between Processes Using Array and Value
codebasics
 55 Git Tutorial 8 - .gitignore file
Git Tutorial 8 - .gitignore file
codebasics
 56 Python Tutorial - 29. Sharing Data Between Processes Using Multiprocessing Queue
Python Tutorial - 29. Sharing Data Between Processes Using Multiprocessing Queue
codebasics
 57 Python Tutorial - 30. Multiprocessing Lock
Python Tutorial - 30. Multiprocessing Lock
codebasics
 58 Python Tutorial - 31. Multiprocessing Pool (Map Reduce)
Python Tutorial - 31. Multiprocessing Pool (Map Reduce)
codebasics
 59 What is code?
What is code?
codebasics
 60 Python unit testing - pytest introduction
Python unit testing - pytest introduction
codebasics

This video teaches viewers about the various ways SQL is used in the data industry, from ad hoc analysis to ETL and data migration, and highlights the importance of SQL skills for data analysts, scientists, and engineers. By watching this video, viewers will gain a deeper understanding of the role of SQL in data analysis and machine learning. The video also provides examples of how SQL is used in different tools and technologies, such as Jupyter notebooks, PowerBI, and Tableau.

Key Takeaways
  1. Write ad hoc SQL queries to analyze data
  2. Create SQL store procedures to generate reports
  3. Use SQL to pull data from relational databases for machine learning models
  4. Write SQL queries to filter and transform data in BI tools
  5. Perform ETL and data migration using SQL
  6. Connect to data sources in PowerBI or Tableau using SQL
  7. Create reports and dashboards using BI tools
💡 SQL is a fundamental skill for data professionals, and its applications go beyond just data analysis to include machine learning, report generation, and data migration.

Related Reads

📰
Dari Membuat Program Pendeteksi Hujan Sampai Hak Cipta: Apa yang Saya Pelajari Tentang Data &…
Learn how a student's project on building a rain detection program led to insights on data and intellectual property rights
Medium · Programming
 📰
How to Query Databricks from Salesforce Apex (Without Copying a Billion Rows)
Learn how to query Databricks from Salesforce Apex without copying large datasets, enabling efficient data retrieval and analysis
Dev.to · Md Mohiuddin
 📰
Can a Data Science Course Really Change Your Career in 2026?-IABAC
Discover how a data science course can transform your career in 2026 and what skills you need to acquire for a successful transition
Medium · Data Science
 📰
How to Add and Manage Excel Slicers in Python: A Practical Guide
Learn to add and manage Excel slicers in Python for automated reporting and dashboard creation
Medium · Python
Up next
How to Prompt Your LLM Directly from SQL
Ian Wootten
Watch →