Published On Nov 16, 2020
SQL is a must if you want to be a Data Analyst or a Data Scientist. In this tutorial series I'll show you everything, you might need as a junior.
00:00 Intro
02:02 What is SQL? And why is it good?
04:17 What about Python, R and bash?
05:00 Access your SQL database via SQL Workbench
06:40 Get some data! (CREATE TABLE + INSERT)
08:36 The most important SQL statement: SELECT * FROM table_name
10:47 SELECT columns!
11:59 LIMIT
13:05 WHERE
14:38 about the SQL syntax requirements
16:52 WHERE + comparison operators
18:50 WHERE + LIKE
22:08 multiple conditions with WHERE (AND + OR)
25:49 SQL IN
27:19 SQL NOT
28:08 Conclusion
ARTICLE VERSION (RECOMMENDED):
1st half: https://data36.com/sql-for-data-analy...
2nd half: https://data36.com/sql-where-clause-t...
LINKS MENTIONED IN THE EPISODE:
SQL cheat sheet: https://data36.com/newsletter
Learn SQL (10+ tutorial articles) https://data36.com/learn-sql-for-data...
7-day SQL online course: https://data36.com/sql-for-aspiring-d...
SQL server setup video: • How to INSTALL PostgreSQL for learnin...
Newsletter: https://data36.com/newsletter
Free mini-course: https://data36.com/how-to-become-a-da...
NEXT EPISODE:
• SQL functions, GROUP BY, ORDER BY, DI...
----------------------------------
Check my website: https://data36.com
Get access to more data science tutorials, join the inner circle: https://data36.com/inner-circle
Find me on Twitter: / data36_com