I have been working with a lot of SQL lately. I wouldn't label myself an expert, but I have been finding my way around a lot easier the more I work with it. I have been working a lot with normalizing data and writing queries that reference multiple tables. When referencing multiple tables, it is common to write a join. Here is a very small overview that explains the difference … [Read more...] about What is the difference between LEFT, RIGHT, INNER and OUTER JOIN?
Paste to Terminal in Linux | Paste to cmd.exe Windows
This is not a very long article, but hopefully it rises to the top quick and is helpful. How to Paste to Terminal in Linux Answer: SHIFT+Insert How to Paste to cmd | command in Windows Answer: ALT+SPACE,e,p The windows command really just keystrokes the menu. There is a hotkey fix method that you could check out at lifehacker. That's all I have for this article. Please … [Read more...] about Paste to Terminal in Linux | Paste to cmd.exe Windows
SQL QUERY | Sum Values by Group in Access 2010
I have been working with Access a lot lately. In my last project I was working with a table that contained 1.4 million records with count values by US States. I needed run a graph based on the sum of values for each state. My original table looked like this: Table: States State Value MN 54 MN 62 IL 76 MN 34 CA 48 MN 62 IL 4 And so on... All of the way … [Read more...] about SQL QUERY | Sum Values by Group in Access 2010
Microsoft Word Alternative
If you do not own a license for Microsoft Word, there are many Microsoft Word alternative software packages that exist. Why is this important? You may ask. This is important when considering file formats for your resume. If you are applying or have been applying to jobs online, you may have noticed that some companies will only accept resumes formatted in Microsoft Word file … [Read more...] about Microsoft Word Alternative
How to Install Google Chrome on Fedora 18
Linux is one of my favorite operating systems. I say 'Linux' non specifically because I find all distributions fascinating. I recently installed Fedora 18 on one of my old hard drives and have been playing around. I am still relatively new to Linux and I have been trying to learn it as both a systems admin user as well as someone who would use it day to day (X-Windows … [Read more...] about How to Install Google Chrome on Fedora 18