Completed Assignments
The main focus for Module 3 was for us to get introduced to MySQL. We utilized NewBoston tutorials, Ullman's PHP and MySQL textbook, Zend Tutorials, and W3Schools to learn the basics of MySQL. MySQL is a powerful tool for creating databases which organizes data into rows and columns. Think of it like looking at a sports roster. You have the basic columns like players' Name, Position, Age, College, etc. What MySQl allows us to do is use certain syntax and commands to gather information from databases in order to come to some sort of conclusion. Using the sports roster as an example, say we only want to know players whose college is Rutgers University. So you put in the appropriate code and when executed you get all the players whose college is Rutgers. This is a simple example however MySQL offers countless functions and syntax that can do much more to gather information from databases. To get more indepth information for MySQL click on the links above on the various assignments I did to get familiar with MySQL.
