Editing Advanced Computational Communication Methods (Summer 2023) (section)

== SQL ==
Muqing Liu

Introduction to SQL:
General introduction to SQL https://www.khanacademy.org/computing/computer-programming/sql
Relational model and the foundation of SQL https://dl.acm.org/doi/10.1145/362384.362685
Principles and rules for relational database management systems https://www.dcs.warwick.ac.uk/~hugh/TTM/

Textbook Guidance to write SQL:
"The complete idiot's guide to SQL" Steven Holzner This is a beginner-friendly guide introduces SQL concepts and commands.  https://www.amazon.com/Complete-Idiots-Guide-SQL/dp/1615641092
"SQL and Relational Theory: How to write accurate SQL code" C.J. Date 
This book provides a comprehensive guide to understand SQL and relational theory https://www.amazon.com/SQL-Relational-Theory-Write-Accurate/dp/1449316409
"SQL pocket guide" Jonathan Gennick 
This book is a handy reference for SQL syntax and command https://www.amazon.com/SQL-Pocket-Guide-Usage/dp/1449394094

Online courses:
SQL for beginners https://www.udemy.com/course/sql-for-beginners/
This beginner-friendly course covers database design, querying with SQL, data manipulation, and database management. 
SQL essential training  https://www.linkedin.com/learning/sql-essential-training/
This course covers basic SQL commands and querying techniques. 
The complete SQL bootcamp  https://www.udemy.com/course/the-complete-sql-bootcamp/
This course covers both SQL fundamentals and advanced concepts. It also includes real-world projects and hands-on exercises. 
SQL for data science https://www.coursera.org/learn/sql-for-data-science
This course is designed for data science professionals to use SQL for data manipulation and analysis. It covers SQL queries, joins, and aggregations for data science tasks. 
Advanced SQL for query tuning  https://www.pluralsight.com/courses/advanced-sql-query-tuning
This course is for intermediate to advanced SQL users looking to optimize their SQL queries and improve database performance. 


SQL tutorial videos:
MySQL tutorial for beginners https://www.youtube.com/watch?v=7S_tz1z_5bA
SQL Tutorial - Full Database Course for Beginners： https://www.youtube.com/watch?v=HXV3zeQKqGY
SQL Advanced Tutorial|Advanced SQL Tutorial With Examples https: //www.youtube.com/watch?v=M-55BmjOuXY

The use of SQL in data science: 
A Comparative Analysis on different aspects of Database Management System https://www.researchgate.net/publication/352178674_A_Comparative_Analysis_on_different_aspects_of_Database_Management_System
This paper compared different database management system for handling big data storage and processing tasks. 
Twitter Sentiment Analysis Approaches: A Survey https://www.learntechlib.org/p/217980/
Analysis of Healthcare Data using SQL https://www.linkedin.com/pulse/analysis-healthcare-data-using-sql-kristopher-bosch/
SQL for Stock Market Analysis https://medium.datadriveninvestor.com/sql-for-stock-market-analysis-f2145031e125