Work Samples

Work Samples

Examples of William Davenport's SQL and Programming Work

Thank you for checking out samples of my work. The table below displays downloadable links in yellow for several bash shell scripts I have written for Linux operating systems. The bash shell scripts are written to be portable to other different types of Linux distributions. You can see I have a wide assortment of Linux bash shell scripts below that each do certain things. The "lookup3.sh" bash shell script requires a file entitled "datafile" with no extension. If you use the script, create that file with numbered entries in it for the script to work properly. This website itself is an example of my work in developing websites in a full stack capacity! I designed and coded this entire website myself using HTML 5, CSS, JavaScript and PHP! I also included a link to a Python script "backpackList.py" that I wrote which can build a backpacking list.

The script adds items to the list, removes them and checks to see if an item is on the list. A fun little script to write. Finally, in the brown links below, you will see where you can download an SQL dump script from a class final project database I had to write and create using Microsoft SQL Server. This dump script is my work that I was required to do taking the Relational Database Design and SQL class at Champlain College. The title of this database SQL dump script is "XYZ Trucking" and can be located by searching for it under "Scripting Language" column. I wrote this database using Structured Query Language (SQL), stored proccedures and a trigger for one of the datbase tables. The title of this database in the dump script is "XYZ Trucking" and somewhat simulates what a trucking company database looks like. It also includes sample data in the tables of this database so it can be tested.

Samples of Work
Scripting Lanugage File Download
Python Port Scanning Tool. Able to Conduct Host Discovery Only, Port Scanning, Or Both. Private IPv4 Addresses Only. davenport_port_scanner.py
Linux Bash Shell Script, Archiving into Tarball, Gzipping and Encrypting Client Host Backups on Server. encryptBackups.sh
Linux Bash Shell Script, Ungzipping, Untarring, Decrypting Client Host Backups on Server. decryptUB.sh
Linux Bash Shell Script Archiving Files Changed in Past 24 Hours in Home Directory. archive.sh
Linux Bash Shell Script Checks to see if a File Exists. checkFile.sh
Linux Bash Shell Script Checks to see if the User is in the /etc/passwd File. checking.sh
Linux Bash Shell Script sort file entitled "datafile" by last names, show user contents of data file and tell user number of entries in file. lookup3.sh
Linux Bash Shell Script Counts all the Files in a user's Home Directory which are not Readable. nonReadable.sh
Python Script Builds List for Backpack, Removes Items and Checks for Items. backpackList.py
SQL Dump Script for "XYZ Trucking" Truck Company Database Class Final Project for Microsoft SQL Server. William_Davenport_SQL_Server_Class_Project_Database.sql