Justin's Tech Blog

                SQL statements can be defined into three major types: Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL). SQL language is relatively easy to learn and has fewer than 100 statements. The way different types of the SQL statements manipulate or control the data is what sets each apart. The three main categories can be broken down as follows: Data Definition Language – These types of statements create something in the database, like a table, index, or other properties of the actual database. ALTER TABLE – modifies a table’s definitions (ALTER TABLE table_name) DROP TABLE – Deletes a table and all of the data permanently (DROP TABLE table_name;) Be very careful using this and ensure backups are created first. The table will permanently deleted along with all of the data. Data Manipulation Language – These are used to manipulate the data, as the name implie...

  Java Language Java is a programming language, similar to many other programming languages like Python or C++. Java can be used as a tool to create algorithms and data structures (Shaffer 1.1). Algorithms are used to sort, search, or otherwise assist in organizing information. Data structures act like arrays or lists that help to structure the data in the most effective way possible (Lysecky 1.2). Going over the different methods help the programmer understand which are the best methods of each to use. Searching Data Searching data is a way to find information in a list, array, or que. These are simply different types of sets of data. Binary searching is one way to make the computer program more effective at searching. The data list is split into groups, making the groups faster for the computer to search through. Common examples of the binary search are as follows:                             ...

So you want to start programming? Everyone has to start somewhere, and the "Hello World!" is a great way to ensure that you have all of the requirements running on your computer to successfully start programming. Java will need to be installed on your computer before you can start coding. The links to Oracle's Java Development Kit downloads can be found here: https://www.oracle.com/java/technologies/downloads/#jdk20-windows Keep in mind to download the correct file for your Operating System. Download packets are available for Window, Mac, or Linux. Once the Java software kit is installed on your computer, picking an IDE or Integrated Development Environment is the next important step. NetBeans is a great IDE for Java development and is recommended on the Java tutorial pages. NetBeans can be downloaded at this link: https://netbeans.apache.org/download/index.html Java has a great step by step tutorial to complete the "Hello World!" project and verify that you sys...

  OS Theory Concept Map Operating Systems (OS) are built to assist the computer in running all programs as efficiently as possible. The OS is also used to give users the ability to interact with the computer in an easier way. Computers must have an environment to execute programs in the best way possible and also manage all of the resources that are available to the computer in the best possible method. When controlling the programs, it serves to supervise the user programs and manage the operation and control devices (Silberschatz, Galvin, & Gagne 1.1). The OS is an essential requirement for computing in today’s technological world.             The OS uses threading when executing code for a program. Threading “improves application performance through parallelism” and can really assist in the allocation of resources when running a program (TutorialPoint 2023). Program...

  The employee management system project is designed to take user input and store the information as variables for later use. As Miller, Vahid, and Lysecky point out, a variable “is used to remember a value for later use" (2015). Creating the variables of employeeName, employeeSSN, employeePhone, employeeEmail, and employeeSalary were to hold the information to display later in the program. Variable types were string with the exception of the salary input that was set as an integer.             Repetition was very useful in writing this code. Each line was the same just changing the variable name and type in the string. Employee salary was the only line that had an addition with the sep= function to remove the space after the $ sign in the code. This was used for appearance purposes. Setting the variables to strings allowed the user to enter dashes if needed and parenthesis if desired for the phone number. Setting the variabl...

  What is a Variable? Using implicit or explicit variables is an important decision when choosing what language to use when writing a program or starting to code. In simplest terms, a variable is used to remember a value for later use. The way different programming languages use variables is important for programmers to keep in mind when choosing how to code variables. Implicit variables are when the compiler chooses the type of output and explicit variables are when the programmer pre-assigns variables to have a specific output. Examples of Variables Each can be useful depending on the program that is being written. Boudreau points out that implicit variables can often be easier to use in programming and that sometimes the results can be just fine. However, leaving the compiler making that decision making on an assumption can often lead to problems. Explicit assigning of variables gives a more specific output and result and can be much more reliable. Depending on the lan...