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.
George Mount is the founder and CEO of Stringfest Analytics, a consulting firm specializing in analytics education and upskilling. He has worked with leading bootcamps, learning platforms, and practice organizations to help individuals excel at analytics. George regularly blogs and speaks on data analysis, data education, and workforce development.
George holds a bachelor’s degree in economics from Hillsdale College and a master’s degree in finance and information systems from Case Western Reserve University. He resides in Cleveland, Ohio.