Opinion
Posts
Programming - Intro
Programming Intro – How to Find a Coding Job
There are more employers than FANG – Facebook, Apple, Netflix, Google 2.8% Unemployment Rate of Coders in Baltimore area Prepare to have conversations rather than “interviews”. Conversations seek to find if you are a good […]
Programming - Intro
Programming Intro – Best Programming Language
People want to know the “best” programming language, but every language has a purpose and it’s own place. To find YOUR best programming language determine what your own problems in technology are, and talk to […]
Opinion
Opinion
Programming - Intro
Programming Intro – How to Self Study Coding
Everyone should self study to see if you like it. DO NOT sign up for a bootcamp before you have done some coding!!! You are not married to a language. You can learn one, and […]
Opinion
Opinion
Programming - Intro
Programming Intro – Introduction to Programming
What is Programming? Programming and Coding generally mean the same thing Programming is simply telling computers to perform actions Programs can range from a calculator app to a full fledged operating system Why is Programming […]
Opinion
Opinion
MySQL Introduction (NEW)
MySQL – HTML Form Validation with PHP (filter_var)
You can validate that variable values look how they are supposed to by using filter_var in PHP. Filter_var determines if an email address, IP address, Int, Float, etc are formatted how they are supposed to […]
MySQL Introduction (NEW)
MySQL – Sanitize Variables with PHP (filter_var)
Sanitizing Variables prevents users from being able to submit data to a database such as HTML formatting or JavaScript code. filter_var works based off of specific filters that you designate that can be found at: […]
MySQL Introduction (NEW)
MySQL – PHP Prepared Statements
Prepared statements help prevent SQL Injection attacks. Essentially they send a template for your SQL Statement, and then inserts the variables separately. This prevents hackers from escaping out of the original SQL statement and being […]
MySQL Introduction (NEW)
MySQL – INSERT Records with HTML Hyperlinks and PHP($_GET)
Using the GET method you can pull variable values from HTML hyperlinks and process them in a PHP script to Insert records into a MySQL Table. vote.html phpLink.php votes Table
MySQL Introduction (NEW)
MySQL – UPDATE Records with HTML Form and PHP
You can use PHP to Dynamically create an HTML form from a MySQL record and then be able to edit the record. Warning: Your Web Browser may cache form values. Opening a new tab may […]
MySQL Introduction (NEW)
MySQL – SEARCH Form with HTML and PHP
You can create an HTML form that allows you to search records in your MySQL Tables and print the results in a web browser. In these project we use LIKE and wildcards for the query […]
MySQL Introduction (NEW)
MySQL – INSERT Records with HTML Form and PHP
You can easily create an HTML form with PHP to insert records within your MySQL database. Warning – It’s important to create a troubleshooting routine, and verify you have written your code properly. form.html phpTEST.php […]
MySQL Introduction (NEW)
MySQL – Update Records with PHP
Using PHP you can update records in your MySQL tables. phpUpdate.php
MySQL Introduction (NEW)
MySQL – PHP to INSERT Into Table
You can use PHP to INSERT data into MySQL Tables. This data can come from HTML forms, or things such as scripts that parse text documents. phpInsert.php
MySQL Introduction (NEW)
MySQL – PHP Print Records to HTML (mysqli)
You can use PHP to access records in a MySQL database and then print them out in HTML. phpSelect.php phpSelectTable.php
MySQL Introduction (NEW)
MySQL – Connect with PHP (mysqli)
You can use the built in MySQLi Extension with PHP to connect your PHP scripts to a MySQL Database. Environment – LAMP stack on Ubuntu 18.04 Desktop using tasksel gEdit – Preferences -> Display Line […]
MySQL Introduction (NEW)
MySQL – Backup, Restore Copy Tables and Databases
Backing up tables and databases is very useful when you are learning to update records so that you can recover quickly when you do something wrong. create table if not exists newTable like oldTable; – […]
MySQL Introduction (NEW)
MySQL – Stored Functions Introduction
Stored functions allow you to manipulate data stored in tables. Unless specifically coded the data created is “impermanent” which means it only exist while using the function. If you need the results to be used […]
MySQL Introduction (NEW)
MySQL – Stored Procedures Introduction
Stored Procedures allow you to write and call full SQL Statements just like scripts in an operating system. Create Procedure: delimiter $$ or delimiter ; – sets delimiter call procedureName; – calls procedure show procedure […]
MySQL Introduction (NEW)
MySQL – Table Joins Introduction (inner join)
Joining Tables allows you to interact with two tables as if they are one. This means you can simply reference a record from one table in another such as having a PART record reference a […]
MySQL Introduction (NEW)
MySQL – Create, Delete User Accounts and Grant Privileges (create user, drop user, grant, show grants)
MySQL has its own user accounts and security policies. Remember that most times “hackers” are only able to compromise a database using the privileges assigned to the compromised account. CREATE USER ‘user’@’localhost’ IDENTIFIED BY ‘password’; […]
MySQL Introduction (NEW)
MySQL – Update and Delete Records (update, delete)
Updating and Deleting records in a table is very easy. Remember that MySQL does not ask for verification of a command, and so a poorly written statement can be devastating to a database. update users […]
MySQL Introduction (NEW)
MySQL – Add Records and Search Tables (insert, select)
Insert into table(column1, column2) values(‘value1’,’value2’); – Inserts records into Table. TEXT type values need single quotation marks ‘ ‘. Select * from table; – Selects ALL records from table and displays ALL columns Select * […]
MySQL Introduction (NEW)
MySQL – Create, Alter and Delete Tables (Create Table, Alter Table, Drop Table)
Tables are the building blocks of Databases. They store the records for the Database are are easy to create, alter and delete. Use database; – Enter Database Select database(); – Shows what Database you are currently […]
MySQL Introduction (NEW)
MySQL – Create, Delete Database and Show Grants (Create Database, Drop Database, Show Grants)
Creating and Deleting databases on a MySQL server is very easy. Sometimes it can be too easy. show databases; – Shows databases create database databasename; – Creates a database drop database databsename; – Deletes a […]
MySQL Introduction (NEW)
MySQL – Install LAMP Server for MySQL Labs (tasksel)
This class will show you how to build a lab for the further MySQL classes. You will use the tasksel app to install the LAMP Stack (Linux, Apache MySQL, PHP) on Ubuntu Desktop 18.04. Note: […]
MySQL Introduction (NEW)
MySQL – Data Types Introduction
In MySQL, and other databases, you can set what type of data a value in a table can be. Whether it’s text, a number, or even a file. This is used to prevent bad data […]
MySQL Introduction (NEW)
MySQL – Structure Introduction
The structure of a MySQL Backend can be designed however the administrator thinks is logical. There are few hard rules for how the structure has to be designed. Front End/ Back End With modern applications […]
MySQL Introduction (NEW)
MySQL – MySQL Introduction
MySQL is a useful and widely used open source database Basics A Database Software stores data so that it is easily accessible Relational Databases store Like Data in Tables and those Tables are then How […]
Cloud Computing (NEW)
Cloud Computing – Database Introduction
Databases contain the records that are required for most advanced applications to run. Databases themselves only store data, and you need to create a front end and intelligence for users to be able to interact […]
Cloud Computing (NEW)
Cloud Computing – Serverless Architecture (Cloud Functions)
Serverless Architecture allows you to abstract out Compute from your infrastructure and call compute service from Cloud Functions. This means you get the results of a server like encoding video, or computer vision without needing […]
Cloud Computing (NEW)
Cloud Computing – SOA (Service Oriented Architecture)
SOA, Service Oriented Architecture, is the concept of designing infrastructure based on the services that are needed instead of focusing on the servers themselves. Designing with SOA in mind makes it easier to not only […]
Cloud Computing (NEW)
Cloud Computing – Client/ Server Architecture
Client/ Server Architecture is an Infrastructure style where Client Computers receive Services from Servers. Servers are composed of the Physical Machine, the Server Operating System, Services Software and Configurations. Clients are composed of the Physical […]
Cloud Computing (NEW)
Cloud Computing – Virtualization Introduction
In the old days the Operating System was deeply connected to the hardware it ran on and moving the OS to a new machine could be next to impossible. With Virtualization an Operating System becomes […]
Cloud Computing (NEW)
Cloud Computing – Colocation Datacenters
Colocation Datacenters allow you to rent space for your servers to run. You can rent from 1U of space to a dozen 42U racks for your equipment. Colocation facilities allow you to run your equipment […]
Cloud Computing (NEW)
Cloud Computing – MaaS Introduction (Metal as a Service)
MaaS, or Metal As A Service, is the ability to rent bare metal servers from cloud providers. You can have root access to the operating system and run the server anyway you see fit. This […]
Cloud Computing (NEW)
Cloud Computing – IaaS Introduction (Infrastructure as a Service)
IaaS, Infrastructure as a Service, refers to cloud based services that are not full end user functional products of themselves. Google Drive is an SaaS, AWS Glacier is IaaS. IaaS offers core components of your […]
Cloud Computing (NEW)
Cloud Computing – PaaS Introduction (Platform as a Service)
PaaS or Platform as a Service is essentially “web hosting” for your code. Even run a “serverless” enviornment you still need somewhere to run your code from. PaaS gives you a place to run code, […]
Cloud Computing (NEW)
Cloud Computing – SaaS Introduction (Software As A Service)
Interacting with SaaS Direct Interaction – By going to the SaaS website or using their native app you can use their service Client Applications – Third party Native applications that can communicate with the SaaS […]
Cloud Computing (NEW)
Cloud Computing – Public, Private and Hybrid Clouds
Designing Cloud Infrastructure is fundamentally different that standard Client/ Server infrastructure. You think of Services as separate from the Servers, and design hardware so that entire Servers can be destroyed without effecting the Services offered. […]
Cloud Computing (NEW)
Cloud Computing – Load Balancing
Reasons for Load Balancing Fault Tolerance – Load Balancing offers fault tolerance incase a server fails. Server Upgrades – It’s easier to upgrade hardware if you can take entire machines offline without effecting user experience. […]
Cloud Computing (NEW)
Cloud Computing – Server Clusters
Clustering ties multiple servers into a single logical server for users to access. Think of it like RAID, but for the whole server. Uses for Clustering Failover – If a physical server fails services will […]
Cloud Computing (NEW)
Cloud Computing – Abstraction
Abstraction is the concept of dividing specific functions of a server into their own individual systems. Much like subcontracting janitorial, or security services out for a building owner. Virtualization Compute – Provided by hardware with […]
Cloud Computing (NEW)
Cloud Computing – Introduction
Cloud Computing in one form or another is the major architecture for enterprise class infrastructure. Cloud Computing should be looked as a world view more than as a specific technology or product. What is the […]
Linux - Introduction
Linux – Network Configuration (ip, route, dhclient, systemd-resolve, netplan)
Configuring Networking at the command line in Linux can be confusing. It’s important to know that you use many different application to manage networking and these applications may be different based on your distribution or […]
Linux - Introduction
Linux – UFW Firewall Setup (ufw)
UFW is a simple firewall application that is included with Ubuntu nd can be installed on other distributions of Linux. Note: For the demonstrations to work you may need to change settings or hardware configurations […]
Linux - Introduction
Linux – FTP Server Setup (vsftpd)
FTP allows you to upload, download files and perform basic file and directory tasks. FTP is a technology not a single product so there are numerous pieces of server and client software that can be […]
Linux - Introduction
Linux – SSH for Remote Administration
SSH allows you to remotely administer Linux Servers SSH is a Client/ Server System. SSH requires Port 22 to be accessible Change Network setting in VirtualBox to “Bridged Adapter” Install OpenSSH Server on your Linux […]
Linux - Introduction
Linux – Cron Jobs for Scheduled Tasks (crontab)
Cron Jobs are automated tasks that you can create in Linux to do such things as delete cache files or run antivirus scans. You simply set when you want the task to run and then […]
Linux - Introduction
Linux – Tarballs, Archive and Compress Folders (tar)
Tarballs are Compressed Archive Files of Folders that are useful when moving folders and making sure all contents stay intact. In the name tarball “tar” stands for the archiving, and “ball” stands for the compression. […]
Linux - Introduction
Linux – Change Permissions and Ownership for Files and Folders (chmod, chown, members, groups)
The commands chown and chmod allow you to change permissions and ownership of files and folders, but you also need to know the membership of groups to make sure permissions and ownership is appropriate. View […]
Linux - Introduction
Linux – File and Folder Permission Introduction
Linux Permissions are much more simple than what is provided in Windows Active Directory. You have 3 permission types that you can apply to 3 groups. The permissions are Read, Write and Execute which can […]
Linux - Introduction
Linux – Task Manager and Kill Processes (top)
Top is the built in Task Manager for the Linux CLI. It can be a powerful and complex tool, but most people only need it for simple tasks. top – starts top sudo top – […]
Linux - Introduction
Linux – Start, Stop, Restart Services (Systemd, systemctl, service, init.d)
There are 3 ways to manage services on Ubuntu Linux. Systemd is considered the “right” way as of now, but using the service command and init.d scripts still work. When. you make changes to configuration […]
Linux - Introduction
Linux – Make, Rename, Move, Delete Folders (mkdir, mv, cp, rm)
Managing folders is much like managing files in Linux. Just remember to use the -r option (recursive) for copying and deleting. Make Directory mkdir newfolder – Creates a folder called folder Rename Directory mv newfolder […]
Linux - Introduction
Linux – Rename, Move, Copy and Delete Files (mv, cp,rm)
Renaming, moving, copying, and deleting files in Linux command line is easy. Renaming files uses the same command as move. As an administrator if you do not own the files you are interacting with you […]
Linux - Introduction
Linux – Group Managment (addgroup, delgroup, adduser, deluser)
Managing Groups in Linux is relatively simple. It’s important to realize Linux users, groups and permissions are much simpler than in Windows Server. Group Configuration File sudo vim /etc/group – opens Group configuration file in […]
Linux - Introduction
Linux – Add, Delete and Modify Users (adduser, deluser, passwd, chfn)
Managing Users on Linux systems is very easy. Add Users sudo adduser username – adds users Additional profile information is not required, but a comment is a good idea. Delete Users sudo deluser username – […]
Linux - Introduction
Linux – Find Files in Linux (find, whereis)
To find files and configurations in Linux you can use the find and whereis commands. Whereis who’s you the folders where data for applications are stored. Find allows you to search for files and folders […]
Linux - Introduction
Linux – Install Software on Linux Server (Apt-Get)
Installing software on Linux is very easy using the apt-get command. Using sudo apt-get install apache2 your server will download Apache2, and install it without you needing media. Note: Debian distributions of Linux use apt-get […]
Linux - Introduction
Linux – Vim
Vim is a text editor that is included with Ubuntu that allows you to modify configuration files. http://manpages.ubuntu.com/manpages/xenial/man1/vim.1.html To Create a Text File Simply type vim filename Capitalization matters. test.txt, Test.txt, and TEST.TXT are different […]
Linux - Introduction
Linux – sudo Command Intro
In order to do many tasks you have to escalate your privileges using the “sudo” command. This is like UAC in Windows. The idea is that to make major changes to the OS there is […]
Linux - Introduction
Linux – Command Line Navigation
Navigating through the folder structure in Linux is easy if you know a few commands. A major issue for many technicians is that Linux cares about capitalization (FOLDER != folder), and using / with the […]
Linux - Introduction
Linux – Tab Autocomplete, Whatis, Man Pages, –Help
The UX for Linux can cause fits of laughter for all of the wrong reasons. Even the tools that are offered to help users can be frustrating to use and understand. We will go over […]
Linux - Introduction
Linux – Install Ubuntu Desktop in VirtualBox
Installing Ubuntu Desktop in VirtualBox gives techs the ability to learn Linux with a GUI. Hardware Requirements In general I would recommend your host computer has 16GB of RAM and an SSD. 8GB of RAM, […]
Linux - Introduction
Linux – Install Ubuntu Server in VirtualBox
Installing Ubuntu Server into VirtualBox gives you the ability to create a lab environment without needing multiple physical machines. Hardware Requirements In general I would recommend your host computer has 16GB of RAM and an […]
Linux - Introduction
Linux – VirtualBox Overview for Linux Labs
VirtualBox is an Open Source, Free for all use virtual hypervisor that runs on Windows, Mac, Linux, and… Solaris. It is a good tool for using to learn Linux. Download VirtualBox: https://www.virtualbox.org Hardware Requirements You […]
Linux - Introduction
Linux – Shells and Desktop Enviornments
In Linux you can use numerous shells and Desktop Environments in order to interact with your system. Shells and Desktop Environments Shells are the software you use to directly interact with the operating system. Generally […]
Linux - Introduction
Linux – Is Linux Open Source?
Everyone knows that Linux is “Open Source”! But what does that really mean? Open Source means different things to different people, and more importantly there are different licenses that are covered under the Open Source […]
Linux - Introduction
Linux – Best Distribution
Finding the best distribution of Linux for your personal use and for your organization is important. As with much in the tech world you should be thinking more about what questions to answer rather than […]
Linux - Introduction
Linux – Forks, Distributions and Versions
When using Linux it’s important to understand that “Linux” is not a single Operating System. GNU/Linux is built buy using numerous different applications. Over the years technicians have customized the applications and feel that they […]
Linux - Introduction
Linux – Introduction
Understanding Linux is a must in the modern world as a technology professional. Whether you’re building IoT projects, or simply managing websites Linux will many times be your go to operating system of choice. What […]
Arduino
Arduino – Simple Webserver with Ethernet Shield
Using an Ethernet Shield you can run a simple web server from an Arduino. Note: The Micro SD card must be formatted as FAT. Functional Parts in the Project: Arduino Uno – https://store.arduino.cc/usa/arduino-uno-rev3 Arduino Ethernet Shield […]
Arduino
Arduino – PIR Sensor (HC-SR501)
PIR Sensors (Passive Infrared) are the standard sensors used for motion detection. They offer a wide field of view and are easy to configure, but offer only HIGH/LOW output and are not overly accurate. Functional […]
Arduino
Arduino – Continuous Network/ Server Tester with Arduino Uno with WiFi
You can use an Arduino Uno with WiFi to constantly check on the ping response from servers and networked devices. Libraries Required for this Demonstration: Adafruit SSD1306 Adafruit GFX Note: Remember to change the I2C […]
Arduino
Arduino – Ping Servers with Arduino Uno with WiFi
You can ping servers by domain name or IP address and use the response time as a value for a variable. Functional Parts in the Project: Arduino WiFi Rev 2 – https://store.arduino.cc/usa/arduino-uno-wifi-rev2
Arduino
Arduino – Draw Shapes on OLED Screen
You can draw and overlap custom shapes on OLED screens to provide your users with a better User Experience. Libraries Required for this Demonstration: Adafruit SSD1306 Adafruit GFX Note: Remember to change the I2C address […]
Arduino
Arduino – Print Text to OLED Screen
OLED Screens are great ways to display text from your Arduino Projects. You can change Font Sizes, positions and much more. Libraries Required for this Demonstration: Adafruit SSD1306 Adafruit GFX Note: Remember to change the […]
Arduino
Arduino – 128 x 64 OLED Screen Setup/ Demo
OLED Screens allow for complicated displays for Arduino projects. You can change font size, display bitmap images, and even run animations. Libraries Required for this Demonstration: Adafruit SSD1306 Adafruit GFX Note: Remember to change the […]
Arduino
Arduino – Find I2C Addresses (I2C Scanner)
I2C devices allow you to add numerous sensors and displays to your Arduino project using only 2 communication wires. The issue can be that since I2C is an Addressable Communication Protocol that you need to […]
Arduino
Arduino – I2C 20 x 4 LCD Display
I2C Control Boards allow you to connect an LCD Display to your Arduino using only 4 wires. Note: I2C is an Addressable Communication Protocol. 0x27 should be the default address of the display. If this […]
Arduino
Arduino – Send Email Notifications with PHP Mail Function
You can send SMTP (email) notifications using an Arduino Uno with WiFi and a web server with PHP using the mail() function in PHP. You POST data to the web server from the Arduino and […]
Arduino
Arduino – Servo Motors
Servo Motors are able to be set to a specific position. This may be useful for steering vehicles, opening vents, or creating visual notification systems. Note: Cheap servo motors may require that you tweak the […]
Arduino
Arduino – Photoresistor (Light Sensor)
Photoresistors are analog sensors that allow your Arduino to determine the level of light in an environment. Note: You can use either 5 or 3.3 volt power for this project, and you can use different […]
Arduino
Arduino – Soil Moisture Sensor LED Alert with Arduino Uno
Use Soil Moisture sensors and LED’s to alert you to when your plants need to be watered. Functional Parts in the Project: Arduino Uno – https://store.arduino.cc/usa/arduino-uno-rev3 560 Piece Jumper Wire Kit – https://amzn.to/2MsCLjL Soil Moisture Sensor – https://amzn.to/2jEDyjQ […]
Arduino
Arduino – Soil Moisture Sensor
Analog Soil Moisture Sensors allow you to determine how dry soil is and then trigger an event such an LED turning , or a water pump being turned on. Note: Give the sensor a few […]
Arduino
Write POST Data to Server with Arduino Uno with WiFi
This project shows you how to send data to a server with POST from an Arduino Uno with WiFi and to have the server parse the data using a PHP script. Functional Parts in the […]
Arduino
Internet Up/ Down LED Alert with Arduino Uno with WiFi
This project shows you you to create a visual alert to notify you if your internet service has gone down. Functional Parts in the Project: Arduino WiFi Rev 2 – https://store.arduino.cc/usa/arduino-uno-wifi-rev2 Breadboard Kit – https://amzn.to/2Xih5ei 560 Piece […]
Arduino
WiFi Status LED on Arduino Uno with WiFi
This project shows you how to use an LED to notify users when the Arduino Uno with Wifi has connected to the wireless network. Functional Parts in the Project: Arduino WiFi Rev 2 – https://store.arduino.cc/usa/arduino-uno-wifi-rev2 Breadboard […]
Arduino
Manual Fan Control Temperature System with Arduino Uno WiFi
This project shows you how to build a temperature alert system that will allow you to manually trigger a fan to turn on or off from hyper links. NOTE: This project can be a bit […]
Arduino
Arduino Uno WiFI Turn LED On and Off
This project shows you how to turn an LED on and off through a web browser. Functional Parts in the Project: Arduino WiFi Rev 2 – https://store.arduino.cc/usa/arduino-uno-wifi-rev2 Analog Temperature Sensor – https://amzn.to/2Rkkl3k Breadboard Kit – https://amzn.to/2Xih5ei 560 Piece […]
Arduino
Arduino WiFi Temperature Web Page Alert
This project displays the temperature on a web page that auto refreshes. The color of the temperature readout changes based on the temperature. Functional Parts in the Project: Arduino WiFi Rev 2 – https://store.arduino.cc/usa/arduino-uno-wifi-rev2 Analog Temperature […]
Arduino
Arduino Uno Wifi Temperature Sensor
You can use an Arduino Uno WiFi board to create sensors that are web accessible. This project allows you to read the temperature through a web browser. Note: I found that the 5V pin on […]
Arduino
Arduino Uno with WiFi Basic Setup
Arduino Uno WiFi Rev 2 Board allows you to communicate with an Arduino over TCP/IP 4 WiFi networks. Note: Make sure to select the Arduino Uno WiFi Rev2 board under Tools -> Board Arduino WiFi […]