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 a SQL query
- how to use SQL along with Python, R, Excel, etc.
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.