Found 8 result(s) for "SQL"! Click on the links for more details
Tour Planner Web App
This app was built using Java Spark and Maven for the back-end and React and npm for the front-end. It was deployed to GitHub for releases, automation, workflows, and version control. It is an app that helps users build tours, whether for work or a vacation. Places can be added using the map or the add places button, both explained in detail in the belowe sections. These will appear as their names and display their coordinates in the list below the map. The app also allows you to optimize the tour so there are no overlapping lines and the trip can be efficient. The first location is the starting city and will also be the ending city so the distances are calculated using modulo so the last leg distance is between the last place and the first one. The tests were created using JUnit for unit testing, Jacoco and Jest for coverage testing, and Postman for integration testing.
Distributed_Analytics_of_US_Residential_Zoning
This is a project that aims to do distributed analytics using clusters using a spatial dataset. Our goal with this project was to analyze the impact of single family rresidential zoning in the US and correlate it to quality of life measures in an effort to dissuade a segreggation of zoning types and promote inclusivity. We hoped to be able to compare the results against data from other countries that have more includive zoning laws, but this was not possible due to constraints on data availability and language barriers. For the distributed component, we are using a cluster of 10 machines that are managed by Yarn. To do the processing of data and calculations, we applied Spark using Java and Gradle. The data itself was stored using HDFS and totaled to ~3.2 GB. For more detail on our motivation, procedures, project structure, and results, please reference the latex file or the presentation in the GitHub repo.
Analysis of the MovieLens Dataset using Apache Spark
This project was an introduction to using Apache Spark to analyze a large file (~800 MB), namely the Movie Lens dataset containing movies, genres, ratings, etc. The files were stored using HDFS and cluster size consisted of 10 machines. There is 1 Java file with 7 Spark jobs which are focused on answering the 7 questions that can be found on GitHub.
Color Coordinate Generator
This is a color coordinate sheet generator that is actively used in Vision Therapy. The goal was to use web development tags and explore accessibility.
Personal Website
The website you are on! This is my personal website I created using Python's Django framework for the back-end and pure Javascript, HTML, and CSS for the front-end with some help from Bootstrap5. Please feel free to explore the website and the various projects, courses, and features. If you would like to contact me, you can do so using the contact tab or my contact information from the sidebar.
CS314: Software Engineering
Introduced team-based development of large, complex systems that supported Scrum-based development while completing a semester-long web development project to prepare for the industry. Topics included clean code, configuration management, continuous integration, testing, requirements, project management and teamwork. The process tools used include Visual Studio Code, IntelliJ IDEA, Linux, Docker, Git, GitHub, Maven, NPM, Webpack, JUnit, Jest, Postman, Zenhub, and Code Climate. The technology tools used include: Linux, Java, JavaScript, ReactJS, Reactstrap, React Leaflet, SQL, MariaDB, Java Spark, Java Concurrency, SLF4J, uLog, JSON, and KML.
CS430: Database Systems
This course was based on database systems and recognizing the elements and components that compromise these systems. Topics included relational models, database design, DDL, DML, querying against the database, applying algebra and calculus principles, defining indexing options and the various data structures utilized, transactional SQL with ACID, and recovery plans. These were all supplemented with labs and projects using a MySQL database.
CIS 455: Advanced Database Management
Learned and utilized advanced data management topics including performance tuning, concurrency control, security, object-oriented databases, and data warehousing. Reviewed physical and logical design, implementation, and administration of databases.