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 == |