SQL Crash Course for Beginners

When learning data science, students typically focus on Python or R for data analysis and machine learning.

In the real world, data is usually stored in databases, and that data is best used by directly using SQL against the database..

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.

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.

Frank

#DataScientist, #DataEngineer, Blogger, Vlogger, Podcaster at http://DataDriven.tv . Back @Microsoft to help customers leverage #AI Opinions mine. #武當派 fan. I blog to help you become a better data scientist/ML engineer Opinions are mine. All mine.