SQL

   






    This week I will be sharing the progress I have made in my android development journey. A big part of developing apps is also being able to store data in an organized way. The most popular way big companies do that is by using a database management system as known as DBMS. I used to always hear about SQL and MYSQL and wondered what is the difference? I took a dive into databases and learned that SQL is the language itself and MYSQL is the database management system that actually holds the data. There are many different types of DBMS suck as MYSQL, Oracle, Microsoft SQL, and others. I chose MYSQL because I looked online to different internship opportunities and it looks like the most popular is MYSQL. 

    I started with first having to install the correct programs on my computer. This was a bit difficult on its own since databases are a bit complicated. I first installed MYSQL command line client. This is just a black terminal where you can write your MYSQL code. It is not user friendly unless you are used to coding on terminals but I got familiar with it really fast. The first picture above is the welcome screen for my terminal which I simply input my password. Once you do that the system is ready to start accepting SQL queries. I also decided to install a program called MYSQL workbench. This is a more user friendly program that connects to your MYSQL command line. This is the third image above which just by looking at it you can tell is much more user friendly. It even finishes of queries for you if you are typing SQL keywords. 
    I found a course online that I am going to start following to show me the fundamentals of using MYSQL. I figured out how to connect MYSQL command line and MYSQL workbench together. I created a database that is part of the course called books. I attached a copy of the code I learned in the course to create a database. Once I created the database I created a table called books. This will hold all my columns and rows of book data. It includes the a book id, title, author first name, author last name, released year, quantity in stock and number of pages. I also attached a copy of a screenshot of the code I used to create this table Each different column has a different data type which in this case is either INT or VARCHAR which I will get into more next week. 

Comments

Post a Comment

Popular posts from this blog

Ping Pong in Python

Image
      For this weeks assignment I decided to learn how to make a game using Python. I have been looking up online how to get better at coding and other than doing coding challenges its useful to create real world projects to put everything together. I learned so much just from doing this project that I didn't know from just doing coding challenges. Now this is 147 lines of code so I wont explain every single detail but I did leave comments on all of my code so you can go through it and understand what each block of codes adds to the game.I will also upload a video at the end of this page so you can see the game working in real time.     The first thing I had to do is import a built in library in Python called Turtle. It allows you to draw different objects and animations on to your screen. Once I installed Turtle I created a variable holding the Turtle.Screen function that allows me to create a screen that pops up. Once I did that I changed different attributes of my screen such as
Read more

Sunset Views Coding Challenge

Image
    For this weeks challenge I did a problem called sunset views. The challenge is that you are given a list of integers and also a string that is either west or east. The integers in the array represent the height of buildings. Your challenge is to return to the user a new list of indexes that represent the buildings in the list that were given that can see the sunset. I also included a video of me explaining my solution since this problem is easier to understand if I can show you visually my solution. In this portion I will explain how my actual code works.      To start I initialize a couple variables. First is tallest that represents the tallest building in our list, the tallest index, a new building list which will hold the indexes that can see the the sunset and the second tallest that will be initialized to zero. We will have a first loop that will be used to first find the tallest building in our list. We will use this tallest building in either west or east direction. Once we
Read more

Week 9 Coding Challenges

Image
      For this weeks challenge I did a coding challenge called generate document. The way this works is you are given a function that takes in 2 strings. The first string is called characters and the second is document. Your goal is to see if you can generate a document with the given characters in your string. The only way you can generate a document is if you have the same amount of characters in your character string that will enable you to generate the document. For example if characters = "abcabc" and document = "aabbccc" you can't make the document because you are missing one 'c' in the characters string. If you are able to make the document you will return True to the user else False. This program will also account for spaces to be able to generate the document.      The first thing I thought up when I saw this challenge was to automatically use a for loop. Once I did though I realized I needed a way to keep track how many instances of each charac
Read more