About this session
When learning data science, students typically focus on SQL, 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 session 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.
Speakers
Alice ZhaoData Scientist and Author at O'Reilly
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.
Explore more sessions from the Future of Data & AI conference
Watch panel discussions, tutorials, and talks from industry leaders.