SQL Tutorial for Beginners | SQL Crash Course смотреть онлайн

When learning data science, students typically focus on Python or R for data analysis and machine learning. On the job though, data is usually stored in a database, and that data can either be accessed through a business intelligence tool or directly using SQL.

This crash course is intended for beginners with no prior experience in SQL. By the end of the session, you will know:
- What a database is and the difference between SQL and NoSQL
- What an RDBMS is and the difference between MySQL, Oracle, PostgreSQL, SQL Server, and SQLite
- How to see what’s in a database by looking at a data model
- How to find data in a database by writing an SQL query
- How to use SQL along with Python, R, Excel, etc.

About the Presenter:
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. She writes about analytics and pop culture on her blog, A Dash of Data. Her work has been featured in Huffington Post, Thrillist, and Working Mother. She has her MS in analytics and BS in electrical engineering, both from Northwestern University.

Table of Contents:
0:00 – Introduction
2:38 – Data
4:25 – Checkpoint
4:47 – SQL
5:42 – SQL database
8:39 – SQL summary
9:49 – NoSQL summary
11:44 – SQL basics summary
12:53 – Current situation
16:02 – Database summary
19:30 – SQL coding basics
23:36 – SQL Query
33:08 – Where can I write SQL code?
49:05 – QnA

Looking for more crash courses? Check out our playlist: https://www.youtube.com/playlist?list=PL8eNk_zTBST9SJS5gUw_HYGSk5MdyC89-

--

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: https://www.linkedin.com/company/data-science-dojo

Follow us: https://twitter.com/DataScienceDojo

Keep up with us: https://www.instagram.com/data_science_dojo/

Like us: https://www.facebook.com/datasciencedojo

Find us: https://www.threads.net/@data_science_dojo

--

Also, join our communities:

LinkedIn: https://www.linkedin.com/groups/13601597/

Twitter: https://twitter.com/i/communities/1677363761399865344

Facebook: https://www.facebook.com/groups/AIandMachineLearningforEveryone/

Vimeo: https://vimeo.com/datasciencedojo

Discord: https://discord.com/invite/tj8ken4Err

_

Want to share your data science knowledge? Boost your profile and share your knowledge with our community: https://hubs.la/Q01ZZNCn0

#sql #datascience #dataanalytics