Editing Advanced Computational Communication Methods (Summer 2023)

From CommunityData

Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.

The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then publish the changes below to finish undoing the edit.

Latest revision Your text
Line 524: Line 524:
Muqing Liu
Muqing Liu


Introduction to SQL:
An overall introduction to SQL:
General introduction to SQL https://www.khanacademy.org/computing/computer-programming/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:
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 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
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


== Command line ==
== Command line ==
Please note that all contributions to CommunityData are considered to be released under the Attribution-Share Alike 3.0 Unported (see CommunityData:Copyrights for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource. Do not submit copyrighted work without permission!

To protect the wiki against automated edit spam, we kindly ask you to solve the following CAPTCHA:

Cancel Editing help (opens in new window)