24  End Note

24.1 SQL Advantage

• Manage and query data efficiently
  • A universal tool to manage and query data efficiently
• Explore data in any platform
  • Work in your favourite programming environment
  • And work in many other not-so-favourite environments if needed: R, Python, SAS, Stata, Excel, SPSS
  • Data wrangling in an unknown environment
  • Learn once, use everywhere
• Work with an RDBMS server
  • Connect and get the data from popular RDBMS Server
  • Work on the data on the RDBMS server or from your favourite language platform
• Free and commercial options
  • Many open-source and free: SQLite, PostgreSQL, MariaDB, MySQL
  • Renown proprietary versions: Microsoft Access, Microsoft SQL Server, Microsoft Azure SQL, Oracle, Amazon Aurora -Connect and get data from the RDBMS Server
• Large-scale data
  • Work efficiently on large-scale datasets
  • Large-scale databases: Google’s BigQuery
• Engage with other professionals
  • Collaborate with IT and RDBMS professionals to understand large-scale data

24.2 Resources

• W3 Schools covers tutorial on SQL from basic to advanced level.

• Wikipedia has a comprehensive wikibook on SQL.

• SQL Tutorial has short and simple tutorials and other resources on SQL.

• LearSQL has articles, guides and other resources on SQL

• Khan Academy has a nice set of tutorials on basic SQL.

• And many more …