Saturday, November 18, 2023

Writing SQL Queries

 Writing SQL Queries is right alongside robot programming using embedded keywords to operate tasks and processes (which can be separately wrote using SQL). If this were your first time using SQL, I have not had any problems finding websites, blogs, with tutorials that help on the subject. Using the terms and expressing the description of when to use them is great. What I have issues with are the syntax errors and the corrective steps to take. 

From my understanding, when there are certain compile errors with SQL - there are certain routes you should take. It labels the errors as needing an aggregate structure or cannot use certain keywords within the structure you wrote. It was because of the mapping that was involved when initially using the tables, how those were put together, and how they are being used in the query. This part is ommitted from many websites as to reason and it doesn't specifically point out what those terms represent within the structure of the syntax in code. Its like having the label 'verb' or 'pronoun' and you are trying to use it like a predicate (state, affirm, or assert something about the subject of a sentence or an argument of a proposition - google search, dictionary result) sentence without the proper words to state your proposition. 

Grammar involved with coding is an embedded knowledge of what those words already mean. That is defining the keyword, why they used it, and its prolonged effective language skills. I had this issue before with C# and the "asynchronized" string commands while pushing forward with syntax structures. 

SQL is great for separating these types of commands with DDL and DML. DDL (Data Definition Language) is used for the data structures. The DML (Data Manipulation Language) is used when updating data within the table structure, like a variable. Geeks for Geeks website explains this better than I can. What is interesting about it, is understanding to separate these keywords as such. Something that I have not come across any other place. It is establishing the Table as a place itself that can be structured while the keywords within can be manipulated. However this is setup, it has to abide by certain guidelines or it fails for keyword placement and its commands of processes. 

This is important because in the terraform styles of coding, it is writing the code without boundaries and creating an open-spaced domain to run freely. Which is defining the cyberspace a little bit differently, and it reacts differently, with the program and network. It appears to be crafted uniquely to provide sitting rooms to observe interactions therafter. 

Photo by Brett Sayles: https://www.pexels.com/photo/multilevel-atrium-of-building-10772746/
                                                                                                                                            Photo by Brett Sayles


The queries for SQL are a great starter langauge to learn, if you plan on becoming an architect for cyberspace, creating your own open source program, or want to kick off your ideas with your own madness and operate bilaterally with other programs. Building a network library of your own is key to any software programmer and for others to understand the madness, or there is no fun in it. The risk is levying the character to be invitational for others to challenge, the idea is to not become an intruder within your own creation! 

It is expected while there is no online governance to control how people are coding. Everyone is experimenting with their structural skills and language choices, because of time. The idea of programming, especially with AI short-handed undeveloped neural networking designs and intelligence as it is in ethical concerns, is all in testing and development at this point in the world. It is not too late to start learning how to program! The world wants to know how you think and they invite your weird way of interpreting algebra because it could mean the next breakthrough! STEM research is a big topic and if your not developing with it, there is literally something wrong with that direction in our Country efforts, at best, our global efforts. They pay big, want results, and need to mandate the educational steam it can produce for the engineering components to lead our world in its perfect forms, apart from the world, and with the world. 

If that doesn't confuse you and encourage you - then you should be relieved to know, that's what its there for. That somebody out there is trying. That within our world, we are coming up with solutions and the more nitpicky we are with what this means and where its derived from (VIEW = perspective of data collections we use to make things simple with what is), the more flexibility we have and concise language for what is properly in its place and appropriate to talk about. Departmental lingo, is more like it. 

__Mischief

Welcome to Gravacity!

Welcome to Gravacity! I have been anticipating my C#-Part 2 NWTC course in the second term of the Fall Semester and within it, a game I must...