SQL Tutorial for Beginners | Future of Data & AI | Data Science Dojo
Are you starting your journey in data science? Then you're probably already familiar with SQL, Python, and R for data analysis and machine learning. However, in real-world data science jobs, data is typically stored in a database and accessed through either a business intelligence tool or SQL. If you're new to SQL, this beginner-friendly tutorial is for you! By the end of this session, you'll learn the basics, including:
The definition of a database and the difference between SQL and NoSQL.
How to inspect a database's data model to understand its structure.
How to write SQL queries to find data in a database.
By the end of this tutorial, you'll have a strong foundation in SQL and be ready to tackle more advanced data science concepts.
About the Speaker:
Alice Zhao is a data scientist who is passionate about teaching and making complex things easy to understand. She is the author of SQL Pocket Guide, 4th Edition (O’Reilly), and has taught numerous courses in SQL, Python, and R as a senior data scientist at Metis and as a co-founder of Best Fit Analytics.
Table of Contents:
00:00 – Introduction
01:27 – Agenda of the talk
01:50 – Basics
10:00 – Example database
14:00 – SQL coding basics
24:42 – Practice coding
28:45 – Free resources for SQL
29:25 – SQL demo
35:30 – SQL crash course: One pager
Hello everyone, you can find all the remaining tutorials here: • Future of Data and AI: Tutorials
--
At Data Science Dojo, we believe data science is for everyone. Our data science trainings have been attended by more than 10,000 employees from over 2,500 companies globally, including many leaders in tech like Microsoft, Google, and Facebook. For more information please visit: https://hubs.la/Q01Z-13k0
💼 Learn to build LLM-powered apps in just 40 hours with our Large Language Models bootcamp: https://hubs.la/Q01ZZGL-0
💼 Get started in the world of data with our top-rated data science bootcamp: https://hubs.la/Q01ZZDpt0
💼 Master Python for data science, analytics, machine learning, and data engineering: https://hubs.la/Q01ZZD-s0
💼 Explore, analyze, and visualize your data with Power BI desktop: https://hubs.la/Q01ZZF8B0
--
Unleash your data science potential for FREE! Dive into our tutorials, events & courses today!
📚 Learn the essentials of data science and analytics with our data science tutorials: https://hubs.la/Q01ZZJJK0
📚 Stay ahead of the curve with the latest data science content, subscribe to our newsletter now: https://hubs.la/Q01ZZBy10
📚 Connect with other data scientists and AI professionals at our community events: https://hubs.la/Q01ZZLd80
📚 Checkout our free data science courses: https://hubs.la/Q01ZZMcm0
📚 Get your daily dose of data science with our trending blogs: https://hubs.la/Q01ZZMWl0
--
📱 Social media links
Connect with us: / data-science-dojo
Follow us: / datasciencedojo
Keep up with us: / data_science_dojo
Like us: / datasciencedojo
Find us: https://www.threads.net/@data_science...
--
Also, join our communities:
LinkedIn: / 13601597
Twitter: / 1677363761399865344
Facebook: / aiandmachinelearningforeveryone
Vimeo: https://vimeo.com/datasciencedojo
Discord: / discord
_
Want to share your data science knowledge? Boost your profile and share your knowledge with our community: https://hubs.la/Q01ZZNCn0
#sql #programming #datascience #futureofdataandai
