I had a few school projects that required me to deal with databases, including an FAQ forum and a Telegram Chatbot to assist professors in teaching novice programmers.
I also have been wanting to learn SQL (or any of its implementations) for a while as the database aspect in Full-stack website developments.
Initially, I wanted to learn SQLite as the SQL implementation, but I quickly learnt that it is serverless-based, which is not a typical SQL implementation, so instead I decided to learn MySQL as the SQL implementation.
Hence, the creation of this Github repository to document my learning journey of SQL.
Apparently while SQL is a programming language, it is different from other well known programming languages by being a fourth-generation programming language (4GL), while other well known programming languages (Python, Java, JavaScript, C++, etc.) are third-generation programming languages (3GL).
Apart from the 'SQL learn with My SQL (SQL implementation) code archives' folder's sources where I learnt SQL with MySQL (SQL implementation), I also made reference from this popular 'CS50x 2024 - Lecture 7 - SQL' Youtube tutorial video (link: https://www.youtube.com/watch?v=1RCMYG8RUSE&t=2668s (CS50)) to get a general grasp on how SQL, Databases, Database Management Systems (DBMS) and SQL implementations (including MySQL) work, which helped tremondously in my understanding of SQL.
Here is a directory to the explanations of what each folder contains in this SQL learn with MySQL (SQL implementation) learning journey repository:
- SQL learn with My SQL (SQL implementation) code archives)
- 1. 'About_these_MySQL_(SQL_implentation)_tutorials.txt' text file
- 2. MySQL (SQL implementation) basic syntax
- 3. MySQL (SQL implementation) modifying Relational Databases
- 4. MySQL (SQL implementation) integrated with Python (as backend) using PyMySQL (Python library)
- 'MySQL_(SQL_implementation)query_that_creates_the_movies_relational_database_in_a_MySQL(SQL_implementation)_server.sql' MySQL (SQL implementation) file
- 'movies_relational_database_visual_in_Microsoft_Excel.xlsx' Microsoft Excel file
- 'What_is_SQL_and_what_are_databases_and_what_is_MySQL.txt' text file
- 'Setting_up_MySQL_(SQL_implementation)_in_VScode.txt' text file
- 'How_to_set_up_a_Relational_Database_in_an_empty_MySQL_(SQL implementation)server_and_how_to_run_MySQL(SQL_implementation)_queries_in_VScode.txt' text file
This folder contains all the MySQL (SQL implementation) files during my SQL programming language with MySQL (SQL implementation) learning journey segregated into 3 folders, '2. MySQL (SQL implementation) basic syntax', '3. MySQL (SQL implementation) modifying Relational Databases' and '4. MySQL (SQL implementation) integrated with Python (as backend) using PyMySQL (Python library)', organised based on the programming concept of each MySQL (SQL implementation) file. Most of the information from the first and second folders, '2. MySQL (SQL implementation) basic syntax' and '3. MySQL (SQL implementation) modifying Relational Databases', is taken from this Youtube playlist: https://www.youtube.com/playlist?list=PL41lfR-6DnOokmJfmYj2hdVMKVGIcF7__ (Quentin Watt Tutorials) and the information from the third folder is taken from these Youtube videos: https://www.youtube.com/watch?v=3vsC05rxZ8c&list=PLzMcBGfZo4-l5kVSNVKGO60V6RkXAVtp-&index=1 (Tech with Tim) and https://www.youtube.com/watch?v=91iNR0eG8kE&list=PLzMcBGfZo4-l5kVSNVKGO60V6RkXAVtp-&index=2 (Tech with Tim). While in all 3 folders I split the respective lessons myself to the individual folders.
This folder also contains 1 text files, '1. About_these_MySQL_(SQL_implentation)_tutorials.txt' text file, 1 MySQL (SQL implementation) file, 'MySQL_(SQL_implementation)query_that_creates_the_movies_relational_database_in_a_MySQL(SQL_implementation)_server.sql' SQL file, and 1 Microsoft Excel file, 'movies_relational_database_visual_in_Microsoft_Excel.xlsx' Microsoft Excel file.
However, I did have some deviation for these tutorial folders from their sources:
For deviation for the first and second tutorial folders from the Youtube playlist by Quentin Watt Tutorials, titled 'MySQL for Beginners':
- In the Youtube playlist by Quentin Watt Tutorials, titled 'MySQL for Beginners' used MAMP and PHP as the IDE, but I used VScode instead (refer to the file 'Setting_up_MySQL_(SQL_implementation)_in_VScode.txt' for how to set up MySQL with VScode).
- In the Youtube playlist by Quentin Watt Tutorials, titled 'MySQL for Beginners' used a pre-made Relational Database by Quentin, but I used a 'moviesdb' Relational Database provided by codebasics in their Youtube video, titled 'SQL Tutorial for Beginners | MySQL Tutorial' (link: https://youtu.be/Rm0xH2Vpfi0?si=QVr3mUdqUGLHN84R)
For deviation for the third tutorial folder from the Youtube videos by Tech with Tim, titled 'Python MySQL Tutorial - Setup & Basic Queries (w/ MySQL Connector)' and 'Python MySQL Tutorial - Creating Tables, Inserting & Selecting':
- In these Youtube videos by Tech with Tim, titled 'Python MySQL Tutorial - Setup & Basic Queries (w/ MySQL Connector)' and 'Python MySQL Tutorial - Creating Tables, Inserting & Selecting' used the 'mysql.connector' (Python library), but it dosen't work for my computer for some reason so I used the PyMySQL (Python library) instead, which works for my computer and is relatively similar to the 'mysql.connector' (Python library) in functionality and syntax.
How to use the MySQL (SQL implementation) files in this folder?
The MySQL (SQL implementation) files in this folder can only be used after setting up VS code, where instructions can be found from the '3. 'Setting_up_MySQL_(SQL_implementation)_in_VScode.txt' text file)', setting up the 'moviesdb' MySQL (SQL implementation) Relational Database in a MySQL (SQL implementation) server in the 'MySQL WorkBench' MySQL-specific MySQL (SQL implementation) server management tool/IDE/application, and running these MySQL (SQL implementation) files, where instructions can be found from the '4. 'How_to_set_up_a_Relational_Database_in_an_empty_MySQL_(SQL implementation)server_and_how_to_run_MySQL(SQL_implementation)_queries_in_VScode.txt' text file'.
1. 'About_these_MySQL_(SQL_implentation)_tutorials.txt' text file
This file contains information about these MySQL (SQL implementation) files, the sources of the information they are taken from: https://www.youtube.com/playlist?list=PL41lfR-6DnOokmJfmYj2hdVMKVGIcF7__ (Quentin Watt Tutorials), https://www.youtube.com/watch?v=3vsC05rxZ8c&list=PLzMcBGfZo4-l5kVSNVKGO60V6RkXAVtp-&index=1 (Tech with Tim) and
https://www.youtube.com/watch?v=91iNR0eG8kE&list=PLzMcBGfZo4-l5kVSNVKGO60V6RkXAVtp-&index=2 (Tech with Tim) and the deviations of these MySQL (SQL implementation) files from it (see above in the section 'However, I did have some deviation for these tutorial folders from their sources').
2. MySQL (SQL implementation) basic syntax
This folder contains all the MySQL (SQL implementation) files that deals with the basic syntax and structure in the SQL programming language with MySQL (SQL implementation).
3. MySQL (SQL implementation) modifying Relational Databases
This folder contains all the MySQL (SQL implementation) files that deals with modifying Relational Databases (aka SQL Databases), in the SQL programming language with MySQL (SQL implementation).
4. MySQL (SQL implementation) integrated with Python (as backend) using PyMySQL (Python library)
This folder contains all the MySQL (SQL implementation) files that deals with the integration of the SQL programming language with MySQL (SQL implementation) to Python (as backend) using the PyMySQL (Python library).
'MySQL_(SQL_implementation)query_that_creates_the_movies_relational_database_in_a_MySQL(SQL_implementation)_server.sql' MySQL (SQL implementation) file
This file contains the MySQL (SQL implementation) file, that when run, creates the 'moviesdb' Relational Database provided by codebasics in their Youtube video, titled 'SQL Tutorial for Beginners | MySQL Tutorial' (link: https://youtu.be/Rm0xH2Vpfi0?si=QVr3mUdqUGLHN84R) in a MySQL (SQL implementation) server in MySQL Workbench, a MySQL-specific MySQL (SQL implementation) server management tool/IDE/application (see the section below '3. 'Setting_up_MySQL_(SQL_implementation)_in_VScode.txt' text file' for more detail on what MySQL Workbench is).
'movies_relational_database_visual_in_Microsoft_Excel.xlsx' Microsoft Excel file
This file contains the Microsoft Excel file, that illustrates/visualises the 'moviesdb' Relational Database provided by codebasics in their Youtube video, titled 'SQL Tutorial for Beginners | MySQL Tutorial' (link: https://youtu.be/Rm0xH2Vpfi0?si=QVr3mUdqUGLHN84R) in a Microsoft Excel.
Source(s):
- https://www.youtube.com/playlist?list=PL41lfR-6DnOokmJfmYj2hdVMKVGIcF7__ (Youtube playlist by Quentin Watt Tutorials, titled 'MySQL for Beginners')
- https://www.youtube.com/watch?v=3vsC05rxZ8c&list=PLzMcBGfZo4-l5kVSNVKGO60V6RkXAVtp-&index=1 (Youtube video by Tech with Tim, titled: 'Python MySQL Tutorial - Setup & Basic Queries (w/ MySQL Connector)')
- https://www.youtube.com/watch?v=91iNR0eG8kE&list=PLzMcBGfZo4-l5kVSNVKGO60V6RkXAVtp-&index=2 (Youtube video by Tech with Tim, titled: 'Python MySQL Tutorial - Creating Tables, Inserting & Selecting')
This is the file that explains a comprehensive background of the SQL programming language, how it is related to Databases, the types of Databases, their respective Database Management Systems (DBMS), and the different types of SQL implementations (including MySQL (SQL implementation), etc.
Source(s):
- https://www.geeksforgeeks.org/what-is-sql/ (GeekforGeeks) (for what is SQL)
- https://learnsql.com/blog/what-is-sql-query/ (LearnSQL) (for what is a SQL query)
- https://www.geeksforgeeks.org/what-is-database/ (GeekforGeeks) (for what is a Database)
- https://www.geeksforgeeks.org/what-is-database/ (GeekforGeeks) (for the different types of databases)
- https://www.geeksforgeeks.org/introduction-to-nosql/ (GeekforGeeks) (for the definition of NoSQL Database)
- https://blog.leanxcale.com/distributed-database-concepts/newsql-databases/ (Leanxcale) (for the definition of NewSQL Database)
- https://www.geeksforgeeks.org/what-is-mysql/ (GeekforGeeks) (for what is MySQL (SQL implementation))
This file contains instructions on how to set up MySQL (SQL implementation) with VS code, such as how to download MySQL (SQL implementation) from the MySQL (SQL implementation) official website: https://www.mysql.com/downloads/, create a MySQL (SQL implementation) server in MySQL Workbench, a MySQL-specific MySQL (SQL implementation) server management tool/IDE/application, and establish a connection link between the created MySQL (SQL implementation) server in MySQL Workbench to VS code.
Source(s):
- https://www.mysql.com/downloads/ (MySQL)
- https://youtu.be/Rm0xH2Vpfi0?si=QVr3mUdqUGLHN84R (Youtube video by codebasics, titled: 'SQL Tutorial for Beginners | MySQL Tutorial')
- https://guidingcode.com/use-mysql-with-visual-studio-code/ (GuidingCode)
- https://superuser.com/questions/1438960/error-er-supported-auth-mode-client-does-not-support-authentication-protocal-r (superuser discussion on: 'Error: ER_SUPPORTED_AUTH_MODE: Client does not support authentication protocal requested by server consider upgrading MySQL client')
4. 'How_to_set_up_a_Relational_Database_in_an_empty_MySQL_(SQL implementation)server_and_how_to_run_MySQL(SQL_implementation)_queries_in_VScode.txt' text file
This file contains instructions on how to set up the pre-made 'moviesdb' Relational Database provided by codebasics in their Youtube video, titled 'SQL Tutorial for Beginners | MySQL Tutorial' (link: https://youtu.be/Rm0xH2Vpfi0?si=QVr3mUdqUGLHN84R) in a MySQL (SQL implementation) server in MySQL Workbench, a MySQL-specific MySQL (SQL implementation) server management tool/IDE/application, and how to run a MySQL (SQL implementation) file in VS code.
Source(s):
- https://youtu.be/Rm0xH2Vpfi0?si=QVr3mUdqUGLHN84R (Youtube video by codebasics, titled: 'SQL Tutorial for Beginners | MySQL Tutorial')
- https://guidingcode.com/use-mysql-with-visual-studio-code/ (Guidingcode)