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