Week 7

Current Week Objectives: Work with SQLite this week

Current Week Accomplishments/Hours Worked:

Day 31 - 2/20/17 |

This week I will be creating a PowerPoint presentation on SQLite. I learned how SQLite works in an android device. Researched about SQLite before starting the PowerPoint.

Day 32 - 2/21/17 |

Started to plan out all the slides and figure out what content to put on the PowerPoint.

Day 33 - 2/22/17 |

I figured out how to organize the PowerPoint and started adding everything onto the slides. I put some examples I did in linux and showed step by step guide on how to use SQLite.

Day 34 - 2/23/17 |

I wanted to create more content, so I used Python to create SQLite databases. There are many other ways to use SQLite but I chose python because this is what Joe prefers to use.

Day 35 - 2/24/17 |

I finished up the PowerPoint and showed it to my supervisor (Joe Oakes) to see if he wanted me to change anything on the PowerPoint.

Week 7 total = 22 Hours

Next Week Objectives: MySQL

Key Lessons Learned/New Skills Acquired: SQLite database/Python SQLite

Issues and Concerns: I did not have any issues with SQLite.

Week 6

Current Week Objectives: Dive deep into Hadoop and a little bit on SQLite

Current Week Accomplishments/Hours Worked:

Day 26 - 2/13/17 |

I got lectures from different professors to look at. I will be looking over these lectures over the weekend. Lectures include SQL Server and MySQL.

Day 27 - 2/14/17 |

Day 28 - 2/15/17 |

Tried out the MapReduce script on Hadoop. Instead of using Java, I used Python. I used it to sort the data that was all clustered and print out the data after it was reduced. After it is reduced the data is sorted and displayed.

Day 29 - 2/16/17 |

Made adjustments to the PowerPoint requested by Joe Oakes. I added case studies, penn state logo, and python with Hadoop.

Day 30 - 2/17/17 |

Completed Hadoop PowerPoint. I had to make Hadoop work with SQL commands but in order to do that I needed to use a different Hadoop service that is open sourced. I used Apache Hive with Hadoop to make this happen. Apache Hive is able to use their own HQL commands that are similar to SQL commands.

Week 6 total = 23 Hours

Next Week Objectives: SQLite

Key Lessons Learned/New Skills Acquired: After creating a PowerPoint on Hadoop, I have a better understanding of Hadoop.

Issues and Concerns: I had some trouble using MapReduce in Hadoop.

Week 5

Current Week Objectives: Learn and understand MySQL and Relational databases

Current Week Accomplishments/Hours Worked:

Day 21 - 2/6/17 |

I worked on MySQL and how they are connected to RDBMS. I got MySQL running on linux and was able to create databases. Created a database with primary keys and attributes that fit the database and kept practicing MySQL commands.

Day 22 - 2/7/17 |

After I got used to MySQL commands I started to use Oracle. I had to install Oracle on ubuntu and get it up and running. Oracle was a bit harder to install than MySQL. I am going to try to install Oracle after I do some researching.

Day 23 - 2/8/17 |

I had to create a Hadoop Database PowerPoint presentation that describes what Hadoop is and how it is used. I had to research the basics of Hadoop and put everything I learned onto the PowerPoint.

Day 24 - 2/9/17 |

Day 25 - 2/10/17 |

I set up a single node cluster for our localhost on Hadoop. I am still working on the Hadoop PowerPoint.

Week 5 total = 20 Hours

Next Week Objectives: Go further into MySQL

Key Lessons Learned/New Skills Acquired: I learned more about RDBMS this week.

Issues and Concerns: I had a hard time trying to figure out Oracle this week. I am going to have to find some help with this installation process.

Week 4

Current Week Objectives: Work with Cassandra and Hadoop on Linux

Current Week Accomplishments/Hours Worked:

Day 16 - 1/30/17 |

I started this week off by learning about Hadoop. This database is new to me and I have never used it before. I did some research about Hadoop and what it is used for in a database.

Day 17 - 1/31/17 |

A new task came up today with the windows 2012 server. I was able to remove the administrator password by using a recovery disk that was burned onto a usb. We did not know the password for the server before, but now we were able to get it back. We have to configure the servers for Abington Arts Center. We sat down with a group of people and talked about what they wanted on the server. We will be testing this in a Virtual Machine before doing it on the actual server.

Day 18 - 2/1/17 |

I got back to working with Hadoop and installed it on Linux while following a guide. It took awhile for me to get it up and running, but in the end I got the cluster running. I watched some videos on how Hadoop works as a database and how I can use it.

Day 19 - 2/2/17 |

Day 20 - 2/3/17 |

I sat down with Joe and talked about a database called Oracle. Oracle is a must need to know for a DBA. so I need to work on MySQL and Oracle for my next assignment. I learned about functions and classes in MySQL and how they are used. I installed MySQL on Linux today and configured all the settings for the database. I was able to use MySQL commands easily and create a table with data.

Week four total = 23 Hours

Next Week Objectives: Understand the basics of MySQL, SQLite, and Oracle

Key Lessons Learned/New Skills Acquired: I learned how to run Cassandra on a single node cluster. I also learned how to run hadoop on Linux and create a cluster.

Issues and Concerns: I was not able to run Cassandra and Hadoop on my first try. I had to kept running into errors and was not able to start either databases on Linux. I ended up figuring out what the problem was and fixed it so it would run correctly on Linux.