Day 269 of writing every day.
I’m continuing to go through the SQL tutorial today on W3School’s website. I did a little research about them as well and found out they’re not an educational resource of the W3C international standards organization regarding the web (go figure) but they’re still a pretty well accepted resource like a dictionary of sorts for coding in a variety of languages. I’m not using a paid subscription with them and there are ads, so they’re obviously operating with a need to generate profits perhaps to sustain the people behind the organization.
Anyways, SQL is a language used to interact with database management systems (DBMS) and there are a few competing SQL clients such as those by Microsoft and Oracle among others. Databases store information electronically and make these files readily accessible with the right search and/or key. It makes little sense to have isolated sets of data, however, and SQL works with relational databases which contain information that connects one table to another, such as a person’s personal identification information to a specific bank account, gaming account, and so on.
Given that there are different SQL DBMS, some of the syntax differs across them as well due to different mindsets. Fortunately, international standards set by the ISO have made sure that primary controls are the same such as SELECT, UPDATE, INSERT, and DELETE. The purpose of these commands are pretty straightforward and mean exactly what they mean in English.
I’m only writing as a form of output to help me retain the information I’m cramming these days. This isn’t intended to be a comprehensive guide to SQL or anything, but bear with me while I’m going through another small learning phase again.
Thanks for reading!
One Chance Works 